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?

 

[ismailkhowaja]

This should do what you want.
First you need to calculate the volume
View attachment 72050
Then multiple the volume by 0.004329 which is the number of gallons in a cubic inch.
On the web site you referenced note that 16 gallons was 1.298 inches.
If you use the web site and put in 1 inch it returns 10.82 gallons.

In the example below you can just change the height in cell C1. I just added some other heights so you can check against the web site.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Diameter	Length	Height
2	96	192	1		2	3	4	5	6	10	12	22	55	96
3	Radius		Gallons
4	48		10.82		30.52	55.89	85.77	119.48	156.56	332.43	434.05	1039.96	3564.65	6016.18
Sheet1

Cell Formulas
Range	Formula
A4	A4	=A2/2
C4,E4:N4	C4	=$B$2*($A$4^2*(ACOS(($A$4-C$2)/$A$4))-(($A$4-C$2)*SQRT((2*$A$4*C$2)-C$2^2)))*0.004329

I have c4 values already which are gallons inside the tank. I need to know the height at filled level. Its confusing to explain in the words

 

[jolivanes]

If you look at Post #24 you'll have all the answers there.

 

[ismailkhowaja]

I have created the script that goes to the website, inputs the numbers, and prints the results on the command prompt console. it requires a puppeteer to be installed.

const puppeteer = require('puppeteer');
const diameter = "84"; // tank diameter
const length = "167"; // tank length

const volumeMap = new Map();
function sleep (time) {
    return new Promise((resolve) => setTimeout(resolve, time));
  }

const gallons = [
    //Input gallon number here                                                                                                               
    ];
(async () => {
    const browser = await puppeteer.launch({
        headless: false,
        args: ['--headless'],
    })
const page = await browser.newPage();

for (var gallon of gallons) {
    const navigationPromise = page.waitForNavigation({ waitUntil: ['networkidle2'] });
    await page.goto('https://www.handymath.com/cgi-bin/circlehei4.cgi?convdia=in&convlen=in&convol=gal&convhei=in&dia1=&len1=&vol1=&dia2=&len2=&vol2=&numnum=2&submit=Remove+Rows&moreless=1&decimal=5',
    { waitUntil: "domcontentloaded" });
    
    const diameterBox = await page.$x("//input[@name='dia1']");
    await diameterBox[0].click();
    await diameterBox[0].type(diameter);
    
    const lengthBox = await page.$x("//input[@name='len1']");
    await lengthBox[0].click();
    await lengthBox[0].type(length);
    
    const liquidBox = await page.$x("//input[@name='vol1']");
    await liquidBox[0].click();
    await liquidBox[0].type(gallon.toString());
    
    var calculateBtn = await page.$x("//input[@value='Calculate']");
    await calculateBtn[0].click();
    
    await navigationPromise
    //await page.screenshot({ path: 'example.png' });
    const inches = await page.$$eval("body > table > tbody > tr > td:nth-child(2) > table:nth-child(10) > tbody > tr:nth-child(3) > td:nth-child(4)", ele => ele[0].textContent);
    console.log(inches);
}
await browser.close();
})();