HCT Diesel Pump-In & Mileage Analyzer

Front-end only â€¢ DD/MM/YY filter â€¢ Multi-file upload â€¢ CSV/XLSX exports â€¢ Peak-based fueling detection

GPS file(s) (.csv / .xlsx / .xls)

Upload once; data powers both Pump-in & Driving Behavior.

Load master workbook (.xlsx)

Open a previously exported master file to append more GPS data.

Start Date (DD/MM/YY)

End Date (DD/MM/YY)

HCT Lorry Plate

Master list auto-loads from ./HCT_Lorry_List.xlsx (cached). Upload below to refresh.

Upload HCT_Lorry_List.xlsx (fallback or to refresh cache)

Any header like â€œPlate / Lorry / Vehicle / Registrationâ€. Headerless files are detected too.

Append to Existing Dataset

Detected Pump-in Sessions

#	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

Per-Vehicle Diesel Consumption Summary

Est. km/L excludes the first refuel per vehicle within the loaded range to avoid bias.

Vehicle	Sessions	Total Added (used) L	Avg Added/Session (used) L	Total Dist (used) km	Est. km/L	Last Fuel Time

Processed GPS Data

Processed GPS Thresholds

Driving Speed (kph) Overspeed (kph) Long Idle (min) Fuel Noise (L) Max Interval (min)

These thresholds apply to Processed GPS and Driving Behaviour KPIs. Values are stored in localStorage.

Driving Behaviour Summary

Driving hours and rest time are calculated from uploaded GPS raw data. Results can be exported or sent to the Compliance Sheet.

Vehicles Analyzed

Total Distance (km)

Engine On Hrs

Idle % (Engine On)

Driving Behaviour Summary (Processed GPS)

Derived from Processed GPS (status, distance delta, fuel used).

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)	Driving 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

Daily Behaviour Breakdown (Processed GPS)

Per vehicle per day within selected range.

Vehicle	Date	Total Dist (km)	Engine On Hrs	Driving Hrs	Idle Hrs	Idle %	Long Idle Hrs/100km	Overall Fuel (L)	Overall Fuel Ledger (L)	Driving 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

Driving Safety Compliance (Daily)

Speed Limit (km/h)

Max Daily Drive (h)

Short Rest Min (min)

Short Window (h)

Long Rest Min (min)

Long Window (h)

Harsh Brake Max (/day)

Harsh Brake Threshold (m/s²)

Rest is fixed as speed < 1 km/h. Threshold values are stored in localStorage.

Daily Safety Compliance Table

Per vehicle, per day.

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

Lorry Scorecard

Weight: Diesel

Weight: Behavior

Weight: Safety

Weight: Fuel

Target km/L

Consolidated Scorecard (Per Vehicle, Selected Range)

Standardized columns for multi-lorry consolidation.

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

Fuel Usage Analysis

Target Idle Hrs (max)

Target km/Fuel Used (min)

Compliance rule

Idle Hrs > target or km/Fuel Used < target will be shown in red.

Outlier Threshold Settings

Max Daily Fuel (L) Max Driving Fuel (L) Max Drive Hours (h) Min Idle % to flag (%)

Clerk may tune thresholds; persist locally (localStorage) and apply immediately.

Daily Fuel Usage (clean)

Date	Vehicle	Engine-on (h)	Drive (h)	Idle (h)	Daily Fuel (L)	Driving Fuel (L)	Idle (L)	Idle Cost (RM)	Idle %	km/Fuel Used	km/Driving Fuel

Outlier Fuel Report (requires clerk remark)

Date	Time	Vehicle	Odometer (km)	Daily Fuel (L)	Driving (L)	Drive (h)	Reason	Severity	Confidence	Data Quality	Fuel Gap (L)	Daily Fuel Rule	Driving Fuel Rule	Drive Hours Rule	Idle % Rule	Status	Decision	Reviewed By	Reviewed At	Remark	Detail

Incident Workflow

Open Incident Workflow

Management tracking is now maintained in a dedicated page with filters and editable workflow fields.