Skip to main content
14-Alexandrite
May 20, 2021
Solved

sort data (periodic)

  • May 20, 2021
  • 2 replies
  • 3667 views

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:

Capture d’écran 2021-05-20 094611.png

 

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

Best answer by terryhendicott

Hi,

Here it is using only Prime.

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

Cheers

Terry

2 replies

21-Topaz II
May 20, 2021

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.

Capture.JPG

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.

Capture2.JPG

Cheers

Terry

24-Ruby III
May 20, 2021

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

 

Pic-1.png

XDN14-AlexandriteAuthor
14-Alexandrite
May 20, 2021

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

XDN14-AlexandriteAuthor
14-Alexandrite
May 20, 2021

Capture d’écran 2021-05-20 114014.png

 

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

but I would have liked use only prime.