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. |