finally back online... installed a new LinkSYS cablemodem. (old modem failing intermittently)
went from 1.7 megabits/sec up to 6 megabits/sec... blazing speed for under $80 ;-)
I really need to figure the count error out. I have an idea, lose the -1 and just look one row above where the formula is, for example, calculating row 2000 make search range from 3 to 1999 (lose the recalc time of the IF)
I also would like to get rid of the staleness that kicks in, what if the 0-9 count order (important when a tie exists) was variable? maybe 2 sets of numbers could be used
1. count of the announcers for the vertical pair
2. frequency count of each digit 0-9 over the last 100 games in each position
I should figure out how to code this in visual basic so more test parameters could be tweaked faster... add that to long-term goal list
anyway... update plan...
I have to work soon, tonight I will replace the sheets on my homepage with the 4 variants of the SB3, so anyone who wants to see what is on there now, get it before 8pm tonight because they need to go to make room.
pogo/xavier/hareless thanks for working with the sheet so in-depth and finding errors, that's the exact reason I decided to release it before it was finished! It's great that we're making progress... every little bit helps... I think for now, we will concentrate entirely on optimizing the pick3, since the pick4 is an easy update later (the inherent benefit of a positional system)
thanks for the patience while I got my internet probs sorted out... at 6mbps it's ALL good now ;-)