Configuration Guide User Manual

Micro-PWC CONFIGURATION GUIDE
344 Appendix A - Excel Functions
The fpxammts( ) Function
Function Name
fpxammts( ) - get a range of values for a tag from the Historical Database during a specified time
period (double precision)
Synopsis
double fpxammts(tag, stime, etime, totfac, type)
Description
The fpxammts() function is used to get a range of values from the Historical database, using the
tagname specified. The function fpxammts() computes the minimum, maximum, average, total
and standard deviation of the values obtained. It also gets the times that the minimum and
maximum values occurred. Using the type field, the user can retrieve any of these values. If
multiple calls are made successively using the same tag, stime, etime and totfac, the values are
cached, resulting in one DBA transaction.
Inputs
Parameter Description
tag The tagname of the point in the Historical database for which
values from the database will be obtained.
stime The time in the Historical database at which to start retrieving
values (i.e., start time).
etime The time in the Historical database at which to stop retrieving
values (i.e., end time).
totfac Totalization factor, used when computing the total so that the
value used in the log reflects the type of units desired by the
user. For example, if the value stored in the Historical data-
base reflects gallons per minute, that value is multiplied by the
value in totfac so that the resulting value reflects gallons per
day instead of gallons per minute.
type The type of data requested. Data types which can be
requested and the syntax used to request them are as shown
in the next table.
Data Type
Specifier
Description
imin Minimum value
imax Maximum value
iavg Average value
itot Total value
istd Standard deviation
tmin Time of minimum value
tmax Time of maximum value