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.

Side by side

@RISKMonteGrid
PlatformWindows 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.
DistributionsOver 90 built-in distribution functions (@RISK page).42, in eight groups. MonteGrid converts 29 @RISK distribution functions.
DefinitionsRisk functions in the cells.MC_ functions in the cells.
CorrelationRank correlation matrices (RiskCorrmat, Lumivero), and copulas.Rank (Spearman) correlation by the Iman–Conover method, by group or by matrix.
SamplingLatin Hypercube, the recommended setting, and Monte Carlo (Lumivero).Monte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo.
Stopping ruleConvergence monitoring, with a tolerance and a confidence level (Lumivero).Precision control on the mean or a percentile, at 95% confidence.
SensitivityTornado 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 seriesRISKOptimizer 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

ItemMonteGrid
Excel for MacMonteGrid runs in Excel for Mac, with no virtual machine and no Windows computer.
SamplingLatin Hypercube (median) and Sobol quasi-Monte Carlo, in addition to Monte Carlo and Latin Hypercube.
TrialsUp to 1,000,000,000 in the Fast run mode.
CorrelationThe rank correlation in the trials is the one requested. MonteGrid converts each target to the normal-score correlation that delivers it.
ReportsA report workbook in the layout of a Crystal Ball report, and every trial to a workbook with Extract Data.
LicenseOne-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.

Sources

  1. Lumivero: @RISK License Installation Guide (8.10)
  2. Lumivero: @RISK product page
  3. Lumivero: RiskCorrmat (@RISK help)
  4. Lumivero: Sampling Settings (@RISK help)
  5. Lumivero: Convergence Settings (@RISK help)
  6. Lumivero: Sensitivity Analysis (@RISK help)

All articles