Piping Calculators per ASME B31.1, B31.3, B31.4, B31.5, B31.8, B31.9, B31.12

For Design of Metallic Piping, Tubing, and Pipelines

Get this set of calculators for piping design.

Files are for use with Microsoft Excel 2019 and later. Files contain VBA macros:

1. Calculators per ASME B31.3-2024, Process Piping:
   1. Allowable Pressures and Leak Testing of Pipe & Tube
   2. Required Thicknesses of Pipe & Tube
   3. Reinforcement of Welded Branch Connections (two files):
      1. One file allows design of individual branches and can check for overlapping reinforcement zones.
      2. Another file has a table w/ up to 190 branches.
   4. Reinforcement of Extruded Outlet Pipe Branch, para. 304.3.4
   5. Reinforcement of Extruded Outlet Tapping Split Tee (Welded, Complete Encirclement)
   6. Pipe Bending Required Thickness and Allowable Pressure
   7. Mitered Elbow Required Thickness and Allowable Pressure
   8. Integrally Reinforced Branch Outlet Fitting (ref. MSS SP-97)
   9. Line Blanks, Line Spacers, Spectacle Blinds (Fig-8's), and Restricting Orifices.
   10. Properties of Piping Materials (Dimensions, stresses, Young's modulus, thermal expansion, weights, UNS numbers)
   11. Hydrostatic and Pneumatic Leak Testing, Dimensional Properties, and Testing Data Sheet
   12. Chapter IX High Pressure -- Allowable Pressures of Pipe & Tube
   13. Chapter IX High Pressure -- Required Thicknesses of Pipe & Tube
   14. Chapter IX High Pressure -- Extruded Outlets

2. Calculators per ASME B31.1-2022, Power Piping:
   1. Allowable Pressures of Pipe & Tube
   2. Hydrostatic and Pneumatic Leak Test Pressures
   3. Required Thicknesses of Pipe & Tube
   4. Reinforcement of Welded Branch Connections (two files)
      1. One file allows design of individual branches and can check for overlapping reinforcement zones.
      2. Another file has a table w/ up to 190 branches.
   5. Reinforcement of Extruded Outlet Pipe Branch
   6. Reinforcement of Extruded Outlet Tapping Split Tee (Welded, Complete Encirclement)
   7. Pipe Bending Required Thickness and Allowable Pressure
   8. Mitered Elbow Required Thickness and Allowable Pressures
   9. Steam Safety Valve Installations (Discharge reactions, pressures, velocities, stress intensification factors)
   10. Properties of Piping Materials (Dimensions, stresses, Young's modulus, thermal expansion, weights, UNS numbers)

3. Calculators per ASME B31.4-2022, Pipeline Transportation Systems for Liquids and Slurries:
   1. Required Thicknesses of Pipe & Tube
   2. Allowable Pressures of Pipe & Tube
   3. Reinforcement of Welded Branch Connections (for Internal Pressures. Calculates 2 branches side-by-side, and reinforcement zones may overlap.)
   4. Reinforcement of Extruded Outlet Pipe Branch
   5. Reinforcement of Extruded Outlet Tapping Split Tee (Welded, Complete Encirclement)
   6. Integrally Reinforced Branch Outlet Fitting (ref. MSS SP-97)
   7. Pipe Bending Required Thickness and Allowable Pressure (ref. B31.3 method)

4. Calculators per ASME B31.5-2022, Refrigeration Piping and Heat Transfer Components:
   1. Allowable Pressures of Pipe & Tube
   2. Required Thicknesses of Pipe & Tube
   3. Reinforcement of Welded Branch Connections (two files)
      1. One file allows design of individual branches and can check for overlapping reinforcement zones.
      2. Another file has a table w/ up to 190 branches.
   4. Reinforcement of Extruded Outlet Pipe Branch
   5. Stress Intensification and Flexibility Factors

5. Calculators per ASME B31.8-2022, Gas Transmission and Distribution Piping Systems:
   1. Required Thicknesses of Pipe & Tube
   2. Allowable Pressures of Pipe & Tube
   3. Reinforcement of Welded Branch Connections --Types are: Unreinforced, Repad, Complete Encirclement, or Saddle (Angled 45 to 90-degrees. For internal pressures. Calculates 2 branches side-by-side, and reinforcement zones may overlap.)
   4. Reinforcement of Extruded Outlet Pipeline Header or Tee (Calculates 2 branches side-by-side, and reinforcement zones may overlap.)
   5. Reinforcement of Extruded Outlet Tapping Split Tee (Welded, Complete Encirclement)
   6. Integrally Reinforced Branch Outlet Fitting (ref. MSS SP-97)
   7. Fracture Control and Arrest (Charpy Testing)

6. Calculators per ASME B31.9-2020, Building Services Piping:
   1. Required Thicknesses of Pipe & Tube
   2. Allowable Pressures of Pipe & Tube
   3. Reinforcement of Welded Branch Connections --Types are: Unreinforced, Repad, Complete Encirclement, or Saddle (Angled 45 to 90-degrees. For internal pressures. Calculates 2 branches side-by-side, and reinforcement zones may overlap.)

7. Calculators per ASME B31.12-2023, Hydrogen Piping (Part IP, Industrial Piping):
   1. Allowable Pressures of Pipe & Tube
   2. Hydrostatic and Pneumatic Leak Testing, Dimensional Properties
   3. Required Thicknesses of Pipe & Tube
   4. Reinforcement of Welded Branch Connections (two files):
      1. One file allows design of 2 individual branches and can check for overlapping reinforcement zones.
      2. Another file has a table w/ up to 190 branches.
   5. Reinforcement of Extruded Outlet Pipe Branch
   6. Pipe Bending Required Thickness and Allowable Pressure
   7. Mitered Elbow Required Thickness and Allowable Pressure
   8. Material and Dimensional Properties of Pipe and Tube (Dimensions, Stresses, Young's Modulus, Thermal Expansion, weights, UNS numbers)
   9. Support Span, Shoe Bearing, Pipe Weights (including refractory lined & plastic lined)

8. Calculators per ASME B31.12-2023, Hydrogen Piplines (Part PL, Pipelines):
   1. Allowable Pressures of Pipe
   2. Hydrostatic and Pneumatic Leak Testing
   3. Required Thicknesses of Pipe
   4. Reinforcement of Welded Branch Connections
      The file allows design of 2 individual branches and can check for overlapping reinforcement zones.
   5. Reinforcement of Extruded Outlet Pipe Branch

9. SIF Calculations per ASME B31J -2017, Stress Intensification Factors (i-Factors), Flexibility Factors (k-Factors), and Their Determination for Metallic Piping Components (with 11-9-2017 errata)

10. Bonus Miscellaneous Non-Code:
    1. Support Span, Shoe Bearing, Pipe Weights (including refractory lined & plastic lined)
    2. Jacketed Pipe Weight and Data Calculations
    3. Jacketed Pipe Theoretical Column Buckling
    4. Theoretical External Collapsing Pressure (not per ASME)
    5. 3-D Offset and Triangle Dimension Calcs
    6. Expansion Joint Data Sheet
    7. Spring Hanger Data Sheet
    8. Pipe Bend Dimensions (Angle, Offset, and Special)
    9. Dimension Calculator, Metric & US Customary (mm, ft-inch-fraction, and decimal)
    10. Linear Interpolation - Example returns stress value after choice of material and temperature.