| Author |
 Topic  |
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
 Posted - 09/02/2009 : 23:34:37
|
|
Hey all I just made this up cause I am bored and want to total the melt value of my American junk silver.It is an excel spread sheet that calculates the value of your coins based on silvers current price. It is all set up, all you have to do is type in how many of each coin you have in the quantities column and type in the current price of silver under the word silver in the upper right hand corner and it does the rest for you. This will tell you the total value of your collection, the melt value of each coin and the total melt value of the total number of each coin you have. It is real simple and easy and free. I do not know how to host this so just E-mail me at Trockstroh@gmail.com and I will send it to you as an attachment. Sorry if this has been posted or if there is some program I do not know about I am just trying to be nice and let you all enjoy this.
|
I am an organized coin collector. |
|
|
Neckro
1000+ Penny Miser Member
Saudi Arabia
2080 Posts |
Posted - 09/02/2009 : 23:42:16
|
| So it's in Excel format? Will it work for Office for PDA? |
Trolling is an art. |
 |
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 09/02/2009 : 23:46:50
|
Also if you guys have any coins I should add or know of any gold coins post the weight of the coin (in grams) and what percent gold/silver it is and I will add it.
I was debating on adding the American Eagle Dollar but I just count it as Silver bullion. |
I am an organized coin collector. |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 09/02/2009 : 23:48:39
|
| Yes, it should work on any thing that will run .xls files |
I am an organized coin collector. |
|
|
|
maoguinn
Penny Pincher Member
USA
118 Posts |
Posted - 09/03/2009 : 21:20:24
|
| coinflation.com does the same thing. |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 09/03/2009 : 23:20:58
|
You are right that is where I got the idea, but my spread sheet calculates not only the value of each coin but of yoru collection. It is an easy way to keep track of the value of your coins. here is a screen shot, I added in a bullion oz an g section so all who emailed me if you want that I can send you the new and improved one.
Here is a screen shot
 |
I am an organized coin collector. |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 09/03/2009 : 23:22:04
|
| It is nothing fancy just a convenience. |
I am an organized coin collector. |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 09/03/2009 : 23:28:28
|
| Also I made up all the numbers in the quantity so don't try to find and rob me, you will be disappointed. |
I am an organized coin collector. |
|
|
|
AGgressive Metal
Administrator
USA
1937 Posts |
Posted - 09/03/2009 : 23:33:49
|
quote:
Originally posted by TaRget
Also I made up all the numbers in the quantity so don't try to find and rob me, you will be disappointed.
You will also be shot and attacked by two vicious dogs who are named after MMA fighters. |
And he that hath lyberte ought to kepe hit wel / For nothyng is better than lyberte / For lyberte shold not be wel sold for alle the gold and syluer of all the world.
-Caxton's edition of Aesop's Fables, 1484 |
|
|
|
Market Harmony
1000+ Penny Miser Member
USA
1274 Posts |
Posted - 09/03/2009 : 23:36:52
|
quote:
Originally posted by AGgressive Metal
quote:
Originally posted by TaRget
Also I made up all the numbers in the quantity so don't try to find and rob me, you will be disappointed.
You will also be shot and attacked by two vicious dogs who are named after MMA fighters.
How did you teach your dogs to shoot a gun? I want one!  |
goto the new and improved realcent: http://realcent.org |
Edited by - Market Harmony on 09/03/2009 23:37:10 |
|
|
|
AGgressive Metal
Administrator
USA
1937 Posts |
Posted - 09/03/2009 : 23:46:20
|
 |
And he that hath lyberte ought to kepe hit wel / For nothyng is better than lyberte / For lyberte shold not be wel sold for alle the gold and syluer of all the world.
-Caxton's edition of Aesop's Fables, 1484 |
|
|
|
jadedragon
Administrator
Canada
3788 Posts |
Posted - 09/04/2009 : 02:33:51
|
Nice little setup. Mine includes all Canadian silver coins as well. I also added Columns to show the coin location. It's fun to see what your collection is worth at different metal values.
I made another tab to track copper and nickel. I'm slowly sifting through my coins by hand to separate out US vs Cdn and pull all Wheats and Kings. The common/newer coins and separated wheats hit the high speed counter, filling bags of 2500 coins each. I label the counted bags and place them in numbered bins. The contents of each bin form a line on my spreadsheet and increase my total count. This process takes a fair amount of time, and I have a long ways to go to get a total count.
|
“The reasonable man adapts himself to the world; the unreasonable one persists in trying to adapt the world to himself. Therefore all progress depends on the unreasonable man.” – George Bernard Shaw.
Why Copper Bullion ~~~ Interview with Silver Bullion Producer Market Harmony
Passive Income blog |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 10/12/2009 : 18:38:21
|
Ok guys so I have added some more on this to help me track my coin collection and I think that the new one is much better than the old so here are some screen shots so you can decide weather or not this is for you and if you got a copy of my first one you will probably like this one more. As always please let me know what you would like to see added in and I will add it. I am working on adding in some random foreign silver coins but it is taking some time to figure out which ones are worth adding.
 |
I am an organized coin collector. |
|
|
|
Kurr
1000+ Penny Miser Member
2906 Posts |
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
|
|
Kurr
1000+ Penny Miser Member
2906 Posts |
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 10/13/2009 : 07:03:35
|
| No problem, I am glad it can help. |
I am an organized coin collector. |
Edited by - TaRget on 10/13/2009 07:05:02 |
|
|
|
slickeast
1000+ Penny Miser Member
USA
2533 Posts |
Posted - 10/13/2009 : 09:04:11
|
| I checked it out. I will be using it later this evening when I have time to inventory everything. |
You don't have to be the BEST you just have to be.......SLICK
|
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 10/13/2009 : 09:53:10
|
| Also remember on page 2 there is a penny section |
I am an organized coin collector. |
|
|
|
slickeast
1000+ Penny Miser Member
USA
2533 Posts |
Posted - 10/16/2009 : 18:25:22
|
I used this last night...it took me 2 hours to inventory my safe, and I didn't know where half of the stuff came from or what I paid for it.
My guesstamation to actual melt value was way off. I had way more in the safe than I thought I did.
It was nice to finally have a reason to inventory and organize the clutter in the safe. |
You don't have to be the BEST you just have to be.......SLICK
|
|
|
|
1945V
Penny Pincher Member
Canada
153 Posts |
Posted - 10/16/2009 : 18:44:53
|
Target,
It is a very nice spreadsheet.
I would make one correction.
Canadian dimes and quarters from 1920-1966 are all 80% silver
Canadian silver dimes and silver quarters for 1968 are all 50% silver
Half of 1967 dimes and quarters were minted in 80% silver and the other half were minted in 50% silver. So averaging out, 1967 dimes and quarters are considered to be 65% silver by most coin dealers when you have a bunch.
|
Edited by - 1945V on 10/16/2009 18:46:35 |
|
|
|
jtm3
Penny Pincher Member
USA
187 Posts |
Posted - 10/16/2009 : 21:17:01
|
Thanks TaRget,
The spreadsheet is very helpful.
Unfortunately, I haven't looked at my chart in a couple of weeks. I am afraid to watch how much the value of my "stash" will drop when I update it.
I sold off about 60 percent of my silver. |
Copper Cent Hoarding Wiki
coppercenthoarding.wikia.com
+637 posts |
Edited by - jtm3 on 10/16/2009 21:17:33 |
|
|
|
TaRget
Penny Sorter Member
USA
52 Posts |
Posted - 11/17/2009 : 09:37:35
|
| Hey I have a new version of the spread sheet if anyone wants it I will crop out my random collections and unsellable sections and post it up. |
I am an organized coin collector. |
|
|
| |
Topic |
|
American silver coin melt value spread sheet
Forum Locked
