Skip to content

The interface ​

The OpenRiskSim window follows the layout of Excel with Risk Simulator: a ribbon at the top, the spreadsheet in the centre, the model explorer on the left, the results panel on the right and the status bar at the bottom.

Application overview

The ribbon ​

The ribbon has seven tabs. The names in these tables are exactly the ones on screen (English interface).

File ​

GroupButtonWhat it does
WorkbookOpenOpens an .xlsx workbook or a .csv file (Ctrl+O). You can also drag the file onto the window.
ExamplesReady-made models to practise with (see below).
New workbookCreates a blank workbook (Sheet1).
Save & exportSave .xlsxDownloads the workbook with the risk model included (Ctrl+S).
Export reportReport of the last simulation as .xlsx, PDF or HTML. Enabled after running.
PreferencesEspañol / EnglishSwitches the interface language.
Dark theme / Light themeSwitches the appearance.

The bundled examples are:

ExampleWhat it teaches
Project evaluation5-year cash flow with NPV, IRR and payback; price and units negatively correlated. Basis of the tutorial.
Inventory (newsvendor)Poisson demand; decision variable “order quantity”; forecasts profit and fill rate. Great for optimization.
Investment portfolioFour assets with correlated normal/lognormal returns; weights as decision variables.
Product launchDiscrete events: regulatory approval (Bernoulli) and number of distributors (binomial).
Loan & equity cash flowDebt-financed project with a floating rate; equity NPV and IRR and minimum DSCR.

Simulation ​

GroupButtonWhat it does
ProfileNew profileClears the model: removes all assumptions, forecasts, decisions and correlations. The sheet is not changed and the settings are kept.
DefineDefine assumptionAssigns a distribution to the active cell (Alt+A). See Assumptions.
Define forecastMarks the active cell as an output (Alt+F). See Forecasts & decisions.
Define decisionMarks the active cell as a decision variable (Alt+D).
ModelCorrelationsCorrelation matrix between assumptions (Alt+C). Needs at least two enabled assumptions. See Correlations.
SettingsTrials, seed, sampling method, correlations and precision control. See Running.
RunRun / StopRuns the simulation (Alt+R); while running the button becomes Stop (Esc).
StepRuns a single trial and shows the simulated values in the sheet (Alt+S).
ResetClears results and restores the original sheet values (Alt+X).
DefinitionsCopy definition / Paste definition / Delete definitionCopies the active cell's definition and pastes it into every selected cell, or deletes the definitions in the selection.
WindowsResultsShows or hides the results panel.
OverlayOpens the comparison of several forecasts in one chart (after running).
Model explorerShows or hides the left panel.

Analytical tools, Forecasting, Optimization and Finance ​

These four tabs open tools in their own windows:

  • Analytical tools: Tornado, Spider chart, Sensitivity, Scenario table, Distribution fitting, Bootstrap, Hypothesis test, Descriptive statistics, Overlay chart. → Analytical tools
  • Forecasting: Time series, Multiple regression, Stochastic processes. → Forecasting
  • Optimization: Optimization. → Optimization
  • Finance: Project evaluator, NPV/IRR calculator, Loan amortization, Depreciation, Cost of capital, Break-even, Scenario analysis. → Finance

Each tool has a “What does it do?” box with a short explanation and most have an Export to sheet button that copies the results to a new sheet.

Help ​

Quick start (F1), Distribution glossary, Keyboard shortcuts and About (licence and credits).

The spreadsheet ​

The sheet works like Excel: click a cell, type and press Enter. Above it are the name box (shows the active cell; type a reference such as B34 or Proyecto!B34 and press Enter to jump there) and the formula bar. Below are the sheet tabs and the + button (Add sheet).

Right-clicking a cell opens a menu with Define assumption, Define forecast, Define decision, Copy definition, Paste definition, Delete definition and Clear contents.

Cell colours ​

ColourMeaning
GreenAssumption (uncertain input)
BlueForecast (output)
YellowDecision variable

Defined cells also carry a small triangular marker in the corner. (Some workbooks, like the examples, also use a light-yellow fill for fixed “inputs”; that is just sheet formatting.)

Sheet shortcuts ​

KeyAction
F2 or double-clickEdit the active cell
Enter / TabCommit and move down / right (Shift reverses)
EscCancel editing
Shift+arrowsExtend the selection
Ctrl+arrowsJump to the data edge
Ctrl+ASelect the whole sheet
Ctrl+HomeGo to A1
Page Up / Page DownScroll one screen
Ctrl+C / Ctrl+X / Ctrl+VCopy, cut, paste (compatible with Excel and Google Sheets ranges)
Ctrl+Z / Ctrl+YUndo / redo
Delete / BackspaceClear the selection contents

On macOS you can use ⌘ instead of Ctrl. Full list in Keyboard shortcuts.

Formulas ​

The formula engine is Excel-compatible (HyperFormula, almost 400 functions): =SUM(B2:B9), =NPV(B14,C30:G30)+B30, =IRR(B30:G30), =IF(B23>0,1,0), =PMT(…), =VLOOKUP(…)…

Spanish-speaking users can also type formulas as in Spanish Excel — =SUMA(…), =VNA(…), =TIR(…), =SI(…) — with ; as the argument separator. They are translated to English names with commas when committed, which is how .xlsx files store them anyway.

Details to keep in mind

  • With the Spanish interface, numbers typed in cells use a decimal comma (12,5); with the English interface, a decimal point. Inside formulas always use a decimal point (=B4*1.05).
  • As in Excel, NPV discounts from the first value: add the year-0 investment separately (=B30+NPV(rate,C30:G30)).

Model explorer ​

The left panel shows the model tree: Assumptions, Forecasts and Decisions, each with its name, cell and distribution or type. Hovering an item reveals buttons to go to the cell, show the results chart (forecasts), edit and delete. At the bottom it summarises the settings: number of trials, method (MC or LHS), seed and number of correlations.

Results panel ​

After Run, the right panel shows one tab per forecast (e.g. VAN and TIR in the example) plus Overlay. Each forecast has three tabs: Histogram, Statistics and Percentiles. Everything is explained in Interpreting results.

If you change the model or the sheet after simulating, a “Results out of date” notice appears with a Re-run button.

Status bar ​

  • With several numeric cells selected it shows Average, Count and Sum, like Excel.
  • During a simulation it shows progress (Simulating… 45%) and a Stop button.
  • In step mode it shows the current trial with Next trial and Restore values buttons.
  • When finished it shows Trials, Time, Seed, the sampling method and the backend used with its speed (e.g. GPU · apple metal-3 · Metal; see Acceleration), plus warnings such as trials with errors, “precision reached” or the Fallback chip.

Language and theme ​

  • File → Español / English switches the whole interface language (and number formatting: 1.234,56 in Spanish, 1,234.56 in English).
  • File → Dark theme / Light theme switches the appearance.

Both preferences are remembered by the browser.

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