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

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
 | 605 | 12 |  |  | 2.56 | 2.59 |  |  |  | [NAME]
 | 608 | 2 | 3 | 3 | 3.12 | 3.14 | 0 | On Time | -0.02000000000000002 | M. London
 | 406 | 11 | 3 | 3.01 | 3.05 | 3.06 | 0.009999999999999787 | Late | -0.01000000000000023 | [NAME]
 | 105 | 7 | 2.57 | 2.55 | 3 | 3.01 | -0.02000000000000002 | On Time | -0.009999999999999787 | [NAME]
 | 101 | 6 | 3.06 | 3.04 | 3.09 | 3.09 | -0.02000000000000002 | On Time | 0 | [NAME]
 | 603 | 1 | 3.06 | 3.05 | 3.15 | 3.16 | -0.01000000000000023 | On Time | -0.01000000000000023 | [NAME]
 | 431 | 3 | 3.06 | 3.06 | 3.06 | 3.08 | 0 | On Time | -0.02000000000000002 | [NAME]
 | 602 | 5 | 2.57 | 2.59 | 3.13 | 3.13 | 0.02000000000000002 | Late | 0 | [NAME]
 | 611 | 12 | 3.15 | 3.16 | 3.2 | 3.21 | 0.01000000000000023 | Late | -0.009999999999999787 | E. Tyree
 | 437 | 19 | 3.14 | 3.17 | 3.19 | 3.21 | 0.0299999999999998 | Late | -0.02000000000000002 | [NAME]
 | 505 | 9 | 3.04 | 3.06 | 3.18 | 3.2 | 0.02000000000000002 | Late | -0.02000000000000002 | [NAME]
 | 433 | 8 | 3.28 | 3.25 | 3.35 | 3.35 | -0.0299999999999998 | On Time | 0 | [NAME]
 | 434 | 18 | 3.2 | 3.25 | 3.4 | 3.41 | 0.04999999999999982 | Late | -0.01000000000000023 | [NAME]
 | 506 | 2 | 3.27 | 3.33 | 3.42 | 3.44 | 0.06000000000000005 | Late | -0.02000000000000002 | D. Frazier
 | 104 | 7 | 3.33 | 3.33 | 3.37 | 3.38 | 0 | On Time | -0.009999999999999787 | [NAME]
 | 502 | 3 | 3.35 | 3.36 | 3.5 | 3.52 | 0.009999999999999787 | Late | -0.02000000000000002 | [NAME]
 | 442 | 1 | 3.33 | 3.35 | 3.45 | 3.45 | 0.02000000000000002 | Late | 0 | [NAME]
 | 112 | 4 | 3.42 | 3.39 | 3.54 | 3.55 | -0.0299999999999998 | On Time | -0.009999999999999787 | [NAME]
 | 410 | 11 | 3.25 | 3.45 | 3.3 | 3.56 | 0.2000000000000002 | Late | -0.2600000000000002 | [NAME] | Late due to breakdown
 | 116 | 20 | 3.45 | 3.42 | 4 | 4.01 | -0.03000000000000025 | On Time | -0.009999999999999787 | [NAME]
 | 114 | 8 | 3.59 | 3.57 | 4.01 | 4.04 | -0.02000000000000002 | On Time | -0.03000000000000025 | [NAME]
 |  |  |  |  |  |  | 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.005510204081632645 | Late | -0.01
 |  |  |  |  | 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