Decided to show how I use the sheet for TX (but you can follow along with any state if you choose)
The sheet that I have in front of me is the evening only (standardized worksheet made by SirMetro & sent to those requesting a sheet)
From 6/1/05 thru 6/22/05
I like to use a wide range for my doubles search so the formula that I am using is =COUNTIF($J$2:$O$500,S2)
**Those with limited excel knowledge (only the numbers in yellow would change)
The countif simply means I'm looking in column J row 2 thru column O row 500 in order to find whatever is listed in cell S2 (which happens to be 66 since I have sorted my doubles already)
Even though 66 has appeared 3 times in the last 19 evening draws
I like to focus on the doubles that have not hit yet (those with 0 occurences)
33*44*88*55 (I would like to add that I also do a search of when these doubles last appeared & the one that's longest out is the one that I am in search of to hit soonest)
For my pairs listed in column V - I like a more narrow range because there are only 19 draws listed here
So the formula that I am using is =COUNTIF($J$2:$O$20,V2)
68 has appeared 3 x's in last 19 eve draws
If I use this number I might want to go with the 1st draw of the month for my 3rd number
686*680*689
There are 15 pairs that have not hit yet (too many to play-so if you like one of these pairs, you should again "go & see what is longest out" then play that pair)
Last is key numbers (column Y is the number) Column Z is how many times the number has occured within your set range
The range set here is for all the draws or simply said everything in columns D, row 2 thru Columns F, row 20
=COUNTIF($D$2:$F$20,Y2)
So the ranking highest to lowest is
6 |
10 |
2 |
8 |
1 |
6 |
0 |
6 |
8 |
6 |
9 |
5 |
7 |
5 |
5 |
5 |
4 |
3 |
3 |
3 |
I personally do not like such a wide range (usually I go back 7 -14 draws) but still I know 3 & 4 have hit the least & 6 has hit the most.
So I may want 36 for my pair.
I may take the top 3 numbers 621 or the top 1 & the least 2 for 634
The last part has to come from the person choosing the number (it's all in how you see the number hitting- a gut thing)
If I were playing this state, I would go with the 3 as my key number(368) but based on the most current history it may be the 6 (6XX) that shows again tonight