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).