From: Steven Hook (shook_at_NOTbowens.co.za)
Date: Fri, 12 Nov 2004 16:57:14 +0200
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.