PowerBall Excel Files - Hit & Skips TrackingPrev TopicNext Topic

• winsumloosesum

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Nov 16, 2014, 8:11 pm

  ▲▼

  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

  

  Texas
  United States
  Member #150,790
  December 31, 2013
  824 Posts
  Offline
  Nov 17, 2014, 8:29 am

  ▲▼
  In response to winsumloosesum

  Quote: Originally posted by winsumloosesum on Nov 16, 2014

  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!

  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

  

  COLUMBUS,GA.
  United States
  Member #4,924
  June 3, 2004
  6,719 Posts
  Offline
  Nov 17, 2014, 8:44 am

  ▲▼
  In response to Tialuvslotto

  Quote: Originally posted by Tialuvslotto on Nov 17, 2014

  AWESOME!

  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

  

  Philadelpia/Pennsylvania
  United States
  Member #2,218
  September 1, 2003
  6,802 Posts
  Offline
  Nov 17, 2014, 5:35 pm

  ▲▼

  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.