Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Scenarios
Greetings -
I have a pricing model in excel and am often asked to run it for multiple scenarios. For example, run it for x number of employees, with a, b, c profit margin. I would like to prompt the user for the number of scenarios that need to be run and based on their response I would like to provide them with input prompts for each scenario. For example: if the user requests two scenarios I would like them to be prompted for three different inputs two times. I would then like the two scenarios to execute and output certain calculations on a summary page. Is this asking too much from the built-in, no-programming required capabilities of Excel? Suggestions? Regards, Bryan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Scenarios
If you don't want programming, you could use a setup similar to the
example he http://www.contextures.com/excelfiles.html Under Scenarios, look for 'Alternative to Scenario' Users could fill in as many rows as required on the Scenarios sheet, and view the results on the Report sheet. Bryan wrote: Greetings - I have a pricing model in excel and am often asked to run it for multiple scenarios. For example, run it for x number of employees, with a, b, c profit margin. I would like to prompt the user for the number of scenarios that need to be run and based on their response I would like to provide them with input prompts for each scenario. For example: if the user requests two scenarios I would like them to be prompted for three different inputs two times. I would then like the two scenarios to execute and output certain calculations on a summary page. Is this asking too much from the built-in, no-programming required capabilities of Excel? Suggestions? Regards, Bryan -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel crashing when I use scenarios tool | Excel Discussion (Misc queries) | |||
Creating a form in excel to step through scenarios | Excel Discussion (Misc queries) | |||
Comparing scenarios/forecasts in Excel | Excel Worksheet Functions | |||
Multiple vendors and scenarios - Excel | Excel Worksheet Functions | |||
Excel Scenario Manager should let me re-order scenarios (in the s. | Excel Discussion (Misc queries) |