Data Sheets |
Colorado Prospector - Gem and mineral prospecting and mining forums > Prospecting, Mineral Collecting and Treasure Hunting Forums > Equipment - Prospecting and Lapidary  |
Data Sheets |
 Oct 24 2014, 10:41 AM
Post
#1
|
||
 Rock Bar!  Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949  |
I searched for something along these lines, but didn't find anything with my queries. Does anyone have a spreadsheet template already for evaluation/analysis of mineral deposits that you'd be willing to share? I'm primarily thinking gold, but would be interested in other templates as I suspect the appropriate data elements may be different. Ideally in similar formats to promote ease of use. Something in Excel is what I'm thinking, perhaps with different tabs for different values/areas.
It's not hard to build one of these, so really I'm interested in which key process inputs (KPIs) folks here track. The outputs seem a little more obvious, but I'm curious if folks stratify their data that way too (such as size, amount, fineness, etc.)? I slapped together something quick to show what I'm thinking, but I'm not able to upload an .xlsx file. Here's a screenshot instead:
Thanks, Eric -------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
 |
 
|
|
|
Oct 24 2014, 11:28 AM
Post
#2
|
||
|
Shovel Buster! Group: Members Posts: 91 Joined: 30-July 13 From: Elbert, CO Member No.: 91,383 |
QUOTE (EMac @ Oct 24 2014, 11:41 AM)  I searched for something along these lines, but didn't find anything with my queries. Does anyone have a spreadsheet template already for evaluation/analysis of mineral deposits that you'd be willing to share? I'm primarily thinking gold, but would be interested in other templates as I suspect the appropriate data elements may be different. Ideally in similar formats to promote ease of use. Something in Excel is what I'm thinking, perhaps with different tabs for different values/areas. It's not hard to build one of these, so really I'm interested in which key process inputs (KPIs) folks here track. The outputs seem a little more obvious, but I'm curious if folks stratify their data that way too (such as size, amount, fineness, etc.)? I slapped together something quick to show what I'm thinking, but I'm not able to upload an .xlsx file. Here's a screenshot instead:
Thanks, Eric I would be very interested also. By the way love the adamantium tab on the spreadsheet. 
-------------------- --Chris
01101100 01100101 01110100 01110011 00100000 01100111 01101111 00100000 01101101 01101001 01101110 01101001 01101110 01100111 00100001 00100001 |
|
|
|
|
|
|
Oct 24 2014, 12:43 PM
Post
#3
|
|
 Master Mucker! Group: Members Posts: 1,282 Joined: 13-January 14 From: Lakewood, Colorado Member No.: 116,305 |
Nice engineering plug.
Per wikipedia: Since the late 1950s, aerospace engineers have used the term "unobtainium" when referring to unusual or costly materials, or when theoretically considering a material perfect for their needs in all respects, except that it does not exist. |
|
|
|
|
Oct 24 2014, 12:58 PM
Post
#4
|
|
|
Rock Bar! Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949 |
QUOTE (fenixsmom @ Oct 24 2014, 01:43 PM) Nice engineering plug. Per wikipedia: Since the late 1950s, aerospace engineers have used the term "unobtainium" when referring to unusual or costly materials, or when theoretically considering a material perfect for their needs in all respects, except that it does not exist. And here I was thinking I was doing movie references with those... 
-------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
|
|
|
Oct 24 2014, 01:08 PM
Post
#5
|
|
|
Rock Bar! Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949 |
If there isn't an Excel template already in existence, I can put it together very fast. Feedback on data elements is still very helpful!
I'm very good in Excel, and only dangerous in Access; I prefer Excel, but see how this could more easily be structured in a database. I can decipher SQL query statements, but it would a lot of learning that I'm not interested in to build a SQL database from scratch. -------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
|
|
|
Oct 24 2014, 03:11 PM
Post
#6
|
|
|
Shovel Buster! Group: Members Posts: 91 Joined: 30-July 13 From: Elbert, CO Member No.: 91,383 |
QUOTE (EMac @ Oct 24 2014, 02:08 PM) If there isn't an Excel template already in existence, I can put it together very fast. Feedback on data elements is still very helpful! I'm very good in Excel, and only dangerous in Access; I prefer Excel, but see how this could more easily be structured in a database. I can decipher SQL query statements, but it would a lot of learning that I'm not interested in to build a SQL database from scratch. If you decided going SQL I would be more than happy to help as I am pretty good there. Chris -------------------- --Chris
01101100 01100101 01110100 01110011 00100000 01100111 01101111 00100000 01101101 01101001 01101110 01101001 01101110 01100111 00100001 00100001 |
|
|
|
|
Oct 28 2014, 12:56 PM
Post
#7
|
|
|
Rock Bar! Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949 |
Crickets so far....anyone? Or is it really that simple?
-------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
|
|
|
Dec 28 2015, 10:59 AM
Post
#8
|
|
|
Diggin' In! Group: Members Posts: 8 Joined: 9-November 12 Member No.: 48,744 |
Reviving an old thread
 Any updates on this concept? |
|
|
|
|
Dec 29 2015, 06:58 PM
Post
#9
|
|
 Diggin' In! Group: Members Posts: 5 Joined: 8-December 15 Member No.: 122,345 |
Seems like what you already have is a good start. But I'm sure it could be expanded.
|
|
|
|
|
Dec 30 2015, 06:58 AM
Post
#10
|
|
|
Diggin' In! Group: Members Posts: 8 Joined: 9-November 12 Member No.: 48,744 |
So, anyone have the .xlsx file ? or is it only kept with the "OP" to send as an email attachment? He isn't active on the forum for a while .
|
|
|
|
|
Dec 30 2015, 08:39 AM
Post
#11
|
|
 Master Mucker! Group: Admin Posts: 7,206 Joined: 7-October 03 From: Colorado Member No.: 4 |
Eric has been very busy, but I sent him a message about this thread so he would see it.
-------------------- Education is the key to the future,
and participation opens the door to opportunity. Discover your prospecting independence & success! ColoradoProspector.com Owner/Webmaster Core team member ♥  |
|
|
|
|
Dec 31 2015, 12:36 AM
Post
#12
|
|
|
Diggin' In! Group: Members Posts: 8 Joined: 9-November 12 Member No.: 48,744 |
Thanks Mrs.CP
 I am sure he will !
|
|
|
|
|
Jan 1 2016, 10:11 AM
Post
#13
|
|
|
Rock Bar! Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949 |
I'm sorry, I have been pretty busy. Happy New Year everyone!
Unfortunately I think that file is on my work computer, so I'll have to pull it out to send it. I'm not sure I want to worry about work for another day or 2 though, but I'll send the file (assuming it's still around) when I fire up the laptop. Cheers, E -------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
|
|
|
Jan 1 2016, 11:17 AM
Post
#14
|
|
|
Diggin' In! Group: Members Posts: 8 Joined: 9-November 12 Member No.: 48,744 |
Happy New Year , Eric and to everyone
 No worries mate , there is always these times when you have to do this and finish that like tomorrow will never come  Hopefully you'll find it . Anyway Glad to hear from you ! |
|
|
|
|
Jan 5 2016, 11:48 AM
Post
#15
|
|
|
Rock Bar! Group: Members Posts: 875 Joined: 25-July 14 From: Westminster, CO Member No.: 117,949 |
Happy New Year everyone!
Geo - I just emailed you the file; feel free to share if you'd like. If you don't get it, please let me know; likely a typo. I also tried posting a comma delimited file, but no dice. If anyone else wants it, lemme know. Cheers! E -------------------- Lifetime Member
opera non verba "All courses of action are risky, so prudence is not in avoiding danger (it's impossible), but calculating risk and acting decisively. Make mistakes of ambition and not mistakes of sloth. Develop the strength to do bold things, not the strength to suffer." ~Niccolò Machiavelli Ref Code: EM448 |
|
|
|
|
| Lo-Fi Version | Time is now: 5th May 2025 - 08:22 AM |
