One console forfourteen terminals

Client
Dockline Logistics
Sector
Freight and logistics
Delivered
Span 03 — Dockline Logistics

In one paragraph

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.

Built with

TypeScriptReactNode.jsPostgresRedisPlaywrightDocker