Tank Calibration table, Formula to find volume from height

[endrit01]

Hello guys,
attached is a fuel storage tank calibration table in dcm, cm, and mm and respective volumes.
i need a formula to find volume from height.
for example: after measuring tank with measuring tape i find the liquid height and want to find respective volume for that height based on calibration chart, instead i dont have to calculate manually checking all the time the calibration table.
for example: i put the height like 2300 mm trying to find its volume on the tank, is there any formula to do so? sorry for my English, i hope i was clear
thank you very much

[ben_hensel]

By Dcm it's decimeters, right?

I don't understand how this table works. I mean, I have some guesses, but I'm not understanding how the sub-zones for cm and mm correspond to the tank volume.

At any rate, you would put something like this in J8:

Please Login or Register  to view this content.

But when I charted the tank volume-vs-height data in A5:B156, I see that it's a strictly linear relationship? I mean that would make sense if you had straight sidewalls, but there isn't even a hook or curved section at the bottom for a dish or a cone. When I check the R2 of the linear regression, it was exactly 1! Although it doesn't start at the origin, that needs investigating.

Linear equation in J8 given J6 in mm:

Please Login or Register  to view this content.

[Czeslaw]

Try this formula

Please Login or Register  to view this content.