Spreadsheet: 109588d1306410700-rearranging-data-for-further-analysis-example-of-route-1-
Sheet: Final(Step2)

Date | Duty | DOT Rout No | Trip | Contract | Bus | Driver | Sched Time | Book On Time | Schedule Distance |  | Non-Rev | Revenue | Passes | Tickets | Transfer | Total Psngrs
2011-01-05 00:00:00 | 501 | 01.303.05 | 0 | 1425 ZNT1175 | 7517 | 7567 | 14:25 | 13:26 | 36.8 | Operated | R91.31 | R294.00 | 12 | 35 | 0 | 47
2011-01-05 00:00:00 | 501 | 04.303.12 | 0 | 1130 ZNT1175 | 7517 | 7567 | 11:30 | 11:09 | 36.8 | Operated | R57.53 | R21.00 | 8 | 3 | 0 | 11
2011-01-05 00:00:00 | 501 | 06.303.18 | 0 | 0620 NS1175 | 7517 | 7567 | 06:20 | 5:56 | 42.6 | Operated | R119.73 | R113.00 | 17 | 13 | 1 | 31
2011-01-05 00:00:00 | 501 | 08.302.12 | 0 | 0350 NS1175 | 7517 | 7567 | 03:50 | 3:25 | 67.8 | Operated | R332.75 | R237.50 | 40 | 21 | 0 | 61
2011-02-05 00:00:00 | 501 | 06.303.18 | 0 | 0505 NS1175 | 0 | 0 | 05:05 | 0 | 42.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 501 | 14.302.12 | 0 | 0400 ZNT1175 | 7517 | 7567 | 04:00 | 3:21 | 36.6 | Operated | R389.29 | R168.00 | 48 | 15 | 2 | 65
2011-02-05 00:00:00 | 501 | 50.301.01 | 0 | 0600 ZNT1175 | 7503 | 7521 | 06:00 | 15:04 | 57.4 | Operated | R144.38 | [NAME] | 18 | 8 | 0 | 26
2011-02-05 00:00:00 | 501 | 50.301.01 | 0 | 0600 ZNT1175 | 7517 | 7567 | 06:00 | 5:47 | 57.4 | Operated | R94.07 | [NAME] | 13 | 0 | 2 | 15
2011-02-05 00:00:00 | 501 | 51.301.02 | 0 | 0945 ZNT1175 | 7517 | 7567 | 09:45 | 8:50 | 52.1 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 501 | 52.303.02 | 0 | 1150 ZNT1175 | 7517 | 7567 | 11:50 | 8:49 | 46.2 | Operated | R7.22 | R9.00 | 1 | 1 | 0 | 2
2011-03-05 00:00:00 | 501 | 06.303.18 | 0 | 0505 NS1175 | 0 | 0 | 05:05 | 0 | 42.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 501 | 14.302.12 | 0 | 0400 ZNT1175 | 0 | 0 | 04:00 | 0 | 36.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 501 | 50.301.01 | 0 | 0600 ZNT1175 | 0 | 0 | 06:00 | 0 | 57.4 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 501 | 51.301.02 | 0 | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 11:13 | 52.1 | Operated | R15.40 | R104.00 | 2 | 12 | 1 | 15
2011-03-05 00:00:00 | 501 | 52.303.02 | 0 | 1150 ZNT1175 | 0 | 0 | 11:50 | 0 | 46.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-04-05 00:00:00 | 501 | 06.303.18 | 0 | 0505 NS1175 | 0 | 0 | 05:05 | 0 | 42.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-04-05 00:00:00 | 501 | 14.302.12 | 0 | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:39 | 36.6 | Operated | R303.00 | R340.00 | 39 | 30 | 0 | 69
2011-04-05 00:00:00 | 501 | 50.301.01 | 0 | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 6:00 | 57.4 | Operated | R516.90 | R323.00 | 73 | 27 | 0 | 100
2011-04-05 00:00:00 | 501 | 51.301.02 | 0 | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:42 | 52.1 | Operated | R82.28 | R97.00 | 10 | 11 | 1 | 22
2011-04-05 00:00:00 | 501 | 52.303.02 | 0 | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:46 | 46.2 | Operated | R302.39 | R93.00 | 40 | 8 | 0 | 48
2011-05-05 00:00:00 | 501 | 06.303.18 | 0 | 0505 NS1175 | 0 | 0 | 05:05 | 0 | 42.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-05-05 00:00:00 | 501 | 14.302.12 | 0 | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:41 | 36.6 | Operated | R212.55 | R195.00 | 27 | 17 | 0 | 44
2011-05-05 00:00:00 | 501 | 50.301.01 | 0 | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:55 | 57.4 | Operated | R249.01 | R202.00 | 34 | 15 | 2 | 51
2011-05-05 00:00:00 | 501 | 51.301.02 | 0 | 0945 ZNT1175 | 7504 | 7515 | 09:45 | [NAME] | 52.1 | Operated | [NAME] | R124.00 | 26 | 14 | 3 | 43
2011-05-05 00:00:00 | 501 | 52.303.02 | 0 | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 9:50 | 46.2 | Operated | R258.34 | R106.00 | 34 | 9 | 1 | 44
2011-01-05 00:00:00 | 502 | 01.308.03 | 0 | 0620 ZNT1175 | 0 | 0 | 06:20 | 0 | 73.6 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 502 | 01.308.03 | 0 | 1415 ZNT1175 | 2002 | 7541 | 14:15 | 13:13 | 73.6 | Operated | R3.90 | [NAME] | 1 | 0 | 0 | 1
2011-01-05 00:00:00 | 502 | 02.308.16 | 0 | 0345 ZNT1175 | 0 | 0 | 03:45 | 0 | 65.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-01-05 00:00:00 | 502 | 02.308.16 | 0 | 1200 ZNT1175 | 0 | 0 | 12:00 | 0 | 65.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 01.301.04 | 0 | 1605 ZNT1175 | 0 | 0 | 16:05 | 0 | 45.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 04.303.12 | 0 | 0515 ZNT1175 | 0 | 0 | 05:15 | 0 | 36.8 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 06.301.16 | 0 | 1400 ZNT1175 | 0 | 0 | 14:00 | 0 | 50.9 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 06.399.01 | 0 | 0645 NS1175 | 0 | 0 | 06:45 | 0 | 37.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 12.303.04 | 0 | 0615 NS1175 | 0 | 0 | 06:15 | 0 | 16.3 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-02-05 00:00:00 | 502 | 53.302.01 | 0 | 1100 ZNT1175 | 0 | 0 | 11:00 | 0 | 74.7 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 502 | 01.301.04 | 0 | 1605 ZNT1175 | 0 | 0 | 16:05 | 0 | 45.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 502 | 04.303.12 | 0 | 0515 ZNT1175 | 9999 | 7502 | 05:15 | 5:00 | 36.8 | Operated | [NAME] | R203.00 | 66 | 21 | 0 | 87
2011-03-05 00:00:00 | 502 | 06.301.16 | 0 | 1400 ZNT1175 | 9999 | 7502 | 14:00 | 13:55 | 50.9 | Operated | R269.16 | R252.00 | 40 | 27 | 0 | 67
2011-03-05 00:00:00 | 502 | 06.399.01 | 0 | 0645 NS1175 | 9999 | 7502 | 06:45 | 6:54 | 37.2 | Operated | R120.49 | [NAME] | 18 | 26 | 0 | 44
2011-03-05 00:00:00 | 502 | 12.303.04 | 0 | 0615 NS1175 | 9999 | 7502 | 06:15 | 6:15 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
2011-03-05 00:00:00 | 502 | 53.302.01 | 0 | 1100 ZNT1175 | 9999 | 7502 | 11:00 | 11:00 | 74.7 | Operated | R614.36 | R298.00 | 86 | 30 | 6 | 122
2011-04-05 00:00:00 | 502 | 01.301.04 | 0 | 1605 ZNT1175 | 0 | 0 | 16:05 | 0 | 45.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-04-05 00:00:00 | 502 | 04.303.12 | 0 | 0515 ZNT1175 | 9999 | 7502 | 05:15 | 4:56 | 36.8 | Operated | R543.63 | R152.00 | 76 | 14 | 0 | 90
2011-04-05 00:00:00 | 502 | 06.301.16 | 0 | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 11:01 | 50.9 | Operated | R360.68 | R244.00 | 54 | 29 | 0 | 83
2011-04-05 00:00:00 | 502 | 06.399.01 | 0 | 0645 NS1175 | 9999 | 7502 | 06:45 | 6:57 | 37.2 | Operated | R150.19 | R225.00 | 22 | 26 | 0 | 48
2011-04-05 00:00:00 | 502 | 12.303.04 | 0 | 0615 NS1175 | 9999 | 7502 | 06:15 | 6:20 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
2011-04-05 00:00:00 | 502 | 53.302.01 | 0 | 1100 ZNT1175 | 7524 | 7502 | 11:00 | 11:18 | 74.7 | Operated | R767.14 | R321.00 | 108 | 34 | 10 | 152
2011-05-05 00:00:00 | 502 | 01.301.04 | 0 | 1605 ZNT1175 | 0 | 0 | 16:05 | 0 | 45.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-05-05 00:00:00 | 502 | 04.303.12 | 0 | 0515 ZNT1175 | 7524 | 7502 | 05:15 | 5:07 | 36.8 | Operated | R553.96 | [NAME] | 78 | 11 | 0 | 89
2011-05-05 00:00:00 | 502 | 06.301.16 | 0 | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 11:02 | 50.9 | Operated | [NAME] | R45.00 | 9 | 3 | 0 | 12
2011-05-05 00:00:00 | 502 | 06.399.01 | 0 | 0645 NS1175 | 7524 | 7502 | 06:45 | 6:57 | 37.2 | Operated | R300.06 | R228.00 | 43 | 29 | 0 | 72
2011-05-05 00:00:00 | 502 | 12.303.04 | 0 | 0615 NS1175 | 7524 | 7502 | 06:15 | 6:18 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 1 | 1
2011-05-05 00:00:00 | 502 | 53.302.01 | 0 | 1100 ZNT1175 | 7524 | 7502 | 11:00 | 11:02 | 74.7 | Operated | R1,126.30 | [NAME] | 188 | 49 | 16 | 253
2011-06-05 00:00:00 | 502 | 01.301.04 | 0 | 1605 ZNT1175 | 0 | 0 | 16:05 | 0 | 45.2 | Scheduled, Not Operated | 0 | 0 | 0 | 0 | 0 | 0
2011-06-05 00:00:00 | 502 | 04.303.12 | 0 | 0515 ZNT1175 | 7524 | 7502 | 05:15 | 5:00 | 36.8 | Operated | R591.39 | R263.00 | 80 | 26 | 2 | 108
2011-06-05 00:00:00 | 502 | 06.301.16 | 0 | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 14:00 | 50.9 | Operated | R184.15 | R511.50 | 31 | 48 | 1 | 80
2011-06-05 00:00:00 | 502 | 06.399.01 | 0 | 0645 NS1175 | 7524 | 7502 | 06:45 | 7:00 | 37.2 | Operated | R219.22 | R117.00 | 30 | 15 | 0 | 45