Appending calculated rows in a table problem

In a typical In financial model, we have:

• financial months as columns

• “data” rows imported from some application.

• “calc” rows which are formula driven.

calculated-rows.xlsx

In the attached excel file, in “input” sheet, we have the “data” rows:

We need to append and calculate some “calc” rows as shown in “output” sheet as below:

How to do this in Knime? Any lead or solution would be very helpful.

Regards,

Ajit