Selected dataset · DD/MM/YY filter · CSV/XLSX exports · GPS fuel-rise detection
GPS data is imported once in Data Import. Process the selected dataset below.
Master list auto-loads from ./HCT_Lorry_List.xlsx (cached). Upload below to refresh.
Any header like “Plate / Lorry / Vehicle / Registrationâ€. Headerless files are detected too.
| # | Vehicle | Fueling Time | Diesel Added (L) | Odo @ Fuel (km) | Dist since last fuel (km) [i] | Fuel km/L | Start Fuel (L) | End Fuel (L) | Data Quality | Address @ Fuel |
|---|
Estimated km/L uses positive litres paired with positive distance since a previous refuel or valid odometer baseline. Intervals are grouped by refuel date and may span months.
| Vehicle | Sessions / matched | Total Added (used) L | Avg Added/Session (used) L | Total Dist (used) km | Est. km/L | Last Fuel Time |
|---|
These thresholds apply to Processed GPS and Driving Behaviour KPIs. Values are stored in localStorage.
Driving hours and rest time are calculated from uploaded GPS raw data. Results can be exported or sent to the Compliance Sheet.
| Vehicle / Lorry No | Date Range | Total Dist (km) | Engine On Hrs | Driving Hrs | Idle Hrs | Idle % | Long Idle Hrs/100km | Overall Fuel (L) | Overall Fuel Ledger (L) | Movement Fuel (L) | Idle Fuel Strict (L) | Idle Fuel Strict (L)/100km | Idle Fuel Ops (<5) (L) | Overspeed Cnt/100km | Overspeed Min/100km | Longest Continuous Driving | Longest Rest Break | Rest Break Count 15min | Rest Break Count 30min | Remarks / Data Quality |
|---|
| Vehicle | Date | Total Dist (km) | Engine On Hrs | Driving Hrs | Idle Hrs | Idle % | Long Idle Hrs/100km | Overall Fuel (L) | Overall Fuel Ledger (L) | Movement Fuel (L) | Idle Fuel Strict (L) | Idle Fuel Ops (<5) (L) | Overspeed Cnt/100km | Overspeed Min/100km | Longest Continuous Driving | Longest Rest Break | Rest 15min | Rest 30min | Remarks / Data Quality |
|---|
Rest is fixed as speed < 1 km/h. Threshold values are stored in localStorage.
| Vehicle | Date | Max Speed (km/h) |
Overspeed min/100km | Driving Time (<8hrs) | 15min rest every 2hrs (breach cnt) | 30min rest every 4hrs (breach cnt) | Harsh Brake Cnt | Daily Compliance |
|---|
| Vehicle | Date Range | Pump Sessions | Diesel Used (L) | Fuel km/L | Idle % | Overspeed Min/100km | Safety Compliance % | Outlier Days | Idle Cost (RM) | Fuel Efficiency Score | Behavior Score | Safety Score | Fuel Score | Total Score | Grade |
|---|
Clerk may tune thresholds; persist locally (localStorage) and apply immediately.
| Date | Vehicle | Engine-on (h) | Drive (h) | Idle (h) | Daily Fuel (L) | Movement Fuel (L) | Idle (L) | Unallocated (L) | Daily Mileage (km) | km/Fuel Used | km/Movement Fuel |
|---|
| Date | Time | Vehicle | Daily Mileage (km) | Daily Fuel (L) | Driving (L) | Drive (h) | Reason | Severity | Confidence | Data Quality | Fuel Gap (L) | Daily Fuel Rule | Movement Fuel Rule | Drive Hours Rule | Idle % Rule | Status | Decision | Reviewed By | Reviewed At | Remark | Detail |
|---|