|
 |
        |
|
INDIVIDUAL PRODUCTS:
PRODUCT COLLECTIONS: |
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:
| |
| Copyright 2008 Add-ins.com LLC, all rights reserved. Spreadsheet Assistant is a registered trademark of Macro Systems. Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation |
