LCAdraft.analysis.xlsx

	C	D	E	F	G	H	I	J	K	L	M	O	Q	R	S	T	U	W	AA
1
2
3									Cells with parameter information used in input to LCA calculations
4									Cells Calculated by the information in green
5
6								Common Data: 1 single clothespin				Transportation Emission Factors 1st Case
7	Life Cycle Assessment: Inventory Analysis							Parameter		Unit	Value	Parameter	Unit	Value
8								Weight of Wood (bth arms)		kg	0.006	Emission: MYTTP - CNNSA	kg CO₂e (per TEU)	265
9								Weight of Steel (spring)		kg	0.001	TEU Payload Capacity	kg	28300
10												TEU Volume	m³	33.2
11								Grams to kg conversion factor			0.001
12								302 Steel Emission Factor in processing		kg CO₂-eq	0.001	GHG Emissions of 2 TEUs	kg CO₂e (per TEU)	530
13								Birch Wood Emission Factor in processing		kg CO₂-eq	0.012
14
15								Clothespin Emission Factor in processing		kg CO₂-eq	0.013	Transportation Emission Factors 2nd Case
16												Parameter	Unit	Large Truck	Small Truck
17												Energy Intensity	MJ per tkm	1.65	6.83
18												GHG Intensity	kg of CO2-eq per MJ	0.071	0.067
19												GHG Intensity: A*B	kg of CO2-eq per tkm	0.11715	0.45761
20												Multiplier for external impacts		1.5	1.5
21												Total GHG Emissions	kg CO₂e (per TEU)	0.176	0.686
22
23
24
25	ASSESSMENT BY STAGE: CRADLE-TO-GRAVE
26
27	1) SOURCING											3) TRANSPORTATION							4) Manufacturing
28
29	INPUT: raw materials extraction					OUTPUT: GHG Emissions (kg CO2 equivalent)						INPUT: energy and material flows				OUTPUT: kg CO₂-eq per: TEU, 100kg, tkm…			INPUT: energy and material flows
30
31	Extraction of	How?	Activity Emissions	Unit		Chemical Compounds			GHG Extraction Emissions			1st Case. Before Processing - Transportation of raw birch wood from Malaysia 🇲🇾 to China 🇨🇳
32	Carbon	Added as graphite	0.2	kg CO₂-eq		↓						Marine transportation
33	Magnanese	Mined from Mn Ores	1.5	kg CO₂-eq		302 Stainless Steel (AISI 302)			TOTAL
34	Phosphorus	Mined from phosphate rock	0	kg CO₂-eq		Carbon	0.15 max		0.0257	kg CO₂-eq		Selection of the marine route using container ships
35	Sulfur	Residual from ores	0	kg CO₂-eq		Magnanese	2.00 max					Departure: Port of Tanjung Pelepas (MYTTP) -> Arrival: Nansha Port, Guangzhou (CNNSA)
36	Silicon	From quartz	2	kg CO₂-eq		Phosphorus	0.045 max
37	Nickel	Nickel ored mined, smelted	22	kg CO₂-eq		Sulfur	0.030 max								Fluentcargo.com
38	Cellulose	Extracted naturally	0	kg CO₂-eq		Silicon	0.75 max
39	Lignin	Naturally part of wood	0	kg CO₂-eq		Nickel	8-10 max
40	Hemicelluloses	Naturally part of wood	0	kg CO₂-eq
41	Pentosans	Naturally part of wood	0	kg CO₂-eq		Birch Wood			TOTAL
42						Cellulose	0.42		0	kg CO₂-eq
43						Lignin	0.19
44	2) PROCESSING in China 🇨🇳					Hemicelluloses	0.27
45						Pentosans	0.18
46	INPUT: processing raw materials					Extractives	0.2-0.3
47
48	OUTPUT: GHG Emissions (kg CO2 equivalent)
49
50	302 Stainless Steel (AISI 302)
51	Processes:	Emissions:		Chemical Formulas		Chemical Name
52	· Melt	Oxidation of alloys		FeO, Fe₂O₃, Fe₃O₄ + Cr₂O₃ + NiO		Iron Oxides + Chromium(III) oxide + Nickel(II) oxide
53	· Cut	Metal particles		Fe, Cr, Ni, Mn		Iron, Chromium, Nickel, Manganese
54	· Bend into spring	Machinery Energy used		CO₂, H₂O, NOx, SOx.		Carbon Dioxide, Water Vapor, mix of NO & mix of SO						map.openseamaps.org
55
56	Birch Wood											Calculation of GW for Case1:
57	Processes:	Emissions:		Chemical Formulas		Chemical Name						Estimated emissions of the route:	265
58	· Dry	Machinery Energy used		CO₂, H₂O, NOx, SOx		Carbon Dioxide, Water Vapor, Nitric Oxide, Sulfur Monoxide						Number of TEUs	1
59	· Cut	Wood dust		(C₆H₁₀O₅)ₙ and (C₅H₈O₄)ₙ		Celluloses and Hemicelluloses
60	· Carve	Machinery Energy used		CO₂, H₂O, NOx, SOx.		Carbon Dioxide, Water Vapor, Nitric Oxide, Sulfur Monoxide						Estimated emissions of the route:	530	kg CO₂-eq per TEU
61												Number of TEUs	2
62	Linking the Chemical Formulas with the GWP table to obtain GWP values
63
64	Chemical	Ocurrence Number		GWP table value	Total GWP		Calculation of GW:
65	CO₂	3 (bend, dry and carve )		1	3		GW in 302 Stainless Steel =		0.001	kg CO₂-eq per steel processed		2nd Case. Transportation across China 🇨🇳
66							GW in Birch Wood =		0.012	kg CO₂-eq per wood processed		Road transportation
67	CO₂ in Steel	1					TOTAL =		0.013	kg CO₂-eq per clothespin
68	CO₂ in Birch Wood	2										Routes through the Life Cycle stages: (assumption about distances)
69												Raw Birch Wood from Nansha Port to Factory1		km	291	0%	100%	0.175725
70												Raw 302 Steel from Alibaba supplier to Factory1		km	123	0%	100%	0.175725
71												Factory1 to recycling center		km	19	100%	0%	0.686415
72												Routes		Unit	Distance	Small Truck Share	Large Truck Share	Weighted Avg
73																		kg of CO2-eq per tkm
74
75												Calculation of GW for Case2:
76												Using Raw Material Emissions	0.0045161325	kg of CO2-eq per clothespin
77												Using Processing Emissions	0.008923395	kg of CO2-eq per clothespin
78
79
80
81
82
83
84
85
86												3rd Case. Distributing to The Netherlands
87
88												Factory1 final clothespin distribution to The Netherlands		km
89												Clothespin user to sorting facility		km
90												Sorting to recycling center		km
91												Sorting to final locals with final clothespin product		km
92
93
94
95
96
97
98
99
100