Unihedron
General Category => Connected meters (SQM-LE/LU/LR/DL) => Topic started 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