hypersoniq
Member
I have all of the data for the PA daily number (pick 3) in an excel spreadsheet... what I would like to do is find a formula or macro to count skips per number by position.
I have it laid out as such...
Column = Contents
A = Draw Number (sequential from 1 to 9,169)
B = Date of Drawing
C = the drawn combo (e.g. 251)
D = FIRST number drawn (2 from C)
E = SECOND number drawn (5 from C)
F = THIRD numberdrawn (1 from C)
What I would like to do is have the following skip table result...
pos 1 pos 2 pos 3
days days days
Number out out out
1 46 12 3
2 2 13 1
3 38 14 6
4 4 3 12
5 5 24 26
6 0 1 7
7 20 0 10
8 1 4 8
9 34 10 0
0 27 6 13
From this, I will take the top 3 by position, from the example above...
1 5 5 <longest out
3 3 0 <2nd longest out
9 2 4 <3rd longest out
As a formula or macro, I need something flexible enough to alter the ranges so I can perform back testing of this method of picking numbers (test for straight and box hits)... I already have formulas to test for straights and boxes, I need the formula (or at least an idea of how to go about solving this problem) to avoid the need to cover over 9,000 draws by hand.
Thanks in advance for any help ;-)
I have it laid out as such...
Column = Contents
A = Draw Number (sequential from 1 to 9,169)
B = Date of Drawing
C = the drawn combo (e.g. 251)
D = FIRST number drawn (2 from C)
E = SECOND number drawn (5 from C)
F = THIRD numberdrawn (1 from C)
What I would like to do is have the following skip table result...
pos 1 pos 2 pos 3
days days days
Number out out out
1 46 12 3
2 2 13 1
3 38 14 6
4 4 3 12
5 5 24 26
6 0 1 7
7 20 0 10
8 1 4 8
9 34 10 0
0 27 6 13
From this, I will take the top 3 by position, from the example above...
1 5 5 <longest out
3 3 0 <2nd longest out
9 2 4 <3rd longest out
As a formula or macro, I need something flexible enough to alter the ranges so I can perform back testing of this method of picking numbers (test for straight and box hits)... I already have formulas to test for straights and boxes, I need the formula (or at least an idea of how to go about solving this problem) to avoid the need to cover over 9,000 draws by hand.
Thanks in advance for any help ;-)