Win D's "If You Know 1 Number"
Excel file download (zip) file:
https://copy.com/O9VrvfOCJF3guBnn
The download link above contains 2 Excel files
P3StateDraws.xlsm
Pick3WinDOnNumberSystem
Instructions:
Place both Excel files into 1 folder. You can also place them in the Pick3 Tool Shed with the other Excel file from previous post(s)
Open the Excel file P3StateDraws.xlsm. This Excel file contains all the Pick 3 draws for all states including the Canadian Draws. Midday, Evening, and Combined. When the Excel file opens you should enable macros. Also, you will see a window open to change the date. Just close this window.
Next, go to the Main Menu at the top and click File >Open and browse to the folder where you saved the Excel files. Open the 2nd Excel file "Pick3WinDOneNUmberSystem.xlsm" file. It may take a few seconds for all the calculations to finish.
There are tabs at the bottom. Click the tab labeled "AllPositionsDigit<snip>sSkipsStats". (See below)
This worksheet calculates all the Pick 3 drawings and displays the current skips in all 3 positions. Notice that the Tennessee Midday has 2 digits with a skip of 10 or more wich are digits 3(15) and 5(13).
In column "U" indicates how many digits in all 3 positions have a skip greater than or equal to 10 skips.
Next, click the 1st tab at the bottom labeled "States".
Click cell J25 and from the drop-down arrow to the right I selected Tennessee_Midday from the list. See below.
Next, click the tab at the bottom labeled OneNumberFilter. See below.
In column B I'm filtering only digits 3 & 5 for the Tennessee Midday drawing.
I column C I selected zero (0) which indicates any box 6-way set that has not hit in the last 120 drawings.
You can change the value in cell i1 from 120 to any value you wish. Example, 100 past draws, 50 past draws, etc.
Cell D1 indicates the total number of 6-way box sets remaining after filtering. In this example 29 total sets remain.
In cell column A list all the -6-way box sets that have not hit in the last 120 drawings.
This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.