Doing My Senior Exit Project on Trains...

Hello All,
I am a senior in high school, doing my senior exit project [B)]…

For my project, I plan to make a computer model in excell, to calculate the expense of running various types of railroad equipment. I plan to use this model to prove the economic superiority of diesel power over steam. Last year, I wrote a 4,000 word senior exit paper on this very topic, so I cannot change. I can send my paper to whoever wants to read it for kicks…then subsequently tear it apart. [;)] I haven’t looked at since I turned it in a year ago.

I have only one problem ([xx(])…I need lots of data for this. I’ve raided the library system here in Charlotte, NC. I found some basic data of expenses, but I need data that is much more in-depth. I plan to trek up to the NC railway museum in Spencer one weekend, and see if I can find anything there: apparently there is a museum archive with lots of old Southern Railroad documents.

Does anyone know any good sources where I could find this type of data??? This project is due in over a month, so I’ve got some time to obtain stuff and work through any problems.

Of course I’ll use G-scale models have when I present this product.

Any help would be WONDERFUL.
Thanks in advance!

Can you get access to Interstate Commerce Commission documents? Railroads were required to report annually to the ICC and this would include some cost data for your project. See the PM I sent you.

Well, that’s a formidible project. Excel is an excellent modeling tool for this kind of project. The difficult part of fleet comparisons is … finding comparable fleets. The average steam engine as of 1950 was 27 years old. The average diesel locomotive as of 1960 was about 8 years old. Overall diesel maintenance costs sure looked good. Even today, the average BNSF diesel fleet is about 15 years old. There has never been and probably never will be, in fleet terms, an average age comparable to the average age of steam engines at their heighth. That is a problem for any econometric comparison until you generate an age/cost curve for the respective motive power types. Those curves have been generated and are available. Too, as shops were modernized during the 1950s, that process improved the productivity of maintenance facilities and, while that no doubt benefitted the appearance of diesel fleet maintenance costs, it has to be segregated out as a factor, and that is hard to do without some very careful analytical work.

There are some detailed studies out there done by competent and experienced engineers and subject to peer review. Thomas Thelander did one for Swedish railways in the early 1960s and H.F. Brown did one for British Rail in 1960. Brown’s was published by the Journal of the Institution of Mechanical Engineers and is available at their website. I believe Thelander’s was also published there, but my copy of his paper is in storage and I don’t have it for reference.

The standard data reference source for these kinds of studies are the Transport Statistics of the United States, although an earlier title was Statistics of the Railways of the United States, published by the Interstate Commerce Commission.

These are generally available only at Federal Depository Libraries. Usually at least one or two public University libraries in each state has that designation. In your state, such libraries are at the University of North Carolina, Asheville, Gardner-Webb University (Dover Memorial Library), Appalachia State University (Carol Grotnes Belk Library), Campbell University (Carrie Rich Memorial Library), University of North Carolina at Chapel Hill (Kathrine R. Everett Law Library). You should call ahead and ask specifically if they have the Transport Statistics of the United States published by the Interstate Commerce Commission. You indicate you “raided” the libraries in Charlotte, so I assume that the University of North Carolina (J. Murrey Atkins Library) didn’t have the ICC reports, even though it is also a Federal Depository Library.

This is a preferred data source because each railroad was required to standardize its reporting to the ICC using the ICC accounting system, and so data is pretty much comparable from one road to another, one year to another.

Unfo

Hmm. I think I will try the UNC Charlotte library this weekend in addition to the shops at Spencer (UNC library might be better actually). From what I can tell it is a depository library. I’ve been there for projects before, and it has always been quite good. I had never thought about it for this before now…

Also, thank you very much for the suggestion of ICC records. If they may be inaccurate, I should be able to skew them to fit my purposes! [}:)] Thank you MichaelSol for all the information on the ICC accounting records!

I will also search for the other sources mentioned here in my quest for information.

Thank you to all,

Peter

PS - I’ll find a place to host the model online during/after it’s constructed, so that you guys can view/play with/comment on it.

You might address a letter to the Norfolk Southern’s engineering department and see if they have records that you can use. Certainly, toward the end of the steam era, the Norfolk and Western had steam locomotives with ages comparable to diesels today and servicing facilities for steam locomotives as modern for the time as facilities for diesels today. I think this is one way to get a fair comparison. And despite a tremendous investment in steam, N&W finally did decide to go diesel.

Michel: Do you think if Peter uses maintenance cost data from the steam-diesel transition period that the data might be purer. And what I mean by that is that few if any diesels would have been rebuilt during that time as they were still new.

Ed

[quote user=“MichaelSol”]

The standard data reference source for these kinds of studies are the Transport Statistics of the United States, although an earlier title was Statistics of the Railways of the United States, published by the Interstate Commerce Commission.

These are generally available only at Federal Depository Libraries. Usually at least one or two public University libraries in each state has that designation. In your state, such libraries are at the University of North Carolina, Asheville, Gardner-Webb University (Dover Memorial Library), Appalachia State University (Carol Grotnes Belk Library), Campbell University (Carrie Rich Memorial Library), University of North Carolina at Chapel Hill (Kathrine R. Everett Law Library). You should call ahead and ask specifically if they have the Transport Statistics of the United States published by the Interstate Commerce Commission. You indicate you “raided” the libraries in Charlotte, so I assume that the University of North Carolina (J. Murrey Atkins Library) didn’

You may also wish to contact the Association of American Railroads which keeps all sorts of statistics and may already have what you are looking for.

www.aar.org

Also, in reference to the ICC Valuation records. The originals are kept at the national archives (Archive II Building) in College Park, MD. There is a very knowledgable archivist who works with railroads there, who’s name is escaping me at the moment who might be of help.

LC

Probably so, but that raises the question about what the diesel maintenance curve looks like “down the road”. Too, the maintenance costs of steam are problematic during that period as the fleet was being allowed to age without an eye to sustaining that fleet. And there were still substantial numbers of locomotives built prior to 1915, built with old technologies and old metallurgical knowledge and skills. As you may note from the graph posted above, the differing technologies age quite differently in terms of maintenance requirements – and the highly complex machine “ages” substantially more rapidly than the simpler technologies of whatever type. That shouldn’t be a surprise … but the rail industry is unique in many of its perceptions.

Even for someone as careful and knowledeable as H.F. Brown at Gibbs & Hill, it was a difficult endeavor to extract meaningful data and, as Brown pointed out, even his evaluation measured, ultimately, the practical results of the last design, a “modern” steam engine, for which there was a large scale application and data – the Northern – which supplied the data for comparison to diesel-electric fleets designed and built in the 1950s; and being marketed by the claim that they, in turn, were so much better than the diesel-electric designs coming out of WWII.

They probably were – so would a steam engine fleet built in the mid-to-late 50s.

But, you go with the data you have, not the data you wish you had.

In this case, any comparison, no matter how carefully done, necessarily compares the two technologies across a generation gap in design and manufacture which necessarily operates automatically in favor of one o

Find a library with Trains magazine back through the 40’s. Nearly every issue through the late 50’s had articles on operating cost and payback trying to justify steam.

So, this project has begun! I have begun my spreadsheet (what I have now isn’t a model, I know, the model is coming…) and am traveling to spencer tomorrow to look at the NC Transportation Museum archives. Hopefully I can find some information about individual locomotives, so I can actually start to create a model that will compare a single Diesel vs. a single steam locomotive, and compare costs, proving the Diesel to be more efficient.

This is a link to the blog I have created for this project. The spreadsheet is avaliable through a link on the blog: http://steamvsdiesel.blogspot.com/

Thus far, the blog contains very broad, industry-wide data. The spreadsheet needs alot of work…

Also, some of you have mentioned that I use old trains magazines. I’ve searched google books and apparently the closest collection of old issues is located at Duke… I’ll go to Spencer tomorrow, and then decide whether I would even need them at all.

Just for the sake of completeness and copyright attribution, and in case I am intriqued enough to pursue this information, could you cite the source of this image?

Thanks…

David Pfeiffer

Oops, must have cut off the bottom of the image when I photoshopped it to reduce the image size. The attribution there reads “from H. F. Brown, “Economic Results of Diesel Electric Motive Power on the Railways of the United States of America,” Proceedings of the Institution of Mechanical Engineers, 175:5 (1961).”

Well, it’s nice to see that you are approaching this from a strictly objective perspective!

However, regards “efficiency” I doubt there is anyone who would contest the observation that an internal combustion diesel-electric locomotive is inherently more efficient than an external combustion steam locomotive.

[tup]! thanks…

And in terms of effeciency, as implied by another poster, you will need to define HOW you measure effeciency…the external combustion engine (classic steam) is more mechanically effecient, but the overall system effeciency in terms of man hours to maintain (man hours labor vs operations hours) may be something entirely different…and dont forget support requirements, such as building, maintaining and resupplying water towers. (In the east, water towers may not be a large problem, but as the RR’s stretched west over the deserts, it became a significant issue. )

As a “for example” of the kinds of considerations that go into motive power studies, “water” savings is often cited as a benefit, without recognition of corresponding needs of the diesel-electric locomotive.

A rule of thumb in these kinds of studies is that, in addition to fuel costs, a diesel locomotive consumes substantially more lubricant than a steam engine, running between 10% and 12% of the cost of the diesel fuel consumed, while at the same time using considerably less water than the steam engine.

So, to properly account for the motive power changes, savings in water is, to a large extent, offset by increased charges for lubricants.

On the Milwaukee, which represents a good motive power model because it dieselized more rapidly than its competitors, in 1944 it used $861,039 worth of water, which declined to $158,074 by 1959, two years after dieselization was complete, adjusted for ton-miles.

But, lubricant costs increased from $419,687 to $1,324,196 on an equivalent ton-mile basis.

The cost savings in water of $702,965 were more than offset by the increase in lubrication costs of $904,509.

The difference of $201,544 represents a net loss incurred because of dieselization due to increased lubricant costs over the savings in water costs.

As I say, that is a “for example” of the kinds of considerations necessary to come to a realistic conclusion about relative “costs”. Another would be the “availability” of the respective motive power types which impacts fleet size needs. Brown estimated for steam “at least 60%” availability, whereas he estimated 90% for a new diesel-electric. That figure was optimistic as E

it’s 1:34 AM eastern time…

but the blog has been updated. I have started an actual model based on data one of you gave me (i forget who…but please take credit if you wish). The blog can be viewed here, it explains the update, and provides a link to the file: http://steamvsdiesel.blogspot.com/

Comments/Suggestions are highly appreciated, either here or on the blog.

  • Peter

I just saw the spreadsheet, and it looks pretty good; you’re on the right track (pardon the pun).

Two observations:

  1. tonnage and carloads declined substantially during the era of dieselization. If railroads had stayed with steam, the decline in needs would have permitted railroads to scrap older models and gain the fleet efficiencies shown by newer models. As of 1950, 40% of the existing steam had been built before 1915. Had the diesel-electric been the primary motive power, as a hypothetical, the same statistical result would occur as a result of being able to retire older, high maintenance items. Also, train crew manpower needs declined as a result of declining tonnage.

  2. You have a conclusion about diesel fuel costs in your text, but I don’t see any comparison with costs of coal on a comparable basis during the time frame in question.

The whole point of Dieselization, of course, was to purchase a more efficient motive power fleet. What was missing from most of the public relations promotionals was the key part of the process: “purchase,” – and because the economic service life of the machine being purchased was considerably shorter than equivalent steam, those studies that took the time to look at the financing implications of the changeover found that, for road power, the additional financing charges exceeded the cost savings obtained from efficiency gains in operation. This showed up very clearly at Milwaukee Road:

[Click to enlarge]