Live formula migration mapping details
- Last UpdatedJan 25, 2024
- 1 minute read
wwlive1 Formula
wwLive1 =wwLive1(DataSource, TagRange, DisplayTagName, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, DisplayOPCQuality, DisplaySourceTag, DisplaySourceServer, OptionRange)
Equivalent Formula in the Excel add-in:
HISTORIAN.SINGLEVALUE(TagList, ValueType, Time, Details, Down, DiscreteFormat, UOMAddress)
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
Data Source |
NA |
|
TagRange |
TagList |
|
DisplayTagName |
TagName-Details |
|
DisplayDatetime, |
Time |
|
DisplayQuality, |
NA |
|
ReplacePoorQuality, |
NA |
|
DisplayOPCQuality |
OPC Quailty--Details |
|
DisplaySourceTag, |
NA |
wwAnalogLive1
wwAnalogLive1 =wwAnalogLive1(DataSource, TagRange, DisplayTagName, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, DisplaySourceTag, DisplaySourceServer, OptionRange)
Equivalent Formula in the Excel add-in:
HISTORIAN.SINGLEVALUE(TagList, ValueType, Time, Details, Down, DiscreteFormat, UOMAddress)
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
Data Source |
NA |
|
TagRange |
TagList |
|
DisplayTagName |
TagName-Details |
|
DisplayDatetime, |
Time |
|
DisplayQuality, |
NA |
|
ReplacePoorQuality, |
NA |
|
DisplaySourceTag, |
NA |
wwDiscreteLive1:
wwDiscreteLive1 =wwDiscreteLive1( DataSource, TagRange, DisplayTagName, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, DisplaySourceTag, DisplaySourceServer, OptionRange)
Equivalent Formula in the Excel add-in:
HISTORIAN.SINGLEVALUE(TagList, ValueType, Time, Details, Down, DiscreteFormat, UOMAddress)
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
Data Source |
NA |
|
TagRange |
TagList |
|
DisplayTagName |
TagName-Details |
|
DisplayDatetime, |
Time |
|
DisplayQuality, |
NA |
|
ReplacePoorQuality, |
NA |
|
DisplaySourceTag, |
NA |
wwStringLive1
wwStringLive1 =wwStringLive1( DataSource, TagRange, DisplayTagName, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, DisplaySourceTag, DisplaySourceServer, OptionRange)
Equivalent Formula in the Excel add-in:
HISTORIAN.SINGLEVALUE(TagList, ValueType, Time, Details, Down, DiscreteFormat, UOMAddress)
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
Data Source |
NA |
|
TagRange |
TagList |
|
DisplayTagName |
TagName-Details |
|
DisplayDatetime, |
Time |
|
DisplayQuality, |
NA |
|
ReplacePoorQuality, |
NA |
|
DisplaySourceTag, |
NA |
wwReplicatedLive
wwReplicatedLive =wwReplicatedLive(DataSource, TagRange, DisplayTagName, DisplayDatetime, DisplayMilliseconds, DisplayQuality, ReplacePoorQuality, DisplaySourceTag, DisplaySourceServer, OptionRange)
Equivalent Formula in the Excel add-in:
HISTORIAN.SINGLEVALUE(TagList, ValueType, Time, Details, Down, DiscreteFormat, UOMAddress)
|
Historian Client Workbook |
Excel Add-in |
|---|---|
|
Data Source |
NA |
|
TagRange |
TagList |
|
DisplayTagName |
TagName-Details |
|
DisplayDatetime, |
Time |
|
DisplayQuality, |
NA |
|
ReplacePoorQuality, |
NA |
|
DisplaySourceTag, |
NA |