Updates and Upgrades
Previous customers, who made purchase within the past 12 months, may contact me for a download link or a discount code for purchasing updates and upgrades. Some previous customers will qualify for free updates. Discounts will range from 50% to 80%, depending on number of days since purchase was made. Previous customers must pay the full product price for upgrading after 12 months following the date of original purchase.Most recent changes:
January 10, 2012: Added new package of files per ASME B31.8 -2010. Revised pricing of previous files. Added Miscellaneous files sets to the B31.4 and B31.5 packages.
December 13, 2011: Revised B31.4 package in its entirity. The major changes in B31.4 package were: (1) Materials data were moved to a separate file; (2) changed the macros and formatting (especially materials data); (3) Changed the way system type and design factors are retrieved; (4) Replaced the file for branch reinforcement and included graphics which change when values or different graphic type has been selected. (5) Slurry pipelines design factor was added; and (6) Overrides are now included for design factor, design pressure, material data, and dimensions.
August 15, 2011: In PipeExp3.xlsm, some macro code needed ".xlsm" instead of ".xls"; In PipeThk3.xlsm, Miter3.xlsm, Bend3.xlsm, ExtrBr3.xlsm, and PipeExp3.xlsm: some buttons would not work due to macros which had been renamed and the buttons had not been reassigned.
May 20, 2011: Updated per ASME B31.3 -2010. All of the material data per ASME B31.3 -2010 is now included. Almost all of the stress values have been changed in B31.3 (Aluminum values have not changed since the 2008 version).
Corrected the B31.4 Pkg: (1) PipeThk4 file needed to allow over-ride of design factor; (2) Corrected forgings and wrought fittings material data.
May 9, 2011: Revised macros in all files which retrieve flange data (material and ratings data).
January 29, 2011: Revised per ASME B31.1 -2010 version
January 5 thru March 15, 2011: Added data for numerous materials per ASME B31.3 -2008.
December 13, 2010: Added metric conversions in pipe properties file. Corrected metric conversions and made extensive revisions in B31.3 pipe bending file. Corrected metric conversions in B31.1 pipe bending file
November 19, 2010: Revised form button controls to keep them from relocating while printing in an early version of Excel 2010. The fix was applied to all files which contain forms button controls. Old button format included (1) "Automatic size" and (2) "Move but don't size with cells." The revised button format has (1) no check mark with "Auto size," (2) "Move and size with cells," and (3) increased size of buttons so text will not be cut off when files are converted.
October 11, 2010: (1) Added error trapping in macros for files which have retrieval of flange data.
(2) Updated files for ASME B31.5 -2010 version. There were no materials data changes. Minor nomenclature changes were made in branch reinforcement and stress intensification.
October 4, 2010: (1) Files Bend3.xls and Bend3.xlsm were revised with following: Corrected NPS 3 OD dimension on Dimen sheet at cell E16. Added A234 and A420 steel fitting materials. Value for weld joint factors are now required to be manually input.
(2) Files ReinfS1.xls and ReinfS1.xlsm were revised with following: Placed the statement "On Error Resume Next" in macros "MainFlanges" and "CloseFlgs."
September 30, 2010: Files ReinfS1.xls and ReinfS1.xlsm were revised with following: formulas in Branch (1) sheet at cell B44; formula in Branch (2) sheet at cell B53; cell L58 had range name reference Dob2 changed to Dob2a; formula rearranced in cell Q66; range name reference tr2 changed to tr2_ in cell Q105. Also, changed print settings.
August 13 and 16, 2010: Pipe Support and Shoe Bearing calculator has been revised. (1) Formula in cell "F17" on "Support Calcs" sheet had incorrect range name reference which should have been "SInterp." The error caused reference allowable stress to show as "blank psi". (2) Formula in cell "Q43" was changed to find if either the insulation density or insulation thickness equals zero, and if so, would return zero for insulation cross-section area (This avoids a possible negative result for insulation cross-section and insulation unit weight.). (3) Formula in cell "M42" on "Shoe Bearing" sheet was revised to refer to the value in cell named "Sak" (found on "Support Calcs" sheet). The error caused incorrect result for "Pa" when metric units were chosen. (4) Formula in cell "M61" on "Shoe Bearing" sheet was revised to refer to the value in cell named "Wk" (found on "Support Calcs" sheet (The error caused incorrect result for "Ws".). Thanks to Ian May for asking about some formulas on the Shoe Bearing sheet. The first affected the 8/13/2010 update. Second asked if the formula for "PA" should have considered corrosion allowance, which led me to substitute "Tn" with "t" in the formula for "PA." I rechecked Moment of Inertia, and found it converted correctly. Value for "c" was not changed when tested on 8/13. For example: c = 3 mm = 0.1181 inch.
April 14, 2010: All files were updated or reviewed for updates.
- Flange data and dimensional data were placed in new files seperately from the calculations files.
- Graphics of branch types and line blanks (pancakes) will change the way they look when certain input has been made.
- Conditional formatting and data validation were updated.
- Cleared following boxes on Tools, Options: Update remote references; Save external link values; and Accept labels in formulas
- Layout and formatting have been altered. Printing macros have been adjusted.
- Changed range names which might have been same as cell addresses in future versions of Excel.
September 23, 2009: Changed title block and printing macros in B31.3 Chapter IX Hi-pressure Pipe calcs. Changed Dimension macros. Added Help.
August 11, 2009: Added reference markup on the B16_5 worksheets of ASME B16.5 -2003 (October, 2004 release) and ASME B16.5 -2009 (July, 2009 release)
July 15, 2009: Added A335 -P9 Alloy Steel in 9 files for B31.3 calculations.
July 1, 2009: Revised titanium items in the B31.3 calculator files: Added ASTM B861/B337 (seamless pipe), B862/B337 (welded pipe), B338 (tube), and B 363 (fittings).
May 6, 2009: In numerous files: changed print settings, changed help userforms, changed formatting, made more consistant displays
April 10, 2009: Changed saddle dimension input in B31.1 and B31.3 branch reinforcement files. The saddle width is now taken from the edge of branch OD, and the saddle branch must be at right-angle to run. Also, any part of the input width which extends beyond the maximum zone width cannot contribute for reinforcing area.
The web pages were converted to XHTML using HTML-Kit's Tidy software.
February 15, 2009: Updated files per ASME B31.3 -2008 Code version: (1) The user must now determine the values required for weld strength reduction factors, and (2) Weld P-numbers were revised for nickel alloys C276 and C22.
