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!

Train Inventory Software

35203 views
62 replies
1 rating 2 rating 3 rating 4 rating 5 rating
  • Member since
    April 2016
  • 4 posts
Train Inventory Software
Posted by PRR01 on Sunday, January 28, 2018 9:32 PM

 

Are there any useful train inventory software programs?  I am looking for something a step up from Excel.  A lot of the discussions I found on MR or google are really old, and links to many systems don't exist.  

 

  • Member since
    December 2004
  • From: Rimrock, Arizona
  • 11,251 posts
Posted by SpaceMouse on Monday, January 29, 2018 4:36 PM

PRR01
I am looking for something a step up from Excel.

What do you consider a step up from Excel? What is your purpose in having a train database? Are you interested in having a nicer input screen, or are you looking for something that will track operations across you layout? Because if you are just looking to store data about your equipment, you are just going to have a data table--which is something Excel excels at. 

Chip

Building the Rock Ridge Railroad with the slowest construction crew west of the Pecos.

  • Member since
    August 2006
  • From: Franconia, NH
  • 3,130 posts
Posted by dstarr on Monday, January 29, 2018 4:50 PM

I use Excel.  It makes a data base that I can use.  I keep things like prototype length in feet, purchase date, reporting marks, maintenance history, purchase price, and more.  Excel will sort on anything in the database.  And from using Excel in my old day job, I a pretty familiar with it.  And you can embed BASIC code in an Excel spread sheet to do just about anything.

  • Member since
    January 2009
  • From: Bakersfield, CA 93308
  • 6,526 posts
Posted by RR_Mel on Monday, January 29, 2018 4:55 PM

I agree with Mouse and David, if you just want to inventory your model railroad equipment Excel works great.
 
 
 
 
Mel
 
Modeling the early to mid 1950s SP in HO scale since 1951
  
 
My Model Railroad   
 
Bakersfield, California
 
I'm beginning to realize that aging is not for wimps.
  • Member since
    December 2004
  • From: Rimrock, Arizona
  • 11,251 posts
Posted by SpaceMouse on Monday, January 29, 2018 5:00 PM

RR_Mel
I agree with Mouse

Take note people. Having someone agree with me just doesn't happen every day.

Chip

Building the Rock Ridge Railroad with the slowest construction crew west of the Pecos.

  • Member since
    January 2004
  • From: Canada, eh?
  • 13,375 posts
Posted by doctorwayne on Monday, January 29, 2018 5:07 PM

I did a multipage inventory using Excel (with some help from my daughter).  I like the fact that I can update it at any time, even on my Mac, which doesn't otherwise seem to play very well with MS Word.

Here's a partial screenshot...(click on it for an enlarged view)

It also allows me to keep track of all of the home road cars I've owned over the years, so that a car number is never duplicated unless I know for sure that the original has been destroyed.

Wayne

  • Member since
    August 2006
  • From: Nashville, TN area
  • 713 posts
Posted by hardcoalcase on Monday, January 29, 2018 8:35 PM

 

I've used Excel too, and have found it to fill every record keeping need. I print a copy of the freight car inventory to take to train shows to avoid buying duplicates.

 

I'm in the process of programming Excel to inspect the cars, clean the wheels and correct coupler height as needed, but progress has been slow. Smile, Wink & Grin

Jim

 

 

 

  • Member since
    November 2006
  • From: NW Pa Snow-belt.
  • 2,216 posts
Posted by ricktrains4824 on Monday, January 29, 2018 10:16 PM

Excell spread sheet.

Just easy, and no extra software costs, as it came with my purchase of office.

I have one sheet loco's, one sheet freight cars, one sheet electronics and trackage, and one sheet "accessories", which is anything that doesn't fit the other categories listed. (Buildings, automotive models, tools, etc...) 

Yes, other programs allow photos to be included, but, no big deal for me there.

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 2005
  • From: Franklin, OH
  • 153 posts
Posted by rrlcommish on Monday, January 29, 2018 10:44 PM

Excel is best, Access would be overkill.  It would be pretty easy to write some simple VBA (i.e. macros) and use a basic userform to make data entry easier.  That way you wouldn't have to put it all in rows and columns, the macro/userform would do it for you.

  • Member since
    February 2008
  • From: Potomac Yard
  • 2,767 posts
Posted by NittanyLion on Monday, January 29, 2018 10:52 PM

I go another step and use Google Sheets.  That way I can look something up on the road.

  • Member since
    July 2006
  • From: Chamberlain, ME
  • 5,084 posts
Posted by G Paine on Monday, January 29, 2018 10:54 PM

At Boothbay Railway Village, we use Easy Model Railroad Inventory. It is a freeware program.

http://easy-model-railroad-inventory.software.informer.com/5.4/

 

George In Midcoast Maine, 'bout halfway up the Rockland branch 

  • Member since
    July 2006
  • From: Bradford, Ontario
  • 15,797 posts
Posted by hon30critter on Monday, January 29, 2018 11:20 PM

I use 'Yard Office'. It is a free inventory program designed specifically for model railroaders. I liked it enough that I bought the upgrade. The program is set up to allow you to store just about any information about each piece of rolling stock that you could want. It also allows you to attach multiple pictures to each listing.

http://www.musicmixradio.com/yardoffice/

Note that the Yard Office home page isn't displayed properly when I use Chrome. There is some overlapping text. You may have to try another browser.

Dave

I'm just a dude with a bad back having a lot of fun with model trains, and finally building a layout!

  • Member since
    February 2002
  • From: Reading, PA
  • 30,002 posts
Posted by rrinker on Tuesday, January 30, 2018 7:14 AM

I use Dave Husman's CarCard Generator which does a whole lot more than car cards, it has a full and detailed inventory of locomotives and rolling stock as well as structures and other model railroad items. PLUS it does the car cards and waybills and switch lists for operation, if you so desire.

Old? So what? It's a model train inventory, what has changed in 10 years? Being a niche within a niche within a niche, model train inventory software isn;t under the pressure to add umpteen new features every couple of years like more mainstream stuff like word processors and spreadsheets. As such, the software is stable and relatively bug free as the authors concentrate on making sure it works instead of adding feature after feature that hardly anyone needs.

                                     --Randy

 


Modeling the Reading Railroad in the 1950's

 

Visit my web site at www.readingeastpenn.com for construction updates, DCC Info, and more.

  • Member since
    May 2010
  • From: SE. WI.
  • 8,253 posts
Posted by mbinsewi on Tuesday, January 30, 2018 7:30 AM

PRR01
Are there any useful train inventory software programs?

Wow, I wouldn't know where to begin doing this.  I never have.  So much has come and gone.

It just always seemed so unimportant to me, way too much "bookkeeping".  I guess what shelves and boxes of stuff I have, must fail in volume comparison as to what many of you have, that you need an inventory program to keep track of it all.

I know one thing, that if I was to start a list, or inventory, I would use any one of the office programs, such as Excel, that I already have on my computer(s).

Good luck PRR01 with your "inventory control".

Mike.

 

  • Member since
    July 2006
  • From: Springboro, Ohio
  • 201 posts
Posted by ripvanwnkl on Tuesday, January 30, 2018 8:08 AM

I use free "My Railroad Apps" menu on Dallas Model Works website.  Can be as simple or detailed as you want.  

Dave

USAF (Retired)

 

  • Member since
    February 2002
  • From: Reading, PA
  • 30,002 posts
Posted by rrinker on Tuesday, January 30, 2018 9:32 AM

 I'm not sure what size of collection has to do with an inventory program (OK if you only have 1 loco and 4 cars, you probably DON'T need an inventory program).  In addition to having a full list of everything I bought (which is stored on my server, which is backed up to a cloud backup, thus it will survive any disaster that should happen to my home), which would come in very handy for insurance purposes (some day I will get around to having a full photo roster as well), I added my own report to the database (which wasn't int he odler versions, but is now) that makes a small rather high density list of road names and numebrs that I can take along to train shows and keep from buying duplicate equipment.

 There are fields in this database to record what you paid for a piece, what it might be worth now, and other stuff like what kind of couplers it has (I use all Kadee, but not everything takes a #5 or #148), what kinds of wheels (I repalce all plastic wheels with metal, but there are several kinds, plus a subset of my rolling stock has resistor wheelsets to active the detection system at the club - eventually all will be so equipped as I will be installing detection and signalling on my layout). Plus many other things that I don't necessarily use. When I come home with some new kits, one of the first things I do is enter them into the database, using one of the notes fields to indicate "unbuilt kit", which gets removed once I get around to building it. It's extremely useful to know what you have, and in many cases, when you got it.

                                --Randy


Modeling the Reading Railroad in the 1950's

 

Visit my web site at www.readingeastpenn.com for construction updates, DCC Info, and more.

  • Member since
    April 2016
  • 4 posts
Posted by PRR01 on Tuesday, January 30, 2018 9:52 AM

 

Great questions!  

 

  • My model railroad is in between versions 2.0 and 3.0 so a lot of my rolling stock is put away. I want to start planning ahead, so I need to see what I have, what needs to be sold, and what gaps I have that I need to purchase while the layout is under construction, etc
  • I like to see visuals - what type logo, quality of the unit, how it is weathered, etc
  • I use Excel a lot so I understand a lot of this information could be placed into a table, but a picture is worth a 1000 words.
  • Member since
    April 2016
  • 4 posts
Posted by PRR01 on Tuesday, January 30, 2018 9:57 AM
I like this idea. Thank you for expanding my thought process as maybe I am not thinking far enough out into the future. While operations is down the track, as I am still in construction, killing two birds with one stone has a lot of appeal. Not only will I have an inventory but cards or waybills will already be integrated into the system.
  • Member since
    March 2017
  • 129 posts
Posted by Canalligators on Tuesday, January 30, 2018 11:22 AM

I would go back a step, and ask why have an inventory at all?  I used to keep my inventory (homemade Access tool), but I wasn't using the information for anything. My intent was to keep a maintenance history, so it could generate a list of pieces that were due for service, but I spent a lot of time entering info when I was just giving things an annual once-over anyway.  And all the bad ordered bits are parked on a service lot anyway.

I guess there's an attraction to having a nice list.  Or if you do a lot of buying and selling, being able to keep track of what is available to sell/barter.  I've gotten over wanting a nice list and don't do a lot of equipment changes.

Keep an inventory if you like, but only if you have a good use for the data.  Otherwise you're pounding in info and updates with no return benefit.

Genesee Terminal, freelanced HO in Upstate NY
  ...hosting Loon Bay Transit Authority and CSX Intermodal.  Interchange with CSX (CR)(NYC).

CP/D&H, N scale, somewhere on the Canadian Shield

  • Member since
    January 2004
  • From: Canada, eh?
  • 13,375 posts
Posted by doctorwayne on Tuesday, January 30, 2018 2:31 PM

Canalligators
I would go back a step, and ask why have an inventory at all?....

I had a couple of reasons for creating an inventory.  One was to keep track of all my free-lanced home road equipment.  Stuff suitable for the '50s, '60s and early '70s has all been sold-off or given away, but I don't want to re-use numbers, just in case I do another era change and the same friends (or strangers) buy stuff with numbers identical to what they bought last time.

My other reason for an inventory was to aid in disposal of stuff after I go for that last train ride.  A friend and I have a mutual agreement to take care of that for the first one of us out of the picture.  It just makes things a little simpler, and that's the only reason I included prices in mine - not as if he has to get that price, but only to ensure that he doesn't over-value things, as he's commented, more than once, that the numbers are too low.  The whole idea is to get rid of it, so I disagree.

A minor consideration, especially for the models of prototype rolling stock and locomotives, is the record of car types and, more importantly, car numbers.  It's much easier to check the written record than to go through hundreds of boxes just to make sure that I'm not lettering a new boxcar with the same number as one already on the layout.
With my luck, I'd post a photo here of a train on my layout, with two identically-numbered cars coupled to one another, and not notice it until 27 others had pointed out my error....sorta negates the reason for choosing to letter almost all of my rolling stock, rather than go with factory paint and lettering.

Wayne

  • Member since
    February 2004
  • From: Elyria, OH
  • 2,586 posts
Posted by BRVRR on Wednesday, January 31, 2018 9:12 AM

I use a program called RRTrains2000.

It provides a listing/form that includes Model, RoadName,Number, Color, Scale, Era, Category, Type, Coupler DCC?, Manufacturer, Catalog Number, Date purchased, and Value. There is also a place for a photograph.

The program is easy to use and best of all its free. Here is the link, just scroll down the page to RRTrains2000.

http://www.gregorybraun.com

Tags: BRVRR

Remember its your railroad

Allan

  Track to the BRVRR Website:  http://www.brvrr.com/

  • Member since
    January 2002
  • From: Hilliard, Ohio
  • 1,139 posts
Posted by chatanuga on Sunday, February 4, 2018 1:48 PM

Canalligators

I would go back a step, and ask why have an inventory at all?

For me, it's mainly to keep a record of what all I have should the unthinkable happen and I have to replace anything.

Several years ago, I purchased a model railroad database program called Train Track.  It worked great, but I could only install it on either my PC or my laptop.  I chose my laptop since I could take it down to the basement with me.  Last year, I had to upgrade my PC and later my laptop since they were unable to go past Windows XP.  I got a new PC and laptop running Windows 10.  I went to contact the place I'd gotten Train Track from before, but they're apparently no longer around.  I was going to keep my old laptop for just the database, but video going out on the laptop forced me to get screenshots of the rolling stock records before retiring the laptop.

When I'd purchased the new laptop, I'd also purchased the full version of Office 2016 through my company's home use program where we could get one copy of it for only $10.  With it came Access 2016.  I'd never used Access before, but after watching tutorial videos for Access on YouTube, it really isn't difficult to use.  I've been able to recreate the original database with little effort, even customizing it to include maintenance/service records for my locomotive fleet.  By learning Access, I've also found other uses for it with my inventory of books, DVDs, CDs, etc. around home, which I already had on Excel spreadsheets but have since converted.

Kevin

  • Member since
    February 2009
  • 1,983 posts
Posted by railandsail on Monday, November 5, 2018 6:59 AM

G Paine

At Boothbay Railway Village, we use Easy Model Railroad Inventory. It is a freeware program.

http://easy-model-railroad-inventory.software.informer.com/5.4/

 

 

I was really surpried that this one was only mentined once in this subject thread? On another forum it came highly recommended.

https://easy-model-railroad-inventory.software.informer.com/5.4/

  • Member since
    February 2008
  • 2,360 posts
Posted by kasskaboose on Monday, November 5, 2018 7:06 AM

Having started to inventory my small fleet, I found Excel works fine.  Excel provides what I need to then convert the list to car cards and way bills.  These tools help me to create more operations than simply keeping track of the cars.

The questions to ask are why you need an inventory system?  How much time you plan on spending in updating it?  Want something free or with a cost?  Should you want something quick, flexible, and free, go with Excel.

PED
  • Member since
    April 2016
  • 571 posts
Posted by PED on Monday, November 5, 2018 8:14 AM

This is an old thread that has been brought back to life so l will throw in my approach. Like many, I used Excell for many years and it worked well for me. But then I started implementing JMRI OperationsPro. Since OpsPro also has a car inventory feature included and it is a required element to run OpsPro, I decided I did not want to maintain two seperate inventories. I am still in transition but when I am done, my OpsPro inventory list will be my only list. I can still export my OpsPro list to an Excell sheet any time I want if I want an Excel version to look at. The only flaw in this approach is that the OpsPro file does not allow as many fields to play with as I do in Excel.

Paul D

N scale Washita and Santa Fe Railroad
Southern Oklahoma circa late 70's

  • Member since
    July 2006
  • From: Phoenix, AZ
  • 1,835 posts
Posted by bearman on Monday, November 5, 2018 10:55 AM

I have used JMRI and Easy Model Railroad Inventory (EMRI).  EMRI is also freeware available on the internet.  I have been frustrated with both, so I have gone back to using Excel and am happy as a clam.

Bear "It's all about having fun."

  • Member since
    January 2017
  • From: Southern Florida Gulf Coast
  • 18,255 posts
Posted by SeeYou190 on Monday, November 5, 2018 11:07 AM

I don't think anything can do a better job of a simple inventory sheet than Excel does.

.

-Kevin

.

Living the dream.

Moderator
  • Member since
    June 2003
  • From: Northeast OH
  • 17,247 posts
Posted by tstage on Monday, November 5, 2018 11:12 AM

Another vote for Excel.  I can also use it on my cellphone, which makes it handy and convenient to check when I'm out n' about at a train show or 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
    February 2009
  • 1,983 posts
Posted by railandsail on Monday, November 5, 2018 1:43 PM

What would the equivalent program be in Open Office suite?

 

Moderator
  • Member since
    June 2003
  • From: Northeast OH
  • 17,247 posts
Posted by tstage on Monday, November 5, 2018 6:35 PM

Brian,

You want Calc:

https://www.openoffice.org/product

Tom

https://tstage9.wixsite.com/nyc-modeling

Time...It marches on...without ever turning around to see if anyone is even keeping in step.

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!