Skip to content

Nodes types

There are three types of nodes in AIMES:

  • Data node
  • Formula node
  • Python node

Data node

Data node contains data in a table form. It could be a table with many rows (we call it “List”) or a single row (we call it ”Item”). Data node provides its data for further calculations to Formula node and Python node via the output connections.

As AIMES is aimed at working with the data changing over time or over sequential steps column headers are always time marks (end of month, quartal, year) or consecutive steps numbers (1, 2, 3..). Row headers are categories names. For example for table of expenses it could be: Salaries, Taxes, Equipment, etc. Data in the table are always numbers. There is an option to assign units to the data:

  • Currencies ($, Euro, Bitcoin, etc)
  • Physical units (kg, tons, etc)
  • Amounts (amount, employees, etc)
  • Percents (%)

There is an option to adjust the number of decimal places. For quicker understanding of big numbers there is an option to divide every three digits separate thousands: with a space (30000 vs 30 000).

Data node can be populated with data either manually or by importing data from the other spreadsheet formats.

Read further about data node here Link to Data node (pending)

Formula node

Formula node is a place where you can perform math operations on your data stored in data nodes. The following operations are available: +, -, /, , (), X^y, sqrt(x), x/y, ∑, ∏, lg, ln. Another operation you can do in formula node is “if .. then .. else .. *” cycle.

Formula node has input connections from one or more Data nodes. It operates with the data from only those Data nodes.

In the formula node there is a built-in “Time” variable. It allows to reference data from previous and subsequent columns. The limitation of Formula node is that it is not capable of processing Python code. For that you have got a Python node.

Python node

Python node has a built-in python code editor. Here you can use the full power of Python for tasks which can not be solved in Formula node. Probably you may find nested loops one of the main advantages of using Python nodes.