| Author |
 Replies: 15 / Views: 2,596 |
|
|
Valued Member
United Kingdom
126 Posts |
Hi,
I have loads to go through and am writing things on paper but is there software e.g a simple free app that can store a description and an image and search key words.
That's easy to use ?
Sue
|
|
|
|
Pillar of the Community
United States
5825 Posts |
A spreadsheet (I use Excel) is most often used.
Allows you to tailor your input to your tastes, and they change you do your own editing.
You can even put an image on your computer and have a link in the spreadsheet.
|
|
Pillar of the Community
United States
4963 Posts |
 Excel is probably the best way to go. Each coin worth more than a few dollars is numbered, and I have a folder of images named by number for easy reference. My spreadsheet has 42 columns for just about everything I could possibly want to keep track of. |
|
Bedrock of the Community
Australia
21786 Posts |
The most practical 'app' I have found is to write a full description of the coin, along with when, and how much paid for it, on the 2x2 which holds it.
If you wish to move the coin to a different part of your collection or to re arrange your collection, all of the information relating to the coin moves with it.
I do the same with the photographic record of my collection.
Bonus: There is never any need to update your data base, because you don't need one.
An app with pictures perhaps useful if even a small part of your collection is slabbed or in push in holes. If that is the case, you must have a 100% reliable way of linking your slabbed or album coins to your data base, particularly if your collection is large.
A downside may be that if you relocate a coin or you rearrange your collection, the date base will have to reflect this.
Museums use data bases to manage their very large and diverse collections, but professional curators are employed. Perhaps it may be worthwhile to visit a museum with a large collection, and ask how they go about it.
|
|
Pillar of the Community
 United States
7939 Posts |
Excel for me, too. Though I've got fewer than a dozen columns: Country Ruler Date/Date Range Mint Denomination Catalog Ref Grade Provenance Price paid Comments As @sel said, much of this can be fit on the 8 corners of a 2 x 2 Purchase Edited by tdziemia
04/05/2021 10:21 am
|
|
Valued Member
 United Kingdom
126 Posts |
Thank you all. Will learn excell.
|
|
Moderator
 United States
188213 Posts |
Add me to the list of spreadsheet users. This has been my go-to solution for well over three decades now.  |
|
Pillar of the Community
United States
9792 Posts |
I use Filemaker Pro database. Write my own database, it's not a hard thing to learn, and now it's getting even easier these days. There are free options either with spreadsheet or database through Open Office software.
"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
4963 Posts |
Quote:
Thank you all. Will learn excell. It's absolutely worth it. Once you're familiar, it's good for practically everything. |
|
Moderator
United States
188213 Posts |
Quote:
Once you're familiar, it's good for practically everything. I use spreadsheets for everything. Budgets, investments, logs, "Guess The Price," and so on...  |
|
Valued Member
United Kingdom
126 Posts |
My laptop had Excel so I started from a template and put in my first record which has tdziemia text fields and a photo hyperlink. Well actually hubby did it lol. He said I have so many coins that it is far more efficient if I just scan both sides of 100 coins or what fits the scanner at 1200 dpi and can always cut out the TIFF of a coin of interest and JPEG it if I need to post it.
|
|
Moderator
United States
95621 Posts |
Quote:
It's absolutely worth it. Once you're familiar, it's good for practically everything. I agree with that. I use Excel for everything. I don't even use Word anymore. It's far easier to document and move things around in an Excel sheet. |
|
Moderator
United States
188213 Posts |
Quote:
He said I have so many coins that it is far more efficient if I just scan both sides of 100 coins or what fits the scanner at 1200 dpi and can always cut out the TIFF of a coin of interest and JPEG it if I need to post it. That worked for me when scanning old photos. |
|
Valued Member
Australia
66 Posts |
I am addicted to Excel, so use it for coin collecting too.
|
|
Moderator
United States
188213 Posts |
Quote:
I am addicted to Excel, so use it for coin collecting too.  I use spreadsheets for many, many things.  |
|
Valued Member
United States
191 Posts |
Certainly, Excel (or a similar spreadsheet) is the way to go.
|
| |
Replies: 15 / Views: 2,596 |
|
Posted 04/05/2021 08:00 am
