| Author |
 Replies: 20 / Views: 16,391 |
Page 2 of 2
|
|
|
|
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.
|
|
Pillar of the Community
United States
842 Posts |
Spreadsheet has now been sent out to everyone that has requested it. I hope it is working well for you! Several people have responded saying it works great....I am glad!  |
|
New Member
United States
1 Posts |
This looks to be a great tool. Since I am a new user and can't contact through the normal channel, would it be out of place to ask for the spreadsheet here? My email address is tim_fannon at hotmail dot com.
Thanks,
Tim
|
|
New Member
United States
5 Posts |
I can't e mail you. my e mail is jklepacki at sbcglobal dot net.
Thanks
|
|
New Member
United States
8 Posts |
May I please get a copy of this spreadsheet? Also, do you have one for tracking gold? It won't allow me to email you as I am a new member.
My email addy is tinmanut at hotmail dot com
Thanks!
|
|
Moderator
United States
189434 Posts |
 to the Community, TimWUtah! The OP has not been around for a couple of years, so you might be out of luck unless one of the other current members got a copy. |
|
Page 2 of 2
|
Replies: 20 / Views: 16,391 |
Page 2 of 2
|
First Page
Posted 01/28/2013 10:47 pm
