how to synchronize all array ?(attached mathcad file)

[Mathcad111]

is there any inbuilt function to synchronize all the array so that i will get something like (given picture"file name: output.png")?

[-MFra-]

Hi,

Synchronizing seems excessive to me, but it is possible to average:

[Mathcad111]

please ask if you don't understand my question..

[Mathcad111]

thanks for modification can please upload in mathcad file instead of picture ?

[-MFra-]

Hi,

I did this analysis to see if something particular came out. But there is not. So it does not seem useful. However I attach the file.
  Greetings FM

[Werner_E]

You will have to explain what exactly you mean by "synchronize" and how the plot you show in your picture should be derived from the data you provide.

If averaging as shown by FM is what you are after, it can be done that way, too:

[Mathcad111]

i have uploaded new files check once. 

[LucMeekes]

See if this helps.

Success!
Luc

[Mathcad111]

thank you for reply, but have problem with "min" function 

[LucMeekes]

Create Nans this way:

Nans:=0

Nans[ORIGIN,ORIGIN+cols(Data)-1:=0

Nans:=Nans+NaN

Success!
Luc

[Mathcad111]

i could not able to insert this symbol "["

in this line "Nans [ ORIGIN,ORIGIN+cols(Data)-1:=0"

[LucMeekes]

Try this.

Essentially what the Equalize routine does is take away the (assumed !!) slope of every trace.

From the result it can be seen that that assumption may be wrong.

Success!
Luc

[Mathcad111]

thanks a lot but i have to check this...!!!

[Mathcad111]

why we can't able to sync. at center ?

[LucMeekes]

That is possible too, but I guess that your graphs will diverge at the endpoints then.

I think the graphs are the result of a repeated measurement of some phenomenon, and that the measurements suffer from a non-constant 'offset'. It is not constant over the horizontal axis, and not constantly in- or decreasing (linear), so it is 'warped' in a more complex way. It may be quadratic or higher order, it may be exponential. I think you have to work that out before you can successfully 'align' these graphs.

In addition I wonder if the starting point for each of these graphs is the same with respect to the phenomenon that you are investigating.

Success!
Luc

[Mathcad111]

yes the graph is not a constant offset, but only some channels (or cols of data) is miss matched. i wonder how to do that linearization in middle part of graph ?      

[LucMeekes]

Here's a sheet with the EqualizeAt function. It allows you to select a point (on the x-axis) where all graphs (y-values) must be equal (to the average of all graphs at that point).

I've set it to the middle (133) but you can change it to any value from ORIGIN to ORIGIN+rows(Data)-1.

Success!
Luc

[Mathcad111]

thank you but instead of selecting only one point in x-axis ('r') and solving this problem, why can't we set a linear line (i'm mean a straight line) and why can't we optimize or sync. according to that ?   (i'm not sure it maybe work or not)

[LucMeekes]

Sure! That is what the (first) Equalise function does. But it chose then first and last points of the x-axis variable. And you were able to see how warped the graphs are...

Luc

[Mathcad111]

sorry for late response, so we cannot achieve exact result like i have mention in the figure "output_2" ?

[LucMeekes]

Not, unless you have information on how to 'unwarp' the measured traces. As demonstrated, assuming a linear in/de-crease (or less) does not suffice.

Success!
Luc

[Werner_E · Accepted solution]

Comparing the two curves with index 9 (red) and 10 (green): How would an "equalization program" decide that the red increasing at 100 is wrong and should be decreasing like the green curve?