Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
How do you catalog your collection
>
Reply to Thread
Message:
<p>[QUOTE="Vess1, post: 517148, member: 13650"]I've discussed mine in depth here in the past so I'll try to keep this one short.</p><p><br /></p><p> I use a customized Excel spreadsheet as well. I use separate sheets on the same file and name them per denomination. </p><p><br /></p><p> Across the top:</p><p> Date, mint mark(MM), Grading Co., Grade, Qty., Prch. Date, Prch. Price,(current) value, and a short comments column at the end. All fits on a page.</p><p><br /></p><p> The number columns automatically total. For fun I put a formula in that tallies total bullion content on each sheet as well.</p><p><br /></p><p> Another sheet for bullion. Another sheet for World coins. Another sheet for 19th century. Another sheet for commemoratives. I mainly only take pics for the nicer stuff in the commems and 19th century sheets. Reduce the images down to 1x1s (that can be stretched whenever), obv., rev. pics, side by side to the left. Info to the right. I put one generic image at the top of the other sheets and that's it. </p><p> A lot of the more common stuff I don't bother with documenting unless it happens to be in a set. </p><p><br /></p><p> Do what you can handle and what makes sense. If you make it too strenuous and complicated, it will take the fun right out of it. Especially getting started. HTH.[/QUOTE]</p><p><br /></p>
[QUOTE="Vess1, post: 517148, member: 13650"]I've discussed mine in depth here in the past so I'll try to keep this one short. I use a customized Excel spreadsheet as well. I use separate sheets on the same file and name them per denomination. Across the top: Date, mint mark(MM), Grading Co., Grade, Qty., Prch. Date, Prch. Price,(current) value, and a short comments column at the end. All fits on a page. The number columns automatically total. For fun I put a formula in that tallies total bullion content on each sheet as well. Another sheet for bullion. Another sheet for World coins. Another sheet for 19th century. Another sheet for commemoratives. I mainly only take pics for the nicer stuff in the commems and 19th century sheets. Reduce the images down to 1x1s (that can be stretched whenever), obv., rev. pics, side by side to the left. Info to the right. I put one generic image at the top of the other sheets and that's it. A lot of the more common stuff I don't bother with documenting unless it happens to be in a set. Do what you can handle and what makes sense. If you make it too strenuous and complicated, it will take the fun right out of it. Especially getting started. HTH.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
How do you catalog your collection
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...