Configuration Guide User Manual

Micro-PWC CONFIGURATION GUIDE
330 Appendix A - Excel Functions
The fphputd( ) Function
Function Name
fphputd( ) - put a value from the spreadsheet into the Historical database (double precision)
Synopsis
double fphputd(char *tag, char *time, double val)
Description
The fphputd() function is used to put a value from the spreadsheet into the Historical database,
using the tagname specified. The function fphputd() takes and places the value in double
precision format.
Inputs
Outputs
None.
Returns
The value put into the Historical database, or an error message.
Example
This example puts the value for 12.34 into the tagname FIC101 in the historical database, for the
current time.
In Microsoft Excel:
=fphputd("FIC101", DATEVALUE("22-SEP-95") + TIMEVALUE("14:10:00"), 12.34)
Parameter Description
tag The tagname of the point in the Historical database into which
the value will be placed.
time Time and Date in spreadsheet format (refer to the Microsoft
Excel manual for information on spreadsheet format).
val The double precision value to be stored in the Historical data-
base.