MonteGrid | Articles | Oracle Crystal Ball on a Mac

Oracle Crystal Ball on a Mac

Oracle Crystal Ball requires Excel for Windows. On a Mac, a Crystal Ball model runs in Windows, or in MonteGrid after an import of its definitions.

Platform support

Oracle lists the platforms for Crystal Ball 11.1.3 in Updated Compatible Versions of Microsoft Products, last published on July 16, 2024.

ItemSupported
WindowsWindows 10 and Windows 11. Windows Server 2016, 2019 and 2022.
ExcelExcel 2016, 2019 and 2021, 32-bit or 64-bit.
Office 365The desktop Excel of an Office 365 plan, installed on a supported Windows system.

Crystal Ball is not supported for Office Web Apps. The list names no version of macOS or of Excel for Mac.

Options on a Mac

Crystal Ball runs on Windows. On a Mac, Windows runs in a virtual machine or on a remote computer. MonteGrid runs in Excel for Mac.

OptionRequirementsNotes
Parallels DesktopWindows 11 Pro or Enterprise, Excel for Windows and a Crystal Ball license.Microsoft authorizes Parallels Desktop 18, 19 and 20 to run the Arm version of Windows 11 Pro and Enterprise on Macs with M1, M2 and M3 chips. On these Macs, Windows runs x64 and x86 apps in emulation. Oracle's list does not mention Windows on Arm.
Windows 365 Cloud PCA Windows 365 subscription, Excel for Windows and a Crystal Ball license.Microsoft streams Windows 11 to the Mac. Crystal Ball runs on the Cloud PC.
Boot CampA Mac with an Intel processor.Boot Camp requires an Intel processor. Macs with Apple silicon cannot use it.
MonteGridExcel 2024 or Microsoft 365 for Mac. A Mac with Apple silicon and macOS 15 or later.MonteGrid runs in Excel for Mac. It imports Crystal Ball definitions from a full report.

What MonteGrid imports

Crystal Ball stores its assumption definitions outside the cell formulas. MonteGrid reads them from a Crystal Ball full report and writes them into the cells as MC_ functions. The Mac does not need Crystal Ball.

In the full reportIn MonteGrid
An assumption with one of 21 distributionsAn MC_ function in the same cell, with the assumption's name. The cell keeps the value it shows.
A forecastThe cell formula in MC_OUTPUT, with the forecast's name.
An assumption with a Custom distributionNot imported. The cell keeps its value. The import lists the cell and the reason.
A Lognormal, Gamma or Weibull assumption with a location other than 0Not imported. The cell keeps its value. The import lists the cell and the reason.
Correlations and correlation matricesNot imported. The import gives their number. Define them with Define Correlation.
Decision variablesNot imported.
Forecast statisticsShown after the import: the Crystal Ball mean and standard deviation, for comparison.

MonteGrid checks every cell that the report names before it writes. If an assumption cell holds a formula, or a forecast cell is empty or holds text, MonteGrid imports nothing and lists the cells. This occurs when the workbook changed after Crystal Ball created the report, or when the report is from another workbook.

To import a Crystal Ball model:

  1. On the Windows computer, open the model in Excel with Crystal Ball and run the simulation.
  2. On the Crystal Ball ribbon, in the Analyze group, click the upper half of Create Report.
  3. Click Full, then click OK. Crystal Ball creates the report as an Excel worksheet.
  4. Save the report as its own .xlsx workbook.
  5. Copy the model and the report to the Mac.
  6. Open the model in Excel. On the MonteGrid tab, click Import Definitions.
  7. Click Choose report… and select the report.
  8. Click Import.
  9. Save the workbook.

The procedure with screens is in Convert from Crystal Ball or @RISK.

Distribution mapping

Crystal Ball names and parameters are from Oracle's Distribution Parameter Summary. MonteGrid parameters are in the order of the MC_ function.

Crystal BallCrystal Ball parametersMonteGrid function
BetaAlpha, beta, minimum, maximumMC_BETA(alpha, beta, min, max)
BetaPERTMinimum, likeliest, maximumMC_PERT(min, likely, max)
ExponentialRateMC_EXPON(rate)
GammaLocation, scale, shapeMC_GAMMA(shape, scale). Location 0 only.
LogisticMean, scaleMC_LOGISTIC(mean, scale)
LognormalLocation, mean, standard deviationMC_LOGNORMAL(mean, sd). Location 0 only.
Maximum extremeLikeliest, scaleMC_GUMBELMAX(mode, scale)
Minimum extremeLikeliest, scaleMC_GUMBELMIN(mode, scale)
NormalMean, standard deviationMC_NORMAL(mean, sd)
ParetoLocation, shapeMC_PARETO(xmin, shape)
Student's tMidpoint, scale, degrees of freedomMC_STUDENTT(mid, scale, df)
TriangularMinimum, likeliest, maximumMC_TRIANG(min, likely, max)
UniformMinimum, maximumMC_UNIFORM(min, max)
WeibullLocation, scale, shapeMC_WEIBULL(shape, scale). Location 0 only.
BinomialProbability, trialsMC_BINOMIAL(n, p)
Discrete UniformMinimum, maximumMC_DUNIFORM(min, max)
GeometricProbabilityMC_GEOMETRIC(p)
Hyper-geometricSuccess, trials, populationMC_HYPGEOM(population, successes, draws)
Negative binomialProbability, shapeMC_NEGBINOM(r, p)
PoissonRateMC_POISSON(rate)
Yes-NoProbabilityMC_BERNOULLI(p)
CustomUser-definedNot imported.

Note: Each MC_ function ends with MC_STATIC, which holds the value the cell shows outside a simulation and the assumption's name. For example: =MC_TRIANG(420,450,470,MC_STATIC(450,"Unit Price","")).

Check the import

Run the model in MonteGrid with the number of trials used in Crystal Ball. Compare the forecast statistics with the report. They differ within sampling error, because the two tools use different random numbers.

Define by hand each assumption that was not imported. Define the correlations with Define Correlation, as in Correlate assumptions.

Sources

  1. Oracle: Updated Compatible Versions of Microsoft Products (Crystal Ball 11.1.3)
  2. Microsoft: Options for using Windows 11 with Mac computers with Apple M1, M2, and M3 chips
  3. Apple: Install Windows 10 on your Mac with Boot Camp Assistant
  4. Oracle: Basic Steps for Creating Reports (Crystal Ball User's Guide)
  5. Oracle: Distribution Parameter Summary (Crystal Ball User's Guide)

All articles