Spreadsheet: 109873d1306693375-rearranging-data-for-further-analysis-1176-data-john
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
 |  | Day Total: |  |  |  |  |  | 184 |  | R601.32 | R665.50 | 77 | 72 | 1 | 150
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
 |  | Day Total: |  |  |  |  |  | 292.3 |  | [NAME] | R298.00 | 80 | 24 | 4 | 108
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
 |  | Day Total: |  |  |  |  |  | 234.9 |  | R15.40 | R104.00 | 2 | 12 | 1 | 15
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
 |  | Day Total: |  |  |  |  |  | 234.9 |  | R1,204.57 | [NAME] | 162 | 76 | 1 | 239
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
 |  | Day Total: |  |  |  |  |  | 234.9 |  | R898.61 | R627.00 | 121 | 55 | 6 | 182
Duty: | 501 |  |  |  |  |  | Date: | 5/6/2011
 | Printed on: 5/25/2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 1 of 85
MK3 - Dot Sub Route Number - Full Duty Scheduled vs Wor
Route | DOT Rout No | Trip | Contract | Bus | Driver | Sched | Book On | Schedule | Exception | Non-Rev | Revenue | Passes | Tickets | Transfer | Total
 |  |  |  |  |  | Time | Time | Distance |  |  |  |  |  |  | Psngrs
Duty: | 502 |  |  |  |  |  | Date: | 5/1/2011
0308 | 01.308.03 |  | 0620 ZNT1175 |  |  | 06:20 |  | 73.6 | Scheduled, Not Operated
0308 | 01.308.03 |  | 1415 ZNT1175 | 2002 | 7541 | 14:15 | 13:13 | 73.6 | Operated | R3.90 | [NAME] | 1 | 0 | 0 | 1
0308 | 02.308.16 |  | 0345 ZNT1175 |  |  | 03:45 |  | 65.2 | Scheduled, Not Operated
0308 | 02.308.16 |  | 1200 ZNT1175 |  |  | 12:00 |  | 65.2 | Scheduled, Not Operated
 |  | Day Total: |  |  |  |  |  | 277.6 |  | R3.90 | [NAME] | 1 | 0 | 0 | 1
Duty: | 502 |  |  |  |  |  | Date: | 5/2/2011
0301 | 01.301.04 |  | 1605 ZNT1175 |  |  | 16:05 |  | 45.2 | Scheduled, Not Operated
0303 | 04.303.12 |  | 0515 ZNT1175 |  |  | 05:15 |  | 36.8 | Scheduled, Not Operated
0301 | 06.301.16 |  | 1400 ZNT1175 |  |  | 14:00 |  | 50.9 | Scheduled, Not Operated
0399 | 06.399.01 |  | 0645 NS1175 |  |  | 06:45 |  | 37.2 | Scheduled, Not Operated
0303 | 12.303.04 |  | 0615 NS1175 |  |  | 06:15 |  | 16.3 | Scheduled, Not Operated
0302 | 53.302.01 |  | 1100 ZNT1175 |  |  | 11:00 |  | 74.7 | Scheduled, Not Operated
 |  | Day Total: |  |  |  |  |  | 261.1
Duty: | 502 |  |  |  |  |  | Date: | 5/3/2011
0301 | 01.301.04 |  | 1605 ZNT1175 |  |  | 16:05 |  | 45.2 | Scheduled, Not Operated
0303 | 04.303.12 |  | 0515 ZNT1175 | 9999 | 7502 | 05:15 | 5:00 | 36.8 | Operated | [NAME] | R203.00 | 66 | 21 | 0 | 87
0301 | 06.301.16 |  | 1400 ZNT1175 | 9999 | 7502 | 14:00 | 13:55 | 50.9 | Operated | R269.16 | R252.00 | 40 | 27 | 0 | 67
0399 | 06.399.01 |  | 0645 NS1175 | 9999 | 7502 | 06:45 | 6:54 | 37.2 | Operated | R120.49 | [NAME] | 18 | 26 | 0 | 44
0303 | 12.303.04 |  | 0615 NS1175 | 9999 | 7502 | 06:15 | 6:15 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
0302 | 53.302.01 |  | 1100 ZNT1175 | 9999 | 7502 | 11:00 | 11:00 | 74.7 | Operated | R614.36 | R298.00 | 86 | 30 | 6 | 122
 |  | Day Total: |  |  |  |  |  | 261.1 |  | R1,484.65 | R1,011.00 | 210 | 104 | 6 | 320
Duty: | 502 |  |  |  |  |  | Date: | 5/4/2011
0301 | 01.301.04 |  | 1605 ZNT1175 |  |  | 16:05 |  | 45.2 | Scheduled, Not Operated
0303 | 04.303.12 |  | 0515 ZNT1175 | 9999 | 7502 | 05:15 | 4:56 | 36.8 | Operated | R543.63 | R152.00 | 76 | 14 | 0 | 90
0301 | 06.301.16 |  | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 11:01 | 50.9 | Operated | R360.68 | R244.00 | 54 | 29 | 0 | 83
0399 | 06.399.01 |  | 0645 NS1175 | 9999 | 7502 | 06:45 | 6:57 | 37.2 | Operated | R150.19 | R225.00 | 22 | 26 | 0 | 48
0303 | 12.303.04 |  | 0615 NS1175 | 9999 | 7502 | 06:15 | 6:20 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 0 | 0
0302 | 53.302.01 |  | 1100 ZNT1175 | 7524 | 7502 | 11:00 | 11:18 | 74.7 | Operated | R767.14 | R321.00 | 108 | 34 | 10 | 152
 |  | Day Total: |  |  |  |  |  | 261.1 |  | R1,821.64 | R942.00 | 260 | 103 | 10 | 373
Duty: | 502 |  |  |  |  |  | Date: | 5/5/2011
0301 | 01.301.04 |  | 1605 ZNT1175 |  |  | 16:05 |  | 45.2 | Scheduled, Not Operated
0303 | 04.303.12 |  | 0515 ZNT1175 | 7524 | 7502 | 05:15 | 5:07 | 36.8 | Operated | R553.96 | [NAME] | 78 | 11 | 0 | 89
0301 | 06.301.16 |  | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 11:02 | 50.9 | Operated | [NAME] | R45.00 | 9 | 3 | 0 | 12
0399 | 06.399.01 |  | 0645 NS1175 | 7524 | 7502 | 06:45 | 6:57 | 37.2 | Operated | R300.06 | R228.00 | 43 | 29 | 0 | 72
0303 | 12.303.04 |  | 0615 NS1175 | 7524 | 7502 | 06:15 | 6:18 | 16.3 | Operated | [NAME] | [NAME] | 0 | 0 | 1 | 1
0302 | 53.302.01 |  | 1100 ZNT1175 | 7524 | 7502 | 11:00 | 11:02 | 74.7 | Operated | R1,126.30 | [NAME] | 188 | 49 | 16 | 253
 |  | Day Total: |  |  |  |  |  | 261.1 |  | R2,038.06 | R842.00 | 318 | 92 | 17 | 427
Duty: | 502 |  |  |  |  |  | Date: | 5/6/2011
0301 | 01.301.04 |  | 1605 ZNT1175 |  |  | 16:05 |  | 45.2 | Scheduled, Not Operated
0303 | 04.303.12 |  | 0515 ZNT1175 | 7524 | 7502 | 05:15 | 5:00 | 36.8 | Operated | R591.39 | R263.00 | 80 | 26 | 2 | 108
0301 | 06.301.16 |  | 1400 ZNT1175 | 7524 | 7502 | 14:00 | 14:00 | 50.9 | Operated | R184.15 | R511.50 | 31 | 48 | 1 | 80
0399 | 06.399.01 |  | 0645 NS1175 | 7524 | 7502 | 06:45 | 7:00 | 37.2 | Operated | R219.22 | R117.00 | 30 | 15 | 0 | 45
 | Printed on: 5/25/2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 5 of 85