Anyone is interested I uploaded 2 Excel files:
https://app.box.com/s/l4xomm10nmw9mf5tscoa
Create a new folder and name it whatever you like e.g. Pick3IGamblePairs
Download the 2 Excel files from the link above into your new folder created above
1. P3StateDrawsLS.xlsm (Excel versions 2007 & 2010)
2. PairsIGamble.xlsm
Instructions:
1. Open the Excel file P3StateDrawsLS.xlsm 1st. You will see a pop up window to change the date. Just close this window.
2. Once the P3StateDrawsLS.xlsm file opens you will need to go to your Main Menu and select File > Open and browse to the folder where you downloaded the 2 Excel files and locate the 2nd Excel file "PairsIGamble.xlsm"
In this example, at the bottom of the Excel file "PairsIGamble.xlsm" click the tab labeled "CalendarCombined"
Scroll over to column "S"
In cell S2 you should see the abbreviation for New Jersey combined drawings NJ3C
In cell B4 I clicked inside the cell and selected from the drop-down menu "FrontPair". Here we are calculating how many hits in the last 730 drawings for the New Jersey Midday & Evening draws there were for the Pairs 00 through 99.
In cell S11 you shoould see the number 14 and to the left the Pair 07. The 14 indicates that in the last 730 Midday & Evening draws for New Jersey the Front Pair 07 hit 14 times highlighted in yelow.
If you scroll down cell range S4 through S103 you will see the values highlighted in yellow. These are the top 5 Front pairs that have hit in the last 730 draws (2 years)
Cell range S10 through S109 indicate the 5 top hits. In cell S111 through S115 are the Front Pairs 07,91,85,22,23.
Front Pair hit 14 times (cell S105), front pair 91 hit 14 times (cell S106), etc.
In cell S117 if you click this cell you should see a drop-down arrow to the right. You can select 5 Front Pairs in from cell range S111 through S115. In this example I selected the Front Pair 07
In cell S118 you should see the value 2. This indicates how many times a Pair hit after the 07 was drawn in the last 730 draws.
If you scroll down to cells S1645 and S1649 you should see the value 2 for both. In cells D1645 and D1649 we have the Front Pairs 57 and 61. So the 2 indicates that both the front pairs 57 and 61 hit 2 times after the 07 front pair was drawn.
You can go to cell B4 and click this cell and from the drop-down arrow to the right select either "BackPair" or "SidePair"
There are 2 additional Tabs at the bottom "CalendarMidday" and "CalendarEvening" if you want to find the caluslations for just the Midday draws or Evening draws.