Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 467
GetHistValArray_Offset
For multiple point parameters, retrieves multiple consecutive history values by
offset. 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). The function can display data
horizontally (history values by point parameters) or vertically (point parameters
by history values).
Example To retrieve the last 10 fast history values for the PV and OP parameters of point
PNTANA1 on server HSSERVA, and format the output to display the history values
for each parameter horizontally:
=GetHistValArray_Offset(2,"hsserva","pntana1,pntana1",
"pv,op","h5sf",1,10,"h","")
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 by 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.
HistoryType History type of the point to retrieve. For example, “H5SF”
for fast history snapshots.
Refer to “Types of History Collection” on page 167 for a list
of history types.
HistoryOffset Starting history interval from now.
NumHistoryValues Number of history values to retrieve.
ArrayOrientation Enter “h” for horizontal and “v” for vertical.
ArchivePath Set this to “”
plscpcg.book Page 467 Monday, May 28, 2001 10:11 AM