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

Chapter 3
33
FactoryTalk Historian DataLink
Functions
FactoryTalk Historian DataLink functions enable you to query, calculate
and return FactoryTalk Historian point values and attributes to spreadsheet
cells. Like other Excel functions, FactoryTalk Historian DataLink function
results are displayed in arrays which can be recalculated to display updated
event values as needed.
To access FactoryTalk Historian functions:
 Click in the desired output cell, and then choose PI > <function
name> to open a function dialog box (XP-2003), or click a function on
the FactoryTalk Historian ribbon to open a new function task pane
(2007).
The function descriptions in this section describe arguments specific to
each function in terms of these common features.
Current Value
Retrieves the current or most recent (snapshot) value of a FactoryTalk
Historian point, based on tag name.
Required
Arguments
Tagname.
Special Notes Reference a range of cells containing tag names to display current
snapshot values for each.
Updates whenever Excel calculates or recalculates any cell in the
spreadsheet. To force an immediate recalculation, press F9.