| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | TABLE 1 - nodes | itäisi | Quantity of Construction materials (tonnes) | TABLE 2a - Sankey flows | Value check | |||||||||||||||||||||
2 | Lifecycle Stage | Total quantity of construction materials | Aluminium | Bitumen/ Asphalt | Bricks | Concrete | Glass | Gypsum | Insulation | Iron (Steel) | Sand&gravel | Soil | Timber | Waste | From | To | Quantity (tonnes) | Flow Label | Sublabel | Value | LCS | Notes | ||||
3 | Extraction/Harvesting | 0 | Extraction/Harvesting | Manufacturing | 0 | Extraction/Harvesting --> Manufacturing | 0 | Extraction/Harvesting | ||||||||||||||||||
4 | Manufacturing | 0 | Extraction/Harvesting | Retail | 0 | Extraction/Harvesting --> Retail | Extraction, manufacturing, waste collection etc., actually always goes through some sort of retail, wholesale or broker or other economic activity middle man that ensures export. | |||||||||||||||||||
5 | Retail | 0 | Extraction/Harvesting | Use | 0 | Extraction/Harvesting --> Use | ||||||||||||||||||||
6 | Use | 0 | Extraction/Harvesting | Waste collection | 0 | Extraction/Harvesting --> Waste collection | ||||||||||||||||||||
7 | Stock | 0 | The Sankey data and the calculations behind them can be found here: https://docs.google.com/spreadsheets/d/1Zg-xiijQWxg0O7RlMvus9j3KtWs1Ya3E/edit#gid=1507618581&range=A1 | Extraction/Harvesting | Export | 0 | Extraction/Harvesting --> Export | |||||||||||||||||||
8 | Waste collection | Manufacturing | Retail | 0 | Manufacturing --> Retail | 0 | Manufacturing | |||||||||||||||||||
9 | Landfill | Manufacturing | Use | 0 | Manufacturing --> Use | Perhaps, concrete example directly sold. | ||||||||||||||||||||
10 | Incineration | 0 | Manufacturing | Waste collection | 0 | Manufacturing --> Waste collection | ||||||||||||||||||||
11 | Recycling | 0 | Manufacturing | Export | 0 | Manufacturing --> Export | ||||||||||||||||||||
12 | Anaerobic digestion | 0 | Retail | Use | 0 | Retail --> Use | 0 | Retail | ||||||||||||||||||
13 | Composting | 0 | Retail | Use | 0 | Retail --> Use | Redistribution | |||||||||||||||||||
14 | Import | 0 | Retail | Waste collection | 0 | Retail --> Waste collection | ||||||||||||||||||||
15 | Export | 0 | Retail | Export | 0 | Retail --> Export | ||||||||||||||||||||
16 | Use | Waste collection | 0.00 | Use --> Waste collection | 0.00 | Use | ||||||||||||||||||||
17 | Use | Retail | 0.00 | Use --> Retail | Reuse | This concerns a product/flow of less than a year that is being reused directly from one user to another through retail | ||||||||||||||||||||
18 | INDICATORS | Use | Stock | 0.00 | Use --> Stock | 0.00 | Stock | Use' is the act of constructing and using the materials which in turn forms the stock. So it should go from retail to stock because there is an economic activity in between. | ||||||||||||||||||
19 | Stock | Use | Stock --> Use | Reuse | ||||||||||||||||||||||
20 | Stock | Waste collection | Stock --> Waste collection | 0 | Waste collection | |||||||||||||||||||||
21 | Standard indicator components | Waste collection | Landfill | Waste collection --> Landfill | Landfill | |||||||||||||||||||||
22 | Domestic extraction used | 0 | =C3 | from Table 1 | 0 | Waste collection | Incineration | Waste collection --> Incineration | Incineration | |||||||||||||||||
23 | Domestic production | 0 | =C4 | from Table 1 | Waste collection | Recycling | 0 | Waste collection --> Recycling | Recycling | |||||||||||||||||
24 | Imports | 0 | =C14 | from Table 1 | Waste collection | Anaerobic digestion | 0 | Waste collection --> Anaerobic digestion | Anaerobic digestion | |||||||||||||||||
25 | Exports | 0 | =C15 | from Table 1 | Waste collection | Composting | 0 | Waste collection --> Composting | Composting | |||||||||||||||||
26 | Total waste | =C8 | from Table 1 | Waste collection | Manufacturing | 0 | Waste collection --> Manufacturing | Remanufacturing | ||||||||||||||||||
27 | Landfilled waste | =C9 | from Table 1 | Waste collection | Export | 0 | Waste collection --> Export | |||||||||||||||||||
28 | Incinerated waste | 0 | =C10 | from Table 1 | Incineration | Retail | 0 | Incineration --> Retail | ||||||||||||||||||
29 | Domestic recovery = waste recycled in domestic recovery plants | 0 | =C11 | from Table 1 | Recycling | Manufacturing | 0 | Recycling --> Manufacturing | Recycling | |||||||||||||||||
30 | Anaerobic digestion | Harvesting | 0 | Anaerobic digestion --> Harvesting | This is for the digested waste. | |||||||||||||||||||||
31 | Imported waste for recycling | 0 | =S41 | from Table 2 | Composting | Retail | 0 | Composting --> Retail | ||||||||||||||||||
32 | Exported waste for recycling | =S46 | from Table 2 | Composting | Harvesting | 0 | Composting --> Harvesting | Could go via retail, but perhaps also coop exchange. | ||||||||||||||||||
33 | Secondary materials (biomass) | 0.00 | =(S19+S29+S30+S31+S32) | from Table 2 | Import | Manufacturing | 0 | Import --> Manufacturing | 0 | Import | ||||||||||||||||
34 | EOL mass collected | 0.00 | =S16+S20+S36 | from Table 2 | Import | Retail | 0 | Import --> Retail | ||||||||||||||||||
35 | EOL mass collected for recycling (construction) | 0 | =S23 | from Table 2 | Import | Use | 0 | Import --> Use | ||||||||||||||||||
36 | EOL mass collected for recycling (biomass) | 0 | =S27+S25 | from Table 2 | Import | Waste collection | 0 | Import --> Waste collection | Probably goes directly to the respective treatment | |||||||||||||||||
37 | EOL mass recycled (construction) | 0 | =S29 | from Table 2 | Import | Landfill | 0 | Import --> Landfill | ||||||||||||||||||
38 | EOL mass recycled (biomass) | 0 | =SUM(S30:S32) | from Table 2 | Import | Incineration | 0 | Import --> Incineration | ||||||||||||||||||
39 | Exported waste | 0.00 | =S27 | from Table 2 | Import | Anaerobic digestion | 0 | Import --> Anaerobic digestion | ||||||||||||||||||
40 | Imported waste | 0 | =S36 | from Table 2 | Import | Composting | 0 | Import --> Composting | ||||||||||||||||||
41 | Import | Recycling | 0 | Import --> Recycling | CB: I've added this, because Import --> Manufact. masks the amounts otherwise. | |||||||||||||||||||||
42 | Domestic material consumption (DMC) | 0.00 | =C46 | a calculated indicator | Export | Landfill | Export --> Landfill | 0 | Export | |||||||||||||||||
43 | Export | Incineration | Export --> Incineration | |||||||||||||||||||||||
44 | The ones in bold are mandatory for both sectors. | Export | Anaerobic digestion | Export --> Anaerobic digestion | ||||||||||||||||||||||
45 | Indicator number | All mandatory construction indicators | Indicator value | Formula | Type of indicator | CL indicator metadata URL | Export | Composting | Export --> Composting | |||||||||||||||||
46 | 34 | Domestic material consumption (DMC) | 0.00 | =SUM(S3:S6)+SUM(S33:S36)-C25 | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | Tonnes/year | Export | Recycling | Export --> Recycling | |||||||||||||||
47 | 39 | Circular Material Use rate | #DIV/0! | =((C29-C31+C32)/(C46+(C29-C31+C32)))*100 | (Domestic recovery - imported waste for recycling + exported waste for recycling)/((Extraction + Imports - Exports) + (Domestic recovery - imported waste for recycling + exported waste for recycling)) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-39 | % | ||||||||||||||||||
48 | 48 | EU self-sufficiency for raw materials | #DIV/0! | =(1-((C24-C25)/(C23+C24-C25))) | Import Reliance (IR) = Net import / Apparent consumption = (Import - Export) / (Domestic production + Import - Export) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-48 | % | ||||||||||||||||||
49 | 55 | EOL recycling rate | #DIV/0! | =(C37/C34)*100 | For each material fraction, the End-of-Life recycling rate is defined as the End-of-Life mass recycled divided by the available mass of End-of-Life materials. It is the product of the Processing Rate and the Collection Rate (EoL RR = EoL PR x EoL CR). | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-55 | % | TABLE 2b - Allocation values | Value check | ||||||||||||||||
50 | 57 | Amount of sector specific waste that is produced | =C26 | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | Tonnes/year | Extraction/Harvesting | Manufacturing | 0.5 | 1 | Extraction/Harvesting | ||||||||||||||
51 | 58 | EOL processing rate | #DIV/0! | =(C37/C35)*100 | End-of-Life mass recycled / End-of-Life mass collected for recycling. | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-58 | % | Extraction/Harvesting | Retail | 0.2 | |||||||||||||||
52 | 59 | Incineration rate | #DIV/0! | =(C28/(C26+C40-C39))*100 | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | % | Extraction/Harvesting | Use | 0.1 | |||||||||||||||
53 | 61 | Landfilling rate | #DIV/0! | =(C27/(C26+C40-C39))*100 | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | % | Extraction/Harvesting | Waste collection | 0.1 | |||||||||||||||
54 | Extraction/Harvesting | Export | 0.1 | |||||||||||||||||||||||
55 | Manufacturing | Retail | 0.6 | 1 | Manufacturing | |||||||||||||||||||||
56 | Indicator number | All mandatory biomass indicators | Indicator value | Manufacturing | Use | 0 | ||||||||||||||||||||
57 | 34 | Domestic material consumption (DMC) | 0.00 | #NAME? | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | Manufacturing | Waste collection | 0.1 | ||||||||||||||||
58 | 41 | Share of secondary materials in DMC | #DIV/0! | #NAME? | Share of Recycling / domestic material consumption | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-41 | Manufacturing | Export | 0.3 | ||||||||||||||||
59 | 48 | EU self-sufficiency for raw materials | #DIV/0! | #NAME? | Import Reliance (IR) = Net import / Apparent consumption = (Import - Export) / (Domestic production + Import - Export) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-48 | Retail | Use | 0.75 | 1 | Retail | ||||||||||||||
60 | 53 | Quantity of material for anaerobic digestion | 0.00 | #NAME? | For each material fraction, the End-of-Life recycling rate is defined as the End-of-Life mass recycled divided by the available mass of End-of-Life materials. It is the product of the Processing Rate and the Collection Rate (EoL RR = EoL PR x EoL CR). | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-53 | Retail | Use | 0 | Redistribution | |||||||||||||||
61 | 56 | Quantity of material for composting | 0.00 | #NAME? | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-56 | Retail | Waste collection | 0.05 | |||||||||||||||||
62 | 57 | Amount of sector specific waste that is produced | #NAME? | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | Retail | Export | 0.2 | |||||||||||||||||
63 | 58 | EOL processing rate | #DIV/0! | #NAME? | End-of-Life mass recycled / End-of-Life mass collected for recycling. | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-58 | This one has different components than the construction one. | Use | Waste collection | 0.2 | 1 | Use | |||||||||||||
64 | 59 | Incineration rate | #DIV/0! | #NAME? | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | Use | Retail | 0.1 | Reuse | |||||||||||||||
65 | 61 | Landfilling rate | #DIV/0! | #NAME? | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | Use | Stock | 0.7 | 1 | Stock | ||||||||||||||
66 | Stock | Use | 0.01 | Reuse | ||||||||||||||||||||||
67 | Stock | Waste collection | 0.99 | 0 | Waste collection | |||||||||||||||||||||
68 | Waste collection | Landfill | Landfill | |||||||||||||||||||||||
69 | Waste collection | Incineration | Incineration | |||||||||||||||||||||||
70 | Waste collection | Recycling | Recycling | |||||||||||||||||||||||
71 | Waste collection | Anaerobic digestion | Anaerobic digestion | |||||||||||||||||||||||
72 | Waste collection | Composting | Composting | |||||||||||||||||||||||
73 | Waste collection | Manufacturing | Remanufacturing | |||||||||||||||||||||||
74 | Waste collection | Export | ||||||||||||||||||||||||
75 | Incineration | Retail | 0.1 | |||||||||||||||||||||||
76 | Recycling | Manufacturing | 0.3 | Recycling | ||||||||||||||||||||||
77 | Anaerobic digestion | Harvesting | ||||||||||||||||||||||||
78 | Composting | Retail | ||||||||||||||||||||||||
79 | Composting | Harvesting | ||||||||||||||||||||||||
80 | Import | Manufacturing | 0.4 | 1 | Import | |||||||||||||||||||||
81 | Import | Retail | 0.4 | |||||||||||||||||||||||
82 | Import | Use | 0 | |||||||||||||||||||||||
83 | Import | Waste collection | ||||||||||||||||||||||||
84 | Import | Landfill | ||||||||||||||||||||||||
85 | Import | Incineration | ||||||||||||||||||||||||
86 | Import | Anaerobic digestion | ||||||||||||||||||||||||
87 | Import | Composting | ||||||||||||||||||||||||
88 | Import | Recycling | 0.2 | |||||||||||||||||||||||
89 | Export | Landfill | 0 | Export | ||||||||||||||||||||||
90 | Export | Incineration | ||||||||||||||||||||||||
91 | Export | Anaerobic digestion | ||||||||||||||||||||||||
92 | Export | Composting | ||||||||||||||||||||||||
93 | Export | Recycling | ||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||