Creating an Excel Inventory
1 - 20 of 27 Posts
Joined
·
1,546 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
- 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
Joined
·
220 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.
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
Joined
·
917 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.
I also have a column for Catalog (e.g. 2018 Lionel Vol. 1) and I have a column for Mininum Radius.
Joined
·
9,965 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.
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.
Joined
·
96 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
)
Comments
Photo Links (hyperlinked to a photo file)
It works for me; your mileage may vary.
Bob
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
)Comments
Photo Links (hyperlinked to a photo file)
It works for me; your mileage may vary.
Bob
Joined
·
5,820 Posts
I just keep it in my head. If I can't do that, I have too many.
Joined
·
585 Posts
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.
Joined
·
585 Posts
im new to trains so please bare with me.. if I try and use part of yours... lets see...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
Comments
Photo Links (hyperlinked to a photo file)
It works for me; your mileage may vary.
Bob
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?
Joined
·
15,393 Posts
Stock number is the manufacturer's part number, or inventory number....
Joined
·
15,393 Posts
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....
hwell:1 - 20 of 27 Posts
