For the last month I have been developing an Excel Worksheet that creates picks based on any calculation involving a previous number or sequence.
The first step was to download all of the picks for the California Daily 3 and calculate all of the mirror numbers for each sequence. The numbers are listed by game number (descending from Last draw) as follows: N1 N2 N3 M1 M2 M3
The next step was to create a formula set for each Number and Mirror number. For example: using M2 from a previous draw + or – any number calculates a new number. The INDIRECT function allows this formula to change the Number or Mirror Number or +/- number. More complicated formulas use multiple previous numbers or mirror numbers in multiple games (added, subtracted or multiplied) to create a pick For example Take M2 from the previous game and add it to N1 from the picks 3 games back.
The indirect function allows the rapid calculation of the formula for any Number or Mirror and for any previous game. The initial setup uses scenarios for each Number and Mirror Number (6).
The calculated Numbers and their corresponding Mirror numbers are lined up on the same row as the game being analyzed and are generated for the next game. Using the COUNTIF function in the formula for Conditional Formatting allows the numbers to be highlighted if they are in the numbers selected for that row (game) including colors that indicate the position (N1, N2, or N3).
For each Game all possible sequences from the selected numbers are calculated starting with the Straight Sequence (N1-N2-N3) and including the other 5 Box sequences.
Adjacent to each set of formula scenarios, number sequences are calculated in the same way. The Worksheet also allows for the Primary Calculation or the Mirror Calculation to be turned on or off to reduce the number of projected numbers from 12 to 6.
Conditional Formatting highlights a Straight of Box if it hits.
The % of hits for each formula scenario can be calculated for any number of the previous games. Using a number of previous games (I use 5 of 10). Each of the 6 Senario formulas can be changed by selecting different Numbers or Mirrors, Games Back, Numbers to +/-/*. Formulas can also include exponent values to apply to the Numbers or results in or of the scenario formula. I use a formula that uses only the last digit in the calculated Scenario Values.
The results of the scenarios can then be viewed to see how many times they have produced a winner for each game. I manipulate each Scenario formula until I get at least 4 winners from the previous 5 games. The funny thing is that for the games prior to the last 5 there are almost no winners. I am working on an adjustment factor to the Scenarios needed to produce more winners for each series of 5 games prior to the last 5.
I am wondering if anyone might be interested or has tried this approach. I would appreciate any comments or questions out there. I would like to invite anyone to suggest Scenario formulas for analysis.