I have been trying to organize the majority of my "decent" collection into a log. This is part of me going through my collection and downsizing...what I'm going to keep (and add to) should have through records. That way, I can have a quick reference to my collection. Things like cost, date purchased, TPG serial numbers, ect. I thought that it would be a good idea to assemble such a document so if anything ever happened to my collection...I would know exactly what I had and where it came from. This is opposed to my current system of a bunch of different incomplete documents in various places. Some of it will be incomplete as I don't know all the information for every coin currently in my collection (I didn't always keep good records)...but I will fill it out to the best of my ability and going forward be on top of it. To that end, I have created an Excel spreadsheet. It has multiple tabs and sections...but the main tab is what I will share here. I have blocked out some of the "sensitive details" and right now it is pretty empty because I'm still putting the spreadsheet together. I will continue to "fill it out" as time goes by. It is setup to automatically total the costs into the box in the upper right. What do you think? Any suggestions? Also, if anybody would like to use this spreadsheet, PM me and I will email it to you.
Needs more than 3 coins on it , but, yeah, this seems to more or less cover it. Maybe you could include prices realized for when/if you sell, and links to images (if available)?
It's easy to expand a section as needed...just right click and select insert. I agree that some will need more. It's just easier to copy 4 line when making multiple sections.
You could easily throw links into the Notes field. For me, the only difference between this spreadsheet and near-perfection would be the ability to automatically add stock/inventory numbers when a new entry is inserted, and possibly thumbnails.
