TPS 90-FL Скачать руководство пользователя страница 48 | Manualshive

Страница: 48 / 68

TPS 90-FL Скачать руководство пользователя страница 48

47

10.8 Importing Data into Microsoft Excel

The following procedure details the method for importing a

90-FL

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 >”.

Note that the data column headers in row appear only when the data is downloaded using the
WinTPS software.

Continued over the page…

«
...
46
47
48
49
50
...
»

Содержание 90-FL

Страница 1: ...oduction has a diagram and explanation of the display and controls of the 90 FL It also contains a full listing of all of the items that you should have received with unit Please take the time to read...

Страница 2: ...nductivity sensor k factor 16 4 4 Conductivity Calibration 17 4 5 Conductivity Calibration Notes 18 4 6 Conductivity Calibration Messages 18 5 TDS Mode 19 5 1 Selecting TDS Mode 19 5 2 Setting the TDS...

Страница 3: ...nd Statistical Software 43 10 5 Commands 43 10 6 Data Format 45 10 7 GLP Data Format 46 10 8 Importing Data into Microsoft Excel 47 11 Setting the Clock 49 12 Initialising the 90 FL 50 13 Instrument f...

Страница 4: ...3 1 Introduction 1 1 90 FL Display and Controls 1 2 90 FL Rear Panel Connectors...

Страница 5: ...ode See section 9 3 3 Press to obtain context sensitive help messages This function is disabled within menus 1 4 Numeric Keys Used to enter values during set up and calibration A negative sign and dec...

Страница 6: ...stirring DO2 sensor for BOD bottles 123213 8 k 10 ATC Temp Conductivity Sensor 5m 122218 9 k 1 ATC Temp Conductivity Sensor 5m 122196 10 Submersible pH Sensor Gel Filled 5m 111224 11 Intermediate Junc...

Страница 7: ...0 to 2 000 S cm 0 to 20 00 S cm 0 to 200 0 S cm 0 to 2000 S cm 0 001 S cm 0 01 S cm 0 1 S cm 1 S cm 0 5 of full scale of selected range at 25 O C k 1 0 Sensor 0 to 20 00 S cm 0 to 200 0 S cm 0 to 200...

Страница 8: ...d full scales are subject to sensor performance Sensor Type Ryton plastic body with two platinised platinum plates with in built ATC Temperature Compensation Automatic 0 to 100 O C standard Conductivi...

Страница 9: ...our format Sampling Period and Duration One reading every 1 to 300 seconds for a duration of 1 to 720 minutes or continuous RS232 Port 300 9600 19200 baud 8 bits no parity 1 stop bit XON XOFF Protocol...

Страница 10: ...se F1 Erase All F2 Erase Last F3 Print Log F4 Start or F4 Stop F5 Program F1 Rate per Day F2 Time of Day F3 Sampling Period and Duration F4 Setup F1 Standards F1 Conductivity F2 TDS F3 pH Buffers F2 G...

Страница 11: ...n section 3 1 4 Ensure that the Temperature readout has been calibrated see section 7 1 or manually set see section 7 4 when calibrating either of the ppM modes 5 Rinse the Dissolved Oxygen sensor in...

Страница 12: ...brate F1 Oxygen When the reading is above approximately 25 Saturation 2 ppM or 5 Gaseous the 90 FL will display the AIR calibration screen 101 0 Sat 25 0o c Oxygen AIR Calibration Press Enter Press to...

Страница 13: ...ion must be stirred at a moderate rate Allow the reading to stabilise After a zero calibration this may take up to 5 minutes 3 Select Oxygen Calibration F1 Calibrate F1 Oxygen When the reading is abov...

Страница 14: ...message and the Zero value of the sensor 0 0 Sat 25 0o c Calibration OK Zero 0 5 2 If a Zero calibration has failed the 90 FL will display the following message and the failed Zero value of the senso...

Страница 15: ...Dissolved Oxygen sensor into the in line socket that is provided on the stirrer cable Please refer to the diagram below 3 5 3 Starting and Stopping the Dissolved Oxygen stirrer 1 Ensure that the Disso...

Страница 16: ...tandards F1 Conductivity The following screen is now displayed Conductivity Standard 2760 uS Range 20uS cm to 2000mS cm 2 Type in the value of the Conductivity standard that is to be used for calibrat...

Страница 17: ...layed Select nominal k factor F1 k 1 F2 k 1 The arrow indicates the current selection Press if a k 0 1 sensor is being used Press if a k 1 sensor is being used Press to quit without changing the curre...

Страница 18: ...o press to calibrate or to quit The will not be removed after a zero calibration Standard Calibration 7 Place the Conductivity sensor into a sample of Conductivity standard Ensure that it is immersed...

Страница 19: ...o calibrate Ensure that the standard value displayed corresponds to the standard that you are using Alter the Standards set up if necessary see section 4 2 6 Calibration settings for k 0 1 k 1 and k 1...

Страница 20: ...2 TDS The following screen is now displayed TDS Standard 36 00ppK Range 20 ppM to 500 ppK 2 Type in the value of the TDS standard that is to be used for calibration including the decimal point Use the...

Страница 21: ...Select nominal k factor F1 k 1 F2 k 1 The arrow indicates the current selection Press if a k 0 1 sensor is being used Press if a k 1 sensor is being used Press to quit without changing the current se...

Страница 22: ...ss to calibrate or to quit The will not be removed after a zero calibration Standard Calibration 7 Place the TDS sensor into a sample of TDS standard Ensure that it is immersed correctly as per the di...

Страница 23: ...o calibrate Ensure that the standard value displayed corresponds to the standard that you are using Alter the Standards set up if necessary see section 5 2 6 Calibration settings for k 0 1 k 1 and k 1...

Страница 24: ...rrow indicates the current selection Press to select pH4 00 and pH9 22 as the Secondary Buffers Press to select pH4 00 and pH10 06 as the Secondary Buffers Press to quit without changing the current s...

Страница 25: ...sample of primary buffer pH6 88 or 7 00 so that the bulb and reference junction are both covered as per the diagram below DO NOT place the electrodes directly into the buffer bottle 6 Select pH calibr...

Страница 26: ...the displayed buffer Otherwise enter an alternative buffer using the Numeric Keypad and then press 10 The 90 FL is now pH calibrated and is ready for use in this mode Discard the used samples of buffe...

Страница 27: ...ration 3 If a 2 point calibration has been successfully performed the 90 FL will display the following message and the asymmetry and slope of the electrode Slope Asymmetry Calibration Successful 0 10p...

Страница 28: ...Keypad to enter the same temperature as measured by the mercury thermometer 6 Press the key to calibrate the temperature readout Alternatively press the key to abort temperature calibration The 90 FL...

Страница 29: ...has been successfully performed the 90 FL will display the following message and the offset value of the sensor The bottom line appears after 3 seconds 1 Point Calibration OK Offset 0 1o c Press Enter...

Страница 30: ...lect Temperature Calibration F1 Calibrate F2 Temperature 4 The current temperature setting is now displayed For example Enter Manual Temperature 25 0 O C Menu Quits 5 Enter the temperature of the samp...

Страница 31: ...m after the model name is displayed when the Dissolved Oxygen stirrer is enabled 5 Press the key to sequentially scroll through the GLP information for all parameters Press the key to scroll back to p...

Страница 32: ...Next pH Asymmetry 0 10pH 31 12 00 13 30 pH Calibrated F2 Back F4 Next pH Slope 99 0 31 12 00 13 40 pH Calibrated F2 Back F4 Next Temperature Offset 1 0O c 31 12 00 14 30 Temp Probe Calibrated F2 Back...

Страница 33: ...r optional solar panel may be connected to the in line socket on the RS232 cable if required 3 Connect the other end of the RS232 cable to an RS232 Printer or to the COM1 or COM2 ports of a PC 4 Send...

Страница 34: ...ved Oxygen stirrer is enabled 2 The serial number is displayed when recalling the GLP information section 8 1 3 The serial number is included on the print out of GLP information section 8 3 4 The GLP...

Страница 35: ...ates the current selection 2 Press to set A as Pond number with no extra B data input Press to set A as Pond number with extra B data input Press to set A as data input with no extra B data input Pres...

Страница 36: ...normal display mode The display should now look like this 10 00ppM 2 76mS 7 00pH 25 0o c Log 1 Pond 1 31 12 12 00 00 2 Use the numeric keypad to key in the Pond number then press to record all parame...

Страница 37: ...in normal display mode The display should now look like this 10 00ppM 2 76mS 7 00pH 25 0o c Log 1 Enter 31 12 12 00 00 2 Press to record all parameters plus Date and Time into the Logger memory This...

Страница 38: ...venly spaced throughout each 24 hour period Unit is dormant between readings and wakes up when a reading is due Dissolved Oxygen stirrer is switched on for 40 seconds before each reading is logged if...

Страница 39: ...at time automatic logging is started and stopped For example if the 90 FL is programmed to log 4 readings per day they will be logged at 24 00 6 00 12 00 and 18 00 o clock Starting and Stopping Rate p...

Страница 40: ...d stopped as required Notes 1 For 12 00 o clock midnight enter the time as 24 00 2 The times of the day do not need to be entered in chronological order The 90 FL will sort them after pressing Startin...

Страница 41: ...o memory from 1 to 720 minutes Alternatively enter 0 to log continuously until logging is stopped by the user or the memory is full Press to save the new duration Press to quit and retain the previous...

Страница 42: ...ng 10 00ppM 2 76mS 7 00pH 25 0o c Log 1 F2 F4 31 12 12 00 00 The following example shows the display when A and B were both set to data during logging 10 00ppM 2 76mS 7 00pH 25 0o c Log 1 A 1234 B 123...

Страница 43: ...it without erasing any records 9 6 Printing Records from the Logger to the RS232 Port 1 Connect one end of the RS232 cable to the Charger socket of the 90 FL 2 Connect the other end of the RS232 cable...

Страница 44: ...tical Software Communication between the 90 FL and a PC can be handled with any RS232 communication software A TPS communication software package for Windows is optionally available part number 130086...

Страница 45: ...F cr Stops automatic datalogging when the 90 FL is set up for Rate per Day or Time of Day automatic datalogging see sections 9 3 1 and 9 3 2 Power ON Any 10 characters Switches the 90 FL ON A specifi...

Страница 46: ...M S for Saturation readout G for Gaseous readout CCCCCCC is Conductivity or TDS data 7 characters right justified uuu is the Conductivity TDS units description which can be either of the following uS...

Страница 47: ...with a carriage return 3 When the data is sent by the 90 FL using the Print function section 9 6 or the Instant Send function section 10 2 the data ends with a carriage return and a line feed 10 7 GLP...

Страница 48: ...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 Win...

Страница 49: ...ed into a single column to ensure that the X axis is correctly formatted if the data is to be charted later Press Next after all the column breaks have been inserted 6 Simply press Finish at step 3 of...

Страница 50: ...eypad to enter the current date in dd mm yyyy format then press Alternatively press to quit and retain the current setting Notes 1 Press the key to make any corrections as required 2 The 90 FL tests t...

Страница 51: ...d provide an additional warning that these will be erased For example Logger contains Data 1360 readings will be Erased Continue F1 Yes F2 No Press to initialise the 90 FL and reset all calibration da...

Страница 52: ...current selection 3 Press to disable the battery saver function for continuous use Press to set the battery saver function to 5 minutes The meter will switch itself off if no key has been pressed for...

Страница 53: ...icrowave oven Place approximately 100mL water in a microwave proof cup into the microwave oven This will absorb some of the microwave energy and stop the Silica gel balls bursting Turn the microwave o...

Страница 54: ...0 volts Data obtained while the is flashing may be unreliable Do not take readings or calibrate while the is flashing Meter displays the word OFF and switches off Battery is below 5 10 volts Recharge...

Страница 55: ...ry for repair or replacement Blackened Silver anode Electrode has been exposed to sulphides or other chemical poisoning Remove pressure compensation diaphragm and membrane then soak in 5 Ammonia solut...

Страница 56: ...tion Replace standard solution Return sensor to factory for repair or replacement Return to factory for repair Standard calibration fails and k factor is greater than 25 below the nominal value 1 Stan...

Страница 57: ...instructions supplied with the electrode If unsuccessful replace electrode Dry in a warm place Replace buffers Unstable readings 1 Reference Electrolyte chamber needs to be refilled 2 Reference junct...

Страница 58: ...place sensor Displays manual temperature setting eg 25 0o cM when Conductivity or Temperature sensor plugged in 1 Faulty instrument socket 2 Faulty Conductivity or Temperature sensor whichever is bein...

Страница 59: ...ane permeability This coefficient is 4 2 o C at 25o C for this thickness membrane A polarising voltage of about 800 millivolts is applied between the two electrodes The gold electrode is placed close...

Страница 60: ...xygen exerts about 15 5 cm of Mercury pressure Water in equilibrium with air and with no oxygen demand C O D B O D etc is saturated and has this dissolved oxygen partial pressure If we define 100 Satu...

Страница 61: ...quivalent Fresh Water 17 1 7 Velocity Past The Membrane Workers have shown that the relationship between the diffusion current oxygen current and the external velocity of the liquid is expotential Som...

Страница 62: ...e 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 Cleaning of Conductivity Sensors Platinised p...

Страница 63: ...rse the electrode in platinising solution at least to the vent hole in the body Platinising solution is available from TPS part no 122300 Alternatively platinising solution can be prepared by dissolvi...

Страница 64: ...rence junction A saturated solution of KCl is used to make contact with the sample It is vital that the KCl solution has an adequate flow rate in order to obtain stable accurate pH measurements 17 3 1...

Страница 65: ...oduce slightly less than this The output of a pH electrode is expressed as a percentage of an ideal electrode For example an ideal electrode that produces 59 16mV pH unit has 100 Slope An electrode th...

Страница 66: ...of a pH electrode If pH readings are inaccurate or unstable the reference junction of the electrode may be blocked The following test can be performed to determine if the reference junction of a pH el...

Страница 67: ...pproximately pH7 00 depending on the current calibration settings 5 If the 90 FL is operating correctly the reading should be totally stable with the wire firmly in place If not the meter requires ser...

Страница 68: ...eed of repair please re read the manual Sometimes instruments are received for repair in perfect working order This can occur where batteries simply require replacement or re charging or where the ele...

Отзывы:

Нет отзывов