Staff Performance Benchmark Report
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 program targets, using traffic-light formatting.
- Industry
- Healthcare (Residential Treatment)
- Deliverable
- Staff Performance.xlsm
- Built with
- Excel formulas, Conditional formatting
Before
Session and attendance counts for two programs were compiled by hand every week.
After
The weekly report compares every client and staff member against program targets with traffic-light formatting.
More like this
Related projects
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
Inventory Management System for Drilling Operations
Oil & Gas
A complete materials and inventory workbook for a drilling services company. It links every well design to the chemicals and cement it consumes, tracks monthly usage…
View project
Timesheet & Billing Dashboard
Legal Services
A timesheet and payout system for a small legal team. Users log in by role, workers record tasks and hours, and the admin dashboard shows billed,…
View project