
171
Operation of the Software
Power Quality Recorder SICAM Q80 7KG8080, System manual
E50417-H1076-C420-A2, Release 12.01.2015
Each data set receives its own scaling column, which appears at the left of its respective data column.
Column header
In this input box, you define a title which appears above each individual scaling column. To do so, you can combine
fixed text with placeholders. Such placeholders denote specific values belonging to the data set and are filled upon
data saving with the current strings (e.g. name, comment, units) or numerical values (e.g. sampling interval, length). A
placeholder can be recognized as a permanent name bracketed from both sides by the "percent" character.
%NAME%, for example, denotes the name, and %YUNIT% the y-unit of the particular data set. In the list box at right,
all placeholders already defined are listed. Double-clicking on the entry of the desired placeholder (or selecting the
entry and hitting the button
[<<])
copies the placeholder to the current input position in the input box.
You can also use the context menu (right mouse click) of the input box to insert a placeholder. This also presents a list
of all available placeholders.
If no column header is needed, just leave the input box empty (or delete all the contents).
Scaling in: x-Unit
The scaling corresponds to the data set's x-unit.
Scaling in: Time
The scaling output is expressed as absolute time and date. This option, of course, only makes sense if data sets
recorded over time and having "s" (seconds) as the x-unit are actually involved.
The time values are converted to EXCEL time format and transferred. Then the EXCEL-column's numerical format us
set as time (see EXCEL menu item "Format/ Format cells/ Numbers").
Be aware that time statements in EXCEL only have a resolution of approx. 10ms. If your time axis has a finer
resolution, the precision will be reduced upon saving.
Seconds
Here you specify the resolution for the time display. "None" means display of the time of day in terms of
"Hours:Minutes", for instance "23:11". For the setting "1 s", the seconds are also indicated ("23:11:59"), "100ms" also
indicates tenths of seconds 1/10 ("23:11:59,4"), etc.
Date
If this is selected, the date (in abbreviated form, e.g. "11.12.01") is output together with the time of day.
The two specifications Seconds and Date, then, only determine the numerical format displayed initially. The display in
EXCEL can be edited later (menu item "Format/ Cell").