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

Page 350

Advertising
background image

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.

Advertising