Cross Correlation analysis with two series of wavelets

[MrSak87]

Hey all,

This one will be a tough one to explain...

I essentially have 3 columns of data and 40000+ rows of it. Column A measures seconds from time 0 to say 10. Column B is a series of values creating on a graph wavelets from a source detected by receiver one and Column C is the same series of wavelets detected by receiver two. The two receivers are relatively closely spaced apart and therefore the profiles of these waves will be very similar although NOT identical. The spacing between the wavelets also changes due to the density of the soil/rock they travel throughThe aim is for excel to detect the peaks of each correlating wave and detect the lag time between the two series at each source. An example of a lag between two wavelets is shown

https://www.google.co.uk/search?q=w...o.com%2Fcalculator-timedelayphase.htm;365;152

This lag time calculation (column 4!?) allows me to do all the statistical analysis for my job. The traditional way is to manually pick the peaks using ancient software but this simply isn't feasible with the amount of data I have.

My VB ability is marginally better than just recording but only slightly.

Please help!
Sean

 

[oldbrewer]

show us the raw data that produces a wave - my first thought, if there is enough data, is to detect the max value and take the average of it and say 10 data values either side

 

[MrSak87]

Seconds x1 x2
[TABLE="width: 274"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]-5.87E-05[/TD]
[TD="align: right"]-1.00E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.000417[/TD]
[TD="align: right"]-1.05E-05[/TD]
[TD="align: right"]-2.16E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.000833[/TD]
[TD="align: right"]4.64E-07[/TD]
[TD="align: right"]-1.61E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.00125[/TD]
[TD="align: right"]-5.53E-06[/TD]
[TD="align: right"]-2.32E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.001667[/TD]
[TD="align: right"]-4.74E-06[/TD]
[TD="align: right"]-2.16E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.002083[/TD]
[TD="align: right"]-6.32E-06[/TD]
[TD="align: right"]-2.21E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0025[/TD]
[TD="align: right"]2.38E-06[/TD]
[TD="align: right"]-9.34E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.002917[/TD]
[TD="align: right"]2.43E-05[/TD]
[TD="align: right"]2.88E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.003333[/TD]
[TD="align: right"]2.85E-05[/TD]
[TD="align: right"]4.73E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.00375[/TD]
[TD="align: right"]2.64E-05[/TD]
[TD="align: right"]4.24E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.004167[/TD]
[TD="align: right"]3.66E-05[/TD]
[TD="align: right"]5.96E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.004583[/TD]
[TD="align: right"]3.98E-05[/TD]
[TD="align: right"]7.17E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.005[/TD]
[TD="align: right"]4.37E-05[/TD]
[TD="align: right"]7.63E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.005417[/TD]
[TD="align: right"]5.28E-05[/TD]
[TD="align: right"]8.52E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.005833[/TD]
[TD="align: right"]5.39E-05[/TD]
[TD="align: right"]8.75E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.00625[/TD]
[TD="align: right"]5.18E-05[/TD]
[TD="align: right"]8.56E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.006667[/TD]
[TD="align: right"]5.28E-05[/TD]
[TD="align: right"]8.54E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.007083[/TD]
[TD="align: right"]5.40E-05[/TD]
[TD="align: right"]9.17E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0075[/TD]
[TD="align: right"]5.90E-05[/TD]
[TD="align: right"]9.97E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.007917[/TD]
[TD="align: right"]1.08E-04[/TD]
[TD="align: right"]1.60E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.008333[/TD]
[TD="align: right"]1.45E-04[/TD]
[TD="align: right"]1.99E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.00875[/TD]
[TD="align: right"]1.39E-04[/TD]
[TD="align: right"]1.99E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.009167[/TD]
[TD="align: right"]1.36E-04[/TD]
[TD="align: right"]1.80E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.009583[/TD]
[TD="align: right"]1.30E-04[/TD]
[TD="align: right"]1.80E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.01[/TD]
[TD="align: right"]1.16E-04[/TD]
[TD="align: right"]1.54E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.010417[/TD]
[TD="align: right"]6.84E-05[/TD]
[TD="align: right"]7.92E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.010833[/TD]
[TD="align: right"]6.07E-05[/TD]
[TD="align: right"]6.89E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.01125[/TD]
[TD="align: right"]6.62E-05[/TD]
[TD="align: right"]8.04E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.011667[/TD]
[TD="align: right"]6.45E-05[/TD]
[TD="align: right"]7.60E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.012083[/TD]
[TD="align: right"]6.16E-05[/TD]
[TD="align: right"]7.48E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0125[/TD]
[TD="align: right"]5.05E-05[/TD]
[TD="align: right"]5.67E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.012917[/TD]
[TD="align: right"]2.93E-05[/TD]
[TD="align: right"]2.13E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.013333[/TD]
[TD="align: right"]1.75E-05[/TD]
[TD="align: right"]-2.09E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.01375[/TD]
[TD="align: right"]2.20E-05[/TD]
[TD="align: right"]2.43E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.014167[/TD]
[TD="align: right"]8.96E-06[/TD]
[TD="align: right"]-1.58E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.014583[/TD]
[TD="align: right"]1.10E-06[/TD]
[TD="align: right"]-3.22E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.015[/TD]
[TD="align: right"]-1.89E-06[/TD]
[TD="align: right"]-4.00E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.015417[/TD]
[TD="align: right"]-1.07E-05[/TD]
[TD="align: right"]-4.75E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.015833[/TD]
[TD="align: right"]-1.69E-05[/TD]
[TD="align: right"]-4.91E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.01625[/TD]
[TD="align: right"]-1.32E-05[/TD]
[TD="align: right"]-4.71E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.016667[/TD]
[TD="align: right"]-1.58E-05[/TD]
[TD="align: right"]-4.91E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.017083[/TD]
[TD="align: right"]-2.13E-05[/TD]
[TD="align: right"]-5.86E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0175[/TD]
[TD="align: right"]-2.92E-05[/TD]
[TD="align: right"]-6.76E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.017917[/TD]
[TD="align: right"]-8.34E-05[/TD]
[TD="align: right"]-1.38E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.018333[/TD]
[TD="align: right"]-1.14E-04[/TD]
[TD="align: right"]-1.75E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.01875[/TD]
[TD="align: right"]-1.12E-04[/TD]
[TD="align: right"]-1.26E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.019167[/TD]
[TD="align: right"]-6.75E-05[/TD]
[TD="align: right"]-1.33E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.019583[/TD]
[TD="align: right"]-9.43E-05[/TD]
[TD="align: right"]-1.21E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.02[/TD]
[TD="align: right"]-7.51E-05[/TD]
[TD="align: right"]-1.01E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.020417[/TD]
[TD="align: right"]-4.83E-05[/TD]
[TD="align: right"]-4.70E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.020833[/TD]
[TD="align: right"]-3.14E-05[/TD]
[TD="align: right"]-2.24E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.02125[/TD]
[TD="align: right"]-4.12E-05[/TD]
[TD="align: right"]-3.68E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.021667[/TD]
[TD="align: right"]-3.43E-05[/TD]
[TD="align: right"]-3.13E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.022083[/TD]
[TD="align: right"]-3.65E-05[/TD]
[TD="align: right"]-3.23E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0225[/TD]
[TD="align: right"]-3.42E-05[/TD]
[TD="align: right"]-2.28E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.022917[/TD]
[TD="align: right"]-1.72E-05[/TD]
[TD="align: right"]1.71E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.023333[/TD]
[TD="align: right"]-1.95E-06[/TD]
[TD="align: right"]3.21E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.02375[/TD]
[TD="align: right"]-5.21E-06[/TD]
[TD="align: right"]2.40E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.024167[/TD]
[TD="align: right"]7.12E-06[/TD]
[TD="align: right"]3.62E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.024583[/TD]
[TD="align: right"]1.91E-05[/TD]
[TD="align: right"]5.31E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.025[/TD]
[TD="align: right"]2.52E-05[/TD]
[TD="align: right"]5.70E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.025417[/TD]
[TD="align: right"]3.56E-05[/TD]
[TD="align: right"]6.15E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.025833[/TD]
[TD="align: right"]3.97E-05[/TD]
[TD="align: right"]5.74E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.02625[/TD]
[TD="align: right"]3.76E-05[/TD]
[TD="align: right"]5.69E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.026667[/TD]
[TD="align: right"]4.27E-05[/TD]
[TD="align: right"]5.82E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.027083[/TD]
[TD="align: right"]5.11E-05[/TD]
[TD="align: right"]6.80E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0275[/TD]
[TD="align: right"]5.87E-05[/TD]
[TD="align: right"]7.57E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.027917[/TD]
[TD="align: right"]1.05E-04[/TD]
[TD="align: right"]1.29E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.028333[/TD]
[TD="align: right"]1.49E-04[/TD]
[TD="align: right"]1.81E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.02875[/TD]
[TD="align: right"]1.41E-04[/TD]
[TD="align: right"]1.70E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.029167[/TD]
[TD="align: right"]1.40E-04[/TD]
[TD="align: right"]1.70E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.029583[/TD]
[TD="align: right"]1.41E-04[/TD]
[TD="align: right"]1.66E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.03[/TD]
[TD="align: right"]1.27E-04[/TD]
[TD="align: right"]1.43E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.030417[/TD]
[TD="align: right"]9.39E-05[/TD]
[TD="align: right"]8.50E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.030833[/TD]
[TD="align: right"]8.17E-05[/TD]
[TD="align: right"]7.44E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.03125[/TD]
[TD="align: right"]8.67E-05[/TD]
[TD="align: right"]8.38E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.031667[/TD]
[TD="align: right"]8.48E-05[/TD]
[TD="align: right"]8.61E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.032083[/TD]
[TD="align: right"]8.74E-05[/TD]
[TD="align: right"]8.60E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0325[/TD]
[TD="align: right"]8.33E-05[/TD]
[TD="align: right"]7.90E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.032917[/TD]
[TD="align: right"]7.50E-05[/TD]
[TD="align: right"]5.40E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.033333[/TD]
[TD="align: right"]6.36E-05[/TD]
[TD="align: right"]2.61E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.03375[/TD]
[TD="align: right"]6.23E-05[/TD]
[TD="align: right"]3.00E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.034167[/TD]
[TD="align: right"]5.24E-05[/TD]
[TD="align: right"]1.50E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.034583[/TD]
[TD="align: right"]4.81E-05[/TD]
[TD="align: right"]2.19E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.035[/TD]
[TD="align: right"]3.70E-05[/TD]
[TD="align: right"]-2.96E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.035417[/TD]
[TD="align: right"]3.02E-05[/TD]
[TD="align: right"]-5.15E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.035833[/TD]
[TD="align: right"]2.32E-05[/TD]
[TD="align: right"]-3.19E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.03625[/TD]
[TD="align: right"]2.56E-05[/TD]
[TD="align: right"]3.55E-07[/TD]
[/TR]
[TR]
[TD="align: right"]0.036667[/TD]
[TD="align: right"]2.18E-05[/TD]
[TD="align: right"]1.55E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.037083[/TD]
[TD="align: right"]1.80E-05[/TD]
[TD="align: right"]-2.66E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.0375[/TD]
[TD="align: right"]1.01E-05[/TD]
[TD="align: right"]-1.41E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.037917[/TD]
[TD="align: right"]-5.43E-05[/TD]
[TD="align: right"]-9.54E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.038333[/TD]
[TD="align: right"]-6.99E-05[/TD]
[TD="align: right"]-1.13E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.03875[/TD]
[TD="align: right"]-6.85E-05[/TD]
[TD="align: right"]-1.07E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.039167[/TD]
[TD="align: right"]-6.75E-05[/TD]
[TD="align: right"]-1.03E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.039583[/TD]
[TD="align: right"]-6.48E-05[/TD]
[TD="align: right"]-9.57E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.04[/TD]
[TD="align: right"]-5.21E-05[/TD]
[TD="align: right"]-6.97E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.040417[/TD]
[TD="align: right"]-1.66E-05[/TD]
[TD="align: right"]-8.30E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.040833[/TD]
[TD="align: right"]-7.11E-06[/TD]
[TD="align: right"]1.10E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.04125[/TD]
[TD="align: right"]-9.89E-06[/TD]
[TD="align: right"]-5.37E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.041667[/TD]
[TD="align: right"]-1.06E-05[/TD]
[TD="align: right"]-7.34E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.042083[/TD]
[TD="align: right"]-1.41E-05[/TD]
[TD="align: right"]-1.01E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0425[/TD]
[TD="align: right"]-6.71E-06[/TD]
[TD="align: right"]4.14E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.042917[/TD]
[TD="align: right"]6.25E-08[/TD]
[TD="align: right"]2.92E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.043333[/TD]
[TD="align: right"]7.30E-06[/TD]
[TD="align: right"]5.10E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.04375[/TD]
[TD="align: right"]8.75E-06[/TD]
[TD="align: right"]4.48E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.044167[/TD]
[TD="align: right"]1.70E-05[/TD]
[TD="align: right"]5.52E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.044583[/TD]
[TD="align: right"]1.98E-05[/TD]
[TD="align: right"]6.75E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.045[/TD]
[TD="align: right"]2.63E-05[/TD]
[TD="align: right"]7.14E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.045417[/TD]
[TD="align: right"]3.58E-05[/TD]
[TD="align: right"]7.56E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.045833[/TD]
[TD="align: right"]3.74E-05[/TD]
[TD="align: right"]6.91E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.04625[/TD]
[TD="align: right"]3.74E-05[/TD]
[TD="align: right"]6.47E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.046667[/TD]
[TD="align: right"]4.09E-05[/TD]
[TD="align: right"]6.02E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.047083[/TD]
[TD="align: right"]5.32E-05[/TD]
[TD="align: right"]6.52E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0475[/TD]
[TD="align: right"]6.87E-05[/TD]
[TD="align: right"]7.24E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.047917[/TD]
[TD="align: right"]1.31E-04[/TD]
[TD="align: right"]1.35E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.048333[/TD]
[TD="align: right"]1.76E-04[/TD]
[TD="align: right"]1.76E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.04875[/TD]
[TD="align: right"]1.72E-04[/TD]
[TD="align: right"]1.63E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.049167[/TD]
[TD="align: right"]1.68E-04[/TD]
[TD="align: right"]1.61E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.049583[/TD]
[TD="align: right"]1.57E-04[/TD]
[TD="align: right"]1.52E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.05[/TD]
[TD="align: right"]1.37E-04[/TD]
[TD="align: right"]1.33E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.050417[/TD]
[TD="align: right"]9.06E-05[/TD]
[TD="align: right"]7.19E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.050833[/TD]
[TD="align: right"]6.81E-05[/TD]
[TD="align: right"]6.91E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.05125[/TD]
[TD="align: right"]6.81E-05[/TD]
[TD="align: right"]9.16E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.051667[/TD]
[TD="align: right"]6.27E-05[/TD]
[TD="align: right"]1.04E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.052083[/TD]
[TD="align: right"]5.57E-05[/TD]
[TD="align: right"]1.10E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.0525[/TD]
[TD="align: right"]3.63E-05[/TD]
[TD="align: right"]8.89E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.052917[/TD]
[TD="align: right"]1.58E-05[/TD]
[TD="align: right"]4.87E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.053333[/TD]
[TD="align: right"]8.46E-06[/TD]
[TD="align: right"]1.64E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.05375[/TD]
[TD="align: right"]1.13E-05[/TD]
[TD="align: right"]1.98E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.054167[/TD]
[TD="align: right"]1.13E-05[/TD]
[TD="align: right"]1.71E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.054583[/TD]
[TD="align: right"]2.28E-05[/TD]
[TD="align: right"]-1.23E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.055[/TD]
[TD="align: right"]2.99E-05[/TD]
[TD="align: right"]-1.81E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.055417[/TD]
[TD="align: right"]3.27E-05[/TD]
[TD="align: right"]-2.28E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.055833[/TD]
[TD="align: right"]3.74E-05[/TD]
[TD="align: right"]-2.92E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.05625[/TD]
[TD="align: right"]4.59E-05[/TD]
[TD="align: right"]-3.58E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.056667[/TD]
[TD="align: right"]5.21E-05[/TD]
[TD="align: right"]-3.75E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.057083[/TD]
[TD="align: right"]5.88E-05[/TD]
[TD="align: right"]-4.37E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0575[/TD]
[TD="align: right"]6.03E-05[/TD]
[TD="align: right"]-4.56E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.057917[/TD]
[TD="align: right"]1.30E-05[/TD]
[TD="align: right"]-9.69E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.058333[/TD]
[TD="align: right"]-3.01E-05[/TD]
[TD="align: right"]-1.25E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.05875[/TD]
[TD="align: right"]-3.79E-05[/TD]
[TD="align: right"]-1.02E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.059167[/TD]
[TD="align: right"]-6.36E-05[/TD]
[TD="align: right"]-9.18E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.059583[/TD]
[TD="align: right"]-8.66E-05[/TD]
[TD="align: right"]-7.56E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.06[/TD]
[TD="align: right"]-1.01E-04[/TD]
[TD="align: right"]-4.96E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.060417[/TD]
[TD="align: right"]-8.71E-05[/TD]
[TD="align: right"]2.29E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.060833[/TD]
[TD="align: right"]-9.01E-05[/TD]
[TD="align: right"]4.24E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.06125[/TD]
[TD="align: right"]-1.03E-04[/TD]
[TD="align: right"]3.17E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.061667[/TD]
[TD="align: right"]-1.12E-04[/TD]
[TD="align: right"]2.52E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.062083[/TD]
[TD="align: right"]-1.21E-04[/TD]
[TD="align: right"]8.89E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.0625[/TD]
[TD="align: right"]-1.24E-04[/TD]
[TD="align: right"]-7.00E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.062917[/TD]
[TD="align: right"]-1.11E-04[/TD]
[TD="align: right"]3.93E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.063333[/TD]
[TD="align: right"]-1.07E-04[/TD]
[TD="align: right"]-4.31E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.06375[/TD]
[TD="align: right"]-9.72E-05[/TD]
[TD="align: right"]-2.73E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.064167[/TD]
[TD="align: right"]-7.35E-05[/TD]
[TD="align: right"]-2.44E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.064583[/TD]
[TD="align: right"]-5.09E-05[/TD]
[TD="align: right"]-1.46E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.065[/TD]
[TD="align: right"]-2.99E-05[/TD]
[TD="align: right"]-1.21E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.065417[/TD]
[TD="align: right"]-1.64E-05[/TD]
[TD="align: right"]-1.50E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.065833[/TD]
[TD="align: right"]-1.42E-05[/TD]
[TD="align: right"]-2.74E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.06625[/TD]
[TD="align: right"]-1.62E-05[/TD]
[TD="align: right"]-3.41E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.066667[/TD]
[TD="align: right"]-1.78E-05[/TD]
[TD="align: right"]-3.41E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.067083[/TD]
[TD="align: right"]-9.77E-06[/TD]
[TD="align: right"]-1.65E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0675[/TD]
[TD="align: right"]2.99E-06[/TD]
[TD="align: right"]6.24E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.067917[/TD]
[TD="align: right"]5.31E-05[/TD]
[TD="align: right"]8.11E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.068333[/TD]
[TD="align: right"]1.01E-04[/TD]
[TD="align: right"]1.45E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.06875[/TD]
[TD="align: right"]9.30E-05[/TD]
[TD="align: right"]1.41E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.069167[/TD]
[TD="align: right"]9.13E-05[/TD]
[TD="align: right"]1.42E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.069583[/TD]
[TD="align: right"]8.50E-05[/TD]
[TD="align: right"]1.26E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.07[/TD]
[TD="align: right"]7.06E-05[/TD]
[TD="align: right"]1.03E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.070417[/TD]
[TD="align: right"]3.97E-05[/TD]
[TD="align: right"]3.95E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.070833[/TD]
[TD="align: right"]3.97E-05[/TD]
[TD="align: right"]3.43E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.07125[/TD]
[TD="align: right"]5.80E-05[/TD]
[TD="align: right"]5.52E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.071667[/TD]
[TD="align: right"]7.04E-05[/TD]
[TD="align: right"]5.92E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.072083[/TD]
[TD="align: right"]7.43E-05[/TD]
[TD="align: right"]5.59E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0725[/TD]
[TD="align: right"]7.38E-05[/TD]
[TD="align: right"]3.49E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.072917[/TD]
[TD="align: right"]5.84E-05[/TD]
[TD="align: right"]-8.99E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.073333[/TD]
[TD="align: right"]6.91E-05[/TD]
[TD="align: right"]-2.55E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.07375[/TD]
[TD="align: right"]8.75E-05[/TD]
[TD="align: right"]-1.27E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.074167[/TD]
[TD="align: right"]9.86E-05[/TD]
[TD="align: right"]-1.90E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.074583[/TD]
[TD="align: right"]1.09E-04[/TD]
[TD="align: right"]-2.13E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.075[/TD]
[TD="align: right"]1.20E-04[/TD]
[TD="align: right"]-1.69E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.075417[/TD]
[TD="align: right"]1.20E-04[/TD]
[TD="align: right"]-1.35E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.075833[/TD]
[TD="align: right"]1.20E-04[/TD]
[TD="align: right"]-5.45E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.07625[/TD]
[TD="align: right"]1.27E-04[/TD]
[TD="align: right"]3.02E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.076667[/TD]
[TD="align: right"]1.30E-04[/TD]
[TD="align: right"]9.92E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.077083[/TD]
[TD="align: right"]1.30E-04[/TD]
[TD="align: right"]1.34E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0775[/TD]
[TD="align: right"]1.27E-04[/TD]
[TD="align: right"]2.26E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.077917[/TD]
[TD="align: right"]7.65E-05[/TD]
[TD="align: right"]-2.46E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.078333[/TD]
[TD="align: right"]3.20E-05[/TD]
[TD="align: right"]-5.72E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.07875[/TD]
[TD="align: right"]2.71E-05[/TD]
[TD="align: right"]-3.99E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.079167[/TD]
[TD="align: right"]8.17E-06[/TD]
[TD="align: right"]-3.56E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.079583[/TD]
[TD="align: right"]-1.37E-07[/TD]
[TD="align: right"]-2.47E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.08[/TD]
[TD="align: right"]5.73E-06[/TD]
[TD="align: right"]4.25E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.080417[/TD]
[TD="align: right"]4.17E-05[/TD]
[TD="align: right"]7.24E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.080833[/TD]
[TD="align: right"]5.02E-05[/TD]
[TD="align: right"]8.53E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.08125[/TD]
[TD="align: right"]3.78E-05[/TD]
[TD="align: right"]7.21E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.081667[/TD]
[TD="align: right"]2.81E-05[/TD]
[TD="align: right"]6.80E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.082083[/TD]
[TD="align: right"]1.36E-05[/TD]
[TD="align: right"]6.02E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0825[/TD]
[TD="align: right"]5.94E-06[/TD]
[TD="align: right"]6.35E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.082917[/TD]
[TD="align: right"]9.02E-06[/TD]
[TD="align: right"]9.83E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.083333[/TD]
[TD="align: right"]2.33E-06[/TD]
[TD="align: right"]1.13E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.08375[/TD]
[TD="align: right"]-2.20E-06[/TD]
[TD="align: right"]9.83E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.084167[/TD]
[TD="align: right"]3.62E-06[/TD]
[TD="align: right"]1.08E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.084583[/TD]
[TD="align: right"]3.91E-06[/TD]
[TD="align: right"]1.11E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.085[/TD]
[TD="align: right"]3.76E-06[/TD]
[TD="align: right"]1.08E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.085417[/TD]
[TD="align: right"]1.52E-06[/TD]
[TD="align: right"]9.89E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.085833[/TD]
[TD="align: right"]-7.79E-06[/TD]
[TD="align: right"]8.30E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.08625[/TD]
[TD="align: right"]-2.08E-05[/TD]
[TD="align: right"]6.92E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.086667[/TD]
[TD="align: right"]-2.47E-05[/TD]
[TD="align: right"]5.99E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.087083[/TD]
[TD="align: right"]-3.02E-05[/TD]
[TD="align: right"]6.28E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0875[/TD]
[TD="align: right"]-2.91E-05[/TD]
[TD="align: right"]6.58E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.087917[/TD]
[TD="align: right"]1.53E-05[/TD]
[TD="align: right"]1.19E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.088333[/TD]
[TD="align: right"]5.31E-05[/TD]
[TD="align: right"]1.60E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.08875[/TD]
[TD="align: right"]3.94E-05[/TD]
[TD="align: right"]1.31E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.089167[/TD]
[TD="align: right"]3.74E-05[/TD]
[TD="align: right"]1.21E-04[/TD]
[/TR]
[TR]
[TD="align: right"]0.089583[/TD]
[TD="align: right"]3.74E-05[/TD]
[TD="align: right"]9.89E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.09[/TD]
[TD="align: right"]3.10E-05[/TD]
[TD="align: right"]6.90E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.090417[/TD]
[TD="align: right"]1.12E-06[/TD]
[TD="align: right"]-6.51E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.090833[/TD]
[TD="align: right"]7.02E-06[/TD]
[TD="align: right"]-1.85E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.09125[/TD]
[TD="align: right"]2.86E-05[/TD]
[TD="align: right"]-3.42E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.091667[/TD]
[TD="align: right"]4.07E-05[/TD]
[TD="align: right"]3.16E-07[/TD]
[/TR]
[TR]
[TD="align: right"]0.092083[/TD]
[TD="align: right"]5.32E-05[/TD]
[TD="align: right"]7.17E-08[/TD]
[/TR]
[TR]
[TD="align: right"]0.0925[/TD]
[TD="align: right"]5.77E-05[/TD]
[TD="align: right"]-1.32E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.092917[/TD]
[TD="align: right"]4.67E-05[/TD]
[TD="align: right"]-4.77E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.093333[/TD]
[TD="align: right"]5.19E-05[/TD]
[TD="align: right"]-5.85E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.09375[/TD]
[TD="align: right"]6.39E-05[/TD]
[TD="align: right"]-4.37E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.094167[/TD]
[TD="align: right"]6.50E-05[/TD]
[TD="align: right"]-4.44E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.094583[/TD]
[TD="align: right"]6.47E-05[/TD]
[TD="align: right"]-4.77E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.095[/TD]
[TD="align: right"]5.75E-05[/TD]
[TD="align: right"]-3.81E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.095417[/TD]
[TD="align: right"]4.84E-05[/TD]
[TD="align: right"]-3.27E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.095833[/TD]
[TD="align: right"]4.23E-05[/TD]
[TD="align: right"]-1.81E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.09625[/TD]
[TD="align: right"]4.97E-05[/TD]
[TD="align: right"]-3.87E-06[/TD]
[/TR]
[TR]
[TD="align: right"]0.096667[/TD]
[TD="align: right"]5.77E-05[/TD]
[TD="align: right"]1.04E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.097083[/TD]
[TD="align: right"]6.76E-05[/TD]
[TD="align: right"]1.27E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.0975[/TD]
[TD="align: right"]7.43E-05[/TD]
[TD="align: right"]1.14E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.097917[/TD]
[TD="align: right"]3.52E-05[/TD]
[TD="align: right"]-4.99E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.098333[/TD]
[TD="align: right"]1.42E-05[/TD]
[TD="align: right"]-9.43E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.09875[/TD]
[TD="align: right"]3.72E-05[/TD]
[TD="align: right"]-8.13E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.099167[/TD]
[TD="align: right"]5.16E-05[/TD]
[TD="align: right"]-8.16E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.099583[/TD]
[TD="align: right"]6.85E-05[/TD]
[TD="align: right"]-6.28E-05[/TD]
[/TR]
[TR]
[TD="align: right"]0.1[/TD]
[TD="align: right"]8.66E-05[/TD]
[TD="align: right"]-3.01E-05[/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

I plotted the data and the peak from the last column is higher, but both peak widths are the same. What info would you like. I do not think it is possible to detect any lag between the peaks hitting a maximum because there are very few data points maybe 5 that define the peak

 

[MrSak87]

Sorry my apologies, I pasted the top of the data then went home after work. The top of the data doesn't show anything really. This shows a bit more. Peak or trough is required. So in this data set the troughs would be appropriate

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, align: right"]3.495[/TD]
[TD="width: 64, align: right"]0.003115[/TD]
[TD="width: 64, align: right"]0.001985[/TD]
[/TR]
[TR]
[TD="align: right"]3.495417[/TD]
[TD="align: right"]0.003294[/TD]
[TD="align: right"]0.001946[/TD]
[/TR]
[TR]
[TD="align: right"]3.495833[/TD]
[TD="align: right"]0.003429[/TD]
[TD="align: right"]0.001883[/TD]
[/TR]
[TR]
[TD="align: right"]3.49625[/TD]
[TD="align: right"]0.003548[/TD]
[TD="align: right"]0.001806[/TD]
[/TR]
[TR]
[TD="align: right"]3.496667[/TD]
[TD="align: right"]0.003639[/TD]
[TD="align: right"]0.00173[/TD]
[/TR]
[TR]
[TD="align: right"]3.497083[/TD]
[TD="align: right"]0.003709[/TD]
[TD="align: right"]0.001679[/TD]
[/TR]
[TR]
[TD="align: right"]3.4975[/TD]
[TD="align: right"]0.00374[/TD]
[TD="align: right"]0.001686[/TD]
[/TR]
[TR]
[TD="align: right"]3.497917[/TD]
[TD="align: right"]0.003703[/TD]
[TD="align: right"]0.001711[/TD]
[/TR]
[TR]
[TD="align: right"]3.498333[/TD]
[TD="align: right"]0.003556[/TD]
[TD="align: right"]0.001727[/TD]
[/TR]
[TR]
[TD="align: right"]3.49875[/TD]
[TD="align: right"]0.003412[/TD]
[TD="align: right"]0.00184[/TD]
[/TR]
[TR]
[TD="align: right"]3.499167[/TD]
[TD="align: right"]0.003209[/TD]
[TD="align: right"]0.00191[/TD]
[/TR]
[TR]
[TD="align: right"]3.499583[/TD]
[TD="align: right"]0.002988[/TD]
[TD="align: right"]0.00197[/TD]
[/TR]
[TR]
[TD="align: right"]3.5[/TD]
[TD="align: right"]0.002736[/TD]
[TD="align: right"]0.002007[/TD]
[/TR]
[TR]
[TD="align: right"]3.500417[/TD]
[TD="align: right"]0.002539[/TD]
[TD="align: right"]0.002056[/TD]
[/TR]
[TR]
[TD="align: right"]3.500833[/TD]
[TD="align: right"]0.00238[/TD]
[TD="align: right"]0.002056[/TD]
[/TR]
[TR]
[TD="align: right"]3.50125[/TD]
[TD="align: right"]0.002244[/TD]
[TD="align: right"]0.001977[/TD]
[/TR]
[TR]
[TD="align: right"]3.501667[/TD]
[TD="align: right"]0.002132[/TD]
[TD="align: right"]0.001892[/TD]
[/TR]
[TR]
[TD="align: right"]3.502083[/TD]
[TD="align: right"]0.002012[/TD]
[TD="align: right"]0.001765[/TD]
[/TR]
[TR]
[TD="align: right"]3.5025[/TD]
[TD="align: right"]0.001865[/TD]
[TD="align: right"]0.001573[/TD]
[/TR]
[TR]
[TD="align: right"]3.502917[/TD]
[TD="align: right"]0.001694[/TD]
[TD="align: right"]0.001352[/TD]
[/TR]
[TR]
[TD="align: right"]3.503333[/TD]
[TD="align: right"]0.001466[/TD]
[TD="align: right"]0.00108[/TD]
[/TR]
[TR]
[TD="align: right"]3.50375[/TD]
[TD="align: right"]0.001204[/TD]
[TD="align: right"]0.000792[/TD]
[/TR]
[TR]
[TD="align: right"]3.504167[/TD]
[TD="align: right"]0.000926[/TD]
[TD="align: right"]0.000546[/TD]
[/TR]
[TR]
[TD="align: right"]3.504583[/TD]
[TD="align: right"]0.000611[/TD]
[TD="align: right"]0.000363[/TD]
[/TR]
[TR]
[TD="align: right"]3.505[/TD]
[TD="align: right"]0.000216[/TD]
[TD="align: right"]0.000193[/TD]
[/TR]
[TR]
[TD="align: right"]3.505417[/TD]
[TD="align: right"]-0.00027[/TD]
[TD="align: right"]1.13E-05[/TD]
[/TR]
[TR]
[TD="align: right"]3.505833[/TD]
[TD="align: right"]-0.00083[/TD]
[TD="align: right"]-0.0002[/TD]
[/TR]
[TR]
[TD="align: right"]3.50625[/TD]
[TD="align: right"]-0.00146[/TD]
[TD="align: right"]-0.00044[/TD]
[/TR]
[TR]
[TD="align: right"]3.506667[/TD]
[TD="align: right"]-0.0021[/TD]
[TD="align: right"]-0.0007[/TD]
[/TR]
[TR]
[TD="align: right"]3.507083[/TD]
[TD="align: right"]-0.00272[/TD]
[TD="align: right"]-0.00093[/TD]
[/TR]
[TR]
[TD="align: right"]3.5075[/TD]
[TD="align: right"]-0.0033[/TD]
[TD="align: right"]-0.00116[/TD]
[/TR]
[TR]
[TD="align: right"]3.507917[/TD]
[TD="align: right"]-0.00379[/TD]
[TD="align: right"]-0.00136[/TD]
[/TR]
[TR]
[TD="align: right"]3.508333[/TD]
[TD="align: right"]-0.00414[/TD]
[TD="align: right"]-0.00153[/TD]
[/TR]
[TR]
[TD="align: right"]3.50875[/TD]
[TD="align: right"]-0.00447[/TD]
[TD="align: right"]-0.00182[/TD]
[/TR]
[TR]
[TD="align: right"]3.509167[/TD]
[TD="align: right"]-0.0047[/TD]
[TD="align: right"]-0.00212[/TD]
[/TR]
[TR]
[TD="align: right"]3.509584[/TD]
[TD="align: right"]-0.00487[/TD]
[TD="align: right"]-0.00245[/TD]
[/TR]
[TR]
[TD="align: right"]3.51[/TD]
[TD="align: right"]-0.005[/TD]
[TD="align: right"]-0.00281[/TD]
[/TR]
[TR]
[TD="align: right"]3.510417[/TD]
[TD="align: right"]-0.00507[/TD]
[TD="align: right"]-0.00321[/TD]
[/TR]
[TR]
[TD="align: right"]3.510834[/TD]
[TD="align: right"]-0.00503[/TD]
[TD="align: right"]-0.00353[/TD]
[/TR]
[TR]
[TD="align: right"]3.51125[/TD]
[TD="align: right"]-0.0049[/TD]
[TD="align: right"]-0.00374[/TD]
[/TR]
[TR]
[TD="align: right"]3.511667[/TD]
[TD="align: right"]-0.00471[/TD]
[TD="align: right"]-0.00392[/TD]
[/TR]
[TR]
[TD="align: right"]3.512084[/TD]
[TD="align: right"]-0.00446[/TD]
[TD="align: right"]-0.00408[/TD]
[/TR]
[TR]
[TD="align: right"]3.5125[/TD]
[TD="align: right"]-0.00413[/TD]
[TD="align: right"]-0.00423[/TD]
[/TR]
[TR]
[TD="align: right"]3.512917[/TD]
[TD="align: right"]-0.00377[/TD]
[TD="align: right"]-0.00436[/TD]
[/TR]
[TR]
[TD="align: right"]3.513334[/TD]
[TD="align: right"]-0.00335[/TD]
[TD="align: right"]-0.00441[/TD]
[/TR]
[TR]
[TD="align: right"]3.51375[/TD]
[TD="align: right"]-0.00291[/TD]
[TD="align: right"]-0.00437[/TD]
[/TR]
[TR]
[TD="align: right"]3.514167[/TD]
[TD="align: right"]-0.00247[/TD]
[TD="align: right"]-0.00429[/TD]
[/TR]
[TR]
[TD="align: right"]3.514584[/TD]
[TD="align: right"]-0.00203[/TD]
[TD="align: right"]-0.00419[/TD]
[/TR]
[TR]
[TD="align: right"]3.515[/TD]
[TD="align: right"]-0.00159[/TD]
[TD="align: right"]-0.00403[/TD]
[/TR]
[TR]
[TD="align: right"]3.515417[/TD]
[TD="align: right"]-0.00119[/TD]
[TD="align: right"]-0.00382[/TD]
[/TR]
[TR]
[TD="align: right"]3.515834[/TD]
[TD="align: right"]-0.00081[/TD]
[TD="align: right"]-0.00354[/TD]
[/TR]
[TR]
[TD="align: right"]3.51625[/TD]
[TD="align: right"]-0.00046[/TD]
[TD="align: right"]-0.00321[/TD]
[/TR]
[TR]
[TD="align: right"]3.516667[/TD]
[TD="align: right"]-0.00015[/TD]
[TD="align: right"]-0.00284[/TD]
[/TR]
[TR]
[TD="align: right"]3.517084[/TD]
[TD="align: right"]0.000113[/TD]
[TD="align: right"]-0.00245[/TD]
[/TR]
[TR]
[TD="align: right"]3.5175[/TD]
[TD="align: right"]0.000305[/TD]
[TD="align: right"]-0.00205[/TD]
[/TR]
[TR]
[TD="align: right"]3.517917[/TD]
[TD="align: right"]0.000438[/TD]
[TD="align: right"]-0.00168[/TD]
[/TR]
[TR]
[TD="align: right"]3.518334[/TD]
[TD="align: right"]0.000519[/TD]
[TD="align: right"]-0.00134[/TD]
[/TR]
[TR]
[TD="align: right"]3.51875[/TD]
[TD="align: right"]0.000652[/TD]
[TD="align: right"]-0.00089[/TD]
[/TR]
[TR]
[TD="align: right"]3.519167[/TD]
[TD="align: right"]0.000708[/TD]
[TD="align: right"]-0.00047[/TD]
[/TR]
[TR]
[TD="align: right"]3.519584[/TD]
[TD="align: right"]0.000729[/TD]
[TD="align: right"]-3.4E-05[/TD]
[/TR]
[TR]
[TD="align: right"]3.52[/TD]
[TD="align: right"]0.000687[/TD]
[TD="align: right"]0.000389[/TD]
[/TR]
[TR]
[TD="align: right"]3.520417[/TD]
[TD="align: right"]0.000608[/TD]
[TD="align: right"]0.000794[/TD]
[/TR]
[TR]
[TD="align: right"]3.520834[/TD]
[TD="align: right"]0.000495[/TD]
[TD="align: right"]0.001104[/TD]
[/TR]
[TR]
[TD="align: right"]3.52125[/TD]
[TD="align: right"]0.000324[/TD]
[TD="align: right"]0.001285[/TD]
[/TR]
[TR]
[TD="align: right"]3.521667[/TD]
[TD="align: right"]9.63E-05[/TD]
[TD="align: right"]0.001408[/TD]
[/TR]
[TR]
[TD="align: right"]3.522084[/TD]
[TD="align: right"]-0.00016[/TD]
[TD="align: right"]0.001494[/TD]
[/TR]
[TR]
[TD="align: right"]3.5225[/TD]
[TD="align: right"]-0.00041[/TD]
[TD="align: right"]0.00155[/TD]
[/TR]
[TR]
[TD="align: right"]3.522917[/TD]
[TD="align: right"]-0.00059[/TD]
[TD="align: right"]0.001613[/TD]
[/TR]
[TR]
[TD="align: right"]3.523334[/TD]
[TD="align: right"]-0.00074[/TD]
[TD="align: right"]0.001605[/TD]
[/TR]
[TR]
[TD="align: right"]3.52375[/TD]
[TD="align: right"]-0.0009[/TD]
[TD="align: right"]0.001497[/TD]
[/TR]
[TR]
[TD="align: right"]3.524167[/TD]
[TD="align: right"]-0.00104[/TD]
[TD="align: right"]0.001325[/TD]
[/TR]
[TR]
[TD="align: right"]3.524584[/TD]
[TD="align: right"]-0.00112[/TD]
[TD="align: right"]0.001144[/TD]
[/TR]
[TR]
[TD="align: right"]3.525[/TD]
[TD="align: right"]-0.00117[/TD]
[TD="align: right"]0.000966[/TD]
[/TR]
[TR]
[TD="align: right"]3.525417[/TD]
[TD="align: right"]-0.00117[/TD]
[TD="align: right"]0.000823[/TD]
[/TR]
[TR]
[TD="align: right"]3.525834[/TD]
[TD="align: right"]-0.00108[/TD]
[TD="align: right"]0.000694[/TD]
[/TR]
[TR]
[TD="align: right"]3.52625[/TD]
[TD="align: right"]-0.00091[/TD]
[TD="align: right"]0.000594[/TD]
[/TR]
[TR]
[TD="align: right"]3.526667[/TD]
[TD="align: right"]-0.0007[/TD]
[TD="align: right"]0.000532[/TD]
[/TR]
[TR]
[TD="align: right"]3.527084[/TD]
[TD="align: right"]-0.00048[/TD]
[TD="align: right"]0.000521[/TD]
[/TR]
[TR]
[TD="align: right"]3.5275[/TD]
[TD="align: right"]-0.00025[/TD]
[TD="align: right"]0.000531[/TD]
[/TR]
[TR]
[TD="align: right"]3.527917[/TD]
[TD="align: right"]7.3E-06[/TD]
[TD="align: right"]0.000578[/TD]
[/TR]
[TR]
[TD="align: right"]3.528334[/TD]
[TD="align: right"]0.000349[/TD]
[TD="align: right"]0.000716[/TD]
[/TR]
[TR]
[TD="align: right"]3.52875[/TD]
[TD="align: right"]0.00063[/TD]
[TD="align: right"]0.000816[/TD]
[/TR]
[TR]
[TD="align: right"]3.529167[/TD]
[TD="align: right"]0.000928[/TD]
[TD="align: right"]0.001012[/TD]
[/TR]
[TR]
[TD="align: right"]3.529584[/TD]
[TD="align: right"]0.0012[/TD]
[TD="align: right"]0.001246[/TD]
[/TR]
[TR]
[TD="align: right"]3.53[/TD]
[TD="align: right"]0.001466[/TD]
[TD="align: right"]0.001472[/TD]
[/TR]
[TR]
[TD="align: right"]3.530417[/TD]
[TD="align: right"]0.00167[/TD]
[TD="align: right"]0.001611[/TD]
[/TR]
[TR]
[TD="align: right"]3.530834[/TD]
[TD="align: right"]0.001849[/TD]
[TD="align: right"]0.001731[/TD]
[/TR]
[TR]
[TD="align: right"]3.53125[/TD]
[TD="align: right"]0.002003[/TD]
[TD="align: right"]0.001878[/TD]
[/TR]
[TR]
[TD="align: right"]3.531667[/TD]
[TD="align: right"]0.002096[/TD]
[TD="align: right"]0.001979[/TD]
[/TR]
[TR]
[TD="align: right"]3.532084[/TD]
[TD="align: right"]0.002182[/TD]
[TD="align: right"]0.002091[/TD]
[/TR]
[TR]
[TD="align: right"]3.5325[/TD]
[TD="align: right"]0.002285[/TD]
[TD="align: right"]0.002206[/TD]
[/TR]
[TR]
[TD="align: right"]3.532917[/TD]
[TD="align: right"]0.002406[/TD]
[TD="align: right"]0.002279[/TD]
[/TR]
[TR]
[TD="align: right"]3.533334[/TD]
[TD="align: right"]0.002551[/TD]
[TD="align: right"]0.002348[/TD]
[/TR]
[TR]
[TD="align: right"]3.53375[/TD]
[TD="align: right"]0.002706[/TD]
[TD="align: right"]0.002393[/TD]
[/TR]
[TR]
[TD="align: right"]3.534167[/TD]
[TD="align: right"]0.002852[/TD]
[TD="align: right"]0.002379[/TD]
[/TR]
[TR]
[TD="align: right"]3.534584[/TD]
[TD="align: right"]0.002982[/TD]
[TD="align: right"]0.002315[/TD]
[/TR]
[TR]
[TD="align: right"]3.535[/TD]
[TD="align: right"]0.003103[/TD]
[TD="align: right"]0.002254[/TD]
[/TR]
[TR]
[TD="align: right"]3.535417[/TD]
[TD="align: right"]0.003205[/TD]
[TD="align: right"]0.002189[/TD]
[/TR]
[TR]
[TD="align: right"]3.535834[/TD]
[TD="align: right"]0.003291[/TD]
[TD="align: right"]0.002122[/TD]
[/TR]
[TR]
[TD="align: right"]3.53625[/TD]
[TD="align: right"]0.003371[/TD]
[TD="align: right"]0.002048[/TD]
[/TR]
[TR]
[TD="align: right"]3.536667[/TD]
[TD="align: right"]0.003442[/TD]
[TD="align: right"]0.00195[/TD]
[/TR]
[TR]
[TD="align: right"]3.537084[/TD]
[TD="align: right"]0.003479[/TD]
[TD="align: right"]0.001838[/TD]
[/TR]
[TR]
[TD="align: right"]3.5375[/TD]
[TD="align: right"]0.003489[/TD]
[TD="align: right"]0.001761[/TD]
[/TR]
[TR]
[TD="align: right"]3.537917[/TD]
[TD="align: right"]0.003459[/TD]
[TD="align: right"]0.001702[/TD]
[/TR]
[TR]
[TD="align: right"]3.538334[/TD]
[TD="align: right"]0.003374[/TD]
[TD="align: right"]0.001643[/TD]
[/TR]
[TR]
[TD="align: right"]3.53875[/TD]
[TD="align: right"]0.003342[/TD]
[TD="align: right"]0.00171[/TD]
[/TR]
[TR]
[TD="align: right"]3.539167[/TD]
[TD="align: right"]0.003263[/TD]
[TD="align: right"]0.001756[/TD]
[/TR]
[TR]
[TD="align: right"]3.539584[/TD]
[TD="align: right"]0.003165[/TD]
[TD="align: right"]0.001798[/TD]
[/TR]
[TR]
[TD="align: right"]3.54[/TD]
[TD="align: right"]0.003017[/TD]
[TD="align: right"]0.001825[/TD]
[/TR]
[TR]
[TD="align: right"]3.540417[/TD]
[TD="align: right"]0.002874[/TD]
[TD="align: right"]0.001881[/TD]
[/TR]
[TR]
[TD="align: right"]3.540834[/TD]
[TD="align: right"]0.002682[/TD]
[TD="align: right"]0.001888[/TD]
[/TR]
[TR]
[TD="align: right"]3.54125[/TD]
[TD="align: right"]0.002449[/TD]
[TD="align: right"]0.001827[/TD]
[/TR]
[TR]
[TD="align: right"]3.541667[/TD]
[TD="align: right"]0.00222[/TD]
[TD="align: right"]0.00178[/TD]
[/TR]
[TR]
[TD="align: right"]3.542084[/TD]
[TD="align: right"]0.001999[/TD]
[TD="align: right"]0.001719[/TD]
[/TR]
[TR]
[TD="align: right"]3.5425[/TD]
[TD="align: right"]0.001765[/TD]
[TD="align: right"]0.001628[/TD]
[/TR]
[TR]
[TD="align: right"]3.542917[/TD]
[TD="align: right"]0.001566[/TD]
[TD="align: right"]0.001529[/TD]
[/TR]
[TR]
[TD="align: right"]3.543334[/TD]
[TD="align: right"]0.00135[/TD]
[TD="align: right"]0.001367[/TD]
[/TR]
[TR]
[TD="align: right"]3.54375[/TD]
[TD="align: right"]0.001121[/TD]
[TD="align: right"]0.001136[/TD]
[/TR]
[TR]
[TD="align: right"]3.544167[/TD]
[TD="align: right"]0.00086[/TD]
[TD="align: right"]0.000885[/TD]
[/TR]
[TR]
[TD="align: right"]3.544584[/TD]
[TD="align: right"]0.000536[/TD]
[TD="align: right"]0.000623[/TD]
[/TR]
[TR]
[TD="align: right"]3.545[/TD]
[TD="align: right"]0.000138[/TD]
[TD="align: right"]0.000342[/TD]
[/TR]
[TR]
[TD="align: right"]3.545417[/TD]
[TD="align: right"]-0.00029[/TD]
[TD="align: right"]6.72E-05[/TD]
[/TR]
[TR]
[TD="align: right"]3.545834[/TD]
[TD="align: right"]-0.00077[/TD]
[TD="align: right"]-0.00019[/TD]
[/TR]
[TR]
[TD="align: right"]3.54625[/TD]
[TD="align: right"]-0.00132[/TD]
[TD="align: right"]-0.00044[/TD]
[/TR]
[TR]
[TD="align: right"]3.546667[/TD]
[TD="align: right"]-0.00191[/TD]
[TD="align: right"]-0.00068[/TD]
[/TR]
[TR]
[TD="align: right"]3.547084[/TD]
[TD="align: right"]-0.00251[/TD]
[TD="align: right"]-0.00091[/TD]
[/TR]
[TR]
[TD="align: right"]3.5475[/TD]
[TD="align: right"]-0.00311[/TD]
[TD="align: right"]-0.00115[/TD]
[/TR]
[TR]
[TD="align: right"]3.547917[/TD]
[TD="align: right"]-0.00366[/TD]
[TD="align: right"]-0.00138[/TD]
[/TR]
[TR]
[TD="align: right"]3.548334[/TD]
[TD="align: right"]-0.00412[/TD]
[TD="align: right"]-0.00158[/TD]
[/TR]
[TR]
[TD="align: right"]3.54875[/TD]
[TD="align: right"]-0.00458[/TD]
[TD="align: right"]-0.00188[/TD]
[/TR]
[TR]
[TD="align: right"]3.549167[/TD]
[TD="align: right"]-0.00492[/TD]
[TD="align: right"]-0.00215[/TD]
[/TR]
[TR]
[TD="align: right"]3.549584[/TD]
[TD="align: right"]-0.00515[/TD]
[TD="align: right"]-0.00243[/TD]
[/TR]
[TR]
[TD="align: right"]3.55[/TD]
[TD="align: right"]-0.00526[/TD]
[TD="align: right"]-0.00272[/TD]
[/TR]
[TR]
[TD="align: right"]3.550417[/TD]
[TD="align: right"]-0.00531[/TD]
[TD="align: right"]-0.00307[/TD]
[/TR]
[TR]
[TD="align: right"]3.550834[/TD]
[TD="align: right"]-0.00526[/TD]
[TD="align: right"]-0.00339[/TD]
[/TR]
[TR]
[TD="align: right"]3.55125[/TD]
[TD="align: right"]-0.00508[/TD]
[TD="align: right"]-0.00366[/TD]
[/TR]
[TR]
[TD="align: right"]3.551667[/TD]
[TD="align: right"]-0.00483[/TD]
[TD="align: right"]-0.00394[/TD]
[/TR]
[TR]
[TD="align: right"]3.552084[/TD]
[TD="align: right"]-0.00451[/TD]
[TD="align: right"]-0.00418[/TD]
[/TR]
[TR]
[TD="align: right"]3.5525[/TD]
[TD="align: right"]-0.00415[/TD]
[TD="align: right"]-0.00438[/TD]
[/TR]
[TR]
[TD="align: right"]3.552917[/TD]
[TD="align: right"]-0.00378[/TD]
[TD="align: right"]-0.00454[/TD]
[/TR]
[TR]
[TD="align: right"]3.553334[/TD]
[TD="align: right"]-0.00335[/TD]
[TD="align: right"]-0.00461[/TD]
[/TR]
[TR]
[TD="align: right"]3.55375[/TD]
[TD="align: right"]-0.0029[/TD]
[TD="align: right"]-0.00459[/TD]
[/TR]
[TR]
[TD="align: right"]3.554167[/TD]
[TD="align: right"]-0.00247[/TD]
[TD="align: right"]-0.00451[/TD]
[/TR]
[TR]
[TD="align: right"]3.554584[/TD]
[TD="align: right"]-0.00208[/TD]
[TD="align: right"]-0.0044[/TD]
[/TR]
[TR]
[TD="align: right"]3.555[/TD]
[TD="align: right"]-0.00173[/TD]
[TD="align: right"]-0.00422[/TD]
[/TR]
[TR]
[TD="align: right"]3.555417[/TD]
[TD="align: right"]-0.00141[/TD]
[TD="align: right"]-0.004[/TD]
[/TR]
[TR]
[TD="align: right"]3.555834[/TD]
[TD="align: right"]-0.00108[/TD]
[TD="align: right"]-0.00372[/TD]
[/TR]
[TR]
[TD="align: right"]3.55625[/TD]
[TD="align: right"]-0.00077[/TD]
[TD="align: right"]-0.00338[/TD]
[/TR]
[TR]
[TD="align: right"]3.556667[/TD]
[TD="align: right"]-0.00047[/TD]
[TD="align: right"]-0.00298[/TD]
[/TR]
[TR]
[TD="align: right"]3.557084[/TD]
[TD="align: right"]-0.00019[/TD]
[TD="align: right"]-0.00257[/TD]
[/TR]
[TR]
[TD="align: right"]3.5575[/TD]
[TD="align: right"]8.75E-05[/TD]
[TD="align: right"]-0.00215[/TD]
[/TR]
[TR]
[TD="align: right"]3.557917[/TD]
[TD="align: right"]0.000319[/TD]
[TD="align: right"]-0.00176[/TD]
[/TR]
[TR]
[TD="align: right"]3.558334[/TD]
[TD="align: right"]0.000493[/TD]
[TD="align: right"]-0.00143[/TD]
[/TR]
[TR]
[TD="align: right"]3.55875[/TD]
[TD="align: right"]0.000688[/TD]
[TD="align: right"]-0.00102[/TD]
[/TR]
[TR]
[TD="align: right"]3.559167[/TD]
[TD="align: right"]0.000791[/TD]
[TD="align: right"]-0.00064[/TD]
[/TR]
[TR]
[TD="align: right"]3.559584[/TD]
[TD="align: right"]0.000846[/TD]
[TD="align: right"]-0.00024[/TD]
[/TR]
[TR]
[TD="align: right"]3.56[/TD]
[TD="align: right"]0.000862[/TD]
[TD="align: right"]0.000145[/TD]
[/TR]
[TR]
[TD="align: right"]3.560417[/TD]
[TD="align: right"]0.000833[/TD]
[TD="align: right"]0.000543[/TD]
[/TR]
[TR]
[TD="align: right"]3.560834[/TD]
[TD="align: right"]0.000738[/TD]
[TD="align: right"]0.000879[/TD]
[/TR]
[TR]
[TD="align: right"]3.56125[/TD]
[TD="align: right"]0.00056[/TD]
[TD="align: right"]0.001115[/TD]
[/TR]
[TR]
[TD="align: right"]3.561667[/TD]
[TD="align: right"]0.000355[/TD]
[TD="align: right"]0.001324[/TD]
[/TR]
[TR]
[TD="align: right"]3.562084[/TD]
[TD="align: right"]0.000147[/TD]
[TD="align: right"]0.001476[/TD]
[/TR]
[TR]
[TD="align: right"]3.5625[/TD]
[TD="align: right"]-7.3E-05[/TD]
[TD="align: right"]0.001586[/TD]
[/TR]
[TR]
[TD="align: right"]3.562917[/TD]
[TD="align: right"]-0.00027[/TD]
[TD="align: right"]0.001671[/TD]
[/TR]
[TR]
[TD="align: right"]3.563334[/TD]
[TD="align: right"]-0.00046[/TD]
[TD="align: right"]0.001679[/TD]
[/TR]
[TR]
[TD="align: right"]3.56375[/TD]
[TD="align: right"]-0.00065[/TD]
[TD="align: right"]0.0016[/TD]
[/TR]
[TR]
[TD="align: right"]3.564167[/TD]
[TD="align: right"]-0.00079[/TD]
[TD="align: right"]0.001485[/TD]
[/TR]
[TR]
[TD="align: right"]3.564584[/TD]
[TD="align: right"]-0.00087[/TD]
[TD="align: right"]0.00136[/TD]
[/TR]
[TR]
[TD="align: right"]3.565[/TD]
[TD="align: right"]-0.00092[/TD]
[TD="align: right"]0.001206[/TD]
[/TR]
[TR]
[TD="align: right"]3.565417[/TD]
[TD="align: right"]-0.00092[/TD]
[TD="align: right"]0.001057[/TD]
[/TR]
[TR]
[TD="align: right"]3.565834[/TD]
[TD="align: right"]-0.00089[/TD]
[TD="align: right"]0.000903[/TD]
[/TR]
[TR]
[TD="align: right"]3.56625[/TD]
[TD="align: right"]-0.00085[/TD]
[TD="align: right"]0.000769[/TD]
[/TR]
[TR]
[TD="align: right"]3.566667[/TD]
[TD="align: right"]-0.00079[/TD]
[TD="align: right"]0.000657[/TD]
[/TR]
[TR]
[TD="align: right"]3.567084[/TD]
[TD="align: right"]-0.00072[/TD]
[TD="align: right"]0.000595[/TD]
[/TR]
[TR]
[TD="align: right"]3.5675[/TD]
[TD="align: right"]-0.00064[/TD]
[TD="align: right"]0.000576[/TD]
[/TR]
[TR]
[TD="align: right"]3.567917[/TD]
[TD="align: right"]-0.00049[/TD]
[TD="align: right"]0.000638[/TD]
[/TR]
[TR]
[TD="align: right"]3.568334[/TD]
[TD="align: right"]-0.00021[/TD]
[TD="align: right"]0.000808[/TD]
[/TR]
[TR]
[TD="align: right"]3.56875[/TD]
[TD="align: right"]4.79E-05[/TD]
[TD="align: right"]0.000932[/TD]
[/TR]
[TR]
[TD="align: right"]3.569167[/TD]
[TD="align: right"]0.000385[/TD]
[TD="align: right"]0.001122[/TD]
[/TR]
[TR]
[TD="align: right"]3.569584[/TD]
[TD="align: right"]0.00077[/TD]
[TD="align: right"]0.001288[/TD]
[/TR]
[TR]
[TD="align: right"]3.57[/TD]
[TD="align: right"]0.001197[/TD]
[TD="align: right"]0.001422[/TD]
[/TR]
[TR]
[TD="align: right"]3.570417[/TD]
[TD="align: right"]0.001565[/TD]
[TD="align: right"]0.001463[/TD]
[/TR]
[TR]
[TD="align: right"]3.570834[/TD]
[TD="align: right"]0.001884[/TD]
[TD="align: right"]0.001503[/TD]
[/TR]
[TR]
[TD="align: right"]3.57125[/TD]
[TD="align: right"]0.002141[/TD]
[TD="align: right"]0.001604[/TD]
[/TR]
[TR]
[TD="align: right"]3.571667[/TD]
[TD="align: right"]0.002322[/TD]
[TD="align: right"]0.001716[/TD]
[/TR]
[TR]
[TD="align: right"]3.572084[/TD]
[TD="align: right"]0.002467[/TD]
[TD="align: right"]0.001869[/TD]
[/TR]
[TR]
[TD="align: right"]3.5725[/TD]
[TD="align: right"]0.002583[/TD]
[TD="align: right"]0.002053[/TD]
[/TR]
[TR]
[TD="align: right"]3.572917[/TD]
[TD="align: right"]0.00265[/TD]
[TD="align: right"]0.002205[/TD]
[/TR]
[TR]
[TD="align: right"]3.573334[/TD]
[TD="align: right"]0.002726[/TD]
[TD="align: right"]0.002355[/TD]
[/TR]
[TR]
[TD="align: right"]3.57375[/TD]
[TD="align: right"]0.002815[/TD]
[TD="align: right"]0.002467[/TD]
[/TR]
</tbody>[/TABLE]


Is the kind of thing I'm looking for possible? Cheers for your reply

 

[oldbrewer]

I used conditional formatting to find all the minima in cols B and C using =and(b2<b1,b2<b3)

are you interested in the time difference between each pair of minima or the minimum value itself

PM me if you want to continue off line as I think there is nothing fundamental of interest to the general forum readers

 

[shg]

Uisng formulas, you can see that the correlation of the first 150 samples of W1 peaks with a 5-sample delay to W2:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr]
[tr][td]

1​

[/td][td]

T​

[/td][td]

W1​

[/td][td]

W2​

[/td][td]

​

[/td][td]

Offset​

[/td][td]

​

[/td][td]

​

[/td][/tr]

[tr][td]

2​

[/td][td]

3.4950​

[/td][td]

0.0031​

[/td][td]

0.0020​

[/td][td][/td][td]

0​

[/td][td]

0.825​

[/td][td]F2: =CORREL($B$2:$B$151, INDEX($C$2:$C$191, E2 + 1):INDEX($C$2:$C$191, E2 + 150))[/td][/tr]

[tr][td]

3​

[/td][td]

3.4954​

[/td][td]

0.0033​

[/td][td]

0.0019​

[/td][td][/td][td]

1​

[/td][td]

0.856​

[/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

3.4958​

[/td][td]

0.0034​

[/td][td]

0.0019​

[/td][td][/td][td]

2​

[/td][td]

0.882​

[/td][td][/td][/tr]

[tr][td]

5​

[/td][td]

3.4963​

[/td][td]

0.0035​

[/td][td]

0.0018​

[/td][td][/td][td]

3​

[/td][td]

0.902​

[/td][td][/td][/tr]

[tr][td]

6​

[/td][td]

3.4967​

[/td][td]

0.0036​

[/td][td]

0.0017​

[/td][td][/td][td]

4​

[/td][td]

0.916​

[/td][td][/td][/tr]

[tr][td]

7​

[/td][td]

3.4971​

[/td][td]

0.0037​

[/td][td]

0.0017​

[/td][td][/td][td]

5​

[/td][td]

0.923​

[/td][td][/td][/tr]

[tr][td]

8​

[/td][td]

3.4975​

[/td][td]

0.0037​

[/td][td]

0.0017​

[/td][td][/td][td]

6​

[/td][td]

0.921​

[/td][td][/td][/tr]

[tr][td]

9​

[/td][td]

3.4979​

[/td][td]

0.0037​

[/td][td]

0.0017​

[/td][td][/td][td]

7​

[/td][td]

0.910​

[/td][td][/td][/tr]

[tr][td]

10​

[/td][td]

3.4983​

[/td][td]

0.0036​

[/td][td]

0.0017​

[/td][td][/td][td]

8​

[/td][td]

0.890​

[/td][td][/td][/tr]

[tr][td]

11​

[/td][td]

3.4988​

[/td][td]

0.0034​

[/td][td]

0.0018​

[/td][td][/td][td]

9​

[/td][td]

0.859​

[/td][td][/td][/tr]

[tr][td]

12​

[/td][td]

3.4992​

[/td][td]

0.0032​

[/td][td]

0.0019​

[/td][td][/td][td]

10​

[/td][td]

0.819​

[/td][td][/td][/tr]

[tr][td]

13​

[/td][td]

3.4996​

[/td][td]

0.0030​

[/td][td]

0.0020​

[/td][td][/td][td]

11​

[/td][td]

0.769​

[/td][td][/td][/tr]

[tr][td]

14​

[/td][td]

3.5000​

[/td][td]

0.0027​

[/td][td]

0.0020​

[/td][td][/td][td]

12​

[/td][td]

0.710​

[/td][td][/td][/tr]

[tr][td]

15​

[/td][td]

3.5004​

[/td][td]

0.0025​

[/td][td]

0.0021​

[/td][td][/td][td]

13​

[/td][td]

0.644​

[/td][td][/td][/tr]

[tr][td]

16​

[/td][td]

3.5008​

[/td][td]

0.0024​

[/td][td]

0.0021​

[/td][td][/td][td]

14​

[/td][td]

0.570​

[/td][td][/td][/tr]

[tr][td]

17​

[/td][td]

3.5013​

[/td][td]

0.0022​

[/td][td]

0.0020​

[/td][td][/td][td]

15​

[/td][td]

0.490​

[/td][td][/td][/tr]

[tr][td]

18​

[/td][td]

3.5017​

[/td][td]

0.0021​

[/td][td]

0.0019​

[/td][td][/td][td]

16​

[/td][td]

0.405​

[/td][td][/td][/tr]

[tr][td]

19​

[/td][td]

3.5021​

[/td][td]

0.0020​

[/td][td]

0.0018​

[/td][td][/td][td]

17​

[/td][td]

0.317​

[/td][td][/td][/tr]

[tr][td]

20​

[/td][td]

3.5025​

[/td][td]

0.0019​

[/td][td]

0.0016​

[/td][td][/td][td]

18​

[/td][td]

0.226​

[/td][td][/td][/tr]

[tr][td]

21​

[/td][td]

3.5029​

[/td][td]

0.0017​

[/td][td]

0.0014​

[/td][td][/td][td]

19​

[/td][td]

0.135​

[/td][td][/td][/tr]

[tr][td]

22​

[/td][td]

3.5033​

[/td][td]

0.0015​

[/td][td]

0.0011​

[/td][td][/td][td]

20​

[/td][td]

0.044​

[/td][td][/td][/tr]

[tr][td]

23​

[/td][td]

3.5038​

[/td][td]

0.0012​

[/td][td]

0.0008​

[/td][td][/td][td]

21​

[/td][td]

-0.045​

[/td][td][/td][/tr]

[tr][td]

24​

[/td][td]

3.5042​

[/td][td]

0.0009​

[/td][td]

0.0005​

[/td][td][/td][td]

22​

[/td][td]

-0.130​

[/td][td][/td][/tr]

[tr][td]

25​

[/td][td]

3.5046​

[/td][td]

0.0006​

[/td][td]

0.0004​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

26​

[/td][td]

3.5050​

[/td][td]

0.0002​

[/td][td]

0.0002​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

27​

[/td][td]

3.5054​

[/td][td]

-0.0003​

[/td][td]

0.0000​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

28​

[/td][td]

3.5058​

[/td][td]

-0.0008​

[/td][td]

-0.0002​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

29​

[/td][td]

3.5063​

[/td][td]

-0.0015​

[/td][td]

-0.0004​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

30​

[/td][td]

3.5067​

[/td][td]

-0.0021​

[/td][td]

-0.0007​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

31​

[/td][td]

3.5071​

[/td][td]

-0.0027​

[/td][td]

-0.0009​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

32​

[/td][td]

3.5075​

[/td][td]

-0.0033​

[/td][td]

-0.0012​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

33​

[/td][td]

3.5079​

[/td][td]

-0.0038​

[/td][td]

-0.0014​

[/td][td][/td][td][/td][td][/td][td][/td][/tr]
[/table]

 

[shg]

EDIT: For the first set of data, which has smaller time values, the correlation peak is at 0 offset. Maybe a better test is to see what time dilation of W1 is a best fit for W2. Does that make sense?

 

[MrSak87]

shg, I've not tried this yet but this is EXACTLY what I'm looking for!! Makes perfect sense I'll get back to you

 

[MrSak87]

Works perfectly! Thank you, you've no idea how much time I've spent trying to figure this out.

What do you mean by time dilation? Do you mean the amount of time change between the two waves as if one was stretched? If so how would I go about this?