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

Help with "Possible" numbers formula.

Topic closed. 18 replies. Last post 7 years ago by winsumloosesum.

Page 1 of 2
PrintE-mailLink
KnuckleHead's avatar - box

United States
Member #73037
April 3, 2009
147 Posts
Offline
Posted: April 17, 2010, 10:57 am - IP Logged

Morning again all,

This is 2nd question that I've been burning up gray matter over.

 

Has anyone been able to construct a formula or write code that could look at a table of numbers, disregard any multiple numbers, then place the numbers into "ticket" formats (depending on the number of picks) using all of the number combinations?

Example of a Pick 6 table:
42    52    48    40    32    54       
52    48    42    39    54    49       
42    40    47    39    31    27       
19    17    42    24    31    16       
26    22     7     31    52    16   

Based on my tables, I've had several numbers show up in a single drawing, but never on the same line.

Again, thanks for any thoughts or assistance with this idea.

          The only DUMB question is the one question you DID NOT ask...

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Online
    Posted: April 18, 2010, 7:24 pm - IP Logged

    Morning again all,

    This is 2nd question that I've been burning up gray matter over.

     

    Has anyone been able to construct a formula or write code that could look at a table of numbers, disregard any multiple numbers, then place the numbers into "ticket" formats (depending on the number of picks) using all of the number combinations?

    Example of a Pick 6 table:
    42    52    48    40    32    54       
    52    48    42    39    54    49       
    42    40    47    39    31    27       
    19    17    42    24    31    16       
    26    22     7     31    52    16   

    Based on my tables, I've had several numbers show up in a single drawing, but never on the same line.

    Again, thanks for any thoughts or assistance with this idea.

    KnuckleHead,

    Not sure if this is what you needed.

    I created 2 Excel files (Zip File) in the download link below:

    1.  Pick 5

    2.  Pick 6

    http://www.box.net/shared/yxpc42hvek

    There is only 1 Tab in each of the 2 Excel files.

    There are Steps in each of the Tabs.

    The Pick 6 is what you really need so I created a Pick 6 Table just like you posted above.  I entered all the values in the "Pick 6 Table" and sorted and removed all duplicate values.

    If you follow the Steps you will be able to run all the combinations based on the number of digits you have after all the duplicates have been removed.

    The only thing is that when you run the last step to generate combinations it may take about 30 seconds to calculate based on the number of digits to wheel into combinations.

    The other issue is that any combinations over 65,000 will result in an "Alert Box".  Due to the limitations with Excel 2002 you will not be able to generate more than 65,000 combinations.

    Hope this helps!!

    Let me know if you have any questions.

    Good Luck!

      KnuckleHead's avatar - box

      United States
      Member #73037
      April 3, 2009
      147 Posts
      Offline
      Posted: April 19, 2010, 12:26 pm - IP Logged

      Morning winsumloosesum,

      Thank you. I did a PM to you regarding the files.

                The only DUMB question is the one question you DID NOT ask...

        Avatar
        CA
        United States
        Member #84266
        December 26, 2009
        410 Posts
        Offline
        Posted: April 21, 2010, 4:56 am - IP Logged

        Is it possible to generate a complete list of combinations of X numbers from range y-z using your file?

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Online
          Posted: April 21, 2010, 7:55 am - IP Logged

          Is it possible to generate a complete list of combinations of X numbers from range y-z using your file?

          You can enter any number of digits.  The limit is that the list can't go over 65,000 combinations (Excel 2002). Use either the Pick 5 or Pick 6 Excel file and enter your numbers in the Table.  Just follow the steps in the Tab.

          This is actually a decent wheeling file because you can enter the digits you want to wheel.

            Avatar
            Houston
            United States
            Member #62319
            June 24, 2008
            242 Posts
            Offline
            Posted: April 22, 2010, 5:56 pm - IP Logged

            To the OP,

             

            Let me test my method against your math.

             

            I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

            Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

              winsumloosesum's avatar - Lottery-060.jpg
              Pennsylvania
              United States
              Member #2218
              September 1, 2003
              5387 Posts
              Online
              Posted: April 22, 2010, 6:19 pm - IP Logged

              To the OP,

               

              Let me test my method against your math.

               

              I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

              Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

              Cool.

              Here ya go

              545 046 274 737 732 787 438 792 063
                xthundercat2003's avatar - 161784 100002045964044_7086045_n.jpg
                new york
                United States
                Member #52681
                June 4, 2007
                2216 Posts
                Offline
                Posted: April 22, 2010, 6:25 pm - IP Logged

                 i think you should read spirit blog she tell how to pick your pick3

                xthundercat2003's avatar - 161784 100002045964044 7086045 ntrust and belive

                  winsumloosesum's avatar - Lottery-060.jpg
                  Pennsylvania
                  United States
                  Member #2218
                  September 1, 2003
                  5387 Posts
                  Online
                  Posted: April 22, 2010, 6:32 pm - IP Logged

                   i think you should read spirit blog she tell how to pick your pick3

                  Are you referring to Spirit2010 blog?

                    Avatar
                    Houston
                    United States
                    Member #62319
                    June 24, 2008
                    242 Posts
                    Offline
                    Posted: April 22, 2010, 6:37 pm - IP Logged

                    Cool.

                    Here ya go

                    545 046 274 737 732 787 438 792 063

                    Actually I need more than 10 numbers. I found the patterns and sequence but couldn't complete it because of a lack of numbers.

                    However, for the next (the 10th play), the last number of the 3 number will be  either a 5 or 8 ( if the numbers are big numbers from 5 to9).

                     

                    I.E.: X X 5

                              or

                            X X 8

                     

                    Tell me if I'm right.

                     

                    I would probably need 20 to 30 numbers to get a complete read and a full grip on the pattern/sequence.

                      Lucky Loser's avatar - bucks
                      Texas
                      United States
                      Member #86154
                      January 30, 2010
                      1648 Posts
                      Offline
                      Posted: April 22, 2010, 6:38 pm - IP Logged

                      To the OP,

                       

                      Let me test my method against your math.

                       

                      I never did a Pick 3,4 or 5. Give me the last 10 plays of your state's Pick 3 or 4 game. Line it up with the latest being at the bottom and the previous numbers at the top ( a descending order).

                      Only post the first 9 plays of the Pick 3 or 4 games and I will predict the 10th play in a matter of minutes and tell me how I did.

                      'Tank, I'd be curious to kow why you've never "did" a Pick game before. In my opinion, a person needs to know at least a reasonable amount about "working" these games before jumping into the Major Leagues. Don't you know that it's easier to match numbers here, more consistently, and make some money for your efforts if carefully executed?

                      I mean, (3) numbers with MM pays really nothing as opposed the same (3) numbers in Pick 3 will net around $40-$50...maybe more depending on how it's played. Pick 3 will pay you...MM won't, unless you net 5+0 or all of them. Think about this when you have time...

                      Nothing wrong with wanting the big money but, gotta know how to make a little money first. My .02.

                       

                      L.L.

                        winsumloosesum's avatar - Lottery-060.jpg
                        Pennsylvania
                        United States
                        Member #2218
                        September 1, 2003
                        5387 Posts
                        Online
                        Posted: April 22, 2010, 6:40 pm - IP Logged

                        Actually I need more than 10 numbers. I found the patterns and sequence but couldn't complete it because of a lack of numbers.

                        However, for the next (the 10th play), the last number of the 3 number will be  either a 5 or 8 ( if the numbers are big numbers from 5 to9).

                         

                        I.E.: X X 5

                                  or

                                X X 8

                         

                        Tell me if I'm right.

                         

                        I would probably need 20 to 30 numbers to get a complete read and a full grip on the pattern/sequence.

                        You are correct the last digit is an 8.  The 10th draw was 888

                          Avatar
                          Florida
                          United States
                          Member #66575
                          October 30, 2008
                          3549 Posts
                          Offline
                          Posted: April 22, 2010, 6:52 pm - IP Logged

                          Heres last 20 combo's

                          want to give it a try ?

                           

                          These are Eve only  or do you need combined draws ?

                          619
                          780
                          399
                          818
                          864
                          013
                          090
                          315
                          342
                          901
                          642
                          867
                          556
                          128
                          913
                          722
                          438
                          802
                          389
                          890
                          824

                          779

                           

                          Thanks

                          CarliG

                            Avatar
                            Houston
                            United States
                            Member #62319
                            June 24, 2008
                            242 Posts
                            Offline
                            Posted: April 22, 2010, 6:59 pm - IP Logged

                            Heres last 20 combo's

                            want to give it a try ?

                             

                            These are Eve only  or do you need combined draws ?

                            619
                            780
                            399
                            818
                            864
                            013
                            090
                            315
                            342
                            901
                            642
                            867
                            556
                            128
                            913
                            722
                            438
                            802
                            389
                            890
                            824

                            779

                             

                            Thanks

                            CarliG

                            I don't want to keep predicting for people. I just wanted to see how my method fares against it. However, I only test the last column of the number and my method produced :

                             

                            XX5

                            or

                            XX7

                            or

                            XX8

                             

                            If it's a smaller number, it's definitely

                            1XX

                             

                             

                            Tell me if I'm right. If I'm wrong it's because I didn't institute the full scope of the method. I kind did it off the head. Tell me anwyay....?

                              winsumloosesum's avatar - Lottery-060.jpg
                              Pennsylvania
                              United States
                              Member #2218
                              September 1, 2003
                              5387 Posts
                              Online
                              Posted: April 22, 2010, 7:02 pm - IP Logged

                              I don't want to keep predicting for people. I just wanted to see how my method fares against it. However, I only test the last column of the number and my method produced :

                               

                              XX5

                              or

                              XX7

                              or

                              XX8

                               

                              If it's a smaller number, it's definitely

                              1XX

                               

                               

                              Tell me if I'm right. If I'm wrong it's because I didn't institute the full scope of the method. I kind did it off the head. Tell me anwyay....?

                              Next winning combo was 8-3-2