Sorting Through 00 Gauge Models.

Discuss model railway topics and news that do not fit into other sections.
User avatar
Mountain
Posts: 4506
Joined: Mon Oct 24, 2016 3:43 pm
Location: Somewhere in Wales, UK.

Sorting Through 00 Gauge Models.

Postby Mountain » Tue Sep 19, 2017 7:53 pm

I decided to take the plunge and write a new stock book as the old one had so many changes (Some of which I didnt record) that it is ready for a new list. I have trains everywhere and I dont think I've found them all yet! It looks like a larger job then I expected. I may have to find a way to clear them off my bed so I can get some sleep tonight. :D
I'm sure I've some missing as at least one wagon isn't here. I think I have a whole box of trains to find yet. I know where they'll be but is going to be a job to get at them....
Well. At least I'm getting there after a few pages filled in the stock book.

Anyone else keep a stock book? Maybe it is an idea for someone to make a specific book to sell to us modellers....

User avatar
luckymucklebackit
Posts: 3501
Joined: Mon Jul 18, 2011 7:05 am
Location: Troon - where the Duchesses went to die
Contact:

Re: Sorting Through 00 Gauge Models.

Postby luckymucklebackit » Tue Sep 19, 2017 9:13 pm

I keep all the details of my stock on an Excel spreadsheet, also allows me to plan the stock movements on the ;ayout.

Jim
This Signature Left Intentionally Blank, but since I have written this and I intended to do it, this Signature is intentionally not blank. Paradox or What?
My layout - Gateside and Northbridge
Image

b308
Posts: 5006
Joined: Sat Apr 15, 2006 5:48 pm
Location: North Worcs

Re: Sorting Through 00 Gauge Models.

Postby b308 » Tue Sep 19, 2017 9:30 pm

I hate Excel, never got the hang of it, if only there was some sort of free "collector's catalogue" software we could use!

User avatar
Alexander Court
Posts: 1164
Joined: Mon Mar 21, 2011 7:42 pm
Location: Waterville, Ireland
Contact:

Re: Sorting Through 00 Gauge Models.

Postby Alexander Court » Tue Sep 19, 2017 9:35 pm

I have a mental stock book but thinking I might write it down, I had one a few years back but its changed a lot since then and my Island setting has changed some what that I need to write the railway lines and companies and the places they serve too. But yea I mentally go through my stock book when I have to remind myself to ignore the idea of going DCC xD

"I love the way you call it Art, When you never even use your Heart, and I just wanna tear you Apart"

User avatar
TimberSurf
Posts: 2485
Joined: Wed Jan 08, 2014 5:47 pm
Location: N.Wales
Contact:

Re: Sorting Through 00 Gauge Models.

Postby TimberSurf » Tue Sep 19, 2017 10:08 pm

As an Excel expert, there is no choice! Mine is documented in excel here, which took long enough, I would hate to think how long it would have taken long hand!
I will eventually transpose the spreadsheet into a database and have a proper front end for it.
There is a freebie database available from America or this reasonably priced Brit one http://www.modeltraincatalogue.com
http://www.modeltraincatalogue.com/down ... manual.pdf
Image
Lumsdonia <--- Hit link to go to my website for full story and wiring advice!

User avatar
Mountain
Posts: 4506
Joined: Mon Oct 24, 2016 3:43 pm
Location: Somewhere in Wales, UK.

Re: Sorting Through 00 Gauge Models.

Postby Mountain » Wed Sep 20, 2017 12:31 am

Didnt think you lot were geniuses with your computers! :mrgreen: This list I'm compiling is a rough list. As I DCC'd half my locos and couldn't remember which ones, the book of Lenz instructions will need to come out as not having used it for a few years I'm a bit rusty! Will need to set up the control system to see what is what.
My list is a basic list for now. One of my wagon I can't find so somewhere I must have another box full. Could be with my Dublo stuff so may not be so easy to get it. Well I'm getting organised slowly!!!

User avatar
Dragonfly
Posts: 382
Joined: Mon Jan 24, 2011 7:49 am
Location: Stoke on Trent
Contact:

Re: Sorting Through 00 Gauge Models.

Postby Dragonfly » Wed Sep 20, 2017 6:25 am

I went extra-geeky and wrote my own web-based database for my stock-taking.

dtr.png


Still a work in progress, when I get time (as this kind of thing is my full-time job, I try to work on this between work project, lest I get mixed up).

User avatar
Bufferstop
Posts: 12607
Joined: Thu Mar 11, 2010 12:06 pm
Location: Bottom end of N. Warks line

Re: Sorting Through 00 Gauge Models.

Postby Bufferstop » Wed Sep 20, 2017 8:55 am

TimberSurf wrote:I will eventually transpose the spreadsheet into a database and have a proper front end for it.


That's a dangerous statement to make! When I took early retirement I left one that was ready for a front end to be implemented. It's great grandson is still waiting. Requirements seem to change faster than code can be developed, without a large squad of code bunnies to burrow their way into it.
Growing old, can't avoid it. Growing up, forget it!
My Layout, My Workbench Blog and My Opinions

Dad-1
Posts: 6421
Joined: Sun Aug 24, 2008 8:05 pm
Location: Dorset - A mile from West Bay.

Re: Sorting Through 00 Gauge Models.

Postby Dad-1 » Wed Sep 20, 2017 9:16 am

I have and need a stock record that's easily searched. I use
a Casio digital diary programme that won't run on Win10 which
is why I have to stay XP. or Win98.
Even then I thought I'd duplicated one brake van entry, deleted and
subsequently have found I do have 2, but with in excess of 400 wagons
keeping tabs on exactly where any one is would be impossible without
a good rapidly searchable record.
Not so bad with only about 85 locomotives, but with decoder numbers
being used several times due to a Select only having 59 two digit loco
addresses I need to refer to a record to see what address a less used
locomotive's on before I can run it !!

Geoff T.
Remember ... I know nothing about railways.
viewtopic.php?f=22&t=32187 and Another on viewtopic.php?f=22&t=28436&start=60&st=0&sk=t&sd=a

User avatar
luckymucklebackit
Posts: 3501
Joined: Mon Jul 18, 2011 7:05 am
Location: Troon - where the Duchesses went to die
Contact:

Re: Sorting Through 00 Gauge Models.

Postby luckymucklebackit » Wed Sep 20, 2017 10:44 am

Dad-1 wrote:I have and need a stock record that's easily searched. I use
a Casio digital diary programme that won't run on Win10 which
is why I have to stay XP. or Win98.
Even then I thought I'd duplicated one brake van entry, deleted and
subsequently have found I do have 2, but with in excess of 400 wagons
keeping tabs on exactly where any one is would be impossible without
a good rapidly searchable record.
Not so bad with only about 85 locomotives, but with decoder numbers
being used several times due to a Select only having 59 two digit loco
addresses I need to refer to a record to see what address a less used
locomotive's on before I can run it !!

Geoff T.


Geoff = You are not alone in still needing Windows XP....http://www.bbc.co.uk/news/technology-41306321
This Signature Left Intentionally Blank, but since I have written this and I intended to do it, this Signature is intentionally not blank. Paradox or What?
My layout - Gateside and Northbridge
Image

User avatar
Mountain
Posts: 4506
Joined: Mon Oct 24, 2016 3:43 pm
Location: Somewhere in Wales, UK.

Re: Sorting Through 00 Gauge Models.

Postby Mountain » Wed Sep 20, 2017 11:04 am

Dad-1 wrote:I have and need a stock record that's easily searched. I use
a Casio digital diary programme that won't run on Win10 which
is why I have to stay XP. or Win98.
Even then I thought I'd duplicated one brake van entry, deleted and
subsequently have found I do have 2, but with in excess of 400 wagons
keeping tabs on exactly where any one is would be impossible without
a good rapidly searchable record.
Not so bad with only about 85 locomotives, but with decoder numbers
being used several times due to a Select only having 59 two digit loco
addresses I need to refer to a record to see what address a less used
locomotive's on before I can run it !!

Geoff T.

Dont you think it is time for a controller upgrade? :D
Actually, if you happen across a secondhand Lenz Compact at a good price (Where you know it works OK) these do 99 loco addresses (Actually 100 as there is the dc address. Later Compacts did 127 loco addresses) and over 100 point addresses (Can't remember how many but it was way over 100) and when I've noticed them secondhand they are really impressive prices.

User avatar
SRman
Posts: 1096
Joined: Fri Oct 03, 2008 2:26 am

Re: Sorting Through 00 Gauge Models.

Postby SRman » Wed Sep 20, 2017 11:28 am

I also use Excel for my stock lists (still working on the rolling stock, but most locomotives are documented). I also include what decoders are installed and how many pins they are (or HW for hard-wired).

The next stage is to add values for insurance purposes; fine for current models, but not so easy for older ones or for kit-built or modified examples.

If I feel inclined I could do as TimberSurf has suggested and import the Excel sheets into a database. Microsoft Access, while not the best DB on the market does allow direct import from Excel, with the excel worksheets becoming individual tables in the relational database.

User avatar
Lancastrian
Posts: 1579
Joined: Sat Mar 15, 2014 9:33 am
Location: Lancashire
Contact:

Re: Sorting Through 00 Gauge Models.

Postby Lancastrian » Wed Sep 20, 2017 11:50 am

I use Access, the large grey square to the top right is where I put a photograph.

Image
My Web Site Links: FGO & Boats and Canals (Forum)

m.levin
Posts: 2001
Joined: Mon Jan 09, 2006 6:46 pm

Re: Sorting Through 00 Gauge Models.

Postby m.levin » Wed Sep 20, 2017 12:11 pm

I also have a list of stock but mines more a data/service sheet.
It has all details and decoder details and a list of work carried out and so on...
It's just nice to keep this info.

User avatar
Mountain
Posts: 4506
Joined: Mon Oct 24, 2016 3:43 pm
Location: Somewhere in Wales, UK.

Re: Sorting Through 00 Gauge Models.

Postby Mountain » Wed Sep 20, 2017 1:07 pm

Lancastrian wrote:I use Access, the large grey square to the top right is where I put a photograph.

Image


Sorry to say that for me that would be overkill. (Why I prefer a simple paper list).
My list is kept as simple as possible to give the information needed without the need to go into unnecessary detail to the job in mind.

For example, my list for locos (Slightly more complex then rolling stock) would be :-


Loco identity (E.g. class 47 or Terrier etc)

Livery (E.g. GWR green)

Boxed or unboxed (Helps to find the things or if one wants to sell them etc)

Make

DCC fitted or not with the address number if fitted.


Return to “General Model Railway Discussion / News”

Who is online

Users browsing this forum: No registered users and 9 guests