Specific Gravity test help - Gold and quartz

[davsgold]

Doesn't appear to be possible, Phil - I just tried.

if anyone wants the spread sheet xls that I use and not just a picture, I can send it in an email, you will need to send me a message with your email address, as grubstake says it not something that can be attached to a post on here

this is a screen shot

 

[Moneybox]

This ".xls" will allow calculation with different sg for host materials when you download it. When you open the spreadsheet just use the save feature on your down-loaded file.
Link...> Spreadsheet 4 Calc of Gold.

Yes that's the one. I wasn't keen to supply a link to my onedrive files.

 

[Hippyty79]

There was a Excel gold calculator floating around years ago that I think was put together by a fella named Bill & wife Sue? Bill was on the admin side of a gold forum? The calculator was very handy but somehow I inadvertantly deleted it. All I have is a photo of what it looked like.
We have never crushed any of our specimens, they look far better than a blob of gold. Can anyone help?

View attachment 12580

This is Bill and Udos site your looking for,
They run prospecting courses in Cue, Bill and Sue also work and help out with apla.
https://www.gold-prospecting-wa.com/gold-in-quartz.html

 

[davsgold]

"Nightjar said:
There was a Excel gold calculator floating around years ago that I think was put together by a fella named Bill & wife Sue? Bill was on the admin side of a gold forum? The calculator was very handy but somehow I inadvertantly deleted it. All I have is a photo of what it looked like.
We have never crushed any of our specimens, they look far better than a blob of gold. Can anyone help?

View attachment 12580"

hey Nightjar, if your still looking for this spread sheet gold calculator, it's the one I use, I may have even given it to you years ago, if you want it I can send it to you in an email, just message me if you want it

cheers dave

 

[Nightjar]

geof_junk, Gentleman and a scholar, your intructions work perfectly, program up and running again.

 

[Hawkear]

This is a copy of an Excel worksheet I set up to do the gold content calculations for my specimens. Regrettably I seem unable to upload the Excel worksheet directly to this site so that others can modify the inputs and use it. If anyone can help me do that, I would be happy to share.. I could also share the worksheet by email to someone who may have the skill to do that for me.
Note that the following is only a copy of the worksheet page and does not show it the way it appears in excel format and not modifiable. Just shown here to give anyone interested an idea of how it works.

Values

SG of Quartz 2.65 Sg of Gold 19.32

Weight of Specimen* 25.925 Volume of Specimen 9.70

Vol of Gold Vol of quartz Wt of quartz Wt of Gold

Initial Estimate 0 9.70 25.705 0.22

!st refinement 0.011387164 9.688612836 25.67482402 0.250175983

2nd refinement 0.012949067 9.687050933 25.67068497 0.254315029

3rd refinement 0.013163304 9.686836696 25.67011725 0.254882755

4th refinement 0.013192689 9.686807311 25.67003937 0.254960626

5th refinement 0.01319672 9.68680328 25.67002869 0.254971307

Final calculated gold content (rounded off) 0.25gr

* All weights are in grams
** In ccs as determined by direct scale pressure measurement. This method does not rely on the fiddly job of recording the specimen's wet weight.

 

[grubstake]

This is a copy of an Excel worksheet I set up to do the gold content calculations for my specimens. Regrettably I seem unable to upload the Excel worksheet directly to this site so that others can modify the inputs and use it. If anyone can help me do that, I would be happy to share..

Sorry, but it's impossible. A screenshot is all that can be done.

 

[Hippyty79]

Test

 

[user 4485]

Test

That works for me.
Can post excel as a zip then just download & unzip it

 

[Nightjar]

"Nightjar said:
There was a Excel gold calculator floating around years ago that I think was put together by a fella named Bill & wife Sue? Bill was on the admin side of a gold forum? The calculator was very handy but somehow I inadvertantly deleted it. All I have is a photo of what it looked like.
We have never crushed any of our specimens, they look far better than a blob of gold. Can anyone help?

View attachment 12580"

hey Nightjar, if your still looking for this spread sheet gold calculator, it's the one I use, I may have even given it to you years ago, if you want it I can send it to you in an email, just message me if you want it

cheers dave

Thanks Dave, Originally got it direct from Bill after our Mt Elsie Meet. But would appreciate your email. Will message you details.

 

[davsgold]

Thanks Dave, Originally got it direct from Bill after our Mt Elsie Meet. But would appreciate your email. Will message you details.

replied to you message and sent it in an email

 

[casper]

Test

Thank You cobber