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 & 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:
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.
December 16, 2008: Updated calculators per new version B31.1a-2008 (Addenda to B31.1-2007) (8 files revised). Weld strength reduction factors (W) were introduced. A worksheet with W factors was added. Added materials A691-91 and Alloy 2507. Revised Ferralium 255, Duplex SS Alloys S31803, 2205, and two B42 copper materials.
December 10, 2008: Added material ASTM A 444 Alloy 625 (N06625) in the calculators for B31.3 (12 files revised).
September 29, 2008: Price for Theoretical External Collapsing Pressure calculator has been changed to $12. It had been offered as a free download since August 18, 2008.
September 16, 2008: Important corrections have made in the Pipe Allowable Pressure per ASME B31.1 calculator. The flange ratings were shown for reference, but they were not matched to the correct temperatures.
Also, the file for Required Thicknesses per B31.1 needed to have a few formulas revised on the Tables sheet. These allow stress and Y values to be included when input temperature is less than or equal to a lookup value.
September 14, 2008: In Branch Reinforcement per B31.3, corrected formulas for th, tb, and tb2. They had referred to the wrong value for weld joint quality and thus would not allow use of user-defined values.
September 11, 2008: Mitered Elbow per B31.1 was rearranged and a solution was added for widely spaced miter segments.
August 19, 2008: Major changes were made the support spacing and weights calculator file. Dialog boxes were added for selection of pipe and tubing materials, and their dimensions. New material tables were constructed for pipe, lined pipe, tubing, and vacuum tubing. Separate dimension tables were made for pipe, lined pipe, tubing, and vacuum tubing.
User-defined material and dimensions are input in a dialog box. A new dropdown control in the insulation input dialog box allows material choices and placement of default density for selected insulation material. Also, there is a text box for overriding the default insulation material name and density.
Liner data can be input for any pipe or tube. A lined pipe choice will cause data to be retrieved from a table. The "Links" sheet was reworked to accept data from the numerous user forms that were added.
August 18, 2008: Major rewrite was completed for the Theoretical External Collapsing Pressure calculator file. This file is now offered as a free download (or you can make a donation for it).
April 13, 2008: Added materials in B31.1 and B31.3 files. These include per B31.1: Alloy Ferralium 255 Superduplex SS (UNS S32550), Alloy 2205 Duplex SS (UNS S31803), Alloy 625 (UNS N06625), and Titanium Grades 1, 3, and 12. Alloy 2507 Superduplex SS (UNS S32750) was added per B31.3.
March 24, 2008: Updated support span and pipe properties files with B31.3-2006 material data. Changed formatting in Sup.xls file. Fixed problem when combo-box dropdown control stopped showing selection, by: Select the range which is referred to as the ListFillRange in the Properties window. Click Format, Cells..., Number tab, General, then OK.
I have had a few worksheets that would not display dates correctly. The only fix I could find was to create a new worksheet and cut-and-paste the old cells to it, but excluding the cells in which I had attempted to set date formatting. Has anyone else seen similar trouble?
February 25, 2008: Updated B31.1 files for version 2007. Rewrote and made corrections in files for calculating B31.1 pipe bend and mitered elbow.
February 15, 2008: Rewrote files for B31.3 pipe bend and mitered elbow.
February 10, 2008: Updated layout in numerous files. Added materials data in files for B31.1 -2006 calcs. Updated macros for printing. Added code to numerous files for unloading all userforms when closing.
October 11, 2007: Refrigeration Piping Code B31.5 - 2006 version updates were made. Most of the materials now have higher allowable stresses. The file changes are in both the main set and B31.5 packages.
August 13, 2007: The package per ASME B31.4 has been updated per version 2006, and a file has been added for calculating required thicknesses per B31.4.
July 25, 2007: In file SafetyVa.xls, unprotected cell "E40" on "Tables" sheet.
June 22, 2007: Updated 10 files per new version of ASME B31.3-2006. There were no changes to formulas or stress values in 9 of the files, but the file for high-pressure calculations per Chapter IX required a new formula and new titanium data.
June 29, 2007: Materials were added in 7 files.
