|Posted: April 28, 2010, 8:41 am - IP Logged|
A member requested a copy of the "90 Degress" Excel file posted back in 2008.
Here is a download link to the Missouri Pick 3 (Combined Draws) if anyone is interested.
You will need to change the dates & drawings for your state in the "Draws" Tab.
Here is some additional information:
To add/delete drawings go to the 1st Tab labeled Toolbars and click either of the 2 Toolbars (Add New Draw or Delete Last Draw)
Most of the times you will want to ADD New Drawing
Once you click the Add New Draw it will take you to the next Tab labeled "Draws". Just enter the new Pick 3 draw in cell C1.
Next, I created a HIT & SKIP Tab "90 Degress Hit & Skip Chart". There is a "Straight" Hit & Skip Chart and a "Boxed" Hit & Skip Chart.
In column "B" you see "Day 1 through 7" for both the Straight & Boxed charts. The Day represents how many days back when a Straight or Boxed HIT. For example in cell "B15" you see that Day 3 hat a total of 4 HITS (based on 366 Past Draws (Cell F3) and it has a current Skip of 52 in cell F15. You can see the other 3 skips in cells H15, I15, and J15.
The same idea for the "Boxed" Hit & Skip Chart. In cell B1 for Day 1 which is the previous drawing you see it is has a total hits of 21 in cell D28 which is also highlighted in Yellow because it has the highest total for all 7 days. The current skip is 7 in cell F28. And the other skips are in cells H28, I28, J28, etc. etc.
If you look at Day 2 in the boxed chart in cell B29 you see a skip of 2 in cell F29. So this means that a boxed hit occured 2 days ago. If you click the Tab labeled "Draws" and scroll over to cell range AT2 through AZ2 you will see the letter "B" in cell AU2 (2 days). If you count 2 cells down and look at cell range AB4 through AJ4 (Boxed Combinations) you will see the combination 056 in cell AD4 which is a "boxed" hit from the drawing 065 on Midday April 27, 2010.
The Hit & Skip Chart might help you decide what the best "days back" are the best to play or even looking at the "Hits & Skips". It would seem that playing Straights is not a good idea since it only had a total of 15 hits in the last 365 draws. The best seems to be playing "Boxed" combinations and picking the best Day Back and looking at the "Skips" chart.