Skip to main content

I recently started a spreadsheet for all rolling stock.

I've dreamed about starting a spreadsheet for my trains, but when I actually get to looking at the shelves and all the stuff that isn't on the shelves, I lose interest and run some trains!

Maybe if I get more shelves up, it'll be easier to count them...

Attachments

Images (5)
  • mceclip0
  • mceclip1
  • mceclip2
  • mceclip3
  • mceclip4

I've dreamed about starting a spreadsheet for my trains, but when I actually get to looking at the shelves and all the stuff that isn't on the shelves, I lose interest and run some trains!

Maybe if I get more shelves up, it'll be easier to count them...

I am in Johns Camp except I have a spread sheet but keeping finding stuff that is not on it maybe when I get the reminder of my shelfs up I will have a better idea. That being said I will run out of walls before I run out of trains.

@A. Wells posted:

I'm curious, do ABA's count as one locomotive or two locomotives or two powered locomotives and one unpowered locomotive?

I count any ABA or ABBA, etc consist as one locomotive since they go together, but that's just me.

I hope Lionel releases an ABBA consist of the F7 (like the ones in the current 2022 1 catalog) in the Black Bonnet.  That would be amazing!

I've dreamed about starting a spreadsheet for my trains, but when I actually get to looking at the shelves and all the stuff that isn't on the shelves, I lose interest and run some trains!

Maybe if I get more shelves up, it'll be easier to count them...

I figured that might happen to me so I started it while my collection still isn't that big.  Every time I purchase something it goes on the spreadsheet.

BTW, I have the SP 4449, the M1 and the Aerotrain as well (mine can't pull very well so I have 4 coach cars).

I figure I'll have to add some weight to that engine.

More important than weight is to adjust the rear truck for proper tension on the springs.  It's tricky to get it where the pony wheels don't pop out of the track or exert too much force and lift the rear drivers off the rail.  That's the biggest issue with traction with this engine as the rear truck does most of the heavy lifting as far as traction is concerned.

@ADCX Rob posted:

This comes up regularly, still not understanding everyone's fascination with spreadsheets for inventories when it's the wrong tool, a relational database is what is called for.

nah, nah, go all out, use a graphical database *lol*.

Given the nature of train collections a relational db is overkill, just not enough data to warrant building out a db (I realize there are commercial, freeware db based products out there that do just that, inventory management). Sure, you can run queries if you forget what you have and run  query something like "select * from train_type where type=steam&maker=lionel&engine_number=*434" or something, but how much do most people have?

More important than weight is to adjust the rear truck for proper tension on the springs.  It's tricky to get it where the pony wheels don't pop out of the track or exert too much force and lift the rear drivers off the rail.  That's the biggest issue with traction with this engine as the rear truck does most of the heavy lifting as far as traction is concerned.

That makes sense.  I'll have to fix it like that.  Thanks for the info!  That Aerotrain is a real crowdpleaser.

You can always spot a civilian when they ask "how many trains do you have?", as a "train", grammatically, is 2 or more things attached, usually semi-permanently, typically for the purpose of movement. What they really mean is "how many of these things (on the wall, on the layout, in your pocket) do you have?" So, if we agree that a steam loco is not a "train" (there's that tender following behind factor), and that an MU'd set of diesels is not a "train", plus that a disconnected piece of rolling stock is not a "train", then your "train" count goes way down. Only equipment that is entrained (i.e., coupled) are "trains".

My "train" count at the moment is about 5, maybe 6. Practically zero.

No matter how you express it, the numbers are pretty meaningless to most people.

I was showing a non-train friend my basement.  My still-boxed Lionel Simpsons animated gondola caught his eye - he saw the $49 price tag and said he was amazed at how expensive this stuff is.  He didn't understand my uncontrollable laughter... 

A tough question, and as mentioned, typical of a civilian meaning all the rolling stock, locos, track, etc.   But when stated that way, it is hard for me to give an answer that they can understand.     There big numbers if you count pieces, small numbers if you count the trains run in my operating sessions.    Somewhere in between if you count what is in use on the layout at a given time. 

A ruder question in my opinion that some blurt out first is "how much did this cost?".    I have a friend whose standard answer to that was "about the same as a golf game every week".

Add Reply

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