EMS Response Time Analytics: Percentiles, Coverage & Unit-Hour Utilisation

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Split every response into call processing, turnout and travel time in minutes, handle a call that crosses midnight and average the P1 response time.
• Compare average, median and 90th percentile response times of an urban and a rural zone and test each zone against its target.
• Look up the target of every call in a zone × priority table, flag the calls within target and build the compliance matrix and the overall rate.
• Calculate the UHU of every ambulance and of the system, the transports per unit hour and the extra unit hours needed to bring utilisation down to a ceiling.
• Turn hourly call demand into the number of ambulances busy, compare it with the units staffed, count the stretched blocks and chart demand against staffing.
• Find the fastest station for every demand zone from a drive-time table, then measure the share of calls within 8 minutes, with and without one station.
• Measure offload and turnaround times at three hospitals, the delay beyond a 30-minute offload target and the ambulance hours lost per hospital.
• 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.