Figure 18: Example Data File
3.3
Data Conversion
3.3.1 Time Stamps: Relative Mode
By default, the time stamps represent the elapsed seconds relative to the start time listed in the file
header. Add the time stamp to the start time to determine the complete date/time of each sample.
The time stamp calculation is incorporated easily into a spreadsheet, such as Excel or Calc. First, open
the data file in a spreadsheet and parse on the comma (“,”) deliminator. Most spreadsheets will
automatically parse the data using the “,” character. The parsing operation will separate the start_time
into two cells – date and time. Use the “trim” function to strip the white space around the date cell and
use “concatenate” to combine the text into a new start date. The spreadsheet will automatically format
the new text into a date. Next, divide the time stamp entry by 86400. This converts the time stamp
into a value compatible with the spreadsheet date functions. Finally, add the new time stamp to the
new start date and a complete data/time is generated. Format the column as a “time” category and
include the trailing “.000” to present the millisecond precision.
Gulf Coast Data Concepts
Page 17
X16-5, Rev New
Figure 19: Time Stamp Conversion Method
;Title, http://www.gcdataconcepts.com, X16-5, Analog Dev ADXL345
;Version, 2031, Build date, Dec 2 2020, SN:CCDC1016D2A5B00
;Start_time, 2020-12-15, 10:15:24.390
;Uptime, 5,sec, Vbat, 3270, mv, EOL, 3200, mv
;SampleRate, 100,Hz
;Deadband, 0, counts
;DeadbandTimeout, 0.000,sec
0.163,10,24,-2054
0.173,21,28,-2063
0.183,17,12,-2090
0.194,3,7,-2097
0.204,30,5,-2061
0.214,24,24,-2061
0.224,17,26,-2082
0.234,44,16,-2063
0.245,19,33,-2072
0.255,-2,26,-2093
0.265,39,3,-2061