If you play the UK Lottery on a regular basis (with the same numbers each time) or if you have a subscription, you might find the following spreadsheet useful:
a1_lotteries.zip (12.1 KB)
a1_lotteries_10.zip (11.5 KB)
a1_lotteries_100.zip (13 KB)
a1_euromillions_10.zip (9 KB)
a1_euromillions_100.zip (9.39 KB)
The first two spreadsheets will work with Lotto and Thunderball games. You must enable macros in order for these to work.
Firstly you need to enter the numbers you play with on the left-hand side. You can add up to 4 lines for each game (unless you are using the 10 or 100 line version of the spreadsheet), the below examples use 2:
Every time a draw is held, you will need to enter the winning numbers on the right-hand list i.e.:
The green column is for the Bonus ball. If you want to, you can enter the Jackpot and whether their was a rollover for that week i.e. 0 for no rollover, 1 for rollover, 2 for double-rollover, etc.
The pink column is for the Thunderball.
The number of matches will automatically appear in the A, B, C and D columns, which correspond with the numbers you have in the 'My Numbers' section. If you have won, the cell will become green, as shown above.
You can check the Lotto and Thunderball results at The National Lottery website:
|Date:||Sunday, July 10, 2011 at 08:00:52|
why do you not say how much is paid to the lottery
what happens to all the money put on this week if the prize money does not go up.
Who gets all the interest on the money not claimed
|Date:||Wednesday, May 18, 2011 at 01:24:25|
|Comments:||an excellent spreadsheet! New to macros, how would i alter your macro to highlight having two main numbers in open office?|
|Date:||Tuesday, March 1, 2011 at 00:43:45|
Hi, Have downloaded your Euro Million 100 Spreadsheet, but how do you know
if you have won or not? Put in my numbers then put in the same numbers in
the winning numbers but nothing happens, what should happen to know that
you have won?
|Reply:||You must enable macros for these spreadsheets to work. As the above screenshots show, winning draws should be automatically highlighted in green.|
|Date:||Monday, June 7, 2010 at 12:09:06|
Do you know a fast way of inputting the previous draw numbers? I am
wanting to use your spreadsheet to pick out a set of numbers which have
never had a big win / only a few £10 wins.
I have a file with EVERY single draw to date listed.
|Reply:||Ideally if you can open your file in Excel, copy and paste (as values) the results into one of the Lotto spreadsheets (above). You will then need a way of activating the macro for each line to show the results. This can be done by pressing F2 on one of the winning number cells (or bonus ball) for each line or a quicker way would be to create a macro to do this for you.|
|Date:||Friday, January 22, 2010 at 02:20:55|
I do see that there are 6 columns, but my lotto has
only 5 numbers with a max of 39.
Please let me know if i can use it.
|Reply:||Sorry, but I designed these spreadsheets for the UK lottery only.|
|Date:||Saturday, November 14, 2009 at 18:09:12|
Load of crap ... these sheets are only for recording the winning numbers and prizes , and do not show if you have won or not .... Do just the same on a piece of paper.... ROY
|Reply:||The winning numbers show up as highlighted in green. Maybe there is a bug in one of the spreadsheets. Which one did you try? Also have you enabled macros?|
|Date:||Tuesday, October 6, 2009 at 04:25:56|
Very useful tool. However, I have to re-enter the winning numbers, everytime I change my played numbers
|Reply:||If you enter new numbers under 'My Numbers', the results for previous draws will not change. Future results will be against the numbers currently in 'My Numbers'.|
|Date:||Sunday, October 4, 2009 at 13:13:44|
|Comments:||Brilliant, I have been using a lottery programme which I bought in 1994 it is no longer working as I run a syndicate of 25. Have put your spreadsheet into mine which keeps a note of payments and winnings, also so much easier now everything is in one place. Thanks very much.|
|Date:||Sunday, September 13, 2009 at 13:57:03|
I have found the 100 line lottery spreadsheet to be very useful..is it possible to have a 100 line version for the Euromillions as well?
|Reply:||I have added a 100 line version of the EuroMillions spreadsheet above.|
|Date:||Friday, May 29, 2009 at 12:38:24|
|Comments:||is it possible to ammend the sheet for many lines.. i have a syndicate that varies from 25 to 35|
|Reply:||I have added a 100 line version of the spreadsheet above.|
|Date:||Wednesday, January 7, 2009 at 14:28:34|
I've downloaded your lottery spreadsheet and it is very helpful indeed, I have been trying to do something like this without sucess for some weeks now. I'd like to know if you have done one for the euro lottery? If not is there any chance you could email me the vba code for the macro to accomodate the euro lottery and 10 play lines.
Thanks in advance
|Reply:||I have added a EuroMillions version of the spreadsheet above.|
|Date:||Friday, July 18, 2008 at 21:50:38|
Your lottery checking spreadsheet is a very useful tool, the only problem is that can it be expanded so that more lines can be used instead of just 4? I have 9 lines and would like to continue using it but i am unable to add more lines?
|Reply:||I have added a 10 line version of the spreadsheet above.|