Download files for use with Excel 2010 and later.
B31.1 +B31.3 +B31.4 +B31.5 Pkg.
B31.1 +B31.3 +B31.5 Pkg.
B31.1 +B31.3 Pkg.
B31.1 -2022
B31.3 -2022
B31.4 -2022
B31.5 -2019
B31.8 -2022
B31.9 -2020

Updated
September 18, 2023

Caculators for Metallic Piping and Pipelines

Complete Suite According to ASME B31.1, B31.3, B31.4, B31.5, B31.8, B31.9, and B31J

    Secure Download.   Save lots of time.

$505 US, single user        

This package is for use with Microsoft Excel 2010 or later. Files contain VBA macros:

  1. Calculators per ASME B31.3 -2022, 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
  1. 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)
  1. 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)
  1. Calculators per ASME B31.5 -2019, 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
  1. 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)
  1. 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.)
  1. 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)
  1. 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.
  The above are all of the files I current offer.
User Licenses:

Single User License: For use only by 1 person.

Multiuser License: If there are 3 or more users, including with access on a network and/or intranet, then the price would be 3 times single user price. Just enter 3 at checkout and get 1 download link in email.

For security, the individual or IT department should prepare a new folder which will contain extracted files. This folder would be copied to single users or made network accessible to all assigned multiusers, as applicable.

Security settings for the folder will likely show as blocked initally, which is good for testing on a standalone computer. (Search for Microsoft's various instructions for blocking or unblocking a folder or single file.).

Each user can put the files on more than one computer which he or she regularly uses.

Media & Delivery: The preferred method of delivery is a zipped file by download link. If requested, I can send files by attachments to 4 separate e-mails. The size of the FULL SUITE of over 55 calculator files is currently under 34 MB.

Updates & Upgrades: One free update may be requested by previous customers within the 12 months following a purchase. There is no discount offering.

Payment Methods:  You can purchase over the Internet with any major credit card, PayPal, or send check (cheque) or cash. You can send email directly to me to arrange for payment by check.

PayPal is a secure way to send and receive money online. It has been voted the second-most trusted company worldwide. PayPal Holdings, Inc. is an American multinational financial technology company operating an online payments system in the majority of countries that support online money transfers, and serves as an electronic alternative to traditional paper methods such as checks and money orders.

You do not have to register with PayPal to send money using your major credit card.

Shipping and Handling Costs: Shipping is not being offered because all sales are being handled by the download service, E-Junkie, or, rarely by email attachments.

Tax:  Tennessee state tax: Add 9.25 percent to total only if purchasing from an address in the state of Tennessee, USA. Foreign taxes are not collected by PipingOffice.

PayPal Acceptance Mark     Developed by Ben A. Nottingham, sole proprietor, USA
     Email: PipingOffice  Your privacy is important to me.