3 replies to this topic

[bhalchandra1986]

Dear Sir,

In attached horizontal tank volume calculation sheet (Horizontal storage tank heat loss calc- 03.01.2011.XLS) ,which formula is used for estimating liquid cross sectional area.

R = 1.495 m ; h =1.378 m for 45% filled volume.

By using this formula im getting Liquid cross sectional area as 190 m2.

Af = R^2 x COS-1 ((R-h)/h) - (R-h)x sqrt(2Rh - h^2) _______(from Reference sheet of 73456122- Vessel volumes.XLS)

Whereas as per calculation sheet it is 3.16 m2.

Please clarify.

Thanks

Edited by bhalchandra1986, 31 October 2012 - 04:17 AM.

[Pilesar]

Your spreadsheet attachment did not appear. But check the units. I suspect the 190 is in cubic meters to represent the vessel volume (?) while the 3.16 square meters is the area of the liquid vertical cross section.

You are right to ask questions about results that look unreasonable. Any time I work from another's spreadsheet, I always am more comfortable stepping through each of the calculations to thoroughly understand the origin and use of each equation. It can be tedious, but I have made enough mistakes myself to blindly trust that the author of the spreadsheet made no errors. Sometimes a short cut is to compare the results to a known standard.

By the way, I think your formula should be:
Af = R^2 x COS-1 ((R-h)/R) - (R-h)x sqrt(2Rh - h^2)

Edited by Pilesar, 31 October 2012 - 07:10 AM.

[breizh]

http://www.arachnoid...Calc/index.html

Consider this resource to support your calculations, if needed .

Breizh

Edited by breizh, 31 October 2012 - 07:15 PM.

[Bobby Strain]

You can check your answers with software at bobby-strain-group.com.

Bobby