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
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
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
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