
Creating zero-depth downhole survey records
You don’t need a survey record at the end of the hole.
If you have no surveys at zero
depth then MM will assume the hole direction is vertically down. Micromine only projects downwards, so it needs a zero depth measurement.
You can copy the first existing
survey and paste it into the survey file as a zero-depth measurement.
(And if you have no survey records for a drillhole that you consider straight then you can specify an azimuth and inclination via the collar. Those angles are optional fields for collar file usage.)
Here's a Python script that creates zero-depth downhole survey records (by copying the first known record for that hole
and giving it zero depth). Use the script as follows:
1. Save the script (e.g. into your current project directory)
2. Use the menu option Scripting | Open Script Editor
to open the script
3. Modify lines 13 to 17 to match your Survey file (That is assumed to be in
current project directory)
4. Make sure that the Survey file is closed.
5. Run the script (a shortcut for that is CTRL+F5)6. To see the changes, view the Script Output window pane and/or “ZeroDepthRepairFile.DAT”
7. Check that the changes to the survey file are correct, to be sure.
Customer support service by UserEcho
Also, here's a script for creating Missing Intervals in a downhole interval file. Use it as follows:
1. Save the script (for example into your current project directory)
2. Use the menu option Scripting | Open Script Editor to open the script
3. Modify lines 19 to 24 to match your Interval file (That is assumed to be in current project directory)
4. Make sure that the Interval file is closed.
5. Run the script (a shortcut for that is CTRL+F5)
6. To see the changes, view the Script Output window pane and/or “MissingIntervalsRepairFile.DAT”
7. Check that the changes to the Interval file are correct, to be sure.
Create missing-intervals.py <= (this is outdated, use the one below)
Here's an updated version: Create missing-intervals.py
Thanks for these scripts. Work a treat. It'd be nice though with the create-missing-intervals script if it could check max depth in the collar file and create an interval to end of hole.
I'll play around and see what happens.
Basic Example
I thought this would be helpful for others learning like me. I took the code posted by the moderators for inserting missing intervals and used it as a guide to write a really simple script that makes basic calculations in a .dat file. I don't know if there are others out there like me but I need to start really basic and work my way up. I was really excited about Python scripting in MicroMine and thought instantly of calculations between columns in .dat files. The below code shows a beginner how to do this.
A few improvements on this code would are:
-Applying a filter, so only perform calculations where a condition is true, or doing different calculations for different conditions, currently working on this for extra credit,
-And having a resulting calculation populate a newly created column, I couldn't figure this out.
I used the table below saved in the root of the project and named it "IntervalFile.dat"
HOLE
FROM
TO
Interval
A
20
30
10.0
A
30
40
10.0
A
40
50
10.0
B
0
5
5.0
B
5
20
15.0
B
20
30
10.0
B
75
100
25.0
C
0
10
10.0
C
10
75
65.0
Hey Geoff,
Your script looks nice, but here are some advice and tips:
Thanks for the tips!