Synchronizing wall thickness and force data with different time formats in MATLAB

1 reply · 4K views · last reply
Nusc
Messages
752
Reaction score
2
Attached are three figures. The problem in question essentially involves extracting data from a .CSV (MS Excel) file and .mdb (MS Access) file which I have done already but not correctly.

Data set #1: gives me 'Wall Thickness vs. Time' ( [3400 - 8200] s , [0,1] in.) as shown in figure3.jpg.
Data set #2: gives me 'Force vs. Time' ( [ 0 - 17,000] lbs. , [3.8x10^4, 3.86x10^4] s) as shown in figure2.jpg

figure1.jpg is the figure that plots both at the same time. In the Wall Thickness vs. Time graph, I had only selected the first step function within figure3.jpg.

Physically we expected that higher wall thickness requires higher drag force. The idea is to prove this correlation.

The issue is with the time format in MATLAB. I cannot synchronize them together.

I hope that is clear.

Thanks for your help,
 
Attachments
  • Two stacked MATLAB plots: top, Wall Thickness vs. Time as a step function rising from 0.4 to 0.75 then dropping; bottom, Raw Data for Pull Test showing Drag Force (lbs) vs. Time with force rising to about 15000 lbs.
    figure1.jpg
    24.9 KB · Views: 665
  • Line graph titled Raw Data for Pull Test @ 1 m/s, showing Drag Force (lbs) against Time from 10:36 AM to 10:46 AM; force stays near zero, rises to about 18,000 with fluctuations, then drops back to zero near 10:41 AM.
    figure2.jpg
    35.8 KB · Views: 677
  • Line plot titled Wall Thickness vs. Time, with time 3000 to 9000 on the x-axis and wall thickness 0 to 0.8 on the y-axis; a step-shaped blue trace shows spikes near 0.6 to 0.75 and a baseline near 0.33.
    figure3.jpg
    14.2 KB · Views: 692
One data set is measured over the time interval [3400, 8200] whereas the other is over the interval [38000, 38600]. Why would you expect them to be synchronized?