Printable Version of Topic

Posted by: EMac Oct 24 2014, 10: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:

Posted by: lostnewb Oct 24 2014, 11:28 AM

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

Posted by: fenixsmom Oct 24 2014, 12: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.

Posted by: EMac Oct 24 2014, 12:58 PM

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.

Posted by: EMac Oct 24 2014, 01: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.

Posted by: lostnewb Oct 24 2014, 03:11 PM

QUOTE (EMac @ Oct 24 2014, 02:08 PM)

Posted by: EMac Oct 28 2014, 12:56 PM

Crickets so far....anyone? Or is it really that simple?

Posted by: Geo Dec 28 2015, 10:59 AM

Reviving an old thread

Any updates on this concept?

Posted by: rorybagleys Dec 29 2015, 06:58 PM

Seems like what you already have is a good start. But I'm sure it could be expanded.

Posted by: Geo Dec 30 2015, 06:58 AM

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 .

Posted by: Mrs.CP Dec 30 2015, 08:39 AM

Eric has been very busy, but I sent him a message about this thread so he would see it.

Posted by: Geo Dec 31 2015, 12:36 AM

Thanks Mrs.CP I am sure he will !

Posted by: EMac Jan 1 2016, 10:11 AM

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

Posted by: Geo Jan 1 2016, 11:17 AM

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 !

Posted by: EMac Jan 5 2016, 11:48 AM

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

Posted by: Geo Jan 5 2016, 12:32 PM

Hey Emac, thanks for your reply, can you PM me your E-mail add? couldn't find your message !

Posted by: CP Jan 5 2016, 05:26 PM

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.
Not sure what would be keeping it from uploading here as an attached file.....

Posted by: CP Jan 14 2016, 01:12 PM

Emac sent the file over, (thanks Eric ) but the board just won't allow that file upload, I've looked and looked for the setting to allow it.
There is more than one way to get it done though I've just uploaded the file directly to the Colorado Prospector server ( linked below), now everyone can just open the file directly into their computer and go to work with it in Excel.

http://www.coloradoprospector.com/Au%20Sampling%20Data.xlsx