Engineers have y'all...

I must have too much time on my hands, or I’m losing my mind, but I’ve started copying from my old tally books to an Excel spreadsheet, all the trains I’ve run.

My original idea was that I was curious as to how many times I’ve run the same units on different trains.

I’ve included make/model and unit numbers, but alot of things have changed since I started. Alot of the units are either retired, renumbered, or just plain gone so I can’t get all the information. I’m hoping some railfans can help me with models.

I am guessing that you will eventually post the numbers.

Here are the SP, SSW, and DRGW locomotives from 1990-1996. Obviously, most of these series were missing locomotives, espicially the older locomotive types, and locomotives were retired during this time. Also, the SP roster I have lists the GP40R as GP40-2, the SD40R as SD40-2, and the SD45R as SD45-2. Finally, SP 3102, 3103, and 3105 were renumber SP 2957-2959 in 1993 to avoid conflicts with DRGW locomotives.

SP 100-378 AC4400CW
SP 1010-1013 Slug
SP 1500-1542 SD7
SP 1600-1613 TEBU
SP 2270-2293 SW1200
SP 2450-2480 SW1500
SP 2493-2510 SW1500
SP 2523-2578 SW1500
SP 2591-2689 SW1500
SP 2690-2701 MP15
SP 2702-2759 MP15AC
SP 2870-2899 GP9
SP 2961-2970 SD35
SP 2971-2976 SD38-2
SP 3102-3108 SD35
SP 3186-3195 GP9
SP 3200-3204 SDP45
SP 3301-3812 GP9
SP 3816-3859 GP9
SP 3877-3883 GP9
SP 4060 GP9
SP 4102-4144 GP20
SP 4160 GP35
SP 4301-4451 SD9
SP 4800-4844 GP38-2
SP 4846-4864 GP38-3
SP 5100-5114 B23-7
SP 5300-5318 SD39
SP 6300-6361 GP35
SP 6522-6676 GP35
SP 6767-6868 SD45T-2
SP 7100-7138 GP40R
SP 7200-7201 GP40X
SP 7230-7231 GP40X
SP 7240-7247 GP40-2
SP 7294-7299 GP40-2
SP 7300-7385 SD40R
SP 7399 SD44-2
SP 7400-7566 SD45R
SP 7600-7602 GP40P-2
SP 7608-7627 GP40-2
SP 7658-7677 GP40-2
SP 7754-7769 B36-7
SP 7800-7883 B30-7
SP 7940-7959 GP40-2
SP 8000-8039 8-39B
SP 8100-8200 9-44CW
SP 8230-8299 SD40T-2 Short Nose
SP 8300-8321 SD40T-2 Long Nose
SP 8327-8341 SD40T-2 Long Nose
SP 8350-8371 SD40T-2 Long Nose
SP 8377-8391 SD40T-2 Long Nose
SP 8489-8573 SD40T-2 Short Nose
SP 8574-8706 SD40M-2
SP 8937-9031 SD45
SP 9071-9140 SD45
SP 9189-9260 SD45T-2
SP 9303-9368 SD45T-2
SP 9600-9619 GP60
SP 9715-9794 GP60
SP 9800-9824 SD70M

LOCOMOTIVES OPERATED
YEAR DATE TRAIN ID CARRIER UNIT # CAR COUNT WEIGHT LENGTH MAKE MODEL
1997 18-Jun LKC-77 UP 5528 26 LDS/ 26 MTY’S
19-Jun LKC-78 UP 5516
20-Jun ZMELB-25 SSW 9634 56 LDS 3657 3477’ GM SD45T-2
28-Jun MEPFW-02 SSW 8074 GE B40-8
DRGW 5371 GM SD40T-2
SP 8516 GM SD40M-2
29-Jun MFWODX-29 UP 9287 28 LDS/ 41 MTY’S 4750 4114’

It didn’t format correctly when I copied and pasted it, but that’s an example.

To the right of the unit number are loaded and empty car counts.

And thanks for the help, that filled alot of gaps and corrected a whole lot of mistakes.

[:D] If you like doing it, hang in there! Quite possibly your consolidated historical work records could form the “mother lode” of future research for some rail historian of the 20th/21st Centuries.

In an age in which computers are nullifying a lot of traditional information-gathering, and older forms of paper-based data which might be quite useful to keep in paper format are nonethless getting trashed by RR corporations operating under space-saving imperatives (and perhaps impervious to the importance of history!), you might well be doing something pretty unique.

And if you ever want to dictate your memoirs, there’s nothing better than a good solid stack of facts to back up your recollection.

Don’t do it “just” for posterity. But the information you have strikes me as exactly the kind of stuff that is shamelessly undervalued today – and would be a shame to be without tomorrow.

al-in-chgo

Well I appreciate it. I hope this will help anyone who wants to use it. It definitely shows how we in El Paso went from running almost entirely SP/SSW units to running the yellow dogs, but I do need some help. I need help identifying some of the UP units before they all became SD70M’s and C44AC’s. Can anyone point me in the right direction? When I go to UP’s website the unit’s are either no longer there or are a new unit.

I do not know as much about UP locomotives as I do about SP locomotives, but I think the list below is correct for 1997.
18-Jun LKC-77 UP 5528 26 LDS/ 26 MTY’S GP40-2
19-Jun LKC-78 UP 5516 GP40-2
20-Jun ZMELB-25 SSW 9634 56 LDS 3657 3477’ GM GP60
29-Jun MFWODX-29 UP 9287 28 LDS/ 41 MTY’S 4750 4114’ 8-40C
3-Jul ZMELB-02 UP 4205 38 LDS/ 19 MTY’S 2598 3625’ SD40-2(?)
17-Jul MODFW-16 UP 5969 70/43 6129 6876’ GP60
17-Jul MODFW-16 UP 4252 SD40-2(?)
18-Jul MFWTUX-14 UP 5842 GP60
18-Jul MFWTUX-14 UP 9245 GE 8-40C
22-Aug MFWWC-22 UP 4121 SD40-2(?)
26-Aug MHOWC-23 UP 4131 SD40-2(?)
26-Aug MHOWC-23 UP 9238 GE 8-40C
28-Aug IEWLBB-26 UP 5558 GM GP40-2
31-Aug MWCFW-29 UP 5989 GP60
6-Sep ZMELB-04 SP 8362 55/0 3346 4121’ GM SD40T-2
6-Sep MWCFW-03 SP 8132 28/57 4772 5102’ GE C44-9W
6-Sep MWCFW-03 SP 8127 GE C44-9W

You might also try http://www.utahrails.net/up/uprr-index.php and http://ncespee.railfan.net/UP/uptbl.html.

<

YEAR

DATE

TRAIN ID

CARRIER

UNIT #

CAR COUNT

WEIGHT

LENGTH

MAKE

MODEL

1997

18-Jun

LKC-77

UP

5528

26 LDS/ 26 MTY’S

GM

GP40-2

19-Jun

LKC-78

UP

5516

GM

GP40-2

20-Jun

ZMELB-25

SSW

9634

56 LDS

3657

3477’

GM

SD45T-2

28-Jun

MEPFW-02

SSW

8074

GE

B40-8

DRGW

5371

GM

SD40T-2

SP

8516

GM

SD40M-2

29-Jun

MFWODX-29

UP

9287

28 LDS/ 41 MTY’S

4750

4114’

GE

C40-8

3-Jul

ZMELB-02

UP

4205

38 LDS/ 19 MTY’S

2598

3625’

GM

zapp,

Very generally, most of the NS units on your last list are EMD’s. GE’s will be numbered in the 8 & 9 thousands. If you need specifics, send me a list and I’ll try to help.

BTW, NS has some good seats. Beats the heck out of those “Pleather” seats some roads like UP use!

Zapp, have you checked this site?

http://utahrails.net/all-time/all-time-index.php

Oh NO, I couldn’t disagree with you more. Even the old black high backs were better then NS’. At least when the dispatcher was screwing you, you could sleep through a majority of it.

Now the old SP bar stool’s were uncomfortible! I kick myself for not grapping a few of those after the merger when they were retiring those old units. They had the old setting sun emblem pressed into them. They would have been great at our bar!

…and wake up with your arse soaking wet from the sweat!

…you keep your junk and I’ll keep mine and we will both be happy.[:D]