|Posted: December 11, 2005, 11:35 pm - IP Logged|
right now I am getting some ideas for the MASSIVE backtesting sheet that will be required. Also,using conditional formatting and a function called LARGE to show the top 2 numbers to play.
works like this
=LARGE((D1:K1),1) 'this returns the same as MAX in a range (Largest Number)
=LARGE((D1:K1),2) 'this returns the NEXT largest number in the range
so putting formula 1 in M1 and formula 2 in N1, then creating a conditional format on the entire value array D1:Kwhatever... Spotting the top 2 is not only easier, but automatically updated... so far the only thing required to do manually is update the next draw.
all named ranges expand automatically, all arrays update during the recalc.
even if the system doesn't survive backtesting, I think it will make a good reference sheet to see how all of these formulas can be used together.
Playing more than one ticket per game is betting against yourself.