I updated the Excel file so that we can do some backtesting.
Here is the new download link for the Wisconsin Badger 5/31 Lottery Game:
http://www.box.net/shared/my6tz083124p0es57asp
I may do a video on how to use the Excel file.
In the mean time here are a couple instructions:
1. To update the draws go to the tab labeled "Draws" located at the bottom and click the Toolbar labeled "Click To Add New Drawing"
This will insert a new line date on line 20. All you need to do is add the 5 draws from the Wisconsin Badger 5/31 game.
2. To delete the most recent drawing, click the Toolbar labled "Click To Delete Last Drawing". This will delete the most current drawing on line 20.
In the next step go to the 2nd Tab labeled "NumberSkip<snip>s" (located at the bottom).
In cells B1 and B2 I entered the drawing numbers that I want to analyze and calculate the hits & skips for the Number 1 through 31.
So I wanted to backtest and use the drawings from October 15 through October 1 2011.
So cell B1 = 16 and B2 = 30
TIP: To find out what numbers to enter in Cells B1 & B2 just go to the Tab labeled "Draws". Look in colmn "L". Find the number for October 15, 2011 in cell D35. In L35 find the value which is 16.
Look in colmn "L". Find the number for October 1, 2011 in cell D49. In L49 find the value which is 30.
Once you enter 16 in cell B1 and 30 in B2 click the Toolbar labled "Copy #"
Next, click the Tab labled "X Y Axis Chart".
Go to cell range T26 through AD43
In the image above notice how many number did NOT hit (Cell T28 = 0) in cell range T30 through T33. A total of 4 numbers (T26 = 4) Numbers 13,16,23,30 in 15 drawings Ocotber 1 through October 15 2011
Notice the numbers that hit 1 time (cell range U30:U33)
Notice the number that hit 2 times (cell range U30:U35)
As so on....
Also notice the numbers going across on the top line 13, 3, 1, 2, 4, 6
As so on...
In the image above are the next 15 drawings from October 16 through October 30.
Notice the number 3's highlighted in yellow. This represents how many winning numbers came from the # of Hits Chart in the previous image.
For example, drawing from Wednesday October 26, 2011 - 7,15,20,21,26 in cell AC51 the number 3 is highlighted in yellow meaning there were 3 numbers from this drawing that hit from the list of numbers in cell range X30 through X35 which were 4,20,21,24,26,31. So the numbers 20,21,26 hit from this group of 6 numbers not bad.
Notice the drawings from Sunday October 23, 2011, Thursday October 19, 2011, and Wednesday October 19, 2011. each of these hit from the group of numbers in cell range W30 through W39 which were 2,5,7,9,15,17,22,27,28,29 (total 10 numbers)
In the image above if you scroll down to cell range Q62 through AL79 notice we have 2 drawings where we had 2 4of5's using the "Across Numbers". Friday October 28, 2011 and Friday October 21, 2011
For example, The drawing on Friday October 21, 2011 was 1,2,4,6,18. Look at the numbers in cell range T30 through Y30 in the 1st image posted. Numbers across were 13,3,1,2,4,6 (total 6 numbers)
The drawing on Friday October 28, 2011 - 9,11,24,25,30 also had 4 numbers from cell range T33:X33. Numbers 30,25,14,9,24. Total 5 numbers, 4 winners.
This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.