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.
See Also
Copying data to the Clipboard | Copying data to file
Published June 2018