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








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.
First Page Previous Page  Showing last 15 replies.
Author Previous TopicReplies: 32 / Views: 19,886Next Topic Page 3 of 3
Pillar of the Community
United States
1839 Posts
 Posted 03/23/2015  11:20 pm  Show Profile   Bookmark this reply Add Tbone to your friends list
Glad you like it, have fun with it.

Here's a video that may help

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

How-To-Catalog-Collection-Or-Spreadsheet
Pillar of the Community
United States
1959 Posts
 Posted 03/24/2015  09:41 am  Show Profile   Bookmark this reply Add jpbone to your friends list
TBone. I just read your edit. Maybe it will be available on Android soon.
Valued Member
United States
56 Posts
 Posted 03/25/2015  09:02 am  Show Profile   Bookmark this reply Add Ed52151 to your friends list
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
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
United States
604 Posts
 Posted 03/25/2015  10:52 am  Show Profile   Bookmark this reply Add Neo13x to your friends list
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
United States
1959 Posts
 Posted 03/25/2015  1:08 pm  Show Profile   Bookmark this reply Add jpbone to your friends list
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
United States
56 Posts
 Posted 03/25/2015  2:45 pm  Show Profile   Bookmark this reply Add Ed52151 to your friends list
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...
United States
12839 Posts
 Posted 03/26/2015  01:41 am  Show Profile   Bookmark this reply Add CelticKnot to your friends list

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
Australia
21788 Posts
 Posted 03/26/2015  07:58 am  Show Profile   Bookmark this reply Add sel_69l to your friends list
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
Australia
36 Posts
 Posted 03/15/2016  06:29 am  Show Profile   Bookmark this reply Add rob_ccs to your friends list
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
Australia
36 Posts
 Posted 06/11/2016  04:02 am  Show Profile   Bookmark this reply Add rob_ccs to your friends list
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).
Pillar of the Community
United States
1298 Posts
 Posted 06/11/2016  08:26 am  Show Profile   Bookmark this reply Add Ham1947 to your friends list
I have a spreadsheet using Apple's Numbers. Anyone know how to add a coin photo to a cell in Numbers? Thanks.
Pillar of the Community
Norway
1358 Posts
 Posted 06/11/2016  5:27 pm  Show Profile   Bookmark this reply Add UltraRant to your friends list
I'm using an Excel workbook with several sheets. One sheet per country that I actively collect, one sheet for all Euro coins, one for all fake and counterfeit coins, one for each continent for the countries I visited, etc.

I also have a numista account, not for trading but for having a good overview with pictures. Which is especially handy when abroad and not having my excel sheet with me. The only thing with that site is that it doesn't cover all my coins. I have quite some locally issued coins (mintage sometimes just a few hundred) and counterfeit and fake coins, which are not covered there.

@Ham1947: The best way would be to throw the Apple out of the window and buy a decent pc, where you install Excel. Then follow the video by Tbone. No, seriously, for what I know it isn't possible. Not sure if allowed to place links, but here's a few links which support my assumption. http://apple.stackexchange.com/ques...l-in-numbers and https://discussions.apple.com/threa...405?tstart=0
Page 3 of 3   Previous TopicReplies: 32 / Views: 19,886Next Topic Page 3 of 3
First Page Previous Page  Showing last 15 replies.
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.34 seconds to rattle this change. Forums