How do I set multiple columns as the same variable?
23 次查看(过去 30 天)
显示 更早的评论
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.
0 个评论
采纳的回答
Alan Stevens
2020-12-3
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);
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!