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
Before
Client, staff and charting reports were exported from the EHR manually every day.
After
A control panel logs in, downloads the reports and rebuilds attendance, capacity and citation sheets automatically.
More like this
Related projects
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
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
Bill of Materials Cost Comparison
Manufacturing
Compares part costs across product models from a grouped bill of materials. Raw data is imported and a results matrix shows quantity, cost and platform for…
View project