How do I set multiple columns as the same variable?

Hello,

I am currently trying to calulate the power produced using data from 26 seperate points. Each column represents a data collection point with data recorded over a period of 2880 timestamps. At the moment I am assigning each coloum to its own variable using: (UT1 is velocity for turbine 1)

UT1 = xlsread(velocity data.xlsx, 'B3:B2883')

and inputting it into the power equation as shown:

Power= 0.5*rho*A*cp*UT1.^3

This returns the power for each timestamp but only for one column. Is there an easier way to calulate this without having to do every collumn individually? I would then want to collect the overall sum of each column, will I have to do this individually or is there an easier way?

Any help would be much appreciated, thanks.

Answer 1

[Alan Stevens]

Have you tried

UT = xlsread(velocity data.xlsx, 'A3:X2883');

or whatever, the overall range values are.

Then

Power= 0.5*rho*A*cp*UT.^3;
columnSums = sum(Power);

[Jack Lewis]

Awesome, Cheers Alan