6.1 Utility Electricity Bill Analysis (12 Months).xlsx

	A	E	F	G	H	I	J	K
1	Utility Electricity Bill Analysis (12 Months)
2	Utility Electricity Bill Analysis (12 Months)
3
4
5		Flat No. 201 (12 Months of Electricity Bills)
6
7		Sr. No	Bill Date	Reading	Period	Units Consumed	CC Charges (Rs.)	Units Rate/KWh
8		1	1/6/2019	51265	Dec. to Jan. 2019	288	2001.6	6.95
9		2	2/6/2019	51553	Jan. to Feb. 2019	298	2071.1	6.95
10		3	3/6/2019	51851	Feb. to March 2019	305	2171.6	7.12
11		4	4/6/2019	52156	March to April 2019	365	2638.95	7.23
12		5	5/6/2019	52521	April to May 2019	299	2078.05	6.95
13		6	6/6/2019	52820	May to June 2019	299	2078.05	6.95
14		7	7/6/2019	53119	June to July 2019	285	1980.75	6.95
15		8	8/6/2019	53404	July to August 2019	306	2178.72	7.12
16		9	9/6/2019	53710	August to Sept. 2019	310	2207.2	7.12
17		10	10/6/2019	54020	Sept. to Oct. 2019	309	2200.08	7.12
18		11	11/6/2019	54329	Oct. to Nov. 2019	298	2071.1	6.95
19		12	12/6/2019	54627	Nov. to Dec. 2019	308	2192.96	7.12
20						305.83	2155.85	7.04
21
22
23		Flat No. 202 (12 Months of Electricity Bills)
24
25		Sr. No	Bill Date	Reading	Period	Units Consumed	CC Charges (Rs.)	Units Rate/KWh
26		1	1/6/2019	45566	Dec. to Jan. 2019	298	2071.1	6.95
27		2	2/6/2019	45864	Jan. to Feb. 2019	289	2008.55	6.95
28		3	3/6/2019	46153	Feb. to March 2019	306	2178.72	7.12
29		4	4/6/2019	46459	March to April 2019	288	2001.6	6.95
30		5	5/6/2019	46747	April to May 2019	309	2200.08	7.12
31		6	6/6/2019	47056	May to June 2019	322	2305.52	7.16
32		7	7/6/2019	47378	June to July 2019	300	2085	6.95
33		8	8/6/2019	47678	July to August 2019	345	2521.95	7.31
34		9	9/6/2019	48023	August to Sept. 2019	299	2078.05	6.95
35		10	10/6/2019	48322	Sept. to Oct. 2019	266	1848.7	6.95
36		11	11/6/2019	48588	Oct. to Nov. 2019	298	2071.1	6.95
37		12	12/6/2019	48886	Nov. to Dec. 2019	307	2185.84	7.12
38						302.25	2129.68	7.04
39
40
41		Flat No. 203 (12 Months of Electricity Bills)
42
43		Sr. No	Bill Date	Reading	Period	Units Consumed	CC Charges (Rs.)	Units Rate/KWh
44		1	1/6/2019	61236	Dec. to Jan. 2019	285	1980.75	6.95
45		2	2/6/2019	61521	Jan. to Feb. 2019	303	2157.36	7.12
46		3	3/6/2019	61824	Feb. to March 2019	306	2178.72	7.12
47		4	4/6/2019	62130	March to April 2019	298	2071.1	6.95
48		5	5/6/2019	62428	April to May 2019	301	2143.12	7.12
49		6	6/6/2019	62729	May to June 2019	306	2178.72	7.12
50		7	7/6/2019	63035	June to July 2019	311	2226.76	7.16
51		8	8/6/2019	63346	July to August 2019	345	2494.35	7.23
52		9	9/6/2019	63691	August to Sept. 2019	305	2171.6	7.12
53		10	10/6/2019	63996	Sept. to Oct. 2019	301	2143.12	7.12
54		11	11/6/2019	64297	Oct. to Nov. 2019	302	2153.26	7.13
55		12	12/6/2019	64599	Nov. to Dec. 2019	307	2185.84	7.12
56						305.83	2173.73	7.11
57
58
59		Flat No. 204 (12 Months of Electricity Bills)
60
61		Sr. No	Bill Date	Reading	Period	Units Consumed	CC Charges (Rs.)	Units Rate/KWh
62		1	1/6/2019	78445	Dec. to Jan. 2019	288	2001.6	6.95
63		2	2/6/2019	78733	Jan. to Feb. 2019	232	1612.4	6.95
64		3	3/6/2019	78965	Feb. to March 2019	365	2638.95	7.23
65		4	4/6/2019	79330	March to April 2019	235	1633.25	6.95
66		5	5/6/2019	79565	April to May 2019	345	2494.35	7.23
67		6	6/6/2019	79910	May to June 2019	342	2472.66	7.23
68		7	7/6/2019	80252	June to July 2019	330	2385.9	7.23
69		8	8/6/2019	80582	July to August 2019	301	2143.12	7.12
70		9	9/6/2019	80883	August to Sept. 2019	305	2171.6	7.12
71		10	10/6/2019	81188	Sept. to Oct. 2019	301	2143.12	7.12
72		11	11/6/2019	81489	Oct. to Nov. 2019	312	2224.56	7.13
73		12	12/6/2019	81801	Nov. to Dec. 2019	288	2001.6	6.95
74						303.67	2160.26	7.10
75
76
77
78		Average Monthly Power Consumption by VBHC Green Glade Apartment				1217.58	8619.52	7.07
79
80
81
82
83						kWh	Rs.	Rs.
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100