Excel template for vessel estimators
Pressure Vessel Cost Estimation Spreadsheet: a data sheet and a costing sheet in one Excel file
This pressure vessel cost estimation spreadsheet is for estimators and inside sales staff at shops that build custom pressure vessels. You read the customer's package into the data sheet, then price the vessel at your own rates on the cost build-up.
The file is an Excel .xlsx with four tabs and no macros, and you do not need to give an email address to download it.
By Atishay Jain, founder of Mavlon · Updated November 2026
| Item | What the package says | Document and page | Changes the price because |
|---|---|---|---|
| Radiography extent and joint efficiency (full, spot or none) | Less radiography lowers the joint efficiency and makes the shell thicker, while full radiography adds inspection cost and the risk of weld repairs. | ||
| Minimum design metal temperature, MDMT (deg F) | A cold MDMT can mean Charpy impact testing of the plate, the welds and the weld procedures, or a switch to a tougher normalized plate. | ||
| Post-weld heat treatment (PWHT) and the reason for it | Heat treatment means furnace time or a heat treating contractor, extra handling and days added to the schedule, and the reason tells you whether it can be dropped. | ||
| Corrosion allowance (inches) | The allowance is added to the thickness the code requires, so a larger allowance makes the shell, heads and nozzle necks heavier. |
I made this file to show how our engine sits next to COMPRESS, the design program that many vessel shops use for their code calculations. The honest answer is that the two do different jobs. We read the customer's package and write down what it asks for, the engineer does the code calculations, and the weights come back for pricing.
This spreadsheet is a paper version of that hand-off, and you can use it without us. It works as a pressure vessel costing sheet for a single quote, and its first working tab doubles as the data sheet you keep in the job file.
The download
Download the pressure vessel cost estimation spreadsheet
It is one Excel file with four tabs. The yellow cells are the ones you fill in, and every formula already works with those cells left blank, so you can open it and see how it is built before you type anything.
- Read meThis tab explains which cells to fill in, how the tabs link and what the file does not calculate.
- Data sheetThis tab has 72 rows in 12 groups, from design pressure to warranty, and each row gives the reason it changes the price.
- Nozzle tableThis tab gives each nozzle its own row, with its mark, size, flange class, facing, neck schedule and service.
- Cost build-upThis tab prices the plate, purchased items, shop labour, subcontracts and engineering, then adds your contingency and margin.
The file is .xlsx, the current Excel format. It opens in Excel, Google Sheets and LibreOffice.
How the spreadsheet is built: a data sheet and a cost build-up
Every vessel quote has two jobs inside it. The first job is reading: working out from the customer's specification, data sheet and drawings exactly what vessel they want and what has to come with it. The second job is pricing: turning that vessel into pounds of plate, hours in the shop and bought parts, at your own rates.
The spreadsheet gives each job its own tab, so the reading is finished and written down before anyone starts pricing.
Data sheet tab
What the customer asked for
Each row is one thing a package usually settles, from the design pressure to the number of data book copies. You write what the package says and the document and page where it says it.
A fourth column explains in one sentence why the row changes the price, and the last column holds your question for the customer when the package is unclear.
Cost build-up tab
What it costs you to build
Six sections cover plate, purchased items, shop labour, subcontracts and fees, engineering and documents, and the totals.
The diameter, the length and the quantity come across from the data sheet. The thickness, the head data and every rate are yours to type in.
The two tabs are linked so that a number is typed only once. The inside diameter, the tangent-to-tangent length and the quantity flow from the data sheet into the cost build-up, so the cost build-up cannot quietly price a different vessel from the one you read. The tangent-to-tangent length is the length of the vessel between the two lines where the heads start to curve.
The nozzle table is linked the same way. The cost build-up counts the nozzles of each size and flange class on that tab, and a check line warns you if a nozzle on the list has no price beside it.
The rows that move the price most
Most of the 72 rows are quick to fill in. A handful of them can move the price of the same vessel by a large amount, and these are the ones to read twice.
Radiography and joint efficiency
Radiography means taking X-ray or gamma-ray pictures of the welds to find hidden defects, and ultrasonic testing is often used in its place. The amount of radiography the package asks for sets the joint efficiency, which is a number the code uses to discount the strength of a welded seam.
For the most common seam, a butt weld made from both sides, Table UW-12 of Section VIII, Division 1 gives a joint efficiency of 1.0 with full radiography, 0.85 with spot radiography and 0.70 with none. Because a lower joint efficiency lets the designer count on less strength, it makes the shell thicker (the thickness formula in UG-27 uses it).
So less radiography saves inspection cost but adds plate weight and welding. Full radiography also carries repair risk, because every weld that fails the film has to be ground out, welded again and shot again.
MDMT and impact testing
MDMT stands for minimum design metal temperature. It is the coldest metal temperature the vessel is designed for, and it is often set by winter weather at the site or by a process that can chill the vessel.
Cold steel can break in a brittle way, so the code checks the MDMT against the material and its thickness. UG-20(f) and the curves in UCS-66 decide whether the steel is exempt. If it is not exempt, the plate, the welds and the weld procedures need Charpy impact tests under UG-84, in which a small notched bar of the metal is broken at a set cold temperature to measure how much energy it absorbs.
On the cost side, an MDMT that fails the exemption means impact-tested plate and flanges, which cost more and take longer to arrive. It can also mean a new weld procedure qualification with its own test plates and lab fees.
Post-weld heat treatment
Post-weld heat treatment, or PWHT, means heating the finished vessel or its welds to a set temperature and holding it there to relieve the stresses that welding leaves in the steel.
It can be required for two different reasons, and the data sheet should record which one applies. UCS-56 requires it for carbon steel above a thickness limit. Owners also ask for it for service reasons, for example when the fluid can cause stress corrosion cracking, as amine and caustic solutions can.
Either way it is a priced line: furnace time or a local heat treating contractor, extra handling, and days added to the schedule. Lethal service (UW-2), which the owner has to name in the package, brings PWHT for carbon steel along with full radiography of the butt welds.
Code stamp and National Board registration
A vessel built to ASME Section VIII, Division 1 and stamped carries the ASME Certification Mark with the U designator. To apply it, the shop needs its own ASME certificate, and an Authorized Inspector from its inspection agency has to review the work and sign the Manufacturer's Data Report, which is Form U-1 or the shorter Form U-1A for single-chamber vessels (UG-120).
National Board registration is a separate step, done through the National Board of Boiler and Pressure Vessel Inspectors. The shop stamps the NB mark and a registration number on the nameplate and files the data report with the National Board. Some owners and jurisdictions require it, so check whether the package asks for it.
People sometimes mix up the stamps. The R stamp also belongs to the National Board, but it is for repairs and alterations to existing vessels, not for building new ones.
Corrosion allowance
The corrosion allowance is extra metal added to the thickness the code requires, so the vessel can lose metal to corrosion over its life and still be strong enough. If the code needs 1/2 inch and the package asks for a 1/8 inch allowance, the shell becomes 5/8 inch, which is a quarter more plate.
The allowance usually applies to the heads and nozzle necks as well, so a small number on the data sheet reaches almost every pressure part.
Nozzles and flange ratings
Each nozzle is a neck, a flange, a hole cut in the shell, a weld, and often a reinforcing pad around the hole. The flange class, such as 150, 300 or 600 under ASME B16.5, sets how heavy the flange is, and a higher class at the same size is a heavier and more expensive forging.
The facing is the shape of the flange's sealing face, such as a raised face or a ring-type joint, and ring-type joints cost more to machine. Because the cost build-up counts nozzles straight from the nozzle table, a nozzle added to the list shows up in the price.
Testing
The standard hydrostatic test fills the vessel with water and pressurizes it to 1.3 times the MAWP times the stress ratio (UG-99). MAWP is the maximum allowable working pressure, the highest pressure the finished vessel is rated for, and the stress ratio adjusts for steel being stronger at the test temperature than at the design temperature.
The cost of the test changes with a few details on the data sheet: whether a vertical vessel is tested lying down in the shop, whether the owner's inspector must witness it, and, for stainless steel, whether the test water must be low in chlorides. A pneumatic test, with air or gas instead of water, is allowed only when the vessel cannot safely be filled with water (UG-100), and it needs extra safety precautions.
Surface preparation and coating
Blasting and painting are priced by area, so the cost build-up works out the outside area of the shell from the diameter, the thickness and the length. You add the area of the heads from the head maker's data and a rate per square foot.
The rate depends on the blast standard, for example SSPC-SP 6 commercial blast or the cleaner SSPC-SP 10 near-white blast, and on the number of coats and their thickness. An internal lining is usually a specialist subcontract with its own price per square foot.
Documents and third-party inspection
Owner packages often ask for far more paper than the code does: drawings for approval, calculation reports, an inspection and test plan (ITP), the welding procedure specification and its qualification record (WPS and PQR), material test reports and a final data book. Each of these is engineering or quality hours, and a slow approval cycle delays the material order.
Third-party inspection means the owner sends its own inspector in addition to the Authorized Inspector. Every hold point in their plan is a moment when work stops until they arrive, so count the hold points and price the waiting.
Every row of the pressure vessel data sheet, and why it changes the price
Owners and engineering firms call this document a mechanical data sheet or a pressure vessel specification sheet, and theirs usually arrives inside the bid package. The version in the spreadsheet is the shop's reading of it, with the cost reason written beside every row.
Here is the full list as it appears in the Excel file. Open a group to read its rows. In the file, each row also has columns for what the package says, the document and page, and your question for the customer.
General6 rows
| Item | Changes the price because |
|---|---|
| Customer and end user | The end user's own standards often apply on top of the buyer's, so you need to know whose specification governs before you price anything. |
| RFQ or inquiry number and revision | Pricing an old revision is one of the easiest ways to miss a changed requirement, so note the revision you priced. |
| Item tag number | The tag ties every document in the package to this vessel, and a package for several vessels can give each one different rules. |
| Service (what the vessel holds) | The fluid decides the materials, the corrosion allowance and whether lethal or sour service rules apply. |
| Quantity (type the number only) | Identical vessels share engineering, drawings, setup and inspection visits, so the cost of each vessel falls as the quantity rises. |
| Quote due date | A short quote window limits how many questions you can ask, so more of the price rests on your own assumptions. |
Design conditions7 rows
| Item | Changes the price because |
|---|---|
| Internal design pressure (psig) | Pressure drives the shell and head thickness, which drives plate weight, welding time and sometimes the radiography and heat treatment. |
| External design pressure or vacuum | Vacuum or external pressure can call for a thicker shell or stiffening rings, which your engineer checks separately from internal pressure. |
| Design temperature (deg F) | The allowable stress of steel falls as the temperature rises, so a hotter design temperature means thicker parts and can change the material. |
| Minimum design metal temperature, MDMT (deg F) | A cold MDMT can mean Charpy impact testing of the plate, the welds and the weld procedures, or a switch to a tougher normalized plate. |
| MAWP, if the package states one (psig) | A stated MAWP above the design pressure can raise the thickness, the flange classes and the hydrotest pressure. |
| Operating pressure and temperature | The operating conditions tell you whether the vessel cycles, runs hot enough to need insulation, or runs cold enough to affect the MDMT. |
| Wind, seismic, nozzle and other loads | Wind, seismic and piping loads on nozzles can thicken the lower shell or skirt of a tall vessel and add engineering hours. |
Code and certification6 rows
| Item | Changes the price because |
|---|---|
| Design code and edition (for example ASME Section VIII, Division 1, edition per the contract) | The code and its edition set the rules and allowable stresses your engineer uses, and a different code or division changes the design, the inspection and the paperwork. |
| ASME Certification Mark with the U designator (U stamp) required? | A stamped vessel needs your ASME certificate, an Authorized Inspector's review and signature, and a Form U-1 or U-1A data report. |
| National Board registration required? | Registration is a separate step done through the National Board, with the NB mark on the nameplate and the data report filed with them, and it adds a fee and paperwork. |
| Authorized Inspection (your inspection agency) | Inspector cost grows with the number of hold points, the number of vessels and how often the inspector has to visit. |
| Third-party inspection by the owner | An owner's inspector adds their own hold points and witnessed tests, so work waits for their visits, and some contracts bill the visits to you. |
| Place of installation and local rules | Some states, provinces and countries add their own registration or design review, such as a Canadian Registration Number (CRN), which costs time and fees. |
Construction15 rows
| Item | Changes the price because |
|---|---|
| Inside diameter (inches, type the number only) | Diameter sets the plate width, the head size and the weight, and together with pressure it sets the thickness. |
| Tangent-to-tangent length (inches, type the number only) | Length sets the plate area, the number of shell courses and seams, and the floor space and handling the vessel needs. |
| Orientation (horizontal or vertical) | A horizontal vessel sits on saddles and a vertical one on legs, lugs or a skirt, and the orientation also changes how the shop does the hydrotest. |
| Head type (2:1 ellipsoidal, hemispherical, flanged and dished, flat) | Head type changes the head thickness, the head maker's price and the lead time, so ask the head maker to quote the exact type and size. |
| Shell material | The grade sets the price per pound of plate, its lead time, and how much testing and heat treatment the welds need. |
| Head material | Formed heads are usually bought from a head maker, so the grade and any heat treatment or testing after forming all show up in the vendor's price. |
| Nozzle neck material (pipe or forging) | Seamless pipe, welded pipe and forged necks are priced very differently, and large or heavy necks may have to be forged. |
| Flange material and standard | Flanges are priced by size, class and material, and alloy or impact-tested flanges cost more and take longer to get. |
| Corrosion allowance (inches) | The allowance is added to the thickness the code requires, so a larger allowance makes the shell, heads and nozzle necks heavier. |
| Radiography extent and joint efficiency (full, spot or none) | Less radiography lowers the joint efficiency and makes the shell thicker, while full radiography adds inspection cost and the risk of weld repairs. |
| Post-weld heat treatment (PWHT) and the reason for it | Heat treatment means furnace time or a heat treating contractor, extra handling and days added to the schedule, and the reason tells you whether it can be dropped. |
| Impact (Charpy) testing | Impact-tested plate and flanges cost more and take longer to arrive, and a weld procedure without impact tests may have to be qualified again. |
| Lethal or cyclic service | Lethal service brings full radiography of butt welds and PWHT for carbon steel, and cyclic service can need extra engineering for fatigue. |
| Sour service, hardness limits or other service rules | Sour service rules, such as NACE MR0175 / ISO 15156 or the owner's own, add hardness limits and tests, controlled materials and often PWHT. |
| Internals (baffles, demister pad, inlet device, vortex breaker) | Internals are usually bought in and then welded or bolted inside the vessel, which adds parts and slow hours of work in a tight space. |
Nozzles5 rows
| Item | Changes the price because |
|---|---|
| Nozzle schedule (list each nozzle on the Nozzle table tab) | Every nozzle is a neck, a flange, a cut in the shell, a weld and often a reinforcing pad, so the nozzle count drives a large share of the shop hours. |
| Flange classes and facings | A higher flange class is a heavier and more expensive forging at the same size, and ring-type joint faces cost more to machine than raised faces. |
| Manways, davits and hinges | A manway is usually the largest nozzle on the vessel, with a heavy blind flange, a davit or hinge, and its own gasket and bolts. |
| Reinforcing pads and nozzle projections | Reinforcing pads add plate and welding, and long projections add pipe and fit-up time. |
| Blind flanges, gaskets and bolts for spare or test nozzles | Many packages ask the shop to supply blinds, gaskets and bolts for spare nozzles, and they are easy to leave out of the price. |
Supports5 rows
| Item | Changes the price because |
|---|---|
| Saddles (horizontal vessels) | Saddles add plate, welding and wear plates, and a sliding saddle needs slotted holes or a slide plate. |
| Legs or support lugs (vertical vessels) | Legs and lugs are small parts with many welds, and heavy loads can need pads on the shell under them. |
| Skirt, base ring and anchor chairs (tall vertical vessels) | A skirt is a second cylinder with a base ring, anchor chairs and access openings, so it can be a large share of the weight and the welding. |
| Lifting lugs and tailing lug | Lifting lugs need a design check for the lifted weight and often a weld examination, and some owners also ask for a lifting plan. |
| Earthing lugs, nameplate bracket and other small attachments | Each small attachment is cheap, but together they add a long list of welds and hours. |
Testing5 rows
| Item | Changes the price because |
|---|---|
| Hydrostatic or pneumatic test | The standard hydrotest is at 1.3 times the MAWP times the stress ratio (UG-99), and a pneumatic test, which needs extra safety measures, is allowed only when the vessel cannot safely be filled with water. |
| Test position and who witnesses it | Testing a vertical vessel lying down changes how the weight of the water is counted, and each witness adds scheduling and waiting time. |
| Test water quality (chloride limit for stainless steel) | Stainless vessels often need low-chloride test water and quick draining and drying afterwards, which costs water and time. |
| Other examination (ultrasonic, magnetic particle, dye penetrant) | Ultrasonic, magnetic particle and dye penetrant checks on nozzle and attachment welds each have their own price, and a subcontractor often does them. |
| Extra tests (PMI, hardness, pad air test, leak test) | Positive material identification (PMI), hardness checks and air tests of reinforcing pads each add time, and many need a subcontractor or rented equipment. |
Surface preparation, lining and coating5 rows
| Item | Changes the price because |
|---|---|
| Blast standard (for example SSPC-SP 6 or SSPC-SP 10) | A cleaner blast standard takes longer and uses more abrasive for every square foot of surface. |
| Paint system and dry film thickness | Each extra coat and each extra mil of thickness adds paint and labour for every square foot. |
| Internal lining or cladding | Linings and cladding are usually specialist work priced per square foot, and they change how the vessel is welded, tested and handled. |
| Pickling and passivation (stainless steel) | Pickling and passivation is usually done in a tank or sent out, and it brings chemical and disposal costs. |
| Masking of flange faces and the nameplate | Masking takes time, and paint on a gasket face has to be cleaned off before the vessel ships. |
Insulation supports and clips3 rows
| Item | Changes the price because |
|---|---|
| Insulation support rings and clips | Rings and clips are many small welded parts, so their count matters even though each one is cheap. |
| Platform, ladder and pipe support clips | Clips for platforms, ladders and pipe supports are welded to the shell, and the owner's drawings decide how many there are. |
| Who supplies the insulation and fireproofing | Most shops supply only the clips and rings, so say clearly in the quote that the insulation itself is excluded if it is not in your scope. |
Documents7 rows
| Item | Changes the price because |
|---|---|
| Manufacturer's Data Report (Form U-1 or U-1A) | The data report takes quality staff time and the Authorized Inspector's signature, and owners usually want a copy in the data book. |
| Material test reports (MTRs) | Mill certificates have to be collected, checked and traced to each part, which takes quality and clerical hours. |
| Drawings for approval | Each approval cycle costs drafting and engineering time, and a slow approval holds up the material order. |
| Design calculations for review | Calculation reports from your design software take engineering time to prepare, and wind, seismic or nozzle load checks add more. |
| Inspection and test plan (ITP) | Every hold point in the ITP is a moment when work stops until an inspector has seen it. |
| Welding procedures (WPS and PQR) | If your existing procedures do not cover the material, thickness or impact test needs, a new qualification means test plates, lab tests and weeks of lead time. |
| Final data book (manufacturer's record book) | Data books can run to hundreds of pages, and owners often set the format, the index and the number of copies. |
Packing, shipping and spares3 rows
| Item | Changes the price because |
|---|---|
| Packing, crating and preservation | Export crating, desiccant bags and a nitrogen fill all cost material and labour, and shipping blinds may be yours to supply. |
| Delivery terms and freight | The delivery term decides whether freight, permits and escorts for an oversize load sit inside your price. |
| Spare parts (gaskets, bolts) | Spare gaskets and bolts for start-up are cheap but often required, so either price them or exclude them in writing. |
Commercial5 rows
| Item | Changes the price because |
|---|---|
| Required delivery | A short delivery can mean overtime, plate bought from stock at a premium, or other work moved aside. |
| Liquidated damages for late delivery | Damages for late delivery are a cost risk, so many shops add contingency or ask for a cap in the quote. |
| Warranty period and terms | A long warranty, or one that starts at start-up instead of at shipment, keeps the risk on your books for longer. |
| Payment terms and milestones | Payment on delivery means you carry the cost of material and labour until then, while progress payments reduce that cost. |
| Price validity and escalation | Plate prices move, so a long validity period without an escalation clause is a risk you are pricing. |
Where the numbers in the cost build-up come from
The spreadsheet does no code calculations. It does not work out the required thickness, the MAWP, the nozzle reinforcement, the test pressure or anything else that ASME Section VIII asks an engineer to calculate. Those numbers carry legal and safety weight, and they belong to your engineer and your design software.
From your engineer or COMPRESS
The shell and head thickness, the head weights, and the weights of saddles, skirts and pads all come from the design. COMPRESS is Codeware's design program for ASME Section VIII vessels, and it produces the design report and the weights.
From your own records
The shop rate, the hours for each operation, the drop and scrap allowance, the contingency and the margin are yours. Nobody else's rates belong in your quote, which is why every rate cell in the file is blank.
From vendor quotes
Formed heads, flanges and forgings, radiography, heat treatment, linings and freight come from your suppliers. Heads are usually bought from a head maker, so the sheet treats them as a purchased line at the maker's price.
The only arithmetic the sheet does itself is geometry and totals. It works out the shell plate weight from the inside diameter, the thickness, the shell length and the steel's density, using the mean diameter, which is the inside diameter plus one thickness. It also works out the outside area of the shell for painting.
The densities sit in a small table on the cost build-up, so you can change them to your mill's figures.
| Material | Density, lb per cubic inch | Basis |
|---|---|---|
| Carbon steel | 0.2836 | 490 lb per cubic foot divided by 1,728 |
| Stainless 304 / 304L | 0.286 | 7.93 g per cubic cm |
| Stainless 316 / 316L | 0.289 | about 8.0 g per cubic cm |
For plate parts that are not cylinders, such as saddles, wear plates and reinforcing pads, the metal weight calculator gives the weight of any plate, bar or tube.
The totals section adds up the five cost sections, spreads the one-time engineering over the quantity, and applies your contingency and margin.
Margin is your profit as a share of the price. On a cost of 100, a 20 percent margin gives a price of 125, while a 20 percent markup would give only 120.
To be clear about our own part: Mavlon does not have a released COMPRESS integration, and our AI Quoting Engine does not do code calculations. Your engineer still sizes the vessel.
If the customer also wants a clause-by-clause answer to their specification, the specification compliance matrix template does that job alongside this one.
Mavlon's AI Quoting Engine
How Mavlon's AI Quoting Engine fills in the data sheet
Filling in the data sheet by hand means reading the whole package, and an owner's vessel package can run to hundreds of pages of specifications, standards and drawings. Mavlon's AI Quoting Engine does that reading. It takes the customer's bid package and fills in a data sheet like this one, with every line tied to the document and page it came from, the conflicts between documents flagged, and the questions for the customer drafted.
From there the hand-off is the same as in this spreadsheet. Your engineer enters the design conditions in COMPRESS or whichever design software you use, the thickness and weights come back, and the engine prices the draft quote in your own pricing. Your estimator checks the draft and sets the final number.
We walked through a public 283-page refinery vessel package line by line in pressure vessel specification: from owner spec to a priced quote.
Frequently asked questions
Book a demo
See Mavlon's AI Quoting Engine read a bid package
In a short call we show the engine working through a customer's package: the requirements it writes down, the page behind every line, the questions it drafts, and the priced draft quote your estimator would check.
Book a demoYou do not need to prepare or send anything beforehand.
Sources. The code paragraphs on this page are UG-20(f), UG-27, UG-84, UG-99, UG-100, UG-120, UCS-56, UCS-66, UW-2 and Table UW-12 of the ASME Boiler and Pressure Vessel Code, Section VIII, Division 1, and they are referred to by number only. The U designator comes from ASME's certification page, and the form names come from ASME's data report forms page. National Board registration is described in the National Board's criteria for registration (NB-264), and the R stamp on its R Certificate of Authorization page. The description of COMPRESS comes from Codeware's product page. If you find a mistake, write to atishay@mavlon.co and we will fix it.