Spreadsheet: 110043d1306842508-rearranging-data-for-further-analysis-mk3_dot_sub_route_1175-data-adjusted
Sheet: MK3

Route | DOT Rout No | Trip | Contract | Bus | Driver | Sched | Book On | Schedule |  | Non-Rev | Revenue | Passes | Tickets | Transfer | Total
 |  |  |  |  |  | Time | Time | Distance | Exception |  |  |  |  |  | Psngrs
Duty: | 501 |  |  |  |  |  | Date: | 5/1/2011
0303 | 01.303.05 |  | 1425 ZNT1175 | 7517 | 7567 | 14:25 | 13:26 | 36.8 | Operated | R91.31 | R294.00 | 12 | 35 | 0 | 47
0303 | 04.303.12 |  | 1130 ZNT1175 | 7517 | 7567 | 11:30 | 11:09 | 36.8 | Operated | R57.53 | R21.00 | 8 | 3 | 0 | 11
0303 | 06.303.18 |  | 0620 NS1175 | 7517 | 7567 | 06:20 | 5:56 | 42.6 | Operated | R119.73 | R113.00 | 17 | 13 | 1 | 31
0302 | 08.302.12 |  | 0350 NS1175 | 7517 | 7567 | 03:50 | 3:25 | 67.8 | Operated | R332.75 | R237.50 | 40 | 21 | 0 | 61
Duty: | 501 |  |  |  |  |  | Date: | 5/2/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7517 | 7567 | 04:00 | 3:21 | 36.6 | Operated | R389.29 | R168.00 | 48 | 15 | 2 | 65
0301 | 50.301.01 |  | 0600 ZNT1175 | 7503 | 7521 | 06:00 | 15:04 | 57.4 | Operated | R144.38 | [NAME] | 18 | 8 | 0 | 26
0301 | 50.301.01 |  | 0600 ZNT1175 | 7517 | 7567 | 06:00 | 5:47 | 57.4 | Operated | R94.07 | [NAME] | 13 | 0 | 2 | 15
0301 | 51.301.02 |  | 0945 ZNT1175 | 7517 | 7567 | 09:45 | 8:50 | 52.1 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
0303 | 52.303.02 |  | 1150 ZNT1175 | 7517 | 7567 | 11:50 | 8:49 | 46.2 | Operated | R7.22 | R9.00 | 1 | 1 | 0 | 2
Duty: | 501 |  |  |  |  |  | Date: | 5/3/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 |  |  | 04:00 |  | 36.6 | Scheduled, Not Operated
0301 | 50.301.01 |  | 0600 ZNT1175 |  |  | 06:00 |  | 57.4 | Scheduled, Not Operated
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 11:13 | 52.1 | Operated | R15.40 | R104.00 | 2 | 12 | 1 | 15
0303 | 52.303.02 |  | 1150 ZNT1175 |  |  | 11:50 |  | 46.2 | Scheduled, Not Operated
Duty: | 501 |  |  |  |  |  | Date: | 5/4/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:39 | 36.6 | Operated | R303.00 | R340.00 | 39 | 30 | 0 | 69
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 6:00 | 57.4 | Operated | R516.90 | R323.00 | 73 | 27 | 0 | 100
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:42 | 52.1 | Operated | R82.28 | R97.00 | 10 | 11 | 1 | 22
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:46 | 46.2 | Operated | R302.39 | R93.00 | 40 | 8 | 0 | 48
Duty: | 501 |  |  |  |  |  | Date: | 5/5/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:41 | 36.6 | Operated | R212.55 | R195.00 | 27 | 17 | 0 | 44
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:55 | 57.4 | Operated | R249.01 | R202.00 | 34 | 15 | 2 | 51
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | [NAME] | 52.1 | Operated | [NAME] | R124.00 | 26 | 14 | 3 | 43
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 9:50 | 46.2 | Operated | R258.34 | R106.00 | 34 | 9 | 1 | 44
Duty: | 501 |  |  |  |  |  | Date: | 5/6/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:45 | 36.6 | Operated | R249.07 | R307.00 | 32 | 26 | 0 | 58
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:51 | 57.4 | Operated | R455.67 | R229.50 | 61 | 18 | 0 | 79
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:54 | 52.1 | Operated | R108.18 | R190.00 | 14 | 16 | 1 | 31
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:57 | 46.2 | Operated | R255.42 | R110.00 | 32 | 11 | 1 | 44
Duty: | 501 |  |  |  |  |  | Date: | 5/7/2011
0302 | 05.302.01 |  | 0745 ZNT1175 |  |  | 07:45 |  | 57.7 | Scheduled, Not Operated
0302 | 05.302.01 |  | 1400 ZNT1175 |  |  | 14:00 |  | 57.7 | Scheduled, Not Operated
0302 | 08.302.12 |  | 0545 ZNT1175 |  |  | 05:45 |  | 67.8 | Scheduled, Not Operated
0302 | 16.302.02 |  | 0920 ZNT1175 |  |  | 09:20 |  | 57.7 | Scheduled, Not Operated
Duty: | 501 |  |  |  |  |  | Date: | 5/8/2011
0303 | 01.303.05 |  | 1425 ZNT1175 | 7509 | 7503 | 14:25 | 13:31 | 36.8 | Operated | R16.80 | R110.00 | 21 | 16 | 0 | 37
0303 | 04.303.12 |  | 1130 ZNT1175 |  |  | 11:30 |  | 36.8 | Scheduled, Not Operated
0303 | 06.303.18 |  | 0620 NS1175 |  |  | 06:20 |  | 42.6 | Scheduled, Not Operated
0302 | 08.302.12 |  | 0350 NS1175 |  |  | 03:50 |  | 67.8 | Scheduled, Not Operated
Duty: | 501 |  |  |  |  |  | Date: | 5/9/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:49 | 36.6 | Operated | R331.39 | R298.00 | 43 | 27 | 0 | 70
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:58 | 57.4 | Operated | R242.92 | R226.00 | 34 | 18 | 1 | 53
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:43 | 52.1 | Operated | R83.09 | R175.00 | 10 | 12 | 3 | 25
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:48 | 46.2 | Operated | R284.36 | R59.00 | 34 | 5 | 0 | 39
Duty: | 501 |  |  |  |  |  | Date: | 5/10/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:45 | 36.6 | Operated | R309.74 | [NAME] | 40 | 17 | 0 | 57
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:58 | 57.4 | Operated | R596.93 | R218.00 | 87 | 23 | 2 | 112
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:44 | 52.1 | Operated | R73.19 | R97.00 | 9 | 11 | 2 | 22
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:48 | 46.2 | Operated | R285.52 | R36.00 | 35 | 4 | 1 | 40
Duty: | 501 |  |  |  |  |  | Date: | 5/11/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:45 | 36.6 | Operated | R350.47 | R192.00 | 46 | 17 | 0 | 63
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:54 | 57.4 | Operated | R439.00 | R244.00 | 61 | 23 | 0 | 84
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:45 | 52.1 | Operated | R41.52 | R40.00 | 6 | 5 | 1 | 12
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:47 | 46.2 | Operated | R248.58 | R68.00 | 32 | 6 | 0 | 38
Duty: | 501 |  |  |  |  |  | Date: | 5/12/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:46 | 36.6 | Operated | R334.91 | R197.00 | 43 | 17 | 0 | 60
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:52 | 57.4 | Operated | R538.46 | R206.00 | 78 | 17 | 1 | 96
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:42 | 52.1 | Operated | R128.90 | R155.00 | 17 | 14 | 1 | 32
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:48 | 46.2 | Operated | R224.71 | R44.00 | 29 | 4 | 0 | 33
Duty: | 501 |  |  |  |  |  | Date: | 5/13/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:44 | 36.6 | Operated | R362.45 | [NAME] | 46 | 24 | 0 | 70
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:54 | 57.4 | Operated | R498.92 | [NAME] | 74 | 28 | 0 | 102
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:43 | 52.1 | Operated | R74.64 | R47.00 | 10 | 4 | 1 | 15
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:49 | 46.2 | Operated | R270.77 | R78.00 | 34 | 6 | 0 | 40
Duty: | 501 |  |  |  |  |  | Date: | 5/14/2011
0302 | 05.302.01 |  | 0745 ZNT1175 | 9999 | 7547 | 07:45 | 8:37 | 57.7 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
0302 | 05.302.01 |  | 1400 ZNT1175 | 9999 | 7547 | 14:00 | 12:24 | 57.7 | Operated | R211.60 | R15.00 | 28 | 2 | 0 | 30
0302 | 05.302.01 |  | 1400 ZNT1175 | 7513 | 7565 | 14:00 | 13:29 | 57.7 | Operated | R5.60 | R79.00 | 19 | 7 | 0 | 26
0302 | 08.302.12 |  | 0545 ZNT1175 | 9999 | 7547 | 05:45 | 5:42 | 67.8 | Operated | R399.93 | R146.00 | 52 | 16 | 0 | 68
0302 | 16.302.02 |  | 0920 ZNT1175 | 9999 | 7547 | 09:20 | 9:18 | 57.7 | Operated | R117.98 | R169.50 | 16 | 14 | 0 | 30
Duty: | 501 |  |  |  |  |  | Date: | 5/15/2011
0303 | 01.303.05 |  | 1425 ZNT1175 | 7517 | 7545 | 14:25 | 11:39 | 36.8 | Operated | R280.60 | [NAME] | 37 | 21 | 0 | 58
0303 | 04.303.12 |  | 1130 ZNT1175 | 7517 | 7545 | 11:30 | 11:39 | 36.8 | Operated | R93.29 | R20.00 | 12 | 2 | 0 | 14
0303 | 06.303.18 |  | 0620 NS1175 | 7517 | 7545 | 06:20 | 5:40 | 42.6 | Operated | R210.99 | R53.00 | 28 | 6 | 0 | 34
0302 | 08.302.12 |  | 0350 NS1175 | 7517 | 7545 | 03:50 | 3:35 | 67.8 | Operated | R631.41 | R296.00 | 78 | 24 | 0 | 102
Duty: | 501 |  |  |  |  |  | Date: | 5/16/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:45 | 36.6 | Operated | R347.10 | R195.00 | 45 | 17 | 0 | 62
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:53 | 57.4 | Operated | R413.91 | R327.50 | 62 | 33 | 0 | 95
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:46 | 52.1 | Operated | R74.30 | R69.00 | 9 | 6 | 0 | 15
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:49 | 46.2 | Operated | R259.44 | R32.00 | 33 | 3 | 1 | 37
Duty: | 501 |  |  |  |  |  | Date: | 5/17/2011
0303 | 06.303.18 |  | 0505 NS1175 |  |  | 05:05 |  | 42.6 | Scheduled, Not Operated
0302 | 14.302.12 |  | 0400 ZNT1175 | 7504 | 7515 | 04:00 | 3:43 | 36.6 | Operated | R243.81 | [NAME] | 31 | 19 | 0 | 50
0301 | 50.301.01 |  | 0600 ZNT1175 | 7504 | 7515 | 06:00 | 5:52 | 57.4 | Operated | R302.13 | R163.00 | 45 | 13 | 3 | 61
0301 | 51.301.02 |  | 0945 ZNT1175 | 7504 | 7515 | 09:45 | 9:44 | 52.1 | Operated | R95.90 | R97.00 | 13 | 8 | 2 | 23
0303 | 52.303.02 |  | 1150 ZNT1175 | 7504 | 7515 | 11:50 | 11:44 | 46.2 | Operated | R326.38 | R29.00 | 43 | 3 | 0 | 46