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

MegaMillions Excel Files Hits & Skips Tracking

Topic closed. 2 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
5387 Posts
Offline
Posted: November 17, 2014, 1:57 pm - IP Logged

I created these 2 Excel files (2007, 2010, and 2013 versions) for Skips and Hits for the MegaMillions Game 1/75 1/15

Here are the download links:

https://app.box.com/s/8uxqb9kd0a8ug5ptxoby

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

Instructions:

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

Open the Excel file MegaMillions.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 NumbersSkipHits.xlsm. There are 2 worksheet tabs at the bottom. Once for the white balls 1 through 59 and a second worksheet for just the MegaMillions Bonus Ball Number 1 through 15.

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 October 19, 2013 to a 5/75 1/15 game so you can enter 112 in cell B2 or either the hit & skip worksheets.  The 112 is the number of draws that use the current matrix 5/75 and 1/15.

I also created Excel files for the Powerball game.

http://www.lotterypost.com/thread/282900

Good Luck!!

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

    I created these 2 Excel files (2007, 2010, and 2013 versions) for Skips and Hits for the MegaMillions Game 1/75 1/15

    Here are the download links:

    https://app.box.com/s/8uxqb9kd0a8ug5ptxoby

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

    Instructions:

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

    Open the Excel file MegaMillions.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 NumbersSkipHits.xlsm. There are 2 worksheet tabs at the bottom. Once for the white balls 1 through 59 and a second worksheet for just the MegaMillions Bonus Ball Number 1 through 15.

    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 October 19, 2013 to a 5/75 1/15 game so you can enter 112 in cell B2 or either the hit & skip worksheets.  The 112 is the number of draws that use the current matrix 5/75 and 1/15.

    I also created Excel files for the Powerball game.

    http://www.lotterypost.com/thread/282900

    Good Luck!!

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

    Use the same links in OP.

    I added a 4/5 11 number Wheel $23 @ $1 a ticket.

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

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

      The original list was:

      2,5,9

      11,14,15

      21,23,24,25,28,29

      30,31,35,36,37,39

      41,43,46

      50,55,56,57,58

      60,64,65,66,67

      75

       

      Here are the 11 white ball picks for Tuesday 11/18/2014 draw:

      2,9,11,14,23,25,29,31,35,41,43,50,57

      23 SETS TO PLAY

       
      9, 11, 23, 31, 50       
      9, 11, 25, 35, 43       
      9, 11, 29, 35, 43       
      9, 11, 41, 43, 57       
      9, 23, 25, 43, 57       
      9, 23, 29, 31, 57       
      9, 23, 31, 35, 41       
      9, 25, 31, 43, 57       
      9, 25, 41, 43, 50       
      9, 29, 41, 43, 50       
      9, 35, 43, 50, 57       
      11, 23, 25, 29, 41       
      11, 23, 31, 35, 57       
      11, 23, 31, 43, 50       
      11, 23, 35, 41, 50       
      11, 25, 29, 31, 41       
      11, 25, 29, 50, 57       
      23, 25, 29, 35, 50       
      23, 29, 31, 43, 57       
      23, 31, 35, 41, 43       
      23, 31, 41, 50, 57       
      25, 29, 31, 35, 50       
      25, 29, 35, 41, 57