Lets you get the allowable stress for any material in ASME B31.3 Table A-1.

Parameters

Output

Basic Allowable stress at temperature, in MPa or ksi

Note (i) Metric allowable stress is calculated using ksi x 6.895 rather than using the metric table. Note (ii) No check will be performed on minimum temperatures - the ambient allowable stress will be returned for any temperature below 100 deg. F.

Defining materials

At it's simplest, a material is entered as its Spec number followed by its grade. For instance, ASTM A106 Gr. B is entered as "A106 Gr. B" (we drop the "ASTM"). Entries are not case sensitive.

As some materials have multiple entries in B31.3 Table A-1 (to distinguish between thickness ranges or manufacturing process), we are also able to enter further identifying information as described below. This ensures that the correct allowable stress value is returned. You may wish to view the video on selecting materials at http://xtrados.com/x313.

The following table shows all the possible fields from Table A-1 that can be used to identify a material and whether they are recommended for use.

* You can use the wildcard % to only match on part of a description, e.g. Notes (14)(34) could be written as Notes (14%

Examples

Note: when you use the Excel insert function helper (fx button), you don't need to enter the quotation marks shown below - they will be added automatically. However they are required when you enter the formula directly in the cell or formula bar.