|
| Questions? Call us 302-234-9857, 8AM to 10PM U.S. East Coast time 7 days a week |
|
|
The Sensitivity Analyzer performs "what if" analysis quickly and easily, and saves you a lot of time. This add-in allows you to vary the data in up to five cells and return the values of up to 10 other cells. You can specify the starting, stopping, and step values for each of the five cells. It automatically creates a report containing the information on all the cases. It does the calculations and data processing far faster than you can manually, saving you time and eliminating the pain of doing many cases manually. And it puts the original data back in the worksheet cells when it is done processing the cases! It automatically creates a report containing the information on all the cases. The following dialog illustrates how you would specify input variables. Input variables are the ones that you want the Sensitivity Analyzer to vary.
Once you have completed the above panel the following panel appears to allow you to specify the output variables.
The following illustrates just part of the output using the above inputs and outputs:
Customers who viewed the Sensitivity Analyzer also viewed:
|
|
| Copyright 2011 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Add-ins.com LLC. Microsoft, Excel and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. |
