| Author |
 Replies: 36 / Views: 5,479 |
Page 3 of 3
|
|
|
|
Pillar of the Community
1325 Posts |
I have a question for those that use spreadsheets and HTML pages and such like I do. If you also keep coins stored in a book/album/folder that has the info on the coin for you like mintages, does your spreadsheet also contain the mintages and info found where the coin actually is? I have it for my spreadsheet on coins I need like my curious keeping of the under 20 million mintage Kennedy halves and the like of ATB, but not for anything else in my "need" spreadsheet and not on my HTML pages. So what info is most often in a collection tracking spreadsheet? |
|
Valued Member
Netherlands
74 Posts |
Excel. I have for the more recent coins (last 200 years) a complete list of all coins minted in the Netherlands, with all relevant info like weight, mintage, material etc. plus (if I have the coin) when and where I bought it for what price and in what quality.
Each row contains 1 coin. When opening the spreadsheet, in each row two comments are placed automatically with photos of the relevant coin (one for front, one for back). That way on mouse-over I will see the photo of my coin.
For pre-1800 coins I just have a list of the coins I have, again with all the relevant info and photos.
@shadz, I don't have info like mintages in the album where I keep the coins: the 2x2's don't have that much space to write on. I only write enough there to identify the coin, and keep all other info in the spreadsheet.
|
|
Pillar of the Community
Belgium
1194 Posts |
I make a sheet for every coin I have with : face value obverse: inscription and description of the coin reverse: the same picture size period references quality mint date I bought the coin if necessary :further details I keep always a copy of the invoice. Then I print everything. albert  |
|
Pillar of the Community
 United States
5828 Posts |
antwerpen2306, I know I should do that but I've been procrastinating for so long I don't even know if it's possible any more...
I use Google Sheets for my list of coins. Check it out in my signature!
|
|
Pillar of the Community
United States
2233 Posts |
I just got a Numista account! Yippee!  |
|
Moderator
 United States
189340 Posts |
Quote:
So what info is most often in a collection tracking spreadsheet? I may have mentioned this a time or two or three, but my headers are simple: Date, Mint, Variety, Value, Date Acquired, Cost, Grade, Notes. |
|
Pillar of the Community
Belgium
1194 Posts |
ChildOfTheWeat , it is always possible , I started three years ago and have not yet finished , but it is very pleasant to look all the sheets you made.I print only the very fine and better coins to take it with me when I go to my holiday home near Bastogne ( you know : nuts.. ). I don t like to look my coins on pc.albert
|
|
New Member
United States
29 Posts |
I like numista for foreign coins, for US I use Excel and backup on Google Docs
|
|
Valued Member
Slovenia
459 Posts |
antwerpen2306: I really like your system. I used to catalogue my silver coins with a software we use at work, but I find it too time consuming (well: work), so I stopped doing that.
|
|
Pillar of the Community
Australia
7096 Posts |
I gave up trying to keep track of what I have years ago, Far too much of a hassle. Anyway every now and then I do a "Bin Dive" through my various draws and cupboards and I just Love finding stuff that I had totally forgotten about |
|
Pillar of the Community
Canada
1269 Posts |
I collect ancient Roman coins. I only have 14 of them at the moment so keeping track is not a current problem. I have Word document that lists all of the attributions for the coins. Each coin is in a mylar flip with a piece of paper. On the paper is noted the following information: attribution, place of purchase, date of purchase, amount paid.
|
|
Pillar of the Community
United States
3644 Posts |
I like it Child of the Wheat...id also like to hire you to come inventory mine! This is a good thread
|
|
Valued Member
United States
86 Posts |
ii have a half inch binder with a list of all US coins ever made. I cross out the ones I have. I am also compiling a list of key dates there. The list I downloaded from about.com titled "The complete checklist of United States coins." I have been keeping an inventory on Excel. But it's becoming very unmanageable. Plus it tells me what I have not what I am missing. I downloaded the excel template from somplace on the internet. It is very detailed with quantity, description, demoniation, mkt value, cost paid, location, how obtained, etc. Edited by AlabamaDan
08/16/2015 3:46 pm
|
|
Pillar of the Community
1153 Posts |
Quote:
So what info is most often in a collection tracking spreadsheet? I use excel, and my table header is: Date/Coin, Condition, Type, Face Value, Date bought, paid, retail price, location (loose, dansco, etc) |
|
Pillar of the Community
United States
717 Posts |
Another vote for google docs, also use google drive for pictures of coins that I have photographed. Both accessible on my phone if needed at LCS.
|
|
Page 3 of 3
|
Replies: 36 / Views: 5,479 |
Page 3 of 3
|
First Page
Previous Page
Posted 08/11/2015 03:49 am
