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

Страница: 138 / 152

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.