Mike (Virginia Beach)
New member
And I don't mean PIRATED software...I mean software for PIRATES! 
Let me explain.
I was talking to my friend (and boss) Dave at work and telling him about gold finds, Midwest Refinery, melt value...stuff like that. I was saying how I figured up what I have so far this season to be worth a little over $1000, and how I arrived at that. He says "You could do a spreadsheet on that and make it figure it up for you." Well, I know there are some web calculators that will do that. But they do it for ONE thing, or one set amount/weight/karat value, etc. But what if you could tally it ALL up?
Well, Dave is better with Microsoft Excel than I am. And he was intrigued by the challenge of making this spreadsheet, so he started playing with it. And with a little help from me, telling him what we might want, it turned into a pretty cool spreadsheet. So I'm going to post a link to it and if you have Microsoft Excel, you should be able to click the link and open it up. You can then SAVE it to you hard drive (your Desktop would be a good place) and fill it out for your finds. I plugged a few things in there to show you how it works. Here are some simple tips, followed by the link. Be sure and pay attention to the different fields...it's VERY easy to use but you CAN screw it up. I would recommend saving a copy and then saving a SECOND copy, in case you play with it and it gets dorked up.
Open the spreadshhet and:
1) Input the spot prices of the day for gold, silver and platinum where shown. You can get those here: http://www.monex.com/ (check the scolling banner when it comes up)
2) To the right of that is the "Refiner's fee", which with Midwest as an example would be 6%. Just put in a 6 there. That will automatically figure their "cut" and deduct it. If you don't want to know that, put in a "0" and you'll see full value.
3) The "Description" field is for your use as you see fit. Manually enter whatever you like, as I did in the example.
4) For the "Metal Type" field, move to that field and use the dropdown menu. Choose gold, silver, or platinum.
5) In the "Weight" field, put in the weight in ounces or in grams...just the number. You can do 12.7, for example.
6) In the "Unit" field, move to that field and use the dropdown. Pick troy oz or gram.
7) Now click into the "Purity/Karats" field and use the dropdown to select either sterling, plat 950, plat 900, plat 850, or the appropriate value in gold karats.
You will see the final figures for whatever you put in. Now just add in all of your other finds on subsequent lines and it will give a running tally as you go. If there is any error shown than you haven't entered SOMETHING correctly or in the right place...try again. This thing works very well. If you have a suggestion for something to be changed, make it...we can probably do it. Please provide feedback...if you like it, say so. If you don't, save it.
Yeah, there are web links that can do this to an extent, but not for ALL your stuff...just for one thing at a time. If you don't have Microsoft Excel, sorry...you can't play.
So here it is: http://members.cox.net/detect/BootySpreadsheet.xls
Let me explain.
I was talking to my friend (and boss) Dave at work and telling him about gold finds, Midwest Refinery, melt value...stuff like that. I was saying how I figured up what I have so far this season to be worth a little over $1000, and how I arrived at that. He says "You could do a spreadsheet on that and make it figure it up for you." Well, I know there are some web calculators that will do that. But they do it for ONE thing, or one set amount/weight/karat value, etc. But what if you could tally it ALL up?
Well, Dave is better with Microsoft Excel than I am. And he was intrigued by the challenge of making this spreadsheet, so he started playing with it. And with a little help from me, telling him what we might want, it turned into a pretty cool spreadsheet. So I'm going to post a link to it and if you have Microsoft Excel, you should be able to click the link and open it up. You can then SAVE it to you hard drive (your Desktop would be a good place) and fill it out for your finds. I plugged a few things in there to show you how it works. Here are some simple tips, followed by the link. Be sure and pay attention to the different fields...it's VERY easy to use but you CAN screw it up. I would recommend saving a copy and then saving a SECOND copy, in case you play with it and it gets dorked up.
Open the spreadshhet and:
1) Input the spot prices of the day for gold, silver and platinum where shown. You can get those here: http://www.monex.com/ (check the scolling banner when it comes up)
2) To the right of that is the "Refiner's fee", which with Midwest as an example would be 6%. Just put in a 6 there. That will automatically figure their "cut" and deduct it. If you don't want to know that, put in a "0" and you'll see full value.
3) The "Description" field is for your use as you see fit. Manually enter whatever you like, as I did in the example.
4) For the "Metal Type" field, move to that field and use the dropdown menu. Choose gold, silver, or platinum.
5) In the "Weight" field, put in the weight in ounces or in grams...just the number. You can do 12.7, for example.
6) In the "Unit" field, move to that field and use the dropdown. Pick troy oz or gram.
7) Now click into the "Purity/Karats" field and use the dropdown to select either sterling, plat 950, plat 900, plat 850, or the appropriate value in gold karats.
You will see the final figures for whatever you put in. Now just add in all of your other finds on subsequent lines and it will give a running tally as you go. If there is any error shown than you haven't entered SOMETHING correctly or in the right place...try again. This thing works very well. If you have a suggestion for something to be changed, make it...we can probably do it. Please provide feedback...if you like it, say so. If you don't, save it.
Yeah, there are web links that can do this to an extent, but not for ALL your stuff...just for one thing at a time. If you don't have Microsoft Excel, sorry...you can't play. So here it is: http://members.cox.net/detect/BootySpreadsheet.xls
