Spreadsheet: 174374d1345039832-email-specific-range-using-macro-_sample-payroll
Sheet: Payroll calculator

 | Payroll calculator |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-31 00:00:00
 | Employee ID 1 | Employee Name 2 | Working Day 3 | Present 4 | [NAME] 5 | [NAME] 6 | 7 | [NAME] days 8 | Over time Hours on Holidays 9 | Over time Amount 10 | Gross Pay 11 | Bonus 12 | Advance Deduction 13 | [NAME]. Deduction 14 | Net Pay 15 | [NAME] | Note. |  |  |  | Basic | HRA | FA | Electricity Allw | Ed. [NAME]
1 | 1 | Employee1 | 31 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 1935.483870967741 | 0 | 0 | 0 | 1935 | ABC Bank Ltd. |  |  |  | 30 | 967.741935483871 | 387.0967741935484 | 290.3225806451613 | 145.1612903225806 | 96.77419354838709 | 1887.096774193548 | 0
2 | 2 | Employee2 | 31 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 1899.193548387096 | 0 | 0 | 0 | 1899 | ABC Bank Ltd. |  |  |  | 25 | 967.741935483871 | 403.2258064516129 | 262.0967741935484 | 129.0322580645161 | 88.70967741935483 | 1850.806451612903 | 0
3 | 3 | Employee3 | 31 | 23 | 2 | 0 | 0 | 0 | 0 | 0 | 2185.483870967743 | 0 | 0 | 0 | 2185 | ABC Bank Ltd. |  |  |  | 25 | 1129.032258064516 | 483.8709677419355 | 282.258064516129 | 137.0967741935484 | 96.7741935483871 | 2129.032258064516 | 0
4 | 4 | Employee4 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 3065 | 0 | 0 | 0 | 3065 | ABC Bank Ltd. |  |  |  | 31 | 1600 | 700 | 375 | 180 | 130 | 2985 | 0
5 | 5 | Employee5 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 3420 | 0 | 0 | 0 | 3420 | ABC Bank Ltd. |  |  |  | 31 | 1800 | 800 | 400 | 190 | 140 | 3330 | 0
6 | 6 | Employee6 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 3775 | 0 | 0 | 0 | 3775 | ABC Bank Ltd. |  |  |  | 31 | 2000 | 900 | 425 | 200 | 150 | 3675 | 0
7 | 7 | Employee7 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 4130 | 0 | 0 | 0 | 4130 | ABC Bank Ltd. |  |  |  | 31 | 2200 | 1000 | 450 | 210 | 160 | 4020 | 0
8 | 8 | Employee8 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 4484.999999999999 | 0 | 0 | 0 | 4485 | ABC Bank Ltd. |  |  |  | 31 | 2400 | 1100 | 475 | 220 | 170 | 4365 | 0
9 | 9 | Employee9 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 4840 | 0 | 0 | 0 | 4840 | ABC Bank Ltd. |  |  |  | 31 | 2600 | 1200 | 500 | 230 | 180 | 4710 | 0
10 | 10 | Employee10 | 31 | 29 | 2 | 0 | 0 | 0 | 0 | 0 | 5195.000000000001 | 0 | 0 | 0 | 5195 | ABC Bank Ltd. |  |  |  | 31 | 2800 | 1300 | 525 | 240 | 190 | 5055 | 0
11 | 11 | Employee11 | 31 | 31 | 0 | 0 |  |  |  |  | 5550 | 0 | 0 | 0 | 5550 | ABC Bank Ltd. |  |  |  | 31 | 3000 | 1400 | 550 | 250 | 200 | 5400 | 0
12 | 12 | Employee12 | 31 | 29 | 2 | 0 | 0 | 0 | 0 | 0 | 5905 | 0 | 0 | 0 | 5905 | ABC Bank Ltd. |  |  |  | 31 | 3200 | 1500 | 575 | 260 | 210 | 5745 | 0
13 | 13 | Employee13 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 6259.999999999999 | 0 | 0 | 0 | 6260 | ABC Bank Ltd. |  |  |  | 31 | 3400 | 1600 | 600 | 270 | 220 | 6090 | 0
14 | 14 | Employee14 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 6615 | 0 | 0 | 0 | 6615 | ABC Bank Ltd. |  |  |  | 31 | 3600 | 1700 | 625 | 280 | 230 | 6435 | 0
15 | 15 | Employee15 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 6970 | 0 | 0 | 0 | 6970 | ABC Bank Ltd. |  |  |  | 31 | 3800 | 1800 | 650 | 290 | 240 | 6780 | 0
16 | 16 | Employee16 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 7325 | 0 | 0 | 0 | 7325 | ABC Bank Ltd. |  |  |  | 31 | 4000 | 1900 | 675 | 300 | 250 | 7125 | 0
17 | 17 | Employee17 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 7680 | 0 | 0 | 0 | 7680 | ABC Bank Ltd. |  |  |  | 31 | 4200 | 2000 | 700 | 310 | 260 | 7470 | 0
18 | 18 | Employee18 | 31 | 30 | 1 | 0 | 0 | 0 | 0 | 0 | 8035 | 0 | 0 | 0 | 8035 | ABC Bank Ltd. |  |  |  | 31 | 4400 | 2100 | 725 | 320 | 270 | 7815 | 0
19 | 19 | Employee19 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 8390.000000000002 | 0 | 0 | 0 | 8390 | ABC Bank Ltd. |  |  |  | 31 | 4600 | 2200 | 750 | 330 | 280 | 8160 | 0
20 | 20 | Employee20 | 31 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 8744.999999999998 | 0 | 0 | 0 | 8745 | ABC Bank Ltd. |  |  |  | 31 | 4800 | 2300 | 775 | 340 | 290 | 8505 | 0
 |  |  |  |  |  |  |  |  |  |  | 106405.1612903226 | 0 | 0 | 0 | 106404 |  |  |  |  |  | 57464.51612903226 | 26774.1935483871 | 10609.67741935484 |  |  | 103531.935483871