Skip to content

Risk Simulator equivalents ​

If you learned with Risk Simulator in Excel for Windows, this table helps you find each feature in OpenRiskSim.

INFO

Risk Simulator is a trademark of Real Options Valuation, Inc. OpenRiskSim is an independent, unaffiliated project that reproduces the general workflow; it is not a copy of their software.

Concepts ​

Risk SimulatorOpenRiskSimNotes
Simulation profileThe workbook's modelOpenRiskSim has one model per workbook. New profile clears it.
Input assumptionAssumption (green cell)Same.
Output forecastForecast (blue cell)Same.
Decision variableDecision variable (yellow cell)Same.
TrialsTrialsSame.
CertaintyCertainty %Two-tail, left-tail, right-tail. The initial certainty (90% by default) can be changed per forecast.
Seed valueFixed seedSame concept; numbers don't match Risk Simulator's because the random generator differs.
Monte Carlo / Latin HypercubeMonte Carlo / Latin hypercube (LHS)LHS is OpenRiskSim's default.
CorrelationsCorrelationsSpearman + Iman–Conover, like Risk Simulator. Edited in a matrix rather than per assumption.
TruncationTruncate the distributionSame.
Precision control (error control)Precision controlOn a forecast's mean.

Simulation menu ​

Risk SimulatorOpenRiskSim
New Simulation ProfileSimulation → New profile
Edit Simulation Profile (trials, seed, correlations)Simulation → Settings
Set Input AssumptionSimulation → Define assumption (Alt+A) or right-click
Set Output ForecastSimulation → Define forecast (Alt+F)
Run SimulationSimulation → Run (Alt+R)
Run Super Speed SimulationSimulation → Settings → Acceleration (Automatic, Compiled formulas or GPU (WebGPU)), then Run. See Acceleration.
Step SimulationSimulation → Step (Alt+S)
Reset SimulationSimulation → Reset (Alt+X)
Copy / Paste / Remove ParameterCopy definition / Paste definition / Delete definition
Edit CorrelationsSimulation → Correlations (Alt+C)
Forecast chart (histogram, cumulative, statistics, percentiles)Results panel → Histogram / Cumulative, Statistics, Percentiles
Overlay chartsOverlay / Analytical tools → Overlay chart
Create ReportFile → Export report (.xlsx, PDF, HTML)
Extract dataSimulation data sheet of the .xlsx report (first 10,000 trials)
Save the profile in the workbookFile → Save .xlsx (hidden _openrisksim sheet)

Analytical tools ​

Risk SimulatorOpenRiskSim
Tornado AnalysisAnalytical tools → Tornado
Spider chartAnalytical tools → Spider chart
Sensitivity Analysis (rank correlation, contribution to variance)Analytical tools → Sensitivity
Scenario Analysis (two-way table)Analytical tools → Scenario table
Distributional Fitting (single variable)Analytical tools → Distribution fitting (or Fit from data… in the assumption dialog)
Bootstrap Nonparametric SimulationAnalytical tools → Bootstrap
Hypothesis TestAnalytical tools → Hypothesis test (Welch's t)
Statistical Analysis / Descriptive statisticsAnalytical tools → Descriptive statistics

Forecasting ​

Risk SimulatorOpenRiskSim
Time-Series Analysis (moving average, exponential smoothing, Holt, Holt–Winters)Forecasting → Time series
ARIMA / Auto ARIMATime series → ARIMA(p, d, q) / Auto-ARIMA
TrendlinesTime series → Trend line
Multiple Regression / Stepwise RegressionForecasting → Multiple regression
Stochastic Processes (Brownian motion, mean reversion, jump diffusion)Forecasting → Stochastic processes
Autocorrelation, seasonality and stationarity testsTime series → ACF / PACF, Decomposition, Diagnostics tabs

Optimization ​

Risk SimulatorOpenRiskSim
Set DecisionSimulation → Define decision
Set ObjectiveOptimization → Objective and Sense
Set ConstraintOptimization → Constraints → Add
Static optimizationOptimization type: Static (deterministic)
Stochastic optimizationOptimization type: Stochastic (with simulation)
Efficient frontierEfficient frontier

Worksheet functions ​

Risk SimulatorOpenRiskSim
RSDistNormal(mean, sd)ORS.NORMAL(mean, sd)
RSDistTriangular(min, mode, max)ORS.TRIANGULAR(min, mode, max)
RSDistUniform(min, max)ORS.UNIFORM(min, max)
RSDistPERT(min, mode, max)ORS.PERT(min, mode, max)
RSDistLognormal(mean, sd)ORS.LOGNORMAL(mean, sd)
Other RS* functionsNot available: define the assumption with the dialog.

Details in Files → ORS.* risk functions.

Risk Simulator files don't carry the model

If you open in OpenRiskSim an .xlsx prepared with Risk Simulator, sheets and formulas load but assumptions and forecasts don't (Risk Simulator stores them in its own format). You'll need to define them again; with Copy definition / Paste definition it's quick. Cells with RS* functions will show errors: replace them with their value.

What OpenRiskSim adds ​

  • Automatic acceleration: multicore CPU, compiled formulas and GPU (WebGPU) on any system (Windows, macOS, Linux), with automatic validation of the results against the sheet and fallback if anything fails; up to 5,000,000 trials. See Acceleration.
  • Configurable confidence levels: initial certainty and confidence of the mean interval per forecast, and up to three levels at once (including values such as 97.5%) for time-series and stochastic-process bands. See Forecasting.
  • Runs in the browser, with no Excel or add-in to install.

What OpenRiskSim doesn't have (yet) ​

  • Multiple simulation profiles per workbook.
  • Alternate parameters (defining a distribution by percentiles, e.g. “Normal with P10 = 80 and P90 = 120”).
  • Multivariate distribution fitting (joint fitting with correlations).
  • Advanced forecasting models: GARCH, Markov chains, J/S curves, splines, non-linear extrapolation, advanced econometrics (panel data, Box–Cox…).
  • Dynamic optimization and real options (Real Options SLS).
  • Scatter plots of assumptions vs forecasts inside the results window (you can build them from the exported data).

Need any of these? Open an issue or contribute.

Why aren't the numbers identical to Risk Simulator's? ​

A Monte Carlo simulation produces estimates based on random numbers. Two programs (or two runs with different seeds) give slightly different results even with the same model. With enough trials (5,000–10,000) differences should be small: tenths of a percentage point in probabilities and about one standard error in the mean. If you see large differences, check that distributions and parameters are exactly the same (especially Lognormal, PERT and truncation) and that correlations are applied. See also the FAQ.

Released under the GPL-3.0 license · © 2026 Fernando Daza and contributors