Spreadsheet: 882813d1731297099-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r3
Sheet: Aug 24

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value | TORF Ref #
[NAME] | [NAME] | I have completed today's training | 2024-08-01 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17969457
[NAME] | [NAME] | I am submitting a student progress update | 2024-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20 | TORF# 17969488
[NAME] | [NAME] | I am submitting a student progress update | 2024-08-02 00:00:00 |  | DELETED - as per email from Rhiannon |  |  |  |  |  |  |  |  |  |  |  | TORF# 17972467
[NAME] | [NAME] | I have completed today's training | 2024-08-05 00:00:00 | Student to Trainer |  |  | Unit 28295 - Demonstrate knowledge of serving customers | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17981276
[NAME] | [NAME] | I have completed a TNA | 2024-08-05 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50 | TORF# 17977003
[NAME] | [NAME] | I have completed today's training | 2024-08-05 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17977006
[NAME] | [NAME] | I am submitting a student progress update | 2024-08-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20 | TORF# 17980992
[NAME] | [NAME] | I am submitting a student progress update | 2024-08-06 00:00:00 |  | DELETED - as per email from Rhiannon |  |  |  |  |  |  |  |  |  |  |  | TORF# 17981274
[NAME] | [NAME] hyslop | I have completed a TNA | 2024-08-06 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50 | TORF# 17981423
[NAME] | [NAME] | I have completed today's training | 2024-08-06 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17981005
[NAME] | [NAME] | I have completed today's training | 2024-08-07 00:00:00 | Student to Trainer | DELETED - as per email from Michelle |  | Unit 56 - Customer Enquiries | 1.5 |  |  |  |  |  |  |  |  | TORF# 18001434
[NAME] | [NAME] | I have completed today's training | 2024-08-12 00:00:00 | Student to Trainer |  |  | Unit 56 - Customer Enquiries | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18001439
[NAME] | [NAME] | I have completed today's training | 2024-08-12 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17998079
[NAME] | [NAME] | I have returned a student laptop back to SBS after student use | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20 | TORF# 17998148
[NAME] | [NAME] | I have completed today's training | 2024-08-13 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17998348
[NAME] | Shannon McKoy | I have completed today's training | 2024-08-13 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18001025
[NAME] | [NAME] | I have completed today's training | 2024-08-14 00:00:00 | Student to Trainer |  |  | Unit 56 - Customer Enquiries | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18001441
[NAME] | [NAME] | I have completed today's training | 2024-08-14 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18001445
[NAME] | [NAME] | I have completed today's training | 2024-08-19 00:00:00 | Student to Trainer |  |  | Unit 56 - Customer Enquiries | 1 | Unit 57 - Provide Customer Service | 0.5 |  |  |  | 31.5 |  |  | TORF# 18009291
[NAME] | [NAME] | I have completed today's training | 2024-08-19 00:00:00 | Student to Trainer |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18009194
[NAME] | [NAME] | I have completed today's training | 2024-08-20 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1 | Unit 25000 - Demonstrate knowledge of security systems | 0.5 |  |  |  | 31.5 |  |  | TORF# 18028833
[NAME] | [NAME] | I have completed today's training | 2024-08-21 00:00:00 | Student to Trainer |  |  | Unit 57 - Provide Customer Service | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18016709
[NAME] | [NAME] | I have completed today's training | 2024-08-21 00:00:00 | Student to Trainer |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18016696
[NAME] | [NAME] | I have completed today's training | 2024-08-22 00:00:00 | Remote training via Zoom video conferencing |  |  | Unit 25000 - Demonstrate knowledge of security systems | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18028836
[NAME] | [NAME] | I have completed today's training | 2024-08-26 00:00:00 | Student to Trainer |  |  | Unit 57 - Provide Customer Service | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18028777
[NAME] | [NAME] | I have completed today's training | 2024-08-26 00:00:00 | Student to Trainer | Marking |  | Unit 56 - Customer Enquiries | 0.5 | Unit 57 - Provide Customer Service | 0.5 |  |  |  | 31.5 |  |  | TORF# 18044768
[NAME] | [NAME] | I have completed today's training | 2024-08-26 00:00:00 | Student to Trainer |  |  | [NAME] | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18025432
[NAME] | [NAME] | I have completed today's training | 2024-08-27 00:00:00 | Student to Trainer |  |  | Unit 28295 - Demonstrate knowledge of serving customers | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18028840
[NAME] | [NAME] | I have completed today's training | 2024-08-28 00:00:00 | Student to Trainer |  |  | Unit 57 - Provide Customer Service | 0.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18028779
[NAME] | [NAME] | I have completed today's training | 2024-08-28 00:00:00 | Student to Trainer | Marking |  | Unit 25000 - Demonstrate knowledge of security systems | 0.5 | Unit 28295 - Demonstrate knowledge of serving customers | 0.5 |  |  |  | 31.5 |  |  | TORF# 18044770
[NAME] | [NAME] | I am submitting a request for an ad-hoc payment | 2024-08-28 00:00:00 |  | DELETE - to be resubmitted |  |  |  |  |  |  |  |  |  |  |  | TORF# 18028787
[NAME] | [NAME] | I have completed a student completion report and wish to claim for managing the timetable | 2024-08-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | 60 | 1 | 60 | TORF# 18028814
[NAME] | [NAME] | I have completed today's training | 2024-08-28 00:00:00 | Student to Trainer |  |  | Internet Google Chrome | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 18028822