Spreadsheet Analytics

 

 Masagung Graduate School of Management                                                                        Updated: November 15, 2004

Home
Algorithms
Model Implementations
Sensitivity Analysis
Software We'd Like to See
Spreadsheet Engineering
Spreadsheet Research
Conferences & Training
Books & Readings
Textbooks
Sources for Books
Other Resources

Sensitivity Suites

The Sensitivity Toolkit

Authors:  Ken Baker, Steve Powell, and Bob Burnham

Publisher: Tuck School of Business at Dartmouth College

Contact:  sensitivity.toolkit@dartmouth.edu

 

Author/Publisher Statement:  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, Tornado Chart, Solver Sensitivity, and Crystal Ball Sensitivity.

 

Editorial Comments: This is currently the most flexible and powerful sensitivity suite we know of. The alpha test version was excellent. The final version of the toolkit requires a downgrade of Visual Basic security within Excel by choosing "Trust access to Visual Basic Project." Because of this requirement, we did not review the final version, though we anticipate that it is excellent. The toolkit is also bundled with Powel and Baker's text, The Art of Modeling with Spreadsheets: Management Science, Spreadsheet Engineering, and Modeling Craft.

SensIt

Author:  Mike Middleton, Ph.D.

Publisher:  Decision Support Services

Contact:  support@treeplan.com

2105 Buchanan Street, #1
San Francisco, CA 94115.

 

Author/Publisher Statement:  A sensitivity analysis Add-In for Excel. SensIt performs sensitivity analysis on your worksheet what-if model and creates simple plots, spider charts, and tornado charts. Sensitivity analysis helps you determine which of your input assumptions are critical.

Solver Table

Author:  Chris Albright

Publisher: Kelley School of Business, Indiana University

 

Author/Publisher Statement:  This Excel add-in, available as a free download from the above link, works much like an Excel data table. It allows a user to vary any single input, or any pair of inputs, in a Solver optimization model and capture any selected outputs from the corresponding optimization runs.

Tornado Chart Software

Tornado Chart Add-In

Author: Ken Baker, Steve Powell, and Tuck Computing
Publisher: Tuck School of Business at Dartmouth College

Contact:  sensitivity.toolkit@dartmouth.edu

 

Author/Publisher Statement: 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, Tornado Chart, Solver Sensitivity, and Crystal Ball Sensitivity.

 

Editorial Comments:  The Tornado Chart Add-in is part of Ken Baker, Steve Powell, and Bob Burnham' s Sensitivity Tool Kit. Version 1 was used successfully in Fall 2001. Version 2.0.1c is currently in Alpha test. It has a high level of functionality, a well-designed user interface, and good documentation through the Help feature. To use the software as a Beta tester, contact the Authors.

Crystal Ball

Contact:  Decisioneering, Inc.
1515 Arapahoe Street, Suite 1311
Denver, Colorado, USA 80202
1-800-289-2550

 

Editorial Comments:  Crystal Ball has a Tornado Chart Tool

Spreadsheet Add-Ins Survey

OR/MS Today

Software Vendor Pricing Tables

 

DISCLAIMER

The products and services on this page are provided for informational purposes only. No endorsement is implied. Your mileage may vary. No warranty express or implied is provided. There is no guarantee that the information provided here is current or accurate. Use these links and the associated products or services at your own risk.

 

 

Home Algorithms Model Implementations Sensitivity Analysis Software We'd Like to See Spreadsheet Engineering Spreadsheet Research Conferences & Training Books & Readings Textbooks Sources for Books Other Resources