|Posted: December 30, 2014, 2:22 am - IP Logged|
G'day all, I am a Newbie to this forum but not to Lottery. I have for some time been entering the same 1,500 numbers in 250 "boards" every week in the Aus Saturday Lottery. A Board in Aus really just means a single entry, in my case of six numbers. My very uncomplicated system simply means that which ever numbers are drawn, I will have selected.
Our on-line entry form does not allow copying and pasting so every number has to be entered individually. We can enter 50 Boards or entries and save them as one "Favourite" for further use. So in my case I have five Favourites each consisting 50 Boards of 250 numbers.
I originally scrambled the numbers in MS Excel and then laboriously entered them number by number into the on-line forms. How to discover if I had made any mistakes, which of course I had? I could just imagine winning the "Big One" only to discover my entry was wrong. "Goodbye Cruel World". Checking the entries was a bit of a marathon as well.
Solution. I saved each of my five on-line entries in Portable Document Format (.pdf). I converted these files to MS Excel. Then I prepared a spreadsheet with my entries copied and pasted into the first six columns and what they should have been into the next six columns. So columns A-F my entries, columns G-L what they should be. I entered in M2 =IF(a1=g1,"","error"). I then copied the formula right to R. Then copied M1:R1 all the way down to line 50. Found several errors. They have now been corrected.
I also used MS Excel to create a Winnings Checker. Simply enter the winning numbers and the dividends and the winning total appears. These two little apps save hours and hours, as well as mistakes every week and might have me leaving this planet later than I might have. Also very useful for syndicates.
I am 11.74% in front since March 2013 and have not put my hand in my pocket since April 2014 and every week I am in with a chance to win the big one.