Model Train Forum banner

1 - 20 of 27 Posts

·
Registered
Joined
·
282 Posts
Discussion Starter #1
While reading the post, "How many trains do you have?"

You have me creating an Excel Inventory of Engines

So - What columns should one absolutely include

and

What columns would be good to include

Thank you

Enon
 

·
Registered
Joined
·
311 Posts
I’ve kept my roster list simple to four columns - road name - loco number - loco type - model manufacturer

Example - Canadian Pacific - 1450 - GP15-1 - Walthers
 

·
Yard Master & Research
Joined
·
10,552 Posts
How many do you want to put up with?
Any way to describe or classify is a field.
Manufacturer, era, engine number, variations, model number, smoke, sound, condition. price. years manufactured. Whatever is important to you.
 

·
Registered
Joined
·
687 Posts
My columns in my own roster spreadsheet:
- manufacturer (exp. Atlas)
- model (exp. GP7)
- RR (paint job)
- engine number
- decoder manufacturer (I use dcc)
- decoder product number
- cost (of engine)
- remarks1
- purchased (date)
- remarks2
 

·
Registered
Joined
·
67 Posts
I usually try to include a hyperlink to the manufacturer's site featuring the item.

Sent from my moto g(6) using Tapatalk
 

·
Registered
Joined
·
4,015 Posts
I did mine in MS Word with the following columns: Type/RR, Road #, Mfg/PN, Year Made/Catalog #, Purchase Price & Year, Value, Comments. The value column is kind of nebulous. Could be MSRP or Greenberg. Something to give my heirs a ballpark figure.
 

·
Registered
Joined
·
207 Posts
Mine includes columns to keep track of whether the car is from a home, neighbor, or foreign/private road. That is, I'm keeping to current Norfolk Southern. So if it's a car from any road that is now part of NS, it's a home car. Also, if it is a smaller regional rail, that is considered home as well. Neighbors are roads (or roads that have merged into a current road) which connect to NS track or overlap/operate near NS. Foreign/private would be regions that do not fall into either of the above.

Then I go 1 step further and do sums based upon the above sort. THEN I take the percentages to determine the percentage of each on my layout.
 

Attachments

·
Registered
Joined
·
444 Posts
For engines, I use most of the columns/categories already mentioned (Manufacturer, Item#, Road Name, Date Purchased, Price, etc.).

I also have a column for Catalog (e.g. 2018 Lionel Vol. 1) and I have a column for Mininum Radius.
 

·
Registered
Joined
·
8,647 Posts
I need to take another inventory soon. Added a lot, deleted some, and its been a while.

I have columns for basic type of loco (diesel, steam, turbine), type (0-4-0 or 2-4-2, etc.), name of type (EMD F, etc.), mnaufacturers (Lionel, MTH), Railroad (Santa Fe, Union Pacific, PRR) and condition (doesn't run, runs well, etc.).

for rolling stock I just keep a count of how many of what I have (25 PFE reefers, 16 Black Bonnet tanker cars, fourteen Santa Fe Map reefers, etc., 10 18" UP smooth sided cars).

I keep the same type of list for my diecast vehciles but that is woefully out of date since I purged about 140 vehciles late last year. Need to do that one again, too.
 

·
Registered
Joined
·
559 Posts
Lee Willis;2507154 I keep the same type of list for my diecast vehciles but that is woefully out of date since I purged about 140 vehciles late last year. Need to do that one again said:
i have a friend with thousands....its insane. he dont trackem
 

·
Registered
Joined
·
72 Posts
Even though my wife says, "If you need a computer, you have too many trains," I use the following columns for my inventory:

Manufacturer
Stock Number
Road Number
Road Name (PRR,, NYC, etc.)
Type (4-6-4, F-3, reefer, hopper, etc.)
Color/Graphic
Condition
Box (condition or none)
Where Purchased
Purchase Price
Location (display shelves, layout, boxes, etc.)
Collection (mine or either of my two sons, who store things at our house :eek:)
Comments
Photo Links (hyperlinked to a photo file)

It works for me; your mileage may vary.

Bob
 

·
Registered
Joined
·
559 Posts
Even though my wife says, "If you need a computer, you have too many trains," I use the following columns for my inventory:

Manufacturer
Stock Number
Road Number
Road Name (PRR,, NYC, etc.)
Type (4-6-4, F-3, reefer, hopper, etc.)
Color/Graphic
Condition
Box (condition or none)
Where Purchased
Purchase Price
Location (display shelves, layout, boxes, etc.)
Collection (mine or either of my two sons, who store things at our house <img src="http://www.modeltrainforum.com/images/smilies/eek.gif" border="0" alt="" title="EEK!" class="inlineimg" />)
Comments
Photo Links (hyperlinked to a photo file)

It works for me; your mileage may vary.

Bob
thx gonna use some of them. Purchase from and purchase price may not make it to my sheet lol...

weight (oz) will make it though. ive got some heavy cars being post war. my locos struggle around 7-9 cars with no incline!!!!
so im thinking to know the weight would help.
 

·
Registered
Joined
·
559 Posts
Even though my wife says, "If you need a computer, you have too many trains," I use the following columns for my inventory:

Manufacturer
Stock Number
Road Number
Road Name (PRR,, NYC, etc.)
Type (4-6-4, F-3, reefer, hopper, etc.)
Color/Graphic
Condition
Box (condition or none)
Where Purchased
Purchase Price
Location (display shelves, layout, boxes, etc.)
Collection (mine or either of my two sons, who store things at our house :eek:)
Comments
Photo Links (hyperlinked to a photo file)

It works for me; your mileage may vary.

Bob
im new to trains so please bare with me.. if I try and use part of yours... lets see...

Manufacturer
Stock Number
Road Number
Road Name (PRR,, NYC, etc.)
Type (4-6-4, F-3, reefer, hopper, etc.)
Color/Graphic


for 624 switcher id think...
Manufacturer - Lionel
Stock Number - ????
Road Number - 624
Road Name (PRR,, NYC, etc.) - Chesapeake & Ohio
Type (4-6-4, F-3, reefer, hopper, etc.) - NW-2 Switcher
Color/Graphic - Blue

so what is the difference between stock number and road number?
 

·
Registered
Joined
·
7,676 Posts
weight (oz) will make it though. ive got some heavy cars being post war. my locos struggle around 7-9 cars with no incline!!!!
so im thinking to know the weight would help.
You'll need to weight them then.....I don't think you'll find the weight any other way....

IMO, weight would not be much of an important category....:eek:hwell:
 
1 - 20 of 27 Posts
Top