piping_design_info.xls

(4/18)

Description

Piping Design Data and Calculators

A large reference workbook for piping designers, from www.pipingdesign.com, that collects dimensional tables for pipe, fittings, flanges and structural steel together with a few small layout calculators. Most sheets are look-up tables rather than calculations. Many tables are given in both inch and metric (M) versions.

Contents

  • Make-up dimensions by pressure class (150, 300, 600, 900 and 1500 lb, including ring-joint versions for 900 and 1500 lb): pipe OD, weld neck flanges, tees, reducers, caps, elbow and flange combinations and gate, check, globe, butterfly and wafer check valves
  • Fittings and flanges: screwed fittings, weldolets, elbows, tees and reducers, flange dimensions and weights, 2:1 elliptical head dimensions
  • Pipe data: pipe tables (wall, weight, water weight, surface area) and suggested maximum spans for water-filled carbon steel (A53 Gr B) pipe below 650°F
  • Structural steel: W, M, S and HP shapes, channels, MC channels, angles, W and S tees, tubing, grating, bolts, plate and girder weights
  • Calculators: right and oblique triangle solvers, brace lengths, a feet-and-inches adding calculator, stair and fixed ladder notes, and the maximum bracket spacing for platforms on vertical vessels

Inputs and outputs

The tables need no input. The calculators take dimensions in feet and inches (with metric conversions), for example the sides or angles of a triangle, and return the missing dimensions.

Please note

  • The data are compiled from manufacturers’ and standard tables of the time; check critical dimensions against current standards and the supplier’s data.
  • The pipe span table is a rule-of-thumb guide; it is not a stress analysis.
  • Most sheets are protected; the password is given on the Adding Calculator sheet. The file is about 3.4 MB. No macros.

Source: www.pipingdesign.com. Further reading: Piping Calculations Manual; Pipeline Rules of Thumb Handbook; McKetta, Piping Design Handbook; Nayyar, Piping Handbook; The Fundamentals of Piping Design; Pocket Guide to Flanges; Nayyar, Piping Databook.

Calculation Preview

29 May 2008
File Size 3,351.50 Kb
Downloads: 1359
File Version: 1.0
File Rating (4/18)

 
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 1
ron_mitchell 18 years ago
Good information to have in a spreadsheet. I will have to verify that the data agrees with reference books. Once done, it will save time having the data at hand.