Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 469
GetPointValArray
Retrieves the value of multiple point parameters from the server. Before using the
function, you must highlight the number of cells that will contain history values
(that is, you must highlight the number of rows and columns necessary for
displaying the data). Can display data horizontally or vertically.
Example To retrieve the current values for the PV and OP of point PNTANA1 on server
HSSERVA, and arrange the parameter output values vertically:
=
Array(2,"hsserva","pntana1,pntana1","pv,op","v")
NumPoints Number of points.
Server Name of the PlantScape server from which data is retrieved.
PointIDList A list of point IDs on the PlantScape server from which data
is retrieved. These names must be separated by commas, for
example “sinewave,tank1temp”. The number of names
in the list must match the number specified in NumPoints
PointParameterList A list of point parameters separated by commas, for example
“pv,sp”. The number of parameters in the list must match
the number specified in NumPoints.
Refer to Table 8.1, “Summary of Point Parameter Types,” on
page 134 for a list of parameter types.
ArrayOrientation Enter “h” for horizontal and “v” for vertical.
plscpcg.book Page 469 Monday, May 28, 2001 10:11 AM