Findings experimental values closest to the setpoint value

Hi there,
I will try to explain the issue I am having to the best of my ability (I have also attached an example excel for clarity). Essentially, in my experiment, I am trying to analyze the loads achieved at specific angles based on setpoint angles I am feeding the actuator (each case has different setpoints but in the case I am introducing here, the setpoints go from -50 to 10). There are two actuators in this example that I am testing (Compu1 and Compu2) (there are actually about 50 overall I’m testing but in this example, there are 2), each with a different achieved angle value and its equavlient load measurement. What I am trying to have Matlab do is export the load value of that actuator that best represents the neareast achieved angle based on the set point fed into it.

Reason for that, is that when I plot the loads achieved of the two actuators, my X axis (set point angle) will have ranging values for each individual actuator so I’m trying to essentially "normalize" the data based on my set "angles to plot" column in excel (increment of 0.1 degrees) and I would want matlab to just export the nearest value to that column so that each actuator can be properly plotted together against the same X range for direct comparsion.

I hope that made sense. Again, this example only includes 2 actutors but I would appreciate it if the solution can be tailored towards an X number of actuators.
Thanks so much in advance!Hi there,
I will try to explain the issue I am having to the best of my ability (I have also attached an example excel for clarity). Essentially, in my experiment, I am trying to analyze the loads achieved at specific angles based on setpoint angles I am feeding the actuator (each case has different setpoints but in the case I am introducing here, the setpoints go from -50 to 10). There are two actuators in this example that I am testing (Compu1 and Compu2) (there are actually about 50 overall I’m testing but in this example, there are 2), each with a different achieved angle value and its equavlient load measurement. What I am trying to have Matlab do is export the load value of that actuator that best represents the neareast achieved angle based on the set point fed into it.

I hope that made sense. Again, this example only includes 2 actutors but I would appreciate it if the solution can be tailored towards an X number of actuators.
Thanks so much in advance! Hi there,
I will try to explain the issue I am having to the best of my ability (I have also attached an example excel for clarity). Essentially, in my experiment, I am trying to analyze the loads achieved at specific angles based on setpoint angles I am feeding the actuator (each case has different setpoints but in the case I am introducing here, the setpoints go from -50 to 10). There are two actuators in this example that I am testing (Compu1 and Compu2) (there are actually about 50 overall I’m testing but in this example, there are 2), each with a different achieved angle value and its equavlient load measurement. What I am trying to have Matlab do is export the load value of that actuator that best represents the neareast achieved angle based on the set point fed into it.

Cart

Cart