Articles
Home
|
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)
For 10 lines:
a1_lotteries_10.zip (11.5 KB)
For 100 lines:
a1_lotteries_100.zip (13 KB)
EuroMillions:
a1_euromillions_10.zip (9 KB)
EuroMillions - 100 lines:
a1_euromillions_100.zip (9.39 KB)
The first two spreadsheets will work with Lotto and Thunderball games.
How to Use
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:
Lotto
Thunderball
Every time a draw is held, you will need to enter the winning numbers on the
right-hand list i.e.:
Lotto
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.
Thunderball
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.
Checking the Results
You can check the Lotto and Thunderball results at The National Lottery
website:
https://www.national-lottery.co.uk/player/p/results.ftl
Comments
| From: |
Chiller |
| Date: |
Monday, June 7, 2010 at 12:09:06 |
| Comments: |
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.
Thanks,
Chiller |
| 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. |
| From: |
Ram |
| Date: |
Friday, January 22, 2010 at 02:20:55 |
| Comments: |
Hi,
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.
Thanks.
Ram. |
| Reply: |
Sorry, but I designed these spreadsheets for the UK
lottery only. |
| From: |
roy roberts |
| Date: |
Saturday, November 14, 2009 at 18:09:12 |
| Comments: |
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? |
| From: |
Bill |
| Date: |
Tuesday, October 6, 2009 at 04:25:56 |
| Comments: |
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'. |
| From: |
Shirley |
| 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. |
| From: |
Janet |
| Date: |
Sunday, September 13, 2009 at 13:57:03 |
| Comments: |
Hi Martin, 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?
thanks
Janet |
| Reply: |
I have added a 100 line version of the EuroMillions spreadsheet
above. |
| From: |
stephen smith |
| 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. |
| From: |
Alex |
| Date: |
Wednesday, January 7, 2009 at 14:28:34 |
| Comments: |
Hi there,
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
Alex |
| Reply: |
I have added a EuroMillions version of the spreadsheet
above. |
| From: |
lee barwise |
| Date: |
Friday, July 18, 2008 at 21:50:38 |
| Comments: |
Martin 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?
thanks
Lee |
| Reply: |
I have added a 10 line version of the spreadsheet
above. |
Martin Allen 1999 - 2010. Last updated
Saturday 24 July 2010 08:13:50 PM +0100.
|
