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!

Documentation Survey

4019 views
50 replies
1 rating 2 rating 3 rating 4 rating 5 rating
  • Member since
    November 2013
  • 2,771 posts
Posted by snjroy on Friday, February 22, 2019 9:07 PM

I have been thinking about this thread and it struck me this morning that what I would really use is a system to organize and list my spare parts. Has anyone done that?

Simon

  • Member since
    July 2006
  • From: Bradford, Ontario
  • 15,797 posts
Posted by hon30critter on Saturday, February 23, 2019 7:02 AM

snjroy
I have been thinking about this thread and it struck me this morning that what I would really use is a system to organize and list my spare parts. Has anyone done that? Simon

My spare parts are organized (sort of) and I know where to look when I want one, but to list them?!? Doing that would create far more work than it would be worth AFAIC. Besides, if I forget what I have in stock it is always a great surprise to discover the things that I forgot I had! That's one of the pleasures of growing old! Senility has its benefits!!Smile, Wink & Grin

Sorry Simon, I couldn't resist taking a shot at my aging memory! No disrespect intended.

Cheers!!

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
    May 2010
  • From: SE. WI.
  • 8,253 posts
Posted by mbinsewi on Saturday, February 23, 2019 7:12 AM

I haven't documented anything, porbably never will, but I know where I keep parts.  I have 3 tackle boxes full of small detail parts, and a Tubberware style small chest of drawers I keep all locomotive parts.

Mike.

  • Member since
    August 2003
  • From: Collinwood, Ohio, USA
  • 16,367 posts
Posted by gmpullman on Saturday, February 23, 2019 7:15 AM

I have an awful time trying to get "organized". I have dozens of various drawer and container bins and I get part-way through sorting, labeling and filing then I see a pretty color, or hear a train go by and get all distracted.

I recently set out to sort and file my decal collection. One helpful aid I found were these reasonably priced accordion hanging file folders. 

https://www.amazon.com/gp/product/B075SFNS5X/ref=ppx_yo_dt_b_asin_title_o03_s00?ie=UTF8&psc=1

The pockets have no gaps so if an errant little decal piece slips out of the envelope it stays in the pocket. I have a hanging file drawer so these tuck right in them when not needed.

Regards, Ed

 

  • Member since
    October 2001
  • From: OH
  • 17,574 posts
Posted by BRAKIE on Saturday, February 23, 2019 8:08 AM

Bear,Iuse to keep a tally book on the models I owned but,gave up on that after that book was lost in the Bucyrus flood of '07.

I sold my 95 era cars and locomotives save for the OC GP7,C&O RS-1,SCR SW8 and the Summerset SW1500.

As of now I have 2 40' boxcars,1 40'  Santa Fe reefer and a United Models Santa Fe 1950 Class 2-8-0. All of the cars are Accurail kits awaitig me to build them..

Larry

Conductor.

Summerset Ry.


"Stay Alert, Don't get hurt  Safety First!"

  • Member since
    September 2003
  • From: Omaha, NE
  • 10,621 posts
Posted by dehusman on Saturday, February 23, 2019 8:40 AM

I created an MS Access database app to inventory my rolling stock in order to make car cards and waybills for my layout.   The full blown version has the ability to inventory and document a lot of stuff.  I don't actually document as much as I should or could.

I don't inventory unbuilt kits or parts, but I do try to organize them, I have a bunch of those little plastic "drawer" systems that I stor parts in and I have labeled the drawers to be able to find stuff.  I built a rack  that fits in a desk drawer to organize plastic and wood strips (2x, 4x, 6x, .020x, .040x, .080x, rod, etc)

My Access databases are available here on my website:

https://wnbranch.com/home/operations/operations-car-forwarding/

Dave H. Painted side goes up. My website : wnbranch.com

  • Member since
    August 2006
  • From: Nashville, TN area
  • 713 posts
Posted by hardcoalcase on Saturday, February 23, 2019 1:24 PM

SeeYou190

I keep an extremely accurate listing in Excel.

I did not keep track of the price paid.

-Kevin

That's an excellent strategy... after all, your wife might find it! Big Smile

Jim

  • Member since
    October 2006
  • From: Western, MA
  • 8,571 posts
Posted by richg1998 on Saturday, February 23, 2019 4:15 PM

I use to use OpenOffice for Microsoft and Linux for some years. Free download.

I now use LibreOffice for both systems, also free download.

Both very good Office software.

Rich

If you ever fall over in public, pick yourself up and say “sorry it’s been a while since I inhabited a body.” And just walk away.

  • Member since
    November 2006
  • From: NW Pa Snow-belt.
  • 2,216 posts
Posted by ricktrains4824 on Saturday, February 23, 2019 8:40 PM

Yes, but no.

I have a Excell spreadsheet for loco's, where I track make, any mods, and what type of decoder is installed. I also track approxaimate price. (Loco and decoder prices, combined and rounded to nearest dollar amount. No need to be exact here.)

I keep a seperate sheet for rolling stock, which is roadname, number, type and manufacturer, as well as MSRP.

A 3rd sheet tracks all major parts and pieces, like DCC system, throttles, and major components as well as MSRP.

I have not updated for a while though, so my newest items are not included...

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
    January 2017
  • From: Southern Florida Gulf Coast
  • 18,255 posts
Posted by SeeYou190 on Saturday, February 23, 2019 10:46 PM

gmpullman
I recently set out to sort and file my decal collection.

.

Ed,

.

I sorted and catalogued my decal collection in 3 by 5 glassine envelopes. I put an index card in each one and typed the decal information on the card. I sorted the decals into these six metal file drawers.

.

All I found out, was that I have enough decals for five to ten lifetimes.

.

.

-Kevin

.

Living the dream.

  • Member since
    March 2016
  • 1,553 posts
Posted by PRR8259 on Sunday, February 24, 2019 12:21 AM

Since at times I have changed my mind and then changed out entire rosters, I just don't bother documenting the history of the locos on my layout.  Knowing what year I bought them is usually good enough for me.  I have run engines until they've worn out, just none lately have.  You really gotta put a lot of mileage on these engines today to get to any kind of serious mechanical issues, imo.

Right now my son and I have 13 diesels between us, and all of them save one happen to be new in the last couple months (traded away/replaced others).  These I'm planning to keep.  They were also, generally, much more affordable than previous power as only one unit at all has sound/dcc.  It was ordered by mistake instead of plain dc version.

The engines from my childhood--from the first 10 years or so of my being a "model railroader"--I can remember them all, what holiday or special occasion I received them for, and in what year I received them.  They were pretty well used up, and only one Mantua trolley survives.  I still have it and it runs just fine, after approximately 44 years of age.

The other engines were mostly more toys than models.  They accumulated a lot of miles on them, but are better remembered in my mind the way they were than the replacement items I could still pick up at train shows, that seemingly have "inferior" factory paint jobs to how I remembered most of mine looking.

Those were good years and I do have very fond memories of all the Mantua, earlier Athearn (but after the rubber band drive), Model Power can motored shark, and even one Tyco diesel.  I had the Athearn "Santa Fe" pinstripe blue and yellow scheme U30B until I found out that Santa Fe never owned them, and traded it away.

In hindsight, I sorta wish I had that one back.  It would be a conversation piece.

Guess you could say there wasn't a diesel I haven't liked or owned from NW-2's and SW-1500's to the DDA40X.

John

  • Member since
    November 2013
  • 2,771 posts
Posted by snjroy on Sunday, February 24, 2019 10:20 AM

hon30critter
 

 

 
snjroy
I have been thinking about this thread and it struck me this morning that what I would really use is a system to organize and list my spare parts. Has anyone done that? Simon

 

My spare parts are organized (sort of) and I know where to look when I want one, but to list them?!? Doing that would create far more work than it would be worth AFAIC. Besides, if I forget what I have in stock it is always a great surprise to discover the things that I forgot I had! That's one of the pleasures of growing old! Senility has its benefits!!Smile, Wink & Grin

Sorry Simon, I couldn't resist taking a shot at my aging memory! No disrespect intended.

Cheers!!

Dave

 

No offense taken Dave, I use the same approach! I have recently started to box things together - I have a Mantua box, Bachmann box, etc. Maybe I should just attach little labels with a string on the most important pieces, like motors with a worm attached. I also have spare locomotives in their boxes that I keep for parts. But I'm sure I will forget about these sooner or later. Anyway, I was just curious.

Simon

  • Member since
    January 2004
  • From: Canada, eh?
  • 13,375 posts
Posted by doctorwayne on Sunday, February 24, 2019 3:02 PM

I have a book for recording paint colour mixing formulae, locomotive maintenance, repairs, dis-assembly, and modifications, tonnage ratings for locomotives, standard paint and lettering practices for my freelanced roads' equipment, and standard lineside sign formats.

I also keep methods and measurements for building standard lineside structures owned by the railroad, and diagrams and written explanations of certain often-used construction practices, such as that for converting Athearn and Rivarossi heavyweight passenger cars into "wooden" headend cars.

Also technical types of information, regarding drill sizes for particular items or jobs, grade/curve compensation calculations, volume/weight relationships for tender capacities and various types of loads, speed calculations, re-weigh data requirements, along with lots of tips and tricks learned or picked-up from others through the years.

I have, on disc, and on my computer, an all-time roster of my freelanced home road freight and passenger equipment, and all locomotives ever lettered for them - that's mainly to insure that I don't use a car or locomotive number already in use by either myself or someone to whom I've sold equipment.  It's done in Excel, with basic information about each item: description, it's status (in-use or sold), plus a value (too low, I've been told by several friends) for re-sale upon my demise.
Also included are all interchange cars and locos currently in use on the layout.  If any are sold or given away, they're removed from the list, and new ones are added as they're acquired.
 
Each freight and MoW car has a specific box (some boxes contain 2 or four similar cars) many with notes related to the lettering used, as all locomotives and most rolling stock is not factory painted.

I also keep a written list of GERN modellers, and their e-mail addresses so that I can send them the latest on GERN product releases and advertising.

Like Dave, I have a fair-size collection of parts and a fairly-good idea of where they are, and likewise for tools (except when any of them are in use, on one of the various work benches, and I can't see them for the clutter.)

Wayne

  • Member since
    July 2006
  • From: Bradford, Ontario
  • 15,797 posts
Posted by hon30critter on Sunday, February 24, 2019 4:14 PM

snjroy
I have recently started to box things together - I have a Mantua box, Bachmann box, etc.

I have the parts sorted by type, not manufacturer. The larger bits are in BB boxes and the smaller parts are in small plastic boxes either with adjustable dividers or individual lids for each compartment. The plastic boxes with one single lid for all the compartments are good for detail parts like horns and bells because I can see everything at once. The boxes with the individual lids on each compartment are great for screws, nuts and washers etc. I label the top of each compartment with the size of screw etc so it's easy to go straight to the size I want.

I use several multi drawer plastic storage units to keep all the containers in. The individual drawers are dedicated to various categories. I can usually go straight to the proper drawer, but not always. Some things like scratch building supplies take up three or four drawers. Some of the drawers are deeper than others which works out nicely for the bigger bits like turnouts. All the drawers in all five units are full to the top and the excess is almost totally filling my workbench!Whistling I need more units but I have no space left in the workshop to put them. Guess they will be going into the garage.

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
    January 2010
  • 2,616 posts
Posted by peahrens on Sunday, February 24, 2019 5:39 PM

An interesting thread as there are many ideas shared.  

My documentation approach, including what I could do better for my benefit:

- I have 30 or so DCC locos, most if which I have converted from DC finds.  I have a manila folder for each, including notes on CV settings.  While I have DecoderPro & LokProgrammer available, I use them for changes but do not go to the effort (yet) of using those to save a modified file with my tweaked variables.  

- Documentation includes photos, and I do wish I had not only better notes on my locos' DCC conversions, but also interior photos for each so I could better recall what I had done inside.  I'm not even sure how many speakers I put in some locos.

- I also have a "Trains - Current" manila folder at my desk that includes: what I want to order next time, where some odd off-layout things are located, a To Do list (that seems to get longer) of things to address (mainly loco malfunctions that need attention but are delayed due to having fun with something new)

- I have thought of a rolling stock inventory but not bothered.  When I look at my freight cars I do not know off hand which brand they are, which type metal wheelsets I added, etc. 

I tend towards being pretty well organized, but imagine I am just middle of the pack for this group.Smile

Paul

Modeling HO with a transition era UP bent

  • Member since
    March 2012
  • 1,162 posts
Posted by PC101 on Sunday, February 24, 2019 9:01 PM

It's all in a broken spine 'Master' notebook held together with rubber bands cut from intertubes, stock number, where purchased, item description, road name, road number, paint color, price and date. In addition, the locos each have an index card with all info. (I use Lenz DCC since 1-15-01). Stock Rolling stock is in the 'Master' book. Rolling stock that has been modified (not counting couplers) has a index card. Small parts are in small plastic drawers in metal cabinets alphabetical by Manufacturer and in numerical order. If I need a part, I open an old Walthers catalog, find the part, pull the number and go to that cabinet or box. Larger parts (frames, bodies, over the road trailers and scrap loads ect.) are in labeled cardboard boxs.

There are not to many parts, detail/repair I need to buy at this time except to replace an item used or low in stock. I have many parts that I know I will never use. As a teenager I had many ideas that never materialized in later life (TrueScale switch machines-NIB, Super Gearing by Ernst mfg. for Athearn BB 4 axel and 6 axel Diesels, metal X2F couplers just to name a few) I now like to model late '60 early'70 northeastern roads.

All parts acquired within the last 18 M/L years, if possible have a date stamp on the package (do you know that after that date stamper is expired there are some cool scrap loads you can make from the rollers?). I still have the empty package/boxs that my locos and rolling stock came in that I just can't get myself to throw out. Many boxs have untouched (by my hands anyway) locos. and rolling stock still in them. I have maybe 90% of all receipts (I did not keep them from my pre-teen years) railroad related stuffed in shoeboxes, that I never want to add up. 

Sometimes I think I may need therapy. Hello, my name is PC101 and I'm a Model Railroader. I just got a computer maybe 6-7years ago so it's all still going on paper. I will check out the sites listed above for inventory (thanks guys). 

If you looked under my layouts, yes I've had more then a few over the years, you would find dates as I progress on the bench work, wiring and the likes.

If you had done inventory (stock, parts, procedures) from the start it only took seconds back then at the time and when needed that infomation is at your finger tips now.         

  • Member since
    July 2006
  • From: Phoenix, AZ
  • 1,835 posts
Posted by bearman on Monday, February 25, 2019 6:36 AM

I am amazed at the different ideas that people have on this issue.  About a week ago, I went on a weight/coupler binge.  Pulled off all my rolling stock and checked on weights and couplers and I realized that if I had kept track of which cars had been modified then I could have saved some time.  I have a car roster on Excel but someone on here uses Yard Office.  I downloaded it and it appears to be a pretty decent program to keep track of what I want to keep track of.  Now, all I have to do is print out the Yard Office roster and see which cars need attention the next time I go on a weight/coupler binge.

Bear "It's all about having fun."

  • Member since
    May 2010
  • From: SE. WI.
  • 8,253 posts
Posted by mbinsewi on Monday, February 25, 2019 7:29 AM

Whatever works for you, Bearman.  As you can see, some are way over the top with documentation, and some, like me, are not.

As long as your having fun, and "Music doing it your way Music"

Mike.

  • Member since
    August 2018
  • 8 posts
Posted by Daver on Wednesday, February 27, 2019 12:42 PM

I'm noticing a lot of folks using Excel as a database to keep track of information. As a former IT person, it is not the best solution. Over the years, I've dealt with a lot of people who used Excel for that purpose, and then screwed up a sort, rendering the data useless because individual files are are not kept together. For anything complex or long term, you will be much better off using an actual database program - open office, Access, or Filemaker. It may take some time to learn, but you will have much better data intergrity.

  • Member since
    March 2016
  • 1,553 posts
Posted by PRR8259 on Wednesday, February 27, 2019 5:43 PM

Actually, I tend to be more interested in the prototype history of each locomotive than in my particular model history.

When I buy a new (model) engine, I often go online to find out what became of the prototype unit? how long it ran? when it was purged from the roster or sold to a second owner? what paint schemes it wore? etc.

I learn and make mental notes regarding the most interesting facts.  For example, I recently picked up  (model) SP Kodachrome SD45T-2 #9319, and then found out that the real unit was one of the last units still operating in full Kodachrome paint.  It was still in service, in weathered unpatched SP Kodachrome paint, for UP, during May, 1998.  What I don't know is how long it lasted before being set aside.  It was likely never rebuilt as part of the GRIP program or any other rebuild program.  (that stuff I'm still looking up).  So when a major failure occurred, being a non-rebuilt unit, it would have been done.

John

  • Member since
    May 2010
  • From: SE. WI.
  • 8,253 posts
Posted by mbinsewi on Wednesday, February 27, 2019 7:18 PM

PRR8259
Actually, I tend to be more interested in the prototype history of each locomotive than in my particular model history.

Same here.  I use the photos of the prototype for weathering, along with it's history.  I don't document it, just save a couple of pictures.

Mike.

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!