Welcome Guest
Log In | Register )
You last visited December 8, 2021, 7:07 pm
All times shown are
Eastern Time (GMT-5:00)

pick 5

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

Page 1 of 1
PrintE-mailLink
Avatar
Thread Starter
modesto
United States
Member #3241
January 5, 2004
343 Posts
Offline

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 #17554
    June 22, 2005
    5582 Posts
    Offline

    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 #17554
      June 22, 2005
      5582 Posts
      Offline

      WAX ON

      WAX OFF

        johnph77's avatar - avatar
        CA
        United States
        Member #2987
        December 10, 2003
        832 Posts
        Offline

        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
          Thread Starter
          modesto
          United States
          Member #3241
          January 5, 2004
          343 Posts
          Offline

          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

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

              Avatar
              Tennessee
              United States
              Member #7853
              October 15, 2004
              11350 Posts
              Offline

              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!!