The Nozzle Import window allows users to import a list of nozzles directly from a spreadsheet (.xls) file.
The Nozzle Import window is separated into different areas, Import Parameters, Table Profile,and Commands.
Import Parameters Area #
The Import Parameters area includes the following fields:
File Path– Specifies the path of the spreadsheet file (.xls) to import the list of nozzles information.
Table Sheet – Specifies the sheet containing the list of nozzles’ information.
Table Range – Specifies the cell range containing the list of nozzles information.
Length Unit – Specifies the thickness unit for the imported information.
Material, Pipe– Specifies the pipe material used for imported nozzles.
Material, Pipe Fittings – Specifies the pipe fittings material used for imported nozzles.
Material, Flanges– Specifies the pipe flange used for imported nozzles.
Material, Studs– Specifies the studs material used for imported nozzles.
Material, Reinforcing Plate – Specifies the plate material used for imported nozzles.
Table Profile Area #
The Table Profile area includes the following fields:
Nozzle NPS – Specify the nozzle’s nominal pipe size (NPS) column from the imported table.
SCH – Specify the nozzle’s schedule column from the imported table. Acceptable values are schedule values from a table or a dimension with units (mm or in). If a value with dimension is set such as “0.5 in” a custom pipe component is used instead of a standard one.
TAG – Specify the nozzle’s identification TAG column from the imported table.
Quantity – Specify the nozzle’s quantity column from the imported table. Additional nozzles are offset from the first one by a pre-defined angle. Acceptable field values are integers only.
Loc – Specify the nozzle’s location column from the imported table. Acceptable field values are:
| Shell Nozzle | Shell Shell nozzle |
| Roof Nozzle | Roof Roof nozzle |
Note: values are not case-sensitive.
Type – Specify the nozzle’s type column from the imported table. Acceptable field values are:
| Double Flange | Double Double flange |
| Single Flange | Nozzle Single Single flange |
| Gooseneck | Gooseneck Goose neck Goose-neck |
| Draw off sump | Drawoff Draw off Drawoff sump Draw off sump |
| Outside downcomer | Outside downcomer |
| Inside downcomer | Inside downcomer Downcomer |
| Cleanout | Cleanout Flush-cleanout Flush cleanout |
| Manhole | Manhole Manway |
| Rectangular | Rectangular Rectangular opening |
Note: values are not case-sensitive.
Orientation – Specify the nozzle’s orientation column from the imported table. Acceptable field values are numbers only.
Elevation/Radius – Specify the nozzle’s elevation/radius column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area.
Projection – Specify the nozzle’s projection column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area.
d1 – Specify the nozzle’s dimension “d1” column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area.
| Gooseneck | Distance from the tank surface to the elbow axis |
| Draw off sump | Horizontal pipe extension |
| Outside downcomer | Horizontal pipe extension |
| Inside downcomer | Horizontal pipe extension |
d2 – Specify the nozzle’s dimension “d2” column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area.
| Gooseneck | Distance from the elbow axis to the gooseneck pipe end |
| Draw off sump | Vertical pipe extension |
| Outside downcomer | Vertical pipe extension |
| Inside downcomer | Vertical pipe extension |
d3 – Specify the nozzle’s dimension “d3” column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area. This dimension is saved for future nozzle configurations.
CA – Specify the nozzle’s corrosion allowance column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area
Flange Standard – Specify the nozzle’s flange standard column from the imported table. Acceptable field values are:
| AME B16.5 | ASME B16.5 ASMEB16.5 ASME-B16.5 B16.5 |
| ASME B16.47a | ASME B16.47a ASMEB16.47a ASME-B16.47a B16.47a |
| ASME B16.47b | ASME B16.47b ASMEB16.47b ASME-B16.47b B16.47b |
| API 650 | API 650 API650 API-650 |
Note: values are not case-sensitive.
Flange Class – Specify the nozzle’s flange class column from the imported table. Acceptable field values are:
| 75# | #75 75 75# |
| 150# | #150 150 150# |
| 300# | #300 300 300# |
| 400# | #400 400 400# |
| 600# | #600 600 600# |
| 900# | #900 900 900# |
| 1500# | #1500 1500 1500# |
| 2500# | #2500 2500 2500# |
Flange Type – Specify the nozzle’s flange type column from the imported table. Acceptable field values are:
| Flush Cleanout | Flush-type Flush-type Cleanout Cleanout Flush Cleanout |
| Rectangular | Opening Rectangular Rectangular Plate Rectangular-plate |
| Circular | Circular Circular Plate Circular-plate |
| Welding Neck Flange | WN WNRF WNFF Welding neck Weldneck Welding neck flange |
| Slip On Flange | SO SORF SOFF Slip On Slip-On Slip On Flange Slip-On Flange |
| Socket Flange | Socket Socket Flange |
| Lapped Flange | Lapped Lap-joint Lapped Flange |
| Threaded Flange | Threaded Threaded Flange |
Note: values are not case-sensitive.
Flange Face – Specify the nozzle’s flange face column from the imported table. Acceptable field values are:
| Raised Face (RF) | SORF WNRF RF Raised Face Raised Face (RF) |
| Flat Face (FF) | SOFF WNFF FF Flat Face Flat Face (FF) |
Note: values are not case-sensitive.
Blinded – Specify the nozzle’s blinded status column from the imported table. Acceptable field values are:
| With Blind Flange | Y Yes Blinded |
| Without Blind Flange | N No – Blank |
Note: values are not case-sensitive.
Reinforcement – Specify the nozzle’s reinforcement type column from the imported table. Acceptable field values are:
| None | N No – Blank |
| Circular Reinforcement | Circular Circular Reinforcement Circular Shape |
| Diamond Reinforcement | Diamond Diamond Reinforcement Diamond Shape |
Note: values are not case-sensitive.
Reinforcement (Low/Reg) – Specify the nozzle’s reinforcement low/regular type column from the imported table. Acceptable field values are:
| Low-type | Low Low type Low-type |
| Regular-type | Regular Regular type Regular-type |
Note: values are not case-sensitive.
Reinforcement Length – Specify the nozzle’s reinforcement length column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area
Reinforcement Thickness – Specify the nozzle’s reinforcement thickness column from the imported table. Acceptable field values are numbers only. Dimension unit is set on the Length Unit field located in the Import Parameters area
Service – Specify the nozzle’s service column from the imported table.
Notes – Specify the nozzle’s notes column from the imported table.
Commands Area #
Import Button – Import nozzle import parameters from a file.
Export Button – Export nozzle import parameters into a file.
Cancel Button – Exit window without importing nozzle list.
OK Button – Exit window importing nozzle list.
