Back to main topicThe 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 data tabs; click on a link below to jump to its description.
! This discussion is for importing multiple boreholes. See Single Borehole for the format for importing a single well from an XLS file.
Required: This worksheet must be present and must contain data for the import to be successful.
Worksheet name in Excel: SETUPGRD
Example:
Bore Start Depth Ending Depth Easting Northing Elevation (KB)
DH-1 0 -40 123456 1234567 1000
DH-2 0 -65 123467 1234578 1021
DH-3 0 -54 123478 1234589 1120
Notes:
The Bore column is required, and will be used to reference the data in the other Excel worksheets. Other fields, if unknown, can be left blank. For example, you can omit the well location information from columns 4 and 5, but be sure that the column count is correct if you enter the KB elevation (which must be in column #5).
See also: Setup tab for the LogPlot data format and what the fields represent.
Back to list
Optional. This worksheet is used to list raster image file names and their depth intervals for import into a LogPlot Bitmap tab. These images can be displayed in the log body.
Worksheet name in Excel: BMP_GRID_name
Example:
Bore Top Base Bitmaps
DH-1 0.00 -40.00 elog-1.tif
DH-2 -5.00 -45.00 elog-2.tif
DH-3 0.00 -53.00 elog-3.tif
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Bitmap tab 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
Optional. This worksheet is used to list depths and values for a single measured item, to be imported into a LogPlot Curve tab. This data can be displayed in the log body in a Curve or Cross-Plot Curve column. For the data format for listing multiple curves, see Multi-Curves.
Worksheet name in Excel: CRV_GRID_name
Example:
Bore Depth Value
DH-1 -0 0.090
DH-1 -0.5 0.075
DH-1 -0.0 0.132
DH-1 -1.0 0.240
DH-3 -0 0.092
DH-3 -0.5 0.100
DH-3 -23.40 0.240
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Curve tab for the LogPlot data format and information about the specific fields.
Back to list
Optional. This worksheet is used to list text information and their identifying names, to be imported into a LogPlot Edit-Notes tab. 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: NOTGRD
Example:
Bore Entity Name Text
DH-1 Comments It was a dark and stormy night..
DH-1 Location 100 FWL 200 FSL Sec 32 Range...
DH-2 Comments Note interval at 220 feet.
DH-2 Location 150 FWL 15 FSL Sec 16 Range..
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. The text entries are limited to 2000 characters.
See also: Edit Notes tab for other note information.
Back to list
Optional. This worksheet is used to list text to be imported into a LogPlot Edit-Text tab. 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_GRD Note that the name field is optional. If no group name is desired for the Edit Text entries, the worksheet name can be simply EDITGRD.
Example:
Bore Entity Name Text
DH-1 Borehole Name DH-1
DH-1 Project Name Lexington
DH-1 Driller Name Jones & Co.
DH-2 Borehole Name DH-2
DH-2 Project Name Lexington
DH-2 Driller Name Allied
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. The text entries are limited to 120 characters.
See also: Edit-Text tab for the LogPlot data format and other information.
Back to list
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_GRID_name
Example:
Bore Top Base Fill
DH-1 -2500 -2543
DH-1 -2785 -2805 gas
DH-2 -1789 -1900
DH-2 -2500 -2538 gas
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Fillbar tab for the LogPlot data format and other information.
Back to list
Optional. This worksheet is used to list one or two depths for each "horizontal" line, to be imported into a LogPlot Horizontal Line tab. This data can be displayed in the log body as lines in the color/style of your choice.
Worksheet name in Excel: HZL_GRID_name
Example:
Bore Left Depth Right Depth
DH-1 -5
DH-1 -10
DH-1 -15
DH-1 -16 -17
DH-2 -5
DH-2 -10
DH-2 -15
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Horizontal Line tab for more information about the layout of this data.
Back to list
Optional. This worksheet is used to list a top and base depth and lithology keyword for import into a LogPlot Interbed tab. 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_GRID_name
Example:
Bore Top Base Lithology
DH-1 -5 -6.5 SAND
DH-1 -10 -11.5 CLAY
DH-2 -8 -9.5 SAND
DH-2 -11 -12.5 CLAY
DH-3 -6 -7 SAND
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Interbed tab for more information about the entry and use of interbed data.
Back to list
Optional. This worksheet is used to list one or more depth intervals and a single column of text or numeric data, for import into a LogPlot Interval-Data tab. This is information that can be plotted in an Interval Text, Bar Graph, or Bar Graph Value column on a log. For the data format for listing multiple columns in the same table, see Multi-Interval-Data.
Worksheet name in Excel: HST_GRID_name
Example:
Bore Top Base Value
DH-1 0 -5 25
DH-1 -5 -7 23
DH-1 -7 -10 15
DH-2 0 -4 20
DH-2 -4 -7.5 25
DH-2 -7.5 -10 12
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Interval-Data tab for information about the use of this kind of data.
Back to list.
Optional. This worksheet is used to list one or more depth intervals, and for each a contact line style (optional), a lithology keyword, and/or an extended description for the interval. This information is imported into a LogPlot Lithology tab, and can be displayed in a pattern and/or lithology description column on a log.
Worksheet name in Excel: LTH_GRID_name
Example:
Bore Top Base Lithology Contact Description
DH-1 0.0 -2.0 Gravel and Sand 0/1/0 with trace of silt
DH-1 -2.0 -3.0 Sand 1/1/0 with trace gravel.
DH-1 -3.0 -4.5 Sand and Silt
DH-2 0.0 -3.0 Gravel and Sand 0/1/0 silty, brown
DH-2 -3.0 -5.0 Sand and Silt with trace gravel.
DH-2 -5.0 -6.5 Sandy Gravel fine grained
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Lithology tab for information about the layout of this data.
Back to list
Optional. This worksheet is used to list depths and values for two or more measured item, to be imported into a LogPlot Multi-Curve tab. This data can be displayed in the log body in a Curve or Cross-Plot Curve column. For the data format for listing single curves, see Curves.
Worksheet name in Excel: MCR_GRID_MULTI_CURVE
Example:
Bore Depth Natural Gamma SP Resistivity
DH-1 -0.3750 20.1578 -230.0 25
DH-1 -0.5000 15.1598 -230.0 25
DH-1 -0.6250 22.5280 -230.0 25
DH-1 -0.7500 15.3411 -230.0 25
DH-2 -0.3750 21.8768 -215.0 21
DH-2 -0.5000 22.3948 -215.0 22
DH-3 -0.3750 19.4635 -236.0 24
DH-3 -0.5000 16.3671 -237.0 23
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. The names you enter for the curve 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.
See also: Multi-Curve tab for more information about laying out this type of data.
Back to list.
Optional. This worksheet is used to list one or more depth intervals and multiple columns of text or numeric data, for import into a LogPlot Multi-Interval-Data tab. This is information that can be plotted in an Interval Text, Bar Graph, or Bar Graph Value column on a log. For the data format for listing just a single column of values, see Interval-Data.
Worksheet name in Excel: MHS_GRID_MULTI_HISTOGRAM
Example:
Bore Top Base BTU Ash
DH-1 -19 -20 71.5 31.1
DH-1 -20 -21 82.7 43.3
DH-1 -21 -22 61.4 21.5
DH-3 -15 -17 61.5 28.2
DH-3 -17 -19 78.9 34.3
DH-3 -19 -22 55.7 29.0
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. 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.
See also: Multi-Interval Data tab for information about this type of data.
Back to list.
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_GRID_name
Example:
Bore Depth Bearing Inclination
DH-1 0 0 -90
DH-1 -20 15 -83
DH-1 -60 18 -80
DH-3 0 0 -90
DH-3 -30 25 -85
DH-3 -65 28 -78
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Orientation tab for the LogPlot data format.
Back to list.
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 tab. 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_GRID_name
Example:
Bore Top Base SANDSTONE SHALE LIMESTONE DOLOMITE
DH-1 -16720 -16725 30 0 70 0
DH-1 -16725 -16730 5 10 40 45
DH-1 -16730 -16735 0 100 0 0
DH-2 -15890 -15910 30 0 70 0
DH-2 -15910 -15945 5 10 40 45
DH-2 -15945 -16025 0 100 0 0
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. 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 tab for the layout of this type of data.
Back to list.
Optional. This worksheet is used to list depth intervals and a new horizontal scale for the curve 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.
Worksheet name in Excel: SCA_GRID_name
Example:
Bore Top Base Min Value Max Value
DH-2 -16720 -16755 0 100
DH-2 -16835 -16900 0 150
DH-3 -15080 -15150 0 100
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Scale Table tab for the layout of this type of data.
Back to list.
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 tab, and is plotted in a log body symbol column.
Worksheet name in Excel: SYM_GRID_name
Example:
Bore Depth/Top Base (optional) Symbol Size
DH-2 -12 140\16711680 0.3
DH-2 -18 141\255 0.3
DH-2 -20 -25 B\PIPE2\0\16777215\N 0.3
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. See also: Symbols tab for more information about the layout of this data.
Back to list.
Optional. This worksheet is used to list depths, dip directions, and dip angles for downhole structural information, to be imported into a LogPlot Tadpoles tab. This data can be displayed in the log body in a Tadpole column.
Worksheet name in Excel: TAD_GRID_name
Example:
Bore Depth Azimuth Dip Color Value
DH-2 -205 245 30 128 4.1
DH-2 -365 235 32 128 3.8
DH-2 -398 224 35 128 4.0
DH-3 -175 176 23 128 6.2
DH-3 -215 185 25 128 4.7
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet. The color and value fields are optional.
See also: Tadpoles tab for information about the required data format.
Back to list.
Optional. This worksheet is used to list depths and generic text, for import into a LogPlot Text Column tab. This text is displayed in log body Text Columns.
Worksheet name in Excel: TXT_GRID_name
Example:
Bore Depth Text
DH-1 -5 Ss
DH-1 -11 Sz
DH-1 -18 Sd
DH-1 -25 St
DH-1 -27 Sh
DH-3 -6 Ss
DH-3 -13 Sz
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Text Column tab for more information about this data format.
Back to list.
Optional. This worksheet is used to list depth intervals and text, to be imported into a LogPlot Vertical Text tab. The text is displayed as vertical labels in the log body in a Vertical Text column.
Worksheet name in Excel: VTX_GRID_name
Example:
Bore Top Base Text
DH-1 0 -5 grab
DH-1 -5 -10 shelby tube
DH-1 -10 -15 split spoon
DH-3 0 -5 grab
DH-3 -5 -10 shelby tube
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Vertical Text tab for more information about this data format.
Back to list.
Optional. This worksheet is used to list depth intervals, material types, diameters, and (optional) offsets, to be imported into a LogPlot Well Column data tab. This data can be displayed in the log body in a Well Construction column.
Worksheet name in Excel: WCN_GRID_name
Example:
Bore Top Base Outer Diam. Inner Diam. Material Offset
DH-1 0 -1 3.0 0.0 cap
DH-1 -14 -25 3.0 0.0 screen
DH-1 -25 -26 3.0 0.0 cap
DH-1 -26 -30 3.0 0.0 bentonite
DH-2 0 -1 3.0 0.0 cap
DH-2 -15 -23 3.0 0.0 screen
DH-2 -23 -26 3.0 0.0 bentonite
The Bore column is required - you need to be sure that the borehole names you list here are referenced in the SETUPGRD worksheet.
See also: Well Column tab for more details about this data format.
Back to list.
Back to main topic