Rockwell Automation FactoryTalk Historian SE DataLink 4.2 User Guide - Manual (Page 141)

9
●
FactoryTalk Historian DataLink Function Reference
●
●
●
●
●
133
 4 produces values and percent good along 2 columns.
 5 produces time stamps, values, and percent good along 3 columns.
 6 produces values and percent good along 2 rows.
 7 produces time stamps, values, and percent good along 3 rows.
Example:
The following retrieves totals for the tag located in cell B1, from midnight
yesterday to midnight today at 3-hour intervals from the default
FactoryTalk Historian server:
=PICalcDat(b1,"y","t","3h","total",24,1,)
Time stamps are also returned. The values are multiplied by 24 before they
are displayed in the spreadsheet.
PIAdvCalcDat()
Retrieves calculated FactoryTalk Historian point values using the
following syntax:
PIAdvCalcDat(tagname, stime, etime, interval, mode,
calcbasis, minpctgood, cfactor, outcode, PIServer)
Arguments
Argument Explanation
tagname (string) The tag name or names matching the desired FactoryTalk Historian
points for calculation.
stime (string) The start time for the range of calculation (in FactoryTalk Historian
time format).
etime (string) The end time (in FactoryTalk Historian time format).
interval (string) The interval between calculated values (in FactoryTalk Historian time
format).
mode (string) The type of calculation to be used to compute point values.