Spreadsheet: 836658d1689569496-sum-formula-error-fornightly-pay-calculation-copy
Sheet: Pay 18-2022

Employee Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fortnightly Pay Adjustment Summary
Emp. ID: |  | FYR | 2021/2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Paid | Due | Difference | Adjustment
Surname: |  | Pay | 18/2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Adjustment | 2876.27
First Name(s): |  | Faculty/Division: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Interest 5%
[NAME]: | 40.5108 | School/Branch: | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation OTE | 2876.27 | 2467.1
Meal Allowance Rate: | 25.59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation Rate for FYR | 0.1 | 0.11
Payday | 2022-03-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Superannuation
Fortnight Start Date: | 2022-02-03 00:00:00
Sat Established Pattern: | Yes
Sun Establised Pattern:
PROFESSIONAL EMPLOYEES - RECALCUATIOED FORTNIGHTLY PAY
Day | Date | Public Holiday | Job | Professional Employee Level | Hrly rate of pay (inc 25% [NAME]) | Use 24 hour time fomat for start & finish times below (HH:MM) |  |  |  | Hours Claimed | Cumlative Hours per day (H) | [NAME] (Decimal) | Salary $ per job | Overtime hours | Overtime - Time and a Half. |  | Overtime - Double Time. |  | Overtime - Double Time and a half. |  | Overtime Daily $ Total |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Monday to Sat |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Sunday |  | Penalty for work outside span (ie within 7.35 per day but outside span)  Public Holiday |  | Daily summary # of normal hrs to be paid as [NAME] | Daily Summary of  Salary $ | Daily # of overtime hrs to be paid | Daily Summary of Overtime $ | Daily # of  Penalty hrs to be paid | Daily Summary of Penalty $ | Meal Allowances | Meal $ | Gross amount | Were you on campus for study or other CDU paid work on this day?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Normal + 50%) |  | (Normal + 100%) |  | (Normal + 150%) |  |  |  | 150% (100% Salary) |  | 200% (100% Salary) |  | 2.5
 |  |  |  |  |  | Start | Break Start | Break Finish | Finish |  |  |  |  |  | 1.5 |  | 2 |  | 2.5 |  |  | Total hours work in span hrs | 0.5 |  | 1 |  | 1.5
Thursday |  |  | 1 | Professional - 1.3 |  | 08:30:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  | 2 | Professional - 1.3 |  | 16:00:00 |  |  | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 1.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  | 2 | Professional - 2.3 |  | 09:00:00 |  |  | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Monday |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  | 1 | Professional - 2.3 |  | 08:30:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  | 2 | Professional - 2.3 |  | 16:00:00 |  |  | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  | 1 | Professional - 2.3 |  | 09:00:00 | 12:00:00 | 12:30:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  | 2 | Professional - 2.3 |  | 17:00:00 |  |  | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Thursday |  |  | 1 | Professional - 2.3 |  | 09:00:00 | 12:00:00 | 13:00:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Friday |  |  |  | Professional - 2.3 |  | 08:30:00 |  |  | 12:30:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Saturday |  |  | 2 | Professional - 2.3 |  | 09:00:00 |  |  | 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Sunday |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  | N/A | N/A |  |  |  |  |  |  |  |  |  |  | N/A | N/A |  | No
Monday |  |  | 2 | Professional - 2.3 |  | 09:00:00 |  |  | 15:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Tuesday |  |  | 2 | Professional - 2.3 |  | 09:00:00 | 15:00:00 | 16:00:00 | 18:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Wednesday |  |  |  | Professional - 2.3 |  | 09:00:00 | 12:00:00 | 12:30:00 | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
 |  |  |  | Professional - 2.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No
Total Gross (recalculated)