Help - Search - Members - Calendar
Full Version: Data Sheets
Colorado Prospector - Gem and mineral prospecting and mining forums > Prospecting, Mineral Collecting and Treasure Hunting Forums > Equipment - Prospecting and Lapidary
EMac
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:
Click to view attachment

Thanks,
Eric
lostnewb
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:
Click to view attachment

Thanks,
Eric


I would be very interested also.

By the way love the adamantium tab on the spreadsheet. thumbsupsmileyanim.gif
fenixsmom
Nice engineering plug. thumbsupsmileyanim.gif
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.
EMac
QUOTE (fenixsmom @ Oct 24 2014, 01:43 PM) *
Nice engineering plug. thumbsupsmileyanim.gif
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... chin.gif
EMac
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.
lostnewb
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
EMac
Crickets so far....anyone? Or is it really that simple?
Geo
Reviving an old thread research.gif

Any updates on this concept?
rorybagleys
Seems like what you already have is a good start. But I'm sure it could be expanded.
Geo
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 .
Denise
Eric has been very busy, but I sent him a message about this thread so he would see it. happy112.gif
Geo
Thanks Mrs.CP sign0016.gif I am sure he will !
EMac
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
Geo
Happy New Year , Eric and to everyone smiley-clapping.gif

No worries mate , there is always these times when you have to do this and finish that like tomorrow will never come smileywaving.gif

Hopefully you'll find it . Anyway Glad to hear from you !
EMac
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
Geo
Hey Emac, thanks for your reply, can you PM me your E-mail add? couldn't find your message !
CP
You could try sending the file to me in an email Eric, maybe I could get it uploaded into this thread. If not then at least I'd have a copy here for myself. thumbsupsmileyanim.gif
Not sure what would be keeping it from uploading here as an attached file..... confused0082[1].gif
CP
Emac sent the file over, (thanks Eric happy088.gif ) but the board just won't allow that file upload, I've looked and looked for the setting to allow it. wacko.gif bash.gif
There is more than one way to get it done though smiley-cool14.gif I've just uploaded the file directly to the Colorado Prospector server ( info_grin.gif linked below), now everyone can just open the file directly into their computer and go to work with it in Excel. signs021.gif

Emac's Au Sampling Data spreadsheet
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2024 Invision Power Services, Inc.