MonteGrid | Articles | Crystal Ball and MonteGrid compared

Crystal Ball and MonteGrid compared

MonteGrid covers the Crystal Ball simulation workflow in Excel for Mac: assumptions, forecasts, rank correlation, precision control, tornado charts and reports in the Crystal Ball layout. It imports Crystal Ball definitions from a full report.

Side by side

Crystal Ball 11.1.3MonteGrid
PlatformWindows 10 or 11, with Excel 2016, 2019 or 2021 for Windows (Oracle).Excel 2024 or Microsoft 365 for Mac, on Apple silicon with macOS 15 or later.
Distributions21, and Custom (Oracle).42, in eight groups.
DefinitionsStored outside the cell formulas.MC_ functions in the cells.
CorrelationRank (Spearman) (Oracle).Rank (Spearman), by the Iman–Conover method, by group or by matrix.
SamplingMonte Carlo and Latin Hypercube (Oracle).Monte Carlo, Latin Hypercube (random or median) and Sobol quasi-Monte Carlo.
Stopping rulePrecision control on confidence intervals (Oracle).Precision control on the mean or a percentile, at 95% confidence.
Tornado chartPercentiles of the variables, 10% to 90%, five test points by default (Oracle).Percentiles of the assumptions at 10%, 30%, 50%, 70% and 90%: the same method and points.
ReportsCreate Report: Full, Assumptions, Forecasts and other types (Oracle).Create Report, in the layout of a Crystal Ball report. Extract Data writes every trial to a workbook.
Other toolsBatch Fit, Tornado Analysis, Bootstrap, Decision Table, Scenario Analysis, 2D Simulation and Data Analysis (Oracle). OptQuest and Predictor in some editions.Not included. MonteGrid covers simulation, sensitivity and reports.
Model import—Imports Crystal Ball definitions from a full report.

Oracle's compatibility list for Crystal Ball 11.1.3 was last published on July 16, 2024. It does not name Excel 2024 or any version of Excel for Mac.

What MonteGrid adds

ItemMonteGrid
Excel for MacMonteGrid runs in Excel for Mac, with no virtual machine and no Windows computer.
DistributionsModified PERT, Trapezoidal, Erlang, Rayleigh, Log-logistic, Inverse Gaussian, Inverse gamma, Fréchet, Chi-squared, F, Laplace, Cauchy, Cosine, Power function, Reciprocal, Beta-binomial and Logarithmic, which are not in Oracle's list. Four distributions from data: Discrete, Cumulative, Histogram and Resample.
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, where MonteGrid's engine calculates the workbook outside Excel.
CorrelationThe rank correlation in the trials is the one requested. MonteGrid converts each target to the normal-score correlation that delivers it.
ModelThe definitions are formulas in the cells, so the workbook holds the whole model.
LicenseOne-time license. Free for one hour each day.

Moving a Crystal Ball model

MonteGrid reads the assumptions and forecasts from a Crystal Ball full report and writes them into the cells. It maps 21 of Crystal Ball's 22 distributions. The tornado chart uses the same method and test points, and the report uses the Crystal Ball layout, so the two reports compare line by line.

The steps and the distribution mapping are in Oracle Crystal Ball on a Mac.

MonteGrid is free for one hour each day. Download MonteGrid.

Sources

  1. Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
  2. Oracle: Distribution Parameter Summary (Crystal Ball User's Guide)
  3. Oracle: Specifying Correlations Between Assumptions (Crystal Ball User's Guide)
  4. Oracle: Simulation Sampling Methods (Crystal Ball Statistical Guide)
  5. Oracle: Precision Control (Crystal Ball User's Guide)
  6. Oracle: Tornado input options (Crystal Ball User's Guide)
  7. Oracle: Basic Steps for Creating Reports (Crystal Ball User's Guide)
  8. Oracle: Crystal Ball tools (Crystal Ball User's Guide, chapter 9)

All articles