Calculations run locally in this browser or Excel add-in. This version evaluates the model expression below; it does not simulate arbitrary workbook formulas.
1. Inputs
Excel: select the header and all input rows (five columns), then read the table. You can also edit the table here. Changes here do not alter the source cells.
Normal: mean, standard deviation. Uniform: minimum, maximum. Triangular: minimum, mode, maximum. Fixed: value.
| Name | Distribution | P1 | P2 | P3 |
|---|
Source: editable table
2. Analysis
Use input names, + − * / **, parentheses, abs, min, max, sqrt, log and exp. Powers need a constant exponent from 0 to 10.
Monte Carlo uses independent inputs. Sensitivity varies one input at a time between its P5 and P95 with other inputs held at their means. It is not a global sensitivity measure.
Ready. The first run downloads the Python runtime.
3. Results
Connection and scope
This interface is served by your installed WordPress plugin. In Excel, Office.js connects it to the active workbook. Model values stay in memory and are not posted to WordPress. Office.js and Pyodide load from Microsoft and jsDelivr. Internet and HTTPS are required.
Included: four distributions, Monte Carlo, one-at-a-time sensitivity and descriptive statistics. Decision trees, optimisation, fitting, correlated sampling, custom worksheet functions and arbitrary Python script uploads are not included in this connected pilot. Your desktop VS11 build remains a separate download.