ENERGY CONSUMPTION CALCU

Location My House
Cost/kWh 0.75 $
Total Rating/Hour 3,949.00 Watt

Hourly Usage
No Appliances Rating (W) # of Units
per Day

1 Television - Samsung 150.00 5.0 1

2 Air Conditioner - Panasonic 480.00 6.0 1
3 Air Conditioner - Panasonic 2 400.00 1.0
4 WiFi Modem 10.00 24.0
5 Cable TV Setup Box 25.00 24.0
6 Internet Modem 10.00 24.0 1
7 Mobile Phone Charger - Samsung 3.00 3.0 1
8 Microwave 600.00 0.5 1
9 Refrigerator 105.00 24.0 1
10 Coffee Maker 600.00 1.0 1
11 Toaster 600.00 0.5 1
12 Laptop 50.00 3.0 1
13 Electric Iron 400.00 3.0 1
14 Washing Machine 500.00 1.0 1
15 LED Light Bulb - 7 7.00 10.0 4
16 LED Light Bulb - 9 9.00 10.0 4
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

© 2016 - Exceltemplate.net
GY CONSUMPTION CALCULATOR

Maximum consumption per day 11.33 kWh

Average consumption per day 9.78 kWh
Total Consumption per month 293.47 kWh
Total Monthly Cost 220.10 $

Consumption Day Frequency Consumption Day Frequency Consumption

Monthly Cost
per Day Usage per Week per Week Usage per Month per Month

0.75 7.0 5.25 30.0 22.50 16.88

2.88 7.0 20.16 30.0 86.40 64.80
0.40 2.80 12.00 9.00
0.24 1.68 7.20 5.40
0.60 4.20 18.00 13.50
0.24 1.68 7.20 5.40
0.01 7.0 0.06 0.27 0.20
0.30 5.0 1.50 9.00 6.75
2.52 7.0 17.64 75.60 56.70
0.60 5.0 3.00 20.0 12.00 9.00
0.30 5.0 1.50 20.0 6.00 4.50
0.15 7.0 1.05 4.50 3.38
1.20 2.0 2.40 8.0 9.60 7.20
0.50 2.0 1.00 8.0 4.00 3.00
0.28 7.0 1.96 8.40 6.30
0.36 7.0 2.52 10.80 8.10
How to Use

Type location (optional)

and Cost/kWh
Select Appliance Item
from dropdown list in
Appliances Column

Type Hourly Usage per

day for selected appliance
Type number of similar
appliance unit (if you
leave it empty,
consumption per day will
take 1 as defaullt number)

Type day frequency usage

per week (if you leave it
empty, consumption per
week will take 7 as default
value)
Type day frequency usage
per month (if you leave it
empty, consumption per
month will take 30 as
defaullt # of days)
LIST OF APPLIANCES

No Item Description Rating (Watt) Efficiency (%)

1 Television - Samsung 50" 150.00 100%
2 Television - Sony 40" 125.00
3 Air Conditioner - Panasonic 1 PK 600.00 80%
4 Air Conditioner - Panasonic 2 3/4 PK 500.00 80%
5 Air Conditioner - Daikin 800.00 80%
6 WiFi Modem 10.00
7 Cable TV Setup Box 25.00
8 Internet Modem 10.00
9 Refrigerator 150.00 70%
10 Water Heater 1,000.00
11 Microwave 600.00
12 Dispenser 600.00
13 Dishwasher 1,200.00
14 LED Light Bulb - 7 7W 7.00
15 LED Light Bulb - 9 9W 9.00
16 Incandescent Light Bulb - 60 60W 60.00
17 Incandescent Light Bulb - 80 80W 80.00
18 Washing Machine 500.00
19 Vaccum Cleaner 200.00
20 Electric Iron 400.00
21 Rice Cooker 400.00
22 Toaster 600.00
23 Laptop 50.00
24 Printer 20.00
25 Scanner 10.00
26 Desktop Computer - Apple 100.00
27 Mobile Phone Charger - Samsung 3.00
28 Mobile Phone Charger - Iphone 3.00
29 Water Pump 400.00
30 Electric Saver 15.00
31 Lawn Mower 1,000.00
32 Food Blender 300.00
33 Hair Dryer 400.00
34 Coffee Maker 600.00
35
36
37
38
39
40
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

© 2016 - Exceltemplate.net
 Notes :
Final Rating (Watt) Notes Type Item Name in Item Column.
150.00 It must be a unique name
125.00
Type Rating in Rating Column in
480.00 Watt unit. If you can't find Watt
400.00 information in your item
640.00 specification, you can use box
below to convert Voltage and
10.00 Current specification into Watt
25.00 unit and copy its value into
10.00 respective boxes
105.00 Efficiency Rating column is
1,000.00 optional. You can leave it empty.
600.00
600.00 Description and Notes columns
are optional as well.
1,200.00
7.00
9.00
60.00
80.00
500.00
200.00
400.00
400.00
600.00
50.00 Voltage Volt(s)
20.00 Current Amp(s)
10.00 Rating - Watt
100.00
3.00
3.00
400.00
15.00
1,000.00
300.00
400.00
600.00