converting an excel formula into matlab

Question

C.G. 2021-8-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/899227-converting-an-excel-formula-into-matlab

评论： C.G. 2021-8-16

C-RMSfluctuation.xlsx

I've written the formulas out that I require in excel, but now I want to put these into matlab.

The current matlab code I have is below, but I am struggling to convert column D in my excel file to code in matlab. Could anybody help?

resV = sqrt(vel(:,1).^2 +vel(:,2).^2 + vel(:,3).^2);
time = 1:1935804;
time = time';
GT = resV-mean(resV);
GT2 = GT.^2;
RMS = sqrt(

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Wan Ji 2021-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/899227-converting-an-excel-formula-into-matlab#answer_768122

Hi, friend, I have translated your excel function to matlab command line.

clc;clear
a = readtable('C-RMSfluctuation.xlsx','PreserveVariableNames',true);
cols = a.Properties.VariableNames;
a{:,cols{3}} = a{:,cols{2}}.^2;
a{:,cols{4}} = sqrt(cumsum(a{:,cols{3}})./a{:,cols{1}});
writetable(a,'C-RMSfluctuation_New.xlsx') % strore the result in a new xlsx file

The result table is shown like this

2 个评论
显示无隐藏无

Wan Ji 2021-8-16

If you want to totally implement your idea with matlab, then:

resV = sqrt(vel(:,1).^2 +vel(:,2).^2 + vel(:,3).^2);
time = 1:1935804;
time = time';
GT = resV-mean(resV);
GT2 = GT.^2;
col_4 = sqrt(cumsum(GT2)./time);
a = table(time, col_4);
writetable(a,'NewTable.xlsx')

C.G. 2021-8-16

Thank you, your code worked well!

请先登录，再进行评论。

Answer 2

dpb 2021-8-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/899227-converting-an-excel-formula-into-matlab#answer_768107

resV = vecnorm(vel,2,2);            % 2-norm by row
time = 1:1935804.';                 % dunno what time represents, use a timetable instead, maybe?
GT = detrend(resV);                 % again, use MATLAB-supplied function
RMS = rms(GT);                      % and yet again, builtin guessing is what wanted rms of...

It's daunting to find all the functions that are available initially, granted...just takes some time.

The venerable lookfor command is still valuable if you have an idea of what you want but don't know the name...