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

A Permutation Combination P3 Problem

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

Page 1 of 1
51
PrintE-mailLink
lotteryprophet's avatar - nbvc
lincoln, nebraska
United States
Member #86998
February 15, 2010
21 Posts
Offline
Posted: November 17, 2011, 8:36 am - IP Logged

I want to make combos using that must include 3 particular digits (say 1,2,3) in which all combos must include at least one pair from these 3 digits.

I thought it would be simply ((3*2)*10)*3=180 but when I test using a wheel I get combos that shouldn't be included.

 

IOW all combos must include the following pairs: 12, 21, 13, 31, 23, 32

    Avatar
    FL
    United States
    Member #93841
    July 8, 2010
    576 Posts
    Offline
    Posted: November 17, 2011, 10:48 am - IP Logged

    I want to make combos using that must include 3 particular digits (say 1,2,3) in which all combos must include at least one pair from these 3 digits.

    I thought it would be simply ((3*2)*10)*3=180 but when I test using a wheel I get combos that shouldn't be included.

     

    IOW all combos must include the following pairs: 12, 21, 13, 31, 23, 32

    I'm not sure if this is what you need but I will post all the pairs that have these numbers below...

     

    Pair 12
    012(021,102,120,201,210) 123(132,213,231,312,321) 124(142,214,241,412,421) 125(152,215,251,512,521) 126(162,216,261,612,621) 127(172,217,271,712,721) 128(182,218,281,812,821) 129(192,219,291,912,921)
    112(121,211) 122(212,221)

    Pair 13
    013(031,103,130,301,310) 123(132,213,231,312,321) 134(143,314,341,413,431) 135(153,315,351,513,531) 136(163,316,361,613,631) 137(173,317,371,713,731) 138(183,318,381,813,831) 139(193,319,391,913,931)
    113(131,311) 133(313,331)

    Pair 23
    023(032,203,230,302,320) 123(132,213,231,312,321) 234(243,324,342,423,432) 235(253,325,352,523,532) 236(263,326,362,623,632) 237(273,327,372,723,732) 238(283,328,382,823,832) 239(293,329,392,923,932)
    223(232,322) 233(323,332)

     

    10 boxed combos per group

    54 straight combos per group

     

    28 boxed combos Total

    162 straight combos Total

    "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."

      lotteryprophet's avatar - nbvc
      lincoln, nebraska
      United States
      Member #86998
      February 15, 2010
      21 Posts
      Offline
      Posted: November 17, 2011, 11:06 am - IP Logged

      Thanks team profit. This helped a great deal..although I still would like to see how the 162 combos (it is 162,,,I verfied it manuallY) are arrived at mathematically.

        Avatar
        FL
        United States
        Member #93841
        July 8, 2010
        576 Posts
        Offline
        Posted: November 17, 2011, 5:22 pm - IP Logged

        Thanks team profit. This helped a great deal..although I still would like to see how the 162 combos (it is 162,,,I verfied it manuallY) are arrived at mathematically.

        What do you mean by, "are arrived at mathematically"??

        I don't believe there is any math involved....

        in a pick 3 you can only choose 1 number in each position

        if you have 2 numbers already there are only 10 other options for the last number 0-9

        12X 1X2 X12 21X 2X1 X21 = 60 combos(6 repeats)"54"

        13X 1X3 X13 31X 3X1 X31 = 60 combos(6 repeats)"54"

        32X 3X2 X32 23X 2X3 X23 = 60 combos(6 repeats)"54"

        54 times 3 = 162 total combos===>>150 after repeats are removed

        "It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."

          winsumloosesum's avatar - Lottery-060.jpg
          Pennsylvania
          United States
          Member #2218
          September 1, 2003
          5387 Posts
          Offline
          Posted: November 18, 2011, 11:52 am - IP Logged

          Excel (Version 2002) 1000 Pick 3 Combinations file download:

          http://www.box.com/s/darryqm6sjim4x5jokbv

          In the Tab labeled "1000NumberList"

          Click cell P2.  You will see the following formula:

          =SUMPRODUCT(--(ISNUMBER(MATCH($L2:$N2,{12,21,13,31,23,32},0))))

          You can change the {12,21,13,31,23,32} to any pairs you wish.  The formula will "match" the number of times the 12,21,13,31,23,32 will occur in the Front Pair, Back Pair, and Side Pair for each combination.

          In cell T2 you can click the down arrow and select 1.  This will sort all 1000 combinations that have at least 1 of the pairs 12.21.13.31.23.32.

            lakerben's avatar - spherewall
            New Mexico
            United States
            Member #86099
            January 29, 2010
            11119 Posts
            Offline
            Posted: November 18, 2011, 12:19 pm - IP Logged

            Excel (Version 2002) 1000 Pick 3 Combinations file download:

            http://www.box.com/s/darryqm6sjim4x5jokbv

            In the Tab labeled "1000NumberList"

            Click cell P2.  You will see the following formula:

            =SUMPRODUCT(--(ISNUMBER(MATCH($L2:$N2,{12,21,13,31,23,32},0))))

            You can change the {12,21,13,31,23,32} to any pairs you wish.  The formula will "match" the number of times the 12,21,13,31,23,32 will occur in the Front Pair, Back Pair, and Side Pair for each combination.

            In cell T2 you can click the down arrow and select 1.  This will sort all 1000 combinations that have at least 1 of the pairs 12.21.13.31.23.32.

            Great work!

              lotteryprophet's avatar - nbvc
              lincoln, nebraska
              United States
              Member #86998
              February 15, 2010
              21 Posts
              Offline
              Posted: November 22, 2011, 12:06 pm - IP Logged

              Excel (Version 2002) 1000 Pick 3 Combinations file download:

              http://www.box.com/s/darryqm6sjim4x5jokbv

              In the Tab labeled "1000NumberList"

              Click cell P2.  You will see the following formula:

              =SUMPRODUCT(--(ISNUMBER(MATCH($L2:$N2,{12,21,13,31,23,32},0))))

              You can change the {12,21,13,31,23,32} to any pairs you wish.  The formula will "match" the number of times the 12,21,13,31,23,32 will occur in the Front Pair, Back Pair, and Side Pair for each combination.

              In cell T2 you can click the down arrow and select 1.  This will sort all 1000 combinations that have at least 1 of the pairs 12.21.13.31.23.32.

              Thanks Winsumloosesum...you are all that Fibonacci boasted about you. Just what I needed.

                winsumloosesum's avatar - Lottery-060.jpg
                Pennsylvania
                United States
                Member #2218
                September 1, 2003
                5387 Posts
                Offline
                Posted: November 27, 2011, 1:20 pm - IP Logged

                Thanks Winsumloosesum...you are all that Fibonacci boasted about you. Just what I needed.

                Your welcome.

                http://www.box.com/s/ldtfar4cabzt41pjkl8p

                The link above is an updated Excel file.

                You would just need to enter your Pairs in the 1st tab labled MatchPairs in cell A1.