Counselor Service Hours Report
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts when service falls short.
- Industry
- Healthcare (Behavioral Health)
- Deliverable
- Staff Hours Calculation.xlsm
- Built with
- Excel formulas, Dynamic arrays, VBA
Before
Supervisors had to add up service minutes per client from several reports.
After
Pick a counselor and a week to see minutes by service type for every client, with alerts when service falls short.
More like this
Related projects
Payroll & Billing Hours Automation
Healthcare (Home & Community Services)
Automates the bi-weekly payroll check for a home and community services provider. Staff and billing reports are downloaded from the EHR, billed hours are summarised by…
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
Attendance & Compliance Automation Tool
Healthcare (Behavioral Health)
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…
View project