| Author |
 Replies: 24 / Views: 33,045 |
|
|
|
Pillar of the Community
United States
2049 Posts |
I use a spreadsheet with the following columns (I am going off of memory since I am at work): Denomination (Cent, Nickel), Set (Indian Head, Lincoln), Date, Mintmark, Grade, TPG if applicable, Retail Value (taken from Coin Values), my cost, notes (such as small motto or full split bands), quantity, extended value, and location (whether I have it in a safe, safe deposit box, album, etc) It's not perfect, but it has the info that I like to see. |
|
Valued Member
United States
130 Posts |
Excel works fine but I bought Coin Manage. I could have spent hours setting up a template or $49 to have it done for me.
|
|
Valued Member
United States
85 Posts |
Glad to see a user of Coin Manage, Mike. I have it, too, but gave up using it when I couldn't figure out how to make a report. Will you help me? When I add a coin, sometimes I have multiples, such as maybe 33 dimes of a certain year. If I use print out a report, I can't figure out how to make it show me the extended price of the 33 times $.xx cost. It only shows me the cost of one. Does each coin have to be on a separate record or is there a way to see the extended value on a report?
I made my own spreadsheet with headings very much like CoinHunter. It works pretty well.
|
|
Valued Member
United States
130 Posts |
Bobbi,
I can take a look tonight see if I can remember how! I normally just log coins in or out and search.
|
|
Valued Member
United States
250 Posts |
On certified coins, I use the "My Collection" program at Heritage Galleries. It's free and actually gives you what I believe are better values over PCGS.
On raw coins, I don't really do anything with them other than putting them in holders or albums
|
|
Valued Member
United States
130 Posts |
Bobbi, All of my coins are entered individually. I did try to add an ASE in a multiple of 2 and see if the database calculated it properly. It did not! So, I think you are right in that you won't get an accurate report if you log in (say) 10 Kennedy halves. Not a problem for me as 10 Kennedy halves of the same year means I have 9 to sell :) But, it may not be to your liking. |
|
Valued Member
United States
85 Posts |
Thank you, Mike. I thought it probably would only do individual coins, as the likelihood of having identical multiples was probably not sufficient to fool around with another query calculation. I'm still trying to figure out just how I want to inventory what dear husband has and where to go from here. My homemade spread sheet works okay so far. The inaccuracies are only a result of the incorrectly input data.
|
|
Valued Member
United States
130 Posts |
I had the same issue from what my father left me. I used paper to start with. As I assimilated his collection, Coin Manage helped me enter it quickly and add photo's of those I really cared about. I'll bet advanced reporting is available. If I play with it and get some success, I'll let you know.
|
|
Pillar of the Community
United States
581 Posts |
I have Coin Manage too. Not sure if you can do multiples - probably because you couldn't have pictures of each one of them. The other reason is that it's unlikely that 10 coins will be EXACTLY the same grade and have the same rim nicks and so on and so forth.
For expensive coins, this makes sense, but can be frustrating for the common stuff of recent years.
|
| |
Replies: 24 / Views: 33,045 |
First Page
Posted 03/05/2008 8:08 pm
