general:eoyaccruals_juneyearendschools:step3
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| general:eoyaccruals_juneyearendschools:step3 [2023/04/28 13:27] – emoreno | general:eoyaccruals_juneyearendschools:step3 [2024/05/24 14:23] (current) – emoreno | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| * Sort the file by **Accrual Cd**, and then by **Last Name**. | * 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** | * 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. | + | * Insert a new column (**Total Pay Remaining**) between the **Pay Rate** and the **Contract Balance** columns. |
| - | * Insert calculated columns: | + | * In Column J, insert the calculation for the **Difference** with the following formula: **Total Pay Remaining** (column H) - **Contract Balance** (column I) |
| - | * Column H - **Total Pay Remaining** with the | + | |
| - | * Column J - **Difference** with the following formula: **Total Pay Remaining** (column H) - **Contract Balance** (column I) | + | |
| <div indent> | <div indent> | ||
general/eoyaccruals_juneyearendschools/step3.1682688467.txt.gz · Last modified: 2023/04/28 13:27 by emoreno