Report on timetable adherence

This report is designed to monitor the actual execution of the schedule on a selected bus line.
It compares the planned time of stop arrivals (according to the schedule matrix) with the actual time of stop visits and clearly shows how closely the real movement matched the plan.

What the report shows

The report is built for one selected bus line and is presented as a table where:
  • The first column — the name of the schedule.
  • Each next column — a stop on the route.
  • Each cell — data for a specific stop on a specific trip.
Each cell displays:
  • Plan — the planned arrival time at the stop.
  • Fact — the actual arrival time at the stop.
  • Diff — the deviation of the actual time from the planned one.
  • Vehicle — the vehicle (license plate) that actually performed the stop.
If no actual stop visit is recorded, the cell is marked as “Missed” (not executed).

How the report is generated

1. The system takes the selected bus line and the list of its stops
2. It loads the history of schedule versions that were active during the selected period
3. For each day within the reporting interval, it determines which schedule table should be applied:
  • by a specific date
  • by day of the week
  • or daily
    4. For each planned trip and each stop, the system searches for the closest actual visit to that stop
    5. If a matching event is found within the allowed deviation window — the cell shows Plan / Fact / Diff / Vehicle
    6. If no event is found — the cell is marked as “Missed”

Comparison logic

  • The report checks schedule compliance not by a specific bus, but by the actual execution of the stop on the line.
  • If several buses are operating on the line at the same time, the report counts any bus that actually performed the stop at the required time.
  • For each planned time, no more than one actual event is used.
  • One actual event is not reused to confirm several planned arrivals.
  • If the schedule changes within the reporting period, the system applies the version of the schedule that was active at the moment of the specific planned trip.

Color indication

  • Green — minimal deviation, the stop was performed very close to the plan.
  • Yellow — acceptable deviation from the schedule.
  • Orange — noticeable time deviation.
  • Red — large deviation or “Missed” (no actual stop visit recorded).