Spreadsheet: 889977d1741072691-excel-formula-for-sales-incentive-hierarchy-level-sum-jeysjeys-target-allocation-spill-365-aligw
Sheet: CALC

 |  |  | July'24 | Aug'24 | Sept'24 | Q2 FY25
Sno. | E ECN | Employee Name | Target | Target | Target | Total
1 | 10903822 | Aishwarya Prachi |  | 26 | 13 | 65
2 | 10903824 | [NAME] | 10 | 10 | 15 | 35
3 | 10903665 | Dibyendu Rabindranath Pal | 15 | 15 | 2 | 32
4 | 10903548 | Divyank Hitesh Udani | 0 | 0 | 0 | 0
5 | 10903719 | Krunal Chetan Rupani | 45 | 45 | 50 | 140
6 | 10903545 | [NAME] | 0 | 0 | 0 | 0
7 | 10903857 | [NAME] | 0 | 0 | 20 | 20
8 | 10903832 | [NAME] | 0 | 0 | 0 | 0
9 | 10903616 | [NAME] | 24 | 24 | 35 | 83
10 | 10903817 | [NAME] | 25 | 30 | 30 | 85
11 | 10903620 | [NAME] | 7.5 | 10 | 5 | 22.5
12 | 10903526 | Kailash Anand Shinde | 30 | 30 | 30 | 90
13 | 3256625 | Ketan Prakash Netawate | 7.5 | 10 | 0 | 17.5
14 | 3455918 | Meha Samit Shah |  |  | 10 | 0
15 | 10903794 | Chirag Kishor Limbad | 0 | 0 | 0 | 0
16 | 10903316 | Prajeshlal Prakashan Podikalamparambil | 0 | 0 | 0 | 0
17 | 10903610 | Akbarali [NAME] | 10 | 10 | 10 | 30
18 | 10903821 | [NAME] | 5 | 5 | 5 | 15
19 | 10903829 | Dimple Kamlesh Desai | 15 | 15 | 15 | 45
20 | 10903561 | Siddhant Chandrakant Naik | 0 | 0 | 0 | 0
21 | 3305957 | [NAME] | 5 | 5 | 5 | 15
22 | 3212442 | [NAME] | 5 | 5 | 5 | 15
23 | 10903833 | [NAME] [NAME] | 25 | 25 | 25 | 75
24 | 10903429 | Vikas Ratan Sharma | 20 | 20 | 20 | 60
25 | 10903404 | [NAME] | 0 | 0 | 0 | 0
26 | 10903463 | Suman [NAME] | 0 | 0 | 0 | 0
27 | 10903830 | Meghna Adhikary | 35 | 45 | 31 | 111
28 | 10903650 | [NAME] Amandeep [NAME] | 0 | 0 | 0 | 0
29 | 10903639 | Sumeet Ramesh Kotwani | 65 | 55 | 74 | 194
30 | 10903549 | [NAME] Faheem Qadri | 0 | 0 | 0 | 0
31 | 10903334 | [NAME] | 0 | 0 | 0 | 0
32 | 10903785 | [NAME] | 14 | 20 | 32 | 66
33 | 10903798 | Deepshikha Vij | 14 | 15 | 30 | 59
34 | 10903662 | [NAME] | 8 | 7 | 7 | 22
35 | 10903663 | Prachi Gogia | 6 | 8 | 8 | 22
36 | 10903750 | [NAME] | 0 | 0 | 0 | 0
37 | 10903433 | Ranu Sinha | 28 | 28 | 26 | 82
38 | 10903588 | Sonal Mathur | 34 | 33 | 35 | 102
39 | 10903624 | Sumit Verma | 0 | 0 | 30 | 30
40 | 10902417 | Sushant Bector | 0 | 0 | 0 | 0
41 | 10903182 | Vineet Hooda | 4.6 | 4.6 | 4.6 | 13.8
42 | 10903266 | [NAME] |  |  |  | 0
43 | 10903839 | Animesh Jain | 7 | 8.8 | 34.8 | 50.59999999999999
44 | 10903791 | [NAME] | 28.8 | 30 | 0 | 58.8
45 | 10903640 | [NAME] | 27 | 27 | 27 | 81
46 | 3090274 | [NAME] |  |  |  | 0
47 | 10903677 | Minakshi | 0 | 0 | 0 | 0
48 | 10903880 | Prince Kumar Singh |  |  |  | 0
49 | 3083932 | Rohit Kumar |  |  |  | 0
50 | 10903708 | Rohit [NAME] | 23 | 23 | 23 | 69
51 | 3065208 | Siddhant Tanwar |  |  |  | 0
52 | 10903697 | [NAME] | 17 | 19 | 17 | 53
53 | 10903800 | [NAME] | 32 | 30 | 0 | 62
54 | 2944692 | [NAME] |  |  |  | 0
55 | 10903854 | Priya Balhra | 0 | 0 | 0 | 0
56 | 3396263 | Sameer Chauhan | 12 | 11 | 11 | 34
57 | 10903881 | [NAME] |  |  |  | 0
58 | 10903755 | Karan Talwar | 18 | 18 | 20 | 56
59 | 10903590 | [NAME] | 29 | 60 | 70 | 159
60 | 10903813 | Pooja Bhairuram Kumawat | 6 | 7 | 6 | 19
61 | 10903773 | Sabyasachi Garai | 0 | 0 | 0 | 0
62 | 10903636 | [NAME] | 0 | 0 | 0 | 0
63 | 3348058 | Ravinder [NAME] | 6.1 | 6.1 | 6.1 | 18.3
64 | 10903428 | [NAME] | 0 | 0 | 0 | 0
65 | 10903842 | Sumit Kumar | 23 | 23 | 23 | 69
66 | 3449681 | [NAME] |  |  |  | 0
67 | 3396264 | Zaid khan | 5.5 | 5.5 | 5.5 | 16.5
68 | 10903608 | [NAME] |  |  |  | 0
69 | 10903860 | M Padma Priya |  |  | 18 | 0
70 | 10903517 | Shivakumar Rasure | 24 | 27 | 27 | 78
71 | 10903838 | [NAME] | 3 | 5 | 6 | 14
72 | 10903820 | C Vandana | 4 | 4 | 4 | 12
73 | 10903479 | Nishchith J R | 14 | 14 | 14 | 42
74 | 10903858 | Karna Naresh Kumar |  |  | 6 | 0
75 | 10903569 | S Ajad Hussain | 10 | 15 | 15 | 40
76 | 10903583 | [NAME] | 17 | 23 | 24 | 64
77 | 10903743 | [NAME] | 0 | 0 | 0 | 0
78 | 3363026 | Shruthi T | 3 | 5 | 5 | 13
79 | 10903531 | [NAME] | 12 | 15 | 15 | 42
80 | 10903444 | [NAME] | 12 | 13 | 13 | 38
81 | 10903667 | Shinoy S Thomas | 12 | 14 | 14 | 40
82 | 10903769 | Mayank [NAME] | 9 | 12 | 12 | 33
83 | 10903747 | [NAME] | 8 | 11 | 12 | 31
84 | 10903004 | [NAME] | 0 | 0 | 0 | 0
85 | #N/A | [NAME] | #N/A | #N/A | #N/A | #N/A
86 | 10903827 | [NAME] | 0 | 0 | 0 | 0
87 | 10903840 | Vinay Kumar P G | 24 | 27 | 45 | 96
88 | 10903836 | [NAME] | 23 | 24 | 25 | 72
89 | 10903714 | [NAME] | 0 | 0 | 0 | 0
90 | 10903572 | Indrani [NAME] | 16 | 0 | 0 | 16
91 | 10903465 | Neela Jan | 18 | 25 | 30 | 73
92 | 10903886 | [NAME] |  |  |  | 0
93 | 10903352 | [NAME] | 0 | 0 | 0 | 0
94 | 10903666 | Shilpa Samanta | 7 | 17 | 15 | 39
95 | 10902819 | Debrup Banerjee | 0 | 0 | 0 | 0
96 | 10903792 | [NAME] | 0 | 0 | 0 | 0
97 | 10903834 | Aishwarya Mukherjee | 12 | 12 | 14 | 38
98 | 10903784 | [NAME] | 0 | 0 | 0 | 0
99 | 10903778 | Reshma Yeasmin | 14 | 15 | 16 | 45
100 | 10903893 | [NAME] |  |  |  | 0
101 | 10903740 | [NAME] Kumar | 28 | 27 | 30 | 85
102 | 10903866 | Yanikapati Pradeep | 0 | 0 | 12 | 12
103 | 10903293 | Dinesh Parsa | 24.5 | 23 | 0 | 47.5
104 | 10903853 | [NAME] [NAME] | 0 | 0 | 27 | 27
105 | 10903862 | [NAME] | 0 | 0 | 26 | 26
106 | 10903749 | [NAME] | 26 | 24 | 0 | 50
107 | 10902789 | Haleema Hasrat | 11.5 | 11 | 0 | 22.5
108 | 10903748 | [NAME] | 28 | 17 | 42 | 87
109 | 10902196 | Murali Netheti | 50.5 | 47 | 53 | 150.5
110 | 10903509 | Muthyala Reddy Anil Kumar Reddy | 90 | 85 | 95 | 270
111 | 3075364 | [NAME] | 3 | 2.5 | 2.5 | 8
112 | 10902871 | [NAME] | 9 | 11 | 9 | 29
113 | 10903871 | [NAME] |  |  | 10 | 0
114 | 10903668 | S B Sarath | 8 | 10 | 9 | 27
115 | 10902150 | Abhilash Sethurayar | 17 | 19 | 0 | 36
116 | 10903877 | Soundarya Subbaraj |  |  | 10 | 0
117 | 10903874 | Anand R |  |  |  | 0
118 | 10901888 | Vinu R | 0 | 0 | 0 | 0
119 | 2661531 | C K Balaji | 10 | 10 | 9 | 29
120 | 10903630 | [NAME] | 10 | 9 | 10 | 29
121 | 10903770 | [NAME] | 9 | 10 | 10 | 29
122 | 10903646 | [NAME] | 9 | 8 | 8 | 25
123 | 10902729 | Harish Ravindranath | 0 | 0 | 0 | 0
124 | 1454100 | Mahububali A |  |  |  | 0
125 | 2703272 | [NAME] | 8 | 7.1 | 8 | 23.1
126 | 10901691 | [NAME] | 7 | 8 | 8 | 23
127 | 10902554 | Sathish A | 7 | 7 | 8 | 22
128 | 10902691 | Santhosh Divakaran | 20 | 22 | 30 | 72
129 | 10902671 | [NAME] | 0 | 0 | 0 | 0
130 | 10903478 | Anoop P | 8 | 8 | 20 | 36
131 | 10903876 | [NAME] I | 7 | 7 | 20 | 34
132 | 10903867 | [NAME] | 0 | 0 | 5 | 5
133 | 10903793 | [NAME] | 8 | 8 | 7 | 23
134 | 10903864 | Nikithash V | 0 | 0 | 0 | 0
135 | 10903683 | Vinay Kumar M | 3.5 | 3.5 | 3.5 | 10.5
136 | 10903496 | Mrugesh [NAME] | 0 | 0 | 0 | 0
137 | 10903482 | [NAME] | 9 | 10 | 12 | 31
138 | 10903499 | Mansuri Taufik Aiyubbhai | 11 | 11 | 13 | 35
139 | 10903211 | Sonam [NAME] | 31 | 32 | 42 | 105
140 | 10903720 | [NAME] | 0 | 0 | 0 | 0
141 | 10903491 | Kunal [NAME] | 0 | 0 | 0 | 0
142 | 10903915 | [NAME] Prahladbhai | 8 | 10 | 12 | 30
143 | 10903511 | Hitendrasinh K Rathod | 16 | 18 | 23 | 57
144 | 10903481 | Prarthit Anand Munshi | 8 | 8 | 9 | 25
145 | 10903865 | Sandeep Kishorkumar Raval |  |  |  | 0
146 | 10902802 | [NAME] | 13 | 13 | 15 | 41
147 | 10903711 | [NAME] | 5 | 5 | 7 | 17
148 | 10903712 | [NAME] | 9 | 8 | 0 | 17
149 | 10903730 | [NAME] | 11 | 12 | 17 | 40
150 | 3083773 | Pratik [NAME] | 11 | 11 | 19 | 41
151 | 10903595 | [NAME] [NAME] | 0 | 0 | 0 | 0
152 | 10903751 | Piyush Suresh Patil | 5.4 | 5 | 7 | 17.4
153 | 10903095 | [NAME] | 15.36 | 15.7 | 17 | 48.06
154 | 10903459 | Jayesh Ramesh Patil | 5 | 5 | 6 | 16
155 | 10903670 | [NAME] | 8.24 | 8.3 | 9 | 25.54
156 | 10903912 | [NAME] | 4 | 4 | 5 | 13
157 | 10903230 | Govind Deshmukh | 4.130000000000001 | 4.130000000000001 | 4.72 | 12.98
158 | 10903632 | Laxmikant [NAME] | 2.87 | 2.87 | 3.28 | 9.02
159 | 10903914 | [NAME] patil | 5 | 5 | 4 | 14
160 | 10903733 | Chetan [NAME] | 5 | 5 | 3 | 13
161 | 10903882 | [NAME] |  |  | 5 | 0
162 | 10903801 | [NAME] | 0 | 0 | 0 | 0
163 | 10903814 | [NAME] | 10.5 | 10.5 | 13.5 | 34.5
164 | 10903731 | Ashish Gajendra Panchmatia | 0 | 0 | 0 | 0
165 | 10903692 | [NAME] | 5.25 | 5.25 | 6.75 | 17.25
166 | 10903505 | Kunal Waman Katole | 5.25 | 5.25 | 6.75 | 17.25
167 | 10903913 | Pradeep [NAME] | 3 | 3 | 4 | 10
168 | 10903765 | Abinash [NAME] | 0 | 0 | 0 | 0
169 | 10903837 | [NAME] | 10 | 15 | 0 | 25
170 | 10903848 | Sachin Bhardwaj |  |  | 25 | 0
171 | 10902646 | Shruti Bhangi | 15 | 10 | 0 | 25
172 | 10903345 | [NAME] Rathore | 5 | 5 | 6 | 16
173 | 10903659 | Pankaj Pareek | 4 | 4 | 6 | 14
174 | 10903879 | Disha Parashar |  |  |  | 0
175 | 10903660 | Puneet Mehta | 15 | 16 | 15 | 46
176 | 10903618 | Sumit [NAME] | 14 | 16 | 16 | 46
177 | 10903578 | [NAME] | 0 | 0 | 0 | 0
178 | 10903786 | Hitesh Jhamarwal | 0 | 0 | 0 | 0
179 | 10903709 | Shiv Dayal Gaur | 9 | 9 | 10 | 28
180 | 10902569 | [NAME] | 8 | 7 | 7 | 22
181 | 10903617 | [NAME] | 9 | 7 | 7 | 23
182 | 10903534 | [NAME] | 5 | 5 | 6 | 16
183 | 10903641 | [NAME] | 13 | 14 | 20 | 47
184 | 10903263 | [NAME] | 13 | 15 | 20 | 48
185 | 10900114 | [NAME] | 0 | 0 | 0 | 0
186 | 10902112 | [NAME] | 0 | 0 | 0 | 0
187 | 10903547 | [NAME] | 13 | 14 | 18 | 45
188 | 10903652 | [NAME] | 0 | 0 | 0 | 0
189 | 10903474 | [NAME] | 13 | 15 | 18 | 46
190 | 2322336 | [NAME] | 3 | 3 | 3 | 9
191 | 10903597 | Ritvik Bhattacharya | 0 | 0 | 0 | 0
192 | 10903823 | [NAME] | 11 | 10 | 12 | 33
193 | 10903803 | Ratnadeep Nath | 11 | 10 | 13 | 34
194 | 3351744 | [NAME] | 2 | 2 | 2 | 6
195 | 2844469 | [NAME] | 1 | 1 | 1 | 3
196 | 10902735 | [NAME] | 2 | 2 | 2 | 6
197 | 1749321 | Jintu Choudhury | 0 | 0 | 0 | 0
198 | 10902492 | Deepak Singh | 11 | 11 | 15 | 37
199 | 10903206 | Subrat Kumar Sahoo | 11 | 12 | 15 | 38
200 | 10903512 | Amulya [NAME] | 0 | 0 | 0 | 0
201 | 10903825 | [NAME] | 2.5 | 3 | 3 | 8.5
202 | 10903599 | Puneet Bhojwani | 6 | 6 | 5.5 | 17.5
203 | 10902887 | Sandeep Singh | 0 | 0 | 0 | 0
204 | 10903570 | [NAME] | 4.5 | 5.5 | 5.5 | 15.5
205 | 10903909 | [NAME] | 13 | 14 | 14 | 41
206 | 10901591 | Amit Pratap Singh | 0 | 0 | 0 | 0
207 | 10903809 | [NAME] | 4 | 4 | 5 | 13
208 | 10902914 | [NAME] | 8.5 | 8.5 | 12 | 29
209 | 10902316 | [NAME] | 0 | 0 | 0 | 0
210 | 10903417 | [NAME] | 0 | 0 | 0 | 0
211 | 10903365 | [NAME] | 9 | 10 | 9 | 28
212 | 10903689 | [NAME] | 7 | 7 | 7 | 21
213 | 10902837 | Mayank Misra | 9 | 10 | 9 | 28
214 | 10903806 | [NAME] | 0 | 0 | 0 | 0
215 | 10903732 | Amit [NAME] | 5 | 6 | 5 | 16
216 | 10902951 | Atul [NAME] | 1 | 1.5 | 1.5 | 4
217 | 10903020 | [NAME] | 2.5 | 3 | 3 | 8.5
218 | 10903612 | Sumit Kumar | 2.5 | 3 | 3 | 8.5
219 | 10903627 | [NAME] | 5 | 5.5 | 5 | 15.5
220 | 10902799 | Amit Tripathi | 7 | 7.5 | 7 | 21.5
221 | 10902294 | [NAME] | 21 | 25 | 21 | 67
222 | 10903845 | [NAME] | 7 | 11 | 7 | 25
223 | 10903579 | [NAME] | 9 | 12 | 9 | 30
224 | 10903716 | [NAME] | 9 | 12 | 9 | 30
225 | 10901994 | [NAME] | 0 | 0 | 0 | 0
226 | 10903609 | [NAME] | 3 | 3 | 3 | 9
227 | 10903742 | Vikash [NAME] | 3 | 3 | 3 | 9
228 | 10902851 | Ashutosh Kumar | 0 | 0 | 0 | 0
229 | 10903582 | Vishal Singh | 11 | 11 | 11 | 33
230 | 10902980 | [NAME] | 9.5 | 9.5 | 9.5 | 28.5
231 | 10902769 | Anjani Kumar | 5 | 4.5 | 6 | 15.5
232 | 10903644 | [NAME] | 5 | 4.5 | 6 | 15.5
233 | 10902293 | [NAME] | 11.5 | 10.5 | 8 | 30
234 | 10903473 | [NAME] | 3 | 3 | 4 | 10
235 | 3438250 | [NAME] |  |  |  | 0
236 | 10903752 | [NAME] | 4 | 3 | 3 | 10
237 | 10903682 | [NAME] | 6 | 6 | 6 | 18
238 | 10900146 | Vikrant Sharma |  |  |  | 0
239 | 10903705 | Ahmer Ikhlaq Shapoo | 15 | 15 | 15 | 45
240 | 10900033 | Siddharth Mahajan | 0 | 0 | 0 | 0
241 | 10903336 | Sachin Puri | 7 | 7 | 7 | 21
242 | 10903554 | [NAME] | 3 | 3 | 4 | 10
243 | 10903724 | [NAME] | 5 | 6 | 8 | 19
244 | 10903810 | [NAME] | 5 | 6 | 7 | 18
245 | 10903247 | [NAME] | 7 | 7 | 7 | 21
246 | 10903846 | Afshan [NAME] |  |  |  | 0
247 | 10903591 | [NAME] | 17 | 17 | 12 | 46
248 | 10903142 | [NAME] | 10 | 15 | 25 | 50
249 | 10903738 | Mohini Sharma | 20 | 18 | 13 | 51
250 | 10903401 | [NAME] | 3 | 0 | 0 | 3
251 | 10903642 | [NAME] | 5 | 5 | 5 | 15
252 | 10903911 | Lavish [NAME] | 15 | 15 | 14 | 44
253 | 10903669 | Manik Goel | 8 | 8 | 8 | 24
254 | 10903324 | Robina Kamboj | 12 | 12 | 12 | 36
255 | 10903878 | [NAME] | 0 | 0 | 1 | 1
256 | 10903713 | Gitish Kumar | 5 | 5 | 5 | 15
257 | 10903649 | Kaveri Nangia | 0 | 0 | 0 | 0
258 | 10903807 | [NAME] | 20 | 30 | 30 | 80
259 | 10903317 | [NAME] | 20 | 50 | 60 | 130
260 | 10903203 | [NAME] | #N/A | #N/A | #N/A | #N/A
261 | 10903539 | [NAME] | #N/A | #N/A | #N/A | #N/A
262 | 10903043 | Shailesh Srivastava | #N/A | #N/A | #N/A | #N/A