Excel Calculated Fields

Excel tables allow for automatic extension of formulas down wards to match the number of value rows.

A simple Excel table needs a single header row containing unique values followed by at least 1 row of input values and formulas referencing some of the input values on the same row.  Headers can be nonsense like a series of numbers or letters if you can't discern meaningful labels for them.

Import some sample data then construct your formulas to the right of the data.  The formulas should reference cell(s) on the same row using row-wise relative references (i.e. without a $ sign before the row number so you can drag the formulas down).  Make sure your formulas are returning correct results.  You can reference other formula cells on the same row too.

Press Ctrl + T to create and Excel table.  Select all but the first row of your data/formula cells, right-click and Delete... Table rows.  Clear the first row of imported data and tidy your formulas to suppress error display if necessary.

Save this as your template.

Import new data to your import area and formulas in the calculated area should extend down to match the import rows.

This should meet you need but I recommend you research Excel tables to explore structured referencing where you can replace cell references with named references which are easier to read.