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

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
 | 442 | 15 |  |  | 2.05 | 2.13 |  |  |  | [NAME] | Bus arrived late for exchange
 | 504 | 19 | 2.09 | 2.12 | 2.21 | 2.23 | 0.03000000000000025 | Late | -0.02000000000000002 | J, Moore
 | 506 | 1 |  |  | 2.12 | 2.14 | 0 | On Time | -0.02000000000000002 | [NAME]
 | 434 | 14 |  |  | 2.2 | 2.22 | 0 | On Time | -0.02000000000000002 | [NAME]
 | 101 | 6 |  |  | 2.14 | 2.15 | 0 | On Time | -0.009999999999999787 | [NAME]
 | 117 | 18 | 2.2 | 2.18 | 2.3 | 2.33 | -0.02000000000000002 | On Time | -0.03000000000000025 | [NAME]
 | 115 | 15 |  |  | 2.18 | 2.19 | 0 | On Time | -0.009999999999999787 | [NAME]
 | 409 | 8 | 2.19 | 2.23 | 2.22 | 2.26 | 0.04000000000000004 | Late | -0.03999999999999959 | J.Lister
 | 119 | 9 | 2.25 | 2.23 | 2.37 | 2.47 | -0.02000000000000002 | On Time | -0.1000000000000001 | [NAME] | Not reason for being late
 | 104 | 7 | 2.26 | 2.27 | 2.31 | 2.31 | 0.01000000000000023 | Late | 0 | [NAME]
 | 610 | 12 | 2.29 | 2.28 | 2.32 | 2.32 | -0.01000000000000023 | On Time | 0 | [NAME]
 | 116 | 20 | 2.3 | 2.28 | 2.35 | 2.35 | -0.02000000000000002 | On Time | 0 | [NAME]
 | 103 | 11 | 2.35 | 2.31 | 2.4 | 2.38 | -0.04000000000000004 | On Time | 0.02000000000000002 | C.Larkins
 | 609 | 6 | 2.43 | 2.35 | 2.46 | 2.46 | -0.08000000000000007 | On Time | 0 | [NAME] | Using the rest-room
 | 604 | 2 | 2.27 | 2.35 | 2.39 | 2.39 | 0.08000000000000007 | Late | 0 | R. Beal
 | 606 | 12 | 2.56 | 2.54 | 2.56 | 2.56 | -0.02000000000000002 | On Time | 0 | [NAME] | [NAME] of Garage
 |  |  |  |  |  |  | 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
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
 |  |  |  |  |  |  | 0 | On Time | 0
Totals |  |  |  |  |  | Avg. % | -0.001020408163265303 | On Time | -0.2299999999999995
 |  |  |  |  | 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. % | -2.218278615794136e-05 | On Time | 0