All work
Internal tools · 2025
Patchbay
The ops console of a delivery team
Routes, drivers and exceptions in one screen, replacing eleven spreadsheets and a group chat.
Client
Patchbay Logistics
Year
2025
Role
Internal tool, start to finish
Built in
8 days
Result
11 spreadsheets retired

The brief
A delivery company ran 42 routes a day from eleven spreadsheets and a group chat. Dispatchers learnt about a stuck van when a customer called. They needed one screen that knew before they did.
Cursor
Remix
Postgres
What I built
01
Every route on one screen
Drivers, stops and states, live, filtered by city or by trouble.
02
Exceptions that arrive first
A van stopped too long or a stop promised too late raises its hand before anyone calls.
03
Fixes in one click
Move stops between routes and the drivers' phones update at once.

The build, day by day
Day 1
A day in dispatch, watching how the spreadsheets were really used.
Days 2–3
The data from the drivers' app, cleaned and joined in Postgres.
Days 4–5
The console: the table, the map and the filters.
Days 6–7
Exceptions and the one-click moves, with the dispatchers testing live.
Day 8
Training, the spreadsheets archived, and cake.
brief.md
The prompt that did the most
›
Here are the eleven spreadsheets the team uses. Tell me what each column is for, which ones contradict each other, and the smallest schema that replaces all of them. Do not write code yet.
What it does now
11
spreadsheets retired
96%
of stops on time, from 88%
40 min
saved each day by every dispatcher
Clear plans, a demo every day and no surprises. It felt like hiring a whole team, without the meetings.

Tomás Brandt
COO, Patchbay
