Data Formatting Requirements for Logs

There are specific data table setup requirements for each log type in Strater. The actual source file type of the data is not important as long as the resulting data table in Strater is formatted appropriately to create the desired log(s). The following table provides information on data formatting for each log type.

Data Log Properties - General Concepts

Required data columns must be present in an imported data file. However, they do not have to be named the default names found in Strater or positioned in their default Strater position. For example, the default name for the column containing the identification number for the borehole is named Hole ID and is located in the first (far left) column in Strater; however, the actual column containing this data in the data file can have any name and be in any column position.

Many users have data in external tables (such as .XLS) that they want to import into Strater to be used in logs. Use the information in Modifying Loaded Data for Logs to make this importing process as easy as possible.

Table of Required Columns for Strater Logs

Use the following table to determine the types of data columns required for each log type.

Log Type: Click the log type name for additional information about the log type and data needed for that log.

Table Columns Required: Required columns are automatically created in the data table when you create this type of log. They cannot be deleted from the data table. In the case of Lithology, Well Construction, and Registered Raster logs the required columns also include the data columns because the full functionality of the logs requires these specific columns.

Data Columns Needed: These columns contain the data that is displayed in the logs in the borehole view. They are not required to create the data table, although they must be present (with data) to display a functioning log in the borehole view.

Log Type	Table Columns Required	Data Columns Needed
Depth	Hole ID, Depth	None
Line/Symbol	Hole ID, Depth	One data column (numeric)
Crossplot	Hole ID, Depth	Two data columns (numeric)
Zone Bar	Hole ID, From, To	Keyword
Bar	Hole ID, Depth	One data column (numeric)
Percentage	Hole ID, Depth	At least two data columns (numeric)
Tadpole	Hole ID, Depth	Two data columns (numeric), optional keyword
Post	Hole ID, Depth	One data column (numeric)
Classed Post	Hole ID, Depth	One data column (numeric)
Complex Text	Hole ID, From, To or Hole ID, Depth	One data column (numeric or alphanumeric)
Graphic	Hole ID, From, To	One data column (contains image file names)
Lithology	Hole ID, From, To, Lithology Keyword, Lithology Description, Indent Percentage, Indent Keyword, Indent Line Scale	Lithology Keyword (alphanumeric), optional Lithology Description (alphanumeric), optional Indent Keyword (alphanumeric), optional Indent Percentage (numeric), optional Indent Line Scale (numeric)
Registered Raster	registration file OR range table (Hole ID, From, To, Log Top, Log Bottom, Log Left, Log Right, Raster Log, Ref 1 Depth, Ref 2 Depth, Ref 1 Pixel, Ref 2 Pixel)	<none>
Unregistered Raster	<none>	<none>
Well Construction	Hole ID, From, To, Well Item, Offset, Inner Diameter, Outer Diameter	Well Item (alphanumeric), Offset (numeric), Inner Diameter (numeric), Outer Diameter (numeric)
Function	Hole ID, Depth	One data column (numeric - calculated from function)

Strater default settings are controlled through the File | Options dialog.