Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
3D Array Payroll
Hi all, I am using Excel 2003 with Vista. I have a reference WkSht with all the Tax, Social Security, Union Dues rates laid out against each element of the Wage Structure package. The Table is laid out as follows: Tax Soc Union etc etc Security Dues Basic Wages 10% 5% 3% Leave Pay 7.5% 3% 3% Subsistence 5.0% 2.5% 3% In the Payroll Calculations WkSht I have the Payroll calculations for each employee and for each element of the Wage Structure Employee Name A B C D etc etc Basic Wages 1,000 750 650 500 Leave Pay 500 375 300 250 Subsistence 160 160 160 160 etc etc What I need to do is to calculate the various deductions against each element of the Pay Structure in a separate table in the same WkSht as the Payroll Calculations. The table is laid out as follows: Employee Name A B C D etc etc Tax Social Security Union Dues etc etc The layout of the Tables cannot be altered as this is part of a much larger project. Any assistance much appreciated/Many thanks/sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need payroll | Excel Discussion (Misc queries) | |||
Payroll | Excel Discussion (Misc queries) | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
Payroll | New Users to Excel | |||
Payroll | Excel Discussion (Misc queries) |