Replacing a spreadsheet dispatch process with a real system
A fleet operator was allocating next-day deliveries across six shared spreadsheets. We replaced the process with a single dispatch dashboard.
Context
Every evening, two coordinators rebuilt the next day's delivery plan by hand across six shared spreadsheets. Edits overwrote each other, there was no history of who changed what, and a single mistake in a vehicle assignment was only discovered the following morning at the depot.
Approach
We mapped the existing process before writing any code, then built a single dispatch dashboard around it — vehicle and driver availability, drag-to-assign allocation, and a full audit trail. Roles were kept deliberately simple: coordinators assign, supervisors approve. We ran it in parallel with the spreadsheets for two weeks before switching over.
Outcome
Dispatch preparation dropped from roughly two and a half hours to twenty minutes. Because every change is attributed and timestamped, disputes about mis-assignments are now settled from the audit log instead of from memory. The team has run it without our involvement since handover.
