Attendance & Compliance Automation Tool
A control panel that logs into the electronic health record system with Selenium, downloads client, staff and charting reports and rebuilds the attendance, group capacity and citation sheets automatically. It replaced hours of daily manual exports.
- Industry
- Healthcare (Behavioral Health)
- Deliverable
- Attendance Tool.xlsb
- Built with
- Excel VBA, Selenium, Web automation
More like this
Related projects
Staff Performance Benchmark Report
Healthcare (Residential Treatment)
A weekly benchmark report for two residential treatment programs. It compares individual sessions, group sessions, interventions and meeting attendance for every client and staff member against…
View project
Product Analysis Report Generator
FMCG / Retail Analytics
An automated sales analysis tool for a beverage brand. Raw point-of-sale data is imported, a pivot master is built and the macro produces Pareto, NIS and…
View project
Survey Completion Dashboard
Housing & Property Surveys
A one-page management dashboard that tracks property survey progress against yearly and monthly targets. Weekly exports from the survey platform are imported with one click and…
View project