Strater: Plotting Logs for Multiple Boreholes in one Borehole View 

Introduction

Strater is designed to display logs for one borehole at a time in the Borehole View window. However, if all your borehole data has the same or similar depth and scaling range, there is a way to plot logs for multiple boreholes at once in the Borehole View window. To display data for more than one borehole, import the data for the different boreholes into separate data tables and simply use the same Hole ID for all the borehole data. For example, follow the procedure outlined below.

Edit the Data File

1. Open your data file and insert a new column in the data file called "Hole ID". Enter the same Hole ID for all data. Keep the original borehole names saved in another column of data. In this example, there are data for three borehole names: M-382, DH 15-16, and M-499. A column containing the common Hole ID of "Missouri" has been added to the data file.
    
   
   

   Add an additional Hole ID column in the data file with a generic Hole ID.

2. Save and close the data file.

Import the Data and Create the Logs

1. Open Strater.
2. In this example, we will create a series of zone bar logs showing lithology. Click on the zone bar log icon and click in the log pane where you want the log to be placed.
3. Select the data file saved earlier and click Open.
4. In the Specify Worksheet Column Definitions dialog box, check Specify Column Header Row if you have a header row.
5. Check the checkboxes next to Specify Starting Row and Specify Ending Row and type in the starting and ending row numbers for the data for one of the boreholes. You can determine the starting and ending rows for the borehole data in the preview window.
    
   
   

   Specify the Starting and Ending Rows for one borehole.

6. Click Next.
7. Make sure the data field with the common Hole ID (i.e. "Missouri") is specified as the Hole ID field.
    
   
   

   Set the Hole ID field to the generic Hole ID column in the data file.

8. Click Load.
9. The zone bar is created. Activate the Database View and go to the data table. Confirm that the data is imported correctly.
10. To keep the data organized, it is helpful to rename the data tables to the original borehole name. Go to Table | Rename Table and rename the table to the original borehole name.
11. Repeat steps 2-10 for all boreholes in the data file.
     
    
    

    Create a data table for each borehole name,
    and rename the data tables to reflect the borehole name.

12. Activate the Borehole View and view the created logs.
13. Each of the zone bar logs are filled with colors and patterns that are defined in scheme files. To make all the fills consistent, open the Scheme Editor by clicking on the Scheme Editor icon .
14. In the Scheme Editor, open the keyword scheme by clicking on the little "+" to the left of the scheme name. In each scheme are multiple scheme items. When you select a scheme item, the properties for that item are displayed on the right side of the Scheme Editor. Select each scheme item and choose the properties you want to display for that item.
     
    
    

    Edit the scheme items to display the properties you want.

15. When all the scheme items are set, click OK.
16. The keyword scheme was initially created using all the keywords from the first data table imported. Keywords for the additional data tables were not included in this scheme. Activate the Database View and click one of the data tables that was not imported first.
17. Click on the Scheme Editor icon to open the Scheme Editor. Check the keyword field in the data table and the keywords listed in the scheme. If there are any keyword items missing from the keyword scheme, you can add them by clicking on a scheme item and then clicking on the Insert New Item button . Repeat clicking on the Insert New Item button as many times as needed to add all the missing keywords.
18. Select one of the New Items and type in the new keyword for that item in the Keyword Properties.
     
    
    

    Insert new scheme items and specify the keyword for the new item.

19. Repeat for all new keyword scheme items. Click OK. Make sure to check all the other data tables that were not imported first for missing keyword scheme items.
20. When all scheme items have been added, activate the Borehole View. Check to make sure there are no blank or unexpected properties for any of the logs. Reposition and resize the logs they way you want them to look. You can change the properties of each log by selecting the log and changing its properties in the Property Inspector.
21. To change the generic settings of the borehole log (such as scaling), go to View | Borehole View Properties. Set the Log Display Mode to Full View to see the entire log on the screen or to Page View to see the log as it is broken into pages. Change the Depth Settings from Automatic to User Defined to change the scaling of the log.
22. Go to File | Save and save your Strater file.
     
    
    

    Import logs displaying data for different boreholes by importing data for different boreholes into different data tables, using the same Hole ID.

Complete the Log Design

1. Add a depth log by clicking on the depth log icon on the toolbar and clicking in the log pane where you want it to be placed. To change the properties of the depth log, such as display direction or number of minor divisions, select the depth log and change the properties in the Property Inspector.
2. Add a set of grid lines to the log by creating a line/symbol log. Click on the line/symbol log icon and click in the log plane where you want it to be placed.
3. Select the line/symbol log and, in the Property Inspector, set the Display Properties | Line Style | Style to Invisible.
4. Set Grid Line Properties | Depth Grid Lines | Depth Grid Line Position to Bottom and Show Major Depth Grid Lines to True.
5. Set the line style for the major depth grid lines to what you want.
6. Change the Grid Interval for the grid lines by changing Grid Line Properties | Depth Grid Lines | Scaling from Auto to User Defined and entering the new Grid Interval in the Show Major Depth Grid Lines section.
7. Resize the line/symbol log so that it fits across the entire log pane.
8. With the line/symbol log selected, go to Arrange | Order Objects | Move to Back to move it behind all the other logs.
9. It is helpful to rename the logs in the Object Manager to easily understandable names. To rename a log, right click over the log and go to Rename Object. Then simply type in the name you want.
    
   
   

   Rename logs to better identify them.

10. Use any of the drawing tools under Tools | Headers and Footers to create informative headers and footers.
     
    
    

    Complete the log design by adding additional logs and creating headers and footers.

If you have any questions about Strater or this article, please contact us at stratersupport@goldensoftware.com.