Minimum Value of Lines(@LineMin)

 

It is function to calculate the minimum value of horizontal cell of which vertical cell is variable, such as AI Multi Ave, AI Multi Min, ...AI Alarm, AI Period Data, DI Multi On Time,... DI ON/OFF List etc. (Data Object for Multiple Lines)

If you select the 'Insert | Function' after selecting the cell (one or several), Insert Function dialogue box comes up.

After inserting the ¡®@LineMin(A:C)¡¯ at Insert Function dialogue box, you can modify this function by using the Cell Text Edit dialogue box. This dialogue box comes up by selecting the 'Form | Cell | Cell Text' or icon of Reporter ToolBox.

Also, you can insert this function by using the Cell Text Edit dialogue box, without Insert Function dialogue box.

 

Function of minimum value for lines uses following format.

-Function definition : double LineMin(cell 1 : cell 2)

-Function parameter : Specific number of cell. (start / end location)

-Result : The calculated minimum value of multiple lines.

 

@LineMin function uses in case of getting the minimum value of multiple lines as same method with @LineAve function.

 

Example of written function)  =@LineMin(D:G);

Function description : Minimum value of D, E, F, G cell of all multiple lines data is displayed at multiple lines which you specify.

 

 

Relate items)

Data Object for Multiple Lines

Inserting a Function

Reporter ToolBox

Edit a Cell Text

Average Value of Lines(@LineAve)

Insert menu in Reporter Editor

Reporter Editor Main Help