Excel workbook simulation
Use the uncertain-input distributions below to drive numeric cells in your Excel model. Link fixed assumptions if you want their table values applied during the run, then select the formula cells to record.
| Role / name | Excel cell |
|---|
Input and fixed cells must contain numbers. Output cells contain your Excel calculations. Unlinked workbook assumptions retain their existing values. Start with 100 trials; workbook recalculation is slower than Python models. This pilot excludes RISKPY formulas, volatile random/time formulas and external-workbook links in the model workbook. Save a copy before your first run; avoid editing the workbook while it runs.
Worksheet functions
132 core functions, 37 Pascal migration names, 17 advanced samplers and a vector sampling function. Type =RISKPY.NORMAL(100,15) or =RISKPY.NORMAL.CDF(100,100,15) in a cell. Function catalogue and examples
Random functions recalculate with Excel. A fixed optional seed repeats that cell sample. Worksheet formulas do not automatically record simulation trials; the Python-model simulation below is separate.
01 Simulation
02 Uncertain inputs
| Name | Distribution |
|---|
Fixed assumptions
| Name | Value |
|---|
Input correlation
Monte Carlo only. The matrix must be symmetric, with ones on its diagonal. Rows follow the input order. This is the Gaussian copula's latent-normal correlation.
03 Your Python script
Write your own model, open an existing .py file, or edit a worked example. A script defines model(inputs, constants) and returns named output arrays.
Current script:
View or edit Python script
NumPy is available as np and SciPy distributions as stats. Inputs contain one value per trial. Opened files stay in the local add-in; Run simulation executes the script.
04 Results
Outcome distribution
Cumulative probability
Sensitivity • Spearman rank correlation
Rank correlation measures association, not causal contribution or a variance decomposition. Correlated inputs can confound this ranking.
Summary uses all trials. Draw export includes the first 20,000 trials at most.