Specifications

Microsoft Excel Data Exchange Functions
PlantScape Server and Client Configuration Guide 473
NAPI_rGethstpar_ofst
Retrieves history parameter value for a single point by offset.
Example To retrieve the last 10 values of fast history for the PV of point PNTANA1 from
server HSSERVA:
=NAPI_rGethstpar_ofst("hsserva",6,1,10,"",NAPI_rGetPnt_Num("
hsserva","pntana1"),0)
Server Name of the PlantScape server from which data is retrieved.
HistoryType History type of the point to retrieve. For example, 6 for 5
second fast history.
The history types and the parameter values are:
• H1M (one minute history)—1
• H6M (six minute history)—2
• H1H (1 hour history)—3
• H8H (8 hour history)—4
• H24H (24 hour history)—5
• H5SF (fast history snapshots)—6
• H1HE (1 hour extended history)—7
• H8HE (8 hour extended history)—8
H24HE (24 hour extended history)—9
HistoryOffset Starting history interval from now.
NumHistoryValues Number of history values to retrieve.
ArchivePath Set this to “ ”
PointNumber Point number of the point. See “NAPI_rGetPnt_Num” on
page 474 for details of how to obtain the point number for
a point ID.
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.
plscpcg.book Page 473 Monday, May 28, 2001 10:11 AM