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% | ||||
Week in Review | Resources | Search | Roy Blanchard | Laura Blanchard | Home
THE
BLANCHARD COMPANY
2041
Christian Street - Philadelphia PA 19146-1338
Roy Blanchard.215-913-7740 mobile, royblan@icloud.com
Laura Blanchard, 215-985-1445, lblanchard@rblanchard.com
Site contents copyright 1995-2020 The Blanchard Company except as indicated herein. All rights reserved.