Lottery generator

From: Steven Hook (shook_at_NOTbowens.co.za)
Date: 11/12/04 

Date: Fri, 12 Nov 2004 16:57:14 +0200

Hey,
I have to make a spreadsheet with over 1000000 entries (rows) and only a few
(Maybe 10) columns, I need to generate "semi random" data to fill the
spreadsheet, I thought of doing it manually in M$ Excel but Excel only has
65536 rows :-(.
It's for printing "scratch and win" cards, out our (HP Indigo) printing
press takes the info from the spreadsheet to print each unique card.
I don't know Linux well at all, but I think with a bit of time and effort
I'll be able to write a script to generate the data for the cards.
the data is such that each card hase six ammounts printed on it, if three
ammounts match, the ticket is a winner, so i need to make for instnce 5000
tickets win $300, 2000 win $500, and 1000 win $800, but the un-matching
ammounts must be random, but 300, 500 or 800, each ticket must have a
unique, random "jackpot number" and a sequential ticket number, should I do
this manually in several Excel files, or would it be "relatively" easy to
write a bash script to generate this?

I also need to be able to count and check winning tickets, i.e. a formula
that sais there are # $300 winning tickets so I can "verify" the data.

Thanks
Steven

Relevant Pages

  • Re: Fares changes for 2007
    ... Nor do they accept credit cards, ... ticket, and no exceptions unless the ticket machine was actually not ... I later read somewhere -- and I have no idea if this is accurate or not -- that this Tesco was the only supermarket in Prague. ...
    (uk.transport.london)
  • [Review] Ticket to Ride: the Card Game
    ... I had some trepidation about playing Ticket to Ride: the Card Game ... locomotive and five other Train cards are dealt to each player. ...
    (rec.games.board)
  • Re: Now I cant top my Oyster card
    ... - either at the ticket office or one of the self-service ticket ... VisitBritainDirect only sell "Visitor Oyster cards" (that obviously ... it's possible that the ticket machines won't like ...
    (uk.transport.london)
  • Re: Fares changes for 2007
    ... train ticket on the train, if you have a good reason for it anyway. ... That means that if you're a foreigner and can't use the ticket machines ... you still can't use credit cards. ... We are switching to integrated transport though; ...
    (uk.transport.london)
  • Re: Season ticket from station paid across multiple cards?
    ... accounts has enough money to make the payment in entirity. ... accorss 2 cards? ... The ticket seller didn't express any irritation: ... simply hand me the phone rather than relay security questions to me ...
    (uk.railway)