Google Answers Logo
View Question
Q: how to conduct an online lucky draw ( No Answer,   1 Comment )
Subject: how to conduct an online lucky draw
Category: Business and Money > Advertising and Marketing
Asked by: dclxvi-ga
List Price: $10.00
Posted: 04 Oct 2006 09:54 PDT
Expires: 03 Nov 2006 08:54 PST
Question ID: 770763
I run an online business, and would like to conduct a simple lucky
draw for my existing customers. THe mechanics goes like this :
purchase a certain amount to qualify for the draw. ie. $150 entitles
to one chance. $300 entitles 2 chances.

The data of customers and purchase amount are available in the MS
access database linked to my website.

1) How do i electronically select a random winner? any free software?
or MS excel has a function *sorry i'm not so sure*
2) How do I ensure transparency in the draw?

I run a homebased biz but would like to make it look as professional as it is. 

Please suggest any mechanisms of lucky draw contests if any.

Request for Question Clarification by denco-ga on 04 Oct 2006 10:12 PDT
Howdy dclxvi-ga,

It might help researchers to know the country in which the business is based.
There is no answer at this time.

Subject: Re: how to conduct an online lucky draw
From: inventorbob-ga on 11 Oct 2006 09:32 PDT
In MS Excel, type in:

B1: Name
C1: Amount
D1: Chances
E1: Chance
F1: Total
G1: =SUM(D:D)

A2: 0 (zero)
D2: =ROUND(C2/150,0)  note: the 150 is the amount that earns 1 chance
E2: =D2/$G$1
F2: winning
G2: =RAND()

A3: =A2+E2
F3: winner

Now, paste in all of the Name and Amount information starting in B2.

Copy the formulas from D2, E2, and A3 down to the bottom of each
column to where your list ends.

Press F9 to make the draw.

The winner name shows up in G3.

Here is an example of what mine looks like:

		Name	Amount	Chances	Chance		Total	11
0		joe	150	1	0.090909091	winning	0.318761422
0.090909091	henry	300	2	0.181818182	winner	eliza
0.272727273	eliza	450	3	0.272727273		
0.545454545	charlie	275	2	0.181818182		
0.727272727	peter	300	2	0.181818182		
0.909090909	frank	200	1	0.090909091		

but remember, colums A, D, and E are calculated numbers.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy