Specifications

Using Microsoft Excel Data Exchange
PlantScape Server and Client Configuration Guide 455
b) Enter the desired point ID into the Point ID field, for example,
01T1LEVEL.
c) Select the point parameter from the Point Parameter list (or type the
parameter name into the field), for example, PV. You can add or
remove point parameters as required.
Note The Point Parameter drop-down list displays all parameters,
regardless of point type. You must select a parameter valid for
your chosen point type.
d) Click Add to add the point parameter specification to the list.
3 Specify to arrange the data either Horizontally or Vertically.
4 Specify how the data is to be displayed on the worksheet.
Display Server Name
Inserts the name of the PlantScape server into a cell on your Excel
worksheet.
Display Point ID
Inserts the name of the Point ID into a cell on your Excel worksheet.
Display Parameter
Inserts the parameter name into a cell on your Excel Worksheet.
Paste Values
When unchecked, it inserts updateable values in your Microsoft Excel
Worksheet. When checked, it inserts fixed values into your Microsoft
Excel Worksheet. Fixed values cannot be updated.
Minimize number of server calls
This option is only available when you choose to get history values
from the PlantScape server. When it is unchecked, Microsoft Excel
queries the PlantScape server separately for every cell that it fills with
data on your Microsoft Excel worksheet. When checked, Microsoft
Excel uses as few queries as possible; in general, this means just one
query per server. It is important to check Minimize number of server
calls when the values in the Microsoft Excel worksheet automatically
update.
5 When you are satisfied with your selection of Display Options, click Finish.
The data is displayed on your worksheet.
Retrieving Historical Information
You can insert a sequence of historical data into your Microsoft Excel worksheet.
In a sequence, each cell contains a single sample from history, for example,
five-second snapshots of the PV for point 01T1LEVEL from server hsserv.
plscpcg.book Page 455 Monday, May 28, 2001 10:11 AM