Wayne
I'm looking to do the same using excel So did you use a preset or did you design your own sheet
Thanks Mike
Same here...(Click on the photo to yield a legible image)
...with lots of options on how you want to organise the info. I have several such pages to keep track of freight, passenger, MoW equipment, and locomotives.
I'm also an MS Excel user and proponent. It's very customizable and the inventory spreadsheet is easily accessible from my smartphone when I'm at a train show or my LHS.
Tom
https://tstage9.wixsite.com/nyc-modeling
Time...It marches on...without ever turning around to see if anyone is even keeping in step.
Another Excel vote here.
Alrhough with the advent of smart phones, I can one-up Mr.B, by having the online copy on me (via smart phone) with a few taps of my finger.
On rolling stock, I break it down by roadname, type, then road number. (Example: NS - 100T TopGon Coal Gondola - 23164 - BLMA) I then add custom notes, such as any modifications like weathering, and a column for things like custom paint and decal work, upgrades to details, etc...
Motive power I break down similarly, but with less I can organize by roadname and unit number at once, such as NKP765, and add in things like decoder model, and maintenance schedule for lube and clean, etc...
Plus on all entries, I also include a column for MSRP and price paid, if a prototype photo of exact road number is located on a website or my railfan photos, and any known issues.
I also keep in that same file a list of "look for" items, like new releases of rolling stock with preference of certain road numbers, and a active inventory of decals, paints, things like extra couplers, wheel sets, etc...
Ricky W.
HO scale Proto-freelancer.
My Railroad rules:
1: It's my railroad, my rules.
2: It's for having fun and enjoyment.
3: Any objections, consult above rules.
I still use Microsoft Excel to make spreadsheets. Rolling stock is easy, and I always bring a paper copy of the spreadsheet to train shows as it helps prevent me from getting duplicate road numbers.
I like the flexibility of being able to customize the columns on my locomotive roster to include CV settings.
It takes an iron man to play with a toy iron horse.
Does anyone know of a software program for personnal model railroad inventory?