Re: Tracking
Rum
The spreadsheet idea works in general but falls down in specifics. The biggest problem is that its not easy to attach images to it and keeping it in a "safe place" essentially requires multiple copies (which you need to make sure are sync'd).
The other problem is more generic in remembering to keep the darn thing up to date
We got overly motivated to update it all when a fire was headed towards our house (didn't get here luckily) but that was clearly well past the right time to have been doing it.
What we tracked was:
description
date purchased
aprox age (relevant for not new tools)
"value" (price paid for most things)
serial no
location (room)
quantity (for multiple items)
comments/notes
If you were organized enough a link to a picture would also be a good idea.
There are many inventory tracking programs that exist that are undoubtedly better in some ways.
As noted the antique and specialty tools are a bit more complicated. I love seeing them at auctions and estate sales because frequently no one knows what they are and they often go for a song (more than once the seller has given me a deal in exchange for identifying things - at least a couple of times with the comment "well at least you know what it is so you'll probably end up using it instead of wasting it" - which I can empathize with). In a lot of cases unless you're just lucky and that "special person" shows up a generic estate sale isn't going to have anyone show up who'll actually know what it is or use it.