XI. OPTIONAL DATA LOGGER
1. Description:
When enabled in the analyzer software, the data logger records the measured residual,
sample water temperature, turbidity, and pH value (if being measured) at a selectable frequency.
This data is recorded on the Micro SDHC memory card and can be retrieved using any text-reading
program. The Micro SDHC memory card is installed in the slot on the MB220 board as indicated on
Figure 11 of this manual. To use the data logger the controller must be provided with the MJ500 Real
Time Clock board (which mounts directly on the MB220 board as shown on Figure 11).
2. Operation:
To enable, enter the confi guration menu on the residual analyzer control software and
select the option “DL”. The fi rst menu option that appears will be the On/Off menu. The menus which
follow allow for adjustment of the data logger frequency and for changes to the clock (date and time).
See fi gure 7.
a.
Frequency
: The frequency is the time interval between data recordings. The frequency is
adjustable in seconds, with a minimum setting of 5 seconds.
b.
Data Logger Clock
: The clock is factory-set before shipment. However, because the clock is set
on Eastern Standard time it may be necessary to change the date and time upon start-up.
3. Stored Data Files:
The data will be written to text fi les on the Micro SDHC memory card. The
formatting and handling of these fi les is as described below:
a.
File Format:
The following is an example data fi le to illustrate the format used. As you can see,
there is a three line header for each fi le. The fourth and fi fth lines are headers for the data. You
will see that each header and data entry is delimited by a comma.
b.
File Name:
Each data fi le will be named according to the date on which it was created. For
example if created on May 24, 2016, the fi le name would be May24_16.txt
i. If the Micro SDHC memory card already has a fi le started earlier on the same day, then data
will be written onto the existing fi le.
ii. The text fi les are limited to 5 MB. Once this limit has been reached, a new fi le will
automatically be created to allow data to continue to be written.
c.
Importing data into Excel:
The data fi les can be imported into Excel as follows:
NOTE: This assumes use of Excel 2007 version.
i. Select the “Data” tab.
ii. Among the “Get External Data” tabs on the toolbar, select “From Text”
iii. A pop up window will appear allowing you to search for and select the data fi le that you wish
to import. After you have selected the fi le, click on “IMPORT”.
iv. Another pop up window “Text Import Wizard – Step 1 of 3” will then appear.
1.
Here under “Original Data Type” you must select “Delimited”.
2.
Lower down you are asked to select “Start import at row:___”. In order to eliminate the 3
line fi le header, you can select “4” here to start the data import on row 4 of the fi le.
3.
Then click “Next”.
v. On the next pop up window “Text Import Wizard – Step 2 of 3” you need to select the type of
delimiter being used in the data fi le. The data entries in these fi les are delimited by commas
and so you must select “Comma”. After selecting Comma and only Comma, then click “Next”.
vi. On the next pop up window “Text Import Wizard – Step 3 of 3” you can accept the “Column
data format” setting of “General” and then click “Finish”.
32
Содержание 210 Series
Страница 20: ...20 ...