Spreadsheet: 536923d1504752561-extract-the-value-of-about-30-different-cell-references-out-of-420-closed-workbooks-example-data-file
Sheet: Example data

Timesheet Calculation - VECTEA Early Childhood Educator |  |  |  |  |  |  |  |  | Toilets |  | Position |  |  | Qualification |  |  | ?? (Below)
 |  |  |  |  |  |  |  |  | Yes | 1
Emp Name: | [NAME] |  |  | Position: | Certificate III Qualified ECE |  |  |  | No | 2 |  |  |  |  |  | 3
Emp ID: | 10078 |  |  | Qualification: | Certificate III |  |  |  |  | 3 |  |  |  |  |  | 4
Location: | Example Kinder |  |  | Classification: |  |  |  |  | Delay | 4
Fixed Term: | N/A |  |  | Level: | Level 1.4 |  |  |  | Yes
Reason for change: |  | 2017 Rostered hours |  | Rate: |  |  |  |  | No
 |  |  |  | Increment date (if appl): | 2018-04-11 00:00:00 |  |  |  | N/A
Contact Hours |  |  |  | Effective date: | 2017-01-30 00:00:00 |  |  |  | Breaks from teaching duties
Day | Group (3 / 4) | Start Time | Finish Time | Meal Break | Teaching Hours |  |  |  | 1 | Your meal break is 30 minutes. This meal break is paid and undertaken concurrently with non-contact duties.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min Prep | [NAME] | If session time is over 5.5 hours, apply relevant break during the session, except break optinn 1 which should only applied if session is over 6 hours.
Monday | 4 | 13:30:00 | 18:30:00 |  |  |  |  |  | 2 | This meal break is paid as non contact duties during your session and you are required to stay on call on the premises to meet National Regulation Staffing obligations. |  |  |  |  |  |  |  |  |  | If time between rostered start time and group time is 2 hours or less, use the hours between rostered start time and session end time to determine if break is required
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prep time is accrued at a minimum of 45 minutes per group session. This is applied to AGLs as well as asssitants, even though VECTAA only requires 30 mins for AGLs
Tuesday | 4 | 16:00:00 | 18:30:00
 |  |  |  |  |  |  |  |  | 3 | Your meal break is 30 minutes. This meal break is unpaid.
Wednesday | 4 | 13:30:00 | 18:30:00
 |  |  |  |  |  |  |  |  | 4 | No break required.
Thursday | 4 | 16:00:00 | 18:30:00
Friday | 4 | 13:30:00 | 18:30:00
 |  |  |  |  |  |  |  |  | Select Break Options Warning (Below)
 |  | Total Contact Hours |  |  |  |  |  |  |  |  |  |  |  |  | Level | Rate | Classification
Total Rostered Hours
Day |  | Start Time | Finish Time | Meal Break | Total Hours | Toilets Y/N |  | Break Option*
 |  |  |  |  |  |  |  |  |  |  |  |  | Reasonable Hours Alert (Below)
Monday |  | 13:00:00 | 19:00:00 |  |  | No |  | 1
Tuesday |  | 15:15:00 | 19:00:00 |  |  | No |  | 4
Wednesday |  | 13:15:00 | 19:00:00 |  |  | No |  | 1
Thursday |  | 15:15:00 | 19:00:00 |  |  | No |  | 4
Friday |  | 13:15:00 | 19:00:00 |  |  | No |  | 1
 |  | Total Rostered Hours
 |  |  |  |  |  |  |  |  | Warning (Left)
 | Contact Hours
 | Non-Contact Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Non teaching time accrued at 50% of teaching time, except;
 | Additional Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly hours cannot exceed 38
 | Other Approved Hours |  |  |  |  |  |  |  | <-- "Additional Hours" should be manually add hours to this line. |  |  |  |  |  |  |  | Uniform Allowance is accrued at 0.68 per day
 |  |  |  | Total Rostered Hours |  |  |  |  |  |  |  |  |  |  |  |  | Meal allowance of 9.25 payable where the day finishes after 6pm or is longer than 9 hours
 |  |  |  | Paid Hours / Fortnight: |  |  |  |  | Wkly Hrs | Rate | P/A |  |  |  |  |  | First Aid allowance of 1.10 per session if "appointed by the employer to be responsible for first-aid"
 |  |  |  | Uniform Allowance / Fortnight: |  |  |  |  |  |  |  |  | Old P/A
 |  |  |  |  |  |  |  |  |  |  |  |  | New P/A
 | You have agreed to delay your meal break to no later than 6 hours from the commencement of your rostered hours. |  |  |  |  |  |  |  |  | Increase PA
Break Options
Breaks from teaching duties
1 | Your meal break is 30 minutes. This meal break is paid and undertaken concurrently with non-contact duties.
2 | This meal break is paid as non contact duties during your session and you are required to stay on call on the premises to meet National Regulation Staffing obligations.
3 | Your meal break is 30 minutes. This meal break is unpaid.
4 | No break required.