How to translate excel coding into matlab?
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
0 commentaires
Réponse acceptée
Image Analyst
le 23 Nov 2016
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
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets 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!