Sub MkIIP Oxygen & Carbon Dioxide Monitor
User Manual - US Navy Version
Document Ref
: AS2-802-14 -
January 2016
Page 16
7.5
Data logging data analysis
Microsoft Excel is not provided with the Analox system. If you do not have a copy of
Microsoft Excel, other spreadsheets will also allow access to the data. These
instructions are limited however to the use of Excel. You may choose to access the
data in a variety of ways, either via Excel or Windows Explorer. These instructions are
based on loading the file from Excel.
1. Start Microsoft Excel from your Start Menu or from your desktop.
2. Select File, Open and then navigate to the folder in which you chose to store the data
file (e.g. in c:\My Documents).
3.
Select files of Type ‘Text Files’. All of the CSV files in the chosen folder will appear.
Click on the file that you wish to inspect, and then click on
‘Open’
4. The data from the file will then appear in a standard Excel Worksheet.
5. Note that the first column of data is the date and time of the reading. This field is too
wide to fit in the standard width of the cell. Click on the ‘A’ at the top of the column,
and then select Format, Column, and Autofit Selection. Or simply drag the column
separator between ‘A’ and ‘B’ to achieve the right width.
6.
Select the right format for the Date and Time. Click on ‘A’ at the top of Column A,
then press Format, Ce
lls. On the ‘Number’ tab, under category, select ‘Date’, and
then under ‘Type’ select 03-04-97 13:30 or similar.
7.
Now to graph the CO2 reading, click on the ‘A’ at the top of Column A, then press and
hold the CTRL key on the keyboard, and click on the ‘C’ at the top of the CO2
column. Then click on Insert, Chart (or press the small Chart Icon on the toolbar if
you have one).
8.
Under ‘Chart Type’ choose XY scatter, and under ‘Chart Sub Type’ choose the type
of lines that you wish on the chart. (Hint
– Use Scatter with data points connected by
lines).
9.
Now press ‘Finish’ or choose ‘Next’ if you wish to refine the appearance of the graph.
10. A graph will appear on the screen with the x-axis showing the date and time, and the
y-axis showing the CO2 reading.
11. The basic appearance of the graph can now be edited, but to do so requires
familiarity with Microsoft Excel. There are several books available at almost any
computer store on this subject.