how to calculate RMS of excel sheet having multiple channel
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Pralhad Uttam
il 22 Dic 2021
Commentato: Mathieu NOE
il 22 Dic 2021
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z
0 Commenti
Risposta accettata
Mathieu NOE
il 22 Dic 2021
Modificato: Mathieu NOE
il 22 Dic 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 Commenti
Più risposte (0)
Vedere anche
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!