Calculate acceleration from velocity and time fron excel
73 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Wayne
am 20 Apr. 2020
Kommentiert: Fabio Freschi
am 20 Apr. 2020
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 Kommentare
Akzeptierte Antwort
Fabio Freschi
am 20 Apr. 2020
Bearbeitet: Fabio Freschi
am 20 Apr. 2020
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;
5 Kommentare
Fabio Freschi
am 20 Apr. 2020
acceleration is the time derivative of velocity. diff(Velocity)./diff(Time) is the derivative in a discrete setting
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!