Build formulas with smart objects
- Last UpdatedFeb 28, 2025
- 1 minute read
Formulas are built in the Equation Editor dialog. In addition to Smart Object functions, AVEVA Production Accounting supports many built-in functions as well. They can be grouped as:
-
Mathematical Functions
-
Text Functions
-
Date & Time Functions
-
Statistical Functions
-
Logical Functions
Details for each function are described in the Function frame of the Equation Editor dialog box when you select the function.
NOTE: AVEVA Production Accounting also supports multiple equations execution in the Equation editor and returns the last equation value to Event data.
Example
A = 2 * Stream(01FC034;MassFlowrate)
B = A + Stream(01FC039;MassFlowrate) * 2
C = A + B
“C” value is output of equation editor and returns the same to Event data of stream/Tank/Tag.
Examples
Below are some realistic examples of the kinds of built-in and smart object functions that our customers use.
|
Some examples of default flow rate equation for stream object type |
|
If(Month(Model(StartDateTime)) >= 10 Or Month(Model(StartDateTime)) <= 3, Stream(LS_WWT;MassFlowrate)*0.8,0) |
|
(Stream(EG2FQI139;MassFlowrate)/28.054*(1-(120-35*(Stream(EG2FQI163;MassFlowrate)/Stream(EG2FQI139;MassFlowrate)))/100)*2*44.01)*1 |
|
(Node(ENERGY_BRU;MassFlowrate)-Node(ENERGY_BRU;MassRunrate))/Stream(ENERGY_SP_BRU_BZ;MassFlowrate)*1000 |
|
If(Abs(Stream(LOSS_SS_C4R1;RecMassFlowrate))>StatStream(LOSS_SS_C4R1;MinMassRate)*2,Stream(V_BD2FI104;MassFlowrate),Stream(V_BD2FI104;MassFlowrate)-Stream(LOSS_SS_C4R1;MassFlowrate)) |
|
If((Stream(BZ2FC6010;MassFlowrate)-Tank(B5436-F;MassDelta)-Stream(VC1FI946;MassFlowrate)-Stream(V_OS2FQI234_S;MassFlowrate)-Stream(NC2FQI1064;MassFlowrate)+Tank(B10-124-F;MassDelta))>10,Stream(BZ2FC6010;MassFlowrate)-Tank(B5436-F;MassDelta)-Stream(VC1FI946;MassFlowrate)-Stream(V_OS2FQI234_S;MassFlowrate)-Stream(NC2FQI1064;MassFlowrate)+Tank(B10-124-F;MassDelta),0) |
|
If(Stream(B1_FI873;MassFlowrate)<10,12-Stream(B1_FI873;MassFlowrate),0) |
|
If((Stream(V_IP20_TSS;MassFlowrate)+Tank(U-FB128B;MassDelta))>5,(Stream(V_IP20_TSS;MassFlowrate)+Tank(U-FB128B;MassDelta))*0.8,0) |
|
(STREAM(V_T3-PIC1302A_N2;MASSFLOWRATE)*STREAM(V_T3-PIC1302A;COMPONENT;CO)+STREAM(V_T3-PIC1302B_N2;MASSFLOWRATE)*STREAM(V_T3-PIC1302B;COMPONENT;CO)+STREAM(V_T3-PIC1401_N2;MASSFLOWRATE)*STREAM(V_T3-PIC1401;COMPONENT;CO))/100 |
|
Some examples of default inventory equation of tank object type |
|
Tank(B5432-FC;MassVolume)+Tank(B5432-FD;MassVolume)+Tank(B5435-F;MassVolume)+Tank(B5439-F;MassVolume)-Tank(V_B5432-F_LG; MassVolume) |
|
TANK(T3-D1605_IBA;MASSVOLUME)*TANK(T3-D1605_IBA;COMPONENT;PX)/100 |