Spreadsheet: 887995d1738311195-incentive-data-calculation-incentive-new-final
Sheet: team

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17
 |  |  |  |  | Target |  |  |  | Achievement |  |  |  | Collection
 |  |  |  |  | April'24 | May'24 | June'24 | Target Q1FY24 | April'24 | May'24 | June'24 | [NAME] | April'24 | May'24 | June'24 | Q1FY25
Location | RM EMP Code | Reporting Manager Name | Emp Code | Employee Name | Target | Target | Target
Mumbai | 123456 | Ram | 123 | Prachi | 18 | 32 | 32 |  | 21.894263 | 46.99193099999999 | 69.75906810000001 |  | 30 | 32 | 25
Mumbai | 123456 | Ram | 124 | Ankur | 0 | 12 | 8 |  | 1.857682 | 7.093509 | 3
Mumbai | 123456 | Ram | 125 | Pal | 8 | 12 | 8 |  | 0.0585 | 6.8 | 0
Mumbai | 123456 | Ram | 126 | Chetan | 18 | 38 | 38 |  | 22.295157 | 8.052828 | 74.5005411 |  | -11.34531 | -15.78306 | 0
Mumbai | 123456 | Ram | 127 | Raju | 0 | 0 | 0
Mumbai | 123456 | Ram | 128 | Ray | 0 | 10 | 19
Mumbai | 123456 | Ram | 129 | Phadnis | 56 | 21 | 20 |  | 67.7033 | 65.528207 | 18.5074
 |  | RamTotal
Mumbai | 123457 | Chirag | 130 | Aruti | 10 | 25 | 30 |  | 4.566625 | 32.375705 | 0.2482935
Mumbai | 123457 | Chirag | 131 | Mohamd | 50 | 18 | 12 |  | 35.6469434 | 2.8529613 | 3.166214
Mumbai | 123457 | Chirag | 132 | Anand | 20 | 20 | 20 |  | 20.511069 | 27.9099333 | 1.930392
Mumbai | 123457 | Chirag | 133 | Jayotsna | 0 | 7 | 8 |  | 0.42228 | 1.33016 | 5.044756
 |  | Chirag Total
Mumbai | 123458 | Faheem | 123457 | Chirag | 80 | 70 | 70 | 220 | 61.1469174 | 64.46875960000001 | 10.3896555 | 136.0053325 | 0 | 0 | 0 | 0
Mumbai | 123458 | Faheem | 123458 | lalsh | 80 | 80 | 80 | 240 | 61.305735 | 39.650462 | 47.70549869999999 | 148.6616957 | 0 | 0 | 0 | 0
 |  | [NAME]
Mumbai | 123458 | Lalsh | 134 | majid | 20 | 15 | 15 |  | 3.187695 | 5.1787 | 13.6694457
Mumbai | 123458 | Lalsh | 135 | [NAME] | 0 | 5 | 5 |  | 0 | 1.969 | 7.67875
Mumbai | 123458 | Lalsh | 136 | Himmat | 40 | 30 | 30 |  | 35.46504 | 19.66296 | 11.6378
Mumbai | 123458 | Lalsh | 137 | Gorge | 0 | 5 | 5 |  | 0 | 0.6 | 0.3
Mumbai | 123458 | Lalsh | 138 | [NAME] | 0 | 0 | 10
Mumbai | 123458 | Lalsh | 139 | hetan | 20 | 25 | 5 |  | 22.653 | 12.239802 | 14.095503
Mumbai | 123458 | Lalsh | 140 | [NAME] | 0 | 0 | 10 |  | 0 | 0 | 0.324
 |  | Lalsh Total
Mumbai | 123460 | Mathur | 123456 | Ram | 100 | 125 | 125 | 350 | 113.808902 | 134.466475 | 165.7670092 | 414.0423862 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123460 | Mathur | 123459 | Sayonee | 80 | 95 | 95 | 270 | 51.284575 | 105.59045 | 116.128878 | 273.003903 | 0 | 0 | 0 | 0
 |  | Mathur Total
Mumbai | 123459 | Sayonee | 141 | [NAME] | 50 |  |  |  | 38.284575 | 1.759725 | 0
Mumbai | 123459 | Sayonee | 142 | Meghna | 0 | 0 | 25 |  | 0 | 0 | 39.521628
Mumbai | 123459 | Sayonee | 143 | Sachin | 30 | 95 | 70 |  | 13 | 103.830725 | 76.60725
 |  | Sayonee Total
Mumbai | 123655 | Nilu | 123458 | Faheem | 160 | 150 | 150 | 460 | 122.4526524 | 104.1192216 | 58.0951542 | 284.6670282 | 0 | 0 | 0 | 0
Mumbai | 123655 | Nilu | 123460 | Mathur | 180 | 220 | 220 | 620 | 165.093477 | 240.056925 | 281.8958871999999 | 687.0462891999999 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123900 | Maran | 123655 | Nilu
 |  | Nilu Total |  |  | 340 | 370 | 370 | 1080 | 287.5461294 | 344.1761466 | 339.9910414 | 971.7133173999999 | 18.65469 | 16.21694 | 25 | 59.87163