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")
***NOTE, Replace E O D U with 1 0 1 0 to be able to use further analysis
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...
another question, is there an easy way to leave a formula open-ended? such as a range to include the latest drawing? I have just been changing and re auto-filling the number count range.
ie... $C$2:$H$76 needs to be $C$2:$H$77 after saturday's drawing.
