Repository navigation
The scenario file
cleorf92 edited this page Sep 24, 2026
·
1 revision
Before you start: this and the next pages are a reference for each sheet. To understand what you are filling in, read How aiphoria works and Processes, flows and stocks first.
aiphoria reads the whole model from one Excel scenario file (also called the settings file). Using Excel means:
- only one file per model, with one sheet for each type of data;
- the model is easy to share and review;
- Excel data validation can catch simple errors before you run aiphoria.
The easiest way to start is to change the example scenario step by step, or to fill in the empty template. Both are on Home. They already contain the data validation.
| Sheet | Contains | Reference |
|---|---|---|
| Settings | model settings (years, units, options) | Settings sheet |
| Processes | processes and stock lifetimes | Processes sheet |
| Flows | flows for each year, and indicator factors | Flows sheet |
| Stock lifetime overrides | changes to stock lifetimes during the simulation | Other sheets |
| Process positions | process positions in the Sankey graph | Other sheets |
| Scenarios | alternative scenarios (flow modifiers) | Scenarios sheet |
| Colors | colours for transformation stages | Other sheets |
| Data validation parameters | lists used by Excel data validation only; not read by aiphoria | – |
You can rename the sheets. Tell aiphoria the new names in the Settings sheet:
| Sheet | Parameter |
|---|---|
| Processes | sheet_name_processes |
| Flows | sheet_name_flows |
| Process positions | sheet_name_process_positions |
| Stock lifetime overrides | sheet_name_stock_lifetime_overrides |
| Scenarios | sheet_name_scenarios |
| Colors | sheet_name_colors |
-
Header row and rows to skip. Parameters such as
skip_num_rows_flowstell aiphoria how many rows to skip at the top of a sheet. The header row must be the first row that is read. -
Ignored columns. Parameters such as
ignore_columns_flowslist columns that aiphoria skips (for exampleA,M,N). Use them for your own notes or helper columns. All other columns must be in the order given on the sheet pages. -
IDs. aiphoria builds the process ID from the process name and location (
Name:Location) and the flow ID from the source and target process IDs. The example file uses Excel formulas to build these IDs for you. - No spaces in names. Spaces in process names can cause errors.
- Settings: years, baseline value name and unit (see Settings sheet).
- Processes: all processes, with lifetimes for the stocks.
- Flows: flows for at least the first year; missing years can be filled in automatically.
- Run the baseline and check it (virtual flows show where your data do not balance).
- Scenarios, Stock lifetime overrides, Process positions, and Colors as needed.
Next: Settings sheet
Getting started
Concepts
Building a scenario file
Results
Help