Skip to main content

Not sure if it has been brought up before but just wondering how many people have thought or have made some type of list of all of their inventory including make, model number, pictures, msrp, ect. of everything in their collection. I thought it might be a good idea to start making one for insurance/personal information. Any thoughts? 

Original Post

Replies sorted oldest to newest

My model railroad catalog

 Instead of a "database" I have created a "catalog" page for each model.  I actually build a "web page".  The web page is then linked to an index page (which itself is linked to another index).

 This Model Railroad Catalog can be expanded indefinitely.

This allows me to have both text and photos in one place. My web page looks just like a regular catalog page with information about MSRP and date of production, etc. The nice feature is that the catalog page is in full color. The photos can also be shown as "thumbnails" which can be linked to full size photos as needed.

All the web pages and indexes are linked using "hyperlinks" so that a person can "browse" the catalog.  This catalog can also be uploaded to the web if necessary.

 A nice feature is that I can add links from each photo to a page with "prototype" photos which are depicted by the model.  I can also link to an information page which can include the price paid, date purchased and a cross-reference to a storage container number or location.

 The attachments show two different examples of a web page in my O scale catalog.

 

Attachments

Last edited by pro hobby

Not sure if it has been brought up before but just wondering how many people have thought or have made some type of list of all of their inventory including make, model number, pictures, msrp, ect. of everything in their collection. I thought it might be a good idea to start making one for insurance/personal information. Any thoughts? 

A list is a must if you want to insure your collection. It would also be helpful for your family when the time comes for them to liquidate your stuff. I don't think all the fields you list are necessary. For example, MSRP isn't particularly meaningful to me, condition and current value is. I guess that I'd include a picture of each item if I was starting my inventory today.

All of my collection has stickers placed in hidden locations or string tags with an inventory number that matches up with my records. Multi-unit diesels and steam engines /tenders have the same number so they won't be accidentally separated in a sale.

 

I'm in the midst of using a freeware database application especially designed for model train collections called "RRTrains2000". It doesn't have pre-compiled lists, but it (usually) remembers entries so you can add repeating data from drop-down lists.  It supports linking to photos (albeit one per entry) stored on the same device, and recording of obscure info such as wheel type, truck/coupler type, length, weight height, lighting, loads, command control assignments, purchase info, value, acquisition date, etc. About the only things it doesn't record are UPC codes and reporting marks.

So far I have about 350-ish items added, with an unknown quantity of partially filled-out 'placeholder' records that I'm slowly completing as I locate missing info. Pieces that have complete records are tagged as such with Post-Its indicating photographed, inventoried, and measured/weighed.

I didn't take the Excel route because none of my computers came with MS Office applications pre-installed, and they cost more to add than I was willing to spend for the use I'd get out of them.

---PCJ

There is another thread currently going on titled "Database" with discussion on / the feasibility of scanning the box bar codes with a smart phone to populate a collection list.  One forum member is working on creating such an app. There is advice in that thread as well regarding databases to use for cataloging your items.

I agree that Excel is the way to go.  For my European items I include a column that enables me to convert from pounds or euros to dollars. I also keep track of the original cost of each item.  The beauty of Excel is that it is easy to perform arithmetic operations.

My train insurance is linked to my homeowner's policy.  I send a revised report every year to my agent to adjust my insurance coverage.

It's a real pain to enter the data, but once you complete the task you will be happy you did.  And you can store the results on your iPhone or iPad.

 

Lew Schneider

bmccarron posted:

Not sure if it has been brought up before but just wondering how many people have thought or have made some type of list of all of their inventory including make, model number, pictures, msrp, ect. of everything in their collection. I thought it might be a good idea to start making one for insurance/personal information. Any thoughts? 

This comes up every few months or so. The general consensus seems to be using Excel. A few, including me, use Microsoft Access or other relational database for more flexible reporting and image handling. I put a front-end on mine as a tool for a database class I was teaching at the time. One of these years I'll put some code behind it to speed it up and make adding images more efficient.

.Opening_Screen

Attachments

Images (1)
  • Opening_Screen

Yes this does come up often on here and the majority of responders seem to use Excel.    

I use Excel also and about 5 years ago started adding linked photos of items already listed.  When I get something new I take its picture and add the item and its photo link to the spreadsheet.

But I realize Excel isn’t for everyone.

Bill   

Last edited by WftTrains
Timothy Sprague posted:

been using excel spreadsheets for about 12 years. I use it for work, so it was easy for me to to apply it to the hobby. Just last year I started adding images, see the pdf sample attached, or the small jpeg image.

Tim

Inventory_sample

I also use an Excel spread sheet, but the idea of adding the photos is a good one.  I'll be doing that too!  I also have two spread sheets.  You never know...  One with prices paid and a column with what they're worth (going down all the time) and another with no prices listed.  They includes manufacturer, car number, number on the item and condition.  

Last edited by poniaj
poniaj posted:
I also use an Excel spread sheet, but the idea of adding the photos is a good one.  I'll be doing that too!  I also have two of them.  One with prices paid and prices of worth (going down all the time) and another with no prices listed.  You never know..

Jerry:

Why not just put the prices in hidden columns then you would only need to maintain one spreadsheet?

Bill

I also use Excel, have done so since 1999.  I do have separate files for different purposes.  I keep two different files of photos, one when the item is purchased (with jpg number, in chronological order) and a second with pics in manufacturer/catalogue number order.  In Excel, I have each item listed by  maker with cat. no., description, box/master, value, number of items, IM (jpg) number reference.

I find it very easy to add to as necessary, access and acquire information, revise as needed.

Jesse  TCA

Attachments

Images (4)
  • IM00045 K Line K3270-5344W NYC Hudson Scale O engine: IM00045
  • IM00046 Lionel Mod 6-14179  TPC 400: IM00046
  • IM000052  Lionel Post 55 Tie Ejector w box,paper,ties,trips: IM00052
  • IM000173 Lionel Mod 6-31716 CCII Niagara Milk Train set w inst, boxes, master cartons: IM000173

Thanks everyone for the feedback. I guess I have missed other peoples posts about this subject because I come on here quite often and don't remember coming across this. I am glad to see that there are a good handful of people that keep a record of their inventory and I will definitely be starting one for myself. By chance anyone use google docs/spreadsheet?

Like a lot of others here, I also use excel - partly because I already have it and know my way around using excel pretty well.  I thought about a database tool, but just about the time I thought I'd try it, Apple stopped supporting Bento and I didn't want to fight my way up the Filemaker pro learning curve.  I have several columns of information and have created several worksheet tabs that are basically different sorts on those columns (like road name, type of car or loco (flat, gon, etc.).  The only disadvantage of this is 'version control' - I often add items to the master list before I go through and update the various sorted lists, so I've found that the best way to do this is to have one of the cells near the top of each spreadsheet reserved for the date of the last update.

Adding a link to photos is a good idea, as several others have mentioned - I haven't yet figured out how to do that (or how I want to do it...).

In my Excel format item(s) listing, the value I include is representative of as new price/replacement value, as this is what would be necessary for insurance purposes.  This listing is easy to upgrade / update when necessary.  My inventory lists also include vehicles and buildings/accessory items as they, too, are part of the complete collection.

Jesse    TCA

 

Attachments

Images (2)
  • IM002347  Hallmark Depot Oceanside #QHT3501: IM Inventory picture related to listing
  • Im001839 Corgi 51201 57 Chevy Fire Chief car: IM Inventory picture related to listing
Files (2)
Various Mfg Scenics items
Corgi Vehicles
Last edited by texastrain
RailRide posted:

I didn't take the Excel route because none of my computers came with MS Office applications pre-installed, and they cost more to add than I was willing to spend for the use I'd get out of them.

---PCJ

Open Office costs exactly nothing.  Its spreadsheet application works just fine, and will save files in Excel format.  Works under Windows, OSX and Linux.  I haven't used MS-Office for ten years.

 

I used Excel for a while and agree it is one of the easiest answers for keeping a simple list of what you own; it's certainly a good starting point if you already have the application.  After a while I wanted to do things like easily cross reference items in my collection based on different types of information, prevent duplicate entries, perform automatic updates when things change, create picture catalog views, etc. While these things can be done in Excel, the process became less straightforward as my needs and collection grew. This pushed me to create a more sophisticated database using FileMaker. I probably could have used one of the commercially available solutions mentioned here on the Forum, but I already own FileMaker and didn't mind the effort involved in building my own solution.

I use Excel for all of my collections. It is easy to use and the file sizes are small. I started taking pictures of everything, but that was not practical for me as I have way too much stuff to take pictures of, so I quit shortly after I started. I use enough columns with descriptions and color code them to make it easy to identify each piece.

Add Reply

Post

OGR Publishing, Inc., 1310 Eastside Centre Ct, Ste 6, Mountain Home, AR 72653
800-980-OGRR (6477)
www.ogaugerr.com

×
×
×
×
Link copied to your clipboard.
×
×