Combination Generator

This started with identifying possible scenarios for something that we needed to test. Here is the gist of the problem.

There are 5 parameters and each parameter has a list of possible values. Generate all the possible cases. Plain old combination.

The first solution that someone followed was to generate the list manually :-). So, I tried and improved it by hardcoding a fixed number of "for" loops for the number of possible values(number of values were fixed too). But then I decided I will roll it out to others and thats when I thought of all the questions that people might ask. So, I realized, not making it general is too lame a solution. So, here it is, a general solution for generating combinations, of course there are upper limits to the number of combinations it can handle due to the limit excel has for data.

Please read the disclaimer before using it. Any constructive comments are welcome!

Link to the excel

Comments (14)

Excellent tool. Thanks a lot :)

I found it very useful.

bala
balachandran.balaoct1982@gmail.com

@bala: I am pleased you found it useful.

I inclination not acquiesce in on it. I think nice post. Especially the designation attracted me to review the intact story.

Amiable brief and this mail helped me alot in my college assignement. Gratefulness you seeking your information.

Good post and this mail helped me alot in my college assignement. Gratefulness you seeking your information.

Easily I assent to but I think the collection should acquire more info then it has.

Genial dispatch and this mail helped me alot in my college assignement. Thank you for your information.

Prime mover a register Our Shady Prices at www.Pharmashack.com, The Unequalled [b][url=http://www.pharmashack.com]Online Chemist's [/url][/b] To [url=http://www.pharmashack.com]Buy Viagra[/url] Online ! You Can also Earwitness Life-and-death Deals When You [url=http://www.pharmashack.com/en/item/cialis.html]Buy Cialis[/url] and When You You [url=http://www.pharmashack.com/en/item/levitra.html]Buy Levitra[/url] Online. We Also Take up again a Ginormous Generic [url=http://www.pharmashack.com/en/item/phentermine.html]Phentermine[/url] Someone is active the allowances of Your Regimen ! We Huckster Disperse [url=http://www.pharmashack.com/en/item/viagra.html]Viagra[/url] and Also [url=http://www.pharmashack.com/en/item/generic_viagra.html]Generic Viagra[/url] !

Predilection casinos? oblige inescapable of this firsthand [url=http://www.realcazinoz.com]casino[/url] advisor and dally online casino games like slots, blackjack, roulette, baccarat and more at www.realcazinoz.com .
you can also sift our untrained [url=http://freecasinogames2010.webs.com]casino[/url] orientate at http://freecasinogames2010.webs.com and subdue to verifiable lolly !
another swaggerer [url=http://www.ttittancasino.com]casino spiele[/url] impression is www.ttittancasino.com , in the adoption of german gamblers, submit c be communicated via unconstrained online casino bonus.

I read this forum since 2 weeks and now i have decided to register to share with you my ideas. [url=http://inglourious-seo.com]:)[/url]

You could easily be making money online in the underground world of [URL=http://www.www.blackhatmoneymaker.com]blackhat forum[/URL], You are far from alone if you haven’t heard of it before. Blackhat marketing uses alternative or not-so-known ways to build an income online.

Excellent work! It's quite useful, and I thank you for posting it.

hey buddy,this is one of the best posts that I�ve ever seen; you may include some more ideas in the same theme. I�m still waiting for some interesting thoughts from your side in your next post.