Harsh Events: Counts per 100 km per Vehicle and Weekly Trends with ISO Weeks
This lesson is part of the course
In this lesson
You label each flagged event with its ISO week, normalise event counts per 100 km for each vehicle and compare two weeks with date-range COUNTIFS.
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