| Author |
 Replies: 47 / Views: 10,400 |
|
|
|
Pillar of the Community
United States
2543 Posts |
Quote:
I should add that the reason I am creating an inventory is in the case of something happening to the collection. Having a " list " of what you had, isn't always the best thing to present to the Ins. co. I remember when my old Jeep got stolen, unfortunately I forgot to take my Stradivarius out after getting it restrung. For whatever reason, the Insurance co wouldn't accept my list of things that got stolen in the Jeep. Hence the photographic record.  Edited by denco7
10/19/2013 3:09 pm
|
|
Pillar of the Community
 Canada
3167 Posts |
|
|
Pillar of the Community
United States
2543 Posts |
My intentionally facetious point was that when covering my very expensive items under my home owners insurance, my agent always advises me to catalog with pictures and keep reciepts. Because when push comes to shove, the insurance company does not have to take your word or believe an unsubstantiated excel spreadsheet.
|
|
Pillar of the Community
Canada
3167 Posts |
|
|
Pillar of the Community
United States
1109 Posts |
Quote:
My intentionally facetious point was that when covering my very expensive items under my home owners insurance, my agent always advises me to catalog with pictures and keep reciepts. Because when push comes to shove, the insurance company does not have to take your word or believe an unsubstantiated excel spreadsheet. Exactly. That's why I catalog all my coins in an excel spreadsheet, no matter if they are a 1909-S VDB cent or a 2013 silver eagle or a 1992-D nickel, and I also photograph them as well. Every month I re-record the list and photos on a CD-RW and keep it locked up at work (separate from my house, in case it gets burglarized or burns). |
|
Valued Member
United States
66 Posts |
I have become a big fan of Wildman Exact Change Software.
|
|
Valued Member
United States
154 Posts |
Just to be contrarian, I keep track of my coins online on numista.com. Probably not as good for doing fine grain tracking like some people need, but it's basic enough for me.
|
|
Pillar of the Community
United States
9792 Posts |
I'm not using anything other than my memory right now. I used to have a self built Filemaker Pro database I used. I really should get something done, the problem I have is most of my collection is the same thing, like 1864 LM Two Cent Pieces, only they are all different varieties, it's hard to make a list when you have more than 200+ of the same coin with small variations. Because of that I often purchase duplicates (and in lesser grades)  Any ideas on how to make a database or list that would keep me from doing that would be much appreciated! I've tried listing all the known varieties on a list and checking off ones I have, but without corresponding photos, it's still not workable, and to add photos it won't do me any good with a mobile device, where I could use it at a show, the database gets too large. I also need to use photos to identify varieties I have not picked up for my collection yet. a tough problem huh? "Buy the Book Before You Buy the Coin" - Aaron R. Feldman - "And read it" - Me 2013! ANA Life Member #3288 in good standing since 1981, ANS, Early American Coppers Member (EAC), Colonial Coin Collectors Club member (C4), Conder Token Collector Club member (CTCC), Civil War Token Society (CWTS) member, Liberty Seated Collectors Club (LSCC) & Numismatic Bibliomania Society member (NBS), USMex, Member in good standing, 2˘ variety collector. See my want page: http://goccf.com/t/140440 |
|
Pillar of the Community
United States
1247 Posts |
ezcoin is great for this, the database is already built. and, you can do what I do and scan the R&O of the coin and add the image to the entry.
Easy as pie, I love this program.
|
|
Bedrock of the Community
United States
20753 Posts |
People purchase all kinds of coin programs. ONE of the best things about Excel is that after you make your listings, you can just save to a flash drive or CD or whatever and take it with you anywhere. Excel is on probably more computers than anything else.
|
|
Pillar of the Community
Canada
4944 Posts |
Edited by Canadian-Banknotes
10/22/2013 3:09 pm
|
|
Pillar of the Community
United States
7840 Posts |
I presently use Excel, but I would like to incorporate my images into an Access database...or I could watch the above ^^^^video ^^^^^.  My PCGS Registry has my coins as well, although it does not get updated as often as it should. Edited by oih82w8
10/22/2013 3:24 pm
|
|
Pillar of the Community
 United States
4592 Posts |
The problem with that method is that it actually embeds the photo into the file. Which means your Excel file will rapidly get ginormous (that's a technical term).
Better would be to embed a true hyperlink (although you don't get a thumbnail) via =hyperlink("filepath","title")
-----Burton 50+ year / Life / Emeritus ANA member (joined 12/1/1973) Life member: Numismatics International, CONECA Member: TNA, FtWCC, NETCC, EveryCountry (online) coin club Owned by three cats and a wife of 40+ years (joined 1983) Author: 3rd Edition of the Sample Slabs book, https://www.sampleslabs.info/ |
|
Pillar of the Community
Canada
3167 Posts |
That's what I have been doing. Uploading my pictures to an image hosting site and adding the hyperlink to the Excel file.
|
|
Valued Member
United States
131 Posts |
I have a book that I write all my coins down in.. When I get the coin in hand I sit down and write out the paid for price, yr, coin name and variety... this helps me put my #7070 together because I've written down all the coins needed in order since that's how I put my collections together.... then I fill in the extra information when I get the coin...
I like the idea of having a spread sheet cause it looks neater than my chicken scratch writing... I'm going to get the wife to draw me some up on the computer and do them for each book or set I am putting together...
thanks to everyone for the great ideas.. I love the collaboration here... PEACE ...
|
| |
Replies: 47 / Views: 10,400 |
First Page
Posted 10/19/2013 2:47 pm
