The .dat file generated by
UDM and defined
here can be imported into a Microsoft Excel spreadsheet for calculations and graphing purposes as follows:
- Start excel
- File Open
- Select "All files"
- Select your .dat file (previously recorded and saved).
- Select "delimited" (as opposed to the default "fixed width")
- Import starting at line 33
- Next
- Unselect "Tab"
- Select "Semicolon", you should see bars separating the data fields now.
- Next
- Define each field. European users will have to select "Advanced", then change the "Decimal point" to "." and "Thousands separator" to ","
- field 1,2 = date YMD
