Loading the shift.

Needs attention at --:--

Late trips first, then trips whose driver has gone quiet, then trips projected to miss their window.

StatusTripPickup windowWhat the check sawAlert

Make something go wrong

The change starts at the current shift time and stays in the replay until you undo it.

    Alerts sent to desks

      How the check decides

      On track
      The driver's latest ETA falls inside the pickup window.
      At risk
      The latest ETA is after the window closes, so the desk can act before the rider waits.
      Late
      The window has closed, the driver is still reporting, and hasn't arrived.
      No recent update
      Nothing from the driver for 15 minutes once the trip is under way. The check asks the desk to call instead of guessing, and never counts silence as late.

      Each trip gets at most one alert of each kind. A trip counts as on time when the driver arrives inside the window, not when the rider gets in.

      End-of-shift results

      Try your own files

      Two CSV files shaped like the samples. They're read in your browser and never uploaded. Please use made-up data and keep real rider details out of a demo.

      Templates: trips.csv and updates.csv (the sample shift)

      All trips at --:--

      StatusTripPickup windowWhat the check sawDriverDeskRide

      Rows the check rejected

      A bad row is listed and skipped, and the rest of the file still loads.