how to calculate RMS of excel sheet having multiple channel

I want to calculate RMS of sheet having nine channel

Example

Time Floor Vibration X Floor Vibration Y Floor Vibration Z

Answer 1

[Mathieu NOE]

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

[Pralhad Uttam]

Thank You Sir

[Mathieu NOE]

My pleasure !

would yu accept my answer ?

tx