Allows you to vary data in up to five cells and return the values of up to 10 other cells. It automatically creates a report.
Sensitivity Analyzer is an add-in for Microsoft Excel 2007, Excel 2003, Excel 2002 (XP), Excel 2000, and Excel 97.
You are here: Add-ins for Microsoft Excel Financial addins Sensitivity Analyzer
The Sensitivity Analyzer for Excel 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:
You can get more information at the developer's site.
Copyright © 2002-2008 Add-in Express Ltd. All right reserved. Privacy Policy Write to WebMaster
Microsoft and the Office logo are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.