Page
28
of
32
7.7
Data Download
High sample rate data and the 15-minute mean / minimum / maximum / S3 data can all be downloaded from
the RADAR as CSV files. The instructions on the Download menu should be followed.
The time and date information in the CSV files is in a Unix epoch format which is the number of seconds since
midnight January 1, 1970. There is more information on this format here:
http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps
The CSV files can be loaded into excel and the epoch time converted into an excel format. From the above
link, and assuming that the epoch time is in cell A2:
1.
In a different cell, perhaps F2, enter the following formula:
=(((A2/60)/60)/24)+DATE(1970,1,1)
2.
Change the format of cell F2 to a date:
a.
Right click on cell F2;
b.
Select “Format Cells…”
;
c.
Select the “Number” tab
;
Select you preferred time / date format either from Date, Time or Custom;
d.
If choosing C
ustom, entering “dd/mm/yyyy hh:mm:ss.000” in the type
results in a format
which includes decimal seconds.
3.
Drag the formula down the sheet.
Содержание PIPEMINDER S
Страница 1: ......
Страница 10: ...Page 10 of 32 4 System Components...
Страница 11: ...Page 11 of 32 Figure 2 Device overview 101667...
Страница 14: ...Page 14 of 32 Figure 4 Configuration editor on RADAR...
