Configuration Guide User Manual

Micro-PWC CONFIGURATION GUIDE
Appendix A - Excel Functions 329
The fphput( ) Function
Function Name
fphput( ) - put a value from the spreadsheet into the Historical database (ASCII)
Synopsis
char fphput(char *tag, char *time, char *val)
Description
The fphput() function is used to put a value from the spreadsheet into the Historical database,
using the tagname specified. The function fphput() takes and places the value in ASCII 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 (in ASCII format) into the tagname FIC101 in the Historical
database, for the current time.
In Microsoft Excel:
=fphput("FIC101", DATEVALUE("22-SEP-05") + 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 ASCII value to be stored in the historical database.