Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Cataloging is Half the Fun
>
Reply to Thread
Message:
<p>[QUOTE="Vess1, post: 489643, member: 13650"]I agree. I've put together a basic, custom spreadsheet with excel with around 12 sheets to sort through at the bottom. Each sheet is a type of coin (silver dollars, half dollars, state quarters, quarters, commems..etc..)</p><p><br /></p><p> If I get a new Morgan, I just go in, click on the silver dollars sheet and the first page on that sheet is for Morgans. Date,MM, grading co.(if applicable), grade/approx. grade, qty.,purch. date, purch. price, book value, and then a space for a brief comment at the end. Usually, who or where I got it from. </p><p> They're also set up so that any sheet/page with silver coins, the quantity automatically is added to a total and the bullion weight is calc'd automatically and totaled on each page as coins are added to the quantity columns.</p><p><br /></p><p> I take pics of stuff like my commemoratives and shrink them down to about 1x1 squares. If, I ever want to look at one, I can just grab on the corner and stretch it out full screen. Then I can just click undo and it goes back to the size I had it. This allows me to get a lot on a page.</p><p><br /></p><p> I only photograph the nicer stuff. If I buy a roll of silver dimes, I'll just enter in the quantity on the dimes sheet with a beginning and ending date for them. And price paid. Trying to photograph everything would be too much. </p><p><br /></p><p> It's so easy to do once you get everything cataloged. I'm glad I started early. I know some people put it off because their collections are so extensive now that they don't know where to start and just don't want to do it now. Others have stuff coming in and going out so much, it isn't worth it to catalog. </p><p><br /></p><p> I think it's worth it for me and I enjoy keeping track. It will be interesting to look at down the road.</p><p><br /></p><p> I also keep this backed up on an external hard drive that I update once in a while. If my computer crashes, I've still got it all.</p><p><br /></p><p> Edit: I should also add that it's great having the info available when going to a show. If I'm headed to a show, I'll go to the half dollars sheet, page 4. I'll print only page 4 and it's a list of Franklins that I have or don't have. Any date that I have a MS one for which are in my IS album, I have an asterick (*) by the date. Circulated ones don't have an (*). And of course the ones I don't have just have the date, MM and the rest of the fields are blank. A perfect, instant list with grid lines, always available.[/QUOTE]</p><p><br /></p>
[QUOTE="Vess1, post: 489643, member: 13650"]I agree. I've put together a basic, custom spreadsheet with excel with around 12 sheets to sort through at the bottom. Each sheet is a type of coin (silver dollars, half dollars, state quarters, quarters, commems..etc..) If I get a new Morgan, I just go in, click on the silver dollars sheet and the first page on that sheet is for Morgans. Date,MM, grading co.(if applicable), grade/approx. grade, qty.,purch. date, purch. price, book value, and then a space for a brief comment at the end. Usually, who or where I got it from. They're also set up so that any sheet/page with silver coins, the quantity automatically is added to a total and the bullion weight is calc'd automatically and totaled on each page as coins are added to the quantity columns. I take pics of stuff like my commemoratives and shrink them down to about 1x1 squares. If, I ever want to look at one, I can just grab on the corner and stretch it out full screen. Then I can just click undo and it goes back to the size I had it. This allows me to get a lot on a page. I only photograph the nicer stuff. If I buy a roll of silver dimes, I'll just enter in the quantity on the dimes sheet with a beginning and ending date for them. And price paid. Trying to photograph everything would be too much. It's so easy to do once you get everything cataloged. I'm glad I started early. I know some people put it off because their collections are so extensive now that they don't know where to start and just don't want to do it now. Others have stuff coming in and going out so much, it isn't worth it to catalog. I think it's worth it for me and I enjoy keeping track. It will be interesting to look at down the road. I also keep this backed up on an external hard drive that I update once in a while. If my computer crashes, I've still got it all. Edit: I should also add that it's great having the info available when going to a show. If I'm headed to a show, I'll go to the half dollars sheet, page 4. I'll print only page 4 and it's a list of Franklins that I have or don't have. Any date that I have a MS one for which are in my IS album, I have an asterick (*) by the date. Circulated ones don't have an (*). And of course the ones I don't have just have the date, MM and the rest of the fields are blank. A perfect, instant list with grid lines, always available.[/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
>
Cataloging is Half the Fun
>
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...