|Posted: July 21, 2010, 10:21 am - IP Logged|
Experimenting with this system to see if profitable.
1. Using Pennsylvania Pick 3 Evening Draws only
2. Taking best Plus/Minus totals from 10,000 past draws.
Here are Wednesday Evening's Set-up:
Straight Combinations for Wednesday July 21, 2010 Evening Drawing:
Here is the download link to the zip file that contains 4 Excel Files
1. Draw File
2. Position 1
3. Position 2
4. Position 3
Create a new folder and name it whatever you want.
Download the zip file into your new folder
Unzip the 4 Excel files
Open the Excel file Pick3PlusMinusPAEvening.xls
Go to the top of the Main Menu and select File > Open then open the Position1PAEve.xls file. There 2 additional Excel files for Position 2 and Position 3. I'm analyzing 1 Position at a time, selecting my most likely "Plus/Minus" from cell range E66 through E84 in the "Total Hits". The "Total Hits" are based on the last digit in Postion 1 which was the "4" and the calculations are based on the best "plus/minus" hits for digit "4" in the 1st Position. The Total Hits in cell range E39 through E57 are calculated based on the previous Position 1 draw "4" and the "Movement" which was a +4. 0 (039 previous drawing) to 4 = +4. So the calculations are the top hits for when a 4 was drawn and a + 4 movement. The Total Hits in cell range E12 through E30 are based on the "movements".
You can adjust the draw range that I have currently set at 10000 to whatever you want in cell range C1 and C2.
Once I know the Plus/Minus for each Position I enter them in the Tab labeled "Pick3Wheel" in the Excel file "Pick3PlusMinusPAEvening.xls" in cell range B7 through D9. You can print the form from the Tab labeled "PlusMinusWorkoutPrintSheet" and then enter the "Plus/Minus" figures from your Position 1 through Position 3 analysis then enter them in the Tab labeled "Pick3Wheel" in cell range B7 through D9. All the combinations will appear in cell range K3 through K29.
To enter new drawings, close any Position 1 through Position 3 Excel files that are open, in the Excel file Pick3PlusMinusPAEvening.xls. Go to the 1st Tab labeled "Toolbars" and click the toolbar labeled "Click To Add New Drawing". The macro will add a new line in the Tab labeled "DrawHistory". Just enter the new drawing in cell F1. Go back again to the 1st Tab labeled "Toolbars" and then click the 3rd Toolbar labeled "Click To Copy Drawings". This will copy all the drawings to the Tab labeled "Draws". Now you can do your Positional analaysis (Position 1, Position 2, or Position 3)
Just testing this system to see if profitable.