210622_Mikkeli_Construction_CDW Indicators and Sankey-diagram_22.6.2021.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	Q	R	S	T	U	V	W	Y
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	1234259	0		0	180640	0	0	0	0	408771	89061	555787.00		Extraction/Harvesting	Manufacturing	617129.6061	Extraction/Harvesting --> Manufacturing		1234259.212	Extraction/Harvesting
4		Manufacturing	672041	15713	0	0	223800	0	0	0	15713	0	0	416815		Extraction/Harvesting	Retail	246851.8424	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	123425.9212	Extraction/Harvesting --> Use
6		Use	376564	376	13785		32977		8		376	327017	200	1825		Extraction/Harvesting	Waste collection	123425.9212	Extraction/Harvesting --> Waste collection
7		Stock	24484983	92187	783314		8089908		1870		92187	14928638	49049	447830		Extraction/Harvesting	Export	123425.9212	Extraction/Harvesting --> Export
8		Waste collection	35598	392	610	1657	19607	271	269		392		5779	4598	35598	Manufacturing	Retail	403224.6	Manufacturing --> Retail		672041	Manufacturing
9		Landfill	2293	0	0	0	0	0	269		0		0	0	2293	Manufacturing	Use	0	Manufacturing --> Use				Perhaps, concrete example directly sold.
10		Incineration	0	0	0	0	0	0	0		0		0	0		Manufacturing	Waste collection	67204.1	Manufacturing --> Waste collection
11		Recycling	27924	0	610	1657	19607	271	0		0		5779	0	27924	Manufacturing	Export	201612.3	Manufacturing --> Export
12		Anaerobic digestion	0													Retail	Use	0	Retail --> Use		0	Retail
13		Composting	0													Retail	Use	0	Retail --> Use	Redistribution
14		Import	69271	1962		1119	7591	1878	11565		40308			4848		Retail	Waste collection	0	Retail --> Waste collection
15		Export	604535	1179		0	111900	0	0	0	56220	81754		353483	5381	Retail	Export	0	Retail --> Export
16																Use	Waste collection	75,312.76	Use --> Waste collection		376,563.80	Use
17																Use	Retail	37,656.38	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	263,594.66	Use --> Stock		35,598.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	355.98	Stock --> Use	Reuse
20																Stock	Waste collection	35,242.02	Stock --> Waste collection		36381	Waste collection
21		Standard indicator components														Waste collection	Landfill	2293	Waste collection --> Landfill			Landfill
22		Domestic extraction used	1234259	=C3	from Table 1			698996								Waste collection	Incineration		Waste collection --> Incineration			Incineration
23		Domestic production	672041	=C4	from Table 1											Waste collection	Recycling	28707	Waste collection --> Recycling			Recycling
24		Imports	69271	=C14	from Table 1											Waste collection	Anaerobic digestion	0	Waste collection --> Anaerobic digestion			Anaerobic digestion
25		Exports	604535	=C15	from Table 1											Waste collection	Composting	0	Waste collection --> Composting			Composting
26		Total waste	35598	=C8	from Table 1											Waste collection	Manufacturing	0	Waste collection --> Manufacturing	Remanufacturing
27		Landfilled waste	2293	=C9	from Table 1											Waste collection	Export	5381	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	27924	=C11	from Table 1											Recycling	Manufacturing	27924	Recycling --> Manufacturing	Recycling
30																Anaerobic digestion	Harvesting	0	Anaerobic digestion --> Harvesting				This is for the digested waste.
31		Imported waste for recycling	13854.2	=S41	from Table 2											Composting	Retail	0	Composting --> Retail
32		Exported waste for recycling	784	=S46	from Table 2											Composting	Harvesting	0	Composting --> Harvesting				Could go via retail, but perhaps also coop exchange.
33		Secondary materials (biomass)	28,279.98	=(S19+S29+S30+S31+S32)	from Table 2											Import	Manufacturing	27708.4	Import --> Manufacturing		69271	Import
34		EOL mass collected	110,554.78	=S16+S20+S36	from Table 2											Import	Retail	27708.4	Import --> Retail
35		EOL mass collected for recycling (construction)	28707	=S23	from Table 2											Import	Use	0	Import --> Use
36		EOL mass collected for recycling (biomass)	5381	=S27+S25	from Table 2											Import	Waste collection	0	Import --> Waste collection				Probably goes directly to the respective treatment
37		EOL mass recycled (construction)	27924	=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	5381.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	13854.2	Import --> Recycling				CB: I've added this, because Import --> Manufact. masks the amounts otherwise.
42		Domestic material consumption (DMC)	561715.39	=C46	a calculated indicator											Export	Landfill	0	Export --> Landfill		5382	Export
43																Export	Incineration	4598	Export --> Incineration
44	The ones in bold are mandatory for both sectors.															Export	Anaerobic digestion	0	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)	561,715.39	=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	784	Export --> Recycling
47	39	Circular Material Use rate	2.58	=((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	4.91	=(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	25.26	=(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	35,598.00	=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	97.27	=(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	0.00	=(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	7.59	=(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)	561715.39	#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	0.05	#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	4.91	#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	35598.00	#NAME?	Sum of all waste collected			Direct	https://cityloops.metabolismofcities.org/indicators/#indicator-57							Retail	Export	0.2
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.				Use	Waste collection	0.2			1	Use
64	59	Incineration rate	0.00	#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	7.59	#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