
168
SICAM Q80 7KG8080
Power Quality Recorder SICAM Q80 7KG8080, System manual
E50417-H1076-C420-A2, Release 12.01.2015
6.3.3.2.2 Defining EXCEL export templates
The template definition dialog offers controls for all settings necessary for complete definition of an EXCEL export
template. Because of the large amount of available options, the dialog is divided into different index cards.
Dialog: Define EXCEL export template
The division of the dialog also reflects the basic structure of an `XLS-file:
Example of an EXCEL-file with 2 data sets
In general, it consists of a file header [Cells A1 to A5], which can contain a permanent text and/or general information.
Next, the data set readings follow in adjacent columns. Each column, in turn, can have its own column header [Cells 6
to 8], which can feature indications of the column contents, such as channel name, sampling rate, comments or
similar things. Below the column header, the actual numerical values appear [starting at Row 9].
There is also a distinction between scaling columns [Columns A and C and readings columns [Columns B and D]. A
scaling column returns the scaling (e.g. the time axis) for all readings columns to its right. In the case of multi-column
files, one scaling column at left can be valid for all subsequent readings columns, or each data set can come with its
own scaling column.
This basic structure determines what specifications are necessary for describing such a format.
The index card
"General"
covers global settings such as column separators and the decimal character to
use with numbers, along with export template specifications.
The index card
"Data"
describes the structure of a readings column, including column header, column
width and numerical format.
Analogously, the index card
"Scaling"
controls the arrangement and format of the scaling column(s).
The index card
"File header"
defines the introductory text at the beginning of a file.
Under
"Miscellaneous"
, further options mainly affecting only special data types can be found.
Once you have made all settings necessary, you can save the export template definitions to a file by hitting the
"Save"
button.
This file is stored in the default definitions folder. It bears the export template's name, plus the extension "
.aet
". If the