Separate sheet in Excell. I have the same issue and there is a monetary value to these things as well, course loss can never replace the effort but good to have that list just in case.
-
1
- Show all
How do you catalog your collection?
- Thread starter Gibby
- Start date
That is what I also found with so called bespoke systems, you cannot beat the spreadsheet and of course Word allows a Table that is effectively a spreadsheet, though not so comprehensive.Thanks for posting Ken. I have just tried the demo - Little problem, it only seems to offer a limited range of manufacturer tags and nothing for 45 mm gauge. I cannot find a field for either of these noted as "other" so that it can be customised to suit all the different Fn3 and 16 mm scale products from the makers I have, just "unknown" that cannot be seem to able to be modified. Am I missing something here ? As it is it would be no better than just writing a list in a regular word document.Max
OK, so now I have a little list 
I'd recommend using Excel, 'cos you can re-size that at print stage to fit to one sheet, or however many you need 
with Word, you're stuck with WP formatting 
I'd recommend using Excel, 'cos you can re-size that at print stage to fit to one sheet, or however many you need with Word, you're stuck with WP formatting 
There's a difference between a spreadsheet and a database. The line is getting blurred somewhat, but there is only so much you can do with sorting an Excel spreadsheet.
I would not recommend tables in Word, they are too limited, and pretty poor at calculating.
I use a database to be able to search for things, but most people will be fine with a spreadsheet, sorted according to the current area of interest. I often search for things in common, like type of decoder, rolling stock that has not been maintained/serviced in a while, etc. Of course I was a computer science major, so been programming since 1969, so maybe I am "different" ha ha!
Greg
I would not recommend tables in Word, they are too limited, and pretty poor at calculating.
I use a database to be able to search for things, but most people will be fine with a spreadsheet, sorted according to the current area of interest. I often search for things in common, like type of decoder, rolling stock that has not been maintained/serviced in a while, etc. Of course I was a computer science major, so been programming since 1969, so maybe I am "different" ha ha!
Greg
-
1
- Show all
Max, there are three tabs at the top of the program screen: Stock, Reports and Maintenance. Click on "Maintenance" on the right then "Makers and Manufacturers". F8 will let you add your own. The prefilled list does seem to favor the smaller scales, but I haven't bothered to delete any yet. KenThanks for posting Ken. I have just tried the demo - Little problem, it only seems to offer a limited range of manufacturer tags and nothing for 45 mm gauge. I cannot find a field for either of these noted as "other" so that it can be customised to suit all the different Fn3 and 16 mm scale products from the makers I have, just "unknown" that cannot be seem to able to be modified. Am I missing something here ? As it is it would be no better than just writing a list in a regular word document.
-
1
- Show all
Thank you Ken. I really should learn to read effing the manual (RTFM)
I think this could end up as a very useful tool now that I have a little time on my hands, as I am now retired, and have a very out of date list. I have a little bit of 009 stuff bow to list too, as well as my 15 mm & 16 mm, so I might keep 1 or 2 of the prefigured names for that. MaxDon't know about the other bespoke systems, but Model Train Catalogue has a lot of customization available, including two "self-named" fields. See my later reply to Max. I've put together a fair number of Excel spreadsheets over the years and some Access databases. They are both great tools, but for the price, it would take me a lot of time to match what is already in MTC and if I find something it won't do that I need badly enough to spend the time, I can just export all the data into Excel or a .CSV file. I think that for someone who wants/needs a detailed inventory, MTC is worth a look or even the $15 or so that it costs to buy. Now, I must admit that after I get into it a bit, I may decide that I don't want to be bothered with any kind of inventory.
Ken
Ah yes, programmers. Can't live with 'em, can't live without 'em. Just don't forget that we probably wouldn't be sitting at keyboards all around the world discussing the nuances of various aspects of our hobby if it weren't for people years ago who got tired of waiting for their company IT department to write the programs they needed to get the job done and bought a wimpy little "personal computer" and a copy of VisiCalc out of their own pockets/budgets. Isn't there some sort of correlation between computer nerds and model railroaders? No comment on whether the early programmers were mostly American, but the UK seems to have a jump on us in the model railways department.Ah! That explains a lot!!
American, AND a Programmer!!
Ah, well, see...........
We built the railways first.. So were the first 'out the blocks' modelling them, as well.
I've been wanting to create a record of all I've got - just in case I drop off my perch! The off-spring can flog it all as part of their inheritence. I keep telling my better half that it's been an investment .
I use Excell on a daily basis but also use Word to log things on as well. Excell has memory - so I would only have to put in a 'B' and it would display Bachmann!
.I use Excell on a daily basis but also use Word to log things on as well. Excell has memory - so I would only have to put in a 'B' and it would display Bachmann!
-
1
- Show all
i do all my lists (not only for the toys) in excel.
if i would ever find out, how to run old programs on modern PCs, i would install my old ms-works again.
data bases and spreadsheets and idiot proofed.
if i would ever find out, how to run old programs on modern PCs, i would install my old ms-works again.
data bases and spreadsheets and idiot proofed.
I now use a simple card for each loco/unit. Date entered service, Volts required for scale 20mph speed & last service date. I did 996001 this morning & updated its card. I did have a spreadsheet on a PC long gone (I started in 1993) I found card system nice, simple & easy to keep up to date.
-
1
- Show all