- Audio: M-Audio Producer USB
- Music: (mostly) Royalty Free
- Video: Canon Powershot SX150 (same camera for photography)
- Images: from the blog or from raffle entries.
The responses were all put on Google Sheets, Google's spreadsheet program. From here I made sure each entry and his or her additional entries qualified. On a separate spreadsheet, I added each redditor's entry as many times as he or she qualified in one column. For example, if /u/ForExample submitted a photo of her workspace, she got ForExample entered into two cells, representing two entries into the raffle.
This is where it gets a little crazy. Before using a random number generator, I decided to further randomize the drawing by shuffling the names. I achieved this through some features on Google Sheets I learned from my Dad (through Microsoft Excel).
|Figure 1: An example of what the function "RANDBETWEEN" might look like.|
In a separate column, I typed in "=RANDBETWEEN(1,xx)" and dragged this function from the first name to the last. I copied the randomly generated numbers and pasted "values only" (found in "Paste Special" menu when right clicking).
|Figure 2: Where to find "Paste values only," converting RANDBETWEEN to solid numbers|
With these random numbers, I selected the column and sorted A through Z, sorting the random numbers 1-xx. Though the numbers are sorted, the names are now randomized.
|Figure 3: Highlighted to show how sorting the numbers will shuffle the names.|
From here, using RANDOM.ORG's random number generator, I produce the winning number and look for the name on the corresponding row number, revealing the 10k Giveaway winner - watch the video to see who won!