Excel templates, 1 single run graph for interval end data upload – Martel Electronics BetaLOG-TI User Manual
Page 14

BetaLOG TI
User Manual
Revision 1.00, October 22, 2010
Page 14 of 16
and third placed in the immediately adjacent cells to
the right of the first.
Readings
Readings are listed one per row starting at the
specified cell row. There are four field values for each
single value sample: the date, the time, the interval
end temperature reading, and the temperature unit.
The second, third, and fourth values are placed in the
immediately adjacent cells to the right of the first.
There are seven field values for each multiple value
sample: the date, the time, the interval end
temperature reading, the minimum temperature, the
maximum temperature, the average temperature, and
the temperature 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.
5.
Excel Templates
An Excel template contains predefined text, titles, graphs, and calculations
which are merged with uploaded temperature 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 TI are described below.
They are provided in a separate folder on the distribution media and must
be manually copied to your hard drive.
5.1
Single Run Graph for Interval End Data Upload
This template provides custom titles and a graph of the merged data for a
single run. It lists and graphs the interval end values for all sample points.
It assumes that a base date is entered for the run. The graph vertical axis
is scaled to the range of the uploaded temperature values and the
horizontal axis is scaled to the number of samples uploaded.
The template file name is: