Welcome Guest
Log In | Register )
You last visited December 5, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Excel Formulas for PB, and some Q's

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

Page 1 of 1
PrintE-mailLink
hypersoniq's avatar - 8ball
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"))

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.


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

      hypersoniq's avatar - 8ball
      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.