how to calculate RMS of excel sheet having multiple channel

8 次查看(过去 30 天)
I want to calculate RMS of sheet having nine channel
Example
Time Floor Vibration X Floor Vibration Y Floor Vibration Z

采纳的回答

Mathieu NOE
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

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Predictive Maintenance Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by