Emp Code Employee Name Address City Region Department Basic DA HRA
1 JP Kumar Andheri (W) Mumbai W Training 6250 1875 3250
2 Anjali Thakur Govindpuri Delhi N Accounts 8750 2625 4550
3 Priya Agarwal Sector 9 Noida N Marketing 11250 3375 5850
4 R Vasu Egmore Chennai S R&D 10000 3000 5200
5 Sanjay Gupta G K - II Delhi N Training 16250 4875 8450
6 Jharna Biswal Link Road Cuttack E Accounts 6400 1920 3328
7 Prakash Dutta Elgin Road Kolkata E Marketing 4500 1350 2340
8 Manisha Guha Alipore Kolkata E R&D 6275 1882.5 3263
9 Arjun Jain MG Road Mumbai W Training 6250 1875 3250
10 Arjun Kapoor Kormangala Bangalore S Accounts 8750 2625 4550
11 Abrar Jayanagar Bangalore S Marketing 11250 3375 5850
12 Shahid Khan M.G Road Mangalore S R&D 10000 3000 5200
13 Anupam Mishra Govindpuri Mysore S Training 16250 4875 8450
14 Ashwini Sector 9 Mangalore S Accounts 6400 1920 3328
15 Prateek Babbar North Road Delhi N Marketing 4500 1350 2340
16 Sukanya Reddy Alipore Mangalore S R&D 6275 1882.5 3263
17 Satish Puri Bandra Mumbai W Operation 6250 1875 3250
18 Anjum Chopra Worli Mumbai W R&D 8750 2625 4550
19 Akram Khan S P B Road Pune W Operation 11250 3375 5850
20 Manish Grover L L R Road Noida N Training 10000 3000 5200
=(G2+H2)*
TA PF Bonus Inventive Overtime
0 750 0 0 1500
0 1050 0 2500 1500
5000 1350 0 2500 1500
0 1200 4000 0 1500
0 1950 0 0 1500
0 768 0 2500 1500
5000 540 0 2500 1500
0 753 0 0 1500
0 750 0 0 1500
0 1050 0 2500 1500
5000 1350 0 2500 1500
0 1200 4000 0 1500
0 1950 0 0 1500
0 768 0 2500 1500
5000 540 0 2500 1500
0 753 2510 0 1500
0 750 0 0 0
0 1050 0 0 1500
0 1350 0 0 0
0 1200 0 0 1500
=IF(F2=$F$4, =12%*G2 =IF(AND(F2="R&D",E=IF(OR(F2="Ma=IF(F2="Operation",0,1500)
Overtime [Link] [Link] CCA Special Allowance
1500 50 5000
1500 50 5000
1500 100 0
1500 50 5000
1500 150 5000
1500 50 0
1500 0 5000
1500 50 5000
1500 50 5000
1500 50 0
1500 100 0
1500 50 0
1500 150 0
1500 50 0
1500 0 5000
1500 50 0
0 50 5000
1500 50 5000
0 100 0
1500 50 0
=IF(NOT(F2="Operation"),1500,0) =IF(G2<5000,0,IF(G2<=10000,50,IF(G2<=15000,100,IF(G2<=20000,
Gross Sala Net Salary Annual Salary
18625
25975
30825
29900
38025
16416
22730
18673.5
18625
20975
30825
24900
33025
16416
22730
16183.5
17125
23475
21825
20900
=SUM(G2:N2,Q2:S2)
#NAME? 0
Emp Code Employee Name Address City Region Department Basic
1 JP Kumar Andheri (W) Mumbai W Training 6250
2 Anjali Thakur Govindpuri Delhi N Accounts 8750
3 Priya Agarwal Sector 9 Noida N Marketing 11250
4 R Vasu Egmore Chennai S R&D 10000
5 Sanjay Gupta G K - II Delhi N Training 16250
6 Jharna Biswal Cuttack E Accounts 6400
7 Prakash Dutta Elgin Road Kolkata E Marketing 4500
8 Manisha Guha Alipore Kolkata E R&D 6275
9 Arjun Jain MG Road Mumbai W Training 6250
10 Arjun Kapoor Kormangala Bangalore S Accounts 8750
11 Abrar Jayanagar Bangalore S Marketing 11250
12 Shahid Khan Mangalore S R&D 10000
13 Anupam Mishra Govindpuri Mysore S Training 16250
14 Ashwini Sector 9 Mangalore S Accounts 6400
15 Prateek Babbar North Road Delhi N Marketing 4500
16 Sukanya Reddy Alipore Mangalore S R&D 6275
17 Satish Puri Bandra Mumbai W Operation 6250
18 Anjum Chopra Worli Mumbai W R&D 8750
19 Akram Khan S P B Road Pune W Operation 11250
20 Manish Grover L L R Road Noida N Training 10000
Age CITY city
25 Delhi TRUE
27 TRUE
36 FALSE
25 FALSE
20 TRUE
14 FALSE
5 FALSE
26 FALSE
15 TRUE
15 FALSE
255 FALSE
45 FALSE
86 FALSE
26 FALSE
7 TRUE
58 FALSE
62 TRUE
25 TRUE
15 FALSE
59 FALSE