Configuration Guide User Manual

Micro-PWC CONFIGURATION GUIDE
338 Appendix A - Excel Functions
The fpblksample( ) Function
Function Name
fpblksample( ) - get Historical Block data for specified block, sample type, and time interval
Synopsis
double *fpblksample(char *blockname, char *type, double stime, double etime)
Description
The fpblksample() function is used to obtain Historical Block data for the block name, sample
type, and time interval specified. Each data value can then be retrieved using the fpblkvald
function with the appropriate single tag, time specification. This function must be preceded by a
function call to fpblkopen( ).
Inputs
Outputs
None.
Returns
The number of block samples found for time interval between stime and etime.
Example
This example gets all Hourly Average samples which were collected for the last 24 hours.
In Microsoft Excel:
=fpblkopen(“CALBLK1”)
=fpblksample("CALBLK1",".HAV", datevalue("12-JAN-06") + timevalue("12:00:00"),
datevalue("12-JAN-06") + timevalue("13:00:00"))
Parameter Description
blockname The name of block to be opened.
type The sample type indicator (atom); null for raw data.
stime Start Time and Date in spreadsheet format.
etime End Time and Date in spreadsheet format.
Sample Type Atoms
Period Average Min. Min. Time Max. Max. Time Standard Deviation
Hourly .HAV .HMN .HTMN .HMX .HTMX .HSD
Daily .DAV .DMN .DTMN .DMX .DTMX .DSD
Monthly .MAV .MMN .MTMN .MMX .MTMX .MSD
Yearly .YAV .YMN .YTMN .YMX .YTMX .YSD