Excel - 1
A B C A+B+C A+C C-A A*B C/A Sub total
7 12 49 68 56 42 84 7
8 8 48 64 56 40 64 6
3 5 27 35 30 24 15 9
1156
7 8 56 71 63 49 56 8
5 8 80 93 85 75 40 16
Total 331 290 230 259 46
Excei - 2
X Y Z X+Y-Z X-Y X*Y X-(Y+Z) Y/Z Sub total
110 14 2 122 96 1540 94 7
152 7 7 152 145 1064 138 1
252 30 10 272 222 7560 212 3
26283
152 16 4 164 136 2432 132 4
162 70 2 230 92 11340 90 35
Total 940 691 23936 666 50
Excel - 3
D X V (D-X)*V X*(D+V) X-V+D D*X X/V Sub total
86 46 2 80 4048 130 3956 23
114 74 2 80 8584 186 8436 37
82 68 4 56 5848 146 5576 17
55758
96 72 12 288 7776 156 6912 6
68 21 7 329 1575 82 1428 3
Total 833 27831 700 26308 86
Excel - 4
A B C D Y A+C+D B+Y+A A+B+C+D+Y Sub total
8 4 9 3 2 20 14 26
4 7 6 5 1 15 12 23
4 3 6 4 2 14 9 19
268
6 5 3 8 9 17 20 31
4 2 3 6 7 13 13 22
Total 79 68 121
Excel -5
Sr. Product Qty. Rate Total Tax(5%) Total
No. Amount
1 Dell wired keybord 8 570 4560 228 4788
2 Zebronics usb keybord 6 290 1740 87 1827
3 Quantum usb keybord 2 260 520 26 546
4 Intex multimedia kebord 4 300 1200 60 1260
5 Logitech mk215 keybord 2 1180 2360 118 2478
6 Hp kebord k 1500 3 500 1500 75 1575
7 Enter e kb 501 wired keybord 1 220 220 11 231
Total Net Amount 12705
Excel - 6
Sr.n Product Qut. Rate Total Gst(18%) Total
o Amount
1 Xiaomi redmi note 3 2 12500 25000 4500 29500
2 Samsung on 7 pro 3 10200 30600 5508 36108
3 Moto g play 4 9200 36800 6624 43424
4 Moto g puse (32gb) 3 15500 46500 8370 54870
5 Coolpad note 5 (32%) 1 12600 12600 2268 14868
6 Lenovo vibe k4 6 11200 67200 12096 79296
Total Net Amount 258066
Excel - 7
Sr. Discount Total
Product Qty. Rate Total
no. (10%) Amount
1 LG 32 inch LED 3 17500 52500 5250 47250
2 Lenovo G 50-80 laptop 2 24900 49800 4980 44820
3 Apple iphone 7 2 65900 131800 13180 118620
4 American tourister bag [Link] 3 4100 12300 1230 11070
5 Woodland men`s shoes 2 3500 7000 700 6300
6 Pepe jeans men`s jacket 4 3800 15200 1520 13680
Total Net Amount 241740
Excel - 8
Sr. Discount Net
Itwms Qty. Rate Total
No. (32%) Amount
1 Pepe Men`s jeans 20 1320 26400 8448 17952
2 GAS Men`s jeans 5 1558 7790 2492.8 5297.2
3 Live`s Men`s Jeans 20 1322 26440 8460.8 17979.2
4 Lee Men`s Jeans 8 1122 8976 2872.32 6103.68
5 Wrangeler Man`s Jeans 10 1584 15840 5068.8 10771.2
Total 58103.28
Tax (5%) 2905.164
Transport Charges 500
Actual Price 61508.44
Excel - 9
Sr. Discount Net
Itwms Qty. Rate Total
no. (32%) Amount
1 Nexus 6P Phone 5 32458 162290 51932.8 110357.2
2 Apple Iphone 6 3 31240 93720 29990.4 63729.6
3 Samsung Galaxy J5 6 11250 67500 21600 45900
4 MI 5 3 18450 55350 17712 37638
5 Gionee marathon M5 4 11348 45392 14525.44 30866.56
Total 288491.36
Tax (5%) 14424.568
Transport Charges 2461
Actual Price 305376.9
Excel - 10
Rate After
Sr. Rate Per
Share Qty. Rate Total (0.60% )
No. Share
Brokierage
1 L & T Company 50 1472 73600 74041.6 1480.832
2 Adani Power 500 31 15500 15593 31.186
3 Ashok Layland 200 104 20800 20924.8 104.624
4 SBI 50 170 8500 8551 171.02
5 Bank Of Baroda 100 140 14000 14084 140.84
6 Idea 82 113 9266 9321.596 113.678
7 Jindal Steel 152 61 9272 9327.632 61.366
L
Excei - 11
Discount Actual
Items Qty. Rate Amount
(%) Amount
Nirma 50 220 11000 5% 10450
Lux 40 320 12800 10% 11520
Dettol 70 450 31500 20% 25200
Cinthol 60 385 23100 15% 19635
Godhrej No. 1 40 285 11400 5% 10830
Jhnson`s Baby Shop 30 370 11100 10% 9990
Total Amount 87625
Excei - 12
Tax Actual
Items Qty. Rate Amount
(%) Amount
Desktop Computer 5 15600 78000 5% 81900
LED TV 2 13500 27000 15% 31050
A.C 1 28500 28500 15% 32775
Fan 8 1500 12000 5% 12600
Refrigerator 3 20400 61200 15% 70380
Cooler 4 8500 34000 10% 37400
Total Amount 266105
Excel - 13
Per Car
Rate After 10% Rate Per Per Car
Car Qty. Rate Total GST
Discount Car Amount
(18%)
Alto 800 2 256000 512000 460800 230400 41472 271872
Wagonor 5 346800 1734000 1560600 312120 56181.6 368301.6
Swift 3 685000 2055000 1849500 616500 110970 727470
Celirio 4 425000 1700000 1530000 382500 68850 451350
Hundai 110 2 542000 1084000 975600 487800 87804 575604
Chevarolate 1 385000 385000 346500 346500 62370 408870
Excel - 14
Rate After Rate Per
Laptop Qty. Rate Amount
18% GST Laptop
HP 1 28500 28500 33630 33630
Lenovo 2 26500 53000 62540 31270
Dell 2 31200 62400 73632 36816
Sony 3 38500 115500 136290 45430
Samsung 4 27500 110000 129800 32450
Asus 2 26500 53000 62540 31270
Excel - 15
P.F.
Sr.N DA HRA Gross Total Net
Name Basic Tax (Basic
o. (127%) (8%) Salary Deduction Salary
1.75%)
1 Girish 10547 13394.69 843.76 24785.45 200 184.5725 384.5725 24401
2 Navin 13546 17203.42 1084 31833.1 250 237.055 487.055 31346
3 Jignesh 17542 22278.34 1403 41223.7 400 306.985 706.985 40517
4 Rohit 8752 11115.04 700.16 20567.2 200 153.16 353.16 20214
5 Vipul 12423 15777.21 993.84 29194.05 150 217.4025 367.4025 28827
6 Maulik 17521 22251.67 1402 41174.35 500 306.6175 806.6175 40368
Total Net Salary 185672
Excel - 16
DA Medical Gross Professional Total
No. Name Basic Loan
(132%) Allowance Salary Tax Deduction
1 Nupur 21447 28310 700 50457.04 4712 700 5412
2 Gutam 15423 20358.4 600 36381.36 6428 500 6928
3 Jivan 7681 10138.9 400 18219.92 2581 200 2781
4 Ravi 10957 14463.2 200 25620.24 8757 250 9007
5 Jaymin 7641 10086.1 200 17927.12 0 200 200
6 Nitin 21759 28721.9 1240 51720.88 11232 700 11932
Total Net Salary
Net Salary
45045.0
29453.4
15438.9
16613.2
17727.1
39788.9
164066.6
Excei - 17
Provident
DA HRA Gross Fund Total
No. Name Basic TA ESI
(123%) (12%) Salary (0.75% on Deduction
Basic
1 Neeta 25664 31566.72 3079.68 1800 62110.4 192.48 1000 1192.48
2 Geeta 18642 22929.66 2237.04 1140 44948.7 139.815 900 1039.815
3 Lalit 21661 26643.03 2599.32 1360 52263.35 162.4575 800 962.4575
4 Moulik 44841 55154.43 5380.92 2800 108176 336.3075 2500 2836.3075
5 Hitendra 18991 23358.93 2278.92 1450 46078.85 142.4325 1000 1142.4325
6 Vinkl 17653 21713.19 2118.36 1360 42844.55 132.3975 1500 1632.3975
Total Net Salary
Net
Salary
60917.92
43908.89
51300.89
105340
44936.42
41212.15
347616
Excel - 18
DA+HRA Other
[Link]. Name Basic Tax LIC Policy Total Salary
(127%) Allowance
1 Girish 22321 28347.67 800 500 1441 49527.67
2 Navin 18643 23676.61 700 150 1053 41816.61
3 Jignesh 21461 27255.47 500 500 841 47875.47
4 Rohit 32791 41644.57 1200 800 1261 73574.57
5 Vipul 8763 11129.01 800 200 1387 19105.01
6 Maulik 16447 20887.69 700 150 1263 36621.69
Total 268521.02
Excel - 19
HRA
DA EPF (Basic
[Link]. Name Basic (Basic+DA) Incentiv Net Salary
(119%) 1.5%)
6%
1 Riva 8961 10663.59 1177.4754 1500 134.415 22167.6504
2 Girish 15447 18381.93 2029.7358 2500 231.705 38126.9608
3 Jayesh 19559 23275.21 2570.0526 3000 293.385 48110.8776
4 Minal 22443 26707.17 2949.0102 2500 336.645 54262.5352
5 Saurabh 15862 18875.78 2084.2668 1200 237.93 37784.1168
6 Nikita 14326 17047.94 1882.4364 2500 214.89 35541.4864
Total Net Salary 235993.627
Excel - 20
DA HRA Medical
[Link]. Name Basic Insurance Total Salary
(129%) (8%) Allowance
1 Geeta 12500 16125 1000 500 115 30010
2 Nilesh 9500 12255 760 200 250 22465
3 Vijay 10800 13932 864 100 300 25396
4 Zanak 16500 21285 1320 150 250 39005
5 Ravi 14500 18705 1160 250 450 34165
6 Seema 12500 16125 1000 300 50 29875
Total 180916
Excel - 21
[Link]. Name Pay Band Grade Pay Basic Pay DA+HRA Loan (23% On Total
(136%) Basic Pay Salary
1 Neeta 12447 4400 16847 22911.92 3874.81 35884.11
2 Jignesh 20441 1600 22041 29975.76 5069.43 46947.33
3 Pulkit 10443 1900 12343 16786.48 2838.89 26290.59
4 Radha 16449 1500 17949 24410.64 4128.27 38231.37
5 Nirali 14500 1000 15500 21080 3565 33015
6 Khusi 12446 1500 13946 18966.56 3207.58 29704.98
Gross Total 210073.4
Excel - 22
Pay HRA
[Link]. Employees Grad Pay Basic Pay DA(128%) Total Salary
Band (8%)
1 Reeta 21561 4200 25761 32974.08 2060.88 60796
2 Jaimini 10847 1900 12747 16316.16 1019.76 30083
3 Arpit 18759 2100 20859 26699.52 1668.72 49227
4 Pankaj 20776 2400 23176 29665.28 1854.08 54695
5 Katan 16854 1900 18754 24005.12 1500.32 44259
6 Nidhi 24790 4400 29190 37363.2 2335.2 68888
Gross Total 307949
Excel - 23
Employees Provient
Name Basic DA HRA Loan Net Salary
No. Fund
P1051 Vipul 12500 15750 1000 5000 156.25 24093.75
P1052 Nilesh 14600 18396 1168 10500 182.5 23481.5
P1053 Sandip 21800 27468 1744 6000 272.5 44739.5
P1054 Vijaysinh 9500 11970 760 4000 118.75 18111.25
P1055 Mansi 16500 20790 1320 4500 206.25 33903.75
P1056 Shital 10800 13608 864 6000 135 19137
Total Net Salary 163466.75
126% 8% 1.25%
Excel - 24
Employees Medical Provient
Name Basic DA HRA Net Salary
No. Allowance Fund
1001 Ridhi 22500 27675 2700 500 562.5 52812.5
1002 Mohit 21900 26937 2628 500 547.5 51417.5
1003 Nirali 19500 23985 2340 300 487.5 45637.5
1004 Girish 10800 13284 1296 100 270 25210
1005 Jatin 20400 25092 2448 500 510 47930
1006 Pafrul 21800 26814 2616 500 545 51185
Total Net Salary 274192.5
123% 12% 2.50%
Excel - 25
Employees Medical
Basic DA HRA Loan P. F.
Code . Allowance
A5051 20500 26445 1640 4000 512.5 200
A5052 10500 13545 840 2000 262.5 400
A5053 18500 23865 1480 2500 462.5 300
A5054 13500 17415 1080 0 337.5 400
A5055 19500 25155 1560 1500 487.5 200
A5056 34200 44118 2736 2500 855 700
A5057 20800 26832 1664 3500 520 350
Total Net Salary
Net Salary
44272.5
23022.5
41182.5
32057.5
44427.5
78399
45626
308987.5
Excel - 26
Employees Other
Basic DA Tax P. F. Incentive
Code . Allowance
B6162 35800 47614 800 1000 1074 4200
B6163 20800 27664 500 500 624 3500
B6164 10800 14364 200 0 324 2500
B6165 19500 25935 350 500 585 3200
B6166 25600 34048 600 1500 768 2200
B6167 40200 53466 850 2000 1206 3400
B6168 18500 24605 300 1200 555 2000
Total Net Salary
133% 3%
Net Salary
86740
51340
27140
48200
61980
97010
45450
417860
Excel - 27
Loan
[Link]. Name Basic DA HRA TA Net Salary
Amount
1 Gaurav 19500 24960 2925 1500 0 48885
2 Nihar 20800 3120 1500 5220 20200
3 Axay 12500 15375 1250 1000 3550 26575
4 Minaxi 28700 36736 4305 2500 7450 64791
5 Shanti 14500 17835 1450 1500 3450 31835
6 Nikul 23500 30080 3525 2500 6250 53355
Total Net Salary 245641
Excel - 28
[Link]. Name Basic DA Loan Advance ESI Net Salary
1 Rajal 31500 34020 7875 0 400 57245
2 Jaya 40200 43416 10050 0 500 73066
3 Tarageeka 15000 16800 3750 500 500 27050
4 Shital 20800 23296 5200 1000 1200 36696
5 Mukesh 32500 35100 8125 450 500 58525
6 Payal 18500 20720 4625 0 700 33895
Total Net Salary 286477
Excel - 29
Dearness Professional
[Link]. Name Basic Overtime P.F. Net Salary
Aqllowance Tax
1 Ramesh 52200 72558 4500 1500 1827 125931
2 Alpesh 62400 86736 2500 1800 2184 147652
3 Hasmukh 25800 33540 8500 500 903 66437
4 Vipulsinh 35000 48650 2500 1800 1225 83125
5 Sanket 20600 26780 9500 500 721 55659
6 William 34600 44980 3500 900 1211 80969
Toal Net Salary 559773
Excel - 30
Perquisite Festival Income
[Link]. Name Basic DA HRA Net Salary
Allowance Allownce Tax
1 valay patel 32500 41600 3900 3500 5000 500 86000
2 kamlesh chavda 15600 19188 1560 2500 2000 0 40848
3 nirav chaudhary 18500 22755 1850 3500 2500 0 49105
4 rajrsh chaudhary 23500 30080 2350 1500 3200 0 60630
5 dipak chaudhary 35800 45824 4296 4500 5000 500 94920
6 vijay vaghela 19500 23985 1950 3600 4000 0 53035
Toal Net Salary 384538
Excel - 31
Net
[Link]. Name Basic DA Conveyance P.F. ESI Loan
Salary
1 Mikail Masuri 45600 58824 3500 2280 1000 10512 94132
2 Amrat Rbari 32600 40750 2500 1630 500 5240 68480
Kuldipsinhn
3 28500 34485 1500 855 500 2562 60568
Gohil
4 Ashish Desai 26500 32065 1500 795 500 1542 57228
5 Sandip Rayka 27600 33396 1500 828 500 3280 57888
6 Saurabh Raval 32600 40750 2500 1630 700 4850 68670
Toal Net Salary 406966
`
Excel - 32
Special Professional
[Link]. Name Basic DA HRA TDS
Allownce Tax
1 Jay Ptel 22500 30375 1500 3645 500 500
2 Himani Patel 32500 45500 1500 5460 1000 700
3 Harshad Dulera 19500 26325 1500 3159 1500 500
4 Dipak Modi 25500 34425 1500 4131 750 700
5 Dolly Raval 14200 19170 1000 2300.4 600 500
6 Priyanka Desai 33500 46900 2500 5628 300 700
Toal Net Salary
Net Salary
57020.0
83260.0
48484.0
64106.0
35570.4
87528.0
375968.4
Excel - 33
DA+HRA Mdical EPF (6.5% Net
No. Employee Basic Lone Incentiv
(119.5%) Allownce On Basic) Salary
1 Dipika Chudhary 32500 38837.5 1000 12032 2112.5 2500 60693
2 Jinal Chudhary 29560 35324.2 800 10325 1921.4 3200 56637.8
3 Smita Patel 25120 30018.4 1500 18520 1632.8 4200 40685.6
4 Paras Yadav 10500 12547.5 1200 0 682.5 4200 27765
5 Roshani Cahudhry 21200 25334 700 7852 1378 3200 41204
6 Jayesh Maheswari 42500 50787.5 1500 9230 2762.5 2400 85195
Toal Salary 312180
Excel - 34
Emp. ESI(1.75% On
Name Basic DA HRA Lone
No. Basic)
1 Payal Patel 27560.00 30867.2 2006.368 1500.00 482.3
2 Mosam Desai 15620.00 16713.4 1086.371 2250.00 273.35
3 Raj Gohil 28450.00 31864 2071.16 5400.00 497.875
4 Ankita Panchal 31020.00 34742.4 2258.256 0.00 542.85
5 Dhruv Soni 15450.00 16531.5 1074.548 4500.00 270.375
6 Umang Pandya 17000.00 18190 1182.35 3500.00 297.5
Total Gross Salary
Gross Salary
58451.3
30896.4
56487.3
67477.8
28285.7
32574.9
274173.3
Excel - 35
No. Name Pay Band Grad Pay Basic DA HRA EPF
A121 Parul Bhati 34500 4400 38900 46680.00 2053.92 750
A122 Krishna Rjput 17200 1900 19100 22347.00 983.268 750
A123 Rahul Trivedi 25000 2400 27400 32880.00 1446.72 750
A124 Disha Chudhari 18800 2200 21000 24570.00 1081.08 750
A125 Vishal Patel 27600 2800 30400 36480.00 1605.12 750
A126 Kuldip Barot 32500 4200 36700 44040.00 1937.76 750
Total Net Salary 750
Net Salary
86883.9
41680.3
60976.7
45901.1
67735.1
81927.8
385104.9
Excel - 36
Student
Roll No. Mathe Science Englesh Total Average Status
Name
A121 Jaimin 75 85 67 227 76 Pass
A122 Virat 35 45 28 108 36 Fail
A123 Gaurav 45 65 45 155 52 Pass
A124 Jagdish 25 14 21 60 20 Fail
A125 Mohit 85 76 78 239 80 Pass
A126 Navin 55 45 65 165 55 Pass
Overall Avrage 318