Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 465
GetHistValArray_Date
For multiple point parameters, retrieves multiple consecutive history values by
date and time. 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). This function can display data
horizontally (history values by point parameters) or vertically (point parameters
by history values).
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. The names in the list 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.
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.
HistoryDate Starting date of historical data to retrieve. The date can be entered
in different formats, for example “20/11/96” and
“20-Nov-96”. Enclose the date with double quotes.
HistoryTime Starting time of historical data to retrieve. The data is formatted in
24 hour format. For example, “17:30:15” for 5:30:15pm.
Enclose the time with double quotes.
NumHistoryValues Number of history values to retrieve.
ArrayOrientation Enter “h” for horizontal and “v” for vertical.
ArchivePath Set this to “”
plscpcg.book Page 465 Monday, May 28, 2001 10:11 AM