## Formulas for Horizontal Cylindrical Tank Volume Calculator

The volume of a cylinder can be of two types: fully and partially filled. Partially filled volume can also be of two types during calculation: filled less than 50% or more than 50%.

**Formula for Volume of a***Fully Filled*Tank:

**V = πR**^{2}**L**

Here,

**R** = Radius of the cylinder base

**L** = Length of the cylinder’s horizontal axis

**Formulas to Calculate Volume of a***Partially Filled*Tank:

**Filled Less Than 50% (F<R)**

**Segment Height (S) = Filled Height (F)**

**Segment Area** =** ****((R**^{2}**cos**^{-1}**(1-S/R)-(R-S)****×****√(2RS-S**^{2}**))**

**Volume (V) = Length × Segment Area ****= L ****×****((R**^{2}**cos**^{-1}**(1-S/R)-(R-S)****×****√(2RS-S**^{2}**))**

Here,

**R** = Radius

**S** = Segment Height

**L** = length

**Segment Area: **

In the figure, the black part is the segment area. When the filled height (F) is less than Radius(R), the segment area is equal to the filled area. And when the filling height is greater than the Radius(R), the segment area will be the remaining unfilled part of the cylinder.

**Filled More Than 50% (F>R)**

**Segment Height (S) = Diameter(D) – Filled Height (F)**

**Segment Area = ((R ^{2}cos^{-1}(1-S/R)-(R-S)×√(2RS-S^{2}))**

**Volume (V) =Full volume – Length × Segment Area ****= πR**^{2}**L**** – L ****×****((R**^{2}**cos**^{-1}**(1-S/R)-(R-S)****×****√(2RS-S**^{2}**))**

## Horizontal Cylindrical Tank Volume Calculator in Excel: 2 Examples

To compute the volume of the cylindrical tank, we have to convert all the units to **S.I. units** to get the volume in **m**** ^{3}** units. We can use other units instead, but here we’ll use

**S.I**. units. To use other units, at the bottom of this article is a handy measurement unit conversion calculator.

### Example 1 – Volume Calculator for *Fully Filled* Horizontal Cylindrical Tanks

Assume we have all the units converted to S.I units. Now we can calculate the full volume of a cylinder tank.

**Steps:**

- Enter the value of the
**length**and**diameter**in cells**C5**and**C6**respectively.

- Enter the following formula in cell
**C7**to calculate the**full volume**of the cylinder:

`=PI()*(C6/2)^2*C5`

### Method 2 – Volume Calculator for *Partially Filled* Horizontal Cylindrical Tanks

When a tank is partially filled, there may be two circumstances: either it is filled to less than half of its capacity, or it is filled to more than half its volume. For these two situations, the volume has to be calculated differently.

**When Tank Is Filled Less Than 50% (F<R):**

**Steps:**

- Enter the value of
**length**,**radius**, and the**filled height**of the cylinder.

- Enter the following formula in cell
**C11**to calculate the**segment height**, which is equal to the**filled height**when**F<R**:

`=C8`

- Enter the following formula in cell
**C12**to calculate the**segment area**:

`=($C$7^2)*ACOS(1-C11/$C$7)-($C$7-C11)*SQRT(2*$C$7*C11-C11^2)`

- Enter the following formula in cell
**C13**to calculate the partially filled volume:

`=IF(C8<=C7,C12*C5,"N/A")`

The **If function** will return a result when the **filled height **is less than the **radius**, otherwise it will return “N/A”

**When Tank Is Filled More Than 50% (F>R):**

If the cylindrical tank filled to **more** than the **half volume**, we subtract the segment volume from the full volume. The segment height will be the difference between the filled height and the full height.

**Steps:**

- Enter the following formula in cell
**C16**:

`=C6-C8`

- Use a similar formula to calculate the segment area in cell
**C17**:

`=($C$7^2)*ACOS(1-C16/$C$7)-($C$7-C16)*SQRT(2*$C$7*C16-C16^2)`

- The partially filled volume will be the subtraction of segment volume from the full volume. To calculate this, enter the following formula in cell
**C18**:

`=IF(C8>C7,PI()*C7^2*C5-C17*C5,"N/A")`

- The
**If**function returns a result when the**filled height**is higher than the**radius**, otherwise it returns “N/A”

The** calculator** is ready to use.

## Things to Remember

During the calculation of the volume of a cylinder or any other thing, you must use constant units. If you have values in any other kind of unit, you must convert the measurement units to the specific constant unit required. To assist you with this process, included in the downloadable sample workbook below is a free **Measurement Unit Converter** that can convert between different unit types.

There is a **drop-down option** in each cell where you can select which units to convert to and from.

**Download Sample Workbook**

**<< Go Back to Excel Area & Volume Calculator | Excel Templates**

If possible, pl. send HT tank with dish calculation for each cm (1 cm to 200cm)for 15KL, Length-500cm, Diameter:200cm

Hello

A.Nirmala Rani,You can the following formula for the volume of a cylindrical segment:

Where:

V is the volume in liters,

L is the length of the cylinder in meters,

R is the radius of the cylinder in meters,

h is the height of the liquid level in meters.

Given the specific dimensions:

L=5.0 meters (500 cm),

R=1.0 meter (100 cm),

h varies from 0.01 meters (1 cm) to 2.0 meters (200 cm)

This formula calculates the volume of the liquid based on the height from the base up to the liquid level within a horizontal cylindrical tank. To use this formula, ensure to convert all measurements (radius, length, and height) to meters before applying them in the calculation.

At 1 cm height: Approximately 9.41 liters

At 2 cm height: Approximately 26.59 liters

At 3 cm height: Approximately 48.77 liters

At 4 cm height: Approximately 74.97 liters

At 5 cm height: Approximately 104.62 liters

At 10 cm height: Approximately 293.63 liters

———————————————————

To see the full list of calculated volumes for each centimeter increment from 1 cm to 100 cm for the horizontal cylindrical tank, Download the Excel File.

List of Calculated Volumes.xlsxRegards

ExcelDemy