[go: up one dir, main page]
Scribd
Upload
119 views3 pages

Employee Data With Formula Practice

The document provides a detailed salary and performance report for employees across various departments, including their basic salary, performance score, location, bonus, HRA, and net salary. It lists employees from departments such as HR, Finance, IT, Operations, and Marketing. Each entry includes an employee ID, name, and corresponding financial details.

Uploaded by

chandan chatterjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
119 views3 pages

Employee Data With Formula Practice

The document provides a detailed salary and performance report for employees across various departments, including their basic salary, performance score, location, bonus, HRA, and net salary. It lists employees from departments such as HR, Finance, IT, Operations, and Marketing. Each entry includes an employee ID, name, and corresponding financial details.

Uploaded by

chandan chatterjee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Emp ID Name Dept ID Department

Basic Salary
Performance Score
Location Bonus HRA Net Salary
E001 Raj D04 45551 99 Hyderabad 5000 5000 55551
E002 Priya D05 46382 46 Mumbai 1000 6000 53382
E003 Amit D03 20189 83 Chennai 5000 4800 29989
E004 Neha D05 39118 47 Chennai 1000 4800 44918
E005 Karan D05 23005 86 Delhi 5000 5500 33505
E006 Simran D02 41042 74 Chennai 3000 4800 48842
E007 Ankit D03 21899 53 Delhi 1000 5500 28399
E008 Pooja D03 44118 56 Mumbai 1000 6000 51118
E009 Vivek D03 21267 75 Hyderabad 3000 5000 29267
E010 Divya D05 37912 89 Hyderabad 5000 5000 47912
E011 Sahil D04 31394 79 Hyderabad 3000 5000 39394
E012 Kriti D03 23556 43 Chennai 1000 4800 29356
E013 Manoj D05 23890 41 Mumbai 1000 6000 30890
E014 Tina D02 28838 45 Chennai 1000 4800 34638
E015 Rohit D04 47464 93 Chennai 5000 4800 57264
E016 Sneha D02 34502 81 Mumbai 5000 6000 45502
E017 Aarav D04 41777 43 Mumbai 1000 6000 48777
E018 Isha D05 30627 93 Mumbai 5000 6000 41627
E019 Yash D01 28792 68 Mumbai 3000 6000 37792
E020 Meera D04 30555 57 Hyderabad 1000 5000 36555
E021 Dev D02 30253 65 Bangalore 3000 5200 38453
E022 Nina D05 28433 83 Bangalore 5000 5200 38633
E023 Arjun D04 30233 73 Mumbai 3000 6000 39233
E024 Riya D01 31016 49 Bangalore 1000 5200 37216
E025 Kabir D01 43897 75 Bangalore 3000 5200 52097
E026 Jiya D03 22612 53 Mumbai 1000 6000 29612
E027 Mohit D03 43425 70 Bangalore 3000 5200 51625
E028 Lata D02 45939 87 Chennai 5000 4800 55739
E029 Naman D04 42619 54 Delhi 1000 5500 49119
E030 Tara D04 41870 47 Delhi 1000 5500 48370
Net Salary
Dept ID Department
D01 HR
D02 Finance
D03 IT
D04 Operations
D05 Marketing

You might also like