Software to Test ALL Input Combinations.

[zealot]

Hello Friends!
I need to test various parameter combinations of a model I built in Excel. I have been thinking of using a macro to run through all combinations of say tree cells (e.g. A1 (1 to 20), B2 (1 to 5) and C4(1 to 3)) – all in all 300 combinations in this example. I think I might need to add more parameters to test so I think a macro would be limiting (which would need to be recorded to add the ability to loop through more inputs). I have been thinking of using Monte Carlo simulation software for EXCEL. I have studied Palisade Risk, Frontline Risk Solver Pro and Oracle Crystal Ball and strangely enough NONE of those products allows to test ALL parameter combinations of the input variables in a model. Yes they allow all kinds of the random sampling of the parameter set universe but that is not applicable in my situation where I need exhaustive testing of ALL parameter combinations (at each run a whole set of stats needs to be copied to another sheet). I wonder if there is software that does this exhaustive test of inputs?
I would be happy to hear any suggestion!
Thanks a lot for your time!
Dima

[zbor]

Can you please upload example workbook?

[zealot]

thank you for your reply. the example workbook is quite large with lots of proprietary coding..I just need to find software which does exhaustive parameter testing..It is OK with me that it might need to cycle through thousands of combinations....the file can be as simple as A1+B2+C3=D5 but of course later on it can become
A1+B2+C3* E7 +F67 -G6=D5

[zbor]

Post a smaller example with important data. It's easier for us to test it.

[zealot]

Post a smaller example with important data. It's easier for us to test it.

Thank you for your interest. I have uploaded a sample worksheet here..I need to cycle through the aforementioned cells highlighted in colors and copy the results of the below calculations (three rows, from a10 to x12 to another sheet, placing the results of each recalculation after one another.....thanks!!!!

[abousetta]

Hi,

Maybe this put you on the right track.

Please Login or Register  to view this content.

It loops through three loops (300 combinations in total) and returns the results in the second sheet of the workbook from A1 to A300.

Is this similar to what you are looking for?

abousetta

[shg]

zealot,

Please post links to all other forums where you have posted the same question.