Welcome Guest
You last visited June 24, 2017, 6:13 am
All times shown are
Eastern Time (GMT-5:00)

# Excel Formulas for PB, and some Q's

Topic closed. 3 replies. Last post 14 years ago by CASH Only.

 Page 1 of 1
Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 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...
=IF(C2<C3,"U",IF(C2=C3,"x","D"))

=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...
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.

United States
Member #379
June 5, 2002
11296 Posts
Offline
 Posted: June 27, 2003, 2:09 pm - IP Logged
H:

I suppose it could never work for Super-6...

Pennsylvania
United States
Member #1340
April 6, 2003
2450 Posts
Offline
 Posted: June 27, 2003, 2:15 pm - IP Logged

Don't know... I haven't really even played the lottery on any regular basis until PA got in on Powerball.

United States
Member #379
June 5, 2002
11296 Posts
Offline
 Posted: June 27, 2003, 2:29 pm - IP Logged
H:

I was being sarcastic about Stupid-6.

 Page 1 of 1