Spreadsheet: 180206d1347526996-color-lookup-with-a-sum-component-book1
Sheet: Sheet1

Group SchStarHR | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | Wkday Tabletable
05:00:00 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
06:00:00 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
07:00:00 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
08:00:00 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4
09:00:00 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 3 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
10:00:00 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
11:00:00 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
12:00:00 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
13:00:00 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
14:00:00 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4
15:00:00 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 6 | 7
16:00:00 | 6 | 6 | 6 | 5 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 6 | 6 | 6 | 5 | 5 | 6 | 6 | 6
17:00:00 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4 | 5
18:00:00 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
19:00:00 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
20:00:00 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2
21:00:00 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 2 | 2
22:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65
No. of missed trips
No. of schedule trips by hour | 13 | 7 | 9 | 6 | 6 | 0 | 0
Count of SchedStart time | Operations Date
Group SchStarHR | 2012-03-03 00:00:00 | 2012-03-10 00:00:00 | 2012-03-17 00:00:00 | 2012-03-24 00:00:00 | 2012-03-31 00:00:00 | Saturday timetable
06:00:00 | 2 | 2 | 2 | 2 | 2 | 2
07:00:00 | 3 | 3 | 3 | 3 | 3 | 3
08:00:00 | 2 | 2 | 2 | 2 | 1 | 2
09:00:00 | 2 | 2 | 2 | 2 | 2 | 2
10:00:00 | 1 | 2 | 2 | 2 | 2 | 2
11:00:00 | 1 | 1 | 1 | 1 | 1 | 1
12:00:00 | 2 | 2 | 2 | 2 | 2 | 2
13:00:00 | 2 | 2 | 2 | 2 | 2 | 2
14:00:00 | 2 | 2 | 2 | 2 | 2 | 2
15:00:00 | 2 | 2 | 2 | 2 | 2 | 2
16:00:00 | 2 | 1 | 2 | 2 | 2 | 2
17:00:00 | 2 | 2 | 2 | 2 | 2 | 2
18:00:00 | 3 | 3 | 3 | 3 | 3 | 3
19:00:00 | 2 | 2 | 2 | 2 | 2 | 2
20:00:00 | 2 | 2 | 2 | 2 | 2 | 2
21:00:00 | 2 | 2 | 2 | 2 | 2 | 2
22:00:00 | 1 | 1 | 1 | 1 | 1 | 1
No. of missed trips
Count of SchedStart time | Operations Date
Group SchStarHR | 2012-03-04 00:00:00 | 2012-03-11 00:00:00 | 2012-03-18 00:00:00 | 2012-03-25 00:00:00 | Sunday timetable
08:00:00 | 3 | 3 | 3 | 3 | 3
09:00:00 | 2 | 2 | 2 | 2 | 2
10:00:00 | 2 | 2 | 2 | 2 | 2
11:00:00 | 2 | 2 | 2 | 2 | 2
12:00:00 | 1 | 1 | 1 | 1 | 1
13:00:00 | 2 | 2 | 2 | 2 | 2
14:00:00 | 2 | 2 | 2 | 2 | 2
15:00:00 | 2 | 2 | 2 | 2 | 2
16:00:00 | 2 | 2 | 2 | 2 | 2
17:00:00 | 2 | 2 | 2 | 2 | 2
18:00:00 | 3 | 3 | 3 | 2 | 3
19:00:00 | 2 | 2 | 2 | 2 | 2
20:00:00 | 1 | 1 | 1 | 1 | 1
No. of missed trips
381 missed trips
381 sched trips