Welcome Guest
Log In | Register )
You last visited September 30, 2020, 4:44 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 1/39 Random NUmber Generator for Excell?

Topic closed. 15 replies. Last post 7 years ago by adobea78.

Page 1 of 2
PrintE-mailLink
Sage's avatar - Lottery-035.jpg
Thread Starter
Dunwoody Georgia
United States
Member #747
September 29, 2002
685 Posts
Offline

Good Morning Lottery Post family.  Awhile back someone  had said there was a Randon Number Generstor for the Fantasy 5 or Pick 5 game 1-39 balls written In Excell?  I was wondering if someone had a copy and if so would they be willing to  share it?  Thanks for taking the time to look.

 

WinkSmileMail For You

Dripping In Finesse for 2018!I Agree!

    winsumloosesum's avatar - Lottery-060.jpg

    United States
    Member #2218
    September 1, 2003
    6476 Posts
    Online

    https://app.box.com/s/549ldc2sckdp1hd0jsap

    Instructions:

    Open Excel file LotterRandomNumber.xlsm

    Click the tab at the bottom labeled Generator

    In cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1

    In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39

    In cell A3 enter "how many" sets you want to generate. Example 10 sets

    In cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4

    Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets.

     

    You can use this for any lottery game!!

      LottoBux's avatar - ryn8iCO
      25
      Ontario
      Canada
      Member #109239
      April 9, 2011
      60463 Posts
      Offline

      https://app.box.com/s/549ldc2sckdp1hd0jsap

      Instructions:

      Open Excel file LotterRandomNumber.xlsm

      Click the tab at the bottom labeled Generator

      In cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1

      In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39

      In cell A3 enter "how many" sets you want to generate. Example 10 sets

      In cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4

      Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets.

       

      You can use this for any lottery game!!

      Thanks For Sharing winsumloosesum Thumbs Up

      Simple Yet Effective.

      I Just Tried It Out For Keno(10/20/70 Game)

                       

        winsumloosesum's avatar - Lottery-060.jpg

        United States
        Member #2218
        September 1, 2003
        6476 Posts
        Online

        Thanks For Sharing winsumloosesum Thumbs Up

        Simple Yet Effective.

        I Just Tried It Out For Keno(10/20/70 Game)

        Your welcome.

        I added an additional 2 Toolbars.

        The 2nd Toolbar will create your random sets in cell column O1

        The 3rd Toolbar will clear cell sets from column O.

        https://app.box.com/s/z0033jmmgr8v63s7sz7a

         

        Excel version 1997 - 2003

        https://app.box.com/s/14d3c9kobx65an6auzz7

          Avatar
          bgonçalves
          Brasil
          Member #92560
          June 9, 2010
          3126 Posts
          Offline

          Hello Winsum, manages to put, yes of course depending on the size of the lottery in question
            Generate rows or 3 or more bets without repeating digits example =
            Lotto 50/5
            01 05 15 29 45
          12 18 39 44
          14 22 25 35 48
              No repetition number among the three lines

            Sage's avatar - Lottery-035.jpg
            Thread Starter
            Dunwoody Georgia
            United States
            Member #747
            September 29, 2002
            685 Posts
            Offline

            https://app.box.com/s/549ldc2sckdp1hd0jsap

            Instructions:

            Open Excel file LotterRandomNumber.xlsm

            Click the tab at the bottom labeled Generator

            In cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1

            In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39

            In cell A3 enter "how many" sets you want to generate. Example 10 sets

            In cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4

            Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets.

             

            You can use this for any lottery game!!

            What can I say? Thank you Steve!  You are truly the best of the best!!! Party

             

            I know I can always count on you!

            Dripping In Finesse for 2018!I Agree!

              winsumloosesum's avatar - Lottery-060.jpg

              United States
              Member #2218
              September 1, 2003
              6476 Posts
              Online

              What can I say? Thank you Steve!  You are truly the best of the best!!! Party

               

              I know I can always count on you!

              Your welcome!!

              If you want to create a random set of 20 (or other selections 10, 15 etc) numbers to wheel:

              1. In cell A1 enter the "lowest" ball number in your lottery.  Example 1/49 game low number ball is 1

              2. In cell A2 enter the "highest" ball number in your lottery. Example 1/49 game high number ball is 49

              3. In cell A3 enter "how many" sets you want to generate. Example 1 set

              4. In cell A4 enter the "total number" of balls drawn in your lottery game.  Enter 20

              5. Click the Toolbar at the top.  The message box will display your 20 numbers to wheel.

              You can change the value to other values other than 20 in step 4 above.

                winsumloosesum's avatar - Lottery-060.jpg

                United States
                Member #2218
                September 1, 2003
                6476 Posts
                Online

                Your welcome!!

                If you want to create a random set of 20 (or other selections 10, 15 etc) numbers to wheel:

                1. In cell A1 enter the "lowest" ball number in your lottery.  Example 1/49 game low number ball is 1

                2. In cell A2 enter the "highest" ball number in your lottery. Example 1/49 game high number ball is 49

                3. In cell A3 enter "how many" sets you want to generate. Example 1 set

                4. In cell A4 enter the "total number" of balls drawn in your lottery game.  Enter 20

                5. Click the Toolbar at the top.  The message box will display your 20 numbers to wheel.

                You can change the value to other values other than 20 in step 4 above.

                Random Number 1

                  pavizlo$'s avatar - binary
                  OKC, OK
                  United States
                  Member #120571
                  December 22, 2011
                  1409 Posts
                  Offline

                  https://app.box.com/s/549ldc2sckdp1hd0jsap

                  Instructions:

                  Open Excel file LotterRandomNumber.xlsm

                  Click the tab at the bottom labeled Generator

                  In cell A1 enter the "lowest" ball number in your lottery.  Example 1/39 game low number ball is 1

                  In cell A2 enter the "highest" ball number in your lottery. Example 1/39 game high number ball is 39

                  In cell A3 enter "how many" sets you want to generate. Example 10 sets

                  In cell A4 enter the "total number" of balls drawn in your lottery game.  Example 5/39 game there are 5 numbers drawn so enter a 5 in cell A4

                  Click the Toolbar labeled "Click To Generate Sets".  You should see a message box appear with your random number of sets.

                   

                  You can use this for any lottery game!!

                  Good stuff here, this is one of the things i like about Lotterypost site: when somebody is looking for some help, there are always a good people who are ready to help.

                  Thank you Winsumloosesum,

                  GOOD LUCK EVERYONE

                    Avatar
                    bgonçalves
                    Brasil
                    Member #92560
                    June 9, 2010
                    3126 Posts
                    Offline

                    Hello, Winsum. so you can generate = the user sends about 50 bets at random, only that they will be based, another tool based on the 50 random bets, others generate at most one or two numbers of each bet or wager is already in law of averages to hit one or two numbers in the first 50, which are the basis, then you can generate again, the 2nd generation, but need for it to generate enough in the first one is based, it would be done already counting that in the first generation random does not play, if thrown in the 2nd or 3rd generation of random, based on the first (discarding the first) or register gara sweepstakes and a maximum of two numbers from previous draws

                      winsumloosesum's avatar - Lottery-060.jpg

                      United States
                      Member #2218
                      September 1, 2003
                      6476 Posts
                      Online

                      Added a Pick 3 and Pick 4 for Excel versions 1997 - 2003 .xls and 2007, 2010,nd 2013 .xlsm

                      Download Folder:

                      https://app.box.com/s/9grn3jlg60wv8dxxvcmo

                        ram's avatar - Lottery-065.jpg
                        South Texas
                        United States
                        Member #11
                        December 6, 2001
                        220 Posts
                        Offline

                        Thanks Steve,your hard work is greatly appreciated.

                          winsumloosesum's avatar - Lottery-060.jpg

                          United States
                          Member #2218
                          September 1, 2003
                          6476 Posts
                          Online

                          Added a Big Game Excel file for Mega Millions & PowerBall games:

                          Download Folder:

                          BigGameLotteryRandomSetGenerator.xlsm & BigGameLotteryRandomSetGenerator.xls

                          https://app.box.com/s/9grn3jlg60wv8dxxvcmo

                            Sage's avatar - Lottery-035.jpg
                            Thread Starter
                            Dunwoody Georgia
                            United States
                            Member #747
                            September 29, 2002
                            685 Posts
                            Offline

                            Added a Big Game Excel file for Mega Millions & PowerBall games:

                            Download Folder:

                            BigGameLotteryRandomSetGenerator.xlsm & BigGameLotteryRandomSetGenerator.xls

                            https://app.box.com/s/9grn3jlg60wv8dxxvcmo

                            Steve I can't thank you enough for all your years of service at the lottery post.  I don't care what I may have asked you to do over the past 5 10 years or however long it's been you have always rose to the occasion and made sure that I got exactly what I asked for!  Thank you from the bottom of my heart! People don't realize how much you could charge for all this work or how much other people would charge someone to make something in excel.  Thank you Steve!  You are The Best!

                             

                            Thumbs UpI Agree!Party

                            Dripping In Finesse for 2018!I Agree!

                              SergeM's avatar - slow icon.png
                              Economy class
                              Belgium
                              Member #123696
                              February 27, 2012
                              4035 Posts
                              Offline

                              Sweet code again.