Trains.com

Subscriber & Member Login

Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!

Software program for model railroad personal inventory

4813 views
34 replies
1 rating 2 rating 3 rating 4 rating 5 rating
  • Member since
    February 2010
  • From: Indiana
  • 225 posts
Posted by mikeGTW on Thursday, March 31, 2022 3:58 PM

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

  • Member since
    January 2004
  • From: Canada, eh?
  • 13,375 posts
Posted by doctorwayne on Thursday, March 31, 2022 12:35 PM

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.

Wayne

Moderator
  • Member since
    June 2003
  • From: Northeast OH
  • 17,247 posts
Posted by tstage on Thursday, March 31, 2022 12:19 PM

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.

  • Member since
    November 2006
  • From: NW Pa Snow-belt.
  • 2,216 posts
Posted by ricktrains4824 on Thursday, March 31, 2022 11:49 AM

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.

  • Member since
    December 2004
  • From: Bedford, MA, USA
  • 21,481 posts
Posted by MisterBeasley on Thursday, March 31, 2022 9:52 AM

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. 

  • Member since
    November 2013
  • 3 posts
Software program for model railroad personal inventory
Posted by CLAYTON L POST on Wednesday, March 30, 2022 7:38 PM

Does anyone know of a software program for personnal model railroad inventory?

Subscriber & Member Login

Login, or register today to interact in our online community, comment on articles, receive our newsletter, manage your account online and more!

Users Online

There are no community member online

Search the Community

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT
Model Railroader Newsletter See all
Sign up for our FREE e-newsletter and get model railroad news in your inbox!