Updates and Upgrades
Free updates may be requested by previous customers within the 12 months following a purchase. There is no longer a discount offering. Previous customers must pay the full product price for upgrading after 12 months following the date of original purchase.
September 21, 2020: Updated B31.1 files to B31.1-2020 version.
July 12, 2020: Bend1.xlsm and Bend3.xlsm have corrections to dimension units. Also dimension data tables were revised.
December 23, 2019: Updated files to B31.4-2019 edition.
September 14, 2019: Updated colors and conditional formatting in numerous files of the full suite.
September 11, 2019: Updated layout in the B31.3 extruded outlet calculator file. Changed conditional formatting and colors in the B31.3 files.
August 27, 2019: Updated files to B31.3 -2018 edition, which had significant material data revisions.
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 -2019 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.Developed by Ben A. Nottingham, sole proprietor, USA
Email: PipingOffice Your privacy is important to me.