Combinations Permutations_Variable Analysis

cotech_10

Board Regular
Joined
Sep 11, 2010
Messages
135
Office Version
  1. 2016
Platform
  1. Windows
Hi All,

I would like to request the following combinations and permutations type of calculation based on a certain set of criteria's:

I would like to use alphanumerical data and produce a Combinations/Permutations Outcomes Table based on a variable selective criteria.

Example (1) : Variable Selective Criteria 1:

Alphanumerical Data : 1 to 8
Numbers to choose from : 8
Number combinations : 4

Repetitons allowed : Yes
Any order allowed : Yes
Maximum repetitions : 4

Based on this Variable Selective Criteria the Permutations would be 4,096


Therefore from the List of 4,096 possible permutations outcomes such as the following
would be allowed :

(1,1,1,1): (2,2,2,2) : (3,3,3,3) etc...


_________________________________________________________________________________________

Example (2) : Variable Selective Criteria 2:

Alphanumerical Data : 1 to 8

Numbers to choose from : 8
Number combinations : 4

Repetitions allowed : Yes
Any order allowed : Yes
Maximum Repetitions : 3


List only Permutations where the repetition of any value is not greater than (3)

For example from the List of 4,096 possible permutations outcomes such as the following
would be filtered out:

(1,1,1,1): (2,2,2,2) : (3,3,3,3) etc...

_________________________________________________________________________________________

Example (3) : Variable Selective Criteria 3:

Alphanumerical Data : 1 to 8

Numbers to choose from : 8
Number combinations : 4

Repetitions allowed : Yes
Any order allowed : Yes
Maximum Repetitions : 2


List only Permutations where the repetition of any value is not greater than (2)

For example from the List of 4,096 possible permutations outcomes such as the following
would be filtered out :

(1,1,1,2): (2,2,2,3): (3,3,3,4) etc... these outcomes contain more than (2) repetitions of any value

Allowed permutations would be for example :

(1,1,2,2): (2,2,3,3): (3,3,2,4) etc... these outcomes do not contain more than (2) repetitions of any value

_________________________________________________________________________________________


Example (4) : Variable Selective Criteria 4:

Alphanumerical Data : 1 to 10

Numbers to choose from : 10
Number combinations : 3

Repetitions allowed : Yes
Any order allowed : Yes
Maximum repetitions : 3

Based on this Variable Selective Criteria the Permutations would be 1,000


Therefore from the List of 1,00 possible permutations the following outcomes would be allowed:

(1,1,1): (2,2,2) : (3,3,3) etc...


_________________________________________________________________________________________


Example (5) : Variable Selective Criteria 5:

Alphanumerical Data : 1 to 10

Numbers to choose from : 10
Number combinations : 3

Repetitions allowed : No
Any order allowed : Yes
Maximum repetitions : 3

Based on this Variable Selective Criteria the Permutations would be 1,000


Therefore from the List of 1,00 possible permutations the following outcomes would be allowed:

(1,2,3): (2,3,4) : (3,4,5) etc...


_______________________________________________________________________________________________


Output Tables would like the following Tables below:



Table 1 : Variable Criteria Table

1704504684286.png




Table 2 : Combinations and Permutations Outcomes Table


1704504644910.png





Regards
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Hi All,

I would like to request the following combinations and permutations type of calculation based on a certain set of criteria's:

I would like to use alphanumerical data and produce a Combinations/Permutations Outcomes Table based on a variable selective criteria.

Example (1) : Variable Selective Criteria 1:

Alphanumerical Data : 1 to 8
Numbers to choose from : 8
Number combinations : 4

Repetitons allowed : Yes
Any order allowed : Yes
Maximum repetitions : 4

Based on this Variable Selective Criteria the Permutations would be 4,096


Therefore from the List of 4,096 possible permutations outcomes such as the following
would be allowed :

(1,1,1,1): (2,2,2,2) : (3,3,3,3) etc...


_________________________________________________________________________________________

Example (2) : Variable Selective Criteria 2:

Alphanumerical Data : 1 to 8

Numbers to choose from : 8
Number combinations : 4

Repetitions allowed : Yes
Any order allowed : Yes
Maximum Repetitions : 3


List only Permutations where the repetition of any value is not greater than (3)

For example from the List of 4,096 possible permutations outcomes such as the following
would be filtered out:

(1,1,1,1): (2,2,2,2) : (3,3,3,3) etc...

_________________________________________________________________________________________

Example (3) : Variable Selective Criteria 3:

Alphanumerical Data : 1 to 8

Numbers to choose from : 8
Number combinations : 4

Repetitions allowed : Yes
Any order allowed : Yes
Maximum Repetitions : 2


List only Permutations where the repetition of any value is not greater than (2)

For example from the List of 4,096 possible permutations outcomes such as the following
would be filtered out :

(1,1,1,2): (2,2,2,3): (3,3,3,4) etc... these outcomes contain more than (2) repetitions of any value

Allowed permutations would be for example :

(1,1,2,2): (2,2,3,3): (3,3,2,4) etc... these outcomes do not contain more than (2) repetitions of any value

_________________________________________________________________________________________


Example (4) : Variable Selective Criteria 4:

Alphanumerical Data : 1 to 10

Numbers to choose from : 10
Number combinations : 3

Repetitions allowed : Yes
Any order allowed : Yes
Maximum repetitions : 3

Based on this Variable Selective Criteria the Permutations would be 1,000


Therefore from the List of 1,00 possible permutations the following outcomes would be allowed:

(1,1,1): (2,2,2) : (3,3,3) etc...


_________________________________________________________________________________________


Example (5) : Variable Selective Criteria 5:

Alphanumerical Data : 1 to 10

Numbers to choose from : 10
Number combinations : 3

Repetitions allowed : No
Any order allowed : Yes
Maximum repetitions : 3

Based on this Variable Selective Criteria the Permutations would be 1,000


Therefore from the List of 1,00 possible permutations the following outcomes would be allowed:

(1,2,3): (2,3,4) : (3,4,5) etc...


_______________________________________________________________________________________________


Output Tables would like the following Tables below:



Table 1 : Variable Criteria Table

View attachment 104517



Table 2 : Combinations and Permutations Outcomes Table


View attachment 104516




Regards
Hi All,

Correction to Example (5)


_________________________________________________________________________________________


Example (5) : Variable Selective Criteria 5:

Alphanumerical Data : 1 to 10

Numbers to choose from : 10
Number combinations : 3

Repetitions allowed : No
Any order allowed : Yes
Maximum repetitions : 3

Based on this Variable Selective Criteria the Permutations would be 220


Therefore from the List of 220 possible permutations the following outcomes would be allowed:

(1,2,3): (2,3,4) : (3,4,5) etc...


_______________________________________________________________________________________________

The number of outcomes is 220 not 1,000
 
Upvote 0

Forum statistics

Threads
1,215,069
Messages
6,122,959
Members
449,096
Latest member
Anshu121

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top