Spreadsheet: 32601d1228783994-data-sort-and-match-student-time-log
Sheet: Manual Restructuring of Data

From Student Data (manually) |  |  | The Way It Should Be |  |  |  |  | Allocated Hours per Course
Date | Hours Attended |  | Date | Hours Attended | Course Name |  |  | Course Name | Planned Hours
2008-08-04 00:00:00 | 8 |  | 2008-08-04 00:00:00 | 8 | OSHA 103 |  |  | OSHA 103 | 8
2008-08-05 00:00:00 | 7.5 |  | 2008-08-05 00:00:00 | 7.5 | MTO 128 |  |  | MTO 128 | 8
2008-08-06 00:00:00 | 6 |  | 2008-08-06 00:00:00 | 0.5 | MTO 128 |  |  | MTO 128L | 8
2008-08-07 00:00:00 | 6.5 |  |  | 5.5 | MTO 128L |  |  | MTO 123 | 70
2008-08-11 00:00:00 | 7.5 |  | 2008-08-07 00:00:00 | 2.5 | MTO 128L |  |  | MTO 122 | 35
2008-08-12 00:00:00 | 6 |  |  | 4 | MTO 123 |  |  | MTO 130 | 8
2008-08-13 00:00:00 | 5 |  | 2008-08-11 00:00:00 | 7.5 | MTO 123 |  |  | MTO 130L | 27
2008-08-14 00:00:00 | 6.5 |  | 2008-08-12 00:00:00 | 6 | MTO 123 |  |  | MTO 129 | 8
2008-08-15 00:00:00 | 3 |  | 2008-08-13 00:00:00 | 5 | MTO 123 |  |  | MTO 129L | 70
2008-08-26 00:00:00 | 7.5 |  | 2008-08-14 00:00:00 | 6.5 | MTO 123 |  |  | MTO 131 | 8
2008-08-27 00:00:00 | 5 |  | 2008-08-15 00:00:00 | 3 | MTO 123 |  |  | MTO 131L | 70
2008-08-28 00:00:00 | 7 |  | 2008-08-26 00:00:00 | 7.5 | MTO 123 |  |  | MTO 124 | 16
2008-08-29 00:00:00 | 6 |  | 2008-08-27 00:00:00 | 5 | MTO 123 |  |  | MTO 133 | 8
2008-09-02 00:00:00 | 6 |  | 2008-08-28 00:00:00 | 7 | MTO 123 |  |  | MTO 133L | 27
2008-09-03 00:00:00 | 4.5 |  | 2008-08-29 00:00:00 | 6 | MTO 123 |  |  | MTO 139 | 80
2008-09-04 00:00:00 | 6 |  | 2008-09-02 00:00:00 | 6 | MTO 123 |  |  | MTO 139L | 85
2008-09-05 00:00:00 | 7 |  | 2008-09-03 00:00:00 | 4.5 | MTO 123 |  |  | MTO 137 | 80
2008-09-08 00:00:00 | 4 |  | 2008-09-04 00:00:00 | 2 | MTO 123 |  |  | MTO 137L | 85
2008-09-09 00:00:00 | 8 |  |  | 4 | MTO 122 |  |  |  | 701
2008-09-10 00:00:00 | 7 |  | 2008-09-05 00:00:00 | 7 | MTO 122
2008-09-11 00:00:00 | 7.5 |  | 2008-09-08 00:00:00 | 4 | MTO 122
2008-09-12 00:00:00 | 5 |  | 2008-09-09 00:00:00 | 8 | MTO 122
2008-09-15 00:00:00 | 7 |  | 2008-09-10 00:00:00 | 7 | MTO 122
2008-09-16 00:00:00 | 10 |  | 2008-09-11 00:00:00 | 5 | MTO 122
2008-09-17 00:00:00 | 6.5 |  |  | 2.5 | MTO 130
2008-09-18 00:00:00 | 5.5 |  | 2008-09-12 00:00:00 | 5 | MTO 130
2008-09-19 00:00:00 | 3.5 |  | 2008-09-15 00:00:00 | 0.5 | MTO 130
2008-09-22 00:00:00 | 6 |  |  | 6.5 | MTO 130L
2008-09-23 00:00:00 | 5 |  | 2008-09-16 00:00:00 | 10 | MTO 130L
2008-09-25 00:00:00 | 4.5 |  | 2008-09-17 00:00:00 | 6.5 | MTO 130L
2008-09-26 00:00:00 | 5.5 |  | 2008-09-18 00:00:00 | 4 | MTO 130L
2008-09-29 00:00:00 | 8 |  |  | 1.5 | MTO 129
2008-09-30 00:00:00 | 7.5 |  | 2008-09-19 00:00:00 | 3.5 | MTO 129
2008-10-01 00:00:00 | 7.5 |  | 2008-09-22 00:00:00 | 3 | MTO 129
2008-10-08 00:00:00 | 2.5 |  |  | 3 | MTO 129L
2008-10-09 00:00:00 | 6 |  | 2008-09-23 00:00:00 | 5 | MTO 129L
2008-10-10 00:00:00 | 5 |  | 2008-09-25 00:00:00 | 4.5 | MTO 129L
2008-10-13 00:00:00 | 3.5 |  | 2008-09-26 00:00:00 | 5.5 | MTO 129L
2008-10-14 00:00:00 | 5.5 |  | 2008-09-29 00:00:00 | 8 | MTO 129L
2008-10-15 00:00:00 | 2 |  | 2008-09-30 00:00:00 | 7.5 | MTO 129L
2008-10-16 00:00:00 | 7 |  | 2008-10-01 00:00:00 | 7.5 | MTO 129L
2008-10-17 00:00:00 | 3 |  | 2008-10-08 00:00:00 | 2.5 | MTO 129L
2008-10-20 00:00:00 | 6 |  | 2008-10-09 00:00:00 | 6 | MTO 129L
2008-10-21 00:00:00 | 3.5 |  | 2008-10-10 00:00:00 | 5 | MTO 129L
2008-10-22 00:00:00 | 5 |  | 2008-10-13 00:00:00 | 3.5 | MTO 129L
2008-10-27 00:00:00 | 6 |  | 2008-10-14 00:00:00 | 5.5 | MTO 129L
2008-10-28 00:00:00 | 5 |  | 2008-10-15 00:00:00 | 2 | MTO 129L
2008-10-29 00:00:00 | 7 |  | 2008-10-16 00:00:00 | 4.5 | MTO 129L
2008-10-30 00:00:00 | 6.5 |  |  | 2.5 | MTO 131
2008-11-03 00:00:00 | 7 |  | 2008-10-17 00:00:00 | 3 | MTO 131
2008-11-04 00:00:00 | 6 |  | 2008-10-20 00:00:00 | 2.5 | MTO 131
2008-11-05 00:00:00 | 5.5 |  |  | 3.5 | MTO 131L
2008-11-10 00:00:00 | 6 |  | 2008-10-21 00:00:00 | 3.5 | MTO 131L
2008-11-13 00:00:00 | 4 |  | 2008-10-22 00:00:00 | 5 | MTO 131L
 | 315 |  | 2008-10-27 00:00:00 | 6 | MTO 131L
 |  |  | 2008-10-28 00:00:00 | 5 | MTO 131L
 |  |  | 2008-10-29 00:00:00 | 7 | MTO 131L
 |  |  | 2008-10-30 00:00:00 | 6.5 | MTO 131L
 |  |  | 2008-11-03 00:00:00 | 7 | MTO 131L
 |  |  | 2008-11-04 00:00:00 | 6 | MTO 131L
 |  |  | 2008-11-05 00:00:00 | 5.5 | MTO 131L
 |  |  | 2008-11-10 00:00:00 | 6 | MTO 131L
 |  |  | 2008-11-13 00:00:00 | 4 | MTO 131L
 |  |  |  |  | TO Date