User Tools

Site Tools


Sidebar

Table of Contents

general:eoyaccruals_juneyearendschools:step3

Perform Excel file maintenance

Modify the Excel file.

  • Sort the file by Accrual Cd, and then by Last Name.
  • Arrange the order of columns as follows: Employee Nbr, First Name, Last Name, Accrual Code, Accrual Rate, Remaining Payments, Pay Rate, and Contract Balance
  • Insert a new column (Total Pay Remaining) between the Pay Rate and the Contract Balance columns. And, then in this column (Column H), insert the following formula: Job Remaining Payments (column F) x Pay Rate (column G)
  • In Column J, insert the calculation for the Difference with the following formula: Total Pay Remaining (column H) - Contract Balance (column I)

Excel File Maintenance Example

general/eoyaccruals_juneyearendschools/step3.txt · Last modified: 2024/05/24 14:23 by emoreno