A.1 the fpblkvald( ) function, The fpblkvald( ) function – Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide User Manual
Page 359

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
time
Time and Date in spreadsheet format.