Pag. 138 di 152
11.9.5 XLS output type
This type of output generates an XLS-formatted file suitable for Microsoft EXCEL
®
or for import by other
spreadsheet programs.
The file format is as below indicated; the example refers to a Load Profile file.
(0120)LoadProfiles
Size (bytes):
7416
Creation time (WALL):
28/05/2005 0.00
Last modification time (WALL):
29/05/2005 0.00
File Header - Input variables
Value
Max data-file number
60
Sampling interval [min]
15
Max data-file size [Bytes]
65535
File Header - Output variables
Value
Timestamp (main clock - WALL TIME)
28 may 2005 0.00.00
+01:00 GMT +01:00 DST
Serial number
300001
Slave ID
204
Data records
1
28/05/2005 0.00
3
14428124
392187
2651429
14910357
0
0
0
0
2
28/05/2005 0.15
3
14430481
392187
2652197
14912845
0
0
0
0
3
28/05/2005 0.30
3
14433148
392187
2652883
14915604
0
0
0
0
4
28/05/2005 0.45
3
14435144
392187
2653698
14917762
0
0
0
0
5
28/05/2005 1.00
3
14437105
392187
2654428
14919858
0
0
0
0
6
28/05/2005 1.15
3
14439101
392187
2655082
14921963
0
0
0
0
7
28/05/2005 1.30
3
14441182
392187
2655727
14924143
0
0
0
0
8
28/05/2005 1.45
3
14443281
392187
2656443
14926362
0
0
0
0
9
28/05/2005 2.00
3
14445152
392187
2657197
14928385
0
0
0
0
10
28/05/2005 2.15
3
14447022
392187
2657934
14930398
0
0
0
0
11
28/05/2005 2.30
3
14449287
392188
2658387
14932712
0
0
0
0
12
28/05/2005 2.45
3
14451134
392188
2659204
14934732
0
0
0
0
13
28/05/2005 3.00
3
14453027
392188
2659971
14936778
0
0
0
0
14
28/05/2005 3.15
3
14455038
392188
2660620
14938893
0
0
0
0
15
28/05/2005 3.30
3
14457206
392188
2661328
14941178
0
0
0
0
16
28/05/2005 3.45
3
14459146
392188
2662114
14943275
0
0
0
0
17
28/05/2005 4.00
3
14461012
392188
2662878
14945295
0
0
0
0
18
28/05/2005 4.15
3
14462930
392188
2663630
14947360
0
0
0
0
19
28/05/2005 4.30
3
14465031
392188
2664231
14949547
0
0
0
0
20
28/05/2005 4.45
3
14466831
392188
2664977
14951501
0
0
0
0
21
28/05/2005 5.00
3
14468538
392188
2665771
14953385
0
0
0
0
22
28/05/2005 5.15
3
14470591
392188
2666437
14955547
0
0
0
0
23
28/05/2005 5.30
3
14472698
392188
2667226
14957800
0
0
0
0
24
28/05/2005 5.45
3
14474531
392188
2668068
14959821
0
0
0
0
25
28/05/2005 6.00
3
14476423
392188
2668822
14961859
0
0
0
0
26
28/05/2005 6.15
3
14478246
392188
2669611
14963848
0
0
0
0
27
28/05/2005 6.30
3
14480031
392188
2670255
14965749
0
0
0
0
28
28/05/2005 6.45
3
14481599
392188
2671001
14967489
0
0
0
0
29
28/05/2005 7.00
3
14483086
392188
2671772
14969167
0
0
0
0
30
28/05/2005 7.15
3
14484945
392188
2672572
14971197
0
0
0
0
31
28/05/2005 7.30
3
14486767
392188
2673221
14973136
0
0
0
0
32
28/05/2005 7.45
3
14488313
392188
2674077
14974905
0
0
0
0
33
28/05/2005 8.00
3
14489994
392188
2674781
14976733
0
0
0
0
34
28/05/2005 8.15
3
14492169
392188
2675321
14978993
0
0
0
0
35
28/05/2005 8.30
3
14494615
392188
2675636
14981460
0
0
0
0
36
28/05/2005 8.45
3
14497020
392188
2675985
14983892
0
0
0
0
37
28/05/2005 9.00
3
14499346
392188
2676444
14986264
0
0
0
0
38
28/05/2005 9.15
3
14502360
392188
2676808
14989305
0
0
0
0
39
28/05/2005 9.30
3
14506043
392188
2677062
14992998
0
0
0
0
40
28/05/2005 9.45
3
14510854
392188
2677670
14997849
0
0
0
0
41
28/05/2005 10.00
3
14516062
392188
2678126
15003079
0
0
0
0
42
28/05/2005 10.15
3
14521228
392188
2678446
15008257
0
0
0
0
43
28/05/2005 10.30
3
14526235
392188
2678788
15013277
0
0
0
0
44
28/05/2005 10.45
3
14530906
392188
2679179
15017966
0
0
0
0
45
28/05/2005 11.00
3
14535620
392188
2679827
15022726
0
0
0
0
46
28/05/2005 11.15
3
14540896
392190
2680364
15028034
0
0
0
0
47
28/05/2005 11.30
3
14546286
392195
2680678
15033438
0
0
0
0
48
28/05/2005 11.45
3
14551083
392195
2681195
15038264
0
0
0
0
49
28/05/2005 12.00
3
14555830
392195
2681560
15043028
0
0
0
0
50
28/05/2005 12.15
3
14560648
392196
2681967
15047865
0
0
0
0
51
28/05/2005 12.30
3
14565573
392196
2682662
15052855
0
0
0
0
52
28/05/2005 12.45
3
14569713
392196
2683660
15057114
0
0
0
0
53
28/05/2005 13.00
3
14573576
392196
2684743
15061129
0
0
0
0
54
28/05/2005 13.15
3
14576436
392196
2685523
15064097
0
0
0
0
55
28/05/2005 13.30
3
14579362
392196
2686138
15067091
0
0
0
0
56
28/05/2005 13.45
3
14581896
392196
2687008
15069771
0
0
0
0
57
28/05/2005 14.00
3
14584373
392196
2687805
15072377
0
0
0
0
58
28/05/2005 14.15
3
14588232
392196
2688545
15076309
0
0
0
0
Variable
Variable
Record number
Timestamp (main clock -
WALL TIME)
Trigger
event
Ea imp
[Wh/10]
Er ind imp
[varh/10]
Er cap imp
[varh/10]
Es exp
[VAh/10]
Es imp
[VAh/10]
Ea exp
[Wh/10]
Er ind exp
[varh/10]
Er cap exp
[varh/10]
Please note that the recorded data are the absolute values of the energy counters at sampling time.
With a sampling interval of 15 minutes, the values over one day are 96 + 1 initial value (at 00,00 hours)
that is needed for the calculation of the energy over the 1st sampling period.