Piping Reference Data - Intergraph Smart 3D - Help

Intergraph Smart 3D Catalog

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Help
Version_S3D
11.x(2016)

After the initial Catalog database is created, you can use the Catalog task to define additional piping specifications and part data interactively in the Catalog task instead of defining your piping reference data in workbooks and then bulkloading the workbooks to the Catalog database.

If you have Intergraph Smart Materials, you can create piping specifications in Smart Materials, export them to Microsoft Excel workbooks, and then bulkload them into your catalog. Refer to your Intergraph Smart Materials documentation for more information.

Understanding how the piping reference data works is essential to effective use of the software. For example, when you route pipe, nearly everything you see on a Properties dialog box comes from reference data. While you route pipe, you are also constrained by piping specification rules in reference data. In addition, you need to read and understand the concepts and procedures about select lists. For more information, see Select Lists.

Piping Workbooks

The piping reference data is defined in multiple Microsoft Excel workbooks so that you can bulkload only what you need. The software delivers these workbooks to the [Product Folder]\CatalogData\Bulkload\Datafiles and to the [Product Folder]\CatalogData\Bulkload\SampleDataFiles folders. The complete list of available piping specifications is in Appendix: Delivered Pipe Specifications.

The following piping reference data workbooks are delivered in [Product Folder]\CatalogData\Bulkload\Datafiles folder:

Piping Specification.xls
Piping Catalog.xls
Piping Specialty Data.xls
Piping.xls
Instrument Data.xls
On-the-fly Instruments.xls
On-the-fly Piping Specialties.xls
Ten_Specs_CatalogData.xls
Ten_Specs_SpecificationData.xls

The following piping reference data workbooks are delivered in [Product Folder]\CatalogData\Bulkload\SampleDataFiles folder:

1S6470 Catalog.xls
1S6470 Specification.xls
4C0844 Catalog.xls
4C0844 Specification.xls
9L3760 Catalog.xls
9L3760 Specification.xls
Additional data for ASME B16.47 Flanges Catalog.xls
Additional data for ASME B16.47 Flanges Specification.xls
Automated Selection of Parts at Spec Break Rules.xls
Bio Pharm Catalog.xls
Bio Pharm Specification Catalog.xls
Bolt Commodity Code Substitution.xls
Bolt Diameter Equivalence.xls
BoltSelection Filter for Nozzles Sample data.xls
Clamp-on Flow Sensor Sample Data.xls
ComponentInsulationExclusion.xls
Connection Parts Commodity Code Substitution.xls
Field Lining Thickness.xls
Flange Insulation Kits Sample Data.xls
Flared Piping Catalog.xls
Flared Piping Specification.xls
FlexibleHoseAssemblyRuleData.xls
FlexibleHoseCodelists.xls
GasketSelection Filter for Nozzles Sample Data.xls
Instrument Sample Data.xls
Jacketed Piping Catalog.xls
Jacketed Piping Specification.xls
Non Radial Branches.xls
Pipe Bending Manufacturability Rules.xls
Pipe Sleeve with Puddle Flange Sample Data.xls
Piping Commodity Procurement Data.xls
Piping Specialty Sample Data.xls
Reportable Commodities for Filters.xls
Sample Codelist for Surface Mounted Components using PCF.xls
Sample Codelists.xls
Sample Data Flange Face Adapter.xls
Sample Data for 45 Degree Angle Valve.xls
Sample Data for Angle Lift Check Valve.xls
Sample Data for BoltLengthLookupRule.xls
Sample Data for Butterfly Valve.xls
Sample Data for Check Valve with External Spring Operator.xls
Sample Data for Concentric Reducer Biological-pharmaceutical.xls
Sample Data for Coupling.xls
Sample Data for Deck Scupper.xls
Sample Data for Detailed Valves.xls
Sample Data for Double Basket Strainers.xls
Sample Data for Dresser Coupling.xls
Sample Data for Drilling Templates of Flanges.xls
Sample Data for Elbows.xls
Sample Data For End Preparation Compatibility Exceptions Rule.xls
Sample Data for Exhaust Heads.xls
Sample Data for Expansion Joints.xls
Sample Data for Filters.xls
Sample Data for Fire and Safety Symbols.xls
Sample Data for Fitting Reducer.xls
Sample Data for Fittings.xls
Sample Data for Flame Arresters.xls
Sample Data for Flanged Elbow-Pipet.xls
Sample Data for Flanged Olet.xls
Sample Data for Flex Coupling.xls
Sample Data for Foam Chamber.xls
Sample Data for GooseNeck Bull Plug.xls
Sample Data for Half Coupling.xls
Sample Data for Hose Connection.xls
Sample Data for Hose Couplings.xls
Sample Data for Hydraulic Flanges.xls
Sample Data for Jacketed Piping Symbols.xls
Sample Data for JIS Fittings.xls
Sample Data for Lap Joint Flanges.xls
Sample Data for Latrolet.xls
Sample Data for Long Sweep Tees.xls
Sample Data for Long Tangent Elbows.xls
Sample Data for Mining Symbols.xls
Sample Data for Mitered Elbows.xls
Sample Data for NPDCompatibilityExepRule.xls
Sample Data for On-the-fly Instruments.xls
Sample Data for On-the-fly Specialties.xls
Sample Data for Open and Blind Spacer set.xls
Sample Data for Orifice Flanges with Multi Taps.xls
Sample Data for Orifice Flanges with Two Taps.xls
Sample Data for Rupture Disc with Holder.xls
Sample Data For Reinforced Branches using Implied Pipe Stock.xls
Sample Data for Saddles.xls
Sample Data for Sight Flow Indicators.xls
Sample Data for Silencers.xls
Sample Data for Siphons.xls
Sample Data for Spectacle Blind.xls
Sample Data for Steam Traps.xls
Sample Data for Strainers.xls
Sample Data for Street Elbows.xls
Sample Data for Surface Mounted Components using PCF.xls
Sample Data for Surface Mounted Components.xls
Sample Data for Surface Mounted Doubler Plate.xls
Sample Data for Surface Mounted Insert Plate.xls
Sample Data for Surface Mounted Pipe Sleeve With Seal.xls
Sample Data for Surface Mounted Pipe Sleeve.xls
Sample Data for Tapered Spacers.xls
Sample Data for Tee with asymmetric branch.xls
Sample Data for Trimmable Olets.xls
Sample Data for Trimmable Reducing Tee.xls
Sample Data for True Wye.xls
Sample Data for Underground and Sanitary Symbols.xls
Sample Data for Vacuum Piping.xls
Sample Data for Valve Operators.xls
Sample Data for Valves.xls
Sample Data for Versionable Pipe Specs.xls
Sample Data for Weaker RPad Selecion.xls
Sample Data for Zero Radius Elbow.xls
Sample Data Piping Specification.xls
Sample data Reportable Piping Commodity Basis Reducing Fittings.xls
Sample End Generic Data for Socket Welded Fittings based on Socket Wall Thickness.xls
Socket Offset Rule.xls
Standard Nozzle Data.xls
Union Fitting Assembly Data.xls
Victaulic Catalog.xls
Victaulic Codelists.xls
Victaulic Plant Rules.xls
Victaulic Spec A4.xls
Victaulic Spec A11.xls

Because bulkloading all of these specifications would create a very large catalog, a subset of ten specifications is used to create the catalogdb.dat file that is delivered with the software. This subset of ten specifications is delivered in the Ten_Specs_SpecificationData.xls and Ten_Specs_CatalogData.xls workbooks and is listed below.

Specification Name

Materials Description

Fluid Service

1C0031

CL150 RFFE, CS, Trim 8, CA 0.063, Process, hot (-20 to 800 degF)

Process

1S3977

CL150 RFFE, 304/CS Valves, Trim 8

Lube and seal oil

1S3984

CL150 RFFE, 304/316 Valves, Trim 12

Process

2C0032

CL300 RFFE, CS, Trim 8, CA 0.063, Process, hot (-20 to 800 degF)

Process

2L1670

CL300 RFFE, 1.25Cr-0.5Mo, 316 Trim, MJ, other

Catalyst lift lines

2S3985

CL300 RFFE, 304/316 Valves, Trim 12

Process

4C0033

CL600 RFFE, CS, Trim 8, CA 0.063, Process, hot (-20 to 800 degF)

Process

5C0390

CL900 BE/RFFE, CS, Trim 5, (ASME-I)

Low pressure CL150 steam

6C0391

CL1500 BE/RJFE, CS, Trim 5, (ASME-I)

Low pressure CL150 steam

AC0014

CL125 FFFE, CS, Bronze Trim

Cooling water

The Piping.xls workbook contains four example pipe specifications (N0, N1, 1C0100, and 1C0101) that Hexagon PPM uses for testing purposes. These four example pipe specifications are also available in the delivered Catalog template file.

Specification Name

Materials Description

Fluid Service

N0

CL150, Carbon Steel, RFFE, Trim 8, < 50mm SWE, >= 50mm BE

Piping Spec N0 Service

N1

CL300, Carbon Steel, RFFE, Trim 8, < 50mm SWE, >= 50mm BE

Piping Spec N1 Service

1C0100

CL150 RFFE, CS, PTFE Lined, Std Trim, Flanged Pipe and Fittings

ASME Class 150 Process

1C0101

CL150 RFFE, CS, PTFE Lined, Std Trim, Flanged Pipe and Fittings

ASME Class 150 Process

See Also

Piping Rules
Commodity Codes
Pipe Specifications