how to calculate RMS of excel sheet having multiple channel

3 views (last 30 days)
Pralhad Uttam
Pralhad Uttam on 22 Dec 2021
Commented: Mathieu NOE on 22 Dec 2021
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z

Accepted Answer

Mathieu NOE
Mathieu NOE on 22 Dec 2021
Edited: Mathieu NOE on 22 Dec 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

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by