Micromod Micro-PWC: 53PW6000 MicroPWC Configuration Guide - Manual (Page 365)

Micro-PWC CONFIGURATION GUIDE
Appendix A - Excel Functions 345
Outputs
None.
Returns
Value of the type requested.
Example
Assignments to support the example are shown in the following table. Note that the contents of
Cell A1 are subtracted from the contents of Cell A2 (A2-A1) and the result is displayed in Cell A3.
The actual example is shown below:
=fpxammts("HIST1",A3,A2,.02,"imin")
=fpxammts("HIST1",A3,A2,.02,"tmin")
This example gets the data for the last 24 hours for the tag "HIST1" from the Historical database.
The first call returns the minimum value and the second call returns the time the minimum value
was collected.
Cell Address Cell Contents
CELL A1 1
CELL A2 =now()
CELL A3 +A2-A1