Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Organizing Coins
>
Reply to Thread
Message:
<p>[QUOTE="Phil Ham, post: 967147, member: 5787"]I use Excel to inventory my coins. I typically have the dataset sorted by country and denomination. I include lots of stuff on every coin such as year, mintage, mint mark, variety, coinage metal, grade, quantity, purchase price, market price, lot value, bought from, purchased date, and other comments. The great thing about Excel is that you can create your own format, it's easy for most to use, and you can sort and query in seconds. In the same spreadsheet, I have tabs on American coins such as cents, nickels, dimes, quarters, proof sets, etc. so that I know which coins that I'm missing. I will list the year in the first column and have columns such as book 1, book2, ... and loose coins with a total on the far right. I will darken fields that aren't applicable to the years in the book. I also have a coin collector's program called Coin Assistant that I got as a gift. It is nice in that you can pick the coin out of a drop down menu and it fills in a lot of information such as mintage, coin metal, designer, etc. I also provides a coin value that seems to be way over valued. Thus, I use my Excel spreadsheet to quickly determine the value of my collection.[/QUOTE]</p><p><br /></p>
[QUOTE="Phil Ham, post: 967147, member: 5787"]I use Excel to inventory my coins. I typically have the dataset sorted by country and denomination. I include lots of stuff on every coin such as year, mintage, mint mark, variety, coinage metal, grade, quantity, purchase price, market price, lot value, bought from, purchased date, and other comments. The great thing about Excel is that you can create your own format, it's easy for most to use, and you can sort and query in seconds. In the same spreadsheet, I have tabs on American coins such as cents, nickels, dimes, quarters, proof sets, etc. so that I know which coins that I'm missing. I will list the year in the first column and have columns such as book 1, book2, ... and loose coins with a total on the far right. I will darken fields that aren't applicable to the years in the book. I also have a coin collector's program called Coin Assistant that I got as a gift. It is nice in that you can pick the coin out of a drop down menu and it fills in a lot of information such as mintage, coin metal, designer, etc. I also provides a coin value that seems to be way over valued. Thus, I use my Excel spreadsheet to quickly determine the value of my collection.[/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
>
Organizing Coins
>
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...