Spreadsheet: 882467d1730858121-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter
Sheet: May

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-05-01 00:00:00 | Student to Trainer |  |  | [NAME] | 1 | [NAME] | 1.5 |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-01 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-01 00:00:00 | Student to Trainer |  |  | Xero | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-02 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-03 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-04 00:00:00 | Student to Trainer |  |  | MS Excel | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-08 00:00:00 | Remote training via Zoom video conferencing |  |  | Keyboarding | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed a student completion report and wish to claim for managing the timetable | 2023-05-08 00:00:00 |  |  |  |  |  |  |  |  |  |  | 60 | 1 | 60
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-08 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-09 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-09 00:00:00 | Student to Trainer |  |  | MS Word | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed a student completion report and wish to claim for managing the timetable | 2023-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 60 | 1 | 60
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-10 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-10 00:00:00 | Student to Trainer |  |  | MS Excel | 1 | Windows | 0.5 |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-11 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | Amanda [NAME] | I have returned a student laptop back to SBS after student use | 2023-05-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have returned a student laptop back to SBS after student use | 2023-05-12 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have completed today's training | 2023-05-12 00:00:00 | Student to Trainer |  |  | MS Word | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-15 00:00:00 | Student to Trainer |  |  | Windows | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-16 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-16 00:00:00 | Student to Trainer |  |  | MS Word | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-17 00:00:00 | Student to Trainer |  |  | Xero | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-18 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-19 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I am submitting a student progress update | 2023-05-23 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | [NAME] | I have completed today's training | 2023-05-23 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-23 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-24 00:00:00 | Student to Trainer |  |  | Xero | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-25 00:00:00 | Student to Trainer |  |  | MS PowerPoint | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-26 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am submitting a student progress update | 2023-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-29 00:00:00 | Student to Trainer |  |  | Xero | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-30 00:00:00 | Student to Trainer |  |  | Windows | 1 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I have completed today's training | 2023-05-30 00:00:00 | Student to Trainer |  |  | MS Excel | 1.5 |  |  |  |  |  | 31.5
[NAME] | Charmain [NAME] | I have completed today's training | 2023-05-31 00:00:00 | Student to Trainer |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5