Idle Report Analytics Dashboard

Upload an idle-location Excel report to generate live KPIs, Riyadh map heatmap, hotspot analysis, route/vehicle charts, time filters, duration filters, and exportable filtered records. Routes are grouped by the digits before the underscore.

← Back to apps

HTML • Excel • Map • Heatmap • Charts

Load idle report Drag Excel/CSV here or click below Choose Excel report

Expected columns: BC ID, Timestamp(s), Duration, Latitude, Longitude, Route Name.

Filters

From date

To date

From hour

To hour

Route

Vehicle / BC ID

Defined area

Official Riyadh route

Minimum idle minutes

Top chart rows

Search route / vehicle / location

Print / Save to PDF

Tick the sections to include. Your browser will open the print dialog — choose Save as PDF.

Report summary and filters KPI cards Map, heatmap and route stands Graphs / charts Hotspot and summary tables Worst idle records

PDF output uses the current filtered data and current map view.

Heat intensity is based on idle duration.
Hotspots are grouped by rounded location.
Red markers indicate 60+ minute idles.

Admin Area Setup

Admin password

Default password: 1234. This is a simple local login for editing saved areas on this computer.

Admin mode active

Area name

Area type

Radius metres

Latitude

Longitude

Map click mode is ON — click the map to fill latitude and longitude.

Areas are saved to Supabase when configured, with browser storage kept as a fallback. Any idle event inside a radius is grouped under that area for the table, graph, filters and export.

Saved location sync: checking Supabase connection...

Riyadh Route Network

Built-in RCRC route network ready.

Import JSON/GeoJSON

The full 117-route Riyadh bus network is built into this app. Start/end coordinates are taken from each official route geometry and shown on the map as faded route stands so the stronger heatmap remains easy to read. Use Edit route JSON to open the current network before saving. Internet refresh updates it from RCRC OpenData when available. Edited/imported routes are saved locally on this computer.

Upload the Excel report to start. The app runs fully in the browser and does not send the report to any server.

Idle Report Analytics Dashboard

Idle Location Report

Idle Location Heatmap

Idle Hours by Day

Idle Events by Hour

Top Routes by Idle Hours

Top Vehicles by Idle Hours

Duration Distribution

Route Quality View

Idle Hours by Defined Area

Idle Events by Defined Area

Top Hotspots

Route Summary

Defined Area Summary

Worst Idle Records