KPIArray Task Pane

Function

Description

KPI Name

• The name of KPI will be set in KPIName parameter.

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

  

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

  

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

Property

• The property will be set in Property parameter.

• You can select several items.

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.