Formula to calculate the inches given tank size, length, and diameter and gallons per inch

[ismailkhowaja]

I want to calculate inches for the number of gallons filled in a tank so I need a formula for that.

Tank size = 6000 Gallons
Size = 96 * 192
1 inch can have 16 gallons (I need a formula for that). For example, if my tank contains 1000 gallons, how many inches is that?

 

[Jamie McMillan]

Hello,

The data in your table seems to have been rounded to the nearest gallon. (Looking at columns 2&3)

But the 'tank' doesn't seem to be uniform.

Jamie McMillan

 

[ismailkhowaja]

Perhaps, do you know the actual shape of your tank, I did not see it stated any place and the capacities will vary by shape. I only worked off the numbers you provided. Additionally, we do not know what the tank is filled with. Is it water, gasoline, LNG, or liquid mercury.

Perhaps, do you know the actual shape of your tank, I did not see it stated any place and the capacities will vary by shape. I only worked off the numbers you provided. Additionally, we do not know what the tank is filled with. Is it water, gasoline, LNG, or liquid mercury.

Its horizontal tank for gasoline

 

[igold]

Can you get your numbers from the sheet you posted to match the website.

 

[igold]

 

[Jamie McMillan]

Hello,

The numbers have been rounded, the exact formula will be difficult to find.

For the 3rd column the formula is ABOUT - =1.5*A1^2+17.8*A1 (where A1 is the number of inches)

Inches	1	2	3	4	5	6	7	8	9	10	11
From Your Sheet	16	38	64	93	126	161	199	240	282	327	374
1.5 x (Inches)2 + 17.8 x (Inches)	19.3	41.6	66.9	95.2	126.5	160.8	198.1	238.4	281.7	328	377.3
Difference from data sheet and formula	3.3​	3.6​	2.9​	2.2​	0.5​	0.2​	0.9​	1.6​	0.3​	1​	3.3​

Jamie McMillan

 

[jolivanes]

It would have helped if you would have mentioned what shape the tank is.
If it would be a round tank, standing up with a diameter of 96 inches and a height of 192 inches, 1 inch would be 31.3 gallons (twice what you mention).

 

[igold]

@jolivanes - See bottom of Post #12

 

[Jamie McMillan]

Hi,

It isn't a regular solid; so the formulae for regular solids will not be applicable. That is why the increments in gallons are not uniform: and the data has been rounded to the nearest gallon.

Jamie

 

[ismailkhowaja]

Hello,

The numbers have been rounded, the exact formula will be difficult to find.

For the 3rd column the formula is ABOUT - =1.5*A1^2+17.8*A1 (where A1 is the number of inches)

Inches	1	2	3	4	5	6	7	8	9	10	11
From Your Sheet	16	38	64	93	126	161	199	240	282	327	374
1.5 x (Inches)2 + 17.8 x (Inches)	19.3	41.6	66.9	95.2	126.5	160.8	198.1	238.4	281.7	328	377.3
Difference from data sheet and formula	3.3​	3.6​	2.9​	2.2​	0.5​	0.2​	0.9​	1.6​	0.3​	1​	3.3​

Jamie McMillan

I will use this as reference for my sheet. Love you guys .. appreciate the help.

 

[Jamie McMillan]

I will use this as reference for my sheet. Love you guys .. appreciate the help.

There are still some issues, I am working on.
I will post an update within an hour.