Unihedron

General Category => Connected meters (SQM-LE/LU/LR/DL) => Topic started by: admin on April 30, 2013, 12:31:25 am

Title: Import .dat file into Excel
Post by: admin on April 30, 2013, 12:31:25 am

The .dat file generated by UDM (http://unihedron.com/projects/darksky/cd/SQM-LU.html) and defined here (http://www.darksky.org/night-sky-conservation/248) 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