displaying xyz values in data tables

[Edward Hakanson]

Hi,
I am am using Rockworks 16 V.5 and am trying to display XYZ data columns in the data tables of the Borehole Manager but I do not see the menu option View/Show XYZ values option indicated in the Rockworks 16 Help file.

[Guest Molly]

Hi Edward,

That topic should have been removed from the Help messages - it's a remnant from earlier versions.

In earlier versions of RockWorks we calculated the actual XYZ location for each downhole entry in the database and stored those in each table. We did not display these coordinates by default (too much clutter) but the Show XYZ could be used to un-hide the downhole XYZ columns.

In RockWorks16 we now calculate and store the offset of each point relative to the collar location; this makes it infinitely easier for users to reproject their coordinate systems. If you were to open your project database (.MDB file) into Microsoft Access, you would see those offset calculations.

If you want to get a report of the actual XYZ points you can still do this: In the Borehole Manager, choose the File | Export | Multiple Tables | Excel. There, you can choose which holes to export, and which data table(s) you want. Insert a check in the "Include XYZ Computations" (which is off by default). The resulting spreadsheet will contain the actual XYZ points for each downhole measurement for the requested table(s) for the requested holes.

Sorry for the confusion! Hope this helps.

Molly Mayfield

RockWare Inc.

[Edward Hakanson]

Hi Molly,

Thanks for the tip. The export to Excel worked out fine, although the process is a little awkward. What I like about that is that it allows me to calculate true distances multiple points points in more than one wellbore, something that I have still not figured out how to do within the Rockworks environment. However, it would be nice if the option to visualize xyz coordinates were still available in the Borehole manager as it was previously.

Edward

[Guest Molly]

Hi Edward,

There is a program in the Striplogs menu which can calculate the distances between the TD's of all of the boreholes. (and/or relative offsets, midpoints, etc.)

If you wish to calculate distances between generic X1Y1Z1 <-> X2Y2Z2 points, you can use the Utilities | Linears | Lineation Properties | 3D program. This reads a listing of XYZ point pairs (which you could copy/paste from the Excel output) and calculates "length" (or true 3D distance) as well as horizontal and vertical offsets, midpoints, and bearing. It does not matter that these are not lineation endpoints. You need to be sure to define the coordinate system and units in the Utilities datasheet so that the calculations are correct for your project space.

Molly Mayfield

RockWare Inc.

[Edward Hakanson]

Hi Molly,

Thanks, the TD option within the Striplog menú does not calculate what I am looking for. I have used the Utilities / Linears / Lineation Properties / 3D program and although it does calculate the needed values, it is a bit cumbersome. It would be nice if Rockworks could capitalize on its relational borehole database so that it would not be necessary to resort to the Utilities sheet to do what should be considered as common every-day calculations between boreholes.

Thanks again for your help.

[Guest Molly]

Hi Edward,

Thanks for your reply. I guess I misunderstood your original question. Can you tell me what specific point to point distances you want to calculate? I would be happy to put this onto our "wishlist".

Molly

[Edward Hakanson]

Yes Molly. For example, there are lost circulation zones (LCZ) at different elevations in different boreholes and I would like to use Rockworks to easily calculate the horizontal, vertical and true distances between them. For example, in directional well 12 I have LCZ at -270, -370 and -540 meters elevation and in well 1 which is a vertical well I have LCZ at -148 and -350 m elevation. I have also got a hypothetical borehole trajectory for an undrilled well (14) that passes near to both wells 12 and 1. Based on the local fault network, well 14 may not find a LCZ until -620 m. I would like to use Rockworks to easily determine the horizontal, vertical and true 3d distance between the LCZ in wells 1 and 12 with respect to the undrilled well 14.

The best way that I have come up with is to go into the borehole orientation table for wells 1, 12 and 14 and copy the xyz coordinates at the specified elevations into Utilities table and then run the 3D lineation program. This works but it is not intuitive.

Could you within he borehole data base something like a menu option (possibly within the same TD program) that allow me to specify the elevation or depth in specific enabled boreholes so that in effect they are read as if they were TDs and then the program gives results based on these parameters.

I think that this would be the same as temporarily changing the TD of each borehole that is being analyzed to the depth / elevation where lost circulation zones occur or are expected.