peterborough transfer study.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O
1
2
3
4							Peterborough collection site: September 25 2024 Post consumer aerosol can measurement
5
6
7
8
9
10
11
12
13
14
15
16
17
18							Conclusion:	Average fill rate by percentage			30.36021567
19
20
21
22
23
24
25							Average fill rate 30.36%
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47		Can #	Type of metal	Volume of can in g	Overall weight post consumer	taie shine	lid yes or no	weight of packaging	weight of plastic	weight of metals	Weight of contents left in can	% contents left in can	weight liquid approx	weight gas approx
48		1	steel	170	82	cooking spray	no	51	0	51	31	18.23529412	24.49	6.51
49		2	steel	340	196.1	paint	yes	102	10	92	94.1	27.67647059	74.339	19.761
50		3	steel	170	80.7	bug spray	no	51	0	51	29.7	17.47058824	23.463	6.237
51		4	steel	410	99.6	parts cleaner	no	99.6	0	99.6	0	0	0	0
52		5	steel	425	115.4	paint stripper	no	115.4	0	115.4	0	0	0	0
53		6	steel	283	158.1	rustoleum	yes	84.9	10	74.9	73.2	25.86572438	57.828	15.372
54		7	steel	425	292	tremclad	yes	127.5	10	117.5	164.5	38.70588235	129.955	34.545
55		8	steel	300	136	water proofing	yes	90	10	80	46	15.33333333	36.34	9.66
56		9	steel	400	138	oven cleaner	yes	120	10	110	18	4.5	14.22	3.78
57		10	steel	400	120	bug spray	yes	120	10	110	0	0	0	0
58		11	steel	340	147	rustoleum	yes	102	10	92	45	13.23529412	35.55	9.45
59		12	steel	110	73.8	cooking spray	yes	33	10	23	40.8	37.09090909	32.232	8.568
60		13	steel	350	136	bug spray	yes	105	10	95	31	8.857142857	24.49	6.51
61		14	steel	340	118.7	rustoleum	yes	102	10	92	16.7	4.911764706	13.193	3.507
62		15	steel	312	176.5	lubricant	no	93.6	0	93.6	82.9	26.57051282	65.491	17.409
63		16	steel	312	374.5	solvent	no	93.6	0	93.6	280.9	90.03205128	221.911	58.989
64		17	steel	340	115.6	spray paint	no	102	0	102	13.6	4	10.744	2.856
65		18	steel	340	94	spray paint	no	94	0	94	0	0	0	0
66		19	steel	340	142	spray paint	yes	102	10	92	40	11.76470588	31.6	8.4
67		20	steel	370	252	fogging oil	no	111	0	111	141	38.10810811	111.39	29.61
68		21	steel	340	195	spray paint	yes	102	10	92	93	27.35294118	73.47	19.53
69		22	steel	340	320	paint	yes	102	10	92	218	64.11764706	172.22	45.78
70		23	steel	165	125	lighter fluid	no	49.5	0	49.5	75.5	45.75757576	59.645	15.855
71		24	steel	340	144	paint	no	102	0	102	42	12.35294118	33.18	8.82
72		25	steel	340	247.5	paint	no	102	0	102	145.5	42.79411765	114.945	30.555
73		26	steel	414	367	adhesive	no	124.2	0	124.2	242.8	58.647343	191.812	50.988
74		27	steel	450	170	silicone	no	135	0	135	35	7.777777778	27.65	7.35
75		28	steel	496	557	cleaner	no	148.8	0	148.8	408.2	82.2983871	322.478	85.722
76		29	steel	496	465.5	cleaner	no	148.8	0	148.8	316.7	63.85080645	250.193	66.507
77		30	steel	170	94.1	cooking spray	no	51	0	51	43.1	25.35294118	34.049	9.051
78		31	steel	368	238.5	spray paint	no	110.4	0	110.4	128.1	34.80978261	101.199	26.901
79		32	steel	311	419.5	adhesive	yes	93.3	10	83.3	326.2	100	257.698	68.502
80		33	steel	340	238.5	paint	yes	102	10	92	136.5	40.14705882	107.835	28.665
81		34	steel	340	123.2	paint	yes	102	10	92	21.2	6.235294118	16.748	4.452
82		35	steel	311	394	shaving cream	no	93.3	0	93.3	300.7	96.68810289	237.553	63.147
83		36	steel	311	202	wd40	no	93.3	0	93.3	108.7	34.95176849	85.873	22.827
84		37	steel	311	166	spray paint	yes	93.3	10	83.3	72.7	23.37620579	57.433	15.267
85		38	steel	400	399	oven cleaner	yes	120	10	110	279	69.75	220.41	58.59
86		39	steel	340	444.5	stain remover	x2	102	20	82	342.5	100	270.575	71.925
87		40	steel	340	373.5	boot cleaner	no	102	0	102	271.5	79.85294118	214.485	57.015
88		41	steel	340	408.5	paint	yes	102	10	92	306.5	90.14705882	242.135	64.365
89		42	steel	300	71.5	hair spray	no	71.5	0	71.5	0	0	0	0
90		43	steel	510	164.4	tire shine	no	153	0	153	11.4	2.235294118	9.006	2.394
91	400	44	steel	400	121	bug spray	yes	120	10	110	1	0.25	0.79	0.21
92		45	steel	350	132.4	bug spray	x2	105	20	85	27.4	7.828571429	21.646	5.754
93		46	steel	340	203	paint	no	102	0	102	101	29.70588235	79.79	21.21
94		47	steel	340	121	paint	yes	102	10	92	19	5.588235294	15.01	3.99
95		48	steel	350	195.2	bug spray	x2	105	20	85	90.2	25.77142857	71.258	18.942
96		49	steel	120	122.8	dry shampoo	no	36	0	36	86.8	72.33333333	68.572	18.228
97		50	steel	340	123.9	paint	yes	102	10	92	21.9	6.441176471	17.301	4.599
98		51	steel	350	97.5	bug spray	yes	97.5	10	87.5	0	0	0	0
99		52	steel	170	136.1	lubricant	no	51	0	51	85.1	50.05882353	67.229	17.871
100		53	steel	538	379.5	primer	no	161.4	0	161.4	218.1	40.53903346	172.299	45.801