Cole Parmer 16 Series, Руководство по эксплуатации

Страница: 26 / 41

26
Collecting Data
The RS-232 output updates to the screen many times per second. Very short-term events can be
captured simply by disconnecting (there are two telephone symbol icons at the top of the HyperTerminal®
screen for disconnecting and connecting) immediately after the event in question. The scroll bar can be
driven up to the event and all of the data associated with the event can be selected, copied, and pasted
into Microsoft® Excel® or other spreadsheet program as described below.
For longer term data, it is useful to capture the data in a text file. With the desired data streaming to the
screen, select “Capture Text” from the Transfer Menu. Type in the path and file name you wish to use.
Push the start button. When the data collection period is complete, simply select “Capture Text” from
the Transfer Menu and select “Stop” from the sub-menu that appears.
Data that is selected and copied, either directly from HyperTerminal® or from a text file can be pasted
directly into Excel®. When the data is pasted it will all be in the selected column. Select “Text to
Columns...” under the Data menu in Excel® and a Text to Columns Wizard (dialog box) will appear.
Make sure that “Fixed Width” is selected under Original Data Type in the first dialog box and click “Next”.
In the second dialog box, set the column widths as desired, but the default is usually acceptable. Click
on “Next” again. In the third dialog box, make sure the column data format is set to “General”, and click
“Finish”. This separates the data into columns for manipulation and removes symbols such as the plus
signs from the numbers. Once the data is in this format, it can be graphed or manipulated as desired.
For extended term data capture see: “Sending a Simple Script to HyperTerminal®” on page 27.
Data Format:
The data stream on the screen represents the pressure parameters of the main mode in the units
shown on the display. For P Series Pressure Gauges, there is a single column of data. This column
represents the measured pressure in the units specified at time of order and shown on the display.
+4.123
+4.123
+4.123
+4.123
+4.124
+4.125
P Series Pressure Gauge Data Format
For PC Series Controllers, there are 2 columns of data representing pressure and set-point. The first
column is pressure (normally in PSIG), the second column is the set-point (in the units specified at time
of order and shown on the display).
+014.70 +014.70
+014.70 +014.70
+014.70 +014.70
+014.70 +014.70
+014.70 +014.70
+014.70 +014.70
PC Series Vacuum and Pressure Controller Data Format