Eurotherm 6100, User Manual

Page: 97 / 397

100/180MM DISTRIBUTED GRAPHIC RECORDER: USER GUIDE
HA029324
Issue 11 Oct 14 Page 81
4.3.5 ARCHIVE CONFIGURATION (Cont.)
MEDIA FILE FORMAT (Cont.)
If ‘CSV’ or ‘Binary and CSV’ is selected, a number of extra check boxes appear. Figure 4.3.5c above,
shows a typical menu page. Figure 4.3.5d below, shows the effects of enabling the CSV check boxes,
with the exception of ‘CSV use Tab delimiter’ the use of which is as follows:
CSV USE TAB DELIMITER
Despite its name, CSV does not always use commas as separators.
For example, in some countries, the decimal point is represented by a full stop (period), whilst in other ar-
eas, a comma is used. In order to avoid confusion between the comma as a decimal point and the comma
as a separator, a different separator is used, usually the semicolon.
The instrument automatically chooses a separator suitable for use with the ‘Locale’ selected in System
Confi guration (
section 4.6.2 ). ‘CSV Use Tab delimiter’ allows the user to override this choice, and force
the instrument to use tabs as separators. This can be particularly useful when moving the data from one
locale to another.
CSV DATE/TIME FORMAT
Allows ‘Text’ or Spreadsheet numeric to be selected. Text causes a time/date to appear in the spread-
sheet. Spreadsheet numeric displays the number of days since December 30th 1899. The decimal part
of the value represents the latest 6 hours, so DDD---DDD.25 represents 0600 hrs, DDD---DDD.5 repre-
sents noon etc. Numeric format is more easily interpretable by some spreadsheets than Text format is.
Tank1 Temp1
Tank1 Temp2
Tank1 Temp3
Tank2 Temp1
Tank2 Temp2
Tank2 Temp3
Group Name
Difference
Tank Temps
Date/Time
Mac Address
Name=
Tank1 Temp1 Tank1 Temp1 Tank1 Temp1 Tank2 Temp1 Tank2 Temp2 Tank2 Temp3
Distil temp Timezone=
Country=
Software Version
Language=
Serial Number
A B C D E F G H I J K L M N O
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
00:AB:8D:80:26:C0
Instrument 1 9921
en
4.0
GB GMT
09.39.0
-C -C Deg C Deg C Deg C Deg C
23.49 23.74 24.01 31.2334 29.7693 30.0983
09.44.0 23.53 23.70 23.88 30.6458 29.0673 29.9083
09.49.0 23.57 23.68 23.91 30.0945 28.8936 29.9083
09.54.0 23.50 23.69 23.99 31.1437 29.4387 30.0235
A1 = Instrument
Ready
Tank Temps~8026C026000002A9
Click/drag separator
to edit field width
Low=
Low=
Low=
Low=
Low=
Low=
0
0
0
0
0
0
Low= -20
High=
High=
High=
High=
High=
High=
40
40
40
40
40
40
High= +20
-C
-C
Deg C
Deg C
Deg C
Deg C
Deg C
Difference
Deg C
6.61
6.13
5.91
6.47
Include column
headings
Include values
Include header
details
09.54.0 11/07/06 14:09:54 Alarm off
End of Archive
Right click, then:
Format cells...
Select 'Time' as number category
Select time/date 'Type' as required
Include messages
Figure 4.3.5d CSV data example
FTP FILE FORMAT
The above description for ‘Media fi le format’ also applies to ‘Remote’ setting.