Office of Senior Citizen Affairs Baguio
Government · Jan 2026 · Solo Developer
Report generation went from 4 days to under 4 hours, run entirely by non-technical staff.
The problem
Over 68,000 senior citizen records were being managed by hand. Generating reports took days of manual work.
What I built
- A system in Excel and VBA that handles data entry, analytics, and report generation automatically
- Designed so non-technical staff can run the whole thing without training
Result
Report generation went from 4 days to under 4 hours.
Stack
- Excel
- VBA
- Data Analytics
Images
Need something like this?