Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 463
GetHistVal_Date
For a single point parameter, retrieves multiple consecutive history values by date
and time. GetHistVal_Date inserts each history sample into an individual cell in
your Microsoft Excel worksheet. Before using the function, you must highlight
the cells that will contain history values (that is, you must highlight the number of
rows and columns necessary for displaying the data).
Example To retrieve 10 fast history values at 8:00am on 8 October 1998 for the PV
parameter of point PNTANA1 on server HSSERVA.
=GetHistVal_Date("hsserva","pntana1","pv","h5sf","8 October
1997","8:00am",10,"")
Server Name of the PlantScape server from which data is retrieved.
PointID Name of the point on the PlantScape server from which data is
retrieved.
PointParameter The point parameter of interest, for example, “PV”.
Refer to Table 8.1, “Summary of Point Parameter Types,” on
page 134 for a list of parameter types
HistoryType The history type to be retrieved, for example, “H5SF” for fast
history snapshots.
Refer to “Types of History Collection” on page 167 for a list of
history types.
HistoryDate The start date of the historical data. The date can be entered in
any string format that Microsoft Excel can interpret as a date or
time, for example “20/11/99” or “20-Nov-99”. Enclose the
date with double quotes.
HistoryTime The starting time of the historical data to retrieve 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.
ArchivePath Set this to “ ”
plscpcg.book Page 463 Monday, May 28, 2001 10:11 AM