Specifications

20 – Using PlantScape Data in Other Applications
456 R400
To display a sequence of historical values:
1 Select Tools
⇒
Microsoft Excel Data Exchange
⇒
Wizard to start the
wizard.
2 Select Get history values from server(s).
3 You can specify the target point parameters you want retrieved.
4 Specify the desired historical values to be retrieved for the selected points.
Note Ensure that your selection matches the history collection for the
points on the server. If you select a history collection that is not configured
for that point, Microsoft Excel displays an error code instead of the data.
Note Offset is the number of samples relative to “now.” You can select
this option to see a continuously updating sequence of values. You use the
Date/Time option to specify a sequence of values from a fixed period of
time.
5 Specify how the data is to be displayed on the worksheet.
Note To view continuously updating data, ensure Paste values is
unchecked.
Using Cell Formulas
In addition to using the Microsoft Excel Data Exchange Wizard, you can use cell
formulas to capture point or history values. Microsoft Excel Data Exchange
includes a number of functions to allow data exchange with PlantScape. In fact,
by using the Microsoft Excel Data Exchange Wizard to retrieve point parameters
and historical data, you are actually using several of these functions.
To use the Microsoft Excel Data Exchange functions:
1 Select a cell, or a range of cells, where you want the data to appear.
2 Click in Excel’s formula bar, then click the fx button to start the Microsoft
Excel Function Wizard.
3 Select the function you want, as described below.
Microsoft Excel fx button
plscpcg.book Page 456 Monday, May 28, 2001 10:11 AM