How to translate excel coding into matlab?

I'm having hard time figuring out how to write an operation for this which I can do in excel.

N1=sum(h4:h23)/20,
N2=(19*n1 +TR2)/20,
N3=(19*n2 +TR3)/20,
N4=(19*n3 +TR4)/20

Where TR comes from another column.

Thanks

Answer 1

[Image Analyst]

You need to read the data into MATLAB with xlsread() or readtable(). Then extract the appropriate column into variables h and TR, and define n1, n2, and n3:

numbers = xlsread(filename);
h = numbers(:, 8); % Or whatever.
TR = numbers(:, 9); % or wherever it is....
n1 = 1; % Whatever it is.
n2 = 2; % Whatever it is.
n3 = 3; % Whatever it is.
N1=sum(h(4:23))/20
N2=(19*n1 +TR(2))/20
N3=(19*n2 +TR(3))/20
N4=(19*n3 +TR(4))/20

[liu James]

I would like to do it automatically as I have over 1680 rows to do, is there a way to do it without writing it all out? Thanks.