Specifications

20 – Using PlantScape Data in Other Applications
464 R400
GetHistVal_Offset
For a single point parameter, retrieves multiple consecutive history values by
offset. GetHistVal_Date inserts each history sample into an individual cell in your
Microsoft Excel worksheet. 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). Offset sets the
function to retrieve samples relative to now. So, for example, setting an offset of
5, means the first sample is 5 samples ago.
For example, when you want to return five history samples with an offset of 5,
you must select five consecutive cells horizontally across your spreadsheet, and
the function returns the values from 5 samples ago until the current sample,
inclusive.
Example To retrieve the last 10 fast history values for the PV parameter of point PNTANA1
on server HSSERVA.
=GetHistVal_Offset("hsserva","pntana1","pv","h5sf",1,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 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.
ArchivePath Set this to “ ”
plscpcg.book Page 464 Monday, May 28, 2001 10:11 AM