Spreadsheet: 196725d1354090571-vba-or-macro-to-copy-specific-value-to-another-worksheet-from-raw-sheet-clustwise-nov-12
Sheet: cluster wise

 |  |  |  |  |  |  |  |  |  | .
 | MAHARASHTRA REGION - CLUSTERWISE TGT VS SALES AS ON |  |  |  | 25 Nov 12
Sr. | Booking | Biz as on |  | Total Target Nov. 2012 | Biz as on |  | Gap | Average Business Reqd/day
 |  | 25 Oct 12 | % Achvd |  | 25 Nov 12 | % Achvd
 | AURANGABAD CLUSTER
1 | 0135 : AHMEDNAGAR | 1.1291697 | 0.2682113301662708 | 4.21 | 1.6079398 | 0.3819334441805226 | 2.6020602 | 0.2891178
2 | 0140 : AURANGABAD | 4.3290847 | 0.5027972938443671 | 8.61 | 4.4450002 | 0.5162601858304298 | 4.164999799999999 | 0.4627777555555555
3 | 0335 : NANDED | 0.0456301 | 0.9126019999999999 | 0.05 | 0.01476 | 0.2952 | 0.03524 | 0.003915555555555556
4 | 0337 : WALUJ (AURANGABAD) | 11.6843365 | 0.4907323183536329 | 23.81 | 11.5698035 | 0.4859220285594289 | 12.2401965 | 1.360021833333333
 | SUB TOTAL | 17.188221 | 0.4685992639040349 | 36.68 | 17.6375035 | 0.4808479689203926 | 19.0424965 | 2.115832944444444
 | NASIK CLUSTER
5 | 0112 : SATPUR | 21.53963 | 0.797764074074074 | 27 | 12.1736001 | 0.4508740777777778 | 14.8263999 | 1.647377766666667
6 | 0490 : MALEGAON | 0.42527 | 0.170108 | 2.5 | 1.7287 | 0.69148 | 0.7713000000000001 | 0.08570000000000001
7 | 0704 : SANGAMNER | 1.11831 | 2.23662 | 0.5 | 0.2534188 | 0.5068376 | 0.2465812 | 0.02739791111111111
8 | 0710 : SINNAR (MIDC) | 8.110869300000001 | 0.5407246200000001 | 15 | 7.4555685 | 0.4970379 | 7.5444315 | 0.8382701666666666
 | SUB TOTAL | 31.1940793 | 0.6932017622222223 | 45 | 21.6112874 | 0.4802508311111112 | 23.3887126 | 2.598745844444444
 | [NAME]
9 | 0113 : BELGAUM CITY | 0.1309 | 2.617999999999999 | 0.05 | 0.0322 | 0.6439999999999999 | 0.0178 | 0.001977777777777778
10 | 0176 : KOLHAPUR (SHIROLI) | 4.1146618 | 0.6369445510835914 | 6.46 | 4.47063 | 0.6920479876160991 | 1.98937 | 0.2210411111111111
11 | 0195 : MADHAVNAGAR | 0.09806 | 0.06326451612903225 | 1.55 | 0.01325 | 0.008548387096774194 | 1.53675 | 0.17075
12 | 0229 : HUBLI | 4.9889848 | 0.3687350184774575 | 13.53 | 5.6583235 | 0.4182057280118256 | 7.8716765 | 0.8746307222222222
13 | 0238 : SATARA | 1.940847 | 0.5953518404907977 | 3.26 | 2.7346158 | 0.8388392024539879 | 0.5253841999999995 | 0.05837602222222217
14 | 0275 : KARAD | 0.14062 | 0.2467017543859649 | 0.57 | 0.0438 | 0.07684210526315789 | 0.5262 | 0.05846666666666667
15 | 0288 : BELGAUM (UDYAMBAUG) | 10.202764 | 0.9309091240875912 | 10.96 | 4.383538499999999 | 0.3999578923357663 | 6.576461500000002 | 0.7307179444444446
16 | 1253 : GOKUL SHIRGAON | 0.8780030999999999 | 0.6651538636363635 | 1.32 | 0.7016417 | 0.5315467424242424 | 0.6183583 | 0.06870647777777777
 | SUB TOTAL | 22.4948407 | 0.596680124668435 | 37.7 | 18.0379995 | 0.4784615251989389 | 19.6620005 | 2.184666722222223
 | [NAME]
17 | 0651 : VERNA | 3.33699 | 0.667398 | 5 | 2.1599418 | 0.43198836 | 2.8400582 | 0.3155620222222222
0 | 0652 : PANJIM | 0.02275 | 0.455 | 0.05 | 0.0636757 | 1.273514 | -0.0136757 | -0.001519522222222222
19 | 0653 : MAPUSA | 2.3476902 | 0.4245371066907775 | 5.53 | 2.4605274 | 0.4449416636528028 | 3.069472600000001 | 0.3410525111111112
20 | 1008 : MARGAO CITY | 0.11375 | 0.21875 | 0.52 | 0.0446 | 0.08576923076923076 | 0.4754 | 0.05282222222222223
21 | 1091 : PONDA KURTI | 3.0178575 | 0.5021393510815307 | 6.01 | 3.8431715 | 0.6394628119800334 | 2.166828499999999 | 0.2407587222222222
 | SUB TOTAL | 8.839037699999999 | 0.516600683810637 | 17.11 | 8.5719164 | 0.5009886849795441 | 8.5380836 | 0.9486759555555556
 | PUNE CLUSTER
22 | 0117 : WAGHOLI | 2.3077585 | 0.4615517000000001 | 5 | 4.0169035 | 0.8033807 | 0.9830965000000003 | 0.1092329444444445
23 | 0209 : LONAVALA | 2.2037783 | 0.8850515261044175 | 2.49 | 0.9618596 | 0.3862889959839357 | 1.5281404 | 0.1697933777777778
24 | 0242 : PIMPRI-CHINCHWAD | 9.7936148 | 0.4453667485220555 | 21.99 | 10.9636489 | 0.4985743019554343 | 11.0263511 | 1.225150122222222
25 | 0283 : CHAKAN | 2.5161053 | 0.3870931230769231 | 6.5 | 3.6672486 | 0.5641920923076923 | 2.8327514 | 0.3147501555555556
26 | 0340 : PHURSUNGI | 0.68697 | 0.15266 | 4.5 | 1.06983 | 0.23774 | 3.43017 | 0.38113
27 | 0342 : SOLAPUR | 0 | 0 | 0.21 | 0 | 0 | 0.21 | 0.02333333333333333
28 | 0449 : PIRANGUT | 1.7828409 | 0.5751099677419355 | 3.1 | 1.0865045 | 0.3504853225806451 | 2.0134955 | 0.2237217222222223
29 | 0467 : BHOSARI | 0.4625474 | 0.3083649333333333 | 1.5 | 0.3981366000000001 | 0.2654244000000001 | 1.1018634 | 0.1224292666666667
30 | 0583 : KOREGAON BHIMA | 1.96997 | 0.5969606060606061 | 3.3 | 1.4354632 | 0.4349888484848485 | 1.8645368 | 0.2071707555555555
31 | 0597 : URULIKANCHAN | 1.4336807 | 0.3853980376344086 | 3.72 | 0.75679 | 0.2034381720430107 | 2.96321 | 0.3292455555555556
32 | 0721 : TALEGAON | 0.7377326 | 0.3783244102564102 | 1.95 | 0.5870385 | 0.3010453846153847 | 1.3629615 | 0.1514401666666667
33 | 0752 : BARAMATI | 1.5958537 | 0.8965470224719101 | 1.78 | 1.1085404 | 0.6227755056179775 | 0.6714596000000002 | 0.07460662222222224
34 | 0768 : KHEDSHIVAPUR | 3.452709 | 0.4946574498567335 | 6.98 | 4.1607875 | 0.5961013610315186 | 2.819212500000001 | 0.3132458333333334
35 | 0777 : WADGAON BUDRUK | 2.7311417 | 0.4965712181818182 | 5.5 | 1.7885946 | 0.3251990181818182 | 3.7114054 | 0.4123783777777778
36 | 1025 : TATHWADE | 0.4911205 | 0.1956655378486056 | 2.51 | 0.3767048 | 0.150081593625498 | 2.1332952 | 0.2370328
37 | 1219 : RANJANGAON | 0.52188 | 0.3034186046511628 | 1.72 | 0.330346 | 0.1920616279069767 | 1.389654 | 0.154406
38 | 1235 : KURULI | 0 | 0 | 2 | 0 | 0 | 2 | 0.2222222222222222
39 | 1248 : KURKUMBH | 3.217985 | 0.6876036324786325 | 4.68 | 2.8810061 | 0.6155995940170941 | 1.7989939 | 0.1998882111111111
40 | 1277 : CHAKAN INDL AREA | 1.4532676 | 0.3229483555555556 | 4.5 | 1.0094025 | 0.2243116666666667 | 3.4905975 | 0.3878441666666667
41 | 1278 : CHAKAN MIDC | 11.3421396 | 0.8218941739130434 | 13.8 | 7.1065001 | 0.5149637753623189 | 6.693499900000001 | 0.7437222111111113
42 | 1280 : HADAPSAR | 0.7410039 | 0.37050195 | 2 | 0 | 0 | 2 | 0.2222222222222222
43 | 1286 : POONA CITY BKG | 4.3812115 | 0.5624148267008986 | 7.79 | 2.9598078 | 0.3799496534017972 | 4.8301922 | 0.5366880222222222
44 | 1288 : TALAWADE | 0 | 0 | 1 | 0 | 0 | 1 | 0.1111111111111111
45 | 1289 : BHOSARIGAON | 4.8733218 | 1.177130869565218 | 4.14 | 2.029015 | 0.4901002415458937 | 2.110985 | 0.2345538888888889
 | SUB TOTAL | 58.69663279999999 | 0.5210068595774896 | 112.66 | 48.69412819999999 | 0.4322219794070654 | 63.96587180000002 | 7.10731908888889
Page Total |  | 138.4128115 | 0.5555400822797509 | 249.15 | 114.552835 | 0.4597745735500702 | 134.597165 | 14.95524055555556