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

Patchbay's console: today's routes as a table with their states and a map beside it

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.

Patchbay's console: today's routes as a table with their states and a map beside it

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

Ready to ship?

Let’s build together.

From the first version to production, at a startup’s speed and with a senior engineer’s care. Tell me about your product.

2 builds open for December

Ready to ship?

Let’s build together.

From the first version to production, at a startup’s speed and with a senior engineer’s care. Tell me about your product.

2 builds open for December

Ready to ship?

Let’s build together.

From the first version to production, at a startup’s speed and with a senior engineer’s care. Tell me about your product.

2 builds open for December

Create a free website with Framer, the website builder loved by startups, designers and agencies.