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

SPORTRAN-SCHEDULE ADHERENCE REPORT
CHECK POINT: |  | TERMINAL |  |  |  |  |  |  |  | DATE: | ____________________
 |  |  |  |  |  |  |  |  |  | SUPERVISOR: | ____________________
 |  |  |  |  |  |  |  |  |  | Last Name, First Initial
Date | Bus No. | Rt No. | [NAME] |  | Departure Time |  | Difference |  |  | Operator | Remarks
 |  |  | Scheduled | Actual | Scheduled | Actual | [NAME] |  | Departure
 |  |  |  |  |  |  | [NAME] |  | Departure
[NAME] | 438 | 1 | 6.1 | 6.05 | 6.13 | 6.15 | -0.04999999999999982 | Late | -0.02000000000000046 | [NAME]
[NAME] | 608 | 2 | 6.05 | 6.03 | 6.1 | 6.1 | -0.01999999999999957 | Late | 0 | [NAME]
[NAME] | 611 | 12 |  |  | 6.08 | 6.1 | 0 | Late | -0.01999999999999957 | [NAME]
[NAME] | 115 | 5 | 5.55 | 5.57 | 6.05 | 6.08 | 0.02000000000000046 | On Time | -0.03000000000000025 | [NAME]
[NAME] | 607 | 4 |  |  | 6.05 | 6.07 | 0 | Late | -0.02000000000000046 | [NAME]
[NAME] | 431 | 3 | 6 | 5.58 | 6.05 | 6.07 | 0.02 | On Time | -0.02000000000000046 | [NAME]
[NAME] | 101 | 6 | 6.09 | 6.07 | 6.12 | 6.12 | -0.01999999999999957 | Late | 0 | [NAME]
[NAME] | 503 | 15 | 6.11 | 6.1 | 6.16 | 6.16 | -0.01000000000000068 | Late | 0 | [NAME]
[NAME] | 440 | 11 | 6.15 | 6.16 | 6.2 | 6.21 | 0.009999999999999787 | On Time | -0.009999999999999787 | [NAME]
[NAME] | 116 | 20 | 6.2 | 6.21 | 6.25 | 6.26 | 0.009999999999999787 | On Time | -0.009999999999999787 | [NAME]
[NAME] | 114 | 8 | 6.2 | 6.21 | 6.25 | 6.25 | 0.009999999999999787 | On Time | 0 | [NAME]
[NAME] | 439 | 11 | 6.34 | 6.35 |  |  | 0.009999999999999787 | On Time | 0 | [NAME]
[NAME] | 507 | 4 | 6.5 | 6.5 | 7 | 7.02 | 0 | Late | -0.01999999999999957 | [NAME] | 7.00 pm Line- up
[NAME] | 602 | 5 | 6.55 | 6.56 | 7 | 7.02 | 0.009999999999999787 | On Time | -0.01999999999999957 | J. Putters | 7.00 pm Line- up
[NAME] | 104 | 7 | 6.54 | 6.55 | 7 | 7.02 | 0.009999999999999787 | On Time | -0.01999999999999957 | [NAME] | 7.00 pm Line- up
[NAME] | 606 | 12 | 6.55 | 6.53 | 7 | 7.02 | -0.01999999999999957 | Late | -0.01999999999999957 | [NAME] | 7.00 pm Line- up
[NAME] | 111 | 18 | 6.41 | 6.44 |  |  | 0.03000000000000025 | On Time | 0 | [NAME] | To Garage
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
 |  |  |  |  |  |  | 0 | Late | 0
Totals |  |  |  |  |  | Avg. % | 0.0002000000000000043 | Late | -0.004199999999999982
 |  |  |  |  | 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 | #N/A