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:
|
|
Add-ins.com LLC
An analysis add-in product for Microsoft® Excel®
|
|
|
|
|
Add-ins.com LLC
Effortlessly re-arrange rows and cells
|
|
|
|
|
Add-ins.com LLC
Get over 1200 macro examples for Microsoft Excel in a downloadable book (Windows help file format). These examples are new and not a repeat of the ones in Macros Made Easy
|
|
|
|
|
Add-ins.com LLC
Extract rows of data into columns for easy review and printing
|
|
|
|
|
Add-ins.com LLC
Consolidate worksheets from multiple workbooks
|
|
|
|
|
Add-ins.com LLC
Convert reports to worksheet data
|
|
|
|
|
Add-ins.com LLC
Create your own toolbar of buttons to quickly and easily format cells and rows.
|
|
|
|
|
Add-ins.com LLC
Automatically add print footers to all of your printouts
|
|
|
|
|
Add-ins.com LLC
Easily lock and unlock worksheets
|
|
|
|
|
Add-ins.com LLC
Easily manage and re-arrange your to do lists
|
|
|
|
|
Add-ins.com LLC
Copy or move rows between worksheets with just a single click!
|
|
|
|
|
Add-ins.com LLC
Create equations that identify colored cells. Sum cells based on color.
|
|
|
|
|
Add-ins.com LLC
Easily format cells based on multiple tests.
|
|
|
|
|
Add-ins.com LLC
Fix missing chart data problems
|
|
|
|
|
Add-ins.com LLC
Move from sheet to sheet with great ease. View a list of all your sheets with one click!
|
|
|
|
|
Add-ins.com LLC
Convert data into a form usable by pivot tables
|
|
|
|
|
Add-ins.com LLC
Merge (concatenate) multiple cells many different ways
|
|
|
|
|
Add-ins.com LLC
Do goal seek on multiple cells automatically
|
|
|
|
|
Add-ins.com LLC
Quickly and easily find and go to any column on a worksheet via a descriptive list of all the columns!
|
|
|
|
|
Add-ins.com LLC
Choose from over 1800 buttons for your macro buttons
|
|
|
