Thanks, it help me understand it too.
This is my usual steps to get the numbers.
-Add in new draw from "X" tab (bottom of the excel).
-From the "Previous 10" I click on "Sort WB" to get my hot/cold numbers.
-Then go to "Data - 10" tab and hit "Add to history" so later if I want to backtrack I can.
-From that page the hot/cold are available, hot (red) has the highest hit and cold (black, like deep space) has 0.
This is what I do next...
-I mainly disgard the previous 5 numbers from the pool of 37. Down to 32 numbers. Looking at % of repeats from previous draw it's about 50/50. Sometimes I pick 1 number from previous draw to include in the pool, most of the time I disgard the 5 total.
-Then I use the current draw date as eliminator, so today is 8-18-11 I eliminate 08-11-18 from the pool of 32. Down to 29 numbers.
-From there, I look at the SUM of the previous draw. 01-05-10-16-25 = 57, I then take 57 and get single digits from it 05-07 and eliminate that from 29 and we're down to 27 numbers.
--Then I take the last digit of the draw date which I'll be playing, say today the 18th, taking the last digit which is 8 and multiply that by 1,2,3,4,5,6,7,8,9,10 which will give me 8-16-24-32-3-11-19-27-35-6 and I eliminate those from the pool of 27 numbers. Noticed after 8 x 5 the number changed because we're doing lottery math with traditional multiplication. Which means digits after 37 will loop back to 1. So 8 x 5 = 40 - 37 = 3, and so forth till 8 x 10. Then eliminate those 10 digits from the pool of 27 I get a total of 17 numbers to pick from.
From here even with 17 numbers pool all the posible combination are vast, so I use random.org to help me select 5 digits from 17.
Those 5 digits has to fit these criteria:
-Even/Odd: 2E/3O or 3E/2O
-Low/High: 2L/3H or 3L/2H
-Consecutive: Yes/No 3:1
-Sum Range: 70-119
-Sum Match: 0 match from previous 10 sums from the last 10 draws
-Group Numbers: ABC/ABD/ACD/BCD/ABCD [A:01-09 B:10-18 C:19-27 D:28-37]
They are good for one draw only. I usually play $1-2 dollars.
I got the excel setup where I just enter the 5 digits randomly selected from the available pool and it will tell me if I'm in the ballpark (from the criteria mentioned above) or not. If the 5 digits does not fit the criteria, a new random 5 digits will be selected and will continue doing so until the numbers are in the ballpark.
This help speed up the process. I just had that in, will fix some stuff and upload a new version.