EMS Performance Dashboard with Conditional Formatting
This lesson is part of the course
In this lesson
You complete a monthly dashboard with compliance and a status flag, then colour UHU with a colour scale and every month that needs review with a formula rule.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Call-to-Arrival Intervals from CAD Timestamps Locked
- The 90th Percentile Response Time vs the Average Locked
- Compliance % within Target by Zone and Priority Locked
- Unit-Hour Utilisation (UHU): Busy Hours ÷ Staffed Hours Locked
- Demand by Hour vs Staffing (with a Chart) Locked
- Station Coverage: Share of Calls within X Minutes Locked
- Hospital Turnaround and Offload Delays Locked
- EMS Performance Dashboard with Conditional Formatting Locked