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 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. 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 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. Vessel Volumes.xlsx 597.37KB 478 downloads Keep up the good work in applying and perfecting engineering tools such as Exel. Perhaps I'll have time in the future to apply them to my workbook as well. 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. I would hope that more young engineers follow this example in improving their skills at dealing with practical field problems. I congratulate you on your effort and I hope you continue to work on this project. ![]() ![]() ![]() Note that my calculations allow for any of the available types of vessel heads. It proved to be very valuable in my projects and I have distributed many hundreds of free copies over the world since then. 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. Perhaps the attached workbook may serve your purpose in checking out your volume calculator.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |