Document Outline

• Introduction
  • About this Document
  • FactoryTalk Historian DataLink Editions
    • PI SDK
    • FactoryTalk Historian DataLink Language Support
  • System Requirements
  • Installation and Upgrade
    • Installation to a Local PC
    • Upgrade
    • Configuration
      • Microsoft Excel 2007
      • Microsoft Excel 2010
• Basics
  • User Interface
    • FactoryTalk Historian DataLink for Excel 2007
      • PI Ribbon
      • Function Task Panes
    • FactoryTalk Historian DataLink for Excel XP-2003
      • PI Menu
      • Function Dialog Boxes
    • Context Menu
  • FactoryTalk Historian Server Connections
  • Graphic Function Components
    • Entry Fields
    • Standard Arguments
      • Tagname(s) or Expression
      • Start Time
      • End Time
      • PI Server
      • Output Cell
    • Time Arguments
    • Appended Data
      • Appended Data Array
      • Show Timestamps
      • Interval Timestamps
      • Show Percent Good
      • Show Value Attributes
      • Show Annotations
    • Orientation Controls
    • Display Formats
  • Preference Settings
  • Spreadsheet Construction
• FactoryTalk Historian DataLink Functions
  • Current Value
  • Archive Value
  • Compressed Data
  • Sampled Data
  • Timed Data
  • Calculated Data
  • Time Filtered
• FactoryTalk Historian Tags and Attributes
  • Tag Search
  • Tag Functions
    • Point ID to Tag
    • Attribute Mask to Tag
    • Tag Attributes
• Module Database Objects
  • Module Database Browse
  • Module Database Functions
    • Alias to Tag
    • Property to Value
• Spreadsheets
  • Calculation Frequency
    • Automatic Update
    • Triggered Recalculation
    • Manual Recalculation
  • Functions and Array Values
  • Array Management
    • Update Arguments
    • Resize Arrays
  • Share Spreadsheets
• Trend Displays
  • Create a Trend
    • Worksheet Data
    • FactoryTalk Historian Data
    • Manage Traces
  • Specify the Time Range
  • Title and Placement
  • Context Menu
• Supplementary Information
  • Setup
    • High Availability Connection Preferences
    • FactoryTalk Historian Server Connectivity
      • Firewall Database
      • FactoryTalk Historian Trusts
      • Point Access Permissions
  • FactoryTalk Historian Time
    • FactoryTalk Historian Time Abbreviations
    • FactoryTalk Historian Time Expressions
    • FactoryTalk Historian Time String Examples
  • FactoryTalk Historian Data Type Support
  • FactoryTalk Historian Expressions
    • Syntax
    • Operators
    • Performance Equation Functions
      • Math Functions
      • Aggregate Functions
      • Miscellaneous Functions
      • FactoryTalk Historian Archive Retrieval
      • FactoryTalk Historian Archive Search
      • FactoryTalk Historian Archive Statistics
      • Point Attributes
      • Time Functions
      • Dynamic Response
      • Alarm Status Functions
      • String Functions
      • String Conversion
    • FactoryTalk Historian Expression Examples
  • Manual Function Entry
    • Use Array Functions
    • Mathematical Functions
    • String Arguments
    • Cell References
    • PIServer Argument
    • Outcodes
  • Write Data to FactoryTalk Historian
  • Troubleshooting
    • FactoryTalk Historian Menu Not Available
    • Array and Cell Limits
    • Row Limitations
    • Security
    • FactoryTalk Historian Security
• FactoryTalk Historian DataLink Function Reference
  • Single Value Functions
    • PICurrVal()
    • PIArcVal()
    • PIExpVal()
  • Multiple Value Functions
    • PINCompDat()
    • PINCompFilDat()
    • PICompDat()
    • PICompFilDat()
    • PISampDat()
    • PISampFilDat()
    • PIExpDat()
    • PITimeDat()
    • PITimeExpDat()
  • Calculation Functions
    • PICalcVal()
    • PIAdvCalcVal()
    • PIAdvCalcFilVal()
    • PIAdvCalcExpVal()
    • PIAdvCalcExpFilVal()
    • PICalcDat()
    • PIAdvCalcDat()
    • PIAdvCalcFilDat()
    • PIAdvCalcExpDat()
    • PIAdvCalcExpFilDat()
    • PITimeFilter()
    • PITimeFilterVal()
  • Tag Functions
    • PIPointIDToTag()
    • PIAttributeMaskToTag ()
    • PITagAtt()
  • Module Database Functions
    • PIAliasToTag()
    • PIPropertyToValue()
  • Input Functions
    • PIPutVal()
• Technical Support and Resources
  • Technical Support
    • Knowledgebase
    • Worldwide Support
    • Training Programs
    • Consulting Services
    • TechConnect Support
    • Find the Version and Build Numbers
    • View Computer Platform Information
• Index