Combination/Permutation Formula

**bryanlindsey** · 02-12-2010, 07:36 PM

Howdy!

Trying to come up with all possible combinations/permutations for testing a new product. Below are the twelve variable names and values (I've limited the possible values to two or three for ease of use). What formula can I use to generate ALL the possible combinations of the variables below?

Thanks for any help you can provide. This is probably easy for someone smart. That someone is not me

Category Possible Values

Voltage: 12v 48v
Res: D1 CIF
BR: 2M 768 128
FR: 30 10 1
#Cam: 10 4 1
Audio: 10 1 0
GPS: DB9 LCD LED
J1939: ON OFF
PW: ON OFF
SDT: HIGH LOW
IGN: HIGH LOW
REC: HIGH LOW

**JBeaucaire** · 02-12-2010, 08:14 PM

Originally Posted by bryanlindsey

Thanks for any help you can provide.

...to do what? I still don't see a question anywhere.

**teylyn** · 02-12-2010, 08:15 PM

Hello brianlindsey,

welcome to the forum. However, your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**shg** · 02-12-2010, 08:21 PM

... and then we'll fix you right up.

You are aware there are over 30,000 combinations?

**bryanlindsey** · 02-15-2010, 11:22 AM

Sorry for the non-conformance. Hopefully my question is now more clear and in line with the forum rules.

Thanks!

**shg** · 02-15-2010, 11:39 AM

See attached. Drag the formulas down another 30,000-odd lines to see all of the combinations.

**bryanlindsey** · 02-15-2010, 11:56 AM

Wow. Thank you very much!

**TMS101** · 03-18-2010, 05:18 PM

Wow. This is amazing. I am trying to do something similar. I have a product with 5 choices, and each choice has 8 options. This is something I do on a fairly regular basis - is there a basic formula for me to apply when trying to come up with all situations? I am trying to apply the example shown here and am still picking up pieces of my brain from the keyboard.