Spreadsheet: 174374d1345039832-email-specific-range-using-macro-_sample-payroll
Sheet: Employee information

 | Employee information
 | Employee ID 1 | Name 2 | Basic salary 3 | HRA 4 | Food Allowance 5 | Electricity Allowance 6 | Child Education Allowance 7 | Vehical Allowance 8 | Other Allowance 9 | Total Salary 10 | Per Day Rate 11 | Per Hour Rate 12 | HRA Per Day 13 | FA Per Day 14 | Electricity Allowance Per Day 15 | [NAME]. Allow. Per Day 16 | Vehical Allowance per Day 17 | Other Allowance per Day 18 | Total Per Day 19 | Working Days 20
1 | 1 | Employee1 | 1000 | 400 | 300 | 150 | 100 | 50 | 0 | 2000 | 32.25806451612903 | 4.032258064516129 | 12.90322580645161 | 9.67741935483871 | 4.838709677419355 | 3.225806451612903 | 1.612903225806452 | 0 | 64.51612903225805 | 31
2 | 2 | Employee2 | 1200 | 500 | 325 | 160 | 110 | 60 | 0 | 2355 | 38.70967741935484 | 4.838709677419355 | 16.12903225806452 | 10.48387096774194 | 5.161290322580645 | 3.548387096774194 | 1.935483870967742 | 0 | 75.96774193548386
3 | 3 | Employee3 | 1400 | 600 | 350 | 170 | 120 | 70 | 0 | 2710 | 45.16129032258065 | 5.645161290322581 | 19.35483870967742 | 11.29032258064516 | 5.483870967741935 | 3.870967741935484 | 2.258064516129032 | 0 | 87.41935483870971
4 | 4 | Employee4 | 1600 | 700 | 375 | 180 | 130 | 80 | 0 | 3065 | 51.61290322580645 | 6.451612903225806 | 22.58064516129032 | 12.09677419354839 | 5.806451612903226 | 4.193548387096774 | 2.580645161290323 | 0 | 98.87096774193547
5 | 5 | Employee5 | 1800 | 800 | 400 | 190 | 140 | 90 | 0 | 3420 | 58.06451612903226 | 7.258064516129032 | 25.80645161290322 | 12.90322580645161 | 6.129032258064516 | 4.516129032258065 | 2.903225806451613 | 0 | 110.3225806451613
6 | 6 | Employee6 | 2000 | 900 | 425 | 200 | 150 | 100 | 0 | 3775 | 64.51612903225806 | 8.064516129032258 | 29.03225806451613 | 13.70967741935484 | 6.451612903225806 | 4.838709677419355 | 3.225806451612903 | 0 | 121.7741935483871
7 | 7 | Employee7 | 2200 | 1000 | 450 | 210 | 160 | 110 | 0 | 4130 | 70.96774193548387 | 8.870967741935484 | 32.25806451612903 | 14.51612903225806 | 6.774193548387097 | 5.161290322580645 | 3.548387096774194 | 0 | 133.2258064516129
8 | 8 | Employee8 | 2400 | 1100 | 475 | 220 | 170 | 120 | 0 | 4485 | 77.41935483870968 | 9.67741935483871 | 35.48387096774194 | 15.32258064516129 | 7.096774193548387 | 5.483870967741935 | 3.870967741935484 | 0 | 144.6774193548387
9 | 9 | Employee9 | 2600 | 1200 | 500 | 230 | 180 | 130 | 0 | 4840 | 83.87096774193549 | 10.48387096774194 | 38.70967741935484 | 16.12903225806452 | 7.419354838709677 | 5.806451612903226 | 4.193548387096774 | 0 | 156.1290322580645
10 | 10 | Employee10 | 2800 | 1300 | 525 | 240 | 190 | 140 | 0 | 5195 | 90.3225806451613 | 11.29032258064516 | 41.93548387096774 | 16.93548387096774 | 7.741935483870968 | 6.129032258064516 | 4.516129032258065 | 0 | 167.5806451612904
11 | 11 | Employee11 | 3000 | 1400 | 550 | 250 | 200 | 150 | 0 | 5550 | 96.7741935483871 | 12.09677419354839 | 45.16129032258065 | 17.74193548387097 | 8.064516129032258 | 6.451612903225806 | 4.838709677419355 | 0 | 179.0322580645161
12 | 12 | Employee12 | 3200 | 1500 | 575 | 260 | 210 | 160 | 0 | 5905 | 103.2258064516129 | 12.90322580645161 | 48.38709677419355 | 18.54838709677419 | 8.387096774193548 | 6.774193548387097 | 5.161290322580645 | 0 | 190.4838709677419
13 | 13 | Employee13 | 3400 | 1600 | 600 | 270 | 220 | 170 | 0 | 6260 | 109.6774193548387 | 13.70967741935484 | 51.61290322580645 | 19.35483870967742 | 8.709677419354838 | 7.096774193548387 | 5.483870967741935 | 0 | 201.9354838709677
14 | 14 | Employee14 | 3600 | 1700 | 625 | 280 | 230 | 180 | 0 | 6615 | 116.1290322580645 | 14.51612903225806 | 54.83870967741935 | 20.16129032258064 | 9.03225806451613 | 7.419354838709677 | 5.806451612903226 | 0 | 213.3870967741935
15 | 15 | Employee15 | 3800 | 1800 | 650 | 290 | 240 | 190 | 0 | 6970 | 122.5806451612903 | 15.32258064516129 | 58.06451612903226 | 20.96774193548387 | 9.35483870967742 | 7.741935483870968 | 6.129032258064516 | 0 | 224.8387096774194
16 | 16 | Employee16 | 4000 | 1900 | 675 | 300 | 250 | 200 | 0 | 7325 | 129.0322580645161 | 16.12903225806452 | 61.29032258064516 | 21.7741935483871 | 9.67741935483871 | 8.064516129032258 | 6.451612903225806 | 0 | 236.2903225806452
17 | 17 | Employee17 | 4200 | 2000 | 700 | 310 | 260 | 210 | 0 | 7680 | 135.4838709677419 | 16.93548387096774 | 64.51612903225806 | 22.58064516129032 | 10 | 8.387096774193548 | 6.774193548387097 | 0 | 247.741935483871
18 | 18 | Employee18 | 4400 | 2100 | 725 | 320 | 270 | 220 | 0 | 8035 | 141.9354838709677 | 17.74193548387097 | 67.74193548387096 | 23.38709677419355 | 10.32258064516129 | 8.709677419354838 | 7.096774193548387 | 0 | 259.1935483870968
19 | 19 | Employee19 | 4600 | 2200 | 750 | 330 | 280 | 230 | 0 | 8390 | 148.3870967741935 | 18.54838709677419 | 70.96774193548387 | 24.19354838709678 | 10.64516129032258 | 9.03225806451613 | 7.419354838709677 | 0 | 270.6451612903226
20 | 20 | Employee20 | 4800 | 2300 | 775 | 340 | 290 | 240 | 0 | 8745 | 154.8387096774194 | 19.35483870967742 | 74.19354838709677 | 25 | 10.96774193548387 | 9.35483870967742 | 7.741935483870968 | 0 | 282.0967741935484
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 58000 | 27000 | 10750 | 4900 | 3900 | 2900 | 0 | 107450 | 1870.967741935484 | 233.8709677419355 | 870.9677419354839 | 346.7741935483871 |  |  | 93.5483870967742 |  | 3466.129032258065