co2-savings-calculator-spreadsheet.xlsx

	A	C	D	E	F
1		CO2 Savings Calculator
2
3	The emission and cost savings achieved by switching off lights is substantial.
4	Use the table below to calculate the savings when lighting is turned off.
5
6	Click-On Cells with Blue Text to Modify Values, Results will be Displayed in Green
7
8			Rating per Fitting (Watts)	Quantity of Fittings	Total Power (Watts)
9
10
11
12		2Ft Twin, Fluorescent Fitting	36	20	720
13		5Ft Single, Fluorescent Fitting	58	500	29000
14		Bulkhead Fitting, 13W CFL	13	0	0
15		Bulkhead Fitting, 16W 2D	16	0	0
16		Bulkhead Fitting, 60W	60	100	6000
17		Floodlight, 70W	70	0	0
18		Floodlight, 150W	150	0	0
19		Floodlight, 250W	250	0	0
20		Floodlight, 400W	400	10	4000
21		Floodlight, 500W	500	0	0
22		Floodlight, 1000W	1000	0	0
23		Floodlight, 1500W	1500	0	0
24
25				Total Power of All Fittings (Watts)	39720
26
27	Lighting to be Switched-off for:
28			Weekday	12	Hours per Day
29			Saturday	16	Hours per Day
30			Sunday	24	Hours per Day
31
32	Annual Savings (based on 52 weeks)
33			Cost per kWHr	£0.10
34			Tonnes of CO2 Saved per Annum	88.81
35			Saving	£20,654.40
36
37
38	Click to View our Time Clock MDA Data Sheet
39
40	Click to View our Time Clock TA Data Sheet
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57	Blakley calculator (version 2.0) Blakley Electrics Ltd.
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100