how to calculate RMS of excel sheet having multiple channel
11 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Pralhad Uttam
le 22 Déc 2021
Commenté : Mathieu NOE
le 22 Déc 2021
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z
0 commentaires
Réponse acceptée
Mathieu NOE
le 22 Déc 2021
Modifié(e) : Mathieu NOE
le 22 Déc 2021
hello
see demo code below with attached excel file
I assumed the data are column oriented
the rms values are stored in array : col_rms
clc
clearvars
T = readmatrix('data_demo.xlsx');
time = T(:,1);
data = T(:,2:end);
col_rms = my_col_rms(data);
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
function col_rms = my_col_rms(data)
[m,n] = size(data);
for ci = 1:n
col_rms(1,ci) = sqrt(mean(data(:,ci).^2));
end
end
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Predictive Maintenance Toolbox 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!