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.
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:
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: firstname.lastname@example.org.
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.