Welcome Guest
Log In | Register )
You last visited January 21, 2017, 10:35 pm
All times shown are
Eastern Time (GMT-5:00)

The All New Mega Millions & Power Ball Combos Creator

Topic closed. 49 replies. Last post 5 years ago by sammy23.

Page 2 of 4
53
PrintE-mailLink
lakerben's avatar - Lottery-061.jpg
New Mexico
United States
Member #86099
January 29, 2010
11166 Posts
Offline
Posted: April 4, 2012, 7:15 pm - IP Logged

Added NM Roadrunner and Texas 2 Step:

http://www.box.com/s/93eb485bf07ff34a883d

Texas 2 Step Lottery Game  - Instructions

4.  Click the Tab labeled "ComboListing1"

      - Click the Toolbar labeled "Step #1 > Clear Old Sets"

      - 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.

thanks Steve!!!!!!!!!

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5396 Posts
    Offline
    Posted: April 4, 2012, 7:52 pm - IP Logged

    Please add NC Cash5 (5/39) without a bonus ball.

    Thank you in advance. 

    North Carolina Cash 5 added

    http://www.box.com/s/93eb485bf07ff34a883d

      lakerben's avatar - Lottery-061.jpg
      New Mexico
      United States
      Member #86099
      January 29, 2010
      11166 Posts
      Offline
      Posted: April 5, 2012, 3:23 pm - IP Logged

      Nice program.  Getting used to the features.  Does it save more than one game result in a playlist database?  And, can you add the Hot Lotto?  Thanks for all your hard work. 

       

      US Flag

        lakerben's avatar - Lottery-061.jpg
        New Mexico
        United States
        Member #86099
        January 29, 2010
        11166 Posts
        Offline
        Posted: April 5, 2012, 3:25 pm - IP Logged

        Can this be used for p3?

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5396 Posts
          Offline
          Posted: April 5, 2012, 4:30 pm - IP Logged

          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!!

            winsumloosesum's avatar - Lottery-060.jpg
            Pennsylvania
            United States
            Member #2218
            September 1, 2003
            5396 Posts
            Offline
            Posted: April 5, 2012, 6:38 pm - IP Logged
              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5396 Posts
              Offline
              Posted: April 5, 2012, 7:24 pm - IP Logged

              Added Maryland 5/39, NY539, FL536, MO339

              http://www.box.com/s/93eb485bf07ff34a883d

                lakerben's avatar - Lottery-061.jpg
                New Mexico
                United States
                Member #86099
                January 29, 2010
                11166 Posts
                Offline
                Posted: April 5, 2012, 9:17 pm - IP Logged

                Thanks for all your hard work it's appreciated!

                 

                Thumbs Up

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5396 Posts
                  Offline
                  Posted: April 6, 2012, 12:20 pm - IP Logged

                  Added a "QuickPicks" tab. Create your own Random Sets.  Instructions located in the TAB.

                  http://www.box.com/s/93eb485bf07ff34a883d

                    lakerben's avatar - Lottery-061.jpg
                    New Mexico
                    United States
                    Member #86099
                    January 29, 2010
                    11166 Posts
                    Offline
                    Posted: April 6, 2012, 12:27 pm - IP Logged

                    Nice I''ll  give it a try!

                    Party

                      Avatar
                      Greensboro, North Carolina
                      United States
                      Member #1616
                      June 5, 2003
                      1288 Posts
                      Offline
                      Posted: April 7, 2012, 12:45 pm - IP Logged

                      I tried using it for NC539draws and when I press RUN to create the combos I get a runtime error 13. I pressed debug and it came up with this.

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5396 Posts
                        Offline
                        Posted: April 7, 2012, 5:48 pm - IP Logged

                        Reddog,

                        Are there any lexi sets in column A in the Tab labeled "ComboCreator"?

                          Avatar
                          Greensboro, North Carolina
                          United States
                          Member #1616
                          June 5, 2003
                          1288 Posts
                          Offline
                          Posted: April 8, 2012, 11:42 am - IP Logged

                          This is what keeps coming up in Column A no matter what I do.

                            Avatar
                            Greensboro, North Carolina
                            United States
                            Member #1616
                            June 5, 2003
                            1288 Posts
                            Offline
                            Posted: April 8, 2012, 11:45 am - IP Logged

                            nothing in column A just column B.

                              tntea's avatar - Lottery-059.jpg

                              United States
                              Member #5344
                              June 30, 2004
                              23641 Posts
                              Offline
                              Posted: April 8, 2012, 1:05 pm - IP Logged

                              Tennessee 5/35 + PB (1/5) Picks - Wednesday April 4

                              Tenn 535 Picks April 4

                              This looks interesting.  I cannot get it to open on my computer.  What do the LEXI # represent?

                              and the numbers on Line 12...  7,11,19,27,31

                                   OLD/Vtrac   Lottery Bible         Double Warnings      Thumbs Up TN F34/F44