Coin Community Family of Web Sites
Like us on Facebook! Subscribe to our Youtube Channel! Check out our Twitter! Check out our Pinterest!
Username:
Password:
Save Password
Forgot your Password?

Welcome Guest! Need help? Got a question? Inherit some coins?
Our coin forum is completely free! Register Now!

What Categories Should I Use To Categorize Coins?

First Page
Showing last 15 replies.
 
To participate in the forum you must log in or register.
Author Previous TopicReplies: 19 / Views: 3,083Next Topic Page 2 of 2
Moderator
Learn More...
United States
87505 Posts
 Posted 08/19/2016  10:32 am  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply

Quote:
I am making an Excel spreadsheet for my coins.
Good choice.

Mine has Date, Mint, Variety (when necessary), Value, Date Acquired, Cost, Grade, Notes (usually where acquired).

Here are some previous threads for more opinions...

http://goccf.com/t/167164
http://goccf.com/t/89375


Pillar of the Community
United States
513 Posts
 Posted 08/19/2016  11:54 am  Show Profile   Bookmark this reply Add Garoyn to your friends list Get a Link to this Reply

Quote:
Now what if you don't remember every price paid because you purchased some years ago and didn't decide to catalog until a week ago


So don't include those values. But if you include price paid and date acquired as columns in the spreadsheet, you'll fill them in for new acquisitions and five years from now you'll have a pretty good looking set of price paid/date values.
Pillar of the Community
United States
513 Posts
 Posted 08/19/2016  11:58 am  Show Profile   Bookmark this reply Add Garoyn to your friends list Get a Link to this Reply
Also, consider a country column. Even if only doing US coins now, you may want to add those odd Canadians you find, or maybe include a foreign coin given to you by a friend/family member (anybody travel?), or at least it is a reminder that you can branch out to inexpensive coins by getting some cool-looking foreign coins.

Of course, you can always add a country column later, but then you won't have the reminder {grin}
Moderator
Learn More...
United States
87505 Posts
 Posted 08/19/2016  12:15 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply

Quote:

Quote:
Now what if you don't remember every price paid because you purchased some years ago and didn't decide to catalog until a week ago
So don't include those values. But if you include price paid and date acquired as columns in the spreadsheet, you'll fill them in for new acquisitions and five years from now you'll have a pretty good looking set of price paid/date values.
Agreed. My "cost" columns have a lot of blanks.
Pillar of the Community
Canada
1744 Posts
 Posted 08/19/2016  1:46 pm  Show Profile   Bookmark this reply Add ace_ftw to your friends list Get a Link to this Reply
how about metal content? 90% silver 40% silver cupronickel etc. what about mintages? might be hard if you are talking about errors or vaieties, but general mintage would be intersting.

also how are you cataloging your collection? you might want to add a number system for your own records, like album 1, or box 1 (you can define this as much as you want down to page, and position) so that you dont need to dig around years later to look for that one coin.

I am sure many of us have "lost" a coin only to find it months or years later when looking for something else.
Moderator
Learn More...
United States
87505 Posts
 Posted 08/19/2016  3:11 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply
For what it is worth...


Quote:
how about metal content? 90% silver 40% silver cupronickel
I put that in the Variety column.


Quote:
etc. what about mintages?
I do not record those now, but I could easily add a column if I ever thought it was necessary. This is why I like spreadsheets.
Pillar of the Community
United States
1746 Posts
 Posted 08/19/2016  4:09 pm  Show Profile   Bookmark this reply Add Alpha2814 to your friends list Get a Link to this Reply
For slabbed coins, I include the certification number for insurance purposes. (I also take pictures but those aren't in the spreadsheet, obviously.)
Pillar of the Community
Canada
1744 Posts
 Posted 08/19/2016  4:14 pm  Show Profile   Bookmark this reply Add ace_ftw to your friends list Get a Link to this Reply
jbuck, for varieties I would only be listing things like DDO DDR large/small date etc. as a distinction from just a normal pds mint coin.
Moderator
Learn More...
United States
87505 Posts
 Posted 08/19/2016  4:26 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply
True, but I only collect major varieties (that which fills a Dansco hole). For example, I have noted the 1976 Eisenhower dollar varieties, large/small date Lincoln cent varieties, etc. Since that column goes largely unused, I can be a bit more flexible as to what it contains.
New Member
United Kingdom
7 Posts
 Posted 01/29/2017  1:35 pm  Show Profile   Bookmark this reply Add latiina to your friends list Get a Link to this Reply
Hi, probably you have made the spreadsheet already.
What categories did you include at the end?
As I collect by design I have country, KM no,year, denomination, series name/important note, design, diameter, material, grade, cost, what sort of coin is it (meant for circulation, commemorative, fantasy).
The spreadsheet keeps changing though. Now it's version no 3.
Pillar of the Community
United Kingdom
2493 Posts
 Posted 01/29/2017  3:36 pm  Show Profile   Bookmark this reply Add DavidUK to your friends list Get a Link to this Reply
I include description (including catalofue numbers), size, weight, year, cost, where and when attained, material, mintage number, grade, miscellaneous comments.

For ancient coins mintage numbers and grade aren't applied... for modern coins size and weight aren't unless its precious metal.

Just my personal preference.
Edited by DavidUK
01/29/2017 3:37 pm
Pillar of the Community
United States
7260 Posts
 Posted 01/30/2017  4:31 pm  Show Profile   Check westcoin's eBay Listings Bookmark this reply Add westcoin to your friends list Get a Link to this Reply
A unique ID tag for each record is a good start, a description and photo area, whether or not coin is TPG graded and slabbed, by which service, variety sub set, date purchased as well as date sold and price paid profit/loss made (good for insurance if needed), report function included if possible.
"Buy the Book Before You Buy the Coin" - Aaron R. Feldman - "And read it" - Me 2013!
ANA Life Member #3288 in good standing since 1982, EAC Member #6202, NBS Member, 2 variety collector.

See my want page: http://goccf.com/t/140440
Bedrock of the Community
United States
19337 Posts
 Posted 02/02/2017  1:44 pm  Show Profile   Bookmark this reply Add just carl to your friends list Get a Link to this Reply
Keep it simple. As a collection grows and grows, to many items to keep track of becomes useless. I used to have many columns in a spread sheet but with thousands of coins, what you have is all you'll ever need.
just carl
Pillar of the Community
United States
1716 Posts
 Posted 02/02/2017  3:20 pm  Show Profile   Bookmark this reply Add The_Duke to your friends list Get a Link to this Reply
As your collection grows, you might consider a database (such as MS Access) instead of a spreadsheet.
Moderator
Learn More...
United States
87505 Posts
 Posted 02/02/2017  6:16 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply
My spreadsheet has scaled very well with my collection. However, ones mileage may vary and creating a true database is an option worthy of consideration.
Page 2 of 2   Previous TopicReplies: 19 / Views: 3,083Next Topic  
First Page
Showing last 15 replies.
 
To participate in the forum you must log in or register.

Coin Community Member eBay Sales

Certified Coins   Certified VAMs   Certified Errors  




Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2020 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us  |  Advertise Here  |  Privacy Policy / Terms of Use

Coin Community Forum © 2005 - 2020 Coin Community Forums
It took 0.86 seconds to rattle this change. Powered By: Snitz Forums 2000 Version 3.4.05