20 replies to this topic

[samayaraj]

Dear all,

 

Please find attached the Excel sheet "Partial filled liquid height Calculation". With this, you can calculated the height of partially filled liquid in horizontal tank with various types of end such as flat plate, torispherical head, elliptical head and spherical head.

 

Kindly enable MACROS before using this excel.

 

Your comments are welcome!!

 

 

Regards,

Samayaraj

Attached Files

•  11. SAM- Partial Filled Volume tank height calc.xlsm   87.2KB   543 downloads
•  tank partially filled.jpg   148.44KB   50 downloads

Edited by samayaraj, 20 February 2014 - 12:09 AM.

[ankur2061]

Samayaraj,

 

There is another vessel volume calculator on "cheresources" and it's results do not match with your spreadsheet. Moreover, any vessel volume calculator for partially filled vessel should have as an input the liquid height and not the vapor volume percentage. Refer the link for the calculator:

 

http://www.cheresour...al-volume-tool/

 

Regards,

Ankur.

[Bobby Strain]

And you can check your computations at my website. Just Google my name.

 

Bobby

[Art Montemayor]

Samayaraj:

 

Perhaps the attached workbook may serve your purpose in checking out your volume calculator.  I started this workbook in the early1990’s when I was doing a lot of problem solving out in process plants and required a quick and accurate way to determine the various liquid levels in process and storage vessels for the reasons outlined in the workbook.  It proved to be very valuable in my projects and I have distributed many hundreds of free copies over the world since then.

 

Note that my calculations allow for any of the available types of vessel heads.

 

I admire your work effort and even though I consider it simplistic in that it does not take into consideration different head types and vessel orientations, it does apply macros and advanced spreadsheet techniques which make it simpler and easier for an engineer to apply when making these calculations.  A drop-down listing of the head types would make an excellent improvement to your spreadsheet as well as a tabular listing of the different volumes contained at incremental liquid heights (what we conventionally call “strapping”).  I congratulate you on your effort and I hope you continue to work on this project.  I would hope that more young engineers follow this example in improving their skills at dealing with practical field problems.

 

May I ask you for the password to your worksheet through my messaging service in order for me to see and study your macros?  I would appreciate the opportunity to look at the algorithms and logic employed.  Perhaps I'll have time in the future to apply them to my workbook as well.

 

Keep up the good work in applying and perfecting engineering tools such as Exel.

 

 Vessel Volumes.xlsx   597.37KB   485 downloads

 

[ankur2061]

Art,

 

I admire your work effort and even though I consider it simplistic in that it does not take into consideration different head types and vessel orientations, it does apply macros and advanced spreadsheet techniques which make it simpler and easier for an engineer to apply when making these calculations.  A drop-down listing of the head types would make an excellent improvement to your spreadsheet as well as a tabular listing of the different volumes contained at incremental liquid heights (what we conventionally call “strapping”).

 

The spreadsheet does take into account the different heads such as 2:1 elliptical head, F&D head, hemispherical head and flat head for which a dropdown menu is provided. However, the macros do not run and the spreadsheet input uses vapor volume % which is not the conventional input for partial filling of a vessel. The conventional input would be the liquid height in the vessel which is measurable quantity using a level glass or an external level tube with height markings.

 

In all probability, using vapor volume % is leading to an error in the final results. The spreadsheet I mentioned in the preceding post in this very thread is giving accurate partial volume figures. I had checked that worksheet and found it to be providing accurate results based on the information provided in the GPSA engineering databook for 'partially filled horizontal vessels'.

 

While young engineers should be encouraged to do such kind of work, as seniors it is also our duty to point out errors and guide them to refer other similar work for the purpose of comparison and checking of their own work. I hope you understand that.

 

Regards,

Ankur

[samayaraj]

Dear Mr.Ankur, Mr. Bobby & Mr. Art,

 

Thanks for your valuable comments. Please find attached the revised excel sheet.

 

@ Mr. Ankur: In one of my project, I've to calculate the height of liquid from the vapor volume. So, I developed this excel in a reverse way to calculate the height from vapor volume. Its quite difficult to prepare this excel since, this excel comes under iteration. It's comparatively easy to prepare the same excel for given height. As you said, error will come due to iteration. I've attached the revised excel sheet where my error is reduced. It is nearly matching the value as per the reference calculator you've given. I've submitted this excel to verify by our forum members to upgrade the same. Thanks for your comment.

 

 

@Mr. Art: There is a drop down list for various types of heads and I'll upgrade this excel as you said. It my pleasure to share my excel to you.

I've messaged you the password thro personal message. The logic I used may be confusing to you. Sorry for that!!

 

I calculated vol for various head based on following equations:

 

For F&D head: 0.215483h²(1.5D-h)

For Hemispherical head: pi()h²(1.5d-h)/3

For 2:1 Ellipsoidal head: pi()h²(1.5d-h)/6

 

Kindly verify the above attached excel and give your comments.

 

Regards,

Samayaraj

Attached Files

•  11. SAM- Partial Volume tank height calc-R1.xlsm   87.97KB   267 downloads

Edited by samayaraj, 20 February 2014 - 09:19 PM.

[Bobby Strain]

Samayaraj,

     You should post the spreadsheet with the VBA unprotected if you want to play nice.

 

Bobby

[gegio1960]

That's the good of this site... one young engineer sharing his work for comments... three senior experts giving advices... a double round of valuable discussions in less than one day, with people coming from different cultures and experiences... very amazing.

Honors to samayaraj to have started it!

[Art Montemayor]

Gegio1960:

 

You have expressed my views exactly.

 

It is indeed a feeling of accomplishment to find a young student of chemical engineering eager and resolved to immerse him/herself into the arcane world of real engineering challenges that make a difference in the everyday workplace.  We, who have been students also at one time, know all too well the feeling of ignorance and naivety as students confronting real world engineering problems for the first time – and not cognizant or sure of what tools or methods to apply at the first opportunity.

 

It is rewarding indeed to find students in our Forum that not only take the extra step and effort of seeking out what are the real world problems, but also put additional effort and time into seeking if their attempts are valid or not.  This is a characteristic of a dedicated work ethic – something that raises my expectations for the next generation that follows us.  It is one thing to develop a method to solve engineering problems for your own self.  It is a higher accomplishment to develop a method that allows others to also resolve the same problem with equal success.  That is progress multiplied many times over.

 

It is our hope that more students become pro-active in developing their engineering skills early in their studies and continue on afterwards.

 

Thank you for your positive comment.

[breizh]

Samayaraj ,

Good work , like others I appreciate the fact that you post your work .

Here I 'm sharing a link for similar topic ( with a lot of options) ,

 

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

 

Breizh

[samayaraj]

Thanks Mr. Geogie, Mr. Art & Mr. Breizh. Thanks a lot for your comments. It encourages me to a lot. Will post more spreadsheets!!

[gegio1960]

pay attention to the details...

...take into account the advise of Bobby

...my name is gegio not geogie :-)

good luck!

Edited by gegio1960, 23 February 2014 - 10:38 PM.

[breizh]

http://www.contrec.c...ds/220-tankwin/

 

Another great resource to download "tankwin from contrec"  , for pre- commissioning , stock taking ,.....

Hope you like it.

Breizh

[Bobby Strain]

Breizh,

     I just get a picture when I visit the site.

 

Bobby

[breizh]

Apologies Friends, Bobby is right the link is not working anymore ....!

I'm contacting the vendor in Australia ,if good news I will revert to you.

Sorry,

Breizh

Edited by breizh, 24 February 2014 - 11:41 PM.

[breizh]

Bobby and others ,

The link is operational , scroll down and download .

hope you found it helpful

 

Breizh

[Nishu99]

Please advise how to calculate oil volume in 3-phase horizontal separator.

ID = 3.2 mm

LG = 7.2 mm

Oil Level in Oil compartment is 480 mm.    

Attached Files

•  Vsl.xlsx   12.61KB   91 downloads

[Bobby Strain]

Go to my website. Just Google my name to find it.

 

Bobby

[samayaraj]

Nishu,

 

Find attached the excel for steps to be followed in finding volume of partially filled tank of various heads.

Attached Files

•  Vsl Sam Edited.xlsx   15.93KB   156 downloads

[Bobby Strain]

samayaraj,

Your illustration looks OK. But the formula are simple enough for a direct calculation; yours are not quite complete. So maybe Nishu can start with what you gave him and use geometry fundamentals to get a direct formula. And relate the volume to the level in the horizontal drum. Or use ready built calculators. It's always good to derive calculation from fundamentals. Trust nothing in a spreadsheet you happen upon without verifying the results. Same for the use of material from the www.

 

Bobby

Edited by Bobby Strain, 20 July 2015 - 02:16 PM.

[Nishu99]

Thanks Bobby and Samayaraj for your inputs.