History formula migration mapping details
- Last UpdatedJan 25, 2024
- 3 minute read
Limitations for migrating history formulas
-
The Excel add-in only supports Full and Delta Modes. Unsupported modes from Historian Client Workbook are migrated to Full Retrieval as the default.
-
Bound time retrievals are not supported.
wwHistory3
wwHistory3 = wwHistory3(DataSource, TagRange, RowOrRes, Time1, Time2, Interpolation, RetrievalMode, TimeDeadband, ValueDeadband, RowLimit, TimestampRule, QualityRule, State, StateCalculation, ValueCriteria, EdgeDetection, HistoryVersion, ReplacePoorQuality, DisplayAsWide UseStringHistory, OrderBy, AnalogFilter, DisplayFlags )
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 RetrievalMode, _ |
Retrieval(Full and Delta) |
|
Optional TimeDeadband, |
NA |
|
Optional ValueDeadband, _ |
NA |
|
Optional RowLimit, _ |
NA |
|
Optional TimeStampRule, |
NA |
|
Optional QualityRule, _ |
NA |
|
Optional State, |
NA |
|
Optional StateCalculation, _ |
NA |
|
Optional ValueCriteria, |
NA |
|
Optional EdgeDetection, _ |
NA |
|
Optional HistoryVersion, |
NA |
|
Optional ReplacePoorQuality, _ |
NA |
|
Optional DisplayAsWide, |
Format(SingleTag or ALLTags) |
|
Optional UseStringHistory, _ |
NA |
|
Optional OrderBy, |
Ascending, |
|
Optional AnalogFilter, |
NA |
|
Optional DisplayFlags, _ |
Details |
|
Optional OptionRange) |
NA |
wwWideHistory3
wwWideHistory3 = wwWideHistory3( DataSource, TagRange, RowOrRes, Time1, Time2, InterpolationType, RetrievalMode, TimeDeadband, ValueDeadband, RowLimit, TimestampRule, QualityRule, State, StateCalculation, TagCriteria, EdgeDetection, HistoryVersion, OrderBy, AnalogFilter, DisplayFlags )
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 |
|---|---|
|
rowOrRes As String, _ |
NA |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
Optional Interpolation, |
NA |
|
Optional RetrievalMode, _ |
Retrieval(Full and Delta) |
|
Optional TimeDeadband, |
NA |
|
Optional ValueDeadband, _ |
NA |
|
Optional RowLimit, _ |
NA |
|
Optional TimeStampRule, |
NA |
|
Optional QualityRule, _ |
NA |
|
Optional State, |
NA |
|
Optional StateCalculation, _ |
NA |
|
Optional TagCriteria, |
NA |
|
Optional EdgeDetection, _ |
NA |
|
Optional HistoryVersion, |
NA |
|
Optional OrderBy, |
Ascending, |
|
Optional AnalogFilter, |
NA |
|
Optional DisplayFlags, _ |
Details |
|
Optional OptionRange) |
NA |
wwAnalogHistory
wwAnalogHistory =wwAnalogHistory( DataSource, TagRange, RowOrRes, Time1, Time2, Interpolation, RetrievalMode, TimeDeadband, ValueDeadband, ValueCriteria, DetectDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, 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 RetrievalMode, _ |
Retrieval, |
|
Optional TimeDeadband, _ |
NA |
|
Optional ValueDeadband, _ |
NA |
|
Optional ValueCriteria, _ |
NA |
|
Optional DisplayDateTime, _ |
Details, |
|
Optional DisplayMilliseconds, _ |
Details, |
|
Optional DisplayQuality, _ |
Details, |
|
Optional ReplacePoorQuality, _ |
NA |
|
Optional OptionRange |
NA |
wwDiscreteHistory
wwDiscreteHistory =wwDiscreteHistory( DataSource, TagRange, RowOrRes, Time1, Time2, RetrievalMode, TimeDeadband, ValueCriteria, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality 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 TagCriteria, _ |
NA |
|
Optional DisplayDateTime, _ |
Details, |
|
Optional DisplayMilliseconds, _ |
Details, |
|
Optional OptionRange |
NA |
wwStringHistory:
wwStringHistory =wwStringHistory(DataSource, TagRange,Time1,Time2,ValueCriteria,DetectDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, 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 |
|
time1 As Variant, _ |
StartTime, |
|
time2 As Variant, _ |
EndTime, |
|
Optional ValueCriteria, _ |
NA |
|
Optional DisplayDateTime, _ |
Details, |
|
Optional DisplayMilliseconds, _ |
Details, |
|
Optional DisplayQuality, _ |
Details, |
|
Optional ReplacePoorQuality, _ |
NA |
|
Optional OptionRange |
NA |