Martel Electronics BetaLOG-PI - Manual (Page 23)

There are six field values for each triple value
pressure reading: the date, the time, the average
reading, the minimum reading, the maximum
reading, and the pressure unit. The second, third,
etc. values are placed in the immediately adjacent
cells to the right of the first. If the field description is
included, the field description is placed in the
specified cell column and the field values are placed
in the next cell columns to the right. If the field
description is not included, the field values are
placed in the specified cell columns.
Temperature Readings
If temperature readings are available in the uploaded
data, they are listed one per row starting at the
specified cell row. There are two field values for
each single value sample: the temperature, and the
temperature unit. The second value is placed in the
immediately adjacent cell to the right of the first.
There are four field values for each triple value
sample: the average temperature, the temperature at
the time of the minimum pressure, the temperature
at the time of the maximum pressure, and the the
first. If the field description is included, the field
description is placed in the specified cell column
and the field values are placed in the next cell
columns to the right. If the field description is not
included, the field values are placed in the specified
cell columns.
5. Excel Templates
An Excel template contains predefined text, titles, graphs, and
calculations which are merged with uploaded pressure data to form a
more complete spreadsheet presentation. A template may be reused
many times, thus avoiding unnecessary work reformatting raw data.
Templates are created with Excel in the same manner as normal
spreadsheets and they support all Excel features. They are stored with
the special ".xlt" suffix to differentiate them from normal spreadsheets,
and to avoid overwriting them when saving merged data.
The field options and Excel cell locations specified on the Export
options screen must be coordinated with the predefined data in the
template to ensure a correct merging of the data.
The sample templates provided with BetaLOG are described below.
They are provided in a separate folder on the distribution media and
must be manually copied to your hard drive.
21