Rolling Stock Condition Online Monitor System

The system is to be used by carrier companies that carry out freight transportation by rail using their own rolling stock. Top and middle managers use information on condition and location of railway carriages for enterprise management and decision-making.

Rolling Stock Condition Online Monitor System
Summary - just-in-time report of fixed form
in Excel format
 

System Goals:

  • To reduce labor input and time spend on processing incoming information about the condition of rolling stock;
  • To provide on-line access to the information about the condition of rolling stock by creating interactive (electronic) documents and printed register forms in dialogue mode;
  • To increase the efficiency while making the SUMMARY on the condition of rolling stock;
  • To create and support informational environment to facilitate planning, accounting, management in the domain of freight transportation by rail.

The system database stores technical characteristics and "history" of each rolling stock unit, since its appearance until its removal from the register. All the trips of a carriage (loaded and empty) are added to the database. Repair works, i.e., capital, depot and current works, that were performed are also recorded in the database.

The original algorithm of incoming data processing allows monitoring location of each carriage and getting complete information on carriage movement during the day.

The system carries out automatic detection and processing of so called "suspicious" situations. Such situations usually require the interference of a dispatcher or manager. They can be caused by errors of incoming data or non-standard progress of a situation, e.g., change of movement direction of a loaded carriage, changes in the location of a carriage that is under repair, etc.

User interface and business logic of the system are implemented in the form of a desktop application compatible with MS Windows 2000/XP.

User Needs

  • To keep record of the rolling stock;
  • To monitor condition and location of carriages for efficient management decision-making;
  • To keep record of repair works (capital, depot and current).

Issues

  • High labor input of data processing in the process of making the SUMMARY on the location of carriages;
  • Errors and inaccuracies of incoming information;
  • Raising number of carriages in the rolling stock cause sharp increase of time and labor input of information processing.

Solution

The "PARK" system provides:
  • Incoming data reception, its preliminary processing and adding to the database;
  • Incoming data is processed by the original algorithm. This results in the SUMMARY document, used for analysis and decision-making;
  • Keeping record of non-operational carriages, meaning the carriages out of transportation work, e.g., carriages under repair;
  • Tools for searching, sorting and filtering data for ad hoc reporting.

Benefits

  • Notable reduction in time and labor input of incoming information processing;
  • Upgrade in efficiency and reliability of received reference and report data;
  • Automatic detection of "suspicious" situations in carriages movement;
  • Convenient user interface allows users to master the work with the system in 1-2 lessons.

Development Environment: Delphi 7.0, MS Access 2000.

Operating System: Windows 2000/XP.

Data Export: MS Excel 97-2002.

System Users:

  • Dispatcher;
  • Transport manager;
  • Heads of commerce and marketing departments.

Input Data:

  • Carriage number;
  • Freight code;
  • Weight;
  • Operation;
  • Location station;
  • Date and time;
  • Destination station;
  • Train number;
  • Train index.

Output Data:

SUMMARY – a just-in-time report of a fixed form for certain date and time including:
  • GENERAL INFORMATION – the number of carriages by purpose ("dark"/"light"), by condition (operational/non-operational), by owner, by topic;
  • NON-OPERATIONAL CARRIAGES – a list of non-operational carriages with the indication of location, type of repair or other breakdown reasons;
  • LOCATION of loaded and empty carriages.

Major System Functions:

  • Keeping record of the rolling stock;
  • Keeping record of repair works (planned and current);
  • Automatic creation of just-in-time SUMMARY on the location of loaded and empty carriages;
  • Automatic detection of non-standard ("suspicious") situations in carriage movement;
  • Making corrections to the calculation result in dialogue mode;
  • Running database queries as a combination of search, sort and filter operations. Export of query results in Excel tables;
  • Automatic classification of carriages by Movement topic. This means that a number of carriages are grouped by a user-defined topic or, for example, a loading station which all of them are attached to. This feature is used for convenient monitoring over groups of carriages;
  • A capability for pairwise use of various user interface toolbars of in order to clarify reference and report information on-line.