Management systems
Medical on-call shift settlement system
Six chained Excel spreadsheets, turned into a system with an audit trail and double reconciliation.
No public link
What it is
The system the Hospital Comunitario de Pinamar uses to settle its medical staff’s on-call shifts.
The problem
Shifts were settled in chained Excel spreadsheets, with formulas only their author understood and no record of who changed what.
The solution
He reproduced the spreadsheet formulas inside a system, without changing anyone’s figures, and added what a spreadsheet cannot give you: traceability and control.
What I built
- Six timesheet types.
- Six calculation components.
- Three user roles.
- Immutable audit log.
- Double reconciliation check before closing each settlement.
Outcome
Shift settlements no longer live in a chain of spreadsheets. Every calculation is recorded, every change has an author, and no settlement closes without passing the double reconciliation. Delivered as a final-year project and left running at the hospital.
Stack
- React + Vite
- Django REST Framework
An internal system: there is no public link, and no screenshots with real data are shown.