|Posted: June 27, 2003, 2:06 pm - IP Logged|
Here are some simple Excel formulas to apply up-down, Decade, and Even-Odd transforms to Powerball Data
Formula for Up-Down...
Formula for Decades...
Formula for Even-Odd...
***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...
3. autofill down to 53
4. enter the following in cell AF2...
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.