Spreadsheet: 154322d1336383072-sum-formulae-sample-data-2-
Sheet: Data

Customer | Location | DM | [NAME]. Jan 2012 | Rev Act. Jan 2012 | % | Rev. Trg. Feb 2012 | Rev. Act. Feb 2012 | % | Rev. Tar.Mar 2012 | Rev. Act. Mar 2012 | % | Rev. Tar. Apr 2012 | Rev. Act. Apr 2012 | % | Rev. Tar. May 2012 | Rev. Act. May 2012 | % | Rev. Tar. Jun 2012 | Rev. Act. Jun 2012 | % | Rev. Tar. Jul 2012 | Rev. Act. Jul 2012 | % | Rev. Tar. Aug 2012 | Rev. Act. Aug 2012 | % | Rev. Tar. Sep 2012 | Rev. Act. Sep 2012 | % | Rev. Tar. Oct 2012 | Rev. Act. Oct 2012 | % | Rev. Tar. Nov 2012 | Rev. Act. Nov 2012 | % | Rev. Tar. Dec 2012 | Rev. Act. Dec 2012 | % | Rev. Tar. Q1 | Rev. Act. Q1 | % | Rev. Tar. Q2 | Rev. Act. Q2 | % | Rev. Tar. Q3 | Rev. Act. Q3 | % | Rev. Tar. Q4 | Rev. Act. Q4 | % | Rev. Tar. H1 | Rev. Act. H1 | % | Rev. Tar. H2 | Rev. Act. H2 | % | Total Rev Tar 2012 | Total Rev Act 2012 | %
AAA | CSS | Vijay | 3398720 | 4124680 | 1.213598060446286 | 3398720 | 3905240 | 1.149032576970153 | 3398720 | 4000680 | 1.177113736936258 | 3725520 |  | 0 | 3725520 |  | 0 | 3725520 |  | 0 | 3790880 |  | 0 | 3790880 |  | 0 | 3790880 |  | 0 | 4117680 |  | 0 | 4117680 |  | 0 | 4117680 |  | 0 | 10196160 | 12030600 | 1.179914791450899 | 11176560 | 0 | 0 | 11372640 | 0 | 0 | 12353040 | 0 | 0 | 21372720 | 12030600 | 0.562895129866484 | 23725680 | 0 | 0 | 45098400 | 12030600 | 0.2667633441541163
AAA | CSS | Vijay | 1602080 | 1360000 | 0.8488964346349746 | 1602080 | 1575520 | 0.9834215519824229 | 1602080 | 1566240 | 0.9776290821931489 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 1602080 |  | 0 | 4806240 | 4501760 | 0.9366490229368488 | 4806240 | 0 | 0 | 4806240 | 0 | 0 | 4806240 | 0 | 0 | 9612480 | 4501760 | 0.4683245114684244 | 9612480 | 0 | 0 | 19224960 | 4501760 | 0.2341622557342122
AAA | CSS | Raju | 2643280 | 2646400 | 1.001180351684271 | 2643280 | 2762320 | 1.045034956569111 | 2643280 | 2924880 | 1.106534305862413 | 2643280 |  | 0 | 2643280 |  | 0 | 2643280 |  | 0 | 2929040 |  | 0 | 2929040 |  | 0 | 2929040 |  | 0 | 2929040 |  | 0 | 2929040 |  | 0 | 2929040 |  | 0 | 7929840 | 8333600 | 1.050916538038599 | 7929840 | 0 | 0 | 8787120 | 0 | 0 | 8787120 | 0 | 0 | 15859680 | 8333600 | 0.5254582690192993 | 17574240 | 0 | 0 | 33433920 | 8333600 | 0.2492558455604368
AAA | IH | Raju | 8645000 | 8864910 | 1.025437825332562 | 8645000 | 2545680 | 0.2944684788895315 | 9500000.000000002 | 8160985 | 0.8590510526315788 | 10640000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 10735000 |  | 0 | 26790000 | 19571575 | 0.7305552444942143 | 32110000 | 0 | 0 | 32205000 | 0 | 0 | 32205000 | 0 | 0 | 58900000 | 19571575 | 0.3322848047538201 | 64410000 | 0 | 0 | 123310000 | 19571575 | 0.158718473765307
AAA | IH | PS | 160000 | 56640 | 0.354 | 160000 | 0 | 0 | 160000 | 22880 | 0.143 | 320000 |  | 0 | 320000 |  | 0 | 320000 |  | 0 | 400000 |  | 0 | 400000 |  | 0 | 400000 |  | 0 | 400000 |  | 0 | 400000 |  | 0 | 400000 |  | 0 | 480000 | 79520 | 0.1656666666666667 | 960000 | 0 | 0 | 1200000 | 0 | 0 | 1200000 | 0 | 0 | 1440000 | 79520 | 0.05522222222222222 | 2400000 | 0 | 0 | 3840000 | 79520 | 0.02070833333333333
BBB | CSS | Ravi / Raju | 15996253.6728 | 16649338.1094 | 1.040827336822653 | 17316663.9912 | 19829134.6893 | 1.14508976436667 | 18530674.56 | 20678644.44 | 1.115914284342167 | 18513556.4304 |  | 0 | 18284436.8496 |  | 0 | 18155592 |  | 0 | 18246549.5208 |  | 0 | 18126483.1992 |  | 0 | 18009948.24 |  | 0 | 17893413.2808 |  | 0 | 17773346.9592 |  | 0 | 17656812 |  | 0 | 51843592.22399999 | 57157117.23869999 | 1.102491451436118 | 54953585.28 | 0 | 0 | 54382980.95999999 | 0 | 0 | 53323572.23999999 | 0 | 0 | 106797177.504 | 57157117.23869999 | 0.5351931443746182 | 107706553.2 | 0 | 0 | 214503730.704 | 57157117.23869999 | 0.2664621125754348
BBB | Onsite | Ravi / Raju | 2699109.6 | 3138844.92 | 1.162918660287081 | 3154813.2 | 3768524.64 | 1.194531784005468 | 3611520 | 3083508 | 0.8537978468899522 | 4458388 |  | 0 | 4403212 |  | 0 | 4347200 |  | 0 | 4319612 |  | 0 | 4291188 |  | 0 | 4263600 |  | 0 | 4236012 |  | 0 | 4207588 |  | 0 | 4180000 |  | 0 | 9465442.8 | 9990877.559999999 | 1.055510848367284 | 13208800 | 0 | 0 | 12874400 | 0 | 0 | 12623600 | 0 | 0 | 22674242.8 | 9990877.559999999 | 0.440626734401909 | 25498000 | 0 | 0 | 48172242.8 | 9990877.559999999 | 0.2073990534648721
CCC | IH | Raju | 1220410.8 | 1013027.06 | 0.8300705467372134 | 1222678.8 | 2647425.7575 | 2.165266754850089 | 1224720 | 2083077 | 1.700859788359788 | 2073470.4 |  | 0 | 2047809.6 |  | 0 | 2021760 |  | 0 | 2343751.2 |  | 0 | 2328328.8 |  | 0 | 2313360 |  | 0 | 2298391.2 |  | 0 | 2282968.8 |  | 0 | 2268000 |  | 0 | 3667809.6 | 5743529.8175 | 1.565929108615671 | 6143040 | 0 | 0 | 6985440 | 0 | 0 | 6849360 | 0 | 0 | 9810849.6 | 5743529.8175 | 0.585426344472756 | 13834800 | 0 | 0 | 23645649.6 | 5743529.8175 | 0.2429000646909696
DDD | IH | [NAME] | 3777462 | 1832069.07 | 0.485 | 3784482 | 1857307.32 | 0.4907692307692308 | 3790800 | 1844856 | 0.4866666666666667 | 4319730 |  | 0 | 4266270 |  | 0 | 4212000 |  | 0 | 5022324 |  | 0 | 4989276 |  | 0 | 4957200 |  | 0 | 4925124 |  | 0 | 4892076 |  | 0 | 4860000 |  | 0 | 11352744 | 5534232.39 | 0.4874797132746057 | 12798000 | 0 | 0 | 14968800 | 0 | 0 | 14677200 | 0 | 0 | 24150744 | 5534232.39 | 0.2291537018486884 | 29646000 | 0 | 0 | 53796744 | 5534232.39 | 0.102872998968116
DDD | Onsite | [NAME] | 559624 | 1353590.55 | 2.41875 | 560664 | 1342089.45 | 2.39375 | 561600 | 1418040 | 2.525 | 554632 |  | 0 | 547768 |  | 0 | 540800 |  | 0 | 537368 |  | 0 | 533832 |  | 0 | 530400 |  | 0 | 526968 |  | 0 | 523432 |  | 0 | 520000 |  | 0 | 1681888 | 4113720 | 2.445894138016325 | 1643200 | 0 | 0 | 1601600 | 0 | 0 | 1570400 | 0 | 0 | 3325088 | 4113720 | 1.237176279244339 | 3172000 | 0 | 0 | 6497088 | 4113720 | 0.6331636573184787
DDD | CSS | [NAME] | 57600 | 72675 | 1.26171875 | 57600 | 76500 | 1.328125 | 57600 | 68850 | 1.1953125 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 57600 |  | 0 | 172800 | 218025 | 1.26171875 | 172800 | 0 | 0 | 172800 | 0 | 0 | 172800 | 0 | 0 | 345600 | 218025 | 0.630859375 | 345600 | 0 | 0 | 691200 | 218025 | 0.3154296875
EEE | IH | [NAME] | 678006 | 401551.744 | 0.5922539682539683 | 679266 | 349164.288 | 0.5140317460317461 | 680400 | 1743163.2 | 2.561968253968254 | 839947.5 |  | 0 | 829552.5 |  | 0 | 819000 |  | 0 | 976563 |  | 0 | 970137 |  | 0 | 963900 |  | 0 | 1276884 |  | 0 | 1268316 |  | 0 | 945000 |  | 0 | 2037672 | 2493879.232 | 1.223886490072985 | 2488500 | 0 | 0 | 2910600 | 0 | 0 | 3490200 | 0 | 0 | 4526172 | 2493879.232 | 0.5509908222665864 | 6400800 | 0 | 0 | 10926972 | 2493879.232 | 0.2282315020117192
FFF | IH | PS | 1278525.6 | 1122342.075 | 0.877840909090909 | 1280901.6 | 1753658.8758 | 1.36908164983165 | 1283040 | 1136329.02 | 0.8856536195286195 | 1689494.4 |  | 0 | 1668585.6 |  | 0 | 1647360 |  | 0 | 2455358.4 |  | 0 | 2439201.6 |  | 0 | 2423520 |  | 0 | 2809144.8 |  | 0 | 2790295.2 |  | 0 | 2772000 |  | 0 | 3842467.2 | 4012329.9708 | 1.044206693761758 | 5005440 | 0 | 0 | 7318080 | 0 | 0 | 8371440 | 0 | 0 | 8847907.2 | 4012329.9708 | 0.4534778541529007 | 15689520 | 0 | 0 | 24537427.2 | 4012329.9708 | 0.1635187722859551
GGG | IH | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 170656 |  | 0 | 168544 |  | 0 | 166400 |  | 0 | 330688 |  | 0 | 328512 |  | 0 | 326400 |  | 0 | 486432 |  | 0 | 483168 |  | 0 | 480000 |  | 0 | 0 | 0 |  | 505600 | 0 | 0 | 985600 | 0 | 0 | 1449600 | 0 | 0 | 505600 | 0 | 0 | 2435200 | 0 | 0 | 2940800 | 0 | 0
HHH | IH | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 372024 |  | 0 | 369576 |  | 0 | 367200 |  | 0 | 364824 |  | 0 | 362376 |  | 0 | 360000 |  | 0 | 0 | 0 |  | 0 | 0 |  | 1108800 | 0 | 0 | 1087200 | 0 | 0 | 0 | 0 |  | 2196000 | 0 | 0 | 2196000 | 0 | 0
Others | IH | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 191988 |  | 0 | 189612 |  | 0 | 187200 |  | 0 | 372024 |  | 0 | 369576 |  | 0 | 367200 |  | 0 | 364824 |  | 0 | 362376 |  | 0 | 360000 |  | 0 | 0 | 0 |  | 568800 | 0 | 0 | 1108800 | 0 | 0 | 1087200 | 0 | 0 | 568800 | 0 | 0 | 2196000 | 0 | 0 | 2764800 | 0 | 0
III | IH | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 170656 |  | 0 | 168544 |  | 0 | 166400 |  | 0 | 330688 |  | 0 | 328512 |  | 0 | 326400 |  | 0 | 486432 |  | 0 | 483168 |  | 0 | 480000 |  | 0 | 0 | 0 |  | 505600 | 0 | 0 | 985600 | 0 | 0 | 1449600 | 0 | 0 | 505600 | 0 | 0 | 2435200 | 0 | 0 | 2940800 | 0 | 0
JJJ | IH | [NAME] | 0 |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
KKK | CSS | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 84480 |  | 0 | 84480 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 168960 |  | 0 | 0 | 0 |  | 337920 | 0 | 0 | 506880 | 0 | 0 | 506880 | 0 | 0 | 337920 | 0 | 0 | 1013760 | 0 | 0 | 1351680 | 0 | 0
LLL | CSS | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
MMM | CSS | PS | 0 |  |  | 0 | 0 |  | 0 |  |  | 190080 |  | 0 | 190080 |  | 0 | 190080 |  | 0 | 285120 |  | 0 | 285120 |  | 0 | 285120 |  | 0 | 285120 |  | 0 | 285120 |  | 0 | 285120 |  | 0 | 0 | 0 |  | 570240 | 0 | 0 | 855360 | 0 | 0 | 855360 | 0 | 0 | 570240 | 0 | 0 | 1710720 | 0 | 0 | 2280960 | 0 | 0
NNN | CSS | [NAME] | 585000 | 279425 | 0.4776495726495726 | 585000 | 508200 | 0.8687179487179487 | 585000 | 589800 | 1.008205128205128 | 702000 |  | 0 | 702000 |  | 0 | 702000 |  | 0 | 819000 |  | 0 | 819000 |  | 0 | 936000 |  | 0 | 936000 |  | 0 | 936000 |  | 0 | 936000 |  | 0 | 1755000 | 1377425 | 0.7848575498575499 | 2106000 | 0 | 0 | 2574000 | 0 | 0 | 2808000 | 0 | 0 | 3861000 | 1377425 | 0.3567534317534318 | 5382000 | 0 | 0 | 9243000 | 1377425 | 0.1490235854159905
OOO | IH | PS | 117000 | 134750 | 1.151709401709402 | 117000 | 0 | 0 | 117000 | 210000 | 1.794871794871795 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 117000 |  | 0 | 351000 | 344750 | 0.9821937321937322 | 351000 | 0 | 0 | 351000 | 0 | 0 | 351000 | 0 | 0 | 702000 | 344750 | 0.4910968660968661 | 702000 | 0 | 0 | 1404000 | 344750 | 0.245548433048433
 |  |  | 43418071.6728 | 43050243.52840001 | 0.9915282247638276 | 45208149.5912 | 42920765.0206 | 0.9494032692936131 | 47746434.56 | 49531932.66 | 1.037395422641585 | 53064558.7304 | 0 | 0 | 52751374.54960001 | 0 | 0 | 52525232 | 0 | 0 | 56211630.1208 | 0 | 0 | 55979302.5992 | 0 | 0 | 55870808.23999999 | 0 | 0 | 57016929.2808 | 0 | 0 | 56777590.95919999 | 0 | 0 | 56230292 | 0 | 0 | 136372655.824 | 135502941.209 | 0.9936225146474934 | 158341165.28 | 0 | 0 | 168061740.96 | 0 | 0 | 170024812.24 | 0 | 0 | 294713821.104 | 135502941.209 | 0.4597780338275451 | 338086553.2 | 0 | 0 | 632800374.3040001 | 135502941.209 | 0.2141322077409262