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.
Updated
Comparison
| MonteGrid | Crystal Ball 11.1.3 | @RISK | |
|---|---|---|---|
| Platform | Excel 2024 or Microsoft 365 for Mac. | Excel 2016, 2019 or 2021 for Windows (Oracle). | Excel for Windows (Lumivero). |
| Distributions | 42, in eight groups. | 21, and Custom (Oracle). | Over 90 (Lumivero). |
| Model definitions | MC_ functions in the cells. | Outside the cell formulas. | Risk functions in the cells. |
| Correlation | Rank 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. |
| Sampling | Monte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo. | Monte Carlo and Latin Hypercube (Oracle). | Latin Hypercube and Monte Carlo (Lumivero). |
| Stopping rule | Precision control on the mean or a percentile. | Precision control (Oracle). | Convergence monitoring (Lumivero). |
| Sensitivity | A 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 models | Imports 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
- Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
- Lumivero: @RISK License Installation Guide (8.10)
- Oracle: Distribution Parameter Summary (Crystal Ball User's Guide)
- Lumivero: @RISK product page
- Oracle: Specifying Correlations Between Assumptions (Crystal Ball User's Guide)
- Lumivero: RiskCorrmat (@RISK help)
- Oracle: Simulation Sampling Methods (Crystal Ball Statistical Guide)
- Lumivero: Sampling Settings (@RISK help)
- Oracle: Precision Control (Crystal Ball User's Guide)
- Lumivero: Convergence Settings (@RISK help)
- Oracle: Tornado input options (Crystal Ball User's Guide)
- Lumivero: Sensitivity Analysis (@RISK help)