just wanted to ask is it possible to export a drill plan information to coordinates where the rock coordinate & the design coordinates & the hole length be exported to excel
In the Project Explorer find your Drill Plan and from there you can Right Click and select the option Generate Design Points - this will create points at the Top and Bottom of the Drill Holes which you can then output to Excel using a CSV file export to P,N,E,Z,D or P,E,N,Z,D formats. The CSV can then be imported to Excel. You can also do the same for As Drilled holes.
Once you have Quality Records for the Drill Holes you can run the Drill Plan Quality Report on the completed holes and all of the Design Info for the Drill holes is in the report - you just cannot run the report without the Quality data being available.
If you need to determine the Lengths of the Drill Holes - I was a little surprised this am to find that you cannot run the Drill Report with Design only data (and have suggested the product manager get that changed so you can run the Report on Design Holes only without the Quality report data), but for now if you need the Hole Lengths - I output the Drill Holes to a DXF File and Reimport it - then you will get 3D Lines that follow the Drill Holes and you can then run an Area Length Count report on the lines to get all of the Drill Hole lengths (Slope and Horizontal distances).
The Commands Generate Design Points and Generate As Drilled Points are in the Command list (F12 to get to the command pane) and you can add them to a custom menu ribbon if you want them in the Menus. The default is to access these through the process listed above (I have these commands in my Menus (I use custom menus all the time).
Hope this helps - Happy Drilling
thanks a lot Alan its exactly what I wanted to achieve, wanted to export the information to an excel spread sheet the clients.
Retrieving data ...