Welcome Guest
Log In | Register )
You last visited January 20, 2017, 12:40 am
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 3 of 4
53
PrintE-mailLink
winsumloosesum's avatar - Lottery-060.jpg
Pennsylvania
United States
Member #2218
September 1, 2003
5396 Posts
Offline
Posted: April 8, 2012, 1:20 pm - IP Logged

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

Lexi or CSN (Combination Sequence Number)

Example: 5/39 Lottery Game

Lexi #:

000001 = 1,2,3,4,5

----------------------------------

575757 = 35,36,37,38,39

The formulas take the previous draws Lexi number and the current draws Lexi number then randomly selects another Lexi # between the 2.

Take the Tennesee 5/39 Lottery game for example.

4/6/12 Draw: 3-8-14-24-34 Lexi = 0104320

4/4/12 Draw: 6-24-25-26-35 Lexi = 025391

Program randomly selects a Lexi Number between 0104320 & 025391. 

You can select as many sets as you want.  I currently have it set to 20 sets meaning there are 20 randomly selected lexi numbers from each of the past 20 drawings.

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

      Reddog,

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

      Correction column B.

      Not sure why your getting Name# in column B.  Looks as if the macro is copying the formulas which it should not.

      Try downloading the most current Excel file from previous post.

      What version of Excel are you using?

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

        Correction column B.

        Not sure why your getting Name# in column B.  Looks as if the macro is copying the formulas which it should not.

        Try downloading the most current Excel file from previous post.

        What version of Excel are you using?

        I am using Excel 2003.  Apparently the version I have is too old. When I click the #NAME? it gives a message saying unrecognized formula.

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

          I am using Excel 2003.  Apparently the version I have is too old. When I click the #NAME? it gives a message saying unrecognized formula.

          There should NOT be any formulas in column B.

          Combo Craetor Tips

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

            This is what mine looks like. Look at Column T. See the #NAME?  going down from 1-20 ? When I clicked click to Random Lexis it caused Column AB to do it also.

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

              So then when I press copy to combo creator Tab and I get a runtime error and debug comes up with this.

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

                So then when I press copy to combo creator Tab and I get a runtime error and debug comes up with this.

                Looks like you changed the name of the Excel file to MegaPowerCombosProgram.xls to MegaPowerCombosProgram 3.xls. Change it back to MegaPowerCombosProgram.xls and it should work.

                  Viper5963's avatar - ange 1180262130-t.jpg
                  New Member
                  Americus GA
                  United States
                  Member #29977
                  January 9, 2006
                  18 Posts
                  Offline
                  Posted: April 9, 2012, 9:33 pm - IP Logged

                  Please add GA Fantasy 5. Numbers 1-39. thanks

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

                    Please add GA Fantasy 5. Numbers 1-39. thanks

                    GA539 Added

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

                      Avatar
                      New Member
                      Istanbul
                      Turkey
                      Member #15973
                      May 24, 2005
                      4 Posts
                      Offline
                      Posted: April 10, 2012, 1:11 am - IP Logged

                      Can you please add the following, too?

                      Sans Topu (TR)
                      Draw534
                      Power Ball114

                      Thx.

                        bootleg233's avatar - Lottery-034.jpg
                        Tn
                        United States
                        Member #54963
                        September 4, 2007
                        1166 Posts
                        Offline
                        Posted: April 10, 2012, 5:08 am - IP Logged

                        Lexi or CSN (Combination Sequence Number)

                        Example: 5/39 Lottery Game

                        Lexi #:

                        000001 = 1,2,3,4,5

                        ----------------------------------

                        575757 = 35,36,37,38,39

                        The formulas take the previous draws Lexi number and the current draws Lexi number then randomly selects another Lexi # between the 2.

                        Take the Tennesee 5/39 Lottery game for example.

                        4/6/12 Draw: 3-8-14-24-34 Lexi = 0104320

                        4/4/12 Draw: 6-24-25-26-35 Lexi = 025391

                        Program randomly selects a Lexi Number between 0104320 & 025391. 

                        You can select as many sets as you want.  I currently have it set to 20 sets meaning there are 20 randomly selected lexi numbers from each of the past 20 drawings.

                        Hello winsum just wanted ya to know the TN Cash 5 is a 5/35 game!!

                        WHEN IT FEELS THE WHOLE WORLD SUCKS!

                        RELAX.........IT'S ONLY GRAVITY Big Smile

                        I think I can I think I can!!!!

                          CARBOB's avatar - FL LOTTERY_LOGO.png
                          ORLANDO, FLORIDA
                          United States
                          Member #4924
                          June 3, 2004
                          5968 Posts
                          Offline
                          Posted: April 10, 2012, 7:10 am - IP Logged

                          So then when I press copy to combo creator Tab and I get a runtime error and debug comes up with this.

                          reddog,

                          If you are still having a problem, do this. Alt F11, Edit ,Replace( make sure All shows in the Direction window)  .XLS With .XLSM  , Current Project

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

                            Hello winsum just wanted ya to know the TN Cash 5 is a 5/35 game!!

                            That what I have it set up as. 5/35 and cash Ball 1 to 5

                            Are you using the drop-down arrow in cell "B8" in the Tab labeled "DrawHistory"?  Click the cell B8 the you should see the drop-down arrow to the right.  Select your state lottery game.  Follow the rest of the instructions I posted in the thread.

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5396 Posts
                              Offline
                              Posted: April 10, 2012, 8:04 am - IP Logged

                              Updated draw histories:

                              Excel Version 2002:

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

                               

                              Excel Version 2010 (Should work for Excel 2007 also)  Note: Make sure you click "Enable Macros"

                              http://www.box.com/s/7cdd3ec905c81b3c7973