Price: US$69.95

Buy Now!

Free trial

   Sensitivity Analysis

What if Analysis Wizard

Spider Analysis, Tornado Analysis Option and Sensitivity Tables Option.

Spider step1

In your model, choose the Output to be analyzed. The add-in automatically recognizes Output row and column headings.

Spider step2

Assign change percentages to input variables.
By default, these percentages are Start 50%, Step 10% and Stop 150%

Tornado step1

In your model, choose the Output to be analyzed. The add-in automatically recognizes Output row and column headings.

Tornado step 2

Assign change percentages to input variables.
By default, this percent is +/- 10 %

Tables step1

In your model, choose the Output(s) to be analyzed. The add-in automatically recognizes Output row and column headings.

Tables step2

Notice that the inputs chosen are: Sales, Manufaturer y Sales, General & Adm. Overheads

Administrate What if Models

Use this dialog to manage sensitivity models previously saved.
Select the sensitivity model category from the drop-down list.

  Miscellaneous

Search Inputs - Outputs

In the following model, you want to know which variables are output variables and which are input ones.

My favorites

Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.

Toogle Settings

We often lose valuable time doing repetitive tasks -if, for example, we want to hide the headings in several sheets of the Workbook....