User Tools

Site Tools


Sidebar

Table of Contents

general:eoyaccruals_juneyearendschools:step3

This is an old revision of the document!


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, Pay Status, 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.
  • Insert calculated columns:
    • Column H - Total Pay Remaining with the folliwng formula: Job Remaining Payments (column F) x Pay Rate (column G)
    • Column J - Difference with the following formula: Total Pay Remaining (column H) - Contract Balance (column I)

Excel File Maintenance Example

general/eoyaccruals_juneyearendschools/step3.1682441140.txt.gz · Last modified: 2023/04/25 16:45 by emoreno