Configuration Guide User Manual

Micro-PWC CONFIGURATION GUIDE
Appendix A - Excel Functions 339
The fpblkvald( ) Function
Function Name
fpblkvald( ) - get a value from the Historical Block database
Synopsis
double *fpblkvald(char *blockname, char *tag, char *type, double time)
Description
The fpblkvald() function gets the value from the Historical Block database which is associated
with the specified block name, tagname.atom, sample type, and time-stamp.This function must be
preceded by function calls to fpblkopen( ) and fpblksample( ).
Inputs
Outputs
None.
Returns
The value of the specified tagname.atom, or an error message.
Example
This example gets the Hourly Standard Deviation value for CAL_0.OUT from the Historical Block
named CALBLK1 for 4:00 PM on 10 January 2004.
In Microsoft Excel:
=fpblkopen(“CALBLK1”)
=fpblksample(“CALBLK1”, “.HAV”, datevalue(“12-JAN-04”) + timevalue(“12:00:00”),
datevalue(“12-JAN-04”) + timevalue(“13:00:00”))
=fpblkvald("CALBLK1", "CAL_0.OUT", ".HSD", datevalue("10-JAN-04") +
timevalue("16:00:00”))
Parameter Description
blockname The name of the block.
tag The tagname and atom for which the value will be retrieved.
type The sample type indicator (see The fpblksample( ) Function).
time Time and Date in spreadsheet format.