Get this set of calculators for piping design.

Download files for use with Excel:
Complete Suite
B31.1 +B31.3 +B31.4 +B31.5 Pkg.
B31.1 +B31.3 +B31.5 Pkg.
B31.1 +B31.3 Pkg.
B31.1 -2018
B31.3 -2016
B31.4 -2016
B31.5 -2016
B31.8 -2018
All Br Reinf
All Req'd Thk
All Allowable Pressures
All Br Reinf +All Req'd Thk
Single Files

January 27, 2019

Updates and Upgrades

Free updates may be requested by previous custimers within the 12 months following a purchase. There is no longer a discount offering. Previous custimers must pay the full product price for upgrading after 12 months following the date of original purchase.

January 25, 2019: corrected Pipe3 file which needed 3 cells unprotected and dimensions sheet unprotected by macro.

January 6, 2019: Hydrostatic and pneumatic testing for two B31.1 calculators: A new file, LeakTest.xlsm, was developed for required thicknesses with leak testing. The old allowable pressures file, Pipe1_.xlsm, now includes leak testing.

December 19, 2018: Hydrostatic and pneumatic testing for two B31.3 calculators: A new file was developed for required thicknesses with leak testing. The old allowable pressures file now includes leak testing.

November 29, 2018: Updated B31.8 fi;es to 2018 version. Added onshore required thickness formulas for case of D/t less than 30. Numerous notations and macros were changed.

September 5, 2018: Updated B31.1 fi;es to 2018 version. Numerous notations and macros were changed.

June 4, 2018: In Prop1.xlsm, corrected cell reference in weight of pipe formula .

December 7, 2017: Pipe dimensions data and related formulas were replaced in 26 files. The new data include API 5L pipe dimensions.

November 8, 2017: Added Integrally Reinforced Branch Outlet Fitting calculators for B31.3, B31.4, and B31.8 (ref. MSS SP-97) (NEW NEW NEW 11/7/2017)

August 8, 2017: Added dimension overrides for B31.1 and B31.3 mitered elbows, pipe bends, and SIF's (stress intensification and flexibility factors). Added new file for B31.4 pipe bend required thickness and allowable pressure (Based on B31.3).

July 20, 2017: Added 2 files for calculating extruded outlet tapping tees (full-encirclement, split, welded, flanged). They were designed with B31.1-2116 and B31.3-2016.

March 22, 2017: In Bend3, corrected required thickness of straight pipe and the adjusted value of Y on the Thickness Req'd sheet.

March 20, 2017: Updated files for B31.8 -2018 edition. There were numerous changes. All of the Low and Intermediate Alloy Steels have new stress values.

March 3, 2017: Updated files to B31.3-2016.

March 2, 2017: Corrected hyperlinks in files issued after October 1, 2016. The files are ReinfS1, ExtrBr1, ExtrBr3, ExtrTapT4, PipeThk5, ExtrBr5, PipeExp1, and PipeExp3.

February 28, 2017: Corrected Pipe1 file's use of allowances in calculations. Allowable pressures using either outside diameters or inside diameters now result in same values when a value for "A" is input.

January 1, 2017: Added file for B31.4 -2016 extruded outlet tapping tee (split full encirclement, welded).

January 1, 2017: Updated files for B31.8 -2018 edition. Offshore pipe required thicknesses and allowable pressures were reworked.

October 8, 2016: Added file for B31.8 -2018 extruded outlet tapping tee (split complete encirclement, welded). Updated macros in the B31.8 files so they work better with material selections. Rearranged branch reinf. ReSB8 file and checked it using example in B31.8.

October 6, 2016: Updated files per B31.1-2016 and B31.5-2016. Materials data were the only changes required.

March 11, 2016: Updated B31.4 files per 2016 version. Material notes revised per B31.4.

February 20, 2016: Fabricated bends files Bend1.xlsm and Bend3.xlsm were changed to show nominal thickness compared to minimum required thicknesses at all measurement locations. User-defined dimensions dialog boxes, links, and formulas were also revised.

January 21, 2016: Changed extruded outlet calculator files ExtrB1.xlsm, ExtrB3.xlsm, and ExtrB5.xlsm to use inside diameters when calculating minimum required thicknesses of extruded headers, and to use outside diameters for minimum thicknesses of connecting pipes.

   Ben A. Nottingham
   Email: PipingOffice

PayPal Acceptance Mark