This Pairs program will take each state's Pick 3 game (Midday - Combined - Evening) and list any Pair that is currently 30 draws or more out (skips).
The Pairs are are reduced by taking the boxed version in all 3 positions (Front - Back - Side Pairs).
The 45 Boxed Pairs are "No-Match" Pairs and do not include doubles.
Here is the link to the zip file:
http://www.badongo.com/file/10368757
1. Create a new folder and name it whatever you like.
2. Unzip the 4 Excel files into your new folder you just created.
3. Open the Excel file "P3StateDraws.xls" file. The Excel file contains all the States Draws. (Midday - Evening - Combined)
4. The P3StateDraws Excel file is open. Click File>Open> Open your new folder and open the Excel file "PairsALLMiddayV2". Both the P3StateDraws.xls and PairsAllMiddayV2.xls must be opened.
5. In the PairsALLMiddayV2.xls Excel file look at the 3 Tabs at the bottom. "States" - "Playsheet" - "Midday"
5. Click the Tab labeled "States". This worksheet contains all the Toolbars for all the Midday States. You can click the top Toolbar labeled "Click All Midday States". This will analyze all the Midday Pick 3 States.
6. All Midday states will be analyzed and any Boxed Pairs in all 3 Positions (Front- Back - Side pairs) that are currently out 30 or more draws.
7. In the "Midday" Tab scroll over to cell range AU:AV. Click the Toolbar labeled "Click To Sort State Pairs". This will sort all the Pairs in cell columns C through AS in "ascending order"
8. In the "Midday" Tab notice in cell range AU4:AV48 are all the 45 Pairs (NO Doubles)
9. In the "Midday" Tab click the Toolbar labeled "Click To Sort Pairs". This will sort the 45 pairs according to how many hits in cell columns C through AS.
10. In the "Midday" Tab you can also click the Toolbar labeled "Click To Copy Pairs". This will copy the information in cell range AX4:AY48. You can copy this and watch the Midday draws for the next drawing(s).
11. In the "Midday" Tab. In cell A1 ther is a Toolbar labeled "Click To Clear". Clicking this Toolbar will clear all the Pairs in cell range C through AS.
12. The Tab labeled Midday is for calculating only.
You can follow the same routine as above by opening the PairsALLCombinedV2.xls file or the PairsALLEvening.xls file. Just remember to always keep open the "P3StateDraws.xls" file or you will receive an error.
You can also look at your own state and follow any pair (boxed) out 30 draws or more.
Good Luck!!