StreamArray Function Pane

Function

Description

Stream Name

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

• You can click Search () to search tank 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 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 tank is only a gas tank. (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.

Output Direction

Output Direction will be set in OutputDirection parameter.

Display Dates

Display Dates will be set in DisplayDates parameter. If you select this checkbox, the function returns an array that includes starting date/time and ending date/time.

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.