8 drivers found on the Scenarios sheet, each with base value and range
Output resolves — Free Cash Flow · Model sheet
No circular references
2 correlations declared — applied to every run
Uploaded 2 Sep · v1Source file is never overwritten
Drop a workbook, or browse
Uploading creates v4 as a new scenario. v3 stays available exactly as it is.
What Studio reads
Drivers sheet — one row per assumption: base, shape, low, high
Model sheet — untouched; scenarios flow through the template's driver logic
Output cell — the number the 10,000 scenarios are counted on
A model is loaded, so every step ahead is live.
Step 02 · Assumptions
Give each driver a range you'd accept.
A low and a high per driver — the 10,000 scenarios draw from these ranges. Everything else in the workbook holds at plan.
Drivers
Click a row to edit the full detail
Driver
Base
Range
Low
High
Cell
8 drivers · every other cell holds at planShapes — Uniform: hard bounds · Triangular: bounds, peak at base · Normal: 90% window
CorrelationsApplied to every run
ρ links two drivers' positions in their ranges: +1 move together · 0 independent · −1 opposite. Each scenario draws one shared set of linked chance numbers and translates each into its driver's own range.
Ranges look sensible. Run when ready — it takes seconds.
Step 03 · Logic
How the number is built.
The template, unfolded. Follow FY EBITDA back to the drivers it stands on — click any block for the formula behind it. Studio reads this structure; it never rewrites it.
FY EBITDA · decomposition
Values at plan · marks a driver with a range
Structure looks right? Run the scenarios through it.
Assumptions changed since the last run — these results are from the previous ranges.
Step 04 · Outcomes
Where 10,000 scenarios landed.
The chance of hitting budget, the median outcome and the downside — counted, not guessed.
10,000 scenarios
FY EBITDA across 10,000 scenarios
Each bar counts scenarios
Percentiles
Output build through the year
Bridge: how the scenario differs from the plan
from
to
Each bar: one driver at its value in that scenario, the rest at plan · interaction closes the gap
Next: which assumption is doing this to the number.
Assumptions changed since the last run — this ranking is from the previous ranges.
Step 05 · Impact of assumptions
What actually moves the number.
Each bar is the swing in FY EBITDA when one driver runs from its low to its high while the rest hold at plan. Click a bar for the plain version.
Swing on FY EBITDA · low → high per driverif it lands lowif it lands high
One driver moved at a time · correlations off for this view
What-if — a driver lands in a specific rangeEverything else holds at your current assumptions
Iflands between%and%of plan:
Work it backwards — the driver value a target needsEverything else at plan
At what value ofdoesequal$M?
Happy with the story? Put it back in Excel.
Assumptions changed since the last run — the report would carry the previous results.
Step 06 · Export
Take the answer back to Excel.
A report workbook lands next to your source file. The source is never overwritten; every version stays available.
Excel reportresults.xlsx
Built from the latest run
Version historySource files kept as-is
Version
Uploaded
Runs
Chance of budget
v1 · douglas-dynamics-fy-plan.xlsxLive
2 Sep
0
—
You're set. Change an assumption any time and run again — versions keep the trail.