Excel RTD formula sample

Use these formulas to read tag values under different options.
On the
Server Configuration
 tab, under
Excel RTD Interface
,
  • If you select
    Folders with scalar data
    , the RTD formula could be:
    =RTD("FTLinxGatewayRTD","","[ShortcutName]TagName",1000,0,"")
    Example:
    =RTD("FTLinxGatewayRTD","","[ShortcutName]Tag1",1000,0,"")
    =RTD("FTLinxGatewayRTD","","[ShortcutName]Program:MainProgram.l_BoolArray1[006]",1000,0,"")
    =RTD("FTLinxGatewayRTD","","area::[ShortcutName]Program:MainProgram.l_BoolArray1[006]",1000,0,"")
    =RTD("FTLinxGatewayRTD","","area:FactoryTalk Linx2:[ShortcutName]Program:MainProgram.l_BoolArray1[006]",1000,0,"")
    =RTD("FTLinxGatewayRTD",""," :FactoryTalk Linx2:[ShortcutName]Program:MainProgram.l_BoolArray1[006]",1000,0,"")
    =RTD("FTLinxGatewayRTD","","[ShortcutName]StructTag.Element",1000,0,"")
    =RTD("FTLinxGatewayRTD","","[ShortcutName]Program:MainProgram.StructTag.Element",1000,0,"")
  • If you select
    Custom namespace
    , the RTD formula could be:
    =RTD("FTLinxGatewayRTD","","[NamespaceName]TagName",1000,0,"")
    Example:
    =RTD("FTLinxGatewayRTD","","[Namespace_01]Tag1",1000,0,"")
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal