|Posted: December 25, 2014, 6:48 pm - IP Logged|
Sensible Shoes Excel files: Excel version 2007, 2010, 2013
Place in new folder and name it whatever you want. Example, Pick3SensibleShoes
There are 3 Excel files in the download folder.
P3StateDraws.xlsm has all the draw histories from each state (includes Canada and Puerto Rico)
Open the P3StateDraws.xlsm file 1st and keep open at all times. You will see a window open to change the date. Just close this window.
Next open the 2nd Excel file SensibleShoesPick3.xlsm
Click the tab at the bottom labeled "Dashboard"
Click cell G4. You should see a small drop-down arrow to the right. Click the arrow and select you state's game. Midday, Evening, Combined etc.
Next click the tab at the bottom labeld DrawHistory. Line 20 will have the most recent drawing from December 24, 2014. Do not add any draws to these sheets. Your state's game name will be in cell A17
In cell column L20 going downward you want to select the number in cell column L to the date you want to analyze. For example, if you want to start with November 30, 2014 for the Virigina Combined draws you would use "68".
Next, click the tab at the bottom labeled "Part1"
Enter the number 68 (from above) and enter it in cell L16
Click cell L9 click the drop-down arrow and select your digit from the drop-down list 0 through 5)
You should have a list of 5 sets of numbers in cell range H1 through H5
Click the tab at the bottom labeled Part2.
You can check for any winners in cell column B for any straights that are highlighted and also column I for any winning boxed sets that are highlighted.