...
- To open KODIAK Functions select the Functions and Queries button in the toolbar:
...
- In the right side of the Excel document you will see a list of all KODIAK Services, Functions and Queries in the system. Select Tree View or Search View to find the right function.
...
- Functions are marked with in front of them but queries have in front of them.
...
- In the Search View you can order functions and queries by name or service by clicking on Name or Service. You can also search for a function or a query by name.
...
...
...
- Select the cell you want the function result to appear in.
...
- Select a function and select Add or double-click on a function name to open the parameter window. You can also right-click on a function name in tree view and select Add
...
- to worksheet to open the parameter window. Finally, you can click on a function name and drag it to the cell you want it to appear in to open the parameter window.
...
- Insert a value or cell including the value in the parameter fields and press OK. Below the description of the function you can see how to insert the parameters. E.g. when
...
- inserting dates use the format "dd.mm.yyyy" or "dd.mm.yy". The result is then displayed in the selected cell.
...
- If you know the name of the function you want to use you can type = in the cell and start to type in the name of the function. A list of functions appears:
...
- Double-click on the function name you want to use.
...
- Select Ctrl+Shift+A to see what the type of parameter is.
...
- Enter the value. You can type in the value or select a cell containing the value. If you enter a string or date, use quotation marks. Press Enter to view the result.
...
- To get help on a function select the name of the function and then select Help below the list of functions and queries. Help on the function will open in a new window.