In this article, I will show you how to create a calculator for a horizontal cylindrical tank volume in Excel.

## Formulas for Horizontal Cylindrical Tank Volume Calculator

The volume of a cylinder can be of two types: fully and partially filled, and partially filled volume can 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

But when calculating a partially filled tank, we have to use a different formula.

**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, you have to convert all the units to **S.I. units** so that you will get the volume in the **m**** ^{3}** units. You can use other units as well, but in this article, I will use

**S.I**. units. If you want to use other units, go to the bottom of the article to know how to use the measurement unit conversion calculator.

### 1. Volume Calculator for *Fully Filled* Horizontal Cylindrical Tanks

Here, suppose that you have all the units converted to S.I units. Now you want to calculate the full volume of a cylinder tank. For this, follow the steps below:

- First, enter the value of the
**length**and**diameter**in the box.

- Then, enter this formula in cell
**C7**to calculate the**full volume**of the cylinder.

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

### 2. Volume Calculator for *Partially Filled* Horizontal Cylindrical Tanks

When a tank is partially filled, there may happen two things: either it is filled with less than half of its capacity or it is filled with more than half its volume. For these two situations, you have to calculate volume differently. Here, I am showing you how you will calculate the partially filled volume of the tank.

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

Now, if you want to calculate the partially filled volume of a cylindrical tank, you have to use a different formula. Follow the steps below to calculate it:

- First of all, enter the value of
**length**,**radius**, and the**filled height**of the cylinder.

After that, you have to insert formulas to calculate the partially filled volume when the filled height is less than the radius **(F<R)**.

- First, insert the formula into cell
**C11**to calculate the**segment height**which is equal to the**filled height**when**F<R.**

`=C8`

- And then, insert the formula in cell
**C12**to calculate the**segment area**. The mathematical formula is as mentioned before.

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

- Finally, insert the formula to calculate the partially filled volume in cell C13. Write the following formula:

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

- The
**If function**works here on the condition that it will give 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):**

Now if the cylindrical tank filled **more** than the **half volume** you will subtract the segment volume from the full volume. Follow these steps in this case:

- Here, the segment height will be the difference between the filled height and the full height. So, use this formula in the cell.

`=C6-C8`

- Then use a similar formula to calculate the segment area. The formula is given below:

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

- Now, the partially filled volume will be the subtraction of segment volume from the full volume. For this write this formula into the cell C18

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

- The
**If**function works here on the condition that it will give a result when the**filled height**is higher than the**radius**otherwise it will give “N/A”

- Now, finally, the
**calculator**is ready to use.

## Things to Remember

During the calculation of the volume of a cylinder or any other thing, it is a must to use constant units. You may have values in any kind of unit but you can convert the measurement units to a specific unit. So, to help you, I am sharing a **Measurement Unit Converter** worksheet for free. You can convert any units here.

- Here, you will find a
**drop-down option**in the cells where you can select where you will convert to which unit from which unit.

- So, using this Measurement Unit Conversion worksheet, you can also convert the volume units.

**Download Sample Workbook**

You can download the practice workbook from here:

## Conclusion

In this article, I have shown you how to calculate a horizontal cylinder tank volume in Excel. Also, you will find a Measurement Unit Converter worksheet as a bonus. I hope you found this article helpful. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.

**<< 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