|Posted: January 30, 2005, 10:38 am - IP Logged|
Back to the excel sheet ;-)
I first must learn the system, but I have already made some progress in automation on sheet 2 of the original excel workbook. Right now it will...
A. let you enter the numbers into the sheet for your state
B. separate them into 3 new columns, e.g. you enter into column C 714, then column D will change to 7, E to 1 and F to 4... this step is key to automatic recalculation... Since it was set up using 2 months of draws, I left that the same.
C. it now automatically calculates the front and back pair sums using BUG's conversion system, I adapted them into excel using the following....
D. it automatically counts the front/back sum and front/back differences, so when you change the input numbers, it automatically adjusts.
E. it uses a rudimentary formula to determine extreme HOT and extreme DUE (MAX and MIN respectively) and alerts you to it... that was done with this formula...
I need to understand where the rest of the numbers come from before I can go further... on sheet 2 is a section in gray with a note that says "need one of these as a back pair"... whare do these numbers come from? why are they needed from the back pair and where in the rest of the information were they calculated from?
I'm not half bad with excel, I just don't follow the system 100% yet... but progress has indeed been made ;-)
Playing more than one ticket per game is betting against yourself.