| Author |
 Replies: 20 / Views: 16,333 |
|
Pillar of the Community
United States
842 Posts |
Hey all! I assume that many of you try and keep your collections well organized and documented. A while back I wanted a spreadsheet that could track my silver coins and give me the total weight and current market value. I created this in Microsoft Excel, and I hope that it may be of use to some of you. Screenshots:   How it works: You simply have to put the number of coins you own into each category. There is a formula that will calculate the total silver weight for U.S. coins, foreign coins, and bullion. Then another formula will add those three weight categories together and display your total silver weight. Finally, a third formula will take that final weight and multiply it by the current melt value of silver to give you a value for your silver. Of course, you can add categories or delete them to suit your needs. You have to manually change the current melt value, and that is located in cell block G4 (hidden from view so the document looks nice). If you would like a copy of this document to use it for your collection, send me an email and I will happily forward it to you. If you use it and run into any problems or do not know how it works, I will help you out with all that as well. Thanks for the read! |
|
|
|
New Member
United States
34 Posts |
Thank you. I will have to give this a try. I have been looking to do something similar and this would be just what I am looking for.
Edited by onecenter
01/28/2013 8:13 pm
|
|
Pillar of the Community
United States
1511 Posts |
Wow, that's great, I've also been looking for something just like this!
|
|
Moderator
 United States
14463 Posts |
I have an idea of what I have, I will tryout your file to see if I was close. PM on the way
|
|
Pillar of the Community
United States
2130 Posts |
I would like to try this also...I will send you a PM. Looks Great!
|
|
Pillar of the Community
United States
1088 Posts |
Thanks for sharing PM on the way for me as well.
|
|
Pillar of the Community
United States
1195 Posts |
I've got a similar spreadsheet going where I track my purchases and trades that involve me getting silver. I also have it calculate my silver holdings in grams, ozt and moles.
|
|
Pillar of the Community
United States
1116 Posts |
I do something very similiar to this for my bullion. Only I also put in what my purchase price was, date of purchase, current value (updated once a day).
The only thing that I have not done is to track my purchases that are placed into an album. Since I have a number of albums and have been collecting for a couple of years, I really have no idea about purchase cost. I am also a poor grader so I have no idea of what both the grade would be as well as what the current value is of those coins.
I think that the best thing I could do would be to itemize my albums into a spreadsheet similiar to what you have there.
It is truly an idea who time has come. Thanks for sharing.
|
|
Valued Member
United States
379 Posts |
Great idea! I need to brush up on my formulas. I'm a lost soul trying to select the right formulas on Excel.
|
|
Pillar of the Community
Canada
3167 Posts |
|
|
Valued Member
United States
81 Posts |
This sounds like a good way to start organizing my coins, pm sent, thanks.
|
|
Pillar of the Community
 United States
842 Posts |
Alright! I have replied to everyone I have received an email from so far. Let me know how it goes. Thanks again for all the interest! Glad to help.
|
|
Pillar of the Community
Canada
3167 Posts |
Looks great! I'll try it out when I get a chance to check my inventory.
Thanks!
|
|
Moderator
United States
14463 Posts |
I got the spreadsheet, and tried it out. It works pretty well.  It has a few coins I don't have, and missed a few I do. Its calculation and my calculation were less than 1% different. |
|
Valued Member
United States
207 Posts |
Thanks for sending that. I will let you know how it works for me.
|
|
Valued Member
United States
152 Posts |
Hello, I was wondering if you could send me the spreadsheet file for calculating silver in my collection. I tried to send you an email but it wouldn't let me. My email is qktbird at yahoo . com
Thanks,
Jon P.
|
| |
Replies: 20 / Views: 16,333 |
Posted 01/28/2013 9:19 pm
