Christmas Draw

[s70a9]

With the silly season approaching I am looking for some software to run this year's Christmas Draw. If anyone can help please pm me. Basically looking for something that you enter the number of tickets an individual has bought and it then runs an automated draw.

Or, if any one has any unusual ways of conducting the draw.

Thanks

[splitbrain]

A sinclair spectrum should do the trick..

10 X=0
20 X = RND (0-however many tickets are sold)
30 Goto list (display winner)
40 goto 10

[grey_not_green]

check your PMs, but it may be a long shot .

[s70a9]

Keh

Sorry I don’t get this. I was looking for something that could be used on excel or access. However if you wish to explain, then any help at all would be appreciated.

IT literate, but basics only.

[MostlyModerate]

glad I kept them

If you want to try Split's solution but haven't got a Spectrum, you could borrow my VIC-20 - or if you are very very good, my Commodore64

[newt]

I seem to remember someone at Bruggen trying a random number generator for the Christmas draw. It worked fine on the trial but when they ran it for the actual draw it came up with the same numbers!! Not so random after all!

Might I suggest a large barrel full of tickets and a pretty lady to do the draw!! Who knows, you might get lucky twice!!!

[Spurlash2]

http://www.ablebits.com/excel-random...dins/index.php
Try that, should do the job.
S2

[airborne_artist]

Here's an even easier solution.

Ticket price £5.00 - all payments in cash. Write your name on the fiver before you put it in the container.

Afore-mentioned long-legged lovely draws out fiver, reads out name of ticket holder.

[Spurlash2]

...or B, also try this in Excel.

If you have a list of numbers and you want to select one at random follow these simple steps;

Enter a list of numbers in column A
Now enter the formula below in the cell you want the random number returned.
=INDEX($A:$A,RANDBETWEEN(1,COUNTA($A:$A)),1)

This will pick a number at random from your list in column A. It will also be dynamic in that when/if you add/remove numbers from the list they will automatically be included/excluded.

S2

[s70a9]

I have looked at the random functions of Excel and downloaded the random generator, but what I am trying to do is display a name to make it easier on the night.

Ideally what I would like to do is have a list/number of how many tickets a person has bought. This would then be placed in a spreadsheet with all other ticket buyers, a calculation would then display the name of the person who wins each "draw", the draw would occur for the number of prizes.

Otherwise I will go old school with tickets in a barrel.

[Spurlash2]

Put the persons name in a column for the number of tickets they have bought.
Use the formula in post #9. Press F9 to refresh the calc and get another name.
ie:
bloggs
bloggs
bloggs
white
white
white
Alternatively, use the barrel (for the tickets, that is

[splitbrain]

Actually, in spite of my earlier reply, I'd go for the traditional method.

A computerised system is all well and good but many people are suspicious about the visibility and accounatbility of the software, (and the geekiness of someone who tries to use one for such a purpose ) and you're bound to have someone who'll point out that a computer is not a true random number generator and never can be.

Plus, if the technology lets you down (chances = fair to middling) you look like a right trumpet on the big night!

Tickets, big barrel, girly to pull them out*.

(*And the tickets too)

[s70a9]

Result! Thanks.

As an add on, what prizes to the Ppruners think draw the most interest/buying of tickets.

Mess membership approx 100 so a Porsche would be out

[vecvechookattack]

A shed full of beer always does the trick....

[Touchin' Down]

This has all the hallmarks of a Channel 4 phone in scam!!

[detgnome]

The shed full of beer was done several years ago at Shawbury. Well actually it was a Wendy House full of beer, but lets not split hairs here...

[BEagle]

"As an add on, what prizes to the Ppruners think draw the most interest/buying of tickets."

To quote Blackadder IV:-

"Well, one or two things do suggest themselves. But you'd probably think them........unhygienic!"

[teeteringhead]

As the yoof of today's messes have all the mod cons/boys toys they want, you need to think out of the box.

Best one I remember (can't think from where) was a year of a reserved parking slot outside the front of the Mess. It was good to see "Fg Off Bloggs" written on a blue sign next to OC 123 Sqn and OC Trivia Wg .....

.....or a day's slightly dodgy "Extreme Activity". Last year someone bought the senior daughter a day out which involved rolling down a hill in a water-filled sphere...... my how we laughed at her shrieks of terror....

[airborne_artist]

As the yoof of today's messes have all the mod cons/boys toys they want, you need to think out of the box.

And how they laughed when as a spotty Midshipman of 19 I won an electric blanket in the Culdrose Christmas Draw of 1979. Luckily the Wren officer who had been sent out to do the prize shopping had bought it from Boots and kept the receipt, so I was able to exchange it for a year's supply of Brut

[BEagle]

And how they laughed at Wattisham when I won a set of Carmen rollers.....

Which went straight back into the draw!