A care home manager was tracking staff qualifications across 4 separate spreadsheets. Each month, she spent an entire day cross-referencing them to check for expiries.
The Problem
- 4 spreadsheets that didn’t link to each other.
- 6+ hours per week on manual compliance checking.
- Expiries sometimes discovered after the deadline.
- CQC inspection anxiety because gathering records took too long.
The Solution
A single web application with a RAG dashboard. Automatic email alerts 30 days before any expiry. CSV export for CQC inspectors. Prototype in 48 hours, full application in 4 days.
The Result
- 6 hours per week saved on compliance checking.
- Zero missed expiry dates since implementation.
- CQC inspection preparation reduced from 2 days to 10 minutes.
- Staff can update their own records, reducing admin burden.
Got a Spreadsheet That's Driving You Mad?
Send it over — I'll tell you what an app version would look like and what it'd cost. No obligation.