Welcome Guest
Log In | Register )
You last visited December 2, 2016, 5:18 pm
All times shown are
Eastern Time (GMT-5:00)

Pick 1/39 Random NUmber Generator for Excell?

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

Page 1 of 2
52
PrintE-mailLink
Sage's avatar - Lottery-035.jpg
Dunwoody Georgia
United States
Member #747
September 29, 2002
659 Posts
Offline
Posted: March 10, 2014, 12:19 am - IP Logged

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

It's Never Too Late To Be The Person You Could Of Been!I Agree!

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Offline
    Posted: March 10, 2014, 5:48 am - IP Logged

    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 - 2elh5if
      Ontario
      Canada
      Member #109243
      April 9, 2011
      31437 Posts
      Offline
      Posted: March 10, 2014, 10:30 am - IP Logged

      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
        Pennsylvania
        United States
        Member #2218
        September 1, 2003
        5387 Posts
        Offline
        Posted: March 10, 2014, 1:46 pm - IP Logged

        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 #92564
          June 9, 2010
          2122 Posts
          Offline
          Posted: March 10, 2014, 3:53 pm - IP Logged

          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
            Dunwoody Georgia
            United States
            Member #747
            September 29, 2002
            659 Posts
            Offline
            Posted: March 10, 2014, 9:45 pm - IP Logged

            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!

            It's Never Too Late To Be The Person You Could Of Been!I Agree!

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Offline
              Posted: March 10, 2014, 10:11 pm - IP Logged

              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
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: March 10, 2014, 10:22 pm - IP Logged

                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 #120575
                  December 22, 2011
                  811 Posts
                  Offline
                  Posted: March 10, 2014, 10:49 pm - IP Logged

                  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 #92564
                    June 9, 2010
                    2122 Posts
                    Offline
                    Posted: March 11, 2014, 8:41 am - IP Logged

                    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
                      Pennsylvania
                      United States
                      Member #2218
                      September 1, 2003
                      5387 Posts
                      Offline
                      Posted: March 12, 2014, 10:18 am - IP Logged

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

                        United States
                        Member #11
                        December 6, 2001
                        75 Posts
                        Offline
                        Posted: March 12, 2014, 12:52 pm - IP Logged

                        Thanks Steve,your hard work is greatly appreciated.

                          winsumloosesum's avatar - Lottery-060.jpg
                          Pennsylvania
                          United States
                          Member #2218
                          September 1, 2003
                          5387 Posts
                          Offline
                          Posted: March 12, 2014, 2:54 pm - IP Logged

                          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
                            Dunwoody Georgia
                            United States
                            Member #747
                            September 29, 2002
                            659 Posts
                            Offline
                            Posted: March 20, 2014, 2:10 pm - IP Logged

                            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

                            It's Never Too Late To Be The Person You Could Of Been!I Agree!

                              SergeM's avatar - slow icon.png
                              Economy class
                              Belgium
                              Member #123700
                              February 27, 2012
                              4035 Posts
                              Offline
                              Posted: March 20, 2014, 3:18 pm - IP Logged

                              Sweet code again.