sort data (periodic)

[XDN]

Hi all 😀

I have a data group from excel

to understand:

the 1st column is : Torque

the 2 column is : Position

the 3 column velocity: Torque

If i make a drawing with Torque (vertical Y axis)  and position (horizontal  X axis), i have this:

I see  i have periodic data :

in position , approximately from 50 to 2250 milimeter.

this is OK, the data relate to a cylinder which makes round trips

My problem:

How to extract data in new matrix wich include only data for one stroke:

submatrix for positionning

50 to 2250

and submatrix for positionning

2250 to 50

and that for the 5 back and forth

I want to make a drawing for forth (torque and velocity)

and back (torque and velocity)

Thanks

[terryhendicott]

Hi

The answer lies in some Excel data analysis.

Position is a linear change from a common low and common high point of 50 and 2200 respectively.

You can filter the data that goes from 1 to 639 points on 50 and 2200 to get the positions to break up the submatrices on two and fro.  The numbers in blue show you what row indices to use to split the data.

Cheers

Terry

[VladimirN]

"submatrix(A, ir, jr, ic, jc) - returns the submatrix of array A consisting of elements in rows ir through jr and columns ic through jc of A.".

[XDN]

is there a solution that uses only Prime ?

Because, i want to make some calculation with this data and finally I increase the graph with regression or smoothing algorithm for example

[XDN]

It's ok if i make a sort with excel, and manipulate data with prime.

but I would have liked use only prime.

[terryhendicott · Accepted solution]

Hi,

Here it is using only Prime.

You will need to change the path of the READEXCEL function of course.

Cheers

Terry