Spreadsheet: 172060d1343971785-entire-row-blink-when-condition-meet-bills-payment1
Sheet: Official

Official Bills 2012-2013
S.No. | Name | P.No | Landline Ceiling Approval Date | Monthly Landline Ceiling | Mobile Ceiling Approval Date | Monthly Mobile Ceiling | Yearly  Ceiling | Consumed Yearly Balance | Remaining Yearly Balance | July 2011 Mobile | July 2011 Land Line | Aug 2011 Mobile | Aug 2011 Land Line | Sep 2011 Mobile | Sep 2011 Land Line | Oct 2011 Mobile | Oct 2011 Land Line | Nov 2011 Mobile | Nov 2011 Land Line | Dec 2011 Mobile | Dec 2011 Land Line | Jan 2012 Mobile | Jan 2012 Land Line | Feb 2012 Mobile | Feb 2012 Land Line | Mar 2012 Mobile | [NAME] Land Line | April 2012 Mobile | April 2012 Land Line | May 2012 Mobile | May 2012 Land Line | June 2012 Mobile | June 2012 Land Line
1 | Abc | 123 |  | 5000 |  | 5000 |  |  |  | 25000 | 21000 | 5000 | 36000 | 4800 | 21000 | 10000
2 | Abc | 321 | 2010-08-23 00:00:00 | 3500 |  | 3500
3 | Abc | 3213 |  | 3500 |  | 3500
4 | Abc | 123 |  | 3500 |  | 3500 |  |  |  |  | 3500
5 | Abc | 124 |  | 3500 |  | 3500
6 | Abc | 125 |  | 3500 |  | 3500
7 | Abc | 126 |  | 2000 |  | 2000
8 | Abc | 127 |  | 2000 |  | 2000
9 | Abc | 128 | 2009-12-08 00:00:00 | 2000 |  | 2000 |  |  |  |  | 2000
10 | Abc | 129 | 2009-07-15 00:00:00 | 2000 |  | 2000
11 | Abc | 130 | Not Availing | 0 | 2009-07-10 00:00:00 | 2000
12 | Abc | 131 | 2009-09-29 00:00:00 | 2000 | 2009-08-21 00:00:00 | 2000
13 | Abc | 132 | 2009-09-29 00:00:00 | 2000 | 2009-08-21 00:00:00 | 2000
14 | Abc | 133 | Not Availing | 0 | 2011-08-12 00:00:00 | 2000
15 | Abc | 134 | 2012-02-13 00:00:00 | 2000 | 2012-02-29 00:00:00 | 2000
16 | Abc | 135 | 2009-09-10 00:00:00 | 1500 | 2009-09-10 00:00:00 | 1500
17 | Abc | 136 |  | 1500 | 2012-02-29 00:00:00 | 1500
18 | Abc | 137 | 2010-02-26 00:00:00 | 1500 | 2010-02-18 00:00:00 | 1500
19 | Abc | 138 |  | 1500 |  | 1500 |  |  |  |  | 800
20 | Abc | 139 |  | 1500 |  | 1500
21 | Abc | 140 | 2009-11-17 00:00:00 | 1500 |  | 1500
22 | Abc | 141 |  | 1500 | 2011-05-31 00:00:00 | 1500
23 | Abc | 142 |  | 1500 |  | 1500 |  |  |  |  | 2300
24 | Abc | 143 | 2010-12-09 00:00:00 | 1500 | 2011-01-03 00:00:00 | 1500
25 | Abc | 144 |  | 1500 |  | 1500 |  |  |  |  | 1500
26 | Abc | 145 |  | 1500 |  | 1500
27 | Abc | 146 |  | 1500 |  | 1500
28 | Abc | 147 | 2009-09-10 00:00:00 | 1500 |  | 1500
29 | Abc | 148 |  | 1500 |  | 1500
30 | Abc | 149 |  | 1500 |  | 1500
31 | Abc | 150 |  | 1500 |  | 1500
32 | Abc | 151 | Not Availing |  |  | 1500
33 | Abc | 152 | 2009-08-26 00:00:00 | 1500 |  | 1500
34 | Abc | 153 |  | 1500 |  | 1500
35 | Abc | 154 | 2010-02-26 00:00:00 | 1500 | 2010-08-03 00:00:00 | 1500
36 | Abc | 155 | 2010-01-04 00:00:00 | 1500 | 2010-01-04 00:00:00 | 1500
37 | Abc | 156 | Not Availing | 0 |  | 1500
38 | Abc | 157 | 2010-01-21 00:00:00 | 1500 | 2010-01-21 00:00:00 | 1500
39 | Abc | 158 | Not Availing | 0 | 2010-12-23 00:00:00 | 1500
40 | Abc | 159 | 2010-02-08 00:00:00 | 1500 | 2010-02-08 00:00:00 | 1500
41 | Abc | 160 | 2010-01-04 00:00:00 | 1500 | 2010-01-04 00:00:00 | 1500
42 | Abc | 161 | 2010-01-21 00:00:00 | 1500 | 2010-01-21 00:00:00 | 1500 |  |  |  |  | 1130
43 | Abc | 162 | 2011-02-03 00:00:00 | 1500 |  | 1500
44 | Abc | 163 | 2011-08-05 00:00:00 | 1500 |  | 1500
45 | Abc | 164 | 2010-12-21 00:00:00 | 1500 |  | 1500
46 | Abc | 165 | 2010-12-09 00:00:00 | 1500 |  | 1500 |  |  |  |  | 2500
47 | Abc | 166 | 2011-01-19 00:00:00 | 1500 |  | 1500
48 | Abc | 167 | 2011-01-19 00:00:00 | 1500 |  | 1500
49 | Abc | 168 | 2010-12-21 00:00:00 | 1500 |  | 1500
50 | Abc | 169 | 2011-01-19 00:00:00 | 1500 |  | 1500
51 | Abc | 170 | Not Availing | 0 |  | 1500
52 | Abc | 171 | 2012-05-18 00:00:00 | 1500 |  | 1500
53 | Abc | 172 | 2011-12-26 00:00:00 | 1500 |  | 1500
54 | Abc | 173 | Not Availing | 0 |  | 1500
55 | Abc | 174 | 2012-02-02 00:00:00 | 1500 |  | 1500
56 | Abc | 175 | Not Availing | 0 |  | 1500
57 | Abc | 176 | Not Availing | 0 |  | 1500
58 | Abc | 177 | 2012-04-25 00:00:00 | 1500 |  | 1500
59 | Abc | 178 | 2011-12-26 00:00:00 | 1500 |  | 1500
60 | Abc | 179 | 2011-12-26 00:00:00 | 1500 |  | 1500
61 | Abc | 180 | 2010-05-21 00:00:00 | 1500 | 2009-08-21 00:00:00 | 1500
62 | Abc | 181 | 2010-12-21 00:00:00 | 1500 | 2010-08-02 00:00:00 | 1500
63 | Abc | 182 | Not Availing | 0 | 2009-04-08 00:00:00 | 1500
64 | Abc | 183 | 2011-12-26 00:00:00 | 1500 | 2010-08-10 00:00:00 | 1500
65 | Abc | 184 | Not Availing | 0 | 2010-01-11 00:00:00 | 1500
66 | Abc | 185 | 2011-12-26 00:00:00 | 1500 | 2010-10-11 00:00:00 | 1500
67 | Abc | 186 | 2010-01-21 00:00:00 | 1500 | 2010-01-21 00:00:00 | 1500 |  |  |  |  | 2500
68 | Abc | 187 | 2012-01-04 00:00:00 | 1500 | 2011-07-18 00:00:00 | 1500
69 | Abc | 188 | Not Availing | 0 |  | 1500
70 | Abc | 189 | Not Availing | 0 | 2011-08-12 00:00:00 | 1500
71 | Abc | 190 | Not Availing | 0 | 2011-09-01 00:00:00 | 1500
72 | Abc | 191 | Not Availing | 0 |  | 1500
73 | Abc | 192 | Not Availing | 0 |  | 700
74 | Abc | 193 | Not Availing | 0 |  | 700
75 | Abc | 194 | Not Availing | 0 |  | 700
76 | Abc | 195 | Not Availing | 0 |  | 700
77 | Abc | 196 | Not Availing | 0 |  | 700
78 | Abc | 197 | Not Availing | 0 |  | 700
79 | Abc | 198 | Not Availing | 0 |  | 700
80 | Abc | 199 | Not Availing | 0 | 2009-07-10 00:00:00 | 700
81 | Abc | 200 | Not Availing | 0 | 2009-10-09 00:00:00 | 700
82 | Abc | 201 | Not Availing | 0 | 2009-10-09 00:00:00 | 700
83 | Abc | 202 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
84 | Abc | 203 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
85 | Abc | 204 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
86 | Abc | 205 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
87 | Abc | 206 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
88 | Abc | 207 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
89 | Abc | 208 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
90 | Abc | 209 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
91 | Abc | 210 | Not Availing | 0 | 2009-06-30 00:00:00 | 700
92 | Abc | 211 | Not Availing | 0 | 2009-07-10 00:00:00 | 700
93 | Abc | 212 | Not Availing | 0 | 2009-04-08 00:00:00 | 700
94 | Abc | 213 | Not Availing | 0 | 2009-04-08 00:00:00 | 700
95 | Abc | 214 | Not Availing | 0 | 2010-03-16 00:00:00 | 700
96 | Abc | 215 | Not Availing | 0 | 2010-03-16 00:00:00 | 700
97 | Abc | 216 | Not Availing | 0 | 2010-07-10 00:00:00 | 700
98 | Abc | 217 | Not Availing | 0 | 2010-07-10 00:00:00 | 700
99 | Abc | 218 | Not Availing | 0 | 2010-07-10 00:00:00 | 700
100 | Abc | 219 | Not Availing | 0 | 2011-03-01 00:00:00 | 700
101 | Abc | 220 | Not Availing | 0 | 2010-12-23 00:00:00 | 700
102 | Abc | 221 | Not Availing | 0 | 2011-03-22 00:00:00 | 700
103 | Abc | 222 | Not Availing | 0 | 2012-04-19 00:00:00 | 700
104 | Abc | 223 | Not Availing | 0 |  | 700
105 | Abc | 224 | Not Availing | 0 | 2012-04-15 00:00:00 | 700
106 | Abc | 225 | Not Availing | 0 | 2012-04-09 00:00:00 | 700
107 | Abc | 226 | Not Availing | 0 | 2012-04-17 00:00:00 | 700
108 | Abc | 227 | Not Availing | 0 | 2012-04-14 00:00:00 | 700
109 | Abc | 228 | Not Availing | 0 | 2012-04-12 00:00:00 | 700
110 | Abc | 229 | Not Availing | 0 | 2012-04-13 00:00:00 | 700
111 | Abc | 230 | Not Availing | 0 | 2012-04-11 00:00:00 | 700
112 | Abc | 231 | Not Availing | 0 | 2012-04-20 00:00:00 | 700
113 | Abc | 232 | Not Availing | 0 | 2012-04-06 00:00:00 | 700
114 | Abc | 233 | Not Availing | 0 | 2012-04-10 00:00:00 | 700
115 | Abc | 234 | Not Availing | 0 | 2012-04-18 00:00:00 | 700
116 | Abc | 235 | Not Availing | 0 | 2012-04-16 00:00:00 | 700
117 | Abc | 236 | Not Availing | 0 |  | 700
118 | Abc | 237 | Not Availing | 0 | 2012-05-25 00:00:00 | 700
119 | Abc | 238 | Not Availing | 0 | 2012-04-23 00:00:00 | 700
120 | Abc | 239 | Not Availing | 0 |  | 700
121 | Abc | 240 | Not Availing | 0 | 2012-04-23 00:00:00 | 700
122 | Abc | 241 | Not Availing | 0 | 2009-10-09 00:00:00 | 600
123 | Abc | 242 | Not Availing | 0 | 2010-02-18 00:00:00 | 600
124 | Abc | 243 | Not Availing | 0 | 2010-02-18 00:00:00 | 600
125 | Abc | 244 | Not Availing | 0 | 2010-02-18 00:00:00 | 600
126 | Abc | 245 | Not Availing | 0 | 2010-01-21 00:00:00 | 600
127 | Abc | 246 | Not Availing | 0 | 2010-02-18 00:00:00 | 600
128 | Abc | 247 | Not Availing | 0 | 2010-12-23 00:00:00 | 600
129 | Abc | 248 | Not Availing | 0 | 2011-01-28 00:00:00 | 600
130 | Abc | 249 | Not Availing | 0 | 2012-04-03 00:00:00 | 600
131 | Abc | 250 | Not Availing | 0 | 2012-04-01 00:00:00 | 600
132 | Abc | 251 | Not Availing | 0 | 2010-02-18 00:00:00 | 600
133 | Abc | 252 | Not Availing | 0 | 2012-04-08 00:00:00 | 600
134 | Abc | 253 | Not Availing | 0 | 2010-04-05 00:00:00 | 600
135 | Abc | 254 | Not Availing | 0 | 2010-02-06 00:00:00 | 600
136 | Abc | 255 | Not Availing | 0 | 2012-04-05 00:00:00 | 600
137 | Abc | 256 | Not Availing | 0 | 2012-04-02 00:00:00 | 600
138 | Abc | 257 | Not Availing | 0 | 2012-04-02 00:00:00 | 600
139 | Abc | 258 | Not Availing | 0 | 2012-04-04 00:00:00 | 600
140 | Abc | 259 | Not Availing | 0 | 2012-04-01 00:00:00 | 600
141 | Abc | 260 | Not Availing | 0 |  | 600
142 | Abc | 261 | Not Availing | 0 | 2010-02-06 00:00:00 | 600
143 | Abc | 262 | Not Availing | 0 | 2012-04-07 00:00:00 | 600
144 | Abc | 263 | Not Availing | 0 |  | 600
145 | Abc | 264 | Not Availing | 0 | 2010-08-04 00:00:00 | 600
146 | Abc | 265 | Not Availing | 0 |  | 600
147 | Abc | 266 | Not Availing | 0 |  | 600
148 | Abc | 267 | Not Availing | 0 |  | 600
149 | Abc | 268 | Not Availing | 0 | 2012-04-01 00:00:00 | 600
150 | Abc | 269 | Not Availing | 0 | 2010-04-05 00:00:00 | 600
151 | Abc | 270 | Not Availing | 0 | 2010-04-05 00:00:00 | 600
152 | Abc | 271 | Not Availing | 0 |  | 600
153 | Abc | 272 | Not Availing | 0 | 2010-02-06 00:00:00 | 600
154 | Abc | 273 | Not Availing | 0 | 2010-05-26 00:00:00 | 600
155 | Abc | 274 | Not Availing | 0 | 2010-10-14 00:00:00 | 600
156 | Abc | 275 | Not Availing | 0 | 2010-01-11 00:00:00 | 600
157 | Abc | 276 | Not Availing | 0 | 2011-01-28 00:00:00 | 600
158 | Abc | 277 | Not Availing | 0 |  | 600
159 | Abc | 278 | Not Availing | 0 | 2011-07-22 00:00:00 | 600
160 | Abc | 279 | Not Availing | 0 |  | 600
161 | Abc | 280 | Not Availing | 0 |  | 600
162 | Abc | 281 | Not Availing | 0 | 2010-08-07 00:00:00 | 600
163 | Abc | 282 | Not Availing | 0 |  | 600