MonteGrid | Articles | How to choose a Monte Carlo add-in for Excel

How to choose a Monte Carlo add-in for Excel

Compare Monte Carlo add-ins for Excel on eight points: platform, distributions, model definitions, correlation, sampling, stopping rule, sensitivity and the move of existing models. The table compares MonteGrid with Crystal Ball and @RISK on each.

Comparison

MonteGridCrystal Ball 11.1.3@RISK
PlatformExcel 2024 or Microsoft 365 for Mac.Excel 2016, 2019 or 2021 for Windows (Oracle).Excel for Windows (Lumivero).
Distributions42, in eight groups.21, and Custom (Oracle).Over 90 (Lumivero).
Model definitionsMC_ functions in the cells.Outside the cell formulas.Risk functions in the cells.
CorrelationRank correlation by group or by matrix. The rank correlation in the trials is the one requested.Rank (Spearman) (Oracle).Rank correlation matrices (Lumivero) and copulas.
SamplingMonte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo.Monte Carlo and Latin Hypercube (Oracle).Latin Hypercube and Monte Carlo (Lumivero).
Stopping rulePrecision control on the mean or a percentile.Precision control (Oracle).Convergence monitoring (Lumivero).
SensitivityA tornado chart by Crystal Ball's method, and rank correlations.The tornado tool: percentiles 10% to 90%, five test points by default (Oracle).Tornado graphs by four methods (Lumivero).
Existing modelsImports Crystal Ball definitions. Converts @RISK functions in place.——

On a Mac

Of the three, MonteGrid is the one that runs in Excel for Mac. Crystal Ball and @RISK run in Excel for Windows, so on a Mac they need a Windows virtual machine or a remote Windows computer.

For a Crystal Ball or @RISK user who works on a Mac, MonteGrid takes over the model: it imports the Crystal Ball definitions from a full report, or converts the @RISK functions in place. The tornado chart uses Crystal Ball's method and test points, and the report uses the Crystal Ball layout.

The details are in Crystal Ball and MonteGrid compared and @RISK and MonteGrid compared.

Scope and license

MonteGrid covers simulation, sensitivity and reports. It does not include optimization or time-series forecasting.

MonteGrid has a one-time license and is free for one hour each day. Download MonteGrid.

Sources

  1. Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
  2. Lumivero: @RISK License Installation Guide (8.10)
  3. Oracle: Distribution Parameter Summary (Crystal Ball User's Guide)
  4. Lumivero: @RISK product page
  5. Oracle: Specifying Correlations Between Assumptions (Crystal Ball User's Guide)
  6. Lumivero: RiskCorrmat (@RISK help)
  7. Oracle: Simulation Sampling Methods (Crystal Ball Statistical Guide)
  8. Lumivero: Sampling Settings (@RISK help)
  9. Oracle: Precision Control (Crystal Ball User's Guide)
  10. Lumivero: Convergence Settings (@RISK help)
  11. Oracle: Tornado input options (Crystal Ball User's Guide)
  12. Lumivero: Sensitivity Analysis (@RISK help)

All articles