Does anyone have an Excel Template for inventorying Your trains and accessories including everything?
Replies sorted oldest to newest
Your definition of "everything" and mine might be different! I could send you mine but you have to know a little about excell to use it. I would need to strip it down, so the pages are not so big. Let me know via email.
I use Excel too, but mine entries are simple stuff. I know I can add photos, just haven't done it yet. All in good time!
Here is the format I use. You can add or delete columns. I don't add photo's.
Steve
Attachments
Thank you everyone. For those who did not include their format I have emailed you. If you did not get the email please let me know. I appreciate all of your help.
Curtis
prrjim posted:Your definition of "everything" and mine might be different! I could send you mine but you have to know a little about excell to use it. I would need to strip it down, so the pages are not so big. Let me know via email.
I'm also interested in an excel template to inventory my o gauge trains, accessories etc.
I have not gotten no emails from you Greg and I can't find your email address on the OGR. Also, I never got an email from Curtis.
I will send a copy of my excel sheet to you if you email me.
I use Yard Office model train inventory. It’s a free download. No expiration or time limits. Fully functional. If you like it you can pay them or not. Your choice. It’s very detailed. I think it’s great. Try it . Nothing to lose, it’s free.
http://www.musicmixradio.com/yardoffice/
Understand that Excel is not a relational database program, and that is what you really need to do this. It’s not the right tool for the job.
A simple list of items can be built in Excel, but it is impossible to get any meaningful reports out of Excel. There are other, vastly superior database programs out there that work better and are easier to use.
Download and try the Yard Office program that Patrick1544 posted. MUCH better than anything you’ll find built in Excel.
Curt,
Patrick and Rich are correct; get a database. I use Access because I bought it cheap through a military program. It is great for quickly searching my inventory for whatever reason. A free one that is already set up, like Patrick1544’s, is the way to go.
What I'd like to see is a package that knows about the stock numbers of major manufacturers. So when you enter Lionel 6-11449 it fills in all the description stuff and even a picture. Then you can edit to suit your situation. That would take care of a lot of typing and make starting a large inventory much simpler.
JOHN - You're talking about the old TrainTracker program. It had a lot of drop down boxes to choose under each classification. It still works as long as you have Microsoft XP. It wouldn't load onto Windows 8 or Windows 10.
Yep, but Windows XP has sailed into the sunset, so I have to look for something else.
CaPPilot
Screenshot sample of one of my entries . Note: When you open the program, just disregard registration. Press "Start" and the "To The Trains" button on the next page.
Attachments
For those of you with programs that will only run under older versions of some operating system, please know that you can run that older system in a Virtual Machine (VM) running under the latest operating systems. A VM is, essentially, another computer running in the memory of your current (real / touch it) computer which still allows you to save your data to your real hard drive or SSD. Windows XP and other older versions of Windows can still be found on the internet and can be used for short periods of time in your VM of choice. You should also be able to install working programs like TrainTracker within your VM.
The only drawback to this is you must start all over with installing the software in your VM when the time limit runs out. But your data is still safe on your hard drive or SSD if you save it properly.
Chuck
I agree with Rich about the advantages of a Database program over spreadsheet software.
But what I don't like are these dedicated database programs that go undeveloped for years and no longer work with modern computers & operating systems. This is why spreadsheet programs like Excel are popular because they never really go obsolete, not mention these programs are cheap. Heck, I was able to import my dad's train inventory spreadsheet he did on SuperCalc 4 back in the early 80's into Excel 2019!
Now if someone has an inventory program that was developed with MS Access (and even better, can be run with the FREE runtime version of Access), I think you would have the best of both worlds. MS Access isn't going away anytime soon and you have your inventory in a much more usable database format.
Hi Guys,
Trainz Auctions offers a free online inventory program that ties into their database, so you get pictures, description and even auctioned value range. I like that you can download it to Excel so you always have a backup. I've bought stuff from them and you can automatically add those items to you inventory. It's functional for my needs. I hope that helps,
G
One of the obvious advantages of Excel (or any spreadsheet) for an inventory record is that you can customize the columns to include not only catalog numbers and descriptions but also any other distinct characteristics that are important to you.
You can obviously do that with a database as well Bob. If you're talking about "canned" applications, that's different, but if you use Microsoft Access and build it with that, it's more flexible than Excel.
One of the problems of software in our hobby including inventory, track planning, signaling, etc. is that many of these products are the work of a single person. As long as that person stays involved these products grow and improve with time and are supported. Sometimes that person gets sick or has change in life's circumstances and s/he turns away from the software and it ceases to evolve and support becomes minimum and declines over time. Thus a program that requires Windoz XP. The size of the market makes it tough for professional software company to have a team on it.
The idea of having an inventory program with a database of all trains would be an enormous project requiring constant updating. Think of the scope of the Greenberg books. Very cool feature to have.
Excel is not a relational database, but one can still do a lot with it. A lot is in how it is set up. Many people (including me at first) have a tab for engines, one for cars, etc. This limits reporting. Excel has a number of intrinsic database functions, such as "filter and sort", "Find Duplicates", etc. These are designed for the master data to be in a single sheet. Some codes are needed to allow for sorting and reporting. Thus, if one creates a column such as "Type" with values of "Engine", "Coach", "Accessory", etc. the database functions of Excel can do some reporting. A column with color would allow one to answer a question such as "How many engines and coaches do I have that are red?" One would have to do some studying of these database functions to make good use of them. Its clunky dealing with pictures, but possible.
Bill