| 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 | Quantity of Biomass materials (tonnes) | TABLE 2a - Sankey flows | Value check | ||||||||||||||||||||||
2 | Lifecycle Stage | Total quantity of biomass materials | Cereals | Dairy products | Fish | Fodder crops | Fruits | Garden and Park materials | Live animals | Oil-bearing crops | Roots, tubers | Sugar crops | Timber | Vegetables | Waste | From | To | Quantity (tonnes) | Flow Label | Sublabel | Value | LCS | Notes | |||
3 | Extraction/Harvesting | 811904 | 5896 | 17220 | 144 | 71113 | 317 | 396 | 21 | 13044 | 0 | 702027 | 1726 | Extraction/Harvesting | Manufacturing | 745096.80 | Extraction/Harvesting --> Manufacturing | 811904.00 | Extraction/Harvesting | |||||||
4 | Manufacturing | 669 | 669 | 0 | Extraction/Harvesting | Retail | 23579.01 | 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 | 0 | Extraction/Harvesting | Use | 0.00 | Extraction/Harvesting --> Use | |||||||||||||||||||
6 | Use | 27535 | 3895 | 8608 | 691 | 3766 | 3825 | 2247 | 1334 | 3169 | Extraction/Harvesting | Waste collection | 43228.19 | Extraction/Harvesting --> Waste collection | ||||||||||||
7 | Stock | 2529 | 2529 | 0 | Extraction/Harvesting | Export | 0.00 | Extraction/Harvesting --> Export | ||||||||||||||||||
8 | Waste collection | 22733 | 0 | 22733 | Manufacturing | Retail | 546.32 | Manufacturing --> Retail | 669.00 | Manufacturing | ||||||||||||||||
9 | Landfill | 0 | 0 | Manufacturing | Use | 0.00 | Manufacturing --> Use | Perhaps, concrete example directly sold. | ||||||||||||||||||
10 | Incineration | 0 | 0 | Manufacturing | Waste collection | 122.68 | Manufacturing --> Waste collection | |||||||||||||||||||
11 | Recycling | 7540 | 0 | 7540 | Manufacturing | Export | 0.00 | Manufacturing --> Export | ||||||||||||||||||
12 | Anaerobic digestion | 0 | 0 | Retail | Use | 0.00 | Retail --> Use | 146.00 | Retail | |||||||||||||||||
13 | Composting | 7469 | 0 | 7469 | Retail | Use | 146.00 | Retail --> Use | Redistribution | |||||||||||||||||
14 | Import | 95079 | 2719 | 972 | 654 | 5888 | 3198 | 42 | 1448 | 652 | 28 | 865 | 76738 | 1875 | Retail | Waste collection | 0.00 | Retail --> Waste collection | ||||||||
15 | Export | 31229.6 | 7918 | 1501 | 550 | 1469 | 101 | 3.5 | 677 | 1.1 | 145 | 37 | 18767 | 60 | Retail | Export | 0.00 | Retail --> Export | ||||||||
16 | Use | Waste collection | 18186.40 | Use --> Waste collection | 18186.40 | 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 | 0.00 | Stock --> Use | Reuse | |||||||||||||||||||||
20 | Stock | Waste collection | 0.00 | Stock --> Waste collection | 22733.00 | Waste collection | ||||||||||||||||||||
21 | Standard indicator components | Waste collection | Landfill | 0.00 | Waste collection --> Landfill | Landfill | ||||||||||||||||||||
22 | Domestic extraction used | 811,904.00 | =C3 | from Table 1 | Waste collection | Incineration | 0.00 | Waste collection --> Incineration | 0.00 | Incineration | ||||||||||||||||
23 | Domestic production | 669.00 | =C4 | from Table 1 | Waste collection | Recycling | 7540.00 | Waste collection --> Recycling | Recycling | |||||||||||||||||
24 | Imports | 95,079.00 | =C14 | from Table 1 | Waste collection | Anaerobic digestion | 0.00 | Waste collection --> Anaerobic digestion | Anaerobic digestion | |||||||||||||||||
25 | Exports | 31,229.60 | =C15 | from Table 1 | Waste collection | Composting | 7469.00 | Waste collection --> Composting | Composting | |||||||||||||||||
26 | Total waste | 22,733.00 | =C8 | from Table 1 | Waste collection | Manufacturing | 0.00 | Waste collection --> Manufacturing | Remanufacturing | |||||||||||||||||
27 | Landfilled waste | 0.00 | =C9 | from Table 1 | Waste collection | Export | 7724.00 | Waste collection --> Export | ||||||||||||||||||
28 | Incinerated waste | 0.00 | =C10 | from Table 1 | Incineration | Retail | 0.00 | Incineration --> Retail | ||||||||||||||||||
29 | Domestic recovery = waste recycled in domestic recovery plants | 7,540.00 | =C11 | from Table 1 | Recycling | Manufacturing | 0.00 | Recycling --> Manufacturing | Recycling | |||||||||||||||||
30 | Anaerobic digestion | Harvesting | 0.00 | Anaerobic digestion --> Harvesting | This is for the digested waste. | |||||||||||||||||||||
31 | Imported waste for recycling | 0.00 | =T41 | from Table 2 | Composting | Retail | 3000.00 | Composting --> Retail | ||||||||||||||||||
32 | Exported waste for recycling | 0.00 | =T46 | from Table 2 | Composting | Harvesting | 0.00 | Composting --> Harvesting | Could go via retail, but perhaps also coop exchange. | |||||||||||||||||
33 | Secondary materials (biomass) | 3,000.00 | =(T19+T29+T30+T31+T32) | from Table 2 | Import | Manufacturing | 83043.68 | Import --> Manufacturing | 95079.00 | Import | ||||||||||||||||
34 | EOL mass collected | 18,186.40 | =T16+T20+T36 | from Table 2 | Import | Retail | 12035.32 | Import --> Retail | ||||||||||||||||||
35 | EOL mass collected for recycling (construction) | 7,540.00 | =T23 | from Table 2 | Import | Use | 0.00 | Import --> Use | ||||||||||||||||||
36 | EOL mass collected for recycling (biomass) | 7,469.00 | =T24+T25 | from Table 2 | Import | Waste collection | 0.00 | Import --> Waste collection | Probably goes directly to the respective treatment | |||||||||||||||||
37 | EOL mass recycled (construction) | 0.00 | =T29 | from Table 2 | Import | Landfill | 0.00 | Import --> Landfill | ||||||||||||||||||
38 | EOL mass recycled (biomass) | 3,000.00 | =SUM(T30:T32) | from Table 2 | Import | Incineration | 0.00 | Import --> Incineration | ||||||||||||||||||
39 | Exported waste | 7,724.00 | =T27 | from Table 2 | Import | Anaerobic digestion | 0.00 | Import --> Anaerobic digestion | ||||||||||||||||||
40 | Imported waste | 0.00 | =T36 | from Table 2 | Import | Composting | 0.00 | Import --> Composting | ||||||||||||||||||
41 | Import | Recycling | 0.00 | Import --> Recycling | CB: I've added this, because Import --> Manufact. masks the amounts otherwise. | |||||||||||||||||||||
42 | Domestic material consumption (DMC) | 906,983.00 | =C46 | a calculated indicator | Export | Landfill | 0.00 | Export --> Landfill | 7724.00 | Export | ||||||||||||||||
43 | Export | Incineration | 7724.00 | Export --> Incineration | ||||||||||||||||||||||
44 | The ones in bold are mandatory for both sectors. | Export | Anaerobic digestion | 0.00 | Export --> Anaerobic digestion | |||||||||||||||||||||
45 | Indicator number | All mandatory construction indicators | Indicator value | Formula | Type of indicator | CL indicator metadata URL | Export | Composting | 0.00 | Export --> Composting | ||||||||||||||||
46 | 34 | Domestic material consumption (DMC) | 906983.00 | =SUM(T3:T6)+SUM(T33:T36)-T15 | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | Export | Recycling | 0.00 | Export --> Recycling | |||||||||||||||
47 | 39 | Circular Material Use rate | 0.01 | =(C29-C31+C32)/(C46+(C29-C31+C32)) | (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 | 1.04 | =(1-((C24-C25)/(C23+C24-C25)))*100 | 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 | 0.00 | =C37/C34 | 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 | 22733.00 | =C26 | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | Extraction/Harvesting | Manufacturing | 0.918 | 1.0 | Extraction/Harvesting | ||||||||||||||
51 | 58 | EOL processing rate | 0.00 | =C37/C35 | End-of-Life mass recycled / End-of-Life mass collected for recycling. | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-58 | Extraction/Harvesting | Retail | 0.029 | ||||||||||||||||
52 | 59 | Incineration rate | 0.00 | =C28/(C26+C40-C39) | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | Extraction/Harvesting | Use | 0.000 | ||||||||||||||||
53 | 61 | Landfilling rate | 0.00 | =C27/(C26+C40-C39) | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | Extraction/Harvesting | Waste collection | 0.053 | ||||||||||||||||
54 | Extraction/Harvesting | Export | 0.000 | |||||||||||||||||||||||
55 | Manufacturing | Retail | 0.817 | 1.0 | Manufacturing | |||||||||||||||||||||
56 | Indicator number | All mandatory biomass indicators | Indicator value | Manufacturing | Use | 0.000 | ||||||||||||||||||||
57 | 34 | Domestic material consumption (DMC) | 906983.00 | =C46 | DMC = DEU + IMP - EXP = Domestic extraction used + Imports - Exports | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-34 | Tonnes/year | Manufacturing | Waste collection | 0.183 | |||||||||||||||
58 | 41 | Share of secondary materials in DMC | 0.33 | =(C33/C42)*100 | Share of Recycling / domestic material consumption | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-41 | % | Manufacturing | Export | 0.000 | |||||||||||||||
59 | 48 | EU self-sufficiency for raw materials | 1.04 | =C48 | Import Reliance (IR) = Net import / Apparent consumption = (Import - Export) / (Domestic production + Import - Export) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-48 | % | Retail | Use | 0.908 | 1.0 | Retail | |||||||||||||
60 | 53 | Quantity of material for anaerobic digestion | 0.00 | =C12 | 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 | Tonnes/year | Retail | Use | 0.000 | |||||||||||||||
61 | 56 | Quantity of material for composting | 7469.00 | =C13 | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-56 | Tonnes/year | Retail | Waste collection | 0.017 | ||||||||||||||||
62 | 57 | Amount of sector specific waste that is produced | 22733.00 | =C50 | Sum of all waste collected | Direct | https://cityloops.metabolismofcities.org/indicators/#indicator-57 | Tonnes/year | Retail | Export | 0.074 | |||||||||||||||
63 | 58 | EOL processing rate | 40.17 | =(C38/C36)*100 | 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 | 1.000 | 1.0 | Use | ||||||||||||
64 | 59 | Incineration rate | 0.00 | =(C52)*100 | Incinerated waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-59 | % | Use | Retail | 0.000 | |||||||||||||||
65 | 61 | Landfilling rate | 0.00 | =(C53)*100 | Landfilled waste / (Total waste + imported waste - exported waste) | Calculated | https://cityloops.metabolismofcities.org/indicators/#indicator-61 | % | Use | Stock | 0.000 | 0.0 | Stock | |||||||||||||
66 | Stock | Use | 0.000 | |||||||||||||||||||||||
67 | Stock | Waste collection | 0.000 | 0.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 | ||||||||||||||||||||||||
74 | Waste collection | Export | ||||||||||||||||||||||||
75 | Incineration | Retail | ||||||||||||||||||||||||
76 | Recycling | Manufacturing | ||||||||||||||||||||||||
77 | Anaerobic digestion | Harvesting | ||||||||||||||||||||||||
78 | Composting | Retail | ||||||||||||||||||||||||
79 | Composting | Harvesting | ||||||||||||||||||||||||
80 | Import | Manufacturing | 0.873 | 1.0 | Import | |||||||||||||||||||||
81 | Import | Retail | 0.127 | |||||||||||||||||||||||
82 | Import | Use | 0 | |||||||||||||||||||||||
83 | Import | Waste collection | 0 | |||||||||||||||||||||||
84 | Import | Landfill | 0 | |||||||||||||||||||||||
85 | Import | Incineration | 0 | |||||||||||||||||||||||
86 | Import | Anaerobic digestion | 0 | |||||||||||||||||||||||
87 | Import | Composting | 0 | |||||||||||||||||||||||
88 | Import | Recycling | 0 | |||||||||||||||||||||||
89 | Export | Landfill | 0 | 0 | Export | |||||||||||||||||||||
90 | Export | Incineration | 0 | |||||||||||||||||||||||
91 | Export | Anaerobic digestion | 0 | |||||||||||||||||||||||
92 | Export | Composting | 0 | |||||||||||||||||||||||
93 | Export | Recycling | 0 | |||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||