Note: All roster uploads will use this selected date
🏢 CSMT Office
Expected: ~400 records daily
🏢 KYN Office
Expected: ~300 records daily
🏢 PNVL Office
Expected: ~125 records daily
📝 Supported Formats: Excel (.xlsx) and CSV files 📅 Upload Frequency: Daily uploads from each office 📊 Expected Structure: Detail ID (Column A), Motorman Name (Column B) 🔒 Security: Each office can only upload for their designated area
📋 View Daily Duty Roster
-
CSMT Records
-
KYN Records
-
PNVL Records
-
Total Records
Detail ID
Motorman Name
Office
Date
Upload Time
Actions
Select a date and click "Load Duty Roster" to view records
Train Cancellation Management
📁 Upload Cancelled Trains (Bulk)
📝 File Format: CSV/Excel with train numbers in first column. System will automatically detect Detail IDs.
🚫 Cancel Single Train
👥 Access Levels:
🏢 Office Staff (CSMT/KYN/PNVL) Can cancel trains from their schedules
🎖️ HQ Supervisor Can cancel any train from any office
📋 View Train Cancellations
-
Total Cancelled
-
CSMT
-
KYN
-
PNVL
-
HQ
Train Number
Detail ID
Date
Reporting Office
Reason
Cancelled At
Actions
Select a date and click "Load Cancellations" to view cancelled trains
Wheel Movement & Duty Hours Analysis
📊 Analysis Filters
📝 Analysis Info:
This report calculates net wheel movement and total duty hours. Duty hours remain constant regardless of cancellations or Sunday restrictions.
Click the + symbol next to each detail to see daily breakdown.
📈 Analysis Summary
Analysis Period
-
Days
Base Wheel Movement
-
Hours
Total Duty Hours
-
Hours
Cancelled Deductions
-
Hours
Sunday Deductions
-
Hours
Net Wheel Movement
-
Hours
📋 Detail-wise Analysis
Detail ID
Period
Net Wheel Movement
Total Duty Hours
Actions
📊
Select date range and click "Show Analysis" to view data
Analysis will show net wheel movement and total duty hours
📖 Understanding the Analysis
🚴 Wheel Movement:
Net movement after deducting cancellations and Sunday restrictions
⏰ Duty Hours:
Total duty hours from ML89A data - unaffected by cancellations
📊 Daily Breakdown:
Click ➕ to see day-by-day wheel movement and duty hours
🎯 Efficiency Ratio:
Compare wheel movement hours vs total duty hours
💡 Key Insights:
Duty Hours: Include all activities - driving, rest periods, preparation time
Wheel Movement: Actual train driving time (subset of duty hours)
Cancellations: Reduce wheel movement but NOT duty hours
Sunday Restrictions: Affect wheel movement calculations only
Efficiency: Higher wheel movement/duty hours ratio indicates better utilization