I have a very complex set of formulas which take in two static numeric input parameters, and results in two values. For example:
Input Parameters (B1, B2)
Salespeople Profit Margin
Output Values (B3, B4)
Revenue Profit
I manually manipulate my two input parameters, and the program outputs Revenue and Profit, based on the two inputs entered. Nothing special here so far.
However, I want to chart out -lots- of different scenarios based on changing the input values and then chart out the results for each scenario. I plan on manually populating the input values myself in the results worksheet, but am looking for a way in Excel to not have to cut/paste hundreds of scenarios (and cut/paste the results as well) back into the results sheet. I am not looking to 'solve' to a minimum or maximum or optimum value. I just want a big spreadsheet of the results (which I intend to graph and perform some data discovery).
I want to run a simulation on a separate worksheet which iterates down my previously chosen input parameters (Salespeople, and profit margin), and then tells me what the results are (revenue, profit) 'as if' I manually did each scenario and recorded it down myself. For example, here is my results worksheet which displays a few scenarios I have pre-defined and want a way to automatically populate C and D.
A B C D
Salespeople Profit-Margin Revenue Profit
1 5%
2 5%
3 5%
4 5%
5 5%
1 10%
2 10%
3 10%
4 10%
5 10%
1 15%
2 15%
3 15%
4 15%
5 15%
etc.
Is there an easy way to do this in Excel without having to learn VBA?
Input Parameters (B1, B2)
Salespeople Profit Margin
Output Values (B3, B4)
Revenue Profit
I manually manipulate my two input parameters, and the program outputs Revenue and Profit, based on the two inputs entered. Nothing special here so far.
However, I want to chart out -lots- of different scenarios based on changing the input values and then chart out the results for each scenario. I plan on manually populating the input values myself in the results worksheet, but am looking for a way in Excel to not have to cut/paste hundreds of scenarios (and cut/paste the results as well) back into the results sheet. I am not looking to 'solve' to a minimum or maximum or optimum value. I just want a big spreadsheet of the results (which I intend to graph and perform some data discovery).
I want to run a simulation on a separate worksheet which iterates down my previously chosen input parameters (Salespeople, and profit margin), and then tells me what the results are (revenue, profit) 'as if' I manually did each scenario and recorded it down myself. For example, here is my results worksheet which displays a few scenarios I have pre-defined and want a way to automatically populate C and D.
A B C D
Salespeople Profit-Margin Revenue Profit
1 5%
2 5%
3 5%
4 5%
5 5%
1 10%
2 10%
3 10%
4 10%
5 10%
1 15%
2 15%
3 15%
4 15%
5 15%
etc.
Is there an easy way to do this in Excel without having to learn VBA?
