2 - Winter Shutdown Phantom Power Calculator.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Step 1	INPUT # of gadgets or fixtures IN YELLOW CELLS ONLY							Updated Dec 16 2021
2	Step 2	INPUT running hours IN PURPLE CELLS ONLY
3	Step 3	Average Cost of Electricity >>>	$ 0.1123	/kWh
4	Step 4	Enter length of time gadget is plugged in for >>		1	hrs/day	7	days/wk	52	wks/yr
5	Step 5	RE-ENTER this value into Column D >>>>>>>>>		364	hrs/yr if different from 24/7 or 8760 hrs per year
6	Step 6	Hit the PRINT button
7
8		What does it cost you if you leave gadgets plugged in?????
9		Existing Technology	INPUT Quantity	INPUT # 0perating hrs (A)	INPUT Wattage or Phantom Power W	TOTAL Wattage (B)	KiloWatts (B/1000 = C)	Kilowatt Hrs (kWh) (C * A)	BC Hydro Rate $/kWh	ENERGY Cost to run the equipment

10		Mobile Phone Charger On, Charged	1	365	2.24	2.24	0.00224	0.8176	$0.1123	$0.09
11	Phantom power	Mobile Phone Charger Power supply only	1	8760	0.26	0.26	0.00026	2.2776	$0.1123	$0.26
12		Laptop only	1	365	20	20	0.02	7.3	$0.1123	$0.82
13		Laptop with 20" LED Monitor Fully On, Charged	1	365	24.4	24.4	0.0244	8.906	$0.1123	$1.00
14		Tablet	1	365	3.7	3.7	0.0037	1.3505	$0.1123	$0.15
15		Computer Desktop with 16" Monitor ON	1	365	270	270	0.27	98.55	$0.1123	$11.07
16	Phantom power	Computer Desktop with 16" Monitor STANDBY	1	8760	60	60	0.06	525.6	$0.1123	$59.02
17	Phantom power	Computer Screen LCD Sleep Mode	1	8760	1.38	1.38	0.00138	12.0888	$0.1123	$1.36
18	Phantom power	Computer Screen LCD OFF	1	8760	1.13	1.13	0.00113	9.8988	$0.1123	$1.11
19		Printer (Laser) ON	1	365	80	80	0.08	29.2	$0.1123	$3.28
20	Phantom power	Printer (Laser) OFF	1	8760	1.58	1.58	0.00158	13.8408	$0.1123	$1.55
21	Phantom power	Coffee Maker OFF	1	8760	1.14	1.14	0.00114	9.9864	$0.1123	$1.12
22	Phantom power	Microwaves Ready - door closed	1	8760	3.08	3.08	0.00308	26.9808	$0.1123	$3.03
23		Microwaves Ready - door opened	1	365	25.79	25.79	0.02579	9.41335	$0.1123	$1.06
24		Refrigerators - small	1	365	350	350	0.35	127.75	$0.1123	$14.35
25		Refrigerators - large	1	365	780	780	0.78	284.7	$0.1123	$31.97
26		Space Heaters	1	365	1500	1500	1.5	547.5	$0.1123	$61.48
27		Baseboard heater	1	365	4200	4200	4.2	1533	$0.1123	$172.16
28	Phantom power	DVD Player On, Not playing	1	8760	13.51	13.51	0.01351	118.3476	$0.1123	$13.29
29		Video Game XBOx & TV	1	365	190	190	0.19	69.35	$0.1123	$7.79
30		Video Game PS4 & TV	1	365	225	225	0.225	82.125	$0.1123	$9.22
31	Phantom power	Video Game XBOX ONLY OFF	1	8760	1.01	1.01	0.00101	8.8476	$0.1123	$0.99
32		Smart TV 42" LCD	1	365	48	48	0.048	17.52	$0.1123	$1.97
33	Phantom power	TV/VCR Off by remote	1	8760	5.15	5.15	0.00515	45.114	$0.1123	$5.07
40		TOTAL								$403.21
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
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
101
102
103
104
105
106