I created these 2 Excel files (2007, 2010, and 2013 versions) for Skips and Hits for the PowerBall Game and MegaMillions 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 NumbersSkipHitss.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.
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.