LP member asked to add the Tennessee Cash 5/35 (1/5) game.
Here is the link to the updated file:
Insructions:
1. Update the draw history (if needed) for Tennessee Cash 5/35 (TNCash5PB), MegaMillionsDraws, or PowerBall Draws lottery games. (1st 3 Tabs)
2. Click the Tab labeled "DrawHistory"
- Click cell B8. You will see an arrow to the far right of the cell
- Click the "drop-down" arrow to select your game. (TNCash5PB, MegaMillions, or PowerBall etc.)
- Go to cell N2 and enter the number of tickets you want to play. Example: 20, 30, 40 etc (1,000 is max)
- Click the Toolbar labeled "Click to Clear Lexis" (Cell range N3 through N7)
- Click the Toolbar labeled "Click to Copy Random Lexis" (Cell range P2 through R6)
- Click the Toolbar labeled "Click to Copy LEXIS to ComboCreator Tab" (Cell range V2 through Z6)
3. Click the Tab labeled "ComboCreator" LEXI Set(s) will be listed in cell column "B". No action required in this Tab.
4. Click the Tab labeled "ComboListing1"
- Click the Toolbar labeled "Step #1 > Clear Old Sets"
"5 Number Lotteries"
- Click the Toolbar labeled "Step # 2 >> RUN 5 NUMBER LOTTERIES". Depending on how many tickets you selected in step 2 above, the program will take each Lexi and calculate the corresponding set. This may take a few seconds or minutes depending on how many tickets you entered.
OR
"4 Number Lotteries"
- Click the Toolbar labeled "Step # 2 >> RUN 4 NUMBER LOTTERIES". Depending on how many tickets you selected in step 2 above, the program will take each Lexi and calculate the corresponding set. This may take a few seconds or minutes depending on how many tickets you entered.
5. Click the Tab labeled "ComboListing2"
- You have 2 choices here:
Choice 1 = in cell "i8" you can enter the letter "Y" (YES) if you want Excel to select random Powerball and/or Mega Ball numbers for your tickets starting in column i12.
Choice 2 = in cell "i8" you can enter the letter "N" (NO) if you want leave the Powerball and/or Mega Ball numbers for your tickets starting in column i12 blank where you can select your own PowerBall and /or MegaBall number(s)
- Click the Toolbar labeled "Step #1 Click to Transfer Play Listing to "PlayList" Tab".
6. "PlayList" Tab: All you Tickets will appear startin in cell B12 (going across) i12. Note: if you selected to create you own MegaBall, PowerBall numbers you will need to manually enter them starting in cell i12 going down.
7. "PlayList" Tab: After the drawing is completed you will need to enter the winning numbers in cell range C5 through i5.
- Any number(s) that match the winning numbers entered in cell range C5 through i5 will be highlighted starting in cell range C12 through i12.
- The total number of winning balls will be calculated in cell columns T, U, and V. The grand totals will appear in cell range T1 through V7.
Good Luck!!