Welcome Guest
Log In | Register )
You last visited December 3, 2016, 1:41 am
All times shown are
Eastern Time (GMT-5:00)

lottery formula

Topic closed. 16 replies. Last post 13 years ago by Bug.

Page 1 of 2
PrintE-mailLink
SHTh's avatar - baby

United States
Member #1959
August 1, 2003
42 Posts
Offline
Posted: August 1, 2003, 5:02 am - IP Logged
Hi,

I've been lurking for a while and have been entertained & educated by the postings.


Please can someone help me with the following: I am looking for an Excel formula that will generate a list of all possible triple combinations of a 49 number draw.

 

Secondly if someone can provide a formula that would enable me to determine the frequency of repetitive triple combinations in my lottery data.


I have a lottery table with all lottery results in (Columns B:G), 300 rows.

 

I would appreciate any help you can give me.

 

SHT.

 
    hypersoniq's avatar - 8ball
    Pennsylvania
    United States
    Member #1340
    April 6, 2003
    2450 Posts
    Offline
    Posted: August 2, 2003, 2:04 pm - IP Logged

    If you happen to find one that narrows dow the powerball (just the powerball)... please forward that along, I'd be happy with that ;-)

     

    During the last 2 weeks of may and the first week of june, I won almost $150 (in smaller hits) on the good ol' PB... now I have some tix for tonight's draw, but only $10 left of "their" money... I'm gonna have to use my own again soon :-(

    Playing more than one ticket per game is betting against yourself.

      Bug's avatar - avatar php?userid=678402&dateline=1071851147

      United States
      Member #788
      October 15, 2002
      471 Posts
      Offline
      Posted: August 2, 2003, 4:17 pm - IP Logged

       

      I wrote some code in C++ to test the Maryland lottery data for the most repetitive match 3 combo's and match 4 combo's. Out of 1631 draws that I had in my file at the time, there was one match 3 combo matching in 8 of the 1631 draws. There were three match 4 combo's in the 1631 draws. Not very meaningful data in my opinion.

      I am not sure if this is the same problem you are undertaking? I am not sure what can be accomplished in Excel, as I don't know much about it. If I remember correctly there are 20 distinct match 3 combos in a winning lotto draw with 6 numbers. So the task gets big pretty quickly.

        RJOh's avatar - chipmunk
        mid-Ohio
        United States
        Member #9
        March 24, 2001
        19816 Posts
        Offline
        Posted: August 2, 2003, 5:27 pm - IP Logged

        SHTh,

        There are 18424 possible combinations of threes in a 49 number field.  If you have the formular for coming up with the 13983816 combinations of sixes then modiy it for three.  To find the frequency of match 3's, you can use an odds calculation which will be pretty close to the real answer you get by checking each file record with the total file.  I don't use excel and don't have a copy of it, but I have a routine(program) that I wrote in GWBasic that works for me.  The same routines are in most lottery software which you can download for a free trial period.

        RJOh 

          kbcherokee's avatar - buffalo2
          Virginia
          United States
          Member #1712
          June 20, 2003
          1549 Posts
          Offline
          Posted: August 2, 2003, 6:44 pm - IP Logged

          Hey gang...

          Just want to try my new Avatar out and see if it is working.

          Ken

            kbcherokee's avatar - buffalo2
            Virginia
            United States
            Member #1712
            June 20, 2003
            1549 Posts
            Offline
            Posted: August 2, 2003, 6:45 pm - IP Logged

            Hey gang...

            I can see it didn't make it for some reason...

            Ken

              kbcherokee's avatar - buffalo2
              Virginia
              United States
              Member #1712
              June 20, 2003
              1549 Posts
              Offline
              Posted: August 2, 2003, 7:02 pm - IP Logged

              Hey gang...

              Just checking once again to see if my Avatar is working...

              Ken

                SHTh's avatar - baby

                United States
                Member #1959
                August 1, 2003
                42 Posts
                Offline
                Posted: August 3, 2003, 7:41 am - IP Logged

                Thank you for your responses so far.

                RJOh wrote:

                If you have the formular for coming up with the 13983816 combinations of sixes then modiy it for three. 

                I have devised other excel lotto formulae but I do not know how to generate all 6 number combinations so your suggestion is redundant. (Please note I do not wish to to generate all 6 combinations).

                SHT.

                  RJOh's avatar - chipmunk
                  mid-Ohio
                  United States
                  Member #9
                  March 24, 2001
                  19816 Posts
                  Offline
                  Posted: August 3, 2003, 10:20 am - IP Logged

                  In GWBasic the following routine will print out all the combinbinations of sixes for a 649 lottery.  Someone once posted a similar routine for Excel. In GWBasic, eliminating N4,N5 and N6 and other small changes will print out all the combinations of threes for a 649 game.  I was thinking that the same thing was true in Excel. I might have been wrong.  I don't recall the post that had the Excel formular, but it's back a while.

                  10 HN=49:REM HN=size of number file
                  20 FOR N1=1 TO HN-5
                  30 FOR N2=N1+1 TO HN-4
                  40 FOR N3=N2+1 TO HN-3
                  50 FOR N4=N3+1 TO HN-2
                  60 FOR N5=N4+1 TO HN-1
                  70 FOR N6=N5+1 TO HN
                  80 H=H+1:PRINT H;". ";N1;N2;N3;N4;N5;N6;"      "
                  90 NEXT N6
                  100 NEXT N5
                  110 NEXT N4
                  120 NEXT N3
                  130 NEXT N2
                  140 NEXT N1

                  Sorry if I appeared redundant.  Good luck to you.
                  RJOh

                    Cleveland,Oh
                    United States
                    Member #1856
                    July 16, 2003
                    531 Posts
                    Offline
                    Posted: August 3, 2003, 11:23 am - IP Logged
                    Quote: Originally posted by SHTh on August 01, 2003



                    Hi,

                    I've been lurking for a while and have been entertained & educated by the postings.


                    Please can someone help me with the following: I am looking for an Excel formula that will generate a list of all possible triple combinations of a 49 number draw.

                     

                    Secondly if someone can provide a formula that would enable me to determine the frequency of repetitive triple combinations in my lottery data.


                    I have a lottery table with all lottery results in (Columns B:G), 300 rows.

                     

                    I would appreciate any help you can give me.

                     

                    SHT.

                     




                    APARENTLY YOU DID NOT UNDERSTSND MY RESPONCE!

                    MY PROGRAM HAS THAT CAPABILITY BUT IT WON'T HELP OTHER THAN

                    SHOW YOU HOW MANY 3/4/5 CAME IN ON THE 6/49!

                      visiondude's avatar - eye3logo
                      light on my feet
                      United States
                      Member #356
                      May 20, 2002
                      2744 Posts
                      Offline
                      Posted: August 3, 2003, 1:26 pm - IP Logged

                      kbcherokee,

                      nice av

                                  "i am .........."meant to"       

                      P.S.,  that RJoH  is a stand up guy.  thanks,  vision

                               until further notice,  it's  france everyday

                        SHTh's avatar - baby

                        United States
                        Member #1959
                        August 1, 2003
                        42 Posts
                        Offline
                        Posted: August 4, 2003, 3:34 am - IP Logged
                        -- Previous Private Message --
                        Sent By : MrSteel01
                        Sent : August 02, 2003 at 8:06am


                        I'LL GIVE SOME INSITE!

                        YOU NEED ABOUT 1,000 DRAWS +-

                        SUMS ARE VERY IMPORTANT LOW/HIGH 56/239 OHIO

                        SEQUENCIAL ORDER 1 THRU 10 COME IN THE MOST 75/80% A $10 BET CARD!

                        QROUPS 1-9 10-19 20-29 30-39 49-49

                        ODDS MORE THAN EVEN

                        I COULD GO ON!

                        I DOWN LOADED A 5 DIGIT FROM GEORGIA HUNDREDS STARTED WITH A 1.

                        MAY BE UOU YOU SHOULD START THEIR! 500,000 TO ONE!

                        NO 6 DIGIT EVER REPEATED IT SELF BUT THEIRS A LOT OF 5/6

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



                        Is this even English??

                        I can be forgiven for not understanding that the above tedious, incomplete, misspelled, rambling message was hawking a lotto program. I can suggest a dozen ways that touting a lotto program can be more succinctly put!

                        APPARENTLY YOU DID NOT UNDERSTAND MY ORIGINAL POST.

                        Mr. Steel under no circumstances will I be interested in your lotto program.

                        SHTh.

                          SHTh's avatar - baby

                          United States
                          Member #1959
                          August 1, 2003
                          42 Posts
                          Offline
                          Posted: August 9, 2003, 4:30 am - IP Logged

                          Bump

                            kbcherokee's avatar - buffalo2
                            Virginia
                            United States
                            Member #1712
                            June 20, 2003
                            1549 Posts
                            Offline
                            Posted: August 9, 2003, 10:58 am - IP Logged

                            Visiondude:

                            Thank you for the nice compliment on the Avatar.

                            Chief

                            May the warm winds of heaven blow softly upon your house. May  the Great Spirit bless all who enter there. May your mocassins make happy tracks in many snows. And may the rainbow always touch your shoulder.

                              Bug's avatar - avatar php?userid=678402&dateline=1071851147

                              United States
                              Member #788
                              October 15, 2002
                              471 Posts
                              Offline
                              Posted: August 10, 2003, 6:00 am - IP Logged

                               

                              I am not sure how loops work in you programming language, or if excel has loops? Maybe you would have to import the file. In pseudo Java it would look like this.

                              for(int i = 1; i <= 49; i++)

                                slot1 = i;

                                  for(int j = i +1; j <= 49; j++)

                                      slot2 =j;

                                      for(int k = j + 1; k <= 49; k++)

                                          slot3 = k;

                                          System.out.println(slot1 + " " slot2 + " " slot3);