Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide - Manual (Page 345)

Micro-PWC CONFIGURATION GUIDE
Appendix A - Excel Functions 325
The fphgetd( ) Function
Function Name
fphgetd( ) - get a value fromthe Historical database (double precision)
Synopsis
double fphgetd(char *tag, double time)
Description
The fphgetd() function is used in the spreadsheet as a formula. This function gets the value of a
specified tagname from the Historical database. The function fphgetd() returns the value as a
double precision data type.
Inputs
Outputs
None.
Returns
The value of the specified tagname, or an error message.
Example
This example gets the value for FIC101 from the Historical database, for noon on 12 January
2006.
In Microsoft Excel:
=fphgetd("FIC101", DATEVALUE("12-JAN-06") + TIMEVALUE("12:00:00"))
Parameter Description
tag Tagname for which the value will be obtained from the
Historical database.
time Time and Date in spreadsheet format (refer to the
Microsoft Excel manual for information on spread-
sheet format).