Common Steel Piping Database   for Timberline Estimating

Introduction

The Common Steel Piping Database for Timberline Estimating is designed to support piping estimating for buildings, process facilities, power plants, and other facilities which include piping of the common steel pipe specifications.  The database supports conceptual estimating and detailed takeoff of designed piping.  It is designed to address the needs of Engineering and Design firms as well as Installation Contractors.  A piping fabricator may wish to have more detail than the base database provides.

This database includes piping items for the common steel piping types, sizes, schedules, and pressure ratings.  The database follows the a modular database design specification so it can be expanded or merged with other modular databases without conflicts or renumbering.

SCI has developed methods to quickly add additional piping materials and pipe specifications in the same structured manner to expand the piping database content.  These may be added in sections, such to add an additional group of pipe for different metal or specification.  Or additional parts and pieces can be added, such as additional fittings, flanges, valves, or hanger parts.  Because these methods have already been developed, the additions can be done at a reasonable cost.

Contents

The database contains approximately 2500 Phases, 53,000 Items, 70 Assemblies

All Items include dual units (inch and mm; psi and bar).  The database can be provided with imperial or metric quantity calculations.

The Common Steel Piping Database includes

• A120 Black and Galvanized Steel pipe with Cast and Malleable Iron threaded fittings

• A53/A106 Grade A ERW and Seamless pipe and Carbon Steel fittings with Butt Welded, Socket Welded, Threaded, Flanged, Victaulic Pressfit, and Grooved End fittings

• A53/A106 Grade B ERW and Seamless pipe and Carbon Steel fittings with Butt Welded, Socket Welded, Threaded, Flanged, Victaulic Pressfit, and Grooved End fittings

• Stainless Steel 304/304L and 316/316L ERW and Seamless pipe and Stainless Steel fittings with Butt Welded, Socket Welded, Threaded, and Flanged fittings

• Chrome P11 pipe and fittings with Butt Welded fittings

• Class 150 Cast Iron Cement Lined Flanged Pipe and fittings

• C151 Ductile Iron Cement Lined Flanged Pipe and C110 Flanged fittings

• Cast Steel valves: Gate, Globe, Ball, Butterfly, Check, Diaphragm, Plug, and Other; in weld end, socket end, threaded end, and flanged end; by pressure rating

• Stainless Steel and Bronze valves: Gate, Globe, Check, and Other; in weld end, socket end, threaded end, and flanged end; by pressure rating

• Pipe Insulation: Fiberglass, Foamglass, Urethane Foam, Calcium Silicate, Cellular Glass, Mineral Wool, and Phenolic Foam

• Basic Pipe Hangers, Supports, and Anchors

• Basic Bolt and Gasket sets

• Basic Painting & Coating

Piping Phases

• 20xxx – Non-specific metal items (such as hangers and bolted joints)
• 21xxx – Pipe/Fittings/Valves /Joints – Cast & Ductile Iron
• 22xxx – Pipe/Fittings/Valves /Joints – Steel
• 23xxx – Pipe/Fittings/Valves /Joints – Stainless Steel
• 24xxx – Pipe/Fittings/Joints – Chrome Alloy
• 254xx – (Non-Ferrous Metal) Valves – Bronze
• 29xxx – Pipe Coatings and Coverings

Phase code and item numbering is all numeric and highly structured, with digits corresponding to types and ratings.  The 20 series of phases is used to fully organize the database items.  The CSI Masterformat 1995 does not provide a convenient classification system for numerous piping items.

Item Details

All Phase/Item descriptions include dual units (inch and mm, psi and bar).  Database quantity and price units are available in Imperial or Metric units.

• All common schedules; Standard, XH, XXH, schedule numbers 5 to 160, 5S to 80S

• Sizes from ¼ inch (6 mm) to 60 inch (1500 mm), where available

• Plain end, threaded & coupled, grooved end pipe

• Butt weld, socket weld, threaded, and flanged fittings

• Mechanical fittings

• Fittings – 90 Ells, 45 Ells, Tees , Caps, Couplings, Reducers, Unions, Stub Ends

• Flanges – Weld Neck, Socket Weld, Threaded, Slip On, Lap Joint, Blind; by pressure rating

• Weldolets, Sockolets, Threadolets

• Valves – Gate, Check, Ball, Globe, Butterfly, Diaphragm, Plug, Other; by pressure rating and joint type

• Pipe erection labor selectable in 10 factored ratings:

0 – Normal - Inside 1-Story Bldg to 12' Ceiling                 
1 – Inside 1-Story Bldg High Ceiling                           
2 – Multi-Story Bldg, or Tunnel                                       
3 – Outside Grade to 12' High                                        
4 – Open Trench to 8' Deep                                            
5 – Supported Trench                                                    
6 – Rack                                                                      
7 – Process/Power Plant                                               
8 – Process/Power Plant – Congested                            
9 – Process/Power Plant – Heavy Congestion                 

• Joining labor Shop or Field:

• Butt Weld

• Slip On Weld

• Olet Weld

• Socket Weld

• Back Weld, or Seal Weld

• Bolted Joint

Pre-defined WBS

Item Material Pricing

- Representative list prices are used for all material items.
- Sample comparisons to standard pricing sources are available on request.  
- Items which are listed by Harrison Publishing House price update service are pre-coded with HPH
  Price Update Codes so that HPH pricing or price updating can be enabled.
- Bill of Materials – materials are coded with an organized material class structure

Item Labor Pricing

- Crew-based pricing is used for labor, with labor productivities expressed as mh/unit.
- All labor items are assigned representative productivities.
- One crew, consisting of a steamfitter/pipefitter is assigned to all labor.
- One rate table is included with a representative hourly rate for steamfitter/pipefitter.
- Productivities are based on SCI developed labor hours.  Sample comparisons to standard manhour
  sources are available on request.

Assemblies

Assemblies are included to support rapid take off of either detailed or conceptual piping.  Assemblies are designed to take off all items for a run of one size, schedule, pressure in each pass.

Assemblies are differentiated for shop fabricated vs. field fabricated piping and for differing joint methods; i.e. butt welded, socket welded, screwed, flanged (bolted), press fit, grooved end couplings.

Each piping assembly includes pipe, fittings, shop welds and/or field welds, valves, hangers and supports, insulation, coating, hydrotesting, and NDT.  The user may enter specific quantities or select built-in calculation of quantities based on underlying calculations and tables (which are adjustable by editing the database).  The selections for calculated quantities are based on entry of pipe complexity:

Simple; min fittings (approx. 2 ftg/100')
Moderate; avg fittings (approx. 8 ftg/100')
Complex; many fittings (approx. 14 ftg/100')
Highly Complex (approx. 25 ftg/100')

Selection of labor conditions (see above) is also included.

Items are selected for all possible entries made in the assembly takeoff.  The database includes NSPC (Non Specified) items in the event the assembly takeoff entries would have otherwise selected an item which does not exist in the database.

Assembly Names

All Piping assemblies begin with an upper case P.  This will allow for merging with other databases which use the Uniformat system of assembly coding.  Although P is not defined in Uniformat, neither is it used.

List of Assembly Groups

List of A53/A106 Assemblies