Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Work Calculator

Employee Name : |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | finish this off then go to pay calculator |  |  |  |  | FINISH OFF |  |  |  |  |  |  |  |  |  |  |  | CAPTURE NEW VOT AND CRIB ENTRIES |  |  |  |  |  |  | CAPTURE NEW VOT AND CRIB ENTRIES
Employee Staff # : |  |  | 894378 | Classification : | Bus Operator
DATE | DAY | SHIFT [NAME] | PAY CLASSIFICATION | SHIFT PENALTY/EXTRA ADD-ONS |  |  | SHIFT # |  | PRE-START VOLUNTARY OVERTIME |  |  |  |  | 1st. HALF |  |  |  | VOLUNTARY OVERTIME DURING BREAK |  |  |  |  | PAID CRIB |  |  |  |  | UNPAID BREAK |  | 2nd. HALF |  |  |  | EXTRA RUN TIME | TOTAL HOURS WORKED |  | BUILD-UP TIME DEDUCTED (Mins) |  | BALANCE OF TIME DUE FOR PAYMENT | TOTAL SPREAD |  | [NAME] (VOT) PLUS ALL ROSTERED WORK THAT EXCEEDS 8.25hrs                                                                                                                                           That is any work that is rostered or voluntarily accepted in a shift that exceeds 8.25 hrs |  |  |  |  |  |  |  |  |  | EARLY-LATE PENALTY | BROKEN SHIFT PENALTY |  |  |  |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED                (RDOC) |  |  | ADO | ALLOCATED DAY OFF CANCELLED                            (ADOC) |  |  |  | ANNUAL LEAVE | SICK DAY
 |  |  |  | ADD-ON #1 | ADD-ON #2 | ADD-ON #3 |  |  | START | END | [NAME]:mins | [NAME] |  | START | END | HOURS WORKED |  | START | END | [NAME]:mins | [NAME] |  | START | END | [NAME]:mins | [NAME] |  |  |  | START | END | HOURS WORKED |  |  | Hrs:mins | [NAME] | Hrs:mins | [NAME] |  |  |  | START | END | [NAME]:mins | [NAME] |  | TOTAL HOURS WORKED | DEFAULT HOURS PAID | 0.5 | 1 |  | HOURS | TOTAL HOURS | DEFAULT HOURS PAID | 9.5-10.5 hours | After 10.5 hours |  | HOURS WORKED | +DEFAULT HOURS | NO WORK |  | HOURS WORKED | 1½ | DOUBLE |  | ADO DEFAULT | 1½ | DOUBLE
WEEK 1
2023-09-24 00:00:00 | Sunday | Day Off - No Pay | Bus Operator | Nil | Nil | No Build-Up Time | Nil |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 0 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | N/A | N/A
2023-09-25 00:00:00 | Monday | [NAME] | Bus Operator | ADOC | Nil | No Build-Up Time | D294 |  | 00:00:00 | 00:00:00 |  |  |  | 03:00:00 | 07:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 07:50:00 | 11:50:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-09-26 00:00:00 | Tuesday | [NAME] | [NAME] | Public Holiday | Nil | Nil | A126 |  | 00:00:00 | 00:00:00 |  |  |  | 06:57:00 | 10:56:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 14:09:00 | 18:55:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-09-27 00:00:00 | Wednesday | [NAME] | HDBOY | Public Holiday+Work | Nil | No Build-Up Time | E830 |  | 00:00:00 | 00:00:00 |  |  |  | 07:33:00 | 11:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 15:02:00 | 19:25:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-09-28 00:00:00 | Thursday | Normal/Straight | Bus Operator | RDOC | High Capacity Allowance | No Build-Up Time | A052 |  | 00:00:00 | 00:00:00 |  |  |  | 06:32:00 | 10:32:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 11:22:00 | 16:10:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-09-29 00:00:00 | Friday | [NAME] | Bus Operator | Nil | Nil | Nil | D300 |  | 00:00:00 | 00:00:00 |  |  |  | 06:58:00 | 11:27:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 14:54:00 | 18:50:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-09-30 00:00:00 | Saturday | Day Off - No Pay | Bus Operator | Nil | Nil | Nil | D840 |  | 00:00:00 | 00:00:00 |  |  |  | 08:38:00 | 13:24:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 14:14:00 | 18:25:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Week 1 Totals :
WEEK 2
2023-10-01 00:00:00 | Sunday | Normal/Straight | Bus Operator | Nil | Nil | No Build-Up Time | D123 |  | 00:00:00 | 00:00:00 |  |  |  | 07:30:00 | 11:40:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 12:30:00 | 17:15:00 |  |  |  |  |  | 0 | 0 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | N/A | N/A
2023-10-02 00:00:00 | Monday | Normal/Straight | Bus Operator | Nil | Nil | Nil | D123 |  | 00:00:00 | 00:00:00 |  |  |  | 05:08:00 | 09:14:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 10:04:00 | 14:58:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-10-03 00:00:00 | Tuesday | Normal/Straight | Bus Operator | Nil | Nil | Nil | D149 |  | 00:00:00 | 00:00:00 |  |  |  | 11:48:00 | 15:05:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 15:54:00 | 20:25:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-10-04 00:00:00 | Wednesday | Normal/Straight | Bus Operator | Nil | Nil | Nil | D081 |  | 00:00:00 | 00:00:00 |  |  |  | 13:48:00 | 17:03:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 17:50:00 | 22:19:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-10-05 00:00:00 | Thursday | Normal/Straight | [NAME] | Nil | Nil | Nil | Y001 |  | 00:00:00 | 00:00:00 |  |  |  | 14:50:00 | 18:50:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 19:30:00 | 00:30:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-10-06 00:00:00 | Friday | Normal/Straight | [NAME] | Nil | Nil | Nil | Y001 |  | 00:00:00 | 00:00:00 |  |  |  | 20:50:00 | 23:15:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:05:00 | 04:30:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
2023-10-07 00:00:00 | Saturday | Day Off - No Pay | Bus Operator | Nil | Nil | No Build-Up Time | Nil |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 | 00:00:00 |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Week 2 Totals :
 |  |  |  |  |  |  | COMBINED TOTAL :