Skip to content

Processes sheet

cleorf92 edited this page Sep 28, 2026 · 3 revisions

Before you start: read Processes, flows and stocks. It explains what a process, a stock, and a lifetime distribution are.

In this sheet you list every process in the system, and give a lifetime to the processes that are stocks.

Columns

The column order matters. Columns listed in ignore_columns_processes (in the Settings sheet) are skipped.

Column Name Description
A (ignored) Free column for your own notes
B Process Process name, e.g. Sawmilling. Avoid spaces.
C Process location Location, e.g. FI, Import, Export. Part of the process ID.
D Process ID Name:Location, e.g. Sawmilling:FI. Must be unique. The example file builds it with a formula.
E Transformation stage Stage the process belongs to, e.g. Source, First, Second, EoL. Sets the colour in the graphs.
F Lifetime Mean lifetime in years, as a whole number (decimals are cut off). 0 = not a stock; > 0 = stock.
G Distribution type Lifetime distribution of the stock: Fixed, Normal, LogNormal, FoldedNormal, Weibull, Simple, LandfillDecayWood, LandfillDecayPaper
H Distribution parameters Parameters for the distribution as name=value, separated by commas, e.g. stddev=1 or shape=2.5, scale=40
I Comment Free text
J Normalized X Horizontal position in the Sankey graph (0–1). Can be empty. Overridden by the Process positions sheet.
K Normalized Y Vertical position in the Sankey graph (0–1). Can be empty. Overridden by the Process positions sheet.
L Label shown in graph Label used in the Sankey and network graphs

Which parameters each distribution needs

Distribution type Required parameters
Fixed, Simple none
Normal, LogNormal, FoldedNormal stddev
Weibull shape, scale
LandfillDecayWood, LandfillDecayPaper condition = Dry, Wet, or Managed

NOTE: A stock is just a process with a lifetime. With Fixed, the lifetime works as a simple delay: what enters in a year leaves exactly lifetime years later. Other distributions spread the outflow over several years.


Next: Flows sheet

Clone this wiki locally