Coin Community Family of Web Sites Join Thousands of Coin, Bullion, & Money Collectors
Royal Estate Auctions - $1 Coin AuctionsVancouvers #1 Coin and Paper Money Dealer Join Thousands of Coin, Bullion, & Money Collectors 300,000 items to help build your collection! Coin, Banknote and Medal Collectors's Online Mall Specializing in Modern Numismatics Royal Canadian Mint products, Canadian, Polish, American, and world coins and banknotes.








Username:
Password:
Save Password
Forgot your Password?


This page may contain links that result in small commissions to keep this free site up and running.

Welcome Guest! Registering and/or logging in will remove the anchor (bottom) ads. It's Free!

How To Catalog Collection Or Spreadsheet

To participate in the forum you must log in or register.
Author Previous TopicReplies: 32 / Views: 19,883Next Topic
Page: of 3
Bedrock of the Community
Learn More...
CelticKnot's Avatar
United States
12839 Posts
 Posted 03/23/2015  11:03 pm  Show Profile   Bookmark this reply Add CelticKnot to your friends list Get a Link to this Reply
@Tbone... pretty cool. I never thought about putting a picture in the comment of a cell. Nice!
Valued Member
Fireman638's Avatar
Canada
158 Posts
 Posted 03/23/2015  11:09 pm  Show Profile   Bookmark this reply Add Fireman638 to your friends list Get a Link to this Reply
Awesome, great info TBone, that is great information.....and gives me a little something to do this weekend. Thanks so much!
Pillar of the Community
Tbone's Avatar
United States
1839 Posts
 Posted 03/23/2015  11:20 pm  Show Profile   Bookmark this reply Add Tbone to your friends list Get a Link to this Reply
Glad you like it, have fun with it.

Here's a video that may help

YTbl9jf5KWY
Pillar of the Community
Joe2007's Avatar
United States
3843 Posts
 Posted 03/24/2015  12:21 am  Show Profile   Bookmark this reply Add Joe2007 to your friends list Get a Link to this Reply
Pictures tend to get a bit bulky and balloon the size of your excel file unless you downsize them.
Pillar of the Community
jpbone's Avatar
United States
1959 Posts
 Posted 03/24/2015  09:40 am  Show Profile   Bookmark this reply Add jpbone to your friends list Get a Link to this Reply
Here is a screenshot of what the app looks like from the App Store.

How-To-Catalog-Collection-Or-Spreadsheet
Pillar of the Community
jpbone's Avatar
United States
1959 Posts
 Posted 03/24/2015  09:41 am  Show Profile   Bookmark this reply Add jpbone to your friends list Get a Link to this Reply
TBone. I just read your edit. Maybe it will be available on Android soon.
Valued Member
Ed52151's Avatar
United States
56 Posts
 Posted 03/25/2015  09:02 am  Show Profile   Bookmark this reply Add Ed52151 to your friends list Get a Link to this Reply
The App Store will have what you are looking for.
Bedrock of the Community
United States
20753 Posts
 Posted 03/25/2015  10:05 am  Show Profile   Bookmark this reply Add just carl to your friends list Get a Link to this Reply
Just keep remembering that all the excess information you enter now will soon be just that, excessive. For a small collection lots of that info is fun, but once you get, if you get, many thousands of coins, what would your files look like. A photo of each coin would take up the entire hard drive. For example I have well over 3,000 Mercury dimes. Even attempting to document all of them would take just to much time and effort. This is why I've now gone to simple records in Excel.
Pillar of the Community
Neo13x's Avatar
United States
604 Posts
 Posted 03/25/2015  10:52 am  Show Profile   Bookmark this reply Add Neo13x to your friends list Get a Link to this Reply
I agree with Just Carl. I can see using a reference picture for each type of coin. Other than that why have a picture for each coin? You can have a numbering system in place that could refer to each coin instead of having the pictures. It would give you the excuse to pull out your collection and enjoy them once in a while.


Quote:
date, mint, Grade and estimated value. Really don't need more than that if it's just a hobby

I agree

Also I would recommend having a different sheet for each type coin or mint set to help keep things organized. I would have sheets like The Red Book has everything broken up in sections.
Pillar of the Community
jpbone's Avatar
United States
1959 Posts
 Posted 03/25/2015  1:08 pm  Show Profile   Bookmark this reply Add jpbone to your friends list Get a Link to this Reply
I only individually document coins with considerable value. Bags of Mercury dimes, wheat pennies etc. I don't bother with entering into my system. Now that I'm caught up with my collection, I enter them as I purchase them.
Valued Member
Ed52151's Avatar
United States
56 Posts
 Posted 03/25/2015  2:45 pm  Show Profile   Bookmark this reply Add Ed52151 to your friends list Get a Link to this Reply
Excessive information may seem tedious, but believe me, when it comes to insurance claims in case of a fire or robbery, you'd be wise to have so much info that you overwhelm the claims adjuster with it if you want any chance of recovering a single dime.
Bedrock of the Community
Learn More...
CelticKnot's Avatar
United States
12839 Posts
 Posted 03/26/2015  01:41 am  Show Profile   Bookmark this reply Add CelticKnot to your friends list Get a Link to this Reply

Quote:
...but once you get...many thousands of coins, what would your files look like. A photo of each coin would take up the entire hard drive. For example I have well over 3,000 Mercury dimes.

I agree with the sentiment but even if you have 3,000 10MB files, that's "only" 30 GB. While that's a downright stupid size for an Excel spreadsheet (and not possible unless you have the 64-bit version, which is not common), it won't come close to filling a modern drive.

I'm just being argumentative here - of course you're correct, who in their right mind would photograph all 3k dimes? No one. What's the point?

Now I CAN see photographing slabbed coins or coins worth more than, say, $50 (or pick your number).


Quote:
...when it comes to insurance claims in case of a fire or robbery....

If you hope to get anything over face value, you better have a rider on your home insurance policy or a separate policy to begin with. Otherwise most insurance companies will only reimburse you for face value, and then only up to a certain amount.

I don't disagree with keeping detailed records and taking lots of photos though. Everything helps, particularly with the police investigation in thefts.
Edited by CelticKnot
03/26/2015 01:43 am
Bedrock of the Community
sel_69l's Avatar
Australia
21788 Posts
 Posted 03/26/2015  07:58 am  Show Profile   Bookmark this reply Add sel_69l to your friends list Get a Link to this Reply
Depends on the nature and size of your collection.

I have a world collection covering the last 26 centuries.
Each coin has it's own description written on it's own 2x2, which have a huge variation from another coin from a different culture and century. That makes consistent description across the whole collection, and consistent cataloging across the whole collection, very difficult.

Perhaps my collection should be subdivided, to reflect the different description and cataloging styles needed.

About a dozen of my most valuable coins are photographed and all of their purchase information stored separate to the collection.
Edited by sel_69l
03/26/2015 08:02 am
New Member
rob_ccs's Avatar
Australia
36 Posts
 Posted 03/15/2016  06:29 am  Show Profile   Bookmark this reply Add rob_ccs to your friends list Get a Link to this Reply
I use a "Custom Inventory System". It currently has 2491 records with 3.45GB of pictures - so Excel isn't really an option.

*** Staff Edit: Link removed. Please let us get to know you before posting personal links ***

If you do want to use Excel with large numbers of images you can put something like this in one of the cells: file://C:\COINS\IMAGES\FLORIN\79490o.jpg
Excel will treat it as a hyperlink - click on it and the image (C:\COINS\IMAGES\FLORIN\79490o.jpg in this example) will be displayed in your web browser. (The aforementioned inventory system can import from Excel and has some nice features.)
New Member
rob_ccs's Avatar
Australia
36 Posts
 Posted 06/11/2016  04:02 am  Show Profile   Bookmark this reply Add rob_ccs to your friends list Get a Link to this Reply
Fair enough to disable the link Eds - better to be safe than sorry. Anyone who's interested can Google the program by name anyway.

I note that there's a new version and the "Zoom" feature, especially, is one I'll be using a lot more now that it's been improved (at least in the paid-for version).
  Previous TopicReplies: 32 / Views: 19,883Next Topic
Page: of 3

To participate in the forum you must log in or register.



    




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 - 2026 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 - 2026 Coin Community Forums
It took 0.42 seconds to rattle this change. Forums