how to calculate RMS of excel sheet having multiple channel
8 views (last 30 days)
Show older comments
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
0 Comments
Accepted Answer
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
2 Comments
More Answers (0)
See Also
Categories
Find more on Predictive Maintenance Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!