Interchange On-Time Performance Calculator for Downloading

The scheduled railroad environment with its trip plans for both loaded and empty cars absolutely requires consistent, reliable interchange between class 1 and shortline railroads. Measurement requires something to measure against, and this is the value of the Interline Service Agreement (ISA). It sets the performance standard.

Typically short lines have not measured interchange performance. That's unfortunate because asset utilization and car-miles per day are under close Class I scrutiny. The On-Time Performance Calculator is designed to help short lines measure class 1 interchange performance and to provide something other than anecdotal evidence that the system is or is not working.

This calculator is set up to keep a running record of interchange performance by days of the month and cumulative performance measures throughout the month. In the sample we see the delivering class 1 missed the two-hour window provided by the ISA 10 out of 20 times for a 50% failure rate.Clearly, this is not acceptable, and the Calculator gives you a starting place for remedial action.

One of the first uses of this product was to document a consistent Class I failure to make the agreed-upon interchange window. The local Trainmaster kept telling senior management everything was working according to plan, yet this tool showed otherwise. Armed with this information, the short line and Class I could drill down to root causes and take remedial action.

Please feel free to download this Interchange Dwell Time Calculator to track your own experience and cost. Any feedback or commentary would be greatly appreciated.
[updated 6/25/2012]

 


(Spreadsheet is Microsoft Excel 2003 for windows)

Sample Output based on the Fallen Flag & Eastern shown below.

   Roy Blanchard's Shortline Interchange Measurement Tool  
Interchange performance      
Railroad: FF&E   Location: Junction   
Interchange time: 8:00 AM    Days: Mon-Fri  
Window in hours: 2:00         
           
Month Date Actual Intch Variance Hours
Late
Events
>2 hours
     
Sep 3 8:00 AM 0:00 0:00  
Sep 4 8:15 AM 0:15 0:00  
Sep 5 8:30 AM 0:30 0:00  
Sep 6 2:30 PM 6:30 4:30 1.00
Sep 7 11:05 AM 3:05 1:05 1.00
Sep 10 8:00 AM 0:00 0:00  
Sep 11 8:00 AM 0:00 0:00  
Sep 12 9:30 AM 1:30 0:00  
Sep 13 10:15 AM 2:15 0:15 1.00
Sep 14 9:40 AM 1:40 0:00  
Sep 17 8:30 AM 0:30 0:00  
Sep 18 9:45 AM 1:45 0:00  
Sep 19 11:05 AM 3:05 1:05 1.00
Sep 20 1:29 PM 5:29 3:29 1.00
Sep 21 10:00 AM 2:00 0:00 1.00
Sep 24 10:30 AM 2:30 0:30 1.00
Sep 25 4:45 PM 8:45 6:45 1.00
Sep 26 0 23:59 21:59 1.00
Sep 27 8:55 AM 0:55 0:00
Sep 28 12:30 PM 4:30 2:30 1.00
    Events   20 10
    Percent in 2 hr window   50%  

 

ChartObject September Intch Perf

 

Week in Review | Resources | Search | Roy Blanchard | Laura Blanchard | Home

THE BLANCHARD COMPANY
2041 Christian Street - Philadelphia PA 19146-1338 (215) 985-1110 voice - (215) 985-1446 fax
Roy Blanchard, rblanchard@rblanchard.com
Laura Blanchard, lblanchard@rblanchard.com

Site contents copyright 1995-2001 The Blanchard Company except as indicated herein. All rights reserved.

home home Home Laura Blanchard - personal page Roy Blanchard - personal page Search the site Resources for the Railroad Industry The Railroad Week in Review