Combinations Generator Toolkit – Excel Template

Description
To understand the true functionality of this template, it is easier to illustrate it using an example.

Regarding its single list use, create a list of 4 car manufacturers, for example. These could be Audi, BMW, Cadillac, and Dodge. We could make 6 combinations of 2 items from this list:

Audi – BMW, Audi – Cadillac, Audi – Dodge, BMW – Cadillac, BMW – Dodge, Cadillac – Dodge.

The template could generate this for your list of items automatically.

If you would like to generate combinations of 3 items, change the R in the input section to 3. You would then automatically receive 4 combinations.

The template also has a multiple list use. If you have 3 lists, and need to pick an item from each list, the multiple list functionality can handle that. For example, the first list may contain different car manufacturers, the second list containing the type of car (e.g., Sedan, SUV), and the third list may contain the number of doors.

Automatically, the template will generate the 12 possible combinations.

Multiple lists (no limit on no. of items)
This combination generator can include up to 15 lists and allows you to include any number of items per list, per your need. To include more items per list, extend the table.
If we have 6 lists with varied items count, and need a combination for all the six lists (R=6)
the template can generate the required combinations automatically.
Please note that the combinations should be within the limit of the number of possible rows allowed in excel (approximately one million forty-eight thousand). As the number of combinations generated gets nearer to the limit value, it might take a few seconds to populate the combinations, based on your system performance.  

Note that the limits of the template are the following:

• Single List: N=20, R=7
• Multi-List: 10 lists, 20 items per list
. Multi list extended: 15 lists
• If your scenario is not supported in the templates, please use Eloquens’ private messaging system, and we can create you a customized solution for no further cost.