Specific Gravity test help - Gold and quartz

Prospecting Australia

Help Support Prospecting Australia:

This site may earn a commission from merchant affiliate links, including eBay, Amazon, and others.
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
 
"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
 
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.
 
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.
 
"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.
 

Latest posts

Top