Stream Function Pane

Function

Description

Stream Name

• The name of event stream will be set in StreamName parameter.

• You can click Search () to search stream names.

  

• You can click Reference () to set specific cell to StreamName parameter.

  

• You can type or choose the stream name from the drop-down.

Property

• The property will be set in Property parameter.

• Depends on selected PropertyName, Unit and Aggregation list shall be changed.

Unit

• Depends on selected PropertyName, items of the list box will change.

• If the property is either Measured, Corrected, or Reconciled, you can choose Flowrate Unit and Volume Unit. But you can choose Gas Volume Unit when the event stream is only a gas stream. (Depends on Phase property).

Aggregation

• The aggregation will be set in Aggregate parameter.

• Depends on the selected property. You can use SUM and AVG. But if the property is not a number type, you cannot use the list box.

Start DateTime

• The date/time will be set in StartDateTime parameter.

• You can click Calendar () to select the specific date/time.

• You can click Reference () to set specific cell to StartDateTime parameter.

End DateTime

• The date/time will be set in EndDateTime parameter.

• You can click Calendar () to select the specific date/time.

• You can click Reference () to set specific cell to EndDateTime parameter.

Inner Object

• The value will be set in InnerObject parameter.

• The list box will be enabled when you only choose complex type property like Products, Components, and Properties.

• * means you did not set InnerObject parameter. If you select * the whole text of property will return.

Formula Cell

• Formula Cell is the cell that you want to insert the function.

• Click Reference () to select the cell in the Excel worksheet.

Buttons

• You can click Accept to insert completed function to the selected cell. (Even though you click Accept, the pane will keep existing values for the next task.)

• You can click Cancel to close the pane.

• You can click Evaluate to check the result before insert the function.