|Posted: March 24, 2010, 9:53 pm - IP Logged|
Here is the download link to a zip file that contains 2 Excel files.
Create a new folder and name it whatever you like. e.g. UpDown
Download the zip file from the link above and unzip the 2 Excel files into your new folder
Once both files are unzipped open the Excel file P3StateDraws.xls first. When this Excel file opens go to File > Open > then go to the folder that has the second Excel file UpDown.xls
You should now have 2 Excel files open. Make the UpDown.xls Excel file the "active" file.
Go to the 1st Tab labeled "States"
There are 3 Drawing Types: Midday States, Evening States, and Combined States
Click you stateToolbar. In this example I will click the Pennsylvania Pick 3 Evening Toolbar (PA3E)
Once the calculations are completed go to the next Tab labeled "Calculations"
In cell O16, P16, and Q16 you see the letter "V" for VTRAC in each of these 3 cells. You can change the letter from V (VTRAC) to N (Neighbor) if you like. There are comments in cells O14, P14, and Q14.
1 = digits 0 and 5
2 = digits 1 and 6
3 = digits 2 and 7
4 = digits 3 and 8
5 = digits 4 and 9
1 = digits 0 and 1
2 = digits 2 and 3
3 = digits 4 and 5
4 = digits 6 and 7
5 = digits 8 and 9
Next, in cell range T16 through AQ16 you can change the values of these cells. There are comments in cell range T14 through AQ14.
For example in cell T20, U20, and V20 are the values 4,4,5 because we increased the first position value to +1 (T16) from cell O20 (1st Position) and we kept the Position 2 and Position 3 the same (S)
You can chnage the values in cell range T16 through AQ16 to the following:
S = Same
If you scroll over to cell range BC through BO you will see the "WIN" that occured in each of the columns. The calculations are based on the previous 7 days. So it looks at the current draw and I calculated the last 7 drawings to see if any of the 8 VTRAC combo picks that were generated in cell range columns AT through AY. So you can see in cell BE20 a STRAIGHT "WIN" appeared because the VTRAC 345 was in the list of 8 combinations from 2 drawings ago in cell AU22.
I also added the calculations for Boxed combinations in cell columns DD through DQ. So you can see in cell DF20 a "WIN" appeared because the VTRAC 345 was in the list of 8 combinations from 2 drawings ago in cell CV22.
You can change from VTRAC to Neighbors by changing the "V" in cell range O16 through Q16 to the letter "N" (without quotes) for Neighbors in all 3 cells.
The following Tabs will give you the Hits and Skips for your states drawings. There are also a Tabs for Digit Hit & Skip Chart and also a VTRAC Hit and Skip Chart. The VTRAC Hit and SKIP chart can be used interchangible with the Neighbors if you change over to Neighbors.