Welcome Guest
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
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

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

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.

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

Pennsylvania
United States
Member #2218
September 1, 2003
5387 Posts
Offline
 Posted: November 18, 2011, 11:52 am - IP Logged

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.

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

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!

United States
Member #86998
February 15, 2010
21 Posts
Offline
 Posted: November 22, 2011, 12:06 pm - IP Logged

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.

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.