Calculate Payroll according to Absenteeism and Performance

Calculate the payroll table of this month on the basis of the basic information of employees, the absenteeism data of this month, and the performance data of this month. The basic algorithm is: Actual Pay = Base Pay*( 1 ĘC Absenteeism Factor + Performance Factor).

Solution:

A
1
=file@s("Employees.txt").import@t()
2
=file@s("Absenteeism.txt").import@t()
3
=file@s("Performance.txt").import@t()
4
=join@1(A1:E,Name;A2:A,Name;A3:P,Name)
5
=A4.new(E.Name:Name,round(E.BasePay*(1-A.Absenteeism+P.Performance)):SalaryPayable)

The computation in A5 is shown below: