Required Worksheets - Intergraph Smart 3D - Administration

Intergraph Smart 3D Export PDS to Smart 3D

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
Version_S3D
12.x(2018)

This topic provides information about the worksheets that are required for loading into a new Catalog database.

If you are translating reference data from PDS, this information will be helpful as you edit the output from the translator.

prefix_Catalog.xls

Worksheet Name

Comments

CustomClassInterfaceList

CustomInterfaces

CatalogRoot

GUIDs

Revision History (optional)

Part Classes - dependent on the input files for the translation

Worksheets listed in bold are required.

prefix_Specification.xls

Worksheet Name

Comments

  • NPDEquivalence

  • MaterialsData

  • Bolt Extension

  • StandardNotesData

  • PipingMaterialsClassData

  • BoltCommodityCodeSubstRule

  • MinimumPipeLengthRule

  • WeldClearanceRule

  • WeldModelRepresentationRule

  • WeldTypeRule

  • PipingCommodityMatlControlData

  • ValveOperatorMatlControlData

  • PipingSpecialtyClassData

  • PipingInstrumentClassData

  • PipingCommodityProcurementData

DefaultProjectOptions
ShortCodeHierarchyRule
PreferredStudBoltLength
StudBoltCalculationTolerance
PreferredMachBoltLength
MachBoltCalculationTolerance
PreferredCapScrewLength
CapScrewCalculationTolerance
WeldModelRepresentation
PortAlignment
SlipOnFlangeSetbackDistance
WeldTypeRule
DefaultChangeOfDirection
DefaultCommoditySelectionRule
MinimumPipeLength
MinPipeLengthPurchase
FieldFitLength
MatingPorts
FlaredPipe
FluidDensity
BoltExtension

These worksheets are project-related worksheets in the specification reference data.

Bulleted worksheets are present in the translated output file.

NPDEquivalence and MaterialsData worksheets are present in the output; however, they may be empty in the translated workbook.

Worksheets in bold are the minimum required.

Worksheets in italics are required only if the corresponding commodities exist in the piping commodity filter. For example, if stud bolts are present, then the PreferredStudBoltLength worksheet is required.

prefix_Specification.xls

Worksheet Name

Comments

  • Service Limits

  • Pipe Nominal Diameters

  • Pipe Branch

  • Permissible Taps

  • Joint Quality Factor

  • ThicknessDataRule

  • ReinforcingPadData

  • Reinforcing Weld Data

  • PipingCommodityFilter

  • BoltSelectionFilter

  • NutSelectionFilter

  • WasherSelectionFilter

  • GasketSelectionFilter

  • ClampSelectionFilter

CorrosionAllowance
MinimumPipeLengthRulePerSpec
MinPipeLengthPurchasePerSpec
PipeBendingElongation
PipeBendingElongationPerSpec
PipeBendRadii
BendAngles
DefaultChangeOfDirectionPerSpec
WeldClearanceRule
InsideSurfaceTreatment
ServiceLimitsForJackets
PipeBranchForJackets
PermissibleJacketAndJumperSizes
PermissibleJacketSizeExceptions
FlaredPipePerSpec
PortAlignmentPerSpec
FieldLiningThickness
PipeTakedownParts

These worksheets are specification- related worksheets in the specification reference data.

The bulleted worksheets are present in the translated output file.

Worksheets in this row are required for each piping material class.

Worksheets in bold are the minimum required.

AllCodeLists.xls

Worksheet Name

Comments

All worksheets

The translator does not convert codelists. Make sure that the codelists meet the project requirements.

AllCommon.xls

Worksheet Name

Comments

Material

OutfittingCrossSections

The required worksheets are shown in bold.

The AllCommon.xls workbook also contains worksheets with delivered generic data for piping.

BulkLoadIsoKeys.xls

Worksheet Name

Comments

All worksheets

This workbook is required for isometric drawing extraction.

Equipment.xls

Worksheet Name

Comments

All worksheets

This workbook is required for equipment placement.

GenericNamingRules.xls

Worksheet Name

Comments

All worksheets

Required.

InsulationData.xls

Worksheet Name

Comments

All worksheets

This workbook is required if you want to have insulation specifications.

StructCrossSections-AISC-LRFD-3.0.xls

Worksheet Name

Comments

All worksheets

This workbook is required for placement of US steel sections.