(6) Electrical Unit consumption and Energy Bill calculation(1.8.23).xlsx

	B	C	D	E	F	G	H	I	R	S
1
2	Calculate Electrical Unit Consumption
3
4	Electrical Unit Slab & Other charges					Quick Electrial Bill Calculation
5		Unit Slab	Unit	Unit	Amount
6		First Unit Slab	0	100	2.70	Unit Consumed	400	Kwh	100	100
7		Next Unit Slab	100	200	3.00	Charges			100	100
8		Next Unit Slab	200	400	3.60	Energy Charge	Rs. 1,290.00		200	200
9		Next Unit Slab	400	600	4.10	Fixed Charge	Rs. 10.00		200	0
10		Next Unit Slab	600		4.70	Fuel Charge	Rs. 300.00	jignesh.Parmar	600	0
11		Charges				Elect. Charge	Rs. 160.00	jiguparma@yahoo.com
12		Fixed Charge	10	Rs		Meter Charge	Rs. 20.00	www.electricalnotes.wordpress.com
13		Fuel Charge	0.75	Rs/Unit		Other Cahrges
14		Elect.Charge	10%	%		Other Cahrges
15		Meter Charge	20	Rs		Total Bill Amount	Rs. 1,780.00
16
17
18	Electrical Equipment Unit Consumption Detail
19	Sr.No	Equipment	No	Kw	Total Kw	Avg.Equipment Using Hr/Day	No of Day/Month	No's of Unit Consumed / Month

20			1	2	2	2	30	60
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
51
52
53
54
55	Total				2 Kw			60 Kwh
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