Spreadsheet: 195826d1353675833-in-vlook-if-value-comes-to-n-a-i-want-there-0-new-clustwise-nov-12
Sheet: cluster wise

 | MAHARASHTRA REGION - CLUSTERWISE TGT VS SALES AS ON  21/11/2012
Sr. | Booking | Biz as on |  | Total Target Nov. 2012 | Biz as on |  | Gap | Average Business Reqd/day
 |  | 23/10/2012 | % Achvd |  | 23/11/2012 | % Achvd
 | AURANGABAD CLUSTER |  |  | Mr. [NAME] Sales Manager  - [PHONE]
1 | 0135 : AHMEDNAGAR |  | #N/A | 4.21 | 0.021 | 0.00498812351543943 | 4.189 | 0.4654444444444444
2 | 0140 : AURANGABAD | 0.00793 | 0.0009210220673635307 | 8.61 | 0.00793 | 0.0009210220673635307 | 8.60207 | 0.9557855555555554
3 | 0335 : NANDED | 0.00793 | 0.1586 | 0.05 | 0.00793 | 0.1586 | 0.04207 | 0.004674444444444445
4 | 0337 : WALUJ (AURANGABAD) | 0.6202433 | 0.02604969760604788 | 23.81 | 0.6202433 | 0.02604969760604788 | 23.1897567 | 2.576639633333333
 | SUB TOTAL | 0.6361033 | 0.01734196564885496 | 36.68 | 0.6571033000000001 | 0.01791448473282443 | 36.0228967 | 4.002544077777777
 | NASIK CLUSTER |  |  | Mr. [NAME] Jhajhria - Area Manager  - [PHONE] |  |  |  | 0
5 | 0112 : SATPUR | 1.05294 | 0.03899777777777778 | 27 | 1.05294 | 0.03899777777777778 | 25.94706 | 2.883006666666667
6 | 0490 : MALEGAON | 0.00793 | 0.003172 | 2.5 | 0.00793 | 0.003172 | 2.49207 | 0.2768966666666667
7 | 0704 : SANGAMNER | 0.4007 | 0.8014 | 0.5 | 0.4007 | 0.8014 | 0.0993 | 0.01103333333333333
8 | 0710 : SINNAR (MIDC) | 0.3136659 | 0.02091106 | 15 | 0.3136659 | 0.02091106 | 14.6863341 | 1.6318149
 | SUB TOTAL | 1.7752359 | 0.03944968666666666 | 45 | 1.7752359 | 0.03944968666666666 | 43.2247641 | 4.802751566666667
 | [NAME] |  |  | Mrs. [NAME] Manager  - [PHONE] |  |  |  | 0
9 | 0113 : BELGAUM CITY | 0.00793 | 0.1586 | 0.05 | 0.00793 | 0.1586 | 0.04207 | 0.004674444444444445
10 | 0176 : KOLHAPUR (SHIROLI) | 0.43377 | 0.0671470588235294 | 6.46 | 0.43377 | 0.0671470588235294 | 6.02623 | 0.6695811111111111
11 | 0195 : MADHAVNAGAR | 0.00793 | 0.005116129032258064 | 1.55 | 0.00793 | 0.005116129032258064 | 1.54207 | 0.1713411111111111
12 | 0229 : HUBLI | 0.35403 | 0.02616629711751663 | 13.53 | 0.35403 | 0.02616629711751663 | 13.17597 | 1.463996666666667
13 | 0238 : SATARA | 0.00793 | 0.002432515337423313 | 3.26 | 0.00793 | 0.002432515337423313 | 3.25207 | 0.3613411111111111
14 | 0275 : KARAD | 0.00793 | 0.01391228070175439 | 0.57 | 0.00793 | 0.01391228070175439 | 0.56207 | 0.06245222222222221
15 | 0288 : BELGAUM (UDYAMBAUG) | 0.08576 | 0.007824817518248175 | 10.96 | 0.08576 | 0.007824817518248175 | 10.87424 | 1.208248888888889
16 | 1253 : GOKUL SHIRGAON | 0.00793 | 0.006007575757575757 | 1.32 | 0.00793 | 0.006007575757575757 | 1.31207 | 0.1457855555555556
 | SUB TOTAL | 0.9132100000000001 | 0.02422307692307692 | 37.7 | 0.9132100000000001 | 0.02422307692307692 | 36.78679 | 4.087421111111111
 | [NAME] |  |  | Mr.[NAME] - Area Manager - [PHONE] |  |  |  | 0
17 | 0651 : VERNA | 0.5466 | 0.10932 | 5 | 0.5466 | 0.10932 | 4.4534 | 0.4948222222222223
0 | 0652 : PANJIM | 0.00793 | 0.1586 | 0.05 | 0.00793 | 0.1586 | 0.04207 | 0.004674444444444445
19 | 0653 : MAPUSA | 0.050631 | 0.009155696202531646 | 5.53 | 0.050631 | 0.009155696202531646 | 5.479369 | 0.6088187777777778
20 | 1008 : MARGAO CITY | 0.00747 | 0.01436538461538461 | 0.52 | 0.00747 | 0.01436538461538461 | 0.51253 | 0.05694777777777778
21 | 1091 : PONDA KURTI | 0.1947227 | 0.0323997836938436 | 6.01 | 0.1947227 | 0.0323997836938436 | 5.8152773 | 0.6461419222222222
 | SUB TOTAL | 0.8073537 | 0.04718607247223846 | 17.11 | 0.8073537 | 0.04718607247223846 | 16.3026463 | 1.811405144444444
 | PUNE CLUSTER |  |  | Mr. [NAME] Manager - [PHONE] |  |  |  | 0
22 | 0117 : WAGHOLI | 0.00793 | 0.001586 | 5 | 0.00793 | 0.001586 | 4.99207 | 0.5546744444444445
23 | 0209 : LONAVALA | 0.00793 | 0.003184738955823293 | 2.49 | 0.00793 | 0.003184738955823293 | 2.48207 | 0.2757855555555556
24 | 0242 : PIMPRI-CHINCHWAD | 0.00793 | 0.000360618462937699 | 21.99 | 0.00793 | 0.000360618462937699 | 21.98207 | 2.442452222222222
25 | 0283 : CHAKAN | 0.1323828 | 0.02036658461538461 | 6.5 | 0.1323828 | 0.02036658461538461 | 6.3676172 | 0.7075130222222222
26 | 0340 : PHURSUNGI | 0.00793 | 0.001762222222222222 | 4.5 | 0.00793 | 0.001762222222222222 | 4.49207 | 0.4991188888888889
27 | 0342 : SOLAPUR | 0.00793 | 0.03776190476190476 | 0.21 | 0.00793 | 0.03776190476190476 | 0.20207 | 0.02245222222222222
28 | 0449 : PIRANGUT | 0.215 | 0.06935483870967742 | 3.1 | 0.215 | 0.06935483870967742 | 2.885 | 0.3205555555555556
29 | 0467 : BHOSARI | 0.0552045 | 0.036803 | 1.5 | 0.0552045 | 0.036803 | 1.4447955 | 0.1605328333333333
30 | 0583 : KOREGAON BHIMA | 0.00793 | 0.002403030303030303 | 3.3 | 0.00793 | 0.002403030303030303 | 3.29207 | 0.3657855555555555
31 | 0597 : URULIKANCHAN | 0.13938 | 0.03746774193548387 | 3.72 | 0.13938 | 0.03746774193548387 | 3.58062 | 0.3978466666666667
32 | 0721 : TALEGAON | 0.00793 | 0.004066666666666666 | 1.95 | 0.00793 | 0.004066666666666666 | 1.94207 | 0.2157855555555556
33 | 0752 : BARAMATI | 0.05685 | 0.03193820224719101 | 1.78 | 0.05685 | 0.03193820224719101 | 1.72315 | 0.1914611111111111
34 | 0768 : KHEDSHIVAPUR | 0.09033209999999998 | 0.01294156160458452 | 6.98 | 0.09033209999999998 | 0.01294156160458452 | 6.8896679 | 0.7655186555555555
35 | 0777 : WADGAON BUDRUK | 0.12598 | 0.02290545454545455 | 5.5 | 0.12598 | 0.02290545454545455 | 5.37402 | 0.5971133333333333
36 | 1025 : TATHWADE | 0.00793 | 0.003159362549800797 | 2.51 | 0.00793 | 0.003159362549800797 | 2.50207 | 0.2780077777777777
37 | 1219 : RANJANGAON | 0.0763 | 0.04436046511627907 | 1.72 | 0.0763 | 0.04436046511627907 | 1.6437 | 0.1826333333333333
38 | 1235 : KURULI | 0.00793 | 0.003965 | 2 | 0.00793 | 0.003965 | 1.99207 | 0.2213411111111111
39 | 1248 : KURKUMBH | 0.19575 | 0.04182692307692308 | 4.68 | 0.19575 | 0.04182692307692308 | 4.484249999999999 | 0.4982499999999999
40 | 1277 : CHAKAN INDL AREA | 0.00793 | 0.001762222222222222 | 4.5 | 0.00793 | 0.001762222222222222 | 4.49207 | 0.4991188888888889
41 | 1278 : CHAKAN MIDC | 0.8462139999999999 | 0.06131985507246376 | 13.8 | 0.8462139999999999 | 0.06131985507246376 | 12.953786 | 1.439309555555556
42 | 1280 : HADAPSAR | 0.00793 | 0.003965 | 2 | 0.00793 | 0.003965 | 1.99207 | 0.2213411111111111
43 | 1286 : POONA CITY BKG | 0.0523739 | 0.006723222079589217 | 7.79 | 0.0523739 | 0.006723222079589217 | 7.7376261 | 0.8597362333333334
44 | 1288 : TALAWADE | 0.00793 | 0.00793 | 1 | 0.00793 | 0.00793 | 0.99207 | 0.11023
45 | 1289 : BHOSARIGAON | 1.3071972 | 0.315748115942029 | 4.14 | 1.3071972 | 0.315748115942029 | 2.8328028 | 0.3147558666666666
 | SUB TOTAL | 3.3881245 | 0.03007389046689153 | 112.66 | 3.3881245 | 0.03007389046689153 | 109.2718755 | 12.1413195
Page Total |  | 7.520027400000001 | 0.03018273088500903 | 249.15 | 7.541027400000001 | 0.03026701745936183 | 241.6089726 | 26.84544140000001