| 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 | To | Notes | |||
3 | Extraction/Harvesting | 583,198.75 | 288.00 | 3,391.50 | 578,092.10 | 1,427.15 | Extraction/Harvesting | Manufacturing | 116,639.75 | Extraction/Harvesting --> Manufacturing | 583,198.75 | Extraction/Harvesting | ||||||||||||||
4 | Manufacturing | 314,148.79 | Extraction/Harvesting | Retail | 174,959.63 | 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.00 | Extraction/Harvesting | Use | 116,639.75 | Extraction/Harvesting --> Use | ||||||||||||||||||||
6 | Use | 517,948.75 | Extraction/Harvesting | Waste collection | 0.00 | Extraction/Harvesting --> Waste collection | ||||||||||||||||||||
7 | Stock | 11,135,463.00 | 1,873,346.00 | 1,341,501.00 | 3,663,012.00 | 4,257,604.00 | Extraction/Harvesting | Export | 174,959.63 | Extraction/Harvesting --> Export | ||||||||||||||||
8 | Waste collection | 633,982.50 | Manufacturing | Retail | 172,781.83 | Manufacturing --> Retail | 314,148.79 | Manufacturing | 282,061.94 | |||||||||||||||||
9 | Landfill | 119,202.85 | Manufacturing | Use | 0.00 | Manufacturing --> Use | Perhaps, concrete example directly sold. | |||||||||||||||||||
10 | Incineration | 4,872.91 | Manufacturing | Waste collection | 15,707.44 | Manufacturing --> Waste collection | ||||||||||||||||||||
11 | Recycling | 385,208.04 | Manufacturing | Export | 125,659.52 | Manufacturing --> Export | ||||||||||||||||||||
12 | Anaerobic digestion | 0.00 | Retail | Use | 0.00 | Retail --> Use | 0.00 | Retail | 498,423.62 | |||||||||||||||||
13 | Composting | 0.00 | Retail | Use | 0.00 | Retail --> Use | Redistribution | |||||||||||||||||||
14 | Import | 246,000.00 | Retail | Waste collection | 0.00 | Retail --> Waste collection | ||||||||||||||||||||
15 | Export | 311,250.00 | Retail | Export | 0.00 | Retail --> Export | ||||||||||||||||||||
16 | Use | Waste collection | 103,589.75 | Use --> Waste collection | 517,948.75 | Use | ||||||||||||||||||||
17 | Use | Retail | 51,794.88 | 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 | 362,564.13 | Use --> Stock | 633,982.50 | 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 | 6,339.82 | Stock --> Use | Reuse | |||||||||||||||||||||
20 | Stock | Waste collection | 627,642.67 | Stock --> Waste collection | 633,982.50 | Waste collection | 791,459.86 | |||||||||||||||||||
21 | Standard indicator components | Waste collection | Landfill | 119,202.85 | Waste collection --> Landfill | Landfill | ||||||||||||||||||||
22 | Domestic extraction used | 583,198.75 | =C3 | from Table 1 | 517949 | Waste collection | Incineration | 4,872.91 | Waste collection --> Incineration | 4,872.91 | Incineration | |||||||||||||||
23 | Domestic production | 314,148.79 | =C4 | from Table 1 | Waste collection | Recycling | 385,208.04 | Waste collection --> Recycling | Recycling | |||||||||||||||||
24 | Imports | 246,000.00 | =C14 | from Table 1 | Waste collection | Other disposal | 1,756.34 | Waste collection --> Other disposal | Other disposal | |||||||||||||||||
25 | Exports | 311,250.00 | =C15 | from Table 1 | Waste collection | Other recovery | 4,511.36 | Waste collection --> Other recovery | Other recovery | |||||||||||||||||
26 | Total waste | 633,982.50 | =C8 | from Table 1 | Waste collection | Storage prior to disposal | 659.78 | Waste collection --> Storage prior to disposal | ||||||||||||||||||
27 | Landfilled waste | 119,202.85 | =C9 | from Table 1 | Waste collection | Storage prior to recovery | 117,771.22 | Waste collection --> Storage prior to recovery | ||||||||||||||||||
28 | Incinerated waste | 4,872.91 | =C10 | from Table 1 | Waste collection | Export | 57,540.00 | Waste collection --> Export | ||||||||||||||||||
29 | Domestic recovery = waste recycled in domestic recovery plants | 385,208.04 | =C11 | from Table 1 | Indicator 39, such high domestic recovery, compared to extraction. CMRU good for metals. Not the same products, so it skews the image. | Incineration | Retail | 487.29 | Incineration --> Retail | Recycling | ||||||||||||||||
30 | Recycling | Manufacturing | 115,562.41 | Recycling --> Manufacturing | Recycling | This is for the digested waste. | ||||||||||||||||||||
31 | Imported waste for recycling | 49,200.00 | =S42 | from Table 2 | Anaerobic digestion | Harvesting | 0.00 | Anaerobic digestion --> Harvesting | ||||||||||||||||||
32 | Exported waste for recycling | 31,125.00 | =S47 | from Table 2 | Composting | Retail | 0.00 | Composting --> Retail | Could go via retail, but perhaps also coop exchange. | |||||||||||||||||
33 | Secondary materials (biomass) | 121,902.24 | =(S19+S30+S31+S32+S33) | from Table 2 | Composting | Harvesting | 0.00 | Composting --> Harvesting | ||||||||||||||||||
34 | EOL mass collected | 775,752.42 | =S16+S20+S37 | from Table 2 | Import | Manufacturing | 49,200.00 | Import --> Manufacturing | 246,000.00 | Import | ||||||||||||||||
35 | EOL mass collected for recycling (construction) | 507,490.61 | =S23+S25+S27 | from Table 2 | special Danish case | Import | Retail | 98,400.00 | Import --> Retail | |||||||||||||||||
36 | EOL mass collected for recycling (biomass) | 122,282.57 | =S27+S25 | from Table 2 | Import | Use | 49,200.00 | Import --> Use | Probably goes directly to the respective treatment | |||||||||||||||||
37 | EOL mass recycled (construction) | 115,562.41 | =S30 | from Table 2 | Import | Waste collection | 44,520.00 | Import --> Waste collection | ||||||||||||||||||
38 | EOL mass recycled (biomass) | 0.00 | =SUM(S31:S33) | from Table 2 | Import | Landfill | 0.00 | Import --> Landfill | ||||||||||||||||||
39 | Exported waste | 57,540.00 | =S28 | from Table 2 | special Danish case | Import | Incineration | 0.00 | Import --> Incineration | |||||||||||||||||
40 | Imported waste | 44,520.00 | =S37 | from Table 2 | Import | Anaerobic digestion | 0.00 | Import --> Anaerobic digestion | ||||||||||||||||||
41 | Import | Composting | 0.00 | Import --> Composting | CB: I've added this, because Import --> Manufact. masks the amounts otherwise. | |||||||||||||||||||||
42 | Domestic material consumption (DMC) | 338,309.13 | =C46 | a calculated indicator | Import | Recycling | 49,200.00 | Import --> Recycling | ||||||||||||||||||
43 | Export | Landfill | 15,562.50 | Export --> Landfill | 311,250.00 | Export | ||||||||||||||||||||
44 | The ones in bold are mandatory for both sectors. | Export | Incineration | 15,562.50 | Export --> Incineration | |||||||||||||||||||||
45 | Indicator number | All mandatory construction indicators | Indicator value | Formula | Type of indicator | CL indicator metadata URL | per person | Export | Retail abroad | 249,000.00 | Export --> Retail abroad | |||||||||||||||
46 | 34 | Domestic material consumption (DMC) | 338,309.13 | =SUM(S3:S6)+SUM(S34:S37)-C25 | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | 6.6650 | Tonnes/year | Export | Composting | 0.00 | Export --> Composting | |||||||||||||
47 | 39 | Circular Material Use rate | 52.04 | =((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 | 0.0010 | % | Export | Recycling | 31,125.00 | Export --> Recycling | |||||||||||||
48 | 48 | EU self-sufficiency for raw materials | 1.26 | =(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 | 0.0000 | % | |||||||||||||||||
49 | 55 | EOL recycling rate | 14.90 | =(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 | 0.0003 | % | |||||||||||||||||
50 | 57 | Amount of sector specific waste that is produced | 633,982.50 | =C26 | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | 12.4901 | Tonnes/year | TABLE 2b - Allocation values | Value check | |||||||||||||||
51 | 58 | EOL processing rate | 22.77 | =(C37/C35)*100 | End-of-Life mass recycled / End-of-Life mass collected for recycling. | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-58 | 0.0004 | % | Extraction/Harvesting | Manufacturing | 0.2 | 1 | Extraction/Harvesting | ||||||||||||
52 | 59 | Incineration rate | 0.78 | =(C28/(C26+C40-C39))*100 | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | 0.0000 | % | Extraction/Harvesting | Retail | 0.3 | ||||||||||||||
53 | 61 | Landfilling rate | 19.20 | =(C27/(C26+C40-C39))*100 | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | 0.0004 | % | Extraction/Harvesting | Use | 0.2 | ||||||||||||||
54 | Extraction/Harvesting | Waste collection | 0 | |||||||||||||||||||||||
55 | Extraction/Harvesting | Export | 0.3 | |||||||||||||||||||||||
56 | Indicator number | All mandatory biomass indicators | Indicator value | Manufacturing | Retail | 0.55 | 1 | Manufacturing | ||||||||||||||||||
57 | 34 | Domestic material consumption (DMC) | 338309.13 | #NAME? | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | Manufacturing | Use | 0 | ||||||||||||||||
58 | 41 | Share of secondary materials in DMC | 0.36 | #NAME? | Share of Recycling / domestic material consumption | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-41 | Manufacturing | Waste collection | 0.05 | ||||||||||||||||
59 | 48 | EU self-sufficiency for raw materials | 1.26 | #NAME? | Import Reliance (IR) = Net import / Apparent consumption = (Import - Export) / (Domestic production + Import - Export) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-48 | Manufacturing | Export | 0.4 | ||||||||||||||||
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.75 | 1 | Retail | ||||||||||||||
61 | 56 | Quantity of material for composting | 0.00 | #NAME? | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-56 | Retail | Use | 0 | Redistribution | ||||||||||||||||
62 | 57 | Amount of sector specific waste that is produced | 633982.50 | #NAME? | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | Retail | Waste collection | 0.05 | ||||||||||||||||
63 | 58 | EOL processing rate | 0.00 | #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. | Retail | Export | 0.2 | |||||||||||||||
64 | 59 | Incineration rate | 0.78 | #NAME? | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | Use | Waste collection | 0.2 | 1 | Use | ||||||||||||||
65 | 61 | Landfilling rate | 19.20 | #NAME? | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | Use | Retail | 0.1 | Reuse | |||||||||||||||
66 | Use | Stock | 0.7 | 1 | Stock | |||||||||||||||||||||
67 | Stock | Use | 0.01 | Reuse | ||||||||||||||||||||||
68 | Stock | Waste collection | 0.99 | 0 | Waste collection | |||||||||||||||||||||
69 | Waste collection | Landfill | Landfill | |||||||||||||||||||||||
70 | Lifecycle stage | Reliability | Completeness | Temporal correlation | Spatial correlation | Waste collection | Incineration | Incineration | ||||||||||||||||||
71 | Extraction/Harvesting | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | done | Waste collection | Recycling | Recycling | |||||||||||||||||
72 | Manufacturing | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="red"></span> | employment proxy to downscale, 2-digit material level | Waste collection | Other disposal | Other disposal | |||||||||||||||||
73 | Retail | no data | Waste collection | Other recovery | Other recovery | |||||||||||||||||||||
74 | Use | <span data-color="red"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="yellow"></span> | use DMC formula | Waste collection | Storage prior to disposal | Remanufacturing | |||||||||||||||||
75 | Stock | <span data-color="yellow"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | good report | Waste collection | Storage prior to recovery | ||||||||||||||||||
76 | Waste collection | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | completeness of waste data; the issue here is that it is detailed per material, but not know from which economic activity | Incineration | Retail | 0.1 | |||||||||||||||||
77 | Landfill | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | completeness of waste data; the issue here is that it is detailed per material, but not know from which economic activity | Recycling | Manufacturing | 0.3 | Recycling | ||||||||||||||||
78 | Incineration | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | completeness of waste data; the issue here is that it is detailed per material, but not know from which economic activity | Anaerobic digestion | Harvesting | ||||||||||||||||||
79 | Recycling | <span data-color="green"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="green"></span> | completeness of waste data; the issue here is that it is detailed per material, but not know from which economic activity | Composting | Retail | ||||||||||||||||||
80 | Imports | <span data-color="red"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="yellow"></span> | NUTS3, for all imports, needed to be estimated that 80% of the materials for selected categories from the NUTS3 imports are used for the construction. | Composting | Harvesting | ||||||||||||||||||
81 | Exports | <span data-color="red"></span> | <span data-color="yellow"></span> | <span data-color="green"></span> | <span data-color="yellow"></span> | Import | Manufacturing | 0.2 | 1 | Import | ||||||||||||||||
82 | Import | Retail | 0.4 | |||||||||||||||||||||||
83 | Import | Use | 0.2 | |||||||||||||||||||||||
84 | high | <span data-color="green"></span> | Import | Waste collection | ||||||||||||||||||||||
85 | medium | <span data-color="yellow"></span> | Import | Landfill | ||||||||||||||||||||||
86 | low | <span data-color="red"></span> | Import | Incineration | ||||||||||||||||||||||
87 | Import | Anaerobic digestion | ||||||||||||||||||||||||
88 | Reliability | Import | Composting | |||||||||||||||||||||||
89 | high | Reviewed or measured data | Import | Recycling | 0.2 | |||||||||||||||||||||
90 | medium | Estimated data | Export | Landfill | 0.05 | 1 | Export | |||||||||||||||||||
91 | low | Provisional data | Export | Incineration | 0.05 | |||||||||||||||||||||
92 | Export | Retail abroad | 0.8 | |||||||||||||||||||||||
93 | Completeness | Export | Composting | |||||||||||||||||||||||
94 | high | Data exists for all of the single materials and their respective economic activites | Export | Recycling | 0.1 | |||||||||||||||||||||
95 | medium | Data exists for most single materials and most economic activities | ||||||||||||||||||||||||
96 | low | Data exists for the sector only for the Life Cycle Stages | ||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | Temporal correlation | |||||||||||||||||||||||||
99 | high | 1 data less than 3 years difference to the time period of the data set | ||||||||||||||||||||||||
100 | medium | 2 data less than 6 years difference to the time period of the data set | ||||||||||||||||||||||||