MonteGrid | Articles | @RISK and MonteGrid compared
@RISK and MonteGrid compared
MonteGrid runs @RISK-style models in Excel for Mac: distribution functions in the cells, rank correlation matrices, tornado charts and rank correlations. It converts @RISK functions to MonteGrid in place.
Updated
Side by side
| @RISK | MonteGrid | |
|---|---|---|
| Platform | Windows 8, 10 or 11, with Excel for Windows (License Installation Guide). | Excel 2024 or Microsoft 365 for Mac, on Apple silicon with macOS 15 or later. |
| Distributions | Over 90 built-in distribution functions (@RISK page). | 42, in eight groups. MonteGrid converts 29 @RISK distribution functions. |
| Definitions | Risk functions in the cells. | MC_ functions in the cells. |
| Correlation | Rank correlation matrices (RiskCorrmat, Lumivero), and copulas. | Rank (Spearman) correlation by the Iman–Conover method, by group or by matrix. |
| Sampling | Latin Hypercube, the recommended setting, and Monte Carlo (Lumivero). | Monte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo. |
| Stopping rule | Convergence monitoring, with a tolerance and a confidence level (Lumivero). | Precision control on the mean or a percentile, at 95% confidence. |
| Sensitivity | Tornado graphs by change in output statistic, regression, Spearman correlation or contribution to variance (Lumivero). | A tornado chart by Crystal Ball's method, and the Spearman rank correlation of each assumption with the forecast. |
| Calculation | "100% Excel calculations for simulation". | MonteGrid's engine calculates the workbook outside Excel (Fast run mode), or Excel recalculates each trial (Excel run mode). |
| Optimization and time series | RISKOptimizer and time-series simulation, in the Industrial edition. | Not included. MonteGrid covers simulation, sensitivity and reports. |
| Model conversion | — | Converts @RISK functions to MonteGrid in place. |
What MonteGrid adds
| Item | MonteGrid |
|---|---|
| Excel for Mac | MonteGrid runs in Excel for Mac, with no virtual machine and no Windows computer. |
| Sampling | Latin Hypercube (median) and Sobol quasi-Monte Carlo, in addition to Monte Carlo and Latin Hypercube. |
| Trials | Up to 1,000,000,000 in the Fast run mode. |
| Correlation | The rank correlation in the trials is the one requested. MonteGrid converts each target to the normal-score correlation that delivers it. |
| Reports | A report workbook in the layout of a Crystal Ball report, and every trial to a workbook with Extract Data. |
| License | One-time license. Free for one hour each day. |
Converting an @RISK model
MonteGrid rewrites each @RISK cell in place: 29 distribution functions with their RiskName, RiskStatic and RiskTruncate properties, RiskOutput forecasts, RiskMakeInput inputs and RiskCorrmat matrices. @RISK statistic functions such as RiskMean stay as they are. The plan lists every cell that does not convert, with the reason.
The steps and the function mapping are in Lumivero @RISK on a Mac.
MonteGrid is free for one hour each day. Download MonteGrid.