Calculate acceleration from velocity and time fron excel

53 次查看（过去 30 天）

Wayne 2020-4-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519238-calculate-acceleration-from-velocity-and-time-fron-excel

评论： Fabio Freschi 2020-4-20

Hi I have an excel sheet with Velocity and Time columns for each step. I need help to input this excel sheet and add a 3rd column with acceleration data.

For example: (Input)

Time (s) Velocity (m/s)

0 50

1 51

2... 52...

For example: (Required Output)

T (s) V (m/s) Acceleration (dV/T)(m/s^2)

0 50 (50-0)/0

1 51 (51-50)/1

2... 52... (52-51)/2

I've used the following to read the Excel

filename='Example.xlsx';

[filepath,name,ext] = fileparts(filename) ;

data = readtable(filename);

N = length(data.t);

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

请先登录，再进行评论。

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

采纳的回答

Fabio Freschi 2020-4-20

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/519238-calculate-acceleration-from-velocity-and-time-fron-excel#answer_427044

编辑：Fabio Freschi 2020-4-20

在 MATLAB Online 中打开

acceleration = diff(data.Velocity)./diff(data.Time);

Note that this vector has one entry less than the original ones, so you may be interested in creating a new vector of time at the mid point of each time interval

tt = (data.Time(1:end-1)+data.Time(2:end))/2;