Attachment.

A2-2
A2.2 Spec Detail
A2.2.1 Default Project Option (Plant Option)
"DefaultProjectOptions"sheet below defines most general plant rule that is applied in whole plant.
Here gives the instruction for the parameter that is commonly used in SP3D.

CmdtyCodeDependenceOnSchedule

PipingSpecVerManagementOption
GsktSlnForMismatchBltdEndsOpt
PipingCmdtyProcurementDataOpt
NonRadlTangtlBranchODMultplier

NonRadlOffsetBranchODMultplier
CapScrewLengthRoundOffOption

PipingCmdtyCtlgPartNoBasisOpt

DefaultPipeBendingMachineNum
PipingCommodityOverrideOption
MachBoltLengthRoundOffOption

CapScrewLengthRoundOffValue

BltCmdtyCodeExpnSubstOption
PipeBendRadiusMultiplierOption

AutoIndCmdtyCdCreationOption
BoltDiameterEquivalenceOption

PipingSpecificationNotesOption
StudBoltLengthRoundOffOption

MachBoltLengthRoundOffValue

MinimumPlateFlangeThickness
IndustryCommodityCodeOption

AutoBranchDataCreationOption

HeaderBranchSizeBasisOption
UndefinedServiceLimitsruleOpt
StudBoltLengthRoundOffValue

PipeBendRadiusByUserOption

CommodityCodeBuilderOption
SpecOrCatalogVerificationOpt

GasketSelBasedOnFluidCode
PurchaseLengthBasisOption
OletBranchOwnershipOption

BoltLengthCalculationOption
CapScrewEngagementGap

MaterialDescBuilderOption
HyperlinkToHumanSpec
DefaultIndustryPractice
WasherCreationOption
NutCreationOption

DensityOfWater

Description
Name
Head
Start
A 5 5 15 0.25in 15 0.25in 15 0.25in 0.25in 5 5 5 5 0.5in 1000Kg/m3 5 5 0.5 0.375 5 15 5 10 10 5 10 5 10 10 5 5 5 5 10 1 10 1
End

①② ③ ④

① ： Which commodty code to be used when selecting piping parts from catalogue
5 --> Industry Commodity Code
10 --> Contractore Commodity Code
15 --> Client Commodity Code

② ： Branch type fitting such as "Olet" shall be included to "Main Pipe" or "Branch Pipe"
when output Isometric Drawing.
5 --> Main Pipe
10 --> Branch Pipe

③ ： Pipe Bend Radius will be calculated by multiplying "Multiplier" to

5 --> NPD (Nominal Pipe Diameter)
15 --> OD (Outside Diameter)
the multiplier is defined in "BendRadiusMultiplier" attribute in "PipinngCommodityFilter sheet".

④ ： Inputting piping model without ServiceLimit (Pressure/Temperature) is allowed or not.

5 --> Not allowed. Operator must input pressure and temperature.
10 --> Allowed. But warning message will appear when inputting without pressure/temperature.

A2.2.2 ShortCode
ShortCode that is defined in "PipingCommodityFilter" is listed in ribbon ber when inputting piping components.

(PipingCommodityFilter)
SecondSizeFrom
FirstSizeFrom

FirstSizeUnits
OptionCode

FirstSizeTo
SpecName

ShortCode

AG1A 45 Degree Direction Change 1 0.5 1 in

"ShortCode" 45 Degree Direction Change 1 1.5 6 in
Gate Valve 1 0.5 1.5 in
Gate Valve 1 2 10 in
Gate Valve 1 12 18 in
Globe Valve 1 0.5 1.5 in
Globe Valve 1 2 8 in
Nipple 1 0.5 1 in
Piping 1 0.5 1 in
Piping 1 1.5 6 in
 Attachment.A2-2
ShortCode is defined in "ShortCodeHierarchyRule" sheet in SPEC.xls and can be customized as you like.
However, when you create new ShortCode, be careful to select correct "ShortCodeHierarchy Type" as the parent.

ShortCodeHierarchyType
(ShortCodeHierarchyRule)

ShortCode
Head
Start
A Olet type Branches BRW
A Olet type Branches Boss
A Olet type Branches Reinforcing Weld
A Olet type Branches Reinforcing pad
A2.2.3 PipingCommodityFilter
Piping Material Specification is defined in "PipingCommodityFilter"
This defines ShortCode and Commodity Code to be used in each material class.

SecondSizeUOMBasisInCatalog

QuantityOfAltReportableParts
AltReportableCommodityCode
FirstSizeUOMBasisInCatalog
FabricationCategoryOverride
SupplyResponsibilityOverride

AssociatedCommodityCode
QuantityOfReportableParts
ReportableCommodityCode
MaximumTemperature
MinimumTemperature

SecondSizeSchedule

PreferredPipeLength
BendRadiusMultiplier
JacketedPipingBasis

NumberOfMiterCuts
FirstSizeSchedule
SecondSizeUnits
SecondSizeFrom

CommodityCode
MultiSizeOption

EngineeringTag
SelectionBasis
SecondSizeTo
FirstSizeUnits
FirstSizeFrom

PDSModifier

PipingNote1
OptionCode

BendRadius
FirstSizeTo

Comments
SpecName

ShortCode
Head

Start
AG1A 45 Degree Direction Change 1 0.5 1 in FELBOW45SW
45 Degree Direction Change 1 1.5 6 in 70 FELBOW45BW SCH40
45 Degree Direction Change 1 8 18 in 70 FELBOW45BW SCH20
Boss 1 2 64 in 0.5 1.5 in FBOSSSWA
Concentric Size Change 1 1 1 in 0.25 0.75 in FREDUCERSW
Concentric Size Change 1 1.5 1.5 in 0.5 1 in FREDUCERBWCON SCH40 MATCH
Concentric Size Change 1 2 2 in 0.5 1 in FREDUCERBWCON SCH40 MATCH
Flange 1 0.5 1 in 5 LWNRF150 SCH80
Flange 1 1.5 24 in 5 LSORF150
Gate Valve 1 0.5 1.5 in VGATE602
Gate Valve 1 2 10 in VGATE150
Wafer Check Valve 1 28 40 in VENWAFERCHECK150
Reinforcing Weld 1 6 24 in 2 10 in 25
End

① ② ③ ④ ⑤ ⑥ ⑦ ⑧

① ： SpecName and ShortCode is defined as per Piping Material Specification

② ： "OptionCode" is defined in "CommodityOption" sheet of "AllCodeList".

"1" is default value and each ShortCode item must have default option code of "1".

③ ： First Size and Second Size are defined by each symbol definition and catalog data.

④ ： SelectionBasis is defined in "SelectionBasis" sheet in "AllCodeList".

Following list value are commonly used.
5 --> Flange selection logic is enabled (Auto Mating Flange Generation)
25 --> Stub-on reinforcing weld by system
70 --> Elbow, trimmed (to enable inputting elbow with special degree)
 Attachment.A2-2
⑤ ： CommodityCode

⑥ ： Schedule Thickness for But Weld connection.

"MATCH" can be used when the second size schedule is selected based on mating piping wall thickness.

⑦ ： "ReportableCommodityCode" are used for generating piping parts automatically under certain condition.
For example, when "LapJointFlange" are specified in ShortCode, the CommodityCode of "StubEnd" are inputted in this field.
(StubEnd is generated automatically when LapJointFlange is inputted.)

⑧ ： "BendRadiusMultiplier" is used to define Bend Radius Multiplier of Pipe Bend such as smooth bend.
For example, if we set "3" in this field, the bend radius of pipe bend will be 3 times of NPD or OD
as specified in DefaultProjectOptions.

A2.2.4 Piping Commodity Material Control Data

"PipingCommodityMatlControlData" sheet defines material rule for each commodity code item.
ContractorCommodityCode

IndustryCommodityCode

ShortMaterialDescription
CIMISCommodityCode
ClientCommodityCode
SecondSizeFrom

SecondSizeUnits

MultiSizeOption
SecondSizeTo
FirstSizeFrom

FirstSizeUnits
FirstSizeTo
Head

Start
BSBOLTNUT BSBOLTNUT STUD BOLT&NUT HEAVY NUT A193-B7(GAL)/A194-GR.2H(GAL) - -
FTEESW3000 FTEESW3000 SW TEE 3000LB SW A105 - - ANSI-B16.11 [403]
FRTEEBW FRTEEBW BW REDUCING TEE - BW A234-WPB - - ANSI-B16.9 [416]
FRTEEBWSML FRTEEBWSML BW REDUCING TEE - BW(SML) A234-WPB - - ANSI-B16.9 [416]
FRTEESW3000 FRTEESW3000 SW REDUCING TEE 3000LB SW A105 - - ANSI-B16.11 [407]
GV6596300G GV6596300G GASKET V-6596 SP-WD GR.304L+GRAFOIL I&O-R C.S OR EQ. ANSI300 3.0T FLAT RING
GV6596300NA GV6596300NA GASKET V-8596 SP-WD GR.304+NON ASBESTOS I&O-R C.S OR EQ. ANSI300 3.0T FLAT RING
LWNRF150 LWNRF150 WN FLANGE A105 - ANSI150 WN RF - - ANSI-B16.5 [407]
LWNRF300 LWNRF300 WN FLANGE A105 - ANSI300 WN RF - - ANSI-B16.5 [407]
PIPEA139BE PIPEA139BE PIPE A139-B E BE - - [401]
PIPEA53BSMLBE PIPEA53BSMLBE PIPE A53-B SML BE [401]
VGATE602STL VGATE602STL GATE VALVE API-602 CL.800 A105 13CR SEAT & DISK STL SW BB,OS&Y - -
VGATE602 VGATE602 GATE VALVE API-602 CL.800 A105 13CR - SW BB,OS&Y - -
VGATE300STLWG VGATE300STLWG GATE VALVE ANSI-B16.34 ANSI300 A216-WCB 13CR SEAT & DISK STL RF BB,OS&Y WHEEL WITH GEAR -
VGATE300STL VGATE300STL GATE VALVE ANSI-B16.34 ANSI300 A216-WCB 13CR SEAT & DISK STL RF BB,OS&Y - -
END

① ① ②
 Attachment.A2-2

SubstCapScrewCntrCommodityCode

ValveOperatorCatalogPartNumber

HyperlinkToElectronicManuals
AltOrientationCommodityCode

HyperlinkToElectronicVendor
LocalizedShortMaterialDesc

LooseMaterialRequirements

ReportableCommodityCode
QuantityOfReportableParts

SubstCapScrewsQuantity

ValveOperatorGeoIndStd
SubstCapScrewDiameter
LongMaterialDescription

MultiportValveOpReq
GasketRequirements
SupplyResponsibility

BoltingRequirements

WeldingRequirement

ValveOperatorType
TappedHoleDepth
FabricationType

PartDataSource
ReportingType
Manufacturer
Vendor
STUD BOLT&NUT HEAVY NUT A193-B7(GAL)/A194-GR.2H(GAL) - - 7 1 20 35 Bolt part data
SW TEE 3000LB SW A105 - - ANSI-B16.11 [403] 15 1
BW REDUCING TEE - BW A234-WPB - - ANSI-B16.9 [416] 15 1
BW REDUCING TEE - BW(SML) A234-WPB - - ANSI-B16.9 [416] 15 1
SW REDUCING TEE 3000LB SW A105 - - ANSI-B16.11 [407] 15 1
GASKET V-6596 SP-WD GR.304L+GRAFOIL I&O-R C.S OR EQ. ANSI300 3.0T FLAT7RING 1 20 35 Gasket part data
GASKET V-8596 SP-WD GR.304+NON ASBESTOS I&O-R C.S OR EQ. ANSI300 3.0T 7 FLAT RING1 20 35 Gasket part data
WN FLANGE A105 - ANSI150 WN RF - - ANSI-B16.5 [407] 15 1 5 5
WN FLANGE A105 - ANSI300 WN RF - - ANSI-B16.5 [407] 15 1 5 5
PIPE A139-B E BE - - [401] 15 1
PIPE A53-B SML BE [401] 15 1
GATE VALVE API-602 CL.800 A105 13CR SEAT & DISK STL SW BB,OS&Y - - 15 1 3 1 VENGATE150OPE
GATE VALVE API-602 CL.800 A105 13CR - SW BB,OS&Y - - 15 1 3 1 VENGATE150OPE
GATE VALVE ANSI-B16.34 ANSI300 A216-WCB 13CR SEAT & DISK STL RF BB,OS&Y
7 WHEEL 1WITH GEAR
5 -5 331 1 VENBUTTERFLY150OPE
GATE VALVE ANSI-B16.34 ANSI300 A216-WCB 13CR SEAT & DISK STL RF BB,OS&Y
7 -- 1 5 5 3 1 VENGATE150OPE

③ ④ ⑤ ⑥ ⑦ ⑧ ⑨
① ： "ContractorCommodityCode" and "IndustryCommodityCode" is used for matching key to get each material rule that is described in right column.
If "IndustryCommodityCodeOption" in "DefaultProjectOption"sheet is set to "5", "IndustryCommodityCode" will be used for matching key.

② ： In general, "ShortMaterialDescription" is used for indicating material description on Isometric Drawing.

③ ： "FabricationType" will be set to define "Shop Fabrication Material" and "Field Fabrication Material"using the codelist value in "AllCodeList.xls".
7 --> Contractor fabricated (Field Fabrication)
15 --> Shop fabricated

④ ： "QuantityOfReportableParts" is the number of object to be reported per each commodity code object.

⑤ ： Gasket is not modeled in SP3D as an object, but automatically generated as an assembly for material take off purpose.
If there is flanged connection for the parts, "GasketRequirements" is set as below using the codelist value in "AllCodeList.xls",
5 --> Gasket required at each bolted end
20 --> Gasket is not applicable as all ends are non-bolted. (This option normally to be set to Bolt/Nut and Gasket itself)

⑥ ： Bolt is not modeled in SP3D as an object, but automatically generated as an assembly for material take off purpose.
If there is flanged connection for the parts, "BoltingRequirements" is set as below using the codelist value in "AllCodeList.xls",
5 --> Bolting required
35 --> Reportable bolts not required

⑦ ： "ValveOperatorType" specifies which type of valve handle to be used as per code list value in "AllCodeList".
3 --> Handwheel
331 --> Gear, side mounted handwheel Type 1

⑧ ： "ValveOperatorCatalogPartNumber" defines which dimensional data to be used for valve handle.

This value must be in "ValveOperatorNumber" attribute in "OperatorXX" sheet of "Catalog.xls"

⑨ ： "PartDataSource" is specified for the material that is not modeled directly on SP3D such as Bolt/Nut and Gasket.
For Bolt/Nut, input "Bolt part data"
For Gasket, input "Gasket part data"
 Attachment.A2-2
A2.2.5 Gasket Selection Filter
Gasket selection for each material class is defined in "GasketSelectionFilter" sheet in "SPEC.xls"

SupplyResponsibilityOverride
FabricationCategoryOverride
ContractorCommodityCode
AlternateEndPreparation

AlternatePressureRating
MaximumTemperature
NominalDiameterFrom

AlternateEndStandard
MinimumTemperature
NominalDiameterTo

ScheduleThickness
EndPreparation

PressureRating
GasketOption
NpdUnitType

EndStandard

RingNumber

PipingNote1
PipingNote2
SpecName

Comments
FluidCode

Priority
Head
Start
AG1A .5 1.5 in 1 31 2500 5 VENGASKETRF 740 X
AG1A .5 1.5 in 10705 31 2500 5 VENGASKETRF 740
AG1A .5 1.5 in 1 21 300 5 VENGASKETRF 740 X
AG1A .5 1.5 in 10701 21 300 5 VENGASKETRF 740
AG1A .5 1.5 in 1 11 150 5 VENGASKETRF 740 X
AG1A .5 1.5 in 10700 11 150 5 VENGASKETRF 740
AG1A .5 1.5 in 1 21 150 5 VENGASKETRF 740

A2.2.7 Bolt Length Calculation

Stud bolt Length at flange connection in SP3D is calculated by following logic.

L
a = Flange Thickness
f e c a b d b a c e
b = Flange Projection for Raised Face (included to Flange Thickness(a))
c = Positive Tolerance of Flange Thickness
d = Gasket Thickness
e = Bolt Extension (including Nut Height)
f = Positive Tolerance of Stud Bolt Length

<Stud Bolt Length>

L = (a + b + c + e) * 2 + d + f

Below is the example of Bolt Length Calculation for "4in WeldNeck Flange, Raised Face, CL150"
Bolt Length will be calculated automatically when Flange is placed.
 Attachment.A2-2
Gasket
Flange Thickness Bolt Length SP3D Bolt Length
NPD Thickness
a b c d e f L
4in 24.3mm 0mm 3mm 4.5mm 19.9mm -1.5mm 97.4mm 100.0mm

FlangeThicknessTolerance

QuantityOfBoltsRequired
"PipingGenericDataBolted" sheet of "Catalog.xls"
FlangeOutsideDiameter
NominalPipingDiameter

DrillingTemplatePattern
NominalDiameterUnits

BodyOutsideDiameter
FlangeFaceProjection

RaisedFaceDiameter

FlangeGrooveWidth

BoltCircleDiameter

BoltPatternLength

BoltPatternOffset
FlangeThickness

BoltPatternWidth
PressureRating

EndPreparation

SeatingDepth

BoltDiameter
EndStandard

Head
Start
3.5 in 150 21 5 215.9mm 24.3mm 3mm 139.7mm 177.8mm 8 0.625in 101.6mm
4 in 150 21 5 228.6mm 24.3mm 3mm 157.2mm 190.5mm 8 0.625in 114.3mm
5 in 150 21 5 254mm 24.3mm 3mm 185.7mm 215.9mm 8 0.75in 141.3mm
6 in 150 21 5 279.4mm 25.9mm 3mm 215.9mm 241.3mm 8 0.75in 168.3mm

a c b
 Start
Start

Start
Head
Head

Head
BoltDiameterFrom
NominalPipingDiameter
BoltDiameterTo

4 in
4 in
4 in
NominalPipingDiameterUnits

VENGASKETRF
VENGASKETRF
VENGASKETRF
VENGASKETRF

150
150
150
BoltDiameterIncrement PressureRating

MaterialsGrade IndustryCommodityCode
EndPreparation

131
21
121
RingNumber

0.5in 4in 0.125in 4031 0mm

EndStandard

"BoltExtension" sheet in "Spec.xls"

PreferredBoltLengthFrom NominalDiameterFrom

e
"GasketPartData" sheet in "Catalog.xls"

NominalDiameterTo

5 19.9mm
5 19.9mm
5 19.9mm
StandardBoltExtensionForStuds
PreferredBoltLengthTo NominalDiameter
8
6
4
3

AltBoltExtensionForStuds2 in
in
in
in

NpdUnitType
AltBoltExtensionForStuds3

99.99mm 5mm
0.5in 4in 0.125in 4038 100mm 2000mm 10mm
0.5in 4in 0.125in 4031 100mm 2000mm 10mm
PreferredBoltLengthIncrement GasketIndustryStandard
AltBoltExtensionForStuds4
AltBoltExtensionForStuds5 GasketType
150
150
150
150

AltBoltExtensionForStuds6
d

StandardBoltExtForMachBolts ThicknessFor3DModel
4.5mm
4.5mm
4.5mm
4.5mm

AltBoltExtensionForMachBolts2
AltBoltExtensionForMachBolts3 ProcurementThickness
4.5mm
4.5mm
4.5mm
4.5mm

1
1
1
1

AltBoltExtensionForMachBolts4 MaterialsGrade

97.4mm --> 100mm

AltBoltExtensionForMachBolts5 GasketOutsideDiameter
AltBoltExtensionForMachBolts6 GasketInsideDiameter
GasketOutsideDiameterBasis
GasketInsideDiameterBasis
FlangeInsulationKitType
InsulatingWasherThickness
End
Start
Head

MetallicElectroPlatedWasherThk
MaintenanceFactor
FlangePressure
25mm

StressAtWhichSealIsInitiated
BoltLengthFrom
TightnessCurveSlope
IntersectionOfUnloadCurveWithVerticalAxis
300.01mm 600mm
300mm

600.01mm 1200mm

BoltLengthTo MinimumTightnessParameter
MaximumTightnessParameter
MaximumTemperature
0.25in
0.25in
0.25in

BoltDiameterFrom MaximumPressure
Bolt Length will be calculated using the parameter above (L = 97.4mm) and will be rounded up by using the filter below for material take off.
4in
4in
4in

BoltDiameterTo
"StudBoltLenCalTolerance" sheet in "Spec.xls"

f
-6mm
-3mm
-1.5mm

BoltLengthTolerance
Attachment.A2-2
 Attachment.A2-2
A2.2.8 Branch Table
Branch Table defines the branch piping parts that is automatically generated when branch piping is modeled in SP3D for each piping material class.

HdrSizeNPDUnitType

SecondaryShortCode
BrSizeNPDUnitType

TertiaryShortCode
HeaderSize

BranchSize
SpecName

ShortCode
AngleHigh
AngleLow
Head
Start
AG1A 0.5 0.5 89.5deg 90.5deg in in Tee
0.75 0.5 89.5deg 90.5deg in in Reducing Tee
0.75 0.75 89.5deg 90.5deg in in Tee
1 0.5 89.5deg 90.5deg in in Reducing Tee
1 0.75 89.5deg 90.5deg in in Reducing Tee
1 1 89.5deg 90.5deg in in Tee
1.25 0.5 89.5deg 90.5deg in in Reducing Tee
1.25 0.75 89.5deg 90.5deg in in Reducing Tee
1.25 1 89.5deg 90.5deg in in Reducing Tee
1.25 1.25 89.5deg 90.5deg in in Tee
1.5 0.5 89.5deg 90.5deg in in Reducing Tee
1.5 0.75 89.5deg 90.5deg in in Reducing Tee
1.5 1 89.5deg 90.5deg in in Reducing Tee
1.5 1.25 89.5deg 90.5deg in in Reducing Tee
1.5 1.5 89.5deg 90.5deg in in Tee
2 0.5 89.5deg 90.5deg in in Boss
2 0.75 89.5deg 90.5deg in in Boss
2 1 89.5deg 90.5deg in in Reducing Tee
2 1.25 89.5deg 90.5deg in in Reducing Tee
2 1.5 89.5deg 90.5deg in in Reducing Tee

① ② ③
① ： Specify HeaderSize and BranchSize for each combination of header and branch pipe size.

② ： "AngleLow" and "AngleHigh" is generally set as "89.5deg" and "90.5deg" for 90 degree branch, and "44.5deg" and "45.5deg" for 45 degree branch.

③ ： Define ShortCode of branch piping part to be generated automatically when branch pipe is modeled.

And the ShortCode must exist in "PipingCommodityFilter"as shown below.

"PipingCommodityFilter" sheet in "Spec.xls"

SupplyResponsibilityOverride
FabricationCategoryOverride
MaximumTemperature

MinimumTemperature

SecondSizeSchedule
JacketedPipingBasis

FirstSizeSchedule
SecondSizeFrom

SecondSizeUnits

CommodityCode
MultiSizeOption

EngineeringTag
SelectionBasis
SecondSizeTo
FirstSizeFrom

FirstSizeUnits
OptionCode

FirstSizeTo
SpecName

Comments
ShortCode
Head

Start
AG1E 45 Degree Direction Change 1 0.5 1 in FELBOW45SW
Reducing Tee 1 0.5 0.5 in 0.25 0.375 in FRTEESW3000
Reducing Tee 1 0.75 0.75 in 0.25 0.5 in FRTEESW3000
Tee 1 0.5 1 in FTEESW3000
Tee 1 1.5 6 in FTEEBW SCH40
Tee 1 8 18 in FTEEBW SCH20
Tee 1 20 36 in FTEEBW 0.250"T