This Hydrotest / Pneumatic Test Pressure & Stored Energy spreadsheet from 3D-LABS follows ASME standards and gives instant, checkable results for practising engineers — no manual derivation required.
This spreadsheet calculates the required hydrotest pressure and pneumatic test pressure for pressure vessels and piping per ASME Section VIII Division 1 (UG-99/UG-100), ASME B31.3 (345.4), and PD 5500:2021 Annex M, and determines the stored energy in a pressurised system to establish safe exclusion zones during pneumatic testing — a mandatory safety calculation per OSHA 29 CFR 1910.217.
What standard does this calculation follow?
ASME Section VIII Div 1 UG-99 (hydrostatic test: 1.3 × MAWP × stress ratio), UG-100 (pneumatic test: 1.1 × MAWP), ASME B31.3 Clause 345.4.2 (hydro: 1.5 × design pressure × ratio), PD 5500:2021 Annex M, and OSHA 29 CFR 1910.217 for pneumatic test exclusion zones.
What formula is used?
ASME VIII-1 hydrotest pressure: PT = 1.3 × MAWP × (Stest/Sdesign), where Stest and Sdesign are allowable stresses at test and design temperatures. Stored energy in pneumatic test: E = (P1V1/γ-1)[1 – (P2/P1)^((γ-1)/γ)] in kJ, where γ = 1.4 for air. Exclusion zone radius R = 15(E/1000)^(1/3) metres per OSHA guidelines.
Frequently Asked Questions
What is the ASME VIII hydrotest pressure formula?
Per ASME Section VIII Div 1 UG-99(b): PT = 1.3 × MAWP × (St/S), where MAWP is maximum allowable working pressure, St = allowable stress at test temperature, S = allowable stress at design temperature. If test is at ambient (St/S ≈ 1.0 for most carbon steels below 50°C), PT = 1.3 × MAWP.
What is the safe exclusion zone for a pneumatic pressure test?
The exclusion zone radius during pneumatic testing is calculated from stored compressive energy: E = P₁V₁/[(γ-1)] × [1-(P₂/P₁)^((γ-1)/γ)] in kJ. For a 1m³ vessel at 10 bar (air): E ≈ 2,200 kJ. Exclusion zone R = 15 × (E/1000)^(1/3) ≈ 19 metres. Personnel must remain outside this radius.
When is a pneumatic test permitted instead of hydrostatic test per ASME VIII?
Per ASME VIII-1 UG-100, pneumatic test (1.1 × MAWP) is permitted when: (1) the vessel cannot be safely filled with liquid, (2) traces of liquid cannot be tolerated, or (3) the vessel’s support structure cannot carry the hydrostatic load. The owner must certify that pneumatic test is required. Pneumatic test stores far more energy than hydrotest — risk analysis is mandatory.
What’s Included
An instant Excel download with the complete formula set, a worked numerical example, and reference to the governing standard — ready to adapt to your own project inputs.
