A.1 the fphput( ) function – Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide User Manual
Page 349

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.