OR/MS Today, August 2002

Spreadsheet Add-Ins for OR/MS
Software Survey


Simulation — Table 2

Product Commercial Limitations Educational Limitations Comments
XLSim - - Easy to use, includes Dr. Savages's Tutorial on understanding uncertainty with forward by Peter Bernstein, Author of Against the Gods. Free trial available at www.XLSim.com.
Crystal Ball 2000 Standard Edition No limitations, registration number required. All academic licenses are valid for one year. Academic software pricing includes installation support. General technical support on the product is not available. An Excel Add-in that uses Monte Carlo simulation to analyze risks and uncertainties associated with spreadsheet models. Features include sensitivity analysis, correlation, tornado analysis, precision control, and distribution fitting to historical data.
@RISK for Excel - Depends on educational option Uses Monte Carlo simulation to see all possible outcomes in spreadsheet models, graphs and reports, distribution viewing, distribution fitting, sensitivity and scenario analyses, etc.
RISKOptimizer - Depends on educational option Combines Monte Carlo simulation with Genetic Algorithm optimization to solve problems. Applications range from manufacturing to financial portfolios to the traveling salesman, etc. Supports @RISK functions in the model, and runs a Monte Carlo simulation
@RISK for Projects - Depends on educational option Analyze risk and uncertainty in Project schedules and resources. New graphs and reports, distribution fitting and viewing, sensitivity and scenario analysis round out the power. Probablistic braching and conditional modeling. `
@RISK Developer's Kit - Depends on educational option Use all the analytical and ease-of-use features of @RISK, and run your application over a web or network server. Easily access function with the ActiveX interface.

Spreadsheet Add-Ins for OR/MS Software Survey Pages:
Introduction | Optimization: Table 1, Table 2 | Simulation: Table 1, Table 2 | Decision Analysis: Table 1, Table 2 | Forecasting: Table 1, Table 2 | Queueing Analysis: Table 1, Table 2 | Suites: Table 1, Table 2 | Vendors | Freeware | Application Summaries | Accompanying Article



E-mail to the Editorial Department of OR/MS Today: orms@lionhrtpub.com


OR/MS Today copyright © 2002 by the Institute for Operations Research and the Management Sciences. All rights reserved.


Lionheart Publishing, Inc.
506 Roswell Street, Suite 220, Marietta, GA 30060, USA
Phone: 770-431-0867 | Fax: 770-432-6969
E-mail: lpi@lionhrtpub.com
URL: http://www.lionhrtpub.com


Web Site © Copyright 2002 by Lionheart Publishing, Inc. All rights reserved.