Skip to main content
F
FDS13-Aquamarine
13-Aquamarine
December 2, 2015
Solved

Is it possible to improve this worksheet

  • December 2, 2015
  • 7 replies
  • 2515 views

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?

Best answer by Werner_E

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().

7 replies

V
ValeryOchkov24-Ruby IV
24-Ruby IV
December 2, 2015

I think better to use medfit not line function

W
Werner_E25-Diamond I
25-Diamond I
December 3, 2015

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

F
FDS13-AquamarineAuthor
13-Aquamarine
December 3, 2015

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.

W
Werner_E25-Diamond IAnswer
25-Diamond I
December 3, 2015

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().

Terms & ConditionsAccessibility statement