TABLE.UPDATE
Creates and updates a defined cell range in a table like manner. The first row and first column of specified cell range defines the indices used to reference a table cell. To set or update a cell its corresponding row and column indices must be given. If a row index does not exist in current range, it can be automatically added to top or bottom. The same applies for a column index which can be automatically added to the left or right. To simply read values from a table cell refer to TABLE.GET
Syntax
=TABLE.UPDATE(CellRange, Value, [RowIndex], [ColumnIndex], [PushRowAt], [PushColumnAt], [AggregationMethod])
Arguments
| Name | Description |
|---|---|
| CellRange | Cell range to treat like a table. Its first row and its first column are used to reference table cells. |
| Value | A value to set in referenced table cell. |
| RowIndex (optional) | The row index of a table cell. If not defined no value is set. The PushRowAt parameter can be used to add the row index if the table has no equal index. |
| ColumnIndex (optional) | The column index of a table cell. If not defined no value is set. The PushColumnAt parameter can be used to add the column index if the table has no equal index. |
| PushRowAt (optional) | Defines where to insert a new row index. Should be either 1, -1, or 0. To insert new row at the bottom specify 1, -1 will insert it at the top and 0 will not insert at all. Defaults to 0. |
| PushColumnAt (optional) | Defines where to insert a new column index. Should be either 1, -1, or 0. To insert new column to the right specify 1, -1 will insert it to the left and 0 will not insert at all. Defaults to 0. |
| AggregationMethod (optional) | One of the predefined numbers which specifies the aggregation method to use for specified table cell. Options (Defaults to 0): 0 : NONE (No aggregation is performed and the last valid value is returned) 1 : AVERAGE (Calculates the average of all received values) 2 : COUNT (Counts the number of received values) 3 : COUNTA (Counts all values which are not zero) 4 : MAX (Determines the maximum of all received values) 5 : MIN (Determines the minimum of all received values) 6 : PRODUCT (Calculates the product of all received values) 7 : STDEV.S (Calculates the standard deviation of all received values) 8 : STDEV.P (Currently not available!!) 9 : SUM (Calculates the sum of all received values) |
Return
TRUE or an error value.
Examples
| Time | Turbine1 | Turbine2 | Turbine3 |
|---|---|---|---|
| 93370 | 1000 | 2000 | 3000 |
| 93360 | 1500 | 2500 | 3500 |
| Formula | Result | Comment |
|---|---|---|
| TRUE | |
| TRUE |