Resources » Engineering Projects » Mechanical Projects

Excel sheet for basic design of pressure vessels

Updated: Category: Mechanical Projects
Author: Member Level: SilverPoints: 70

In this post I shall share with you a small but effective Excel sheet that I have developed which gives us the basic design (thickness, pressure, volume etc.) of a non-critical pressure vessel. This is particularly useful when one is provided with only a General Assembly drawing.

I am in the engineering field and working in a company that is into the fabrication of Pressure Vessels. It's a small company and we do not have dedicated designers employed. I carry out the estimation and costing of Pressure Vessels required by clients.

Generally, the client provides us with only a General Assembly drawing and we have to determine the thickness and size of the vessel according to the criteria of pressure and volume given by them. This was one of the major hurdles I faced while estimating for the item. I had to go through the exercise of determining the thickness by carrying out many different calculations. Moreover, I had to keep in mind the optimum size (height to width/diameter ratio) of the vessel too. If for a certain volume, I changed only the diameter, the thickness would change. Conversely, if I changed the height, the thickness would change again. To overcome this problem and to make my life easier, I started tinkering around with formulas in Excel. In the beginning, I had just fed in the calculation formulas individually and without any co-relation. But as is the case with any development, I was not satisfied and kept on upgrading my Excel sheet. Slowly, over the days and weeks, I created the sheet that I wanted and that is what you can see attached here.

I shall give a brief description of how it works: The very beginning of the sheet has a few black cells which are the only cells where one can insert the basic data such as diameter & length of shell, pressure, type of ends (ellipsoidal, torispherical, conical etc.), stress value etc. If you have the diameter & length as well as the design pressure, then, after you insert the data in the relevant cells you can see the thickness of the plates you require to build your vessel. If you do not have the diameter and length and only the volume is given then, by keeping your eye on the "volume of vessel" cell you can tinker around with the diameter and length cells till you get the right size. There is also an option of knowing the maximum allowable pressure a vessel can withstand given a certain thickness. After you get all the data in order, you can also view the empty weight of the vessel (shell + ends only)

The central portion of the sheet displays the details of the ends such as size, volume, area, weight and, most importantly, the blank size (required for the forming of dished ends). There is also a small conversion table on the extreme right where you can convert the pressure in different units like psi to kg/cm²g to MPa.

I have tried to make this excel sheet as user-friendly as possible complete with cell comments explaining how data is to be inserted in their respective cells.

When it comes to full-fledged designing of a pressure vessel, I am a novice but this sheet helped me a lot in getting the basics right. I am not sure how many people will find this useful but I can say that I did find it very handy for my calculations. I shall be very happy if it helps other people too.

Note: The formulas used for design calculations have been taken from the handbooks - Pressure Vessel Design Manual by Dennis Moss & Pressure Vessel Handbook by Eugene F. Megyesy

Click here to download the XLS file

Did you like this resource? Share it with your friends and show your love!

Responses to "Excel sheet for basic design of pressure vessels"
Author: RAGHU  11 Mar 2014   Member Level: Bronze   Points : 0
Dear Mr.Faraz

It is really interesting. But the Excel sheet is missing. Can you get it attached?


Author: Farazdak  14 Mar 2014   Member Level: Silver   Points : 2
The link to download it is still there. I just checked it. Can you see the Pin icon with the word "Attachments" beside it ? If you click that you will be taken to another page where you can download the file.

Author: noin  14 Mar 2014   Member Level: Bronze   Points : 0
Please explain where is the file and how we can download?

Thanks in advance.

Author: Farazdak  18 Mar 2014   Member Level: Silver   Points : 3
At the top of the page, just below the title "Excel sheet for basic design of pressure vessels", you can see a pin-shaped icon with the word "Attachments" written beside it. Please click on that and it will take you to the download page. In case you are not able to download it, please send me your email address and I will send it over to you. Please check with the admins whether you can send me your email address over here or not so that do not fall foul with the rules of the site.

Author: Mehul Shah  13 May 2014   Member Level: Bronze   Points : 0
Dear Mr. Faraz, I am also not able to see the link in this article. Can you also forward the excel file to my e-mail address - >

Thanks in advance,

Mehul Shah

Guest Author: bala   19 May 2014
This is very interesting. I can not find any attachments. please forward the same to my mail

Guest Author: radhakrishnan   11 Jul 2014
Dear Mr. Faraz

Its a fantastic job. Really nice. But can't to find the attachment. Please upload it soon.

Guest Author: sethuraman Ramakrish   30 Jul 2014
Dear friend,

Can you send me the sheet to my email id.

Author: Farazdak  09 Aug 2014   Member Level: Silver   Points : 0
@Radhakrishnan, please mention your email add. so I can email it to you.

Guest Author: Terence Tan   21 Aug 2014
Hi Sir,

I couldn't locate the download link. Kindly clarify.

Guest Author: abbas yoosaf   23 Aug 2014
I need download link for this particular topic

Guest Author: Humberto   04 Sep 2014
Dear friend,

Can you send me the sheet
Thank you in advance

Guest Author: rhoel   07 Sep 2014
can you please send me the excel sheet with formula

Author: snehisingh  09 Sep 2014   Member Level: Bronze   Points : 0
This is really very beneficial for the engineering students.
Kindly attach the excel sheet.

Guest Author: mahendra joshi   10 Sep 2014
hello sir can you please provide sheet for cost estimation of pressure vessels

Guest Author: mahendra joshi   10 Sep 2014
hello sir

kindly request you for sending excel sheet for pressure vessel estimation .

I need sheet for cost estimation .

thanks for such helping to us .

Guest Author: Sana   11 Sep 2014
Please send me this sheet as well. I am an engineering student working on a similar problem. my email ID is

Author: Farazdak  13 Sep 2014   Member Level: Silver   Points : 2
As mentioned before, due to some glitch, the file is not appearing on the ISC website as a download link (although I can still see the attachment link). Hence, please send me your email addresses so that I can directly email the file to you. I have received several messages here asking for the file but no address to email it to.

Guest Author: Faizal   13 Sep 2014
Please send me the file to

Author: Mohammad  16 Sep 2014   Member Level: Bronze   Points : 0
Dear Faraz,
Please send file to the email ID,

Guest Author: M.Karamipoor   17 Sep 2014
I need calculation of quick opening closure. Can you help me?

Guest Author: Humberto Ramirez   17 Sep 2014
Can you please send me the file? It will be very useful to me. My e-mail address is

Author: Syawal Eqwan  23 Sep 2014   Member Level: Bronze   Points : 0
Dear Faraz,
That is good effort. Please sent me the file to I really appreciate it. Thank you in advance.

Guest Author: palani   19 Oct 2014
please sent the attachment

Author: Fatin Nur Haziqah Binti Kamarulzaman  25 Nov 2014   Member Level: Bronze   Points : 0
Can you please email me the excel file? My email id is

Author: Tony John  27 Nov 2014   Member Level: Gold   Points : 0
Many of you were asking for the excel file since there was no link to download the attachment. I have added it now.

Author: Farazdak  12 Dec 2014   Member Level: Silver   Points : 1
Thanks, Mr. Tony John. I did email the file to many people as they could not download it from here.

Guest Author: shahbaz   13 Dec 2014
Please send me attachment

Guest Author: Usman   18 Jan 2015
Please send me the password for the protected portion as I want to see the formula.

Guest Author: Amit   28 Jan 2015
Its a wonderful tool sir. I have easily calculated the full weight of a pressure vessel using this tool. Thumbs up!
I could easily download the excel file using link provided at the end of the description.

Guest Author: vishal nanaware   30 Jan 2015
jacketed vessels,
reactors with internal & limpet coils
nozzle weight calculations

Guest Author: VISHAL   01 Feb 2015
Could you tell how to change density


Post Comment:

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:   Sign In to fill automatically.
    Email: (Will not be published, but required to validate comment)

    Type the numbers and letters shown on the left.

    Submit Article     Return to Article Index
    Awards & Gifts
    Active Members
    TodayLast 7 Daysmore...

    ISC Technologies, Kochi - India. Copyright © All Rights Reserved.