Hi all 😀
I have a data group from excel
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
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)
Solved! Go to Solution.
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.
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