Utilisation: Hours Used per Vehicle, a Heat Map by Hour and Day, and Underused Vans
This lesson is part of the course
In this lesson
You add up the hours each van was used, turn them into utilisation against the available hours, build a weekday × hour heat map of trip starts with COUNTIFS and count the underused vans.
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
- The Ping Log: Timestamps, Ignition Status and Trip Flags Locked
- Distances from Coordinates: Haversine, the Flat-Grid Shortcut and Trip Totals Locked
- Speed and Stops: km/h per Segment, Stop Status and the Share of Time Moving Locked
- Idling: Threshold Rules, Idle Hours and What They Cost in Fuel Locked
- Fuel Efficiency: Litres per 100 km by Vehicle and Route, and Outliers Locked
- Utilisation: Hours Used per Vehicle, a Heat Map by Hour and Day, and Underused Vans Locked
- Harsh Events: Counts per 100 km per Vehicle and Weekly Trends with ISO Weeks Locked
- The Exception Report: Rule-Based Flags, Top-5 Lists and a Chart Locked