manualshive.com logo in svg

TPS WP Series, User Manual, Page: 29 / 41

Share
Download
TPS WP Series User Manual Download Page 29

10.8

Importing Data into Microsoft Excel

The following procedure details the method for importing a

WP-84

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;
*.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 28

Summary of Contents for WP Series

Page 1: ...QUALITY SERVICE VALUE tps com au WP 84 User Manual WP Series Waterproof Portables Data logging Multiple Power Options USB Download User Friendly Waterproof GLP Compliant ...

Page 2: ...the handbook is clearly listed Sub sections have also been included to enable you to find the information you need at a glance 1 Introduction The introduction has a diagram and explanation of the display and controls of the WP 84 It also contains a full listing of all of the items that you should have received with your WP 84 Please take the time to read this section as it explains some of items t...

Page 3: ...Page 2 Model WP 84 Conductivity TDS Salinity Temp Meter Version 4 1 Date 16 06 2021 TPS Pty Ltd Phone 07 3205 8027 Email sales tps com au Web www tps com au ...

Page 4: ...ng the ATC Coefficient of a Solution 18 7 Good Laboratory Practices GLP 19 7 1 To recall GLP information on the display 19 7 2 Failed Calibration 19 7 3 Printing GLP Information to the RS232 Port 20 7 4 Instrument Serial Number 20 7 5 Additional GLP Features 20 8 Notepad Function 21 8 1 Recording Readings into the Notepad 21 8 2 Recalling Records from the Notepad 21 8 3 Erasing Records from the No...

Page 5: ...e Clock 32 14 Selecting k 0 1 or k 10 Sensors 33 15 Initialising the WP 84 34 16 Instrument firmware version number 34 17 Troubleshooting 35 17 1 General Errors 35 17 2 Conductivity TDS Salinity Troubleshooting 36 17 3 Temperature Troubleshooting 38 18 Appendices 39 18 1 Care Cleaning and Maintenance of Conductivity Sensors 39 18 2 Replatinising Conductivity Sensors 40 Page 4 ...

Page 6: ...1 Introduction 1 1 WP 84 Display and Controls Page 5 ...

Page 7: ...on the WP 84 Press to access the user friendly menu system which makes the WP 84 a breeze to operate and The and k eys are used when calibrating temperature readout section 5 setting the clock section 13 1 setting the automatic logging period section 9 and displaying GLP information section 7 1 The key is also used to initialise the WP 84 at turn on See section 15 Switches the WP 84 on and off Dis...

Page 8: ...cable 3 Conductivity Standard 200mL 2 76 mS cm 122306 58 0 mS cm 122315 150 0 uS cm 122320 4 Battery charger 130037 5 Manual Options that may have been ordered with your WP 84 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 1...

Page 9: ...M k 1 0 Sensor 0 ppM to 10 00 ppK k 10 Sensor 0 ppM to 100 0 ppK Resolution 0 1 of selected range Accuracy 0 5 of full scale of selected range at 25 O C Salinity k 0 1 Sensor 0 to 0 10 0 PSU to 1 0 PSU k 1 0 Sensor 0 to 1 19 0 PSU to 11 9 PSU k 10 Sensor 0 to 8 00 0 PSU to 80 0 PSU Resolution 0 01 0 1 PSU Accuracy 0 5 of full scale of selected range at 25 O C Temperature Range 10 0 to 120 0 o C Se...

Page 10: ...top bit XON XOFF Protocol Clock Calendar clock displays date month hours minutes 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 Conducti...

Page 11: ...ference for the WP 84 menu functions F1 Cal F1 Cond F3 Temp F4 ATC F2 Notepad F1 Recall F2 Erase F3 Print F4 Prog F1 Min F2 Sec F3 Hr Set Period F3 Mode F1 Cond F1 F2 TDS F2 PSU F3 Sal F4 Setup F1 Batt F1 OFF Battery Saver F2 ON Battery Saver F2 Clock F3 GLP F1 Recall F3 Print F4 Baud F1 300 F2 1200 F3 9600 F4 19200 Page 10 ...

Page 12: ...de 1 Press to select the Mode Menu F1 Cond F2 TDS F3 Sal 2 Press to select Conductivity mode Press to select TDS mode You will now be asked to enter the TDS Factor 0 65 TDS factor Set F1 Save Press to select Salinity mode menu Select units F1 F2 PSU Press to select units Press to select PSU units Press to quit and retain the current selection Page 11 ...

Page 13: ...the Conductivity sensor into the Conductivity socket If a k 0 1 or k 10 sensor is being used ensure that the WP 84 is set to the correct k factor before using the instrument see section 14 2 Switch the meter on 3 Rinse the Conductivity sensor in distilled water Shake off as much water as possible Blot the outside of the sensor dry DO NOT BLOT THE SENSOR WIRES 4 Zero Calibration Let the sensor dry ...

Page 14: ...died sensors immerse the sensor at least to the vent hole in the glass body DO NOT place the sensor directly into the bottle of standard Discard the used sample of standard after use It is advisable to use a narrow sample vessel to minimise the use of standard solution 7 Select Conductivity Calibration F1 Cal F1 Cond 8 When the reading has stabilised press the key to calibrate The will now be repl...

Page 15: ...section 8 5 The WP 84 displays the value of the standard to which it will attempt to calibrate Ensure that the standard value displayed corresponds to the standard that you are using 6 If the WP 84 does not recognise the standard it will display the message NOT STD during calibration Calibration will fail if this message is displayed 4 3 Calibration Messages 1 If a Zero calibration has been succes...

Page 16: ...reading on the right has stabilised press the and keys until the reading on the left shows the same temperature as the mercury thermometer 6 Press the key to calibrate the temperature readout Alternatively press to quit and retain the current calibration settings The will now be replaced by a decimal point if calibration was successful Alternatively press the key to abort temperature calibration 5...

Page 17: ...perature of the solution It is therefore impossible to set a single ATC Coefficient in the factor which will be correct for all solutions which the WP 84 will be used to test The ATC Coefficient is set to 2 0 O C in the factory This figure is suitable for environmental waters whose predominant dissolved salt is Sodium Chloride at moderate concentrations being measured between approximately 15 and ...

Page 18: ...Note The ATC Coefficient is set to 2 0 O C during calibration and returns to the user setting when finished Page 17 ...

Page 19: ... become stable 5 Apply the following formula where C1 and T1 are the first readings taken and C2 and T2 are the second readings taken 6 Enter the result that is obtained as the ATC Coefficient of the solution as per the procedure detailed in section 6 1 Note To assist in calculating the ATC Slope the following information can be entered into a spreadsheet This example has been specifically written...

Page 20: ... the GLP information For example WP84 V4 0 S1234 More Back 4 Press the key to sequentially scroll through the GLP information for all parameters Press the key to scroll back to previous data The sequence of information displayed is shown over the page Press to abort at any time GLP display sequence WP84 V4 0 S1234 More Back Cond Zero 0 00uS 31 12 10 12 00 k 1 00 2 76mS 31 12 10 12 10 Temp Offset 1...

Page 21: ...32 port in formatted ASCII text For example 7 4 Instrument Serial Number In case the serial number that is fitted to the rear of the WP 84 is removed or becomes illegible it is also available on the WP 84 display The serial number is displayed at turn on for example WP84 V4 0 S1234 Con TDS Sal Temp where S1234 is the serial number The serial number is displayed when recalling the GLP information s...

Page 22: ...onto the WP 84 display 1 Select the Notepad menu F2 Notepad 2 Select F1 Recall from the menu 3 Record number 1 is now displayed for example 2 76mS 25 0o c 1 F2 Clock 4 Press to alternatively display the date and time or the data for this record Press to move forward through the records Press to move backward through the records Press and hold the or keys to roll rapidly through the readings 8 3 Er...

Page 23: ...95 98 ME are shipped with Hyper Terminal which is suitable for this purpose 3 Ensure that the baud rate for the printer or PC and the WP 84 are the same If necessary alter the baud rate of the WP 84 see section 10 1 The WP 84 uses XON XOFF protocol Ensure that the printer is set accordingly 4 Select the Notepad menu F2 Notepad 5 Select F3 Print from the menu Printing starts as soon as is pressed T...

Page 24: ...riod as seconds Press to save the period as hours For example if the period was set to 05 followed by then the WP 84 will automatically log a record every 5 seconds 5 The WP 84 will ask if the records are to be logged into the Notepad or sent directly to the RS232 port Press to log records into the Notepad maximum of 3600 readings Press to send records directly to the RS232 port 6 The automatic lo...

Page 25: ...ock must be set before the WP 84 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 11 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 full and the meter stops logging the Battery Saver function is still disabled This allows...

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

Page 27: ...ation S cr Returns the model name firmware version number instrument serial number and number of logged readings in memory eg WP84 V4 0 S1234 9999 cr where are spaces Note that the number of logged readings is right justified Request GLP information G cr Returns all calibration GLP information plus the instrument model and current date see section 10 6 for data format and hand shaking 10 6 Data Fo...

Page 28: ... data Notes When requested by a PC with the D or R commands section 10 5 each line of data is terminated with a carriage return When the data is sent by the WP 84 using the Print function section 8 4 or Send function section 10 2 each line of data ends with a carriage return and a line feed 10 7 GLP Data Format GLP information is returned as 6 lines terminated by a carriage return The computer mus...

Page 29: ...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 28 ...

Page 30: ...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 assistance...

Page 31: ...ction 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 the battery volts drops bel...

Page 32: ...e 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 84 2 Charge for approximately 8 hours for full capacity The WP 84 has special circuitry to prevent overcharging so the charger can be used continuously 3 To ensure optimum battery life and capacity the WP 84 should only be...

Page 33: ...ct 7 Press to move the cursor to the minutes Press the and keys until the minutes are correct 8 Check that 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 84 does not test for a valid day of the month when setting the clock eg attempting to enter 31 02 10 i...

Page 34: ...elect a k 0 1 sensor Press to select a k 10 sensor Press to quit buffer selection and retain the current setting Notes 1 The manual k factor selection is kept in memory when the meter is switched off even if the battery is removed 2 The manual k factor selection is reset to k 10 during initialisation 3 The WP 84 will always automatically recognise a k 1 0 sensor regardless of the manual k factor s...

Page 35: ...TDS Sal Temp The s after WP 84 is shown when the RS232 serial port option is fitted 4 The meter then displays Conductivity and Temperature Note that the decimal points have been replaced with a to indicate that the unit requires re calibration Note When the WP 84 is initialised the manual k factor selection is re set to k 10 See section 14 if you wish to select a k 0 1 sensor 16 Instrument firmwar...

Page 36: ... 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 1 Faulty Instrument Recharge the battery If this fails check the charger If charger OK replace the battery Return to factory for repair Battery does not ...

Page 37: ... sensor 1 Sensor is not immersed deeply enough 2 Sensor may have a build up of dirt or oily material on sensor wires 3 Platinum black coating has worn off 4 Standard solution is inaccurate 5 Sensor is faulty 6 Faulty instrument 7 k factor incorrectly set if using k 0 1 or k 10 sensor Immerse sensor at least to the vent hole in the white plastic cover Clean sensor as per the instructions detailed i...

Page 38: ...ay have a build up of dirt or oily material on sensor wires 2 Platinum black coating has worn off Clean sensor as per the instructions detailed in section 18 1 Sensor requires replatinisation Return to the factory or see details in section 18 2 Readings drift 1 Sensor may have a build up of dirt or oily material on sensor wires Clean sensor as per the instructions detailed in section 18 1 Readings...

Page 39: ...r 3 Faulty instrument Check the connector and replace if necessary Fit new sensor Return to factory for repair Page 38 17 3 Temperature Troubleshooting Symptom Possible Causes Remedy Displays OVRo C when sensor is 1 Faulty sensor 2 Faulty instrument Fit new sensor Return to factory for repair ...

Page 40: ... well with distilled water Conductivity sensors can be stored dry Ensure that the sensor is stored in a covered container to avoid dust and dirt build up 21 1 2 Cleaning of Conductivity of Sensors Platinised platinum Conductivity sensors can only be cleaned by rinsing in a suitable solvent DO NOT wipe the sensor wires as this will remove the platinum black layer 1 Rinsing in distilled water will r...

Page 41: ...well in distilled water 3 Immerse the sensor in platinising solution at least to the vent hole in the white plastic cover Platinising solution is available from TPS part no 122300 Alternatively platinising solution can be prepared by dissolving 1g of Hydrogen Chloroplatinate H2PtCl16 in 30mL of distilled water and including about 0 01g of Lead Acetate CH3COO 2Pb and a drop or two of concentrated H...

Reviews:

No comments