One console forfourteen terminals
A single operations console replacing fourteen terminal spreadsheets, built so a shift handover takes six minutes instead of forty.
Measured afterwards
- 14
- Terminals consolidated
- 40min → 6min
- Shift handover
- 3,100
- Daily movements tracked
- 14
- Spreadsheets retired
The problem
Each terminal ran its own spreadsheet with its own column order. Head office rebuilt a national picture every morning by email. Shift handovers took forty minutes of reading notes, and a delayed container was often discovered by the customer first.
What we did
We modelled the domain with dispatchers from three terminals before writing any interface, which surfaced two conflicting definitions of "ready" that had been quietly causing the discrepancies. The console is a typed React application over a Postgres schema with per-terminal permissions and a full audit log. Live movements arrive over a websocket with an explicit stale indicator, so an operator always knows whether they are looking at current data. Handover is a generated document the outgoing shift annotates rather than writes.
What changed
All fourteen terminals moved across in eleven weeks, one terminal at a time, with the spreadsheets kept as read-only for a month. Handover dropped to six minutes, and the national picture is now the same screen everyone is already using.