Lattice OS.
An operations dashboard that ate a dozen spreadsheets and a nightly copy-paste ritual. We embedded with Lattice Labs' ops team and handed thirty-eight hours a week back to people instead of process.
Client
Lattice Labs
Year
2024 · Ongoing retainer
Services
Automation, Internal Tooling, Co-development
Stack
TypeScript, Postgres, Temporal, React
Run by spreadsheet, held together by hope.
Lattice Labs' operations lived in a dozen spreadsheets and one heroic analyst who ran a nightly copy-paste ritual to keep them in sync. It worked, until she took a holiday — and then it very visibly didn't.
They needed the knowledge out of the spreadsheets and into a system, without freezing the business for a six-month rebuild.
Automate the boring, surface the signal.
We embedded with the ops team for the first two weeks and did nothing but watch. The goal was to find the rituals — the recurring, rule-shaped work that a human was doing only because no system existed to do it.
Then we replaced those rituals one at a time with durable workflows, and put a single dashboard on top so the team could see state instead of reconstructing it every morning.
What we automated first.
- The nightly sync. A reliable workflow replaced the copy-paste ritual entirely.
- The exceptions. Edge cases now surface as alerts, not as a 9am scavenger hunt.
- The reporting. Weekly numbers assemble themselves; nobody rebuilds a deck by hand.
Thirty-eight hours, every week.
Within a quarter the team had clawed back thirty-eight hours a week of manual work, retired twelve spreadsheets, and eliminated the nightly export entirely. The analyst now works on the business instead of babysitting it.
We stay on retainer to extend the system as the operation grows — new workflows ship in days, not quarters.
38h
of manual work removed per week
12
spreadsheets retired
0
nightly exports remaining
We went from praying nobody got sick to not thinking about ops at all. That is the highest compliment I can pay a piece of software.— Head of Operations, Lattice Labs