Unlocked - Wall Thickness Calculation-12 Inch
Unlocked - Wall Thickness Calculation-12 Inch
Unlocked - Wall Thickness Calculation-12 Inch
Color Codes:
- user input is required in these cells. They directly affect the outcome of the calculation.
- no input required in these cells. Formulas are already set to calculate based on data entered by
user.
***Start your calculation in the title block (Project No.) and use the TAB key ONLY to
move between cells. You will not be able to select any cells that do not require user
input.***
Purpose:
This spreadsheet is designed to calculate 3 values:
1. The required wall thickness based on the design pressure and temperature.
2. The MAWP (maximum allowable working pressure) for pipe only
3. The hydrotest pressure that is required based on the design pressure and temperature.
Interpolation:
This spreadsheet will interpolate the required "S" value based on the temperatures and SA data entered.
Material Temp.1 (low) must be the lower temperature of the temperature range your design temperature falls
in between. Using 450°F as an example design temperature, your low temperature would be 400°F with the
corresponding SA for that temperature. Material Temp.2 (high) would be 500°F with the corresponding SA for
that temperature. If you design temperature's SA is defined in B31.3, then enter that temperature and SA
value in all the cells.
General Notes:
1. Most clients/projects will limit the wall thickness of carbon steel to no less than STD. WT. and stainless
steel to be no less than 10S. For any lines in vibrating service, 2 phase flow, and/or slug flow, do not go
below STD. WT. in carbon steel or 40S in stainless steels.
2. As noted on the actual calculation sheet, value "tm" should never exceed "T".
3. Some cells contain drop down boxes with selections already set. A value from the drop down must be
selected in order to proceed. Any other values entered will show an error. The exception is "D", Actual
Outside Diameter and Wall (in). You may input the required outside diameter or wall thickness if the data
needed is not listed in the drop down box. **Once you manually enter data in the wall thickness cell, the
formula will be erased and a new wall calculation sheet will need to be used for the next calculation -
DO NOT COPY & PASTE**
Definitions:
Basic Allowable Stress - this term, symbol "S", represents the stress value for any material determined by
the appropriate stress basis in para. 302.3.2 of ASME B31.3.
Mill Tolerance - For seamless pipe, use 12.5 (measured in percentage). For rolled plate, use 0.01
(measured in inches).
Quality Factor, "E" - Use the tab below titled "E" - Tables A-1A & A-1B for the required data.
Schedules & Thickness - Use the tab below titled Reference - Sch. & Thickness to check and/or assign
the correct value.
Sch. - Abbreviation for schedule, which is used to specify the nominal wall thickness of pipe. For example
Sch. 40, which in a 10" diameter pipe is .365".
Weld Joint Strength Reduction Factor, "W" - Not all materials are listed on the table excerpt in the
calculation. If your material is not listed, refer to ASME B31.3, table 302.3.5 for the correct material and value
to enter.
IF HE
Table 304.1.1 Values of coefficient 'Y' for t < D/6 Weld Joint Strenght Reduction Factor 'W'
Temperature, °F(°C) Per 302.3.5 (austenitic stainless & CrMo)