📋 Raw Input Data
Paste raw row data below
📖 Parsing Rules
Multi-word city phrase → Main Route Header
C317, C11, BV3 → Bus / Vehicle Number
ALL / HN MN / NTH EXP / KLS / VV → Route
23/27, 0/35 → Load — ALWAYS SKIPPED
8:30 AM → Slot (Time)
Auto-normalise: HN MN→HNMN · NTH EXP→NTH · KLS EXP→KLS
✅ Cleaned Row Data
| # | Main Route | Bus | Route | Slot (Time) | |
|---|---|---|---|---|---|
Paste raw data and click "Clean Data" | |||||
📋 Raw Partial Fleet Data
Same format as Row Data — paste directly
ℹ️ Format Guide
Same rules as Row Data — header, bus, route, load (skipped), time
Each bus becomes one partial fleet slot
You can also manually add rows with "+ Add Row"
✅ Parsed Partial Fleet
| # | Slot (Time) | Route | Assigned Bus | Main Route | Notes | |
|---|---|---|---|---|---|---|
Paste raw data and click "Parse Fleet" | ||||||
Not connected
☁️ Cloud Sync
➕ Add / Edit Bus
Bus Number *
Main Route Group *
Auto-populated from Row Data
Known Routes (comma-separated)
Driver Base / Depot
🚫 Excluded from Partial Fleet
0 buses
Buses listed here are automatically skipped when parsing Partial Fleet data.
None added
📊 Last Adjustment
—
Run adjustment to see summary
🚌 Bus Master Registry
0 buses
| Bus | Main Route | Known Routes | Depot | Excl. | Actions |
|---|---|---|---|---|---|
No buses registered. Add buses or pull from cloud. | |||||
✅ Adjusted Partial Fleet
| Slot | Route | Original Bus | Assigned Bus | Match Type | Reason |
|---|---|---|---|---|---|
Click "Run Adjustment" to generate output | |||||
🚫 Non-Ops Buses
None
⚠️ Unassigned Slots
None
📝 Adjustment Logs
■ Perfect
■ Similar
■ Fallback
■ Info
Logs will appear after running adjustment