The Sensitivity Toolkit


Installation Instructions

  1. Download Create a directory in your documents folder and give it a meaningful name (e.g. Sensitivity) and save the file in that folder. Right click on the file and extract SolverSensitivity.xlam to the directory.
  2. Check the security setting for your copy of Excel. Click File | Options | Trust Center | Trust Center Settings and then make sure the checkbox for Trust access to the VBA object model is checked. Click OK.
  3. Install Solver Sensitivity. Click File | Options | Add-Ins. At the bottom of the right pane is a dropdown box and Excel Add-ins is usually selected as the default, else select it. Click the Go... button. Click the Browse... button and navigate to where you stored SolverSensitivity.xlam. You will be asked if you would like to copy the file to your Addins folder, click No. Click OK. Solver Sensitivity should now be available under the Sensitivity Toolkit submenu of your Add-Ins menu.


The Sensitivity Toolkit was first developed in 2002 and went through several revisions as a part of Tuck's curriculum. The Toolkit has always been Free software and in completely unprotected with full source code available so that users can modify the software.

Data Sensitivity creates a table and chart to show how an output cell varies with changes in one (or two) inputs. In Tornado Chart, a set of parameters is varied from low to high and the results for a single output cell are reported. Solver Sensitivity runs the optimization program Solver on a spreadsheet for a set of values for one (or two) parameters. Similarly, Crystal Ball Sensitivity runs the simulation program Crystal Ball on a spreadsheet for a set of values for one (or two) parameters.

We have continued to update Data Sensitivity, Tornado Chart, and Solver Sensitivity for both research and classroom use. We no longer have a license for Crystal Ball however, so that component of the Toolkit is unlikely to be functional.

Using the Sensitivity Toolkit

The Sensitivity Toolkit was created to bring the most powerful tools of sensitivity analysis to the spreadsheet. The Toolkit supports four different forms of sensitivity analysis:

Sensitivity Toolkit Support

The Sensitivity Toolkit is free software, but we cannot offer any promise of support. We will try and answer questions about the Toolkit and give advice, but be advised that there may be a considerable delay before we can respond. Please direct all inquires to:

Toolkit Authors

For details and examples of how to conduct sensitivity analysis with Excel, visit the web sites for these books:

Management Science: The Art of Modeling with Spreadsheets, 4th Edition (October 2013, ©2014)

Optimization Modeling with Spreadsheets, 2nd Edition (May 2011, ©2011)

Both of these volumes are now available from Wiley in hardcover.