Optical functions > Workbook and batch control

Using the object names 'workbook' and 'batch control' you can retrieve values computed by the workbook or the batch control window. At the moment the following functions are available:

Function	Meaning
average, sheet1, start_row, start_column, end_row, end_column	Returns the average of numbers that appear in a block of cells in the workbook 'sheet1'. The block must be rectangular, starting at the cell given by start_row and end_row, and ending at the cell defined by end_row and end_column.
stddev, sheet1, start_row, start_column, end_row, end_column	Returns the standard deviation. The other parameters are the same as discussed above.
minimum, sheet1, start_row, start_column, end_row, end_column	Returns the minimum value. The other parameters are the same as discussed above.
maximum, sheet1, start_row, start_column, end_row, end_column	Returns the maximum value. The other parameters are the same as discussed above.
range, sheet1, start_row, start_column, end_row, end_column	Returns the range (= maximum - minimum). The other parameters are the same as discussed above.