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.

0Protocols on paper
1Record per patient, across all projects
1-clickFinal document, auto-generated

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.
The biobank app's protocol-template editor, with ordered steps.

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 guided step-by-step runner, showing technician, patient, sample, and PDF export.

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.
The app dashboard with projects, templates, patients, and runs in one place.

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 →