I'm more of a 'collect everything' rather than a 'look for a certain coin' person, and my inventory system really isn't working. Right now I'm using the book Red Book Collector's Inventory, but there's just not enough room. Sample: Lincoln 1955-S: 2 BU rolls, #12, #27, 2 Proof, MS60, MS63, MS65. I can jam all that into the box, but there's no room for anything else--purchase dates, prices, etc. I've looked at some of the coin software, but it seems geared to a single item for each date, then plus you'd have to keep printing things out to go to shows and such. Anyone else with mega-collections have any ideas?
Build your own with Excel or, if you don't have Microsoft Office, you can download Open Office for free. They are compatible. You can build it how you want it and you can change things as you go. http://www.openoffice.org/
carly I agree with rickmp. Also if you make a folder and place your Excel and your pictures in the same folder, you can hyperlink them in any cell quickly and design your coin collection anyway you want to. I have a fairly large collection and by adding tabs you can customize and design endlessly. Biged
If you're interested in a free basic excel coin spreadsheet, check out this page: http://typesets.wikidot.com/free-coin-templates (I use the 3.2 Excel template. I haven't tried the others, yet.) I found it while looking for a way to catalog my collection and I think it works pretty well for those people that want basic excel functionality, but don't want to take the time to set up all the dates and mintages. Oh, and it's free. Hopefully, others will find it as useful as I did. Good luck
www.numismaster.com Best of all, it's FREE. You can enter all kinds of metrics from weight, mintage, price paid, value, edge type, etc. It even adds the value of your collection and tells you what it's worth.
Thank you everyone for your replies. I spent the entire evening doing a physical inventory of everything and I'm going to try the Excel spreadsheet first and see if that works for me. Still trying to figure out why I have 23 rolls of BU 1959-D Lincolns. Don't even remember that.
I am using Excel myself to organize my collection. Make sure to assign a unique identifier to each coin, like Date-Mint-Type-Variety-Number, e.g. 1830-P-CBH-106-001. If you have hundreds of coins from the same type it should be enough to use one ID for each roll. Just an idea...
