how to calculate RMS of excel sheet having multiple channel
6 次查看(过去 30 天)
显示 更早的评论
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z
0 个评论
采纳的回答
Mathieu NOE
2021-12-22
编辑:Mathieu NOE
2021-12-22
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 个评论
更多回答(0 个)
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!