Spreadsheet: 882471d1730861435-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r1
Sheet: Mar

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
[NAME] | [NAME] | I have completed today's training | 2023-03-01 00:00:00 | Student to Trainer |  |  | Unit 122 - Reception Duties | 2 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2023-03-01 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 2 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-02 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed a TNA | 2023-03-07 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50
[NAME] | [NAME] | I have completed today's training | 2023-03-13 00:00:00 | Student to Trainer |  |  | Unit 122 - Reception Duties | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-13 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am submitting a student progress update | 2023-03-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-14 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-14 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2023-03-15 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Excel | 1 | Google Drive | 1 |  |  |  | 31.5
[NAME] | [NAME] | I have returned a student laptop back to SBS after student use | 2023-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | Charmain [NAME] | I have completed a TNA | 2023-03-16 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50
[NAME] | [NAME] | I have completed today's training | 2023-03-16 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-16 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-17 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-20 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-20 00:00:00 | Student to Trainer |  |  | MS Excel | 2 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-21 00:00:00 | Student to Trainer |  |  | [NAME] | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-21 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2023-03-22 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 1.5 | [NAME] | 0.5 |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-22 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 2 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-23 00:00:00 | Student to Trainer |  |  | [NAME] | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-23 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-24 00:00:00 | Student to Trainer |  |  | Google Drive | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-27 00:00:00 | Student to Trainer |  |  | MS Excel | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-27 00:00:00 | Remote training via Zoom video conferencing |  |  | MS Word | 1 | Google Drive | 1 |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-28 00:00:00 | Student to Trainer |  |  | Google Drive | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-28 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have completed today's training | 2023-03-29 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-29 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 2 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have returned a student laptop back to SBS after student use | 2023-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have completed today's training | 2023-03-30 00:00:00 | Student to Trainer |  |  | Unit 327 - Business Transactions | 2 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-30 00:00:00 | Student to Trainer |  |  | Google Drive | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-03-30 00:00:00 | Student to Trainer |  |  | MS Word | 1 |  |  |  |  |  | 31.5
[NAME] | Sandra  Redmayne | I have completed today's training | 2023-03-31 00:00:00 | Student to Trainer |  |  | Windows | 1 |  |  |  |  |  | 31.5