Exporting Pen Data

You can export Process Analyst data for pens that
are visible to either the Windows Clipboard (by using the Copy to Clipboard command) or to an Microsoft
Excel-compatible file (Copy to File).

When you export data, it is exported using a
standard format of columns that represent time, milliseconds, and
then a column per pen, as shown here:

Time

Milliseconds

Pane1-Pen1

Pane1-Pen2

Pane1-Pen3

15/06/2004 01:17:25

100

NA

10

Off

15/06/2004 01:17:26

100

1

20

Low [Unacknowledged]

15/06/2004 01:17:27

100

Low [Acknowledged]

15/06/2004 01:17:28

100

3

25

Low [Acknowledged]

Export functionality doesn't simply return the
sample markers displayed on the graph. Instead, it exports an
interpolated value per display period from the start time to the
end time of the pen. The display period can be calculated by
dividing the time span of the pen by the IProcessAnalyst.NumberofSamples[Property][Get/Set]
property.

Before exporting the data, the Process Analyst
sorts the timestamps for pens from the earliest to the latest
sample. When the pens are unlocked and have different time spans,
the data for each pen might have different timestamps. As each
entry is added to a row in the table, the value of the pen at that
particular timestamp is exported. If a pen does not have a sample
for that timestamp, the column for that pen is left blank.

An export will also write values of NA, GATED and
alarm states as localized text when necessary.

Pen columns use the format <pane>-<pen>
where pane is the name of the pane that
contains the pen, and pen is the name of
the pen.