|
| |
SensIt Sensitivity Analysis Add-In
For Microsoft® Windows®
Excel® 2000-2010 and Macintosh®
Excel® 2004 |
| |
|
|
|
SensIt® performs sensitivity analysis on
your worksheet what-if model and creates simple plots, spider charts,
and tornado charts. In a decision situation, sensitivity analysis helps
you determine which of your input assumptions are critical so that you
know where to focus your effort for gathering more information or
reducing uncertainty.
|
|
|
|
 |
|
 |
|
 |
|
|
|
Only US$59 |
|
Multi User |
|
Free Tryout |
|
|
| |
|
|
| Benefits: |
* |
Save time by automating your what-if sensitivity analysis. |
|
* |
Identify which of your model's input assumptions are
critical. |
|
* |
Use Sensit's charts to explain your analysis to
colleagues. |
|
* |
Decide which inputs require probability distributions for
subsequent Monte Carlo simulation using RiskSim. |
|
* |
Easily use the single-file SensIt add-in with no
complicated installation; simply open SensIt.xla whenever and wherever
you need it. |
To use SensIt, you
(1) create a spreadsheet model,
(2) identify the input cells (e.g., variable cost, demand,
etc.),
(3) specify a range for each input
value,
(4) identify the output cell (e.g., annual profit), and
(5) choose Tools | Sensitivity Analysis from Excel's menu.
| SensIt performs single-factor
and two-factor sensitivity analysis by automatically varying
the input values, tabulating the corresponding output values, and creating tornado
and spider charts. |
Click each thumbnail below to see the full-size picture.
| Spider Chart |
|
Many Inputs Dialog |
|
|
|
 |
To provide feedback or for additional information about TreePlan, SensIt, and
RiskSim,
please send e-mail to
Mike Middleton.
|
