[nfbcs] Drawings

[Nicole Torcolini]

I would just throw my own together using Java or some other language that
has a random number generator.

-----Original Message-----
From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Joshua Hori via
nfbcs
Sent: Wednesday, July 13, 2016 5:41 PM
To: NFB in Computer Science Mailing List
Cc: Joshua Hori; Steve Jacobson
Subject: Re: [nfbcs] Drawings

Hello Aaron, 

What about creating a google form for users to fill out with the information
directed to google sheets? Users could then use their own devices to enter
the contest. You could then create a script to be used in google sheets to
take everything from column A (list of names), copy them, and paste them in
random order into column B (or other column of choice), picking the top pick
as the winner. 

In cell "B1", enter the following:
=sort(A1:A24;arrayFormula(randbetween(sign(row(A1:A24));1000000));true)

Adjust the A1:A24 to the amount of cells actually filled out. So if there
are 50 entries, you may want to adjust to A1:A50 (make note that there's 2
entries you'll need to edit), making adjustments for new entries as needed.
Then navigate to column B, or your column pasted with the code, for your
winner! If you're collecting other data (emails and other contact info),
just use the first empty column to paste that code into and extract the
winner, then search for the name in the first column to match with contact
details listed in other columns. 

Best, 

Joshua Hori

-----Original Message-----
From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Steve Jacobson
via nfbcs
Sent: Wednesday, July 13, 2016 2:23 PM
To: 'NFB in Computer Science Mailing List' <nfbcs at nfbnet.org>
Cc: Steve Jacobson <steve.jacobson at visi.com>
Subject: Re: [nfbcs] Drawings

Aaron,

If a row is created for each ticket purchased, that really should take care
of multiple ticket purchases by increasing the chance.  If duplicate rows
cause a problem, one could number each of the duplicate rows to make them
unique.

Best regards,

Steve Jacobson


-----Original Message-----
From: nfbcs [mailto:nfbcs-bounces at nfbnet.org] On Behalf Of Aaron Cannon via
nfbcs
Sent: Wednesday, July 13, 2016 3:53 PM
To: NFB in Computer Science Mailing List <nfbcs at nfbnet.org>
Cc: Aaron Cannon <cannona at fireantproductions.com>
Subject: Re: [nfbcs] Drawings

This can easily be done with Excel.

http://www.lifehacker.com.au/2012/03/how-to-sort-a-list-randomly-in-excel/

After the steps in that article, the person in the top row is the winner.

If you need more winners, how you get them will depend on whether you want
to exclude people who have already won, or not. Also, this technique will
result in each person having an equal chance of winning. This is great for
door prizes, but not so great for raffles, where the more tickets a person
buys, the more likely they are to win.
  

--
This message was sent from a mobile device


> On Jul 13, 2016, at 14:32, Steve & Shannon Cook via nfbcs
<nfbcs at nfbnet.org> wrote:
> 
> Hi All,
> 
> Could someone recommend a way to put a list of names in a software 
> program and have the computer draw the winner?  I am looking in to a 
> new way for door prizes for our state convention in October.  Using 
> JAWS 17 and
Windows
> 10.  Thanks in advance!
> 
> Steve Cook
> Steve on Dice World: Steve6009
> Steve on Twitter: @SteveCook67
> 
> 
> _______________________________________________
> nfbcs mailing list
> nfbcs at nfbnet.org
> http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
> To unsubscribe, change your list options or get your account info for
nfbcs:
>
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/cannona%40fireantproducti
ons.com

_______________________________________________
nfbcs mailing list
nfbcs at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for nfbcs:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/steve.jacobson%40visi.com



_______________________________________________
nfbcs mailing list
nfbcs at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for nfbcs:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/jhori%40ucdavis.edu

_______________________________________________
nfbcs mailing list
nfbcs at nfbnet.org
http://nfbnet.org/mailman/listinfo/nfbcs_nfbnet.org
To unsubscribe, change your list options or get your account info for nfbcs:
http://nfbnet.org/mailman/options/nfbcs_nfbnet.org/ntorcolini%40wavecable.co
m