Manually insert a function

You can manually insert functions instead of using the function wizards.

In Excel, functions are not automatically inserted as array formulas. By default, only single cell contains a value from the result set. You must type the formula as an array formula (by pressing CTRL+SHIFT+ENTER) so that all values in the result set appear.

To manually insert a function:

1. In the worksheet, type values to use for the function arguments. For example, you might type "EMINSQL10" for the data source name and "ReactLevel" and "ReactTemp" as the tags for which to retrieve live values.

2. On the Formulas tab, in the Function Library group, click Insert Function. The Insert Function dialog box appears.

3. In the Or select a category list, click User Defined.

4. In the Select a function list, select any of the AVEVA Historian Client Workbook functions.

   All of these functions are prefixed with "ww." For more information regarding these functions and their arguments, see AVEVA Historian Client Workbook Function Reference.

5. Click OK. The Function Arguments dialog box appears.

6. For each of the arguments, assign a cell value that contains the input.

   For example, assigning A1 to the DataSource argument causes "MyInSQL" to be used for the data source.

7. Click OK. The function is inserted into the spreadsheet.

   Note: If the function returns a date/time value, the date/time appear in the Julian format, unless a different format is configured for the cell.

8. Select the returned value.

9. On the Historian tab, in the Controls group, click Refresh Function. The formula is converted to an array and you can see all of the return values.