background image

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. 

Summary of Contents for SA1 W75 SR 60 N 564

Page 1: ...ck Court Stokesley Business Park North Yorkshire TS9 5PT UK T 44 0 1642 711400 F 44 0 1642 713900 W www analox net E info analox net Sub MkIIP Oxygen Carbon Dioxide Monitor User Manual US Navy Version...

Page 2: ......

Page 3: ...al power 100 240VAC 8 6 Calibration 9 6 1 Readout check 9 6 2 Use of calibration gas 10 7 Data logging 11 7 1 Installation of data logging software on a PC 11 7 2 Data logging program overview 13 7 3...

Page 4: ...Sub MkIIP Oxygen Carbon Dioxide Monitor User Manual US Navy Version Document Ref AS2 802 14 January 2016 Page 2...

Page 5: ...supply cable Part Number SAEP AS2 605 c User manual d Test certificates e Analox hyperbaric tested batteries x4 Part Number 2557 4625 Optional f Data output cable Part Number SAEP AS2 602 and softwar...

Page 6: ...ch the standard instrument has only one operator control A single pushbutton controls backlights for each of the liquid crystal displays LCD and can also be used to reset the elapsed time The unit is...

Page 7: ...the fuses in the external supply line or the battery circuit are not blown On powering up the instrument the sensor readings may take a short time to settle particularly the CO2 sensor which can take...

Page 8: ...nstrument is operating from an external power supply The backlight is turned on by momentarily pressing the pushbutton on the front of the instrument The backlight will turn off automatically after a...

Page 9: ...nt damage open the lid of the instrument using the two catches beside the handle b Undo the two Velcro retaining straps around the batteries c Ease each battery from its clips use one hand to grip the...

Page 10: ...ypical current consumption figures are shown below Input Voltage V DC Load Current without backlight mA Load Current with backlight mA 9 0 160 315 12 0 105 340 24 0 55 290 40 0 37 270 5 2 External pow...

Page 11: ...the right hand column as a guideline to the acceptable tolerance Also ensure that the SUB MkIIP is sampling the atmosphere from the same compartment as the CAMS To convert the CAMS Gas reading from u...

Page 12: ...ed with the instrument will be required and should be fitted as shown in Figure 2 The longer free pipe should be connected to the outlet of a test gas bottle flow regulator The flow adaptors in the ch...

Page 13: ...ensure all data from a DISSUB event is captured A cable is supplied to connect the SUB MkIIP to the serial port on a PC The cable is fitted with a 9 way female D type connector An adaptor will also b...

Page 14: ...ED THE NEXT TIME YOU START THE PROGRAM 11 Always ensure that the Baud rate is set to 9600 to which it will default 12 Click on the Communicate with Instrument button You will see a message Please wait...

Page 15: ...iable that you wish to view and a graph will be automatically generated This process will suspend logging you will therefore need to click on the Restart logging button on the Instrument Status page T...

Page 16: ...be apparent Full Memory This option enables you to specify what the instrument should do when its data logging memory is full You may choose to Ignore newer data if for example you are conducting a s...

Page 17: ...spreadsheet Therefore select an Excel compatible csv file CSV stands for a Comma Separated Variable file and is a format that most spreadsheet programs will recognize 8 Now select the folder and enter...

Page 18: ...n 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 wi...

Page 19: ...calibration is required at least once every 12 months to replace the electrochemical oxygen sensor Where the instrument is used as a standby for use in emergencies replace the main batteries as detail...

Page 20: ...effects Body Part Effect First Aid Procedures Skin Contact could result in a chemical burn Wash the affected part with a lot of water and remove contaminated clothing If stinging persists get medical...

Page 21: ...cklight times out after 15 seconds when turned on Oxygen Sensors See Appendix on page 22 Analox 9100 9212 9HSUB oxygen sensor with microprocessor applied temperature compensation 2 3 year life at 21 S...

Page 22: ...replacement or a refund of net purchase price paid as per our Invoice on initial purchase from us We shall have no liability for losses damages costs or delays whatsoever We shall have no liability f...

Page 23: ...Version Document Ref AS2 802 14 January 2016 Page 21 12 Disposal According to WEEE regulation this electronic product can not be placed in household waste bins Please check local regulations for info...

Page 24: ...yields the same partial pressure of oxygen as that present in the current environment SEV on the Sub MkIIP uses 1000mbara as its surface pressure for a point of reference For example 1 If the atmosph...

Page 25: ......

Reviews: