100/180 mm PAPERLESS GRAPHIC RECORDER: USER GUIDE
HA028910
Issue 13 Sep 16
User Guide
Page 90
4.3.5 ARCHIVE CONFIGURATION (Cont.)
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.
Figure 4.3.5d CSV data example
FTP FILE FORMAT
The above description for ‘Media fi le format’ also applies to ‘Remote’ setting.
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 08/04/05 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