THE SENSITIVITY TOOLKIT


SOLVER SENSITIVITY: DOWNLOADS (Developer's Release)

As of September, 2014 a new version of Solver Sensitivity has been developed to support Excel 2013.

Instructions

  1. Download SolverSensitivity.zip. 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 created to bring the most powerful tools of sensitivity analysis to the spreadsheet. The Toolkit supports four different forms of sensitivity analysis:

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.

 
tornado

For details and examples of how to use the Sensitivity Toolkit for modeling 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.