Tag analysis formula mapping details
- Last UpdatedJan 25, 2024
- 1 minute read
Tag Analysis includes widehistory and the wide aggregate formulas.
Note that any charts will be ignored.
wwAnalogWideHistory:
wwAnalogWideHistory =wwAnalogWideHistory( DataSource, TagRange, RowOrRes, Time1, Time2, Interpolation, TagCriteria, DisplayDatetime, DisplayMilliseconds, OptionRange )
Equivalent formula in the Excel add-in: HISTORIAN.DETAIL(TagList, StartTime, EndTime, Retrieval, Format, Details, Down, Ascending, DiscreteFormat, UOMAddress)
Details: DateTime, Resolution, OpcQuality, Unit, and Value.
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
DataSource As String, _ |
NA |
|
TagRange As Range, _ |
TagList |
|
rowOrRes As String, _ |
NA |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
Optional Interpolation, _ |
NA |
|
Optional TagCriteria, _ |
Retrieval, |
|
Optional DisplayDateTime, _ |
NA |
|
Optional DisplayMilliseconds, _ |
NA |
|
Optional OptionRange |
NA |
wwDiscreteWideHistory:
wwDiscreteWideHistory =wwDiscreteWideHistory( DataSource , TagRange, RowOrRes, Time1, Time2, TagCriteria, DisplayDatetime, DisplayMilliseconds, OptionRange )
Equivalent formula in the current version: HISTORIAN.DETAIL(TagList, StartTime, EndTime, Retrieval, Format, Details, Down, Ascending, DiscreteFormat, UOMAddress)
Details: DateTime, Resolution, OpcQuality, Unit, and Value.
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
DataSource As String, _ |
NA |
|
TagRange As Range, _ |
TagList |
|
rowOrRes As String, _ |
NA |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
Optional TagCriteria, _ |
NA |
|
Optional DisplayDateTime, _ |
Details, |
|
Optional DisplayMilliseconds, _ |
Details, |
|
Optional OptionRange |
NA |