Formulas
- Last UpdatedFeb 28, 2025
- 1 minute read
Formulas are built in the Equation Editor dialog. In addition to smart object functions as described above, AVEVA Production Accounting supports many built-in functions. 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 section of the Equation Editor dialog when you select the function.
Below are some realistic examples of the kinds of built-in and smart object functions that our customers use.
|
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 |
|
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 |