Introduction

The data downloaded from CMS was studied. The period of study was from 2023-04-01 to 2023-04-30 23:57:00. There were of 25924 crew sign ons during this period._The data is for diesel operations only_. Analysis for AC operations shall follow.

Observations

The service-wise and division wise break up of number of crew sign-ons is tabulated below.

Service wise , division wise crew sign ons

The total hours worked in each category of service for each division is tabulated below.

Service wise, division wise total crew hours

The same data is tabulated indicating the percentage share of each item with respect to the total number of sign-ons.

Service wise, division wise total crew hours as a percentage of Total Crew Hours

The biggest share of crew hours is in Hubli Division for freight services (62.7%). Further analysis is done on this data. An interactive pivot table is available below for this purpose.

Guide to using the pivot table.

Refer to the image below to create the pivot table

Sample Pivot table

Interpretation

Train No. JVSL has run at an average speed of 61.35 kmph in TNGL-JSWN section.

The interactive pivot table template can be used to further analyse the data