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 shortlines have not measured interchange performance. That's about to change with tightened AAR reporting requirements and increased attention to asset utilization. The On-Time Performance Calculator is designed to help shortlines 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 the need for an ISA where the local Trainmaster thought there was none. Shared with senior management, the need was immediately clear and the ISA process was put into motion right away.
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.
(Spreadsheet is Microsoft Excel 97 for Windows 95/98)
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 (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.