Welcome Guest
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
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

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.

Good Luck!!

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

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.

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.

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

 Page 1 of 1