Repository navigation
Scenarios sheet
cleorf92 edited this page Sep 24, 2026
·
1 revision
Before you start: read Scenarios and scenario modes. It explains flow modifiers, opposite changes, and the constrained and unconstrained modes.

In this sheet you define alternative scenarios. Each row changes one flow. All rows with the same scenario name form
one scenario. aiphoria reads this sheet only if use_scenarios is TRUE in the Settings sheet.
The column order matters. Columns listed in ignore_columns_scenarios are skipped.
| Column | Name | Description |
|---|---|---|
| A | (ignored) | Free column for your own notes |
| B | Scenario name | Rows with the same name belong to the same scenario |
| C | Source process ID | Source process of the flow to change |
| D | Target process ID | Target process of the flow to change. Must be an outflow of the source process. |
| E | Change in value (delta) | How much the flow changes over the year range. Fill in this or column F. |
| F | Target value | Value the flow reaches in the end year. Fill in this or column E. |
| G | Change type |
Value (absolute change) or % (proportional change) |
| H | Start year (included) | First year of the change |
| I | End year (included) | Last year of the change |
| J | Function type | How the change develops over the years: Constant, Linear, Exponential, or Sigmoid
|
| K | Apply to targets |
TRUE (default): apply the opposite change to other outflows of the source process so it stays balanced. FALSE: change only this flow. |
| L, M, … | Target process ID (where the opposite change is applied) | Optional. Outflows of the same source process that take the opposite change. You can add several of these columns. If empty, all other outflows share the change. |
The example file has one row:
| Scenario name | Source process ID | Target process ID | Change in value (delta) | Target value | Change type | Start year | End year | Function type | Apply to targets |
|---|---|---|---|---|---|---|---|---|---|
| Reduce sawmilling residues by 50% | Sawmilling:FI | Residues:FI | −50 | % | 2025 | 2030 | Linear | TRUE |
The residue flow goes down in a straight line from 10 Mm³ in 2025 to 5 Mm³ in 2030, and the wood that is no longer turned into residues goes to the other outflows of sawmilling.
Next: Other sheets
Getting started
Concepts
Building a scenario file
Results
Help