how to calculate RMS of excel sheet having multiple channel
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Pralhad Uttam
am 22 Dez. 2021
Kommentiert: Mathieu NOE
am 22 Dez. 2021
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z
0 Kommentare
Akzeptierte Antwort
Mathieu NOE
am 22 Dez. 2021
Bearbeitet: Mathieu NOE
am 22 Dez. 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 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu MATLAB Coder finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!