Spreadsheet: 154438d1336424599-calculating-multiple-spread-sheets-using-1-formula-on-time-stats
Sheet: May-3

SPORTRAN-SCHEDULE ADHERENCE REPORT
CHECK POINT: |  | TERMINAL |  |  |  |  |  |  |  | DATE: | ____________________
 |  |  |  |  |  |  |  |  |  | SUPERVISOR: | ____________________
 |  |  |  |  |  |  |  |  |  | Last Name, First Initial
supervisor | Bus No. | Rt No. | [NAME] |  | Departure Time |  | Difference |  |  | Operator | Remarks
 |  |  | Scheduled | Actual | Scheduled | Actual | [NAME] |  | Departure
[NAME]
[NAME] | 601 | 1 | 3.27 | 3.25 | 3.42 | 3.46 |  |  |  | [NAME]
[NAME] | 610 | 12 | 3.47 | 3.45 | 3.5 | 3.52 | -0.02000000000000002 | On Time | -0.02000000000000002 | [NAME]
[NAME] | 502 | 3 |  |  | 3.5 | 3.58 | 0 | On Time | -0.08000000000000007 | [NAME] | TWO WHEEL CHAIRS
[NAME] | 112 | 18 |  |  | 4.13 | 4.14 | 0 | On Time | -0.009999999999999787 | [NAME]
[NAME] | 410 | 3 |  |  | 4.13 | 4.14 | 0 | On Time | -0.009999999999999787 | [NAME]
[NAME] | 437 | 1 |  |  | 4.45 | 4.47 | 0 | On Time | -0.01999999999999957 | [NAME] | 4.45 line-up
[NAME] | 608 | 2 |  |  | 4.45 | 4.47 | 0 | On Time | -0.01999999999999957 | [NAME] | 4.45 line-up
[NAME] | 431 | 3 |  |  | 4.45 | 4.47 | 0 | On Time | -0.01999999999999957 | [NAME] | 4.45 line-up
[NAME] | 410 | 3 | 5.03 | 5.05 | 5.15 | 5.17 | 0.01999999999999957 | Late | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 601 | 2 | 5.06 | 5.08 | 5.15 | 5.17 | 0.02000000000000046 | Late | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 114 | 8 | 5.1 | 5.08 | 5.15 | 5.17 | -0.01999999999999957 | On Time | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 101 | 6 | 5.1 | 5.08 | 5.15 | 5.17 | -0.01999999999999957 | On Time | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 435 | 7 | 5.1 | 5.1 | 5.15 | 5.17 | 0 | On Time | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 503 | 15 | 5.06 | 5.09 | 5.15 | 5.17 | 0.03000000000000025 | Late | -0.01999999999999957 | [NAME] | 5.15 line-up
[NAME] | 116 | 20 | 6.2 | 2.2 | 6.25 | 6.25 | -4 | On Time | 0 | [NAME]
[NAME] | 114 | 8 | 6.2 | 6.23 | 6.25 | 6.25 | 0.03000000000000025 | Late | 0 | [NAME]
[NAME] | 112 | 4 | 6.2 | 6.25 |  |  | 0.04999999999999982 | Late | 0 | [NAME] | [NAME] and [NAME]
[NAME] | 506 | 1 | 12.26 | 12.19 |  |  | -0.07000000000000028 | On Time | 0 | [NAME] | [NAME] and [NAME].
[NAME] | 112 | 4 | 12.23 | 12.25 |  |  | 0.01999999999999957 | Late | 0 | [NAME] | [NAME] and [NAME].
[NAME] | 607 | 4 | 12.32 | 12.31 |  |  | -0.009999999999999787 | On Time | 0 | [NAME]
[NAME] | 608 | 2 | 12.33 | 12.32 |  |  | -0.009999999999999787 | On Time | 0 | [NAME]
[NAME] | 439 | 11 | 12.48 | 1.02 |  |  | -11.46 | On Time | 0 | [NAME] | Bus Failure [NAME] and [NAME]
[NAME] | 103 | 11 | 1.28 | 1.26 |  |  | -0.02000000000000002 | On Time | 0 | [NAME] | Mansfield and 70th
[NAME] | 604 | 2 | 1.37 | 1.39 |  |  | 0.0199999999999998 | Late | 0 | R. Beal | Hollywood and Hearne
[NAME] | 506 | 1 | 1.36 | 1.35 |  |  | -0.01000000000000001 | On Time | 0 | [NAME]
[NAME] | 437 | 1 | 2.51 | 2.5 |  |  | -0.009999999999999787 | On Time | 0 | [NAME] | Milam and Alabama
[NAME] | 116 | 20 | 6.2 | 6.2 |  |  | 0 | On Time | 0 | [NAME] | Terminal
[NAME] | 112 | N-101 | 10.11 | 10.15 | 10.15 | 10.18 | 0.04000000000000092 | Late | -0.02999999999999936 | [NAME] | Bus Late Due To Heavy Traffic
[NAME] | 102 | N-102 | 10.03 | 10.13 |  |  | 0.1000000000000014 | Late | 0 | [NAME] | Late DepartureWaiting On Buses
[NAME] | 610 | N-301 | 10.03 | 10.14 |  |  | 0.1100000000000012 | Late | 0 | [NAME]
[NAME] | 117 | N-401 | 10.03 | 10.14 |  |  | 0.1100000000000012 | Late | 0 | [NAME]
[NAME] | 119 | N-501 | 10 | 10.08 |  |  | 0.08000000000000007 | Late | 0 | [NAME]
[NAME] | 112 | N-101 | 11.08 | 11.1 | 11.2 | 11.22 | 0.01999999999999957 | Late | -0.02000000000000135 | [NAME]
[NAME] | 102 | N-201 | 11.15 | 11.15 |  |  | 0 | On Time | 0 | [NAME]
[NAME] | 610 | N-301 | 11.15 | 11.19 |  |  | 0.03999999999999915 | Late | 0 | [NAME]
[NAME] | 117 | N-401 | 11.13 | 11.12 |  |  | -0.01000000000000156 | On Time | 0 | [NAME]
[NAME] | 119 | N-501 | 11.14 | 11.2 |  |  | 0.05999999999999872 | Late | 0 | [NAME]
[NAME] | 112 | N-101 | 12.2 | 12.18 | 12.25 | 12.25 | -0.01999999999999957 | On Time | 0 | [NAME]
[NAME] | 102 | N-201 | 12.2 | 12.2 |  |  | 0 | On Time | 0 | [NAME]
[NAME] | 610 | N-301 | 12.2 | 12.17 |  |  | -0.02999999999999936 | On Time | 0 | [NAME]
[NAME] | 117 | N-401 | 12.18 | 12.16 |  |  | -0.01999999999999957 | On Time | 0 | T.Devones
[NAME] | 119 | N-501 | 12.19 | 12.15 |  |  | -0.03999999999999915 | On Time | 0 | [NAME]
E.. Eddy | 405 | 8 | 8.34 | 8.36 |  |  | 0.01999999999999957 | Late | 0 | [NAME]
E.. Eddy | 114 | 8 | 8.45 | 8.5 |  |  | 0.05000000000000071 | Late | 0 | [NAME]
E.. Eddy | 409 | 4 | 2.12 | 2.15 |  |  | 0.0299999999999998 | Late | 0 | [NAME] | Linwood and Texas Ave.
E.. Eddy | 112 | 4 | 2.18 | 2.15 |  |  | -0.03000000000000025 | On Time | 0 | [NAME] | Linwood and Texas Ave.
E.. Eddy | 102 | 5 | 2.26 | 2.26 |  |  | 0 | On Time | 0 | [NAME] | Linwood and Texas Ave.
E.. Eddy | 115 | 5 | 2.29 | 2.32 |  |  | 0.0299999999999998 | Late | 0 | [NAME] | Linwood and Texas Ave.
 |  |  |  |  |  |  | 0 | On Time | 0
E.. Eddy | 112 | 4 | 2.38 | 2.38 |  |  | 0 | On Time | 0 | [NAME] | Linwood and Texas Ave.
Totals |  |  |  |  |  | Avg. % | -0.3044897959183673 | On Time | -0.3499999999999965
 |  |  |  |  | TERMINAL
Date | Bus No. | Rt No. | [NAME] |  | Departure Time |  | Difference |  |  | Operator | Remarks
 |  |  | Scheduled | Actual | Scheduled | Actual | [NAME] |  | Departure
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
Totals |  |  |  |  |  | Avg. % | 0 | On Time | 0