Analysis - Scenario Manager question

Hey y'all!


I'm kinda stump because I have to project all possible outcomes based on 4 different varriables.

Excel has data-anaylsis tool but I can't have more than 2 variables (data table).
Is there a way to do it with 4??

Thanks for your time

VBA to loop through all the scenarios would be faster, but it appears this is already solved.

A 1D data table only supports one variable, but that variable can have as many different values as you like, e.g., 0 to 3 by 0.001.

I've made a test file in order to better understand how to proceed. Is it possible to make it functional so I can see it??

Thanks a lot for your time

*i've updated the excel

Your initial post said you had one changing variable that needed to assume 3000 values. Now you've edited it to say you need four variables, which puts my response totally out of context.

So before answering, is this the actual problem, or another warmup exercise?

Are you familiar with Scenario Manager and What-If Analysis?
http://www.excel-easy.com/data-analy...-analysis.html


All in you likely dont NEED vba to do what you are asking.

I'm aware of Scenario Manager but I have 4 different inputs. I'd have to put in 256 scenarios per sheet for just 4 variables. I was gonna eventually add 3 more variables so that would make things even more complex.

Also, I can only input 2 variables in Data table..

Is there a simpler way?? I'm open to avoiding VBA altogether if there is an alternative..

I mean why not just list all the variables and use math to the right of them per row?

You could used the formulas (or VBA) in the workbook at https://app.box.com/s/47b28f19d794b25511be to generate the Cartesian product of the inputs, and then add columns for the formulas:

	B	C	D	E	F	G	H
2	E	wS	SL	TP
3
4	1	1	0.01	0.01
5	2	2	0.02	0.02
6	3	3	0.03	0.03
7	4	4	0.04	0.04
8	5	5	0.05	0.05
9						Formula
10	1	1	0.01	0.01		9849.98	G10: =10000 - ((100+B10*D10)+(50+C10*E10))
11	1	1	0.01	0.02
12	1	1	0.01	0.03
13	1	1	0.01	0.04
14	1	1	0.01	0.05
15	1	1	0.02	0.01
16	1	1	0.02	0.02
17	1	1	0.02	0.03
18	1	1	0.02	0.04
19	1	1	0.02	0.05
20	1	1	0.03	0.01
21	1	1	0.03	0.02
22	1	1	0.03	0.03

The link works fine for me. Mike, can you get at it?

*Note: maybe my work is blocking the access, I'd have to try it tonight when I get home

I've thought about it long and hard and there's no way to make it into an equation because all Input change the final result which causes a series of other settings to change within the file. Essentially, it boils back down to the main issue;

Is there a way/plug-in other then the data-analysis tools (because scenario manager means I'd have to enter over 250+ scenarios & I can't do it in Data-table because I have 4 differents inputs which radically change the end result if I omit any of them).

Yeah I can access it, so I attached it here.

This is HIS file, I just attached it via the forum.

Mike, thank you.