topic sort data (periodic) in Mathcad

sort data (periodic)

XDN — Thu, 20 May 2021 07:57:20 GMT

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

Re: sort data (periodic)

terryhendicott — Thu, 20 May 2021 09:13:36 GMT

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

Re: sort data (periodic)

VladimirN — Thu, 20 May 2021 09:17:08 GMT

"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.".

Re: sort data (periodic)

XDN — Thu, 20 May 2021 09:27:51 GMT

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

Re: sort data (periodic)

XDN — Thu, 20 May 2021 09:43:20 GMT

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

but I would have liked use only prime.

Re: sort data (periodic)

terryhendicott — Thu, 20 May 2021 09:51:10 GMT

Hi,

Here it is using only Prime.

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

Cheers

Terry