Case study
A Spanish biobank
From PowerPoint to a guided, auditable lab.
A biobank kept each project in its own Excel file and ran protocols off a printed PowerPoint, then assembled the final documentation by hand. I built a desktop app that centralizes patients, projects, and samples, guides every protocol step by step, and generates the final document automatically. Offline: patient data never leaves the lab.
The problem
One Excel per project and a printed PowerPoint.
Each project lived in its own Excel file. If a patient took part in several projects, there was no way to know: you opened one spreadsheet after another, looking for them by hand.
Protocols were a PowerPoint deck the team created, printed, and followed on paper during the procedure.
And the final document was assembled by hand, pulling data from scattered sources: notes handwritten during each run, each project's spreadsheets, and the patient's data. Plenty of friction, a risk of skipped steps, and inconsistent records.
The solution
A guided, step-by-step protocol runner.
I built a desktop app, for macOS and Windows, around a simple idea: turn each protocol into a reusable template and guide its execution the way a Thermomix would.
- Projects, patients, and samples in one place: a patient is the same across all their projects, no digging through separate spreadsheets.
- Protocol templates with ordered steps, instructions, and per-step images — on screen instead of on paper.
- Guided execution: pick a project, template, sample, and technician, and the app timestamps everything itself.
- Structured data capture at each step, in the format the template defines.

Traceability
Who did what, when — without leaving the lab.
Every run is recorded with its technician, start and end times, and the data captured step by step. Nothing is truly deleted: everything is archived, with an audit log. And it is local-first: the server only listens on the machine itself, so patient data never leaves the biobank.

The outcome
Standardized processes and automatic documentation.
- Every technician runs the same protocol the same way, step by step.
- On completion, the app generates the standardized final document itself, instead of assembling it by hand from notes, spreadsheets, and loose records.
- Less friction, fewer errors, and full traceability, in an app already running on macOS and Windows.

Built with
- Next.js
- React
- Electron
- TypeScript
- SQLite (Drizzle)
- Local-first
Ready for technology to stop being
a problem?
One 20-minute call. No commitment. No cost.
Book free call →