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

LOCATION | EMP CODE | EMPLOYEE NAME | TARGET  APRIL'24 TARGET | TARGET  MAY'24 TARGET | TARGET  [NAME] | TARGET  TARGET Q1FY24 | ACHIEVEMENT APRIL'24 | ACHIEVEMENT MAY'24 | ACHIEVEMENT JUNE'24 | ACHIEVEMENT ACH Q1FY25 | COLLECTION APRIL'24 | COLLECTION MAY'24 | COLLECTION JUNE'24 | COLLECTION Q1FY25
Mumbai | 123 | Prachi | 18 | 32 | 32 | 82 | 21.894263 | 46.99193099999999 | 69.75906810000001 | 138.6452621 | 30 | 32 | 25 | 87
Mumbai | 124 | Ankur | 0 | 12 | 8 | 20 | 1.857682 | 7.093509 | 3 | 11.951191 |  |  |  | 0
Mumbai | 125 | Pal | 8 | 12 | 8 | 28 | 0.0585 | 6.8 | 0 | 6.8585 |  |  |  | 0
Mumbai | 126 | Chetan | 18 | 38 | 38 | 94 | 22.295157 | 8.052828 | 74.5005411 | 104.8485261 | -11.34531 | -15.78306 | 0 | -27.12837
Mumbai | 127 | Raju | 0 | 0 | 0 | 0 |  |  |  | 0 |  |  |  | 0
Mumbai | 128 | Ray | 0 | 10 | 19 | 29 |  |  |  | 0 |  |  |  | 0
Mumbai | 129 | Phadnis | 56 | 21 | 20 | 97 | 67.7033 | 65.528207 | 18.5074 | 151.738907 |  |  |  | 0
Mumbai | 130 | Aruti | 10 | 25 | 30 | 65 | 4.566625 | 32.375705 | 0.2482935 | 37.19062350000001 |  |  |  | 0
Mumbai | 131 | Mohamd | 50 | 18 | 12 | 80 | 35.6469434 | 2.8529613 | 3.166214 | 41.6661187 |  |  |  | 0
Mumbai | 132 | Anand | 20 | 20 | 20 | 60 | 20.511069 | 27.9099333 | 1.930392 | 50.3513943 |  |  |  | 0
Mumbai | 133 | Jayotsna | 0 | 7 | 8 | 15 | 0.42228 | 1.33016 | 5.044756 | 6.797196 |  |  |  | 0
Mumbai | 134 | majid | 20 | 15 | 15 | 50 | 3.187695 | 5.1787 | 13.6694457 | 22.0358407 |  |  |  | 0
Mumbai | 135 | [NAME] | 0 | 5 | 5 | 10 | 0 | 1.969 | 7.67875 | 9.64775 |  |  |  | 0
Mumbai | 136 | Himmat | 40 | 30 | 30 | 100 | 35.46504 | 19.66296 | 11.6378 | 66.7658 |  |  |  | 0
Mumbai | 137 | Gorge | 0 | 5 | 5 | 10 | 0 | 0.6 | 0.3 | 0.8999999999999999 |  |  |  | 0
Mumbai | 138 | [NAME] | 0 | 0 | 10 | 10 |  |  |  | 0 |  |  |  | 0
Mumbai | 139 | hetan | 20 | 25 | 5 | 50 | 22.653 | 12.239802 | 14.095503 | 48.988305 |  |  |  | 0
Mumbai | 140 | [NAME] | 0 | 0 | 10 | 10 | 0 | 0 | 0.324 | 0.324 |  |  |  | 0
Mumbai | 141 | [NAME] | 50 |  |  | 50 | 38.284575 | 1.759725 | 0 | 40.0443 |  |  |  | 0
Mumbai | 142 | Meghna | 0 | 0 | 25 | 25 | 0 | 0 | 39.521628 | 39.521628
Mumbai | 143 | Sachin | 30 | 95 | 70 | 195 | 13 | 103.830725 | 76.60725 | 193.437975 |  |  |  | 0
Mumbai | 123456 | Ram | 100 | 125 | 125 | 350 | 113.808902 | 134.466475 | 165.7670092 | 414.0423862 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123456 | Ram | 100 | 125 | 125 | 350 | 113.808902 | 134.466475 | 165.7670092 | 414.0423862 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123457 | Chirag | 80 | 70 | 70 | 220 | 61.1469174 | 64.46875960000001 | 10.3896555 | 136.0053325 | 0 | 0 | 0 | 0
Mumbai | 123457 | Chirag | 80 | 70 | 70 | 220 | 61.1469174 | 64.46875960000001 | 10.3896555 | 136.0053325 | 0 | 0 | 0 | 0
Mumbai | 123458 | Faheem | 160 | 150 | 150 | 460 | 122.4526524 | 104.1192216 | 58.0951542 | 284.6670282 | 0 | 0 | 0 | 0
Mumbai | 123458 | lalsh | 80 | 80 | 80 | 240 | 61.305735 | 39.650462 | 47.70549869999999 | 148.6616957 | 0 | 0 | 0 | 0
Mumbai | 123458 | lalsh | 80 | 80 | 80 | 240 | 61.305735 | 39.650462 | 47.70549869999999 | 148.6616957 | 0 | 0 | 0 | 0
Mumbai | 123458 | Faheem | 160 | 150 | 150 | 460 | 122.4526524 | 104.1192216 | 58.0951542 | 284.6670282 | 0 | 0 | 0 | 0
Mumbai | 123459 | Sayonee | 80 | 95 | 95 | 270 | 51.284575 | 105.59045 | 116.128878 | 273.003903 | 0 | 0 | 0 | 0
Mumbai | 123459 | Sayonee | 80 | 95 | 95 | 270 | 51.284575 | 105.59045 | 116.128878 | 273.003903 | 0 | 0 | 0 | 0
Mumbai | 123460 | Mathur | 180 | 220 | 220 | 620 | 165.093477 | 240.056925 | 281.8958871999999 | 687.0462891999999 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123460 | Mathur | 180 | 220 | 220 | 620 | 165.093477 | 240.056925 | 281.8958871999999 | 687.0462891999999 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123655 | Nilu | 340 | 370 | 370 | 1080 | 287.5461294 | 344.1761466 | 339.9910414 | 971.7133173999999 | 18.65469 | 16.21694 | 25 | 59.87163
Mumbai | 123655 | Nilu | 340 | 370 | 370 | 1080 | 287.5461294 | 344.1761466 | 339.9910414 | 971.7133173999999 | 18.65469 | 16.21694 | 25 | 59.87163