DEV 1953, Руководство пользователя

Страница: 64 / 143

User Manual DEV 1953
64

Copyright DEV Systemtechnik GmbH 2015-2017
listed with "
Values
" instead of "
Time
". This sequence is repeated for all columns that
are part of the csv-file.
The actual data starts in the second line of the csv-file. Note that the time
information is stated in standard MS Excel format, i.e. the integral part of the
number defines the date (starting from 1 being the 01-Jan-1900, e.g. 42972
denotes the date 25-Aug-2017) and the fractional part defines the time within the
date (1/(24 * 60 * 60) = 00:00:01, e.g. .71875 = 17:15:00).
In the following only the first few lines of a csv-file are listed which was created by
exporting the data shown in this chapter via the button
("
⌡
" and "
⌠
"
are symbolizing that the two consecutive lines are actually one line in the file):
Channel In 4-1 RF Level Time;Channel In 4-1 RF Level Values;
⌡
Channel In 4-2 RF Level Time;Channel In 4-2 RF Level Values;
42972.717210648148148;-25.5;42972.717210648148148;-24.7;
42972.717905092592593;-25.5;42972.717905092592593;-24.7;
42972.718599537037037;-25.5;42972.718599537037037;-24.7;
42972.719293981481481;-25.5;42972.719293981481481;-24.7;
42972.719988425925926;-25.5;42972.719988425925926;-24.6;
42972.720682870370370;-25.5;42972.720682870370370;-24.7;
42972.721377314814815;-25.5;42972.721377314814815;-24.7;
After import and formatting the "Time" columns to the format
"DD-MMM-YYYY, hh:mm:ss" this results in the following table:
Channel In 4-1
RF Level Time Channel In 4-1
RF Level Values Channel In 4-2
RF Level Time Channel In 4-2
RF Level Values
25-Aug-2017, 17:12:47 -25.5 25-Aug-2017, 17:12:47 -24.7
25-Aug-2017, 17:13:47 -25.5 25-Aug-2017, 17:13:47 -24.7
25-Aug-2017, 17:14:47 -25.5 25-Aug-2017, 17:14:47 -24.7
25-Aug-2017, 17:15:47 -25.5 25-Aug-2017, 17:15:47 -24.7
25-Aug-2017, 17:16:47 -25.5 25-Aug-2017, 17:16:47 -24.6
25-Aug-2017, 17:17:47 -25.5 25-Aug-2017, 17:17:47 -24.7
25-Aug-2017, 17:18:47 -25.5 25-Aug-2017, 17:18:47 -24.7
Note:

The decimal separator in the csv-file is the point character ("."), this has to be
considered during the data import of the csv-file e.g. into an Excel worksheet.

For the data import into an empty MS Excel worksheet select the tab "Data"
and there the icon "From Text". Then locate the csv-file and follow the instruc-
tions of the text import wizard.

The correct time information is dependent on the proper configuration of a
timeserver and of the timezone. The settings can be applied via the network
setup of the Setup Tab (chapter 5.5.7.2.1).
If no timeserver is configured for the device, the recording of the data starts at
01-Jan-2000, 00:00:00; after a device reset the time is reset to 01-Jan-2000,
00:00:00 as well, but the recording of the data is continued with the time of the
last sample.
If a timeserver was configured for the device that is not available anymore after
a reset, the recording of the data is continued with the time of the last sample
as well. Otherwise, if the timeserver is available after a device reset, the
recording of the data is continued with the correct time; i.e. this causes a time
gap within the data.