| Author |
 Replies: 15 / Views: 1,540 |
|
|
New Member
United States
24 Posts |
Just curious if other folks do this, and what method they use. Personally, I built simple inventory database using Microsoft Access. The latest version of Access makes it easy to attach a picture to an individual record. (In prior versions it was a pain)
I record the Rulau number, and/or token Catalog number, the price paid, purchase date, the year stamped on the token, if any, the merchant name, the state of issuance, and any other text or noticeable mark, and the dealer name. (and of course an obverse and reverse picture)
|
|
|
|
Pillar of the Community
United States
3323 Posts |
Thanks, beancounter. I've always wanted to set up an Access database for the items in my little group. Knowing that the newer version is friendlier has made me revisit the idea. The older one, as you stated, is a pain.
I'd be surprised if nearly everyone here doesn't catalog in some manner. Adding more detail and photos would be desirable.
Edit: forgot to mention that I currently use an Excel spreadsheet. Hopefully, that could transfer easily into the applicable Access file.
"Nummi rari mira sunt, si sumptus ferre potes." - Christophorus filius Scotiae
Edited by Bump111
07/28/2018 08:50 am
|
|
Pillar of the Community
United States
743 Posts |
I use an Excel spreadsheet. List everything I buy, and anything I had with a value of $50 or more, otherwise I would be typing for months. Have pics of most of collection, but didn't link them to spreadsheet. For spreadsheet columns, I list year made, mint, item, denomination, grade, finish, metal, purchase date, purchased from, cost, value (for coins I had), TPG Company, TPG Serial # For example: 1971 - S - Eisenhower dollar - $1 - PF69 - Proof - 40% Silver - 1/1/2000 - John Doe Coins - $35.00 - - NGC - 1234512345 |
|
Pillar of the Community
5464 Posts |
|
|
Pillar of the Community
United States
2023 Posts |
Considering this is in the token/medla/exonumia category, several of these usual columns don't apply (mint, TPG data) or are a bit more arbitrary (year, grade, value). Third-party software may or may not be able to handle the kind of data relevant to these items. I collect San Francisco tokens/medals and use a spreadsheet with: Type (theme/merchant/general description), Address (if shown on the piece), Kappen (ID in his California Tokens book, if applicable), Year (if known), purchase price and date, and other general notes. I don't keep pictures yet but I should -- some issues have different designs and I don't always remember which I have, especially for the expositions, cable cars and the Mint. |
|
Pillar of the Community
United States
4085 Posts |
I just use an Excel spreadsheet. I track date and mintmark, denomination and type, grade, approx. value, purchase price and if they are part of a set.
|
|
Pillar of the Community
Canada
798 Posts |
|
|
New Member
 United States
24 Posts |
Quote:
I've always wanted to set up an Access database for the items in my little group. Knowing that the newer version is friendlier has made me revisit the idea. The older one, as you stated, is a pain. Here's a link to instructions on how to add pictures to records in the latest version of Access: https://support.office.com/en-us/ar...baad6dbd#bm2 |
|
Pillar of the Community
United States
3323 Posts |
I appreciate the link, Beancounter.
"Nummi rari mira sunt, si sumptus ferre potes." - Christophorus filius Scotiae
|
|
Pillar of the Community
United States
587 Posts |
I use Excel. Each category has a different sheet in the file, one for each coin in albums, plus type of album, one for mint/ proof sets, one for commemorative coins, etc. Nothing too fancy.
|
|
Moderator
 United States
187702 Posts |
Spreadsheet.
I can open in Excel, LibreOffice, Google Sheets, etc.
|
|
Bedrock of the Community
Australia
21786 Posts |
I have about 2,500 coins, covering all centuries and cultures from the beginning of coinage about 2,600 years ago.
Different series of coinages require different methods of cataloging. With my approach to collecting across the whole of numismatics, a spreadsheet system would be next to useless.
Every coin in my collection is in a fully written up 2x2, which for the more important pieces, includes such information as when acquired, from where, price paid and a full description of the coin where needed.
The collection is arranged in approximate date order, but ancient and medievalcoins do not have a date on them at all, in the normally accepted sense.
The volume of information recorded on the 2x2 can vary by a huge amount from coin to coin, and does not lend itself in any way to provide a catalog across the whole the collection.
A few of the more valuable pieces are stored in a small album in a safe. With these pieces, the coins are still arranged in approximate date order.
Perhaps if I was to catalog my collection on a digital file, there would be a listing of approximately 2,500 entries in approximate date order. The information in each listing would be a shortened version of what is written on the 2x2 flips.
There is little need for me to do this, except in case of theft.
Much more important is to have a photographic record of each coin in it's 2x2. I have already done this for about 250 of my more valuable coins.
|
|
Pillar of the Community
Belgium
1194 Posts |
For every coin ,I make a file , classed in my PC first by period (Ancients , Medieval...),then by country(civilisation)(Ancients: Greece , Rome ?Persian..),and if needed in the country by region .For the most beautiful and interesting coins , I print the file and keep it in a map .It is a lot of maps and my wife don't like it because there are all the time maps in the house ...
For every coin , there are 2 photos , a full description ,eventualy some remarks and the invoice , but I don't mention the price on the file .
I like my system because I often leave the house for 1 or 2 weeks and it is easy to take some maps with me .
Most of my coins are in boxes and the most valuable are stored in a safe .
It is a lot of work to do this , but it gives a lot of pleasure by looking the coins in the maps . albert
|
|
Valued Member
United States
330 Posts |
I've been using Excel, it works well enough and lets me practice researching and grading things.
|
|
Pillar of the Community
United States
719 Posts |
Coin Elite, Excel and also a Word document text. Triple entry but the brain works different ways for different issues. The medals and tokens have to be manually entered in Coin Elite.
|
|
Pillar of the Community
United States
772 Posts |
I don't track everything I own currently, but I do use Excel for all of my coin roll hunting as well as large lots of coins I buy from various places.
|
| |
Replies: 15 / Views: 1,540 |
|
Posted 07/28/2018 10:29 am
