Differences

This shows you the differences between two versions of the page.

--- general:eoyaccruals_juneyearendschools:step3 [2018/05/31 18:00] – emoreno
+++ general:eoyaccruals_juneyearendschools:step3 [2024/05/24 14:23] (current) – emoreno
@@ Line 1: / Line 1: @@
-Clean up the Excel file.
+==== Perform Excel file maintenance ====
-  * Delete pay status code 2 (inactive) people.
-  * Sort by **Accrual Cd**, and then by **Last Name**.
-  * Insert Calculated Columns (Column H - Total Pay Remaining) and (Column J – Difference)
-++++Image|{{:general:eoyaccruals_juneyearendschools:june_accruals_step_3.jpg|}}++++
+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)
+<div indent>
+{{:general:eoyaccruals_juneyearendschools:june_accruals_step_3.jpg|Excel File Maintenance Example}}
+</div>

Business