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

FTD  - 14/09/2012
A/C Type | AMDAM | AMDCT | AMDRJ | BDQBD | BDQBR | GDDGD | GRNGR | GWLGW | IDRBH | IDRID | JGRJG | JLRJL | VAPSR | VAPVA | Total
Group Co. | 0.03 |  |  | 0 | 0.11 |  |  |  | 0.02 | 0 |  | 0 |  | 0 | 0.16
Key | 0.52 | 0 |  |  |  |  |  |  |  | 0.08 |  |  | 0 | 0.01 | 0.62
NBD |  |  |  |  |  |  |  |  |  |  |  |  | 0.1 |  | 0.1
RBD | 0.26 | 0.25 | 0.31 | 0.58 |  |  | 0.04 |  | 0.15 | 0.48 |  |  | 0.04 | 1.34 | 3.45
Total | 0.8 | 0.25 | 0.31 | 0.59 | 0.11 |  | 0.04 |  | 0.17 | 0.55 |  | 0 | 0.14 | 1.36 | 4.33
MTD - 14/09/2012
A/C Type | AMDAM | AMDCT | AMDRJ | BDQBD | BDQBR | GDDGD | GRNGR | GWLGW | IDRBH | IDRID | JGRJG | JLRJL | VAPSR | VAPVA | Total
Group Co. | 0.15 | 0.01 |  | 0.02 | 0.11 |  |  |  | 0.15 | 0.06 | 0 | 0 |  | 0.08 | 0.58
Key | 4 | 0.12 | 0.1 | 0.42 |  | 0 | 0.06 |  | 0.15 | 1.37 | 0.08 | 0.01 | 0.17 | 0.48 | 6.95
NBD | 0.02 |  |  |  |  |  |  |  |  |  |  |  | 0.31 |  | 0.34
RBD | 2.93 | 3.41 | 1.89 | 6.6 | 0.58 | 0.04 | 0.6 | 0.06 | 0.93 | 5.57 | 2.43 | 0.34 | 0.38 | 10.6 | 36.34
Total | 7.1 | 3.53 | 1.99 | 7.04 | 0.69 | 0.05 | 0.66 | 0.06 | 1.23 | 7.01 | 2.5 | 0.35 | 0.86 | 11.15 | 44.21
Last Month | 6.73 | 3.59 | 2.09 | 8.37 | 0.7 | 0 | 0.77 | 0.13 | 2.29 | 5.91 | 3.75 | 0.31 | 0.44 | 9.18 | 44.26
MTD Growth | 0.37 | -0.05 | -0.1 | -1.33 | -0.01 | 0.05 | -0.11 | -0.08 | -1.06 | 1.1 | -1.25 | 0.04 | 0.42 | 1.97 | -0.05
RBD - 14/09/12
Branches Position   → |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | Region : | W-II | VAPVA | IDRID | JGRJG | AMDRJ | AMDCT | BDQBD | AMDAM | GRNGR | BDQBR | JLRJL | IDRBH | VAPSR | GDDGD | GWLGW
Last Month Business |  | 78.46 | 19.07 | 8.74 | 5.56 | 3.7 | 7.6 | 18.71 | 6.69 | 1.81 | 1.34 | 0.68 | 3.39 | 0.85 | 0.05 | 0.26
For the Month | Target | 114 | 25 | 14 | 7.25 | 6 | 11 | 24 | 11 | 2.5 | 2.5 | 1.5 | 5 | 2.5 | 0.75 | 1
 | Actual | 36.34 | 10.6 | 5.57 | 2.43 | 1.89 | 3.41 | 6.6 | 2.93 | 0.6 | 0.58 | 0.34 | 0.93 | 0.38 | 0.04 | 0.06
 | [NAME] | -77.66 | -14.4 | -8.43 | -4.82 | -4.11 | -7.59 | -17.4 | -8.07 | -1.9 | -1.92 | -1.16 | -4.07 | -2.12 | -0.71 | -0.94
 | Achieved % | 0.32 | 0.42 | 0.4 | 0.33 | 0.32 | 0.31 | 0.28 | 0.27 | 0.24 | 0.23 | 0.23 | 0.19 | 0.15 | 0.06 | 0.06
August'12 MTD BIZ |  | 34.59 | 8.39 | 3.38 | 3.6 | 1.91 | 3.2 | 7.86 | 2.65 | 0.72 | 0.5700000000000001 | 0.09 | 1.77 | 0.37 | 0 | 0.08
Growth |  | 1.75 | 2.2 | 2.19 | -1.17 | -0.01 | 0.2 | -1.25 | 0.28 | -0.12 | 0.01 | 0.25 | -0.85 | 0.01 | 0.04 | -0.02
Average Per Day BIZ |  | 3.03 | 0.88 | 0.46 | 0.2 | 0.16 | 0.28 | 0.55 | 0.24 | 0.05 | 0.05 | 0.03 | 0.08 | 0.03 | 0 | 0
[NAME] Per Day |  | 5.97 | 1.11 | 0.65 | 0.37 | 0.32 | 0.58 | 1.34 | 0.62 | 0.15 | 0.15 | 0.09 | 0.31 | 0.16 | 0.05 | 0.07
[NAME] |  | -2.95 | -0.23 | -0.18 | -0.17 | -0.16 | -0.3 | -0.79 | -0.38 | -0.1 | -0.1 | -0.06 | -0.24 | -0.13 | -0.05 | -0.07
MEO | MEO | 75.71 | 22.07 | 11.61 | 5.06 | 3.94 | 7.1 | 13.75 | 6.1 | 1.25 | 1.2 | 0.71 | 1.93 | 0.79 | 0.09 | 0.12
 | MEO - Target | -38.29 | -2.93 | -2.39 | -2.19 | -2.06 | -3.9 | -10.25 | -4.9 | -1.25 | -1.3 | -0.79 | -3.07 | -1.71 | -0.66 | -0.88
For the Day | No of Dkt | 124 | 39 | 15 | 0 | 11 | 14 | 9 | 16 | 9 | 0 | 0 | 10 | 1 | 0 | 0
 | Business | 3.45 | 1.34 | 0.48 | 0 | 0.31 | 0.25 | 0.58 | 0.26 | 0.04 | 0 | 0 | 0.15 | 0.04 | 0 | 0
 | Weight in [NAME] | 46.9 | 21.02 | 7.11 | 0 | 4.47 | 2.5 | 6.33 | 2.72 | 0.42 | 0 | 0 | 2.12 | 0.21 | 0 | 0
 | Yield | 7.35 | 6.39 | 6.7 | 0 | 6.97 | 10.07 | 9.23 | 9.41 | 9.41 | 0 | 0 | 6.87 | 19.15 | 0 | 0
MTD | Target | 54.72 | 12 | 6.72 | 3.48 | 2.88 | 5.28 | 11.52 | 5.28 | 1.2 | 1.2 | 0.72 | 2.4 | 1.2 | 0.36 | 0.48
 | Actual | 36.34 | 10.6 | 5.57 | 2.43 | 1.89 | 3.41 | 6.6 | 2.93 | 0.6 | 0.58 | 0.34 | 0.93 | 0.38 | 0.04 | 0.06
 | [NAME] | -18.38 | -1.4 | -1.15 | -1.05 | -0.99 | -1.87 | -4.92 | -2.35 | -0.6 | -0.62 | -0.38 | -1.47 | -0.82 | -0.32 | -0.42
 | Achieved % | 0.66 | 0.88 | 0.83 | 0.7 | 0.66 | 0.65 | 0.57 | 0.55 | 0.5 | 0.48 | 0.47 | 0.39 | 0.32 | 0.12 | 0.12
 | No of Dkt | 1524 | 344 | 205 | 133 | 66 | 196 | 123 | 163 | 104 | 49 | 17 | 80 | 31 | 7 | 6
 | Weight in [NAME] | 452 | 146 | 73 | 26 | 28 | 41 | 73 | 35 | 6 | 5 | 3 | 13 | 2 | 0 | 0
 | Yield | 8.05 | 7.27 | 7.59 | 9.33 | 6.74 | 8.23 | 9.07 | 8.45 | 10.32 | 10.77 | 11.97 | 7.21 | 17.54 | 21.42 | 12