Payroll Summary and Allocation Analysis

I need a detailed payroll summary and allocation by class for each employee, based on three provided spreadsheets: bi-monthly payroll salary masterfile (sheet1), work compensation (sheet2), and class allocations by employee (sheet3) which changes every month. All sheets linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Experience with payroll data and understanding of payroll terminology. - Attention to detail and accuracy in calculations.