With JExcel PRO, you can make simple calculations / relations between the columns.

To create a calculated column click the icon  of any column (1) and select this option (2).



After clicking on it, you will see a dialog where you can


After clicking on "Create", you will see the column created:



You can always change the formula of it by clicking here (2).

Or delete the whole column by clicking here (3).