how to calculate RMS of excel sheet having multiple channel

11 vues (au cours des 30 derniers jours)
Pralhad Uttam
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

Réponse acceptée

Mathieu NOE
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
Pralhad Uttam
Pralhad Uttam le 22 Déc 2021
Thank You Sir
Mathieu NOE
Mathieu NOE le 22 Déc 2021
My pleasure !
would yu accept my answer ?
tx

Connectez-vous pour commenter.

Plus de réponses (0)

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!

Translated by