Metal Value Calculations Spreadsheet

[lovewiibrew]

A while back a member named Koala posted a spreadsheet that calculated the value of silver us CRH's collected using a live silver price. Well, I expanded upon that to include Gold, Copper, Nickel, Palladium, Platinum, Aluminum, Zinc, Tin and Cadmium. Just input the quantity of the items you have in each category (for example: If I have a 1lb tin bullion bar, I will put "1" in quantity under that category) It will give you your total metal value for each metal, along with the value of ALL your metals at the very top. This is in excel format, HOWEVER, I edited it in OpenOffice so I cannot guarantee that the "Live Prices" will work for users in excel. It should for people who use OpenOffice. If the "Live Prices" do not work for you in excel, you should be able to import tables from sites (like Kitco) and just point the metal price to the cell that contains the relevant information. Cadmium is the only one I could not find a live price for. Alternatively, you can always manually input the metal price if you can't get it to live update. I love it though, because everyday I will open the spreadsheet and it will automatically fetch the current prices of all my metals (except for Cadmium) and give me a real time value of all the metals I own. Enjoy!

https://docs.google.com/open?id=0B-J42y5FQrESZmYwZWRmNzktNjY4MS00MjYxLWIyOTEtNzQwOTJmNzM4MWE4

Again, credit goes to Koala for doing the Silver category. I simply expanded upon it.

 

Amazon Forum Fav 👍

Minelab PRO-FIND 35 Waterproof Pinpointer Metal Detector for Experts with Tone ID & Adjustable Sensitivity - Grab it through Amazon!

[White Silver]

I like coinflation, its always updated with the live prices and gives you the melt for all the metals. And you can enter the quantity of what you have.

 

[ImpurestStewart]

Thanks for all the hard work!

 

[Bigheed]

thats very cool wiibrew.

I made a spreadsheet just for my silver and copper that I input my daily searched amount & finds which link up to the summary page which calculates the totals. Basically its just a tab for each month with the dates on the rows and all the finds on the columns. however I have to manually update the silver & copper price on my summary page...I'm not that good at it as you are :-)

Very good work !

Bigheed

 

[lovewiibrew]

thats very cool wiibrew.

I made a spreadsheet just for my silver and copper that I input my daily searched amount & finds which link up to the summary page which calculates the totals. Basically its just a tab for each month with the dates on the rows and all the finds on the columns. however I have to manually update the silver & copper price on my summary page...I'm not that good at it as you are :-)

Very good work !

Bigheed

Would you mind sharing? I was going to make one for my halves boxes just like youre talking about.