When calculating, use the below formula: Payable Weekly Wage=Standard Weekly Wage*(1+Performance addition-absence hour/40)+Bounce.
Since the data is stored in three worksheets, the Join operation must be conducted according to the employee number.
Resort to formula lookup to consolidate the data in the spreadsheet:
Then, calculate the weekly salary payable:
When using Traditional Business Spreadsheet Tool to handle the multi-table joining, usually, you will have to locate and reference through the complicated formula and it is very difficult to view or modify. If you have no skill to use formulas to locate and reference in Traditional Spreadsheet Tool, then you will have to process the data manually. Such work will be more complex.
In order to judge the join value for multi-table join, the cell A2 and its homocells will be set as the master cell in the three calculation cellsets.
Perform the join operation, join the absence data, the performance and bonus information to the first table:
At last, calculate the payable weekly salary:
With esCalc, the desktop BI software, you can complete many senior computations through some very basic operations, such as the multi-table join. Everyone can be the expert in the data computation.