|Posted: April 17, 2010, 7:24 pm - IP Logged|
Instructions for Excel file Sums.xls
Open the Excel file Sums.xls
Go to the Tab labeled "Sums5"
In this worksheet you can calculate the number of Combinations for each of the Sums
Currently the Sums and Combinations are calculated for the Power Ball 5/59 game. Look at the cell range H3 through L3. You see the numbers 55 in cell H3 and 59 in cell L3.
If you want to calculate the Mega Millions Game just enter the numbers 52 in cell H3, 53 in cell I3, 54 in cell J3, 55 in cell K3, and 56 in cell L3. Next click the Toolbar labeled "Click To Calculate Sums and Combinations".
After a few seconds the Sums and Combinations will be appear in cell columns A and B.
You can also see the Total Combinations in cells O2 and O3.
You can use this worksheet for other Pick 5 lottery games other than the Mega Millions and Powerball games.
Next, click the Tab labled "Sums" and go to cell N7. You will see a list of Steps that you need to perform to generate the Lexicographic Numbers for the Sum(s) you wish to play.
Step 1: Fill in the 5 numbers for the game you want to play in cell range T2 through X2. For example, you would enter 55 through 59 in cell range T2 through X2 if you want to play the Power Ball game. If you wanted to play the Mega Millions game you would enter 52 through 56 in cell range T2 through X2.
So, in this example change the number in cell range T2 through X2 from 55 through 59 to 52 through 56 for the Mega Millions game.
Step 2: In cell R2 enter the Sum you wish to play. In this example change the Sum of 180 currently in cell R2 to 142
Step 3: Click the Toolbar labeled Step 3
This may take a few seconds to calculate depending on the speed of your computer but once completed it will generate all the Mega Millions Combinations that have a Sum Total of 142 (Cell R2)
Step 4: Click the Toolbar labeled Step 4
This will take all the combinations in cell column A and separate them into individual cells in cell range D through H. It will also generate all the Lexicographic numbers for each of the combinations for Sum 142
Step 5: Open the Excel file "MegaPowerSums.xls" Go to the Main Menu at the top and select File > Open and open the Excel file "MegaPowerSums". This was one of the Excel files you originally downloaded from the Zip file into your new folder.
Once you have the Excel file MegaPowerSums,xls file open go back to the Sums.xls file and click the Step 6 Toolbar.
Step 6: Clciking this Toolbar will copy and paste all the Lexicographic Numbers from cell column J in the Sums.xls Excel file to cell P2 in the MegaPowerSums.xls Excel file Tab labeled "ComboGenerator"
Step 7: Save and then Close the Excel file Sums.xls.
Next post MegaPowerSums.xls Excel file.....