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

pick 5

Topic closed. 6 replies. Last post 11 years ago by LOTTOMIKE.

Page 1 of 1
PrintE-mailLink
Avatar
modesto
United States
Member #3241
January 5, 2004
343 Posts
Offline
Posted: March 28, 2006, 12:00 am - IP Logged

Hello

        does anybody have a method in excel of inputting

20 numbers.getting the 20,000 combo's than being able to

delete all combo's with a said pick 3 combo? example i wanted

to get rid of all combo's with 12-15-16 in them i could then go on to

the next etc.etc.  thanks for any help I get

 

                                  good luck chris

 


    United States
    Member #17555
    June 22, 2005
    5582 Posts
    Offline
    Posted: March 28, 2006, 1:44 am - IP Logged

    With your Platinum status, you can take advantage of the tools here that may accomodate what you are seeking.

    Good Luck!!!!

    Elephant Eyebrows.....


      United States
      Member #17555
      June 22, 2005
      5582 Posts
      Offline
      Posted: March 28, 2006, 1:45 am - IP Logged

      WAX ON

      WAX OFF

        johnph77's avatar - avatar
        CA
        United States
        Member #2987
        December 10, 2003
        832 Posts
        Offline
        Posted: March 28, 2006, 11:00 am - IP Logged

        Chris -

        There will be 15,504 permutations of 20 specific numbers in any Pick 5 lottery. A given 3-number combination will appear 136 times within those 15,504 possibilities. A macro will eliminate those lines.

        gl

        j

        Blessed Saint Leibowitz, keep 'em dreamin' down there..... 

        Next week's convention for Psychics and Prognosticators has been cancelled due to unforeseen circumstances.

         =^.^=

          Avatar
          modesto
          United States
          Member #3241
          January 5, 2004
          343 Posts
          Offline
          Posted: March 29, 2006, 12:54 am - IP Logged

          Thanks john

                I will check this out! Thanks pac also, but this site

          only lets you generate the combos by filters etc..am looking for

          something that after you have the combo's you then sit there and

          keep deleting things or 3 digit combo's that won't come in next

          out etc..                    good luck chris

            lottoarchitect's avatar - waveform

            Greece
            Member #2815
            November 18, 2003
            502 Posts
            Offline
            Posted: March 29, 2006, 1:20 pm - IP Logged

            Hello

                    does anybody have a method in excel of inputting

            20 numbers.getting the 20,000 combo's than being able to

            delete all combo's with a said pick 3 combo? example i wanted

            to get rid of all combo's with 12-15-16 in them i could then go on to

            the next etc.etc. thanks for any help I get

             

                                           good luck chris

             

            You can use my program Lotto Architect to do this easily. Initially generate a full wheel with your numbers. Then setup a number group with your 3 numbers, set its match parameter to 0 only (this means keep tickets that have 0 common with your 3 numbers) and filter the full wheel listing. Simple as that. You can add more such number groups of varying numbers and match parameters to further reduce the initial full wheel. You can export the filtered tickets to use in excel of course.

            cheers

            lottoarchitect

            If you have something to do, at least do it well...

              LOTTOMIKE's avatar - cash money.jpg
              Tennessee
              United States
              Member #7853
              October 15, 2004
              11338 Posts
              Offline
              Posted: March 29, 2006, 1:47 pm - IP Logged

              With your Platinum status, you can take advantage of the tools here that may accomodate what you are seeking.

              Good Luck!!!!

              Elephant Eyebrows.....

              i definitely agree!!