The Exception Report: Rule-Based Flags, Top-5 Lists and a Chart
This lesson is part of the course
In this lesson
You flag each vehicle with an IFS rule set, build a top-5 list of idle share with LARGE and INDEX/MATCH and chart the idle share by vehicle for the monthly fleet review.
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