|





















| |
| |
SensIt Sensitivity Analysis Add-In
For Microsoft® Excel 97-2007, Windows or Macintosh |
| |
|
 |
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$49 |
|
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 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. Use your
browser's Back button to return to this page.
| Tornado Chart |
|
Spider Chart |
|
|
|
|
| |
|
|
| Many Inputs Dialog |
|
One Input Dialog |
 |
|
 |
To provide feedback or for additional information about TreePlan, SensIt, and
RiskSim, please send e-mail to
Mike Middleton.
|