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

●
●
●
●
●
FactoryTalk Historian DataLink User Guide
102
Use Array Functions
When defining array functions follow these steps:
 Select an appropriate output range for the array based on the number
of expected values.
 Enter the FactoryTalk Historian function and its arguments into the
Excel formula bar.
 Place the FactoryTalk Historian function into the selected output cells
with the Ctrl+Shift+Enter combination of keystrokes.
Refer to the online help for Microsoft Excel for more information on array
functions.
Mathematical Functions
In a tag calculation expression, mathematical operators and functions act
upon tag names. Supported Mathematical Functions are:
 abs &emdash; absolute value
 atn &emdash; arc tangent (angle returned in radians)
 cos &emdash; cosine (argument in radians)
 exp &emdash; e (2.71828...) raised to a power
 int &emdash; integer part of a number
 log &emdash; natural logarithm
 sgn &emdash; sign function (-1 if argument is negative, 0 if zero, 1 if
positive)
 sin &emdash; sine (argument in radians)
 sqr &emdash; square root function
 tan &emdash; tangent (argument in radians)