Greetings!
I have a assignment where i have to solve a non-linear level measurement with the use of trend line. I have a tank table showing liters on different levels.
The level is close to linear up to about half the tank, then it flats out more and more. I was not able to make a 2nd polynomial scaling that worked in all of the curve.
If i split the table in two on the middle, and run a polynomial trend line of the two halves seperatly i got something that worked on the entire tank. Minus the very lowest and highest points (doesnt matter, filter that out)
If tank level is below half, run the ladder formula with first set of coefficients and constant, if over half run the second set in the ladder formula.
Is this a efficient solution or am i overthinking this? Whats your best practice for non-linear scaling?
I have a assignment where i have to solve a non-linear level measurement with the use of trend line. I have a tank table showing liters on different levels.
The level is close to linear up to about half the tank, then it flats out more and more. I was not able to make a 2nd polynomial scaling that worked in all of the curve.
If i split the table in two on the middle, and run a polynomial trend line of the two halves seperatly i got something that worked on the entire tank. Minus the very lowest and highest points (doesnt matter, filter that out)
If tank level is below half, run the ladder formula with first set of coefficients and constant, if over half run the second set in the ladder formula.
Is this a efficient solution or am i overthinking this? Whats your best practice for non-linear scaling?