Spread sheet of locomotives and rolling stock

[ToothFairy]

Like Ollie (reply #13), I have an Access database. I include stuff like length and weight info so that I can keep track of loco pulling capability (with train make-up aka consist info), and date of last service. But I dare not keep financial info on there - the computer would melt.

- Michael

[Sandvika]

Funnily enough, I spent the best part of this weekend creating a spreadsheet of rolling stock after I accidentally bought a loco on eBay that I already have    However, it's a Fowler 3F and they were so often double-headed that having an even number of them is fine  Just needs renumbering.....

So far 2 sheets, one for locomotives, another for coaches and trucks....the trackwork inventory will have to wait until the loft becomes vaguely accessible.

As I'm just returning to N Gauge after a rather extended absence, I have been tracking down RTR LMS locos and must-have trucks that have arrived and been discontinued whilst I've not been paying attention    I think I've got the job done but.... I've never spent so much on N Gauge at once (total cost is about the same as a G Scale live steam loco!) and the only way I can possibly square this off with my wife as the many packages start to arrive in the post is to offload a lot of stock onto eBay - I'll start tonight!

[scruff]

I keep 3 databases, "My rolling stock", a list of what I've got, then "Model wagons", a list of the wagons I would like and then I have "Model Database" Which is my list of current and forthcoming items, loco's, units and coaches with prices, release dates. I just hope SWMBO never learns how to add it up!

Cheers

Mark

[Newportnobby]

I just hope SWMBO never learns how to add it up!

Cheers

Mark

Suggest you password protect it

[scruff]

ah! She would use that female logic on me and say I had something to hide... specially as she makes frequent trips to Hattons and has even been to Rails as well as most local shops. She is the one who pays...  But that also means she knows how much it costs..

For some reason she is also a member of Dapol's collectors club too!!! 

Mark

[Mustermark]

You can't fault female logic.

[Donkey]

You can't fault female logic.

I wouldn't dare try lol 

[Pengi]

I can't even understand my own logic sometimes

[Newportnobby]

I can't even understand my own logic sometimes

What hope do us mere males have

[Chinahand]

As part of the packing up process I've just finished putting all of my stock into Yard Office. I found it to be very easy to use but it frightened the life out of me when I saw the total value 

I showed it to my wife and she didn't bat an eye-lid but she does at least now know what it might be worth when I pop my clogs so she sees it as an investment that she will get the benefit of.

[trainsdownunder]

Help needed

To help me with finish assessing some of the software for this could someone be kind enough to give me a chunk a data from their files in Excel, CSV or Db formats please

Thanks in advance

Colin

[bbdave]

As i only have 4 locos i have not had the need to keep a record but i can see the need in future  so it could be wise to make a start but i have no idea how to layout a list/spreadsheet are there any available online?

Dave

[Tank]

Spread sheets.....  something else to add to the 'to do' list.   Great idea though! 

[Sprintex]

As i only have 4 locos i have not had the need to keep a record but i can see the need in future  so it could be wise to make a start but i have no idea how to layout a list/spreadsheet are there any available online?

Dave

PM me your e-mail address and I'll send you my actual sheets if you like 

There are many ways to lay out a spreadsheet for something like this depending on what information you want to see. One sheet of mine is more traditional listing items and their cost with sub-totals (track, stock, scenery) and total cost. The other is more graphical representation showing train formations, dcc-chip fitted and address, etc 

Might not show you the best way (if there is a best way!) but give you an ida how you might like to set out your own sheet.


Paul

[Donkey]

PM me your e-mail address and I'll send you my actual sheets if you like 

There are many ways to lay out a spreadsheet for something like this depending on what information you want to see. One sheet of mine is more traditional listing items and their cost with sub-totals (track, stock, scenery) and total cost. The other is more graphical representation showing train formations, dcc-chip fitted and address, etc 

Might not show you the best way (if there is a best way!) but give you an ida how you might like to set out your own sheet.


Paul
[/quote]

Paul, I hope you don't think I am being cheeky but could you e-mail me a copy of your sheets too please? I am no real expert with spread sheets though I can normally muddle through. Seeing your sheets might save me a lot of head scratching though.

Marty