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
Solved! Go to Solution.
Hi,
Here it is using only Prime.
You will need to change the path of the READEXCEL function of course.
Cheers
Terry
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
"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.".
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
It's ok if i make a sort with excel, and manipulate data with prime.
but I would have liked use only prime.
Hi,
Here it is using only Prime.
You will need to change the path of the READEXCEL function of course.
Cheers
Terry