Rail Fleet Scheduling Gantt Builder (Excel + Power Query)

At its core, the Rail Fleet Scheduling Gantt Builder leverages Excel’s native capabilities—structured tables, XLOOKUP, SEQUENCE, and dynamic array functions—combined with Power Query’s robust ETL (Extract-Transform-Load) engine to ingest, clean, and harmonize heterogeneous scheduling inputs (e.g., CSV dispatch logs, ERP-maintained rolling stock registers, shift calendars, and rail network topology metadata). The model operates on a time-sliced granularity (typically 15-min or 1-hr intervals), mapping each rail unit (locomotive or wagon set) to discrete temporal blocks representing movement legs, loading/unloading dwell, empty repositioning, and scheduled maintenance. A critical design principle is constraint-aware sequencing: dependencies such as track section availability, crew shift boundaries, safety clearance windows, and interlocking logic are encoded via calculated columns and validation rules—not hard-coded macros—ensuring traceability and regulatory compliance. Visualization relies on stacked bar charts driven by helper columns that convert start/end datetime pairs into horizontal bar segments, with conditional formatting and slicers enabling real-time filtering by asset type, mine pit, commodity, or priority tier. Furthermore, Power Query supports version-controlled refresh pipelines: new schedule revisions can be ingested as delta files, automatically reconciling changes against baseline plans while flagging conflicts (e.g., double-booking of a shunter or overlapping block occupancy) via diagnostic queries.