We recently wrote about why it's important to account for uncertainty when building models and forecasts. (Causal is a good way to do it!)
You're sold, but you've invested a lot of time into your spreadsheet models, and you don't want to move them into a new tool yet. That's okay — you can now account for uncertainty without leaving your spreadsheet, with the Causal Scenarios add-on for Google Sheets.
How it works
Causal Scenarios lets you define ranges for your model's assumptions, and the add-on runs hundreds of simulations to show you the range of possible scenarios.
Step 1: Define your inputs
Your model will have various uncertain assumptions. For each, select its cell and enter the plausible range of values that the assumption could take on.
![](https://cdn.prod.website-files.com/61eff6b3236cf9057b6c1fac/6200ffb73e9f3ee2190d68c3_5e9f1a078229a88aeb7ad64e_ScreenFlow.gif)
Step 2: Select your outputs
Select a cell or range of cells for the main outputs of your model.
![](https://cdn.prod.website-files.com/61eff6b3236cf9057b6c1fac/6200ffb89638bbe2e1fd3fc1_5e9f1a1543f83276f7646b5c_sheets-output.gif)
Step 3: Run the simulation
Causal uses your input ranges to run simulations, determining the range of possible values for your outputs.
![](https://cdn.prod.website-files.com/61eff6b3236cf9057b6c1fac/6200ffb7e7b948316e96ff39_5e9f1a21004d7576059f7105_sheets-simulation.gif)
And of course, if you find the add-on useful, then you may find Causal useful too. Let us know what you think: hi@causal.app.