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/25 16:37] – emoreno | general:eoyaccruals_juneyearendschools:step3 [2024/05/24 14:23] (current) – emoreno | ||
|---|---|---|---|
| Line 4: | Line 4: | ||
| Modify the Excel file. | Modify the Excel file. | ||
| - | * Sort the document | + | * 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** | + | * 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 |
| - | * Column H - **Total Pay Remaining** with the formula: **Job Remaining Payments** (column F) x **Pay Rate** (column G) | + | |
| - | * Column J - **Difference** with the formula: **Total Pay Remaining** (column H) - **Contract Balance** (column I) | + | |
| + | <div indent> | ||
| {{: | {{: | ||
| + | </ | ||
general/eoyaccruals_juneyearendschools/step3.1682440623.txt.gz · Last modified: 2023/04/25 16:37 by emoreno