Main Area and Open Discussion > General Software Discussion

raffle/random choice software

<< < (3/3)

kunkel321:
I think this would be fairly easy to setup in a spreadsheet like Excel.

EDIT:  Okay, here's a starting point, from Google Sheets
https://docs.google.com/spreadsheets/d/1cFvJgqHsA6cbn-BT0yBBdznUDxpKnlEvVl-yUCGc7Q0/edit?usp=sharing

It's a "dumb" random, with no seed.  And unfortunately it is possible to get duplicates.  Just keep refreshing if that happens.
Paste your list of entrants in one Tab, then enter the number of awards to be given in the other Tab, and copy the list. 

There are no protections, so don't delete/cut the forumulas!   :P

app103:
Aryq's suggestion of random.org is a good one if you are simply trying to choose m winners from a group of n entrants.

There are a few specialized cases where you may need to look deeper:

1. If you want to select winners not purely randomly, but with some weighted probabilities -- for example if you wanted the chance that an entrant to win to be based on how many years they have been in operation, etc. [doesn't sound like you need this].
2. If you needed to be able to *prove* to some third party rigorously that you only ran the random selection once and these are the independently verified results. [doesn't sound like you need this].
3. If you were going to be running multiple giveaways over time and wanted to make it less likely that people would win twice in a row, etc. [doesn't sound like you need this].
-mouser (June 09, 2015, 08:32 AM)
--- End quote ---


Mouser wrote an app that I know takes care of 1 and 3, which he used to select the winners in DC software giveaways of the past, but he has never made this app publicly available.

Perhaps with some urging, we can convince him to release it?  ;)

Navigation

[0] Message Index

[*] Previous page