OreCart
Sr. Member
It was raining today, which just meant I got really wet when I retraced my steps to go find my lost camera tripod. I found it, but I had to backtrack 90% of the way out around before I found it. So as my clothes dried in the clothes dryer, I set about organizing my sampling areas.
I used Excel to create a few things. The first was a list of questions.
Does it have Gold?
Does it have Silver?
Does it have Gemstones?
Does it have other Mineralization?
Is it a Placer location?
Is in a Lode location?
Does the location have good access?
Can it be surfaced mined?
Can it have an addit?
Can it take a mine shaft?
What type of analysis was done?
Beside these questions are three columns; a rating, weight and score. That is because the first thing I do is rate how each sampling location turned out. All answers are given in numbers, specifically percentages. For instance, “Does it have gold”, is a yes or no answer, so yes would be 100% and no would be 0%. But others are different, for instance in terms of access, I have places that are 2 mile hikes to get to, while others I can drive right to. So the latter one would be 95%, and the hike would be 5%. A place that was a ½ mile hike? That would be 50%.
But each question might have more or less significance. Like having gold is pretty important, so that gets a heavy weight, say 14% of the total number of percentage points, while having the ability to drive an addit might be really low. This is where a person can really change how they want to prioritize their sampling locations.
Then a score is derived for each question by taking the rating and multiplying it times the weighted percentage. So lets say having gold is 14% of the listed questions, and a sample spot has gold, then it will get a rating of 14% for that question. Then all the question scores are added up, and that one sample spot get assigned a total score. These get linked to a chart where the name of the sample spot is, along with that locations score…listed from highest number to smallest. In other words, what the best sample locations are.
What does that do? It tells me which are my highest priority areas based on my questions. So lets say sample one location has gold, and is rated according to my list of questions, but access is a serious issue, and while it had gold, it was only visually verified and not assayed, it would rate under that of a sample spot that had gold, a road going to it, and was assayed. Or it would rate under that of a sample spot with gold, but poor access, and only visual verification made, but that other location contained silver and garnet. But what happens if a sample location is really great but lacks access? Well computer generated scoring of each sample will tell you, “build a road to that spot!”
It all sounds pretty complicated, but it is not. At any time the weights of the questions can be adjusted to match the prospector’s priorities, so nothing is set in concrete. And no sample location is overlooked, it just has a lower overall score. With only a few sample right now, this does not have a huge impact, but as my sample location grows, it will really let me hone in on where to concentrate my efforts.
Here is a screen shot of my questions, to just one sample spot.

I used Excel to create a few things. The first was a list of questions.
Does it have Gold?
Does it have Silver?
Does it have Gemstones?
Does it have other Mineralization?
Is it a Placer location?
Is in a Lode location?
Does the location have good access?
Can it be surfaced mined?
Can it have an addit?
Can it take a mine shaft?
What type of analysis was done?
Beside these questions are three columns; a rating, weight and score. That is because the first thing I do is rate how each sampling location turned out. All answers are given in numbers, specifically percentages. For instance, “Does it have gold”, is a yes or no answer, so yes would be 100% and no would be 0%. But others are different, for instance in terms of access, I have places that are 2 mile hikes to get to, while others I can drive right to. So the latter one would be 95%, and the hike would be 5%. A place that was a ½ mile hike? That would be 50%.
But each question might have more or less significance. Like having gold is pretty important, so that gets a heavy weight, say 14% of the total number of percentage points, while having the ability to drive an addit might be really low. This is where a person can really change how they want to prioritize their sampling locations.
Then a score is derived for each question by taking the rating and multiplying it times the weighted percentage. So lets say having gold is 14% of the listed questions, and a sample spot has gold, then it will get a rating of 14% for that question. Then all the question scores are added up, and that one sample spot get assigned a total score. These get linked to a chart where the name of the sample spot is, along with that locations score…listed from highest number to smallest. In other words, what the best sample locations are.
What does that do? It tells me which are my highest priority areas based on my questions. So lets say sample one location has gold, and is rated according to my list of questions, but access is a serious issue, and while it had gold, it was only visually verified and not assayed, it would rate under that of a sample spot that had gold, a road going to it, and was assayed. Or it would rate under that of a sample spot with gold, but poor access, and only visual verification made, but that other location contained silver and garnet. But what happens if a sample location is really great but lacks access? Well computer generated scoring of each sample will tell you, “build a road to that spot!”
It all sounds pretty complicated, but it is not. At any time the weights of the questions can be adjusted to match the prospector’s priorities, so nothing is set in concrete. And no sample location is overlooked, it just has a lower overall score. With only a few sample right now, this does not have a huge impact, but as my sample location grows, it will really let me hone in on where to concentrate my efforts.
Here is a screen shot of my questions, to just one sample spot.

Amazon Forum Fav 👍
Upvote
0