Welcome Guest
Log In | Register )
You last visited January 19, 2017, 6:21 pm
All times shown are
Eastern Time (GMT-5:00)

PowerBall Excel Files - Hit & Skips Tracking

Topic closed. 3 replies. Last post 2 years ago by winsumloosesum.

Page 1 of 1
52
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
Posted: November 16, 2014, 8:11 pm - IP Logged

I created these 2 Excel files (2007, 2010, and 2013 versions) for Skips and Hits for the PowerBall Game

Here are the download links:

https://app.box.com/s/x3pqvdl0riv3e2wy7vfk

https://app.box.com/s/c033vybz7toq25wr5y7c

Instructions:

Save both Excel files to a new folder. You can name the folder anything you want.

Open the Excel file PowerBall.xlsm. You can add a new game by just clicking the Add New Draw Toolbar. Add new drawing in cell E20 through J20. All draws will appear on line 20. Date is automatically updated.

Open the 2nd Excel file NumbersSkip<snip>s.xlsm. There are 2 worksheet tabs at the bottom. Once for the white balls 1 through 59 and a second worksheet for just the PowerBall number 1 through 35.

The Hits and Skips are calculated using all the draw history so you can adjust the number of past draws by entering the draw in cell

The Matrix changed after January 15, 2012 to a 5/59 1/35 game so you can enter 296 in cell B2 or either the worksheets.

This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

    Tialuvslotto's avatar - Jailin
    Texas
    United States
    Member #150797
    December 31, 2013
    822 Posts
    Offline
    Posted: November 17, 2014, 8:29 am - IP Logged

    I created these 2 Excel files (2007, 2010, and 2013 versions) for Skips and Hits for the PowerBall Game

    Here are the download links:

    https://app.box.com/s/x3pqvdl0riv3e2wy7vfk

    https://app.box.com/s/c033vybz7toq25wr5y7c

    Instructions:

    Save both Excel files to a new folder. You can name the folder anything you want.

    Open the Excel file PowerBall.xlsm. You can add a new game by just clicking the Add New Draw Toolbar. Add new drawing in cell E20 through J20. All draws will appear on line 20. Date is automatically updated.

    Open the 2nd Excel file NumbersSkip<snip>s.xlsm. There are 2 worksheet tabs at the bottom. Once for the white balls 1 through 59 and a second worksheet for just the PowerBall number 1 through 35.

    The Hits and Skips are calculated using all the draw history so you can adjust the number of past draws by entering the draw in cell

    The Matrix changed after January 15, 2012 to a 5/59 1/35 game so you can enter 296 in cell B2 or either the worksheets.

    This post has been automatically changed by the Lottery Post computer system to remove inappropriate content and/or spam.

    AWESOME! Star

    What a treasure you are for the LP Community, Winsum! Thanks for all you do.

    "There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

    ~Robert A. Heinlein

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5968 Posts
      Offline
      Posted: November 17, 2014, 8:44 am - IP Logged

      AWESOME! Star

      What a treasure you are for the LP Community, Winsum! Thanks for all you do.

      I agree. I was thinking about creating a Powerball wb. You saved me some work, many thanks.

        winsumloosesum's avatar - Lottery-060.jpg
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5396 Posts
        Offline
        Posted: November 17, 2014, 5:35 pm - IP Logged

        Updated the 2 Excel files and uploaded to box at 5:20 pm Monday evening.

        Use the same links in OP.

        I added a 3/4 11 number 10 Sets Wheel $20 @ $2 a ticket.

        The Bonus Ball you will need to add to your tickets.