Forum Discussion
Help required to determine correct calculation methodology/formula
=LOOKUP(A7,
{0;1;1.1;1.2},
{0;375;380;417}+({375;50;370;0}*(A7-LOOKUP(A7,{0;1;1.1;1.2}))))
Note the calculation of the following constants:
1. (375-0)/(1-0)=375;
2. (380-375)/(1.1-1)=50; and
3. (417-380)/(1.2-1.1)=370.
Afraid the function is far from linear. If the tank is horizontal cylinder we shall to calculate segment square based on the level. If more complex form the approximation will be even more complex. In any case just 3 points is not enough for any approximation but linear.
SergeiBaklanthanks for the reply.
All my tanks are cylinder tanks, with conical bottom.
The conical space can be easily measured (I have done that already), the issue is that I have to calculate fast the volume on all tanks based on their level, as much as accurate as possible.
The level is very fast changing and the only remote indication I have is the level in centimeters, that's the reason I need to create this calculator...
Thanks again...With such shape formula could work after 1.1, as I guess that's cylindrical part
I'd only use linear approximation for the second part ignoring first point, like
=270*(A7-1.1)+380
