MATLAB Answers

How do I set multiple columns as the same variable?

22 views (last 30 days)
Jack Lewis
Jack Lewis on 3 Dec 2020
Commented: Jack Lewis on 4 Dec 2020
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.


Sign in to comment.

Accepted Answer

Alan Stevens
Alan Stevens on 3 Dec 2020
Have you tried
UT = xlsread(velocity data.xlsx, 'A3:X2883');
or whatever, the overall range values are.
Power= 0.5*rho*A*cp*UT.^3;
columnSums = sum(Power);

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by