Bird Technologies VPM3 - Manual (Page 39)

31
Analyzing Logged Data
The simplest way to view logged data is to recall in VPM3. See “Chart Display”
on page 14.
Note:
Only log files saved as .xml can be opened and viewed in the
VPM3. Files saved in comma-separated format (CSV) can be read by
most common spreadsheet programs.
Since logged data is stored in a text file in an .xml or comma-separated text file
where each line is one data record. Fields are separated by commas format, it is
also readable by most spreadsheet programs.
Each log file is stored in a separate file that is named using the same date-time
file naming format as for quick-save.
Opening .xml Files in Excel
1.
Open the file in Microsoft Excel.
Note:
The file will appear in Microsoft Excel with each field in its own
column.
2. Filter the data, since the Extensive Markup Language format is a hierarchi-
cal format.
a. In the Measurement column, select the drop-down and check only
the Forward Average label.
b. In the Limit Type column, select the drop-down and check only the
Lower label.
Note:
This will now show data in a time vs. power format. Additional
filtering and sorting can be applied using the options in the column
headers.
Opening .csv Files in Excel
1.
Open the file in Microsoft Excel.
Note:
The file will appear in Microsoft Excel with each field in its own
column. If all the data is in a single column, follow these steps to con-
vert it:
a.Click on the column name, to select the entire column.
b.Select Text To Columns, under the Data tab.
Note:
A conversion wizard should open.
c.Select Delimited, under Original Data Type.
d.Click Next.
e.Check Comma, under Delimiters.
Note: All other delimiters should be unchecked. Treat Consecutive
Delimiters as One should be unchecked.
f.Click Next.
g.Click Finish.