Dynamax Dynamet 5, User Manual

Page: 56 / 83

Dynamet 5
55
6.4 Open Data
– Using EXCEL
1. In the earlier sections it was recommended to save collected data in .csv format such that
the collected data can be readily opened in Excel or any preferred spreadsheet
application. In the windows explorer navigate to the location where data files are saved.
Select the required file (saved in .csv) format and double click to open this Excel.
Alternatively, Launch Excel application, and open the file using open wizard and csv
format. Figure below shows the Output table file Dynamet 5_OutTable.csv as displayed
in excel window.
2. In excel it is much simpler to plot required columns and there is no limitation on the
number of columns that can be displayed in a chart. Ideally all the variables saved in the
OutTable can be displayed in the same chart using multiple axes option. Select column/
columns for charting along with the Time stamp or Jday and HHMM for X-axis. Click on
chart wizard button, follow steps in the wizard to complete the wizard and display chart as
shown below for ETP, Global radiation.