Skip to content

Formula node

Screenshot

To review formula node interface lets use the same example from above where Total money formula node is calculated by multiplying Production volume data node times Price data node.

(1)   Page bar.

Page bar shows all currently open Projects, Sheets, Nodes.

(2)   Path and short node menu.

It shows the path to current node (Project name / Sheet name / Node name). Single click on the node name brings up the menu which lets rename current node.

(3)   Back button.

It shows previously opened page (project, sheet, node) and lets navigate there by just single click.

(4)   Input & Output connections menu.

It shows the list of nodes which are connected as inputs and outputs to currently opened formula node. In this example Total money formula node is connected as output to the Production volume node and Price data node. Names of nodes in input/output connections menu are very useful for fast navigation. Double click on the name of input node (Price) opens this input node in a new tab and brings your focus to that tab. To navigate back to Total money node double click on on its name (Total money) in the output connections menu of Price node.

(5)   Input/output connections search field.

In big projects nodes may have many input/output connections. Start typing the name of any node in the search field and only nodes with matching names will remain in the output connections menu.

(6)   Expression manager.

On the left side of this expression is a variable which contains the result of calculation. This variable cannot be changed. Its name is the same as the name of the formula node. To build the expression on the right side use the names of nodes from the input connections menu [4]. Place the cursor to the right of equal sign and start typing the name of input node. The menu will apper. It will contain names of input nodes matching the typed text. Click on one of them and it will be placed in equation. To use signs of mathematical operations place the cursor where the sign should appear and then click on the button of corresponding sign [7]. An alternative method for most common signs is to use the keyboard: + - * / ( ).

(7)   Mathematical signs buttons bar.

(8)   Run button.

Click on this button to calculate the expression.

(9)   Results of calculation area.

If calculation is successful a table containing the results will apper in this area.

(10)   Path information.

It shows the complete path to the currently open node: Project name -> Sheet name -> Node name.