manualshive.com logo in svg

TPS WP-82, Handbook, Page: 32 / 48

Share
Download
TPS WP-82 Handbook Download Page 32

 

Page 32 

11.8  Importing Data into Microsoft Excel 

The following procedure details the method for importing a 

WP-82Y

 text 

data file into Microsoft

 Excel

. 

1.  Start Microsoft

 Excel

 and select File 

 Open 

2. 

In the “Files of type:” pull-down box, choose “Text Files (*prn; *.txt; 
*.cs

v)”. 

3.  Navigate to the folder where your data file is stored and double-click 

it to start the Text Import Wizard. 

Note:

 

The default data folder for the WinTPS software is “C:\My 

Documents\

WinTPS”. 

4. 

In step 1 of the Text Import Wizard select “Fixed width”, as per the 
sample screen below, then press “Next >”. 

 

Continued over the page… 

Summary of Contents for WP-82

Page 1: ...ons have also been included to enable you to find the information you need at a glance 2 Introduction The introduction has a diagram and explanation of the display and controls of the WP 82Y It also contains a full listing of all of the items that you should have received with your WP 82Y Please take the time to read this section as it explains some of items that are mentioned in subsequent sectio...

Page 2: ... TPS Pty Ltd ABN 82118101714 6 253 Leitchs Rd Brendale QLD 4500 Australia Phone 07 3205 8400 International 61 7 3205 8400 Fax 07 3205 8449 International 61 7 3205 8449 Email tps tps com au Web www tps com au ...

Page 3: ...re Correction 18 7 2 Changing the Altitude or Pressure Correction value 19 7 3 Notes 19 8 Good Laboratory Practices GLP 20 8 1 To recall GLP information on the display 20 8 2 Failed Calibration 22 8 3 Printing GLP Information to the RS232 Port 22 8 4 Instrument Serial Number 23 8 5 Additional GLP Features 23 9 Notepad Function 24 9 1 Recording Readings into the Notepad 24 9 2 Recalling Records fro...

Page 4: ...the Clock 36 15 Initialising the WP 82Y 37 16 Instrument firmware version number 37 17 Troubleshooting 38 17 1 General Errors 38 17 2 Dissolved Oxygen Troubleshooting 39 17 3 Temperature Troubleshooting 39 18 Appendices Dissolved Oxygen Sensor Theory 40 18 1 Operating Principle 40 18 2 Sensor Storage 41 18 3 Notes On Units Of Dissolved Oxygen 42 18 4 Equilibrium Conditions 43 18 5 Velocity Past Th...

Page 5: ...Page 5 Introduction 1 1 WP 82Y Display and Controls ...

Page 6: ...enu system on the WP 82Y Press to access the user friendly menu system which makes the WP 82Y easy to operate and The and keys are used for calibrating temperature readout section 5 1 setting the clock section 14 1 setting the automatic logging period section 10 and displaying GLP information section 8 1 The key is also used to initialise the WP 82Y at turn on See section 15 Switches the WP 82Y on...

Page 7: ... 1 3 or 5m cable 4 Membrane kit for oxygen sensor 123300 5 Battery charger 130037 6 Manual Options that may have been ordered with your WP 82Y 1 Extended cable 130040 2 RS232 Serial Interface Cable 130041 3 Communication software for Windows 95 and later 130086 4 USB to Serial Adaptor requires 130041 also 130087 5 Hard Carry Case 130059 6 Battery charger lead for 12V cigarette lighter socket 13004...

Page 8: ... Gaseous 45 to 100 Gaseous Resolution 0 1 1 Gaseous Accuracy 0 1 Gaseous Ranges subject to sensor performance Temperature Range 10 0 to 120 0 o C Sensor limit 45 o C Resolution 0 1 o C Accuracy 0 2 o C Salinity Correction User set from 0 to 50 0 ppK NaCl Barometric Pressure Correction User set from 500 to 1100 HPa Altitude Correction User set from 0 to 5000m General Specifications Temperature Comp...

Page 9: ...utes seconds Year is recorded in memory and transmitted to the RS232 port but is not displayed Battery Saver On Auto switch off after 5 minutes Off Continuous use Bar Graph display of battery charge level Readout of battery voltage available for troubleshooting Good Laboratory Practices Date Time and Value of last Dissolved Oxygen and Temperature calibration are stored along with Altitude or Press...

Page 10: ... Cal F1 Oxy F2 Temp F3 Sal if ppM Sal mode selected F4 Altitude if one or the other is selected or F4 Pressure F2 Notepad F1 Recall F2 Erase F3 Print F4 Prog F1 Min F2 Sec F3 Hr Set Period F3 Mode F1 ppM Sal F2ppM F3 Sat F4 Gas F4 Setup F1 Batt F1 OFF Disable Battery Saver F2 ON Enable Battery Saver F2 Clock F3 GLP F1 Recall F3 Print F4 Baud F1 300 F2 1200 F3 9600 F4 19200 ...

Page 11: ...ppM uncorrected ppM Saturation and Gaseous To select a mode 1 Select the Mode menu F3 Mode F1 ppM Sal F2 ppM F3 Sat F4 Gas 2 Press to select Salinity corrected ppM mode Press to select ppM mode with no salinity correction Press to select Saturation mode Press to select Gaseous mode ...

Page 12: ...r A 50g bottle of Sodium Sulphite powder is supplied with a new ED1 sensor for this purpose part number 123302 b Allow the reading to stabilise at or near zero This may take 2 3 minutes c Select Oxygen Calibration F1 Cal F1 Oxy d Press the key to calibrate e A will not be removed from the display after a Zero Calibration 7 Rinse the Dissolved Oxygen sensor in distilled water and blot dry 8 Air Cal...

Page 13: ... at least monthly In applications where there is a low level of dissolved oxygen a zero calibration may have to be done weekly 5 An air calibration should be performed at least weekly Of course more frequent calibration will result in greater confidence in results 6 The salinity correction value is ignored during zero and air calibration There is therefore no need to re set the salinity correction...

Page 14: ...mple Zero Cal OK Zero 1 0 2 If an Air calibration has been successfully performed the WP 82Y will display the following message and the span value of the sensor For example Air Cal OK Span 100 0 3 If an Air calibration has failed the WP 82Y will display the following message and the failed span value of the sensor For example Air Cal Fail Span 65 0 or Air Cal Fail Span 140 0 ...

Page 15: ...beaker 4 Select Temperature Calibration F1 Cal F2 Temp 5 The reading from the sensor is now displayed on the right of the display and the value you are going to set is shown on the left 25 0 24 0oc Set F1 Cal 6 When the reading on the right has stabilised press the or keys until the reading on the left shows the same temperature as the mercury thermometer 7 Press the key to calibrate the temperatu...

Page 16: ...not need to be recalibrated unless the sensor is replaced or the meter is initialised 5 3 Calibration Messages 1 If a temperature calibration has been successfully performed the WP 82Y will display the following message and the offset value of the sensor For example Calibrate OK Offset 1 0oc 2 If a temperature calibration has failed the WP 82Y will display the following message and the failed offs...

Page 17: ...ion 3 2 Select the Salinity correction calibration F1 Cal F3 Sal 3 The current salinity correction value is now displayed For example 36 0 ppK Sal Set F1 Save Press the and keys until the display shows the desired salinity correction value 4 Press the key to save the salinity correction value Alternatively press the key to quit and retain the current setting ...

Page 18: ...tude or Pressure mode menu is now displayed F1 Altitude F3 Pressure F4 OFF The arrow indicates the current selection 4 Press to select Altitude correction Press to select Atmospheric Pressure correction Press to switch the Altitude or Pressure correction system OFF 5 If or was selected then the WP 82Y now asks for the altitude or pressure 0 m Alt Set F1 Save or 1013 HPa Set F1 Save Press the and k...

Page 19: ... optimum accuracy the altitude or pressure should be set before calibrating or taking measurements 2 When the altitude or atmospheric pressure correction system is switched off the WP 82Y assumes sea level 0m and 1013 HPa conditions These values are satisfactory for the precision required for most Dissolved Oxygen measurements 3 If Altitude correction is switched on an A is added to the WP 82Y dis...

Page 20: ...ines 8 1 To recall GLP information on the display 1 Switch the meter on 2 Select the GLP menu F4 Setup F3 GLP 3 Select F1 Recall from the menu 4 The instrument model firmware version number and instrument serial number are displayed along with a prompt describing how to scroll through the GLP information For example WP82Y V2 0 S1234 More Back Continued over the page ...

Page 21: ...V2 0 S1234 More Back Oxy Zero 1 0 31 12 10 11 00 Oxy Span 100 0 31 12 10 11 10 Altitude 5000m 31 12 10 11 20 or Pressure 1013HPa 31 12 10 11 20 Temp Offset 1 0Oc 31 12 10 11 30 Exit Altitude OR Pressure are displayed if either one was switched on at the time of the last calibration If the Altitude or Pressure Correction system was switched off at the time of the last calibration then the GLP moves...

Page 22: ...nt to a printer or PC via the RS232 port 1 Switch the meter on 2 Ensure that the WP 82Y RS232 cable is connected to the instrument and to the printer or PC 3 Send the GLP information to the RS232 port F4 Setup F3 GLP F3 Print 4 The GLP information is sent to the RS232 port in formatted ASCII text For example WP82Y V2 0 S1234 31 12 10 12 00 Oxygen Zero 0 0 31 12 10 11 00 Oxygen Span 100 0 31 12 10 ...

Page 23: ...1234 Oxygen Temp where S1234 is the serial number The serial number is display when recalling the GLP information section 8 1 The serial number is included on the printout of GLP information section 8 3 8 5 Additional GLP Features Another GLP requirement is to record the date and time of every reading The WP 82Y does this for you when readings are recorded either with the Notepad function section ...

Page 24: ...lect the Notepad menu F2 Notepad 2 Select F1 Recall from the menu 3 Record number 1 is now displayed Salinity is displayed for readings recorded in salinity corrected ppM mode An A is displayed if Altitude correction was switched on or a P is displayed if Pressure correction was switched on when the reading was recorded For example 10 00ppM A 25 0oc 36 0ppK 1 F2 Clk or 10 00ppM P 25 0oc 36 0ppK 1 ...

Page 25: ...Charger RS232 socket of the WP 82Y The charger optional solar panel or optional car battery lead can be connected into the spare socket on the cable for long term use if required 2 Connect the other end of the RS232 cable to an RS232 Printer or to COM1 or COM2 of a PC 3 Ensure that the baud rate for the printer or PC and the WP 82Y are the same If necessary alter the baud rate of the WP 82Y see se...

Page 26: ... the period at which the WP 82Y will automatically log records 5 When the logging period has been correctly set select whether this period is in minutes or seconds Press to save the period as minutes Press to save the period as seconds Press to save the period as hours eg If the period was set to 05 followed by then the WP 82Y will automatically log a record every 5 seconds 6 The WP 82Y will ask i...

Page 27: ...his 10 00ppM 25 0oc Sending 12 00 00 9 Press to stop automatic logging Notes 1 The clock must be set before the WP 82Y will allow automatic logging to start The message Clock Not Set is displayed if the clock is not set 2 The Battery Saver function section 12 is disabled while the meter is in Automatic Data logging mode to stop the meter switching off while logging data Even when the memory is ful...

Page 28: ...ction 10 Records can be sent directly to the RS232 port rather than stored in memory during automatic data logging See section 10 for details 11 3 RS232 Configuration The WP 82Y RS232 configuration is 8 bits No Parity 1 Stop Bit XON XOFF Protocol 11 4 Communication and Statistical Software Communication between the WP 82Y and a PC can be handled with any RS232 communication software WinTPS RS232 c...

Page 29: ...ll logged records from the WP 82Y memory The data ends with the message ENDS cr Erase logged data E cr Erases all logged records from the WP 82Y memory Returns the message ERASED cr to confirm that the records have been erased Request status information S cr Returns the model name firmware version number instrument serial number and number of logged readings in memory eg WP82Y V2 0 S1234 999 cr wh...

Page 30: ...cters right justified ppK is the salinity correction value unit description TTTTTT is the Temperature Data Maximum 6 characters right justified oC is the Temperature unit description AAAAAA is the Altitude OR Pressure correction value Maximum 6 characters right justified aaa is the unit description either m for Altitude or HPa or Atmospheric Pressure dd mm yy is the date month and year data hh mm ...

Page 31: ...S1234 31 12 10 12 00 Oxygen Zero 0 0 31 12 10 11 00 Oxygen Span 100 0 31 12 10 11 10 Oxygen Altitude 5000m 31 12 10 11 20 Oxygen Pressure 1013HPa 31 12 10 11 20 Temperature Offset 1 0oC 31 12 10 11 30 ENDS NOTE Either Altitude OR Pressure is sent depending upon which was selected the last time the instrument was calibrated If the Altitude or Pressure Correction was switched off at the time of the ...

Page 32: ...ile Open 2 In the Files of type pull down box choose Text Files prn txt csv 3 Navigate to the folder where your data file is stored and double click it to start the Text Import Wizard Note The default data folder for the WinTPS software is C My Documents WinTPS 4 In step 1 of the Text Import Wizard select Fixed width as per the sample screen below then press Next Continued over the page ...

Page 33: ...ss Next after the column breaks have been inserted 6 Simply press Finish at step 3 of the Text Import Wizard TPS recommends that the data format for each column be set once the data is in spreadsheet format For help on formatting the data columns charting graphing or other operations please consult the Microsoft Excel help file Alternatively please contact TPS and we will try to provide further as...

Page 34: ...ble the battery saver function for continuous use Press to enable the battery saver function The meter will switch itself off if no key has been pressed for five minutes Press to quit the battery saver menu and retain the current setting Notes 1 For troubleshooting purposes the battery volts can also be displayed in the battery saver menu Press to display battery volts 2 The symbol flashes when th...

Page 35: ...recharge the battery 1 Plug the battery charger solar panel or car cigarette lighter adaptor into the Charger RS232 socket DO NOT plug into the Sensor socket as this will damage the WP 82Y 2 Charge for approximately 8 hours for full capacity The WP 82Y has special circuitry to prevent overcharging so the charger can be used continuously 3 To ensure optimum battery life and capacity the WP 82Y shou...

Page 36: ... the date and time are correct Press to save the settings If any changes are needed press the key to move left to the desired position Press to quit without resetting the clock Notes 1 The WP 82Y does not test for a valid day of the month when setting the clock eg attempting to enter 31 02 10 is not corrected 2 The WP 82Y does test for leap years 14 2 Displaying or Hiding the Clock The date and ti...

Page 37: ...RS232 serial port option is fitted 4 The meter then displays Dissolved Oxygen and Temperature Note that the decimal points have been replaced with a to indicate that the unit requires re calibration 5 When the WP 82Y is initialised a The manual salinity correction value is re set 36 0ppK See section 6 if you wish to change this value b The Altitude or Pressure correction system is switched off and...

Page 38: ...ch itself off when the battery falls below 5 00 volts Meter displays the word OFF and switches off Battery is below 5 00 volts Recharge the battery If this fails check the charger If charger OK replace the battery Meter will not turn on 1 Battery is exhausted 2 Faulty Instrument Recharge the battery If this fails check the charger If charger OK replace the battery Return to factory for repair Batt...

Page 39: ...e wire Sensor has been exposed to sulphides or other chemical poisoning Return to the TPS factory for cleaning and service Tarnished or scratched Gold cathode Sensor has been chemically poisoned or physically damaged Return to the TPS factory for cleaning and service Meter reads OVR ppM or OVR 1 Sensor has not yet polarised 2 Sensor is faulty Wait for 2 3 minutes for the sensor to polarise after t...

Page 40: ...is case the plastic is 0 025mm intermediate density polyethylene sheet PTFE Teflon can be supplied for special applications It must be realised that using membranes of very different thicknesses will result in an error in the temperature compensation that is applied in the instrument for the membrane permeability This coefficient here 4 2 o C at 25o C is for this thickness polyethylene A polarizin...

Page 41: ...hind the membrane from drying out To achieve this the sensor can be stored with the tip in water For long term storage of the YSI sensor for several weeks or more remove the membrane and empty the electrolyte Re attach the sensor guard When the sensor is stored in this way refill the sensor and replace the membrane before use ...

Page 42: ... example as ocean water is only 3 6 saline It does however stress the importance of correct interpretation of the salinity etc The Clark Sensor measures the partial pressure of oxygen diffusing through a membrane The current is a linear measure of this partial pressure assuming liquid flow conditions are met With air at sea level the 20 9 oxygen exerts about 15 5 cm mercury standard pressure Water...

Page 43: ...ded by manual entry of the salinity of the sample This must first be measured with a good quality salinity meter such as a TPS model Aqua C or a WP 84 18 4 Equilibrium Conditions Whilst Saline Water has a lower ppM than does Fresh Water it does not mean it necessarily has less oxygen biologically available Both have 100 Saturation presuming no Chemical Oxygen Demand C O D Biological Oxygen Demand ...

Page 44: ...using current once the flow is sufficiently high Tests with this sensor have shown that flow rates above 0 2 litres minute past the membrane give results indistinguishable from those with appreciably higher flow rates 5 litres minute Fluctuations in readings due to air bubbles passing through the membrane are however a different matter With the type of sensor to be used with this instrument very l...

Page 45: ...ipment incorrect calibration incorrect operation or from interpretation of information derived from the equipment Specifications are subject to change without notice This warranty becomes invalid if modifications or repairs are carried out on this unit by unauthorised persons There are no express or implied warranties which extend beyond the face hereof Procedure for Service Please read service de...

Page 46: ...ur equipment will be repaired and returned to you by express air freight where possible For instruments beyond warranty period a repair cost will be calculated from parts and labour costs and emailed to you If you decline to have the equipment repaired the complete instrument will be returned to you freight paid not serviced TPS Pty Ltd has only one service location which is located at our factory...

Page 47: ...seal 1 It stops the internal fluid leaking out and causing air bubbles to form behind the membrane 2 Most important It resists contamination from outside getting INTO the sensor Substances such as Sulphides will poison the Silver anode This is triangular shaped piece behind the sensor membrane How to fit the membrane correctly Section d of the YSI SENSOR PREPARATION of the enclosed instruction lea...

Page 48: ...s leaked and crystallized If these are visible re fit a new membrane and re test What will happen if the membrane is not fitted correctly The Silver anode will usually turn black when it is poisoned When the anode is poisoned the whole sensor is usually rendered unserviceable TPS may be able to re furbish the sensor but this is not certain 1 Incorrect fitting of the membrane causes poisoning of th...

Reviews:

No comments