View Sheet

The View sheet links together the data with the selected template. While the Template sheet is data-independent, and the Data sheet is template-independent, the View sheet provides the final instructions for how you want the data to appear. The Tracks Section defines the combination of tracks, and their contents, while the PlotControl section defines the depth range, scale and the appropriate horizontal grid. One important implication of this is that the View sheet cannot be loaded until the Template sheet has been loaded.
The View sheet has just two sections. These must appear in the order given below without any blank rows between them. Borders on cells are optional. There must be a blank column to the right of each set of view parameters. After that, columns may contain notes to explain the parameter meanings and options.
The View page must begin with the two lines:
template start
where cell A1 must contain "OPENLOGPLOT" and cell A2 must contain "VIEW" (case insensitive). The values in B1 and C1 are currently ignored but reserved for future use in case new formats are introduced for the View Sheet in future releases.
Each section is introduced with a line starting "#===" like this:
template start
with the section name preceded with a "~" character. The View sheet must end with the lines:
template start


The PlotControl Section is used to define one or more views onto the data set. This is useful as everything alse remains the same - the same tracks, and the same assignment of data to templates. The only change is that the depth range being viewed is different, which probably requires a different scale for displaying the data, and probably a different horizontal grid appropriate for that scale.
The format of the depth annotation can be set so as to "anonomize" the depths. This is very useful when plots are to be shared publicly without disclosing the exact depths to which the data relates.
The NAME should be a unique name for the view. It is added to the drop-down list of views that can be selected in the user interface.
The UNITS specifies how the following depth values are to be interpreted. It should be one of "mm", "cm", "m", "in" or "ft" (case independent).
The FRDEPTH specifies the start depth of the plot, in the specified units.
The TODEPTH specifies the end depth of the plot, in the specified units.
The SCALE value is used to determine the scale at which the data are displayed. Valid values are in the format "XXXXX:1" (for example "200:1", "1000:1") or may be the keyword "AUTO" which means that the scale will be determined by fitting the desired depth range to the available plotting area, as specified by the page, border and header/footer settings. NOTE: it may be necessary to set the cell format to 'Text' to prevent Calc interpreting the data as a time and reformatting it!
HGRID must be in the format "UNITS:NAME" or NULL. A value of NULL indicates that no horizontal grid is to be shown. The "UNITS:NAME" format must match an HGRID template with this NAME and UNITS. The purpose of having different HGRID settings for each View is to suit the display to the depth range. For example, in the example above, when viewing "LOWER DETAIL" a fine metric horizontal grid is used (defined in the Template sheet as having major lines every 20m and minor lines every 5m). Note that for the "LOWER SECTION" view, the HGRID is specified as "AUTO:DEFAULT" - the units will be determined by the selected View's units and the major and minor plot values will be automatically calculated according to the depth range of the plot. See Template HGRID specification for details.
As a special case, the value "AUTO" can be used for the HGRID name. This will attempt to generate a suitable horizontal grid taking into account the depth range called for by the FRDEPTH and TODEPTH above.
The DEPTFMT is a format string specifying how the depth values should be displayed. The format is of the form "[X]000.0" where X means that any depth characters at this decimal and above should be shown as an "X" to anonomize the depth. For example, value of "0.0" will show the depth to the first decimal place. A value of "X000" will show the depths as an integer number with only the hundreds, tens and units of the depth being displayed, as shown below.
anonomous depths
The HPAGES value is reserved for future use. The value should be set to AUTO.
The VPAGES value is reserved for future use. The value should be set to AUTO.


The Tracks Section specifies the set of tracks, their width, background and border size, their horizontal and vertical grid, and the data to be shown in each track, expressed as a Data:Template pair. The specified Template should be defined in the Template sheet (has to be loaded BEFORE the View sheet). However, the data does not have to be present in the chosen Data sheet. Data that is specified but absent from the Data sheet will be ignored.
The NUMBER should be an incrementing positive integer for each track.
The TYPE is currently either "DEPTH" or "CURVE". The former cannot show curves, but may include intervals and/or tops. The "CURVE" track is effectively the "do everything else" track type, being able to show curves, intervals, tops, graphs and points.
The WIDTH should be expressed as a number followed by a length identifier, such as "1cm", "25mm", or "1.5 in". A space between the number and the length is optional.
The BKGND specifies the color value for the track, using the #RRGGBB hexadecimal format (RR, GG and BB for red, green and blue respectively).
The BTHICK is the thickness, in 1/100mm, of the rectangular track border.
HGRID must be in the format "UNITS:NAME" and specify the name of a valid Horizontal Grid defined in the Template sheet. A value of NULL indicates that no horizontal grid is to be shown. If either UNITS or NAME is "AUTO" then the appropriate value from the View should be used instead. Thus, as in the example above, the value "AUTO:AUTO" defers entirely to the View (i.e. every track has the horizontal grid as determined by the View - with the exception of track 6 which has no horizontal grid).
VGRID must be the name of a valid Vertical Grid defined in the Template sheet. A value of NULL indicates that no vertical grid is to be shown.
There then follows a number of DATA rows, as many as needed for the track contents you want to display. A NULL in any DATA row is used as a placeholder in those tracks that have less data than others. In general, for all data content, the format of a DATA row entry is "DATA:TEMPLATE" where "DATA" refers to a named data source in the Data sheet, such as a log name, a point-set name, and interval-set name, a graph name, and so on. The "TEMPLATE" reference after the colon separator references a defined template from the Template sheet, appropriate for the data type given.
For example, in track #2 above, the "GR" data log will be displayed twice, once using the "GR" curve template and a second time using the "RGR" curve template (which displays the curve with high values on the left). In addition, the "MEM" zone set will be displayed using the "INT01" interval template.
The CUTOFF is used to specify a track cutoff (used for fill purposes) and is in the format "Cx:Value" where C1 is the first curve in this track C2 is the second, and so on; and the "Value" is the cutoff value using that curve's Template-specified data range. Thus, if a "GR" curve is the first curve listed in a track and is being displayed (according to its template) as ranging from 0 on the left to 150 on the right, a CUTOFF entry of "C1:50" would indicate that the cutoff is one-third of the track width.
Finally, there may be one or more FILL rows used to specify what fill(s) to apply to the track. Like the DATA rows a value of NULL is used as a placeholder if no fill is required. The FILL value must be the name of a Fill template as specified in the Template sheet.
For example, in track #2 above, the "MODC1" fill template has been specified. This is defined in the Template sheet as a fill between C1 and C2 (the two "GR" curves in this case) with a fill whose color is chosen from the "YELLOW-BLACK" palette according to the value of C1.