Is it possible to improve this worksheet

[FDS]

I have a worksheet where I want to create a score on basis of a certain RPM. However, the number of RPM can differ depending on the duration of the experiment. In the worksheet I only have 4 different RPM but it can go as high as 8. Is it possible to write a program that automatically, based upon the number of different RPM, would give a number starting with 0 for the lowest RPM and increase the score by 1 for each increase in RPM?

[ValeryOchkov]

I think better to use medfit not line function

[Werner_E]

Are you looking for something like this:

BTW, you may also use line() instead of linefit. It may be more convenient to get slope and intercept.

WE

[FDS]

Werner, thank you for your reply. However, your approach does not give a score to each RPM. I have added the worksheet so you can see the difference.

[Werner_E · Accepted solution]

Yes, you are right. I was too quickly glancing over your routine in my first attempt - sorry.

I was not taking into account, that you are looking for values inbetween two RPM values.

This should do the job, though:

Regards

Werner

EDIT: I changed the routine so that you don't have to call it twice later and showed how to use line() instead of linefit().

[FDS]

Werner, thanks that is exactly what I was looking for. I appreciate your tutoring.

[Werner_E]

You are welcome.

I just noticed, that you could access the data value more natural using the two matrix indices and that in Mathcad we can combine the two inequalities into one using standard math notation.

[FDS]

Thanks, that is indeed more natural.