Borehole log is a record made usually by a geologist of the rocks and soils penetrated during borehole drilling.Borehole log records include a detailed description of. Borehole discontinuity log For use when recording detail on each discontinuity within a core and when the requirement is to record all available information on each fracture in turn. This amount of information does not readily fit onto a core description sheet, or onto a normal field log and so this information is tabulated and entered into the. Importing Excel Data into Multiple Borehole Tables. Borehole Manager File Import Excel Multiple Tables. Use this tool to bring data into the Borehole Manager from multiple worksheets in an external Microsoft Excel file, for one or more boreholes and a variety of data types. Each worksheet in the XLS file must contain a specific type of data (locations or stratigraphy, for example).
Excel Import File Format - Single and Multiple Boreholes
The required format for data being imported into LogPlot from Excel is identical to the format of LogPlot data exported to Excel. Here is a summary of the different Excel Worksheets, which correspond to the different LogPlot datasheets; click on a link below to jump to its description.
The format for importing data from multiple worksheets for a single borehole is identical as that for multiple holes, with the only exception for the latter being the requirement of a borehole ID column at the beginning of the column listing.
Contents
BH Info
Bitmaps
Construction
Edit Notes
Edit Text
Fillbar
Horizontal Lines
Interbeds
Interval Data
Lithology
Orientation (downhole survey)
Pattern Percent Data
Point Data (Curves)
Point Text
Scale Tables
Symbols
Tadpole (dipmeter) Data
Vertical Text
BH Info
Required: This worksheet must be present and must contain data for the import to be successful.
Worksheet name in Excel: SETUPGRD
Example:
Single borehole:
Multiple boreholes:
Unknown fields can be left blank. For example, you can omit the well location information from columns 3 and 4, but be sure that the column count is correct if you enter the KB elevation (which must be in column #5).
See also: BH Info datasheet for the LogPlot data format and what the fields represent.
Back to list.
Bitmaps
Optional. This worksheet is used to list raster image file names and their depth intervals for import into a LogPlot Bitmap datasheet. These images can be displayed in the log body.
Worksheet name in Excel: BMP_name
Example:
Single borehole
Multiple boreholes
Borehole Data
See also: Bitmap datasheet for how this data is used in LogPlot. See the notes there regarding listing the full path for the raster image name.
Back to list.
Construction Data
Optional. This worksheet is used to list depth intervals, material types, diameters, and (optional) offsets, to be imported into a LogPlot well Construction datasheet. This data can be displayed in the log body in a well Construction column.
Worksheet name in Excel: WCN_name
Example:
Single Borehole
Multiple Boreholes
See also: Construction datasheet for more details about this data format.
Back to list.
Edit Notes
Optional. This worksheet is used to list text information and their identifying names, to be imported into a LogPlot Edit-Notes datasheet. This data can be displayed in the log headers and footers in Edit-Notes fields, typically used for entry of multi-line comments that change from well to well. For the data format for listing single-line labels, see Edit-Text.
Worksheet name in Excel: NOT_name
Example:
Single borehole
Multiple boreholes
See also: Edit Notes datasheet for other note information.
Back to list.
Edit Text
Optional. This worksheet is used to list text to be imported into a LogPlot Edit-Text datasheet. This is information that can be displayed in log headers and footers, in Edit-Text fields. These are used for short text labels that change from well to well (dates, names, etc.). For the data format for listing multi-line text, see Edit-Notes.
Worksheet name in Excel: EDT_name
Example:
Single borehole
Multiple boreholes
See also: Edit-Text datasheet for the LogPlot data format and other information.
Back to list.
Fill Bars
Optional. This worksheet is used to list one or more depth intervals and optional keywords to be imported into a LogPlot Fillbar tab. This information is displayed as color/pattern-filled intervals on the log. Optional is an entry in the 'fill' field - if absent the fillbar will show the default fill color/pattern, while if present the bar will be filled with the color/pattern associated with the keyword.
Worksheet name in Excel: FIL_name
Example:
Single borehole
Multiple boreholes
See also: Fillbar datasheet for the LogPlot data format and other information.
Back to list.
Horizontal Lines
Optional. This worksheet is used to list one or two depths for each 'horizontal' line, to be imported into a LogPlot Horizontal Line datasheet. This data can be displayed in the log body as lines in the color/style of your choice.
Worksheet name in Excel: HZL_name
Example:
Left Depth Right Depth
-5
-10
-15
-16 -17
See also: Horizontal Line datasheet for more information about the layout of this data.
Back to list.
Interbeds
Optional. This worksheet is used to list a top and base depth and lithology keyword for import into a LogPlot Interbed datasheet. This data is displayed as interbed overlays in a log pattern column. See Lithology for entry of the main lithology data.
Worksheet name in Excel: INB_name
Example:
Single borehole
Multiple boreholes
See also: Interbed datasheet for more information about the entry and use of interbed data.
Back to list.
Interval Data
Optional. This worksheet is used to list depth intervals (top and base) and one or more columns of values, to be imported into a LogPlot Interval Data datasheet. This is information that can be plotted in a Bar Graph, Bar Graph Value, or Interval Text column on a log. LogPlot will use the names in the first line of the Excel worksheet to label the columns in the resulting data file.
Worksheet name in Excel: HST_name
Example:
Single borehole
Multiple boreholes
See also: Interval-Data datasheet for information about the use of this kind of data.
Back to list.
Lithology Data
Optional. This worksheet is used to list one or more depth intervals and a lithology keyword, and for each a contact line style (optional), and/or an extended description for the interval. This information is imported into a LogPlot Lithology datasheet, and can be displayed in a pattern and/or lithology description column on a log.
Borehole Log Template Excel Download
Worksheet name in Excel: LTH_name
Example:
Single borehole
Multiple boreholes
See also: Lithology datasheet for information about the layout of this data.
Back to list.
Orientation Data
Optional. This worksheet is used to list depths and orientation measurements for non-vertical wells, for import into a LogPlot Orientation tab. This data can be used to display true elevations on log scale bars.
Worksheet name in Excel: SCB_name
Example:
Single borehole
Multiple boreholes
See also: Orientation datasheet for the LogPlot data format.
Back to list.
Pattern Percent Data
Optional. This worksheet is used to list depth intervals and the percentage of multiple rock types described for that interval, imported into a LogPlot Percent datasheet. This data can be displayed in the log body in a Pattern Percent column. For the data format for listing single lithology types, see Lithology.
Worksheet name in Excel: PPP_name
Example:
Borehole Log Template Excel Printable
Single borehole
Multiple boreholes
The names you enter for the column headings in Excel will determine the names LogPlot assigns the columns when imported. You can, however, change the column names in LogPlot once the data has been imported. These represent rock types that will link to patterns.
See also: Percent datasheet for the layout of this type of data.
Back to list.
Point Data datasheet
Optional. This worksheet is used to list one column of depths and one or more columns of values, to be imported into a LogPlot Point Data datasheet. This data can be displayed in the log body in a Curve or Cross-Plot Curve column. LogPlot will use the names in the first line of the Excel worksheet to label the columns in the resulting data file.
Worksheet name in Excel: CRV_name
Example:
See also: Point Data datasheet for the LogPlot data format and information about the specific fields.
Back to list.
Point Text
Optional. This worksheet is used to list depths and generic text, for import into a LogPlot Point Text datasheet. This text is displayed in log body Text Columns.
Worksheet name in Excel: TXT_name
Example:
Single borehole
Multiple boreholes
See also: Point Text datasheet for more information about this data format.
Back to list.
Scale Tables
Optional. This worksheet is used to list depth intervals and a new horizontal scale for the curve (Point Data) of the same name. This data is imported into a LogPlot Scale Table tab, and links to a curve in the log design with the same name.
Borehole Log Template Excel
Worksheet name in Excel: SCA_name
Example:
Single borehole
Multiple boreholes
See also: Scale Table datasheet for the layout of this type of data.
Back to list.
Symbols
Optional. This worksheet is used to list either single depths or depth intervals, and the index number (vector symbols) or names (bitmap symbols) for the designs to be placed there. Also listed are color definitions. This data is imported into a LogPlot Symbol datasheet, and is plotted in a log body symbol column.
Worksheet name in Excel: SYM_name
Example:
Single borehole
Multiple boreholes
See also: Symbols datasheet for more information about the layout of this data.
Back to list.
Tadpole (dipmeter) Data
Optional. This worksheet is used to list depths, dip directions, and dip angles for downhole structural information, to be imported into a LogPlot Tadpoles datasheet. This data can be displayed in the log body in a Tadpole column.
Worksheet name in Excel: TAD_name
Example:
Single borehole
Multiple boreholes
The color and value fields are optional.
See also: Tadpoles datasheet for information about the required data format.
Back to list.
Vertical Text
Optional. This worksheet is used to list depth intervals and text, to be imported into a LogPlot Vertical Text datasheet. The text is displayed as vertical labels in the log body in a Vertical Text column.
Borehole Log Template Excel Template
Worksheet name in Excel: VTX_name
Example:
Top Base Text
0 -5 grab
-5 -10 shelby tube
-10 -15 split spoon
See also: Vertical Text datasheet for more information about this data format.
Back to list.
Back to main topic