Amplitude spectrum from Excel

Good day

I have an excel file with the acceleration of x y z axis of a runing shaft and i want to do the amplitude spectrum of these acceleration so how can i do it?

Here is the link to excel file

https://wutwaw-my.sharepoint.com/:x:/g/personal/01136536_pw_edu_pl/EQ4fGklBm-RIkMxWzZ_eG_ABBF4gi7uPVxFzH33Tr91tug?e=GmSUUI

Answer 1

[Dinesh Yadav]

Hi Anton

Kindly refer to the following link on how to read data from excel file into MATLAB.

Below is the code to replicate the amplitude spectrum as shown in excel file.

T = readtable('file.xlsx','Sheet',2);
t = T.AccelerationX_Time_;
x = T.AccelerationX;
y = T.AccelerationY;
z = T.AccelerationZ;
plot(t,x,t,y,t,z);

Hope it Helps.