As always, the easiest way to start out atheory is against pick 3 data.

I had previously worked with the "1-1-1" system. I had performed operations in excel that subtracted 10 and used absolute values of negative numbers... too complex!

I have redone a "proof of concept" worksheet and have decided to adopt a rolling lookup table. there ARE no negative numbers OR numbers over 9.

problem is it has to be manually changed, there are 1,000 possibilities! I got thru several dozen so far and realize this will have to be automated.

so since nothing is subtracted and just rolls forward, the name "positive change" comes into play (well, the positive part...)

The change part is the new "all positive" delta. using a rolling lookup instead of formulas that manipulate numbers has one major benefit... lightning fast re-calculations!

I need to figure out how to do this in VB! Guess I should search for character replacement algorithms...

watch the pa pick3 tonight... if 6-2-8 is the evening pick3 number, then this is another lucky coincidental system!