alanlambden
Board Regular
- Joined
- Nov 20, 2014
- Messages
- 70
Hi Guys,
Im working on a mining project where there is a DB full of drillholes. Each sample in the drillhole is either .5m or 1m in length. Each samp,e also has a code assigned to it depending on what rock type it is. Anything labelled with "10" means bedrock and anything between 1-6 is ore. I need to figure out what the average ore grade is as a function of depth. I need to populate a table showing the average ore grade, starting at the bedrock contact and working upwards. The average grade should show the average at 1m above bedrock, 2m above bedrock and so on. Below is an example or the data and the desired result:
<colgroup><col span="9"><col></colgroup><tbody>
</tbody>
If anyone has any commands that would be useful for this task it would be greatly appreciated
Thanks
Im working on a mining project where there is a DB full of drillholes. Each sample in the drillhole is either .5m or 1m in length. Each samp,e also has a code assigned to it depending on what rock type it is. Anything labelled with "10" means bedrock and anything between 1-6 is ore. I need to figure out what the average ore grade is as a function of depth. I need to populate a table showing the average ore grade, starting at the bedrock contact and working upwards. The average grade should show the average at 1m above bedrock, 2m above bedrock and so on. Below is an example or the data and the desired result:
Hole_ID | X | Y | Z | From | To | Length | Ore | Code | Average ore grade by depth |
104442 | 606451.2 | 201099.7 | 659.5 | 0 | 1 | 1 | 0.97 | 2 | 1.24 |
104442 | 606451.2 | 201099.7 | 658.5 | 1 | 2 | 1 | 1.27 | 2 | 1.294 |
104442 | 606451.2 | 201099.7 | 657.5 | 2 | 3 | 1 | 1.36 | 3 | 1.3 |
104442 | 606451.2 | 201099.7 | 656.5 | 3 | 4 | 1 | 1.33 | 4 | 1.28 |
104442 | 606451.2 | 201099.7 | 655.5 | 4 | 5 | 1 | 1.28 | 4 | 1.255 |
104442 | 606451.2 | 201099.7 | 654.5 | 5 | 5.5 | 0.5 | 1.23 | 4 | 1.23 |
104442 | 606451.2 | 201099.7 | 654 | 5.5 | 6.5 | 1 | 0.31 | 10 | |
104442 | 606451.2 | 201099.7 | 653 | 6.5 | 7.5 | 1 | 0.22 | 10 | |
104445 | 606551.3 | 201099.3 | 656 | 0 | 1 | 1 | 1.38 | 2 | 1.2 |
104445 | 606551.3 | 201099.3 | 655 | 1 | 2 | 1 | 1.4 | 2 | 1.11 |
104445 | 606551.3 | 201099.3 | 654 | 2 | 2.5 | 0.5 | 0.82 | 4 | 0.82 |
104445 | 606551.3 | 201099.3 | 653.5 | 2.5 | 3.5 | 1 | 0.36 | 10 | |
104445 | 606551.3 | 201099.3 | 652.5 | 3.5 | 4.5 | 1 | 0.31 | 10 |
<colgroup><col span="9"><col></colgroup><tbody>
</tbody>
If anyone has any commands that would be useful for this task it would be greatly appreciated
Thanks