How do I set multiple columns as the same variable?
23 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Alan Stevens
le 3 Déc 2020
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);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Matrix Indexing dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!