Author Topic: Railroad Roster spreadsheets  (Read 695 times)

0 Members and 1 Guest are viewing this topic.

orionfield

  • Crew
  • *
  • Posts: 106
  • Gender: Male
  • Respect: +26
    • Out of the Box Models
Railroad Roster spreadsheets
« on: May 11, 2018, 12:24:46 PM »
0
I've been working on a little side project for about a year now...and its taking me quite a while. I have been working a series of spreadsheets for various railroads, cataloging at a high level, Steam Locomotives, Electric Locomotives, EMU's and Motor Cars, Diesel Locomotives, Freight, Passenger, Business Cars and MoW. Within each category, I have been collecting varying information, that would be helpful to a modeler, such as dimensions, Railroad Class, Road numbers, years of service, and available models in N and HO scale. Not surprisingly, it takes a long time to find most of this information and manually input it into the spreadsheet. Eventually, what I want to do is also use this list to see what models would be available for people to Commission from Out of the Box, and generate flat rate pricing for each commission, and offer the rosters to the community as a public service. If I could cut down on the data collection time, I think I could make more progress on completing these rosters faster.

Surprisingly, the fastest part of the process is comparing photos of the various prototypes to available models.

If anyone knows where I can find or has any roster spreadsheets of their own that they are willing to share, I would be very happy. So far the only railroad rosters that I have that are close to being complete are Amtrak, Alaska RR, and Chicago & North Western.  Right now I am just focusing on Class 1 railroads and some select Fallen Flags. Please see my list below. I am also putting out some feelers to some of my software engineer friends on a way to automate some of the data entry process.

Atchison, Topeka & Santa Fe
Atlantic Coast Line
Baltimore and Ohio
Burlington Northern
Burlington Northern Santa Fe
Canadian National
Canadian Pacific
Chesapeake and Ohio
Chicago, Burlington and Quincy
Chicago, Milwaukee, St. Paul and Pacific
Chicago, Rock Island and Pacific
Conrail
CSX Transportation
Delaware and Hudson
Delaware, Lackawanna and Western
Erie
Erie Lackawanna
Ferromex
Florida East Coast
Grand Trunk Western
Great Northern Railway
Illinois Central
Kansas City Southern
Lehigh Valley
Minneapolis, St. Paul and Sault Ste. Marie Railroad (Soo Line)
Missouri Pacific
Missouri–Kansas–Texas
Monon
New York Cental
New York, New Haven and Hartford
Norfolk & Western
Norfolk Southern
Norfolk Southern 1942–1982
Northern Pacific
Penn Central
Pennsylvania Railroad
Reading Company
Seaboard Air Line
Soo Line
Southern
Southern Pacific
Spokane Portland and Seattle
St. Louis–San Francisco
Trailer Train
Union Pacific
Union Tank Car Company
US Military and Federal Government
Virginian
Wabash
Western Pacific
CEO of Out of The Box Models. Ask me about Commissioning a model kit!
www.outoftheboxmodels.com

seusscaboose

  • The Pitt
  • Crew
  • *
  • Posts: 1940
  • Respect: +138
Re: Railroad Roster spreadsheets
« Reply #1 on: May 11, 2018, 01:01:45 PM »
0
Why don’t you cut a deal with the various historical societies?
"I have a train full of basements"

NKPH&TS #3589


Inspiration at:
http://nkphts.org/modelersnotebook

Philip H

  • Crew
  • *
  • Posts: 7479
  • Gender: Male
  • Respect: +527
    • Layout Progress Blog
Re: Railroad Roster spreadsheets
« Reply #2 on: May 11, 2018, 01:26:22 PM »
0
Why don’t you cut a deal with the various historical societies?

My thought exactly.  Also, it might take a little work, but Railroadpicturearchives.net has breakdowns of rolling stock and locomotives by ARR type, general type and number series.
Philip H.
Chief Everything Officer
Baton Rouge Southern RR - Mount Rainier Division.

"Yes there are somethings that are "off;" but hey, so what." ~ Wyatt

"I'm trying to have less cranial rectal inversion with this." - Ed K.

"There's more to MRR life than the Wheezy & Nowheresville." C855B

orionfield

  • Crew
  • *
  • Posts: 106
  • Gender: Male
  • Respect: +26
    • Out of the Box Models
Re: Railroad Roster spreadsheets
« Reply #3 on: May 11, 2018, 03:41:44 PM »
0
Why don’t you cut a deal with the various historical societies?

Thats a really good idea. I think thats doable. I'll let you know if I have any success.

My thought exactly.  Also, it might take a little work, but Railroadpicturearchives.net has breakdowns of rolling stock and locomotives by ARR type, general type and number series.

I've been doing that too, but its slow going, I wish I could export the DB, that would make things easier!
CEO of Out of The Box Models. Ask me about Commissioning a model kit!
www.outoftheboxmodels.com

Ike the BN Freak

  • Crew
  • *
  • Posts: 1248
  • Respect: +35
Re: Railroad Roster spreadsheets
« Reply #4 on: May 12, 2018, 01:24:18 AM »
0
fobnr.org has a list for BN

orionfield

  • Crew
  • *
  • Posts: 106
  • Gender: Male
  • Respect: +26
    • Out of the Box Models
Re: Railroad Roster spreadsheets
« Reply #5 on: May 15, 2018, 12:45:19 PM »
0
fobnr.org has a list for BN

Thanks! Thats super helpful!
CEO of Out of The Box Models. Ask me about Commissioning a model kit!
www.outoftheboxmodels.com

cv_acr

  • Crew
  • *
  • Posts: 2369
  • Gender: Male
  • Respect: +20
    • Canadian Freight Railcar Gallery
Re: Railroad Roster spreadsheets
« Reply #6 on: May 15, 2018, 11:00:52 PM »
0
All Canadian railways freight cars:
http://nakina.net/

Canadian National:
http://www.cnrha.ca/CNcyclopedia

Canadian Pacific (diesel locomotives:
http://mountainrailway.com/
http://trainweb.org/galt-stn/


Algoma Central:
http://trainweb.org/algoma/equipment.html



cv_acr

  • Crew
  • *
  • Posts: 2369
  • Gender: Male
  • Respect: +20
    • Canadian Freight Railcar Gallery
Re: Railroad Roster spreadsheets
« Reply #7 on: May 15, 2018, 11:13:07 PM »
0
Also, it might take a little work, but Railroadpicturearchives.net has breakdowns of rolling stock and locomotives by ARR type, general type and number series.

Yeah, but it can be spotty and only based on photos that are uploaded. Particularly fragmentary for shortlines or even just smaller groups of cars/units.