Find Rating wise, Division wise and Region Wise Bonus %
Name Salary Division Region Jr Rating Bonus
aman 17912 DFH INDIA INDIAh 3 8.60%
anil 17102 ABY INDIA INDIAh 2 11.90%
suman 19632 ABD ROW ROWh 3 3.77%
rahim 17430 AYZ INDIA INDIAh 1 23.33%
sukh 20210 DUF INDIA INDIAh 2 12.44%
sanky 21011 CYZ ROW ROWh 5 12.22%
saurya 16180 DFH ROW ROWh 3 12.00%
sualabh 16929 ABY ROW ROWh 3 23.11%
rahim 16551 AYZ INDIA INDIAh 2 12.76%
rickesh 22928 DUF INDIA INDIAh 1 44.22%
naman 21847 CYZ INDIA INDIAh 4 33.22%
amresh 23037 ABY ROW ROWh 4 44.77%
arunesh 24102 ABD ROW ROWh 1 2.23%
nikhil 24359 ABY ROW ROWh 2 23.88%
nimish 18557 ABD INDIA INDIAh 2 13.00%
ankush 22654 DUF INDIA INDIAh 3 23.77%
anil 15488 DUF INDIA INDIAh 5 24.44%
anmol 17847 CYZ INDIA INDIAh 1 12.54%
amol 21543 DFH ROW ROWh 2 11.22%
Rating wise, Division wise and Region Wise Bonus %
INDIA
Rating ABD ABY DFH AYZ CYZ DUF
1 12.23% 1.23% 9.99% 23.33% 12.54% 44.22%
2 13.00% 11.90% 8.98% 12.76% 44.34% 12.44%
3 18.00% 14.34% 8.60% 16.77% 34.22% 23.77%
4 11.22% 16.90% 12.33% 12.74% 33.22% 23.11%
5 14.33% 14.23% 17.44% 17.44% 11.11% 24.44%
ROW
Rating ABD ABY DFH AYZ CYZ DUF
1 2.23% 33.44% 33.22% 14.22% 13.34% 11.23%
2 2.88% 23.88% 11.22% 14.12% 14.23% 11.43%
3 3.77% 23.11% 12.00% 12.33% 12.34% 13.21%
4 4.77% 44.77% 12.33% 13.00% 12.44% 14.12%
5 8.99% 45.00% 13.32% 18.40% 12.22% 12.33%
Find the Price Using Vlookup(Please don’t Associate Choose Function to Achieve the result)
Product Price Product Price
Samsung 1200 Xioni 2433
Nokia 1300 Xiomi 5545
Oppo 1260 Oppo 1260
Vivo 1590 Vivo 1590
Moto 1234
Product ModelNo Price Samsung 1200
Moto XX20 1234 Honour 3343
Xiomi XX30 5545 Oppo 1260
Honour XX40 3343
Xioni XX50 2433
EMP DATA STANDARD GROSS DAYS EARNING GROSS
Gross Paid No Of
S.NO Emp. Code Employee's Name Basic HRA Basic
Salary Day Day
1 5080 SANDEEP KUMAR GUPTA 15854 7927 23781 15 31 7671
2 5081 ANIL SHARMA 14005 7003 21008 29 31 13101
3 5082 DEVENDER KUMAR 14285 7143 21428 23 31 10599
4 5083 MUNISH KUMAR 15441 7721 23162 28 31 13947
5 5084 NARENDER S. MEHRA 16349 8175 24524 31 31 16349
6 5085 RAM KISHAN 17064 0 17064 29 31 15963
7 5086 RAMASHANKER PANDEY 17773 8887 26660 30 31 17200
8 5087 RISHIKESH VARSHNEY 17365 8683 26048 24 31 13444
9 5088 ROHIT 14622 7311 21933 29 31 13679
10 5089 SUBHASH CHAND 16342 0 16342 26 31 13706
11 5090 SUNIL KUMAR 15338 7669 23007 24 31 11875
12 5091 TAK RAM 15964 7982 23946 26 31 13389
13 5092 VINOD 14721 7361 22082 21 31 9972
14 5093 RAJ PAL 15669 7835 23504 18 31 9098
15 5094 SHARWAN KUMAR 17804 0 17804 23 31 13209
16 5095 ASHUTOSH KUMAR 17269 8635 25904 31 31 17269
17 5097 PAPPU 15936 7968 23904 31 31 15936
18 5101 RAJESH KUMAR 15811 7906 23717 22 31 11221
19 5104 DHARAM PAL 14947 0 14947 30 31 14465
20 5105 ASHRAF KHAN 17278 8639 25917 30 31 16721
21 5107 SHRAD KUMAR 14954 7477 22431 29 31 13989
22 5109 SUNIL KUMAR 16440 8220 24660 31 31 16440
23 5110 GAURAV KAPOOR 16722 8361 25083 29 31 15643
24 5111 BINOD KUMAR SARANGI 14076 7038 21114 21 31 9535
25 5113 SANTOSH KUMAR RAY 15003 7502 22505 26 31 12583
26 5114 MOHIT DEVRANI 16750 8375 25125 22 31 11887
27 5115 ANIL KUMAR 17863 8932 26795 28 31 16134
28 5116 GAMBHIR SINGH 17379 8690 26069 30 31 16818
29 5117 JITENDER TOMAR 15430 7715 23145 20 31 9955
30 5118 LOKENDER KU. TOMER 17082 8541 25623 15 31 8265
31 5119 VIPIN KUMAR 14021 7011 21032 25 31 11307
495557 214707 710264 796 961 410472
If Standard
If Standard Gross>21000
Basic>15000 then
then "No calculation"
calculation "Zero"
( Zero ) otherwise 0.75% of
other wise 12% on
earning gross
EARNING GROSS earning Basic
Deductions of Emps
Earning
ESIC @ 0.75% of Gross Total Ded.(PF
HRA Gross EPF @ 12% of Basic Net Payment
Salary and ESIC )
Salary
7927 15598 0.00 0 0 15598
7003 20104 2412.53 0 2413 17692
7143 17742 2128.99 0 2129 15613
7721 21668 0.00 0 0 21668
8175 24524 0.00 0 0 24524
0 15963 0.00 119.72 120 15843
8887 26087 0.00 0 0 26087
8683 22127 0.00 0 0 22127
7311 20990 2518.76 0 2519 18471
0 13706 0.00 102.79 103 13603
7669 19544 0.00 0 0 19544
7982 21371 0.00 0 0 21371
7361 17333 2079.99 0 2080 15253
7835 16933 0.00 0 0 16933
0 13209 0.00 99.07 99 13110
8635 25904 0.00 0 0 25904
7968 23904 0.00 0 0 23904
7906 19127 0.00 0 0 19127
0 14465 1735.78 108.48 1844 12621
8639 25360 0.00 0 0 25360
7477 21466 2575.95 0 2576 18890
8220 24660 0.00 0 0 24660
8361 24004 0.00 0 0 24004
7038 16573 1988.80 0 1989 14585
7502 20085 0.00 0 0 20085
8375 20262 0.00 0 0 20262
8932 25066 0.00 0 0 25066
8690 25508 0.00 0 0 25508
7715 17670 0.00 0 0 17670
8541 16806 0.00 0 0 16806
7011 18318 2198.19 0 2198 16120
214707 626079 0.00 0 18069 608009
BINOD
KUMAR
SARANGI
Original data Result
?10092¿ 10092
¿1223301! 1223301
1!21202¡ 121202
¿1022323¡ 1022323
!122¿0433¡ 1220433
Nokia Moto Row 3
Sony Samsung Column 2
Oppo MI Result MI
Vivo Lava
