hypersoniq
Member
Here are some simple Excel formulas to apply up-down, Decade, and Even-Odd transforms to Powerball Data
Formula for Up-Down...
=IF(C2<C3,"U",IF(C2=C3,"x","D"))
Formula for Decades
=IF(C2>49,6,IF(C2>39,5,IF(C2>29,4,IF(C2>19,3,IF(C2>9,2,1)))))
Formula for Even-Odd
=IF((C2/2)-(INT(C2*0.5))=0,"E","O")
Counting times a number was drawn...
1. number 1 to 53 down a column, using the first cell for a label (for example column AD)
2. enter this into cell AE2...
=COUNTIF($C$2:$H$76,AD2)
3. autofill down to 53
4. enter the following in cell AF2...
=COUNTIF(C$2:C$76,$AD2)
5. autofill across to column AK
6. autofill columns AF thru AJ down to 53
7. autofill column AK down to 42
this gives times a number was drawn and breaks it down into what position (SORTED)
my sheet is set up with the following columns...
A = Draw Date
B = Draw Number
C = White Ball 1 (SORTED order)
D = White Ball 2
E = White Ball 3
F = White Ball 4
G = White Ball 5
H = PowerBall (Red)
also: sum, sum+powerball, day of draw (W or S), powerplay, jackpot value and # of winners in each prize tier
The formulas are designed to exploit autofill, only need to type once
I have a question... what are they good for? How can you use the results to help in making your pick?
Is it just meant as a guide or is there some way to apply this with precision? I'm relatively new to all of this...
Formula for Up-Down...
=IF(C2<C3,"U",IF(C2=C3,"x","D"))
Formula for Decades
=IF(C2>49,6,IF(C2>39,5,IF(C2>29,4,IF(C2>19,3,IF(C2>9,2,1)))))
Formula for Even-Odd
=IF((C2/2)-(INT(C2*0.5))=0,"E","O")
Counting times a number was drawn...
1. number 1 to 53 down a column, using the first cell for a label (for example column AD)
2. enter this into cell AE2...
=COUNTIF($C$2:$H$76,AD2)
3. autofill down to 53
4. enter the following in cell AF2...
=COUNTIF(C$2:C$76,$AD2)
5. autofill across to column AK
6. autofill columns AF thru AJ down to 53
7. autofill column AK down to 42
this gives times a number was drawn and breaks it down into what position (SORTED)
my sheet is set up with the following columns...
A = Draw Date
B = Draw Number
C = White Ball 1 (SORTED order)
D = White Ball 2
E = White Ball 3
F = White Ball 4
G = White Ball 5
H = PowerBall (Red)
also: sum, sum+powerball, day of draw (W or S), powerplay, jackpot value and # of winners in each prize tier
The formulas are designed to exploit autofill, only need to type once
I have a question... what are they good for? How can you use the results to help in making your pick?
Is it just meant as a guide or is there some way to apply this with precision? I'm relatively new to all of this...