PUBLIC UTILITY, LABORATORY · FERIZAJ, KOSOVO · Internal lab software, reporting
A water utility's laboratory tracks every sample from source to signed report
Results
- Expert hours saved a year, an estimate: 10 analyses a day over 250 working days, about 10 minutes of manual checking against 1 minute to confirm the automatic verdict
- ~375 h Expert hours saved a year, an estimate: 10 analyses a day over 250 working days, about 10 minutes of manual checking against 1 minute to confirm the automatic verdict
- Of working time a year, by the same estimate
- ~9 weeks Of working time a year, by the same estimate
The problem
Water testing produces a lot of data: sources, zones, meters, dozens of parameters and their legal limits. On paper and in spreadsheets, results were slow to report and hard to check against the limits.
What we built
We built the laboratory's own software.
- The whole network in one place: regions, municipalities, sampling zones, sources and water meters.
- Analyses with the legal limits built in, so every value is checked automatically and failures are flagged.
- One-click PDF reports in the laboratory's own template, with failed parameters highlighted.
- Meter readers record readings for every source, and the monthly difference is calculated automatically.
- Role-based access for lab and meter staff, and a full activity log.
- A dashboard with passed and failed analyses per month and the success rate.
Screens
Stack
- Laravel
- Filament
- Jetstream
- DomPDF
- Spatie Permissions
- Activity log