Stiffener Import Workbook - Intergraph Smart 3D - Help - Hexagon

Intergraph Smart 3D Molded Forms

Language
English
Product
Intergraph Smart 3D
Subproduct
Molded Forms
Search by Category
Help
Smart 3D Version
13

An Excel workbook must have specific formatting to import profile stiffeners. The stiffener import-export format.xls workbook is provided as a template of the format needed for each stiffener type. The workbook is delivered to the [Product Folder]\MoldedForms\Data folder. Configuration and Summary worksheets in the workbook are provided only for information, and are not required for import.

Each worksheet represents a type of stiffener and the attributes of the stiffener. When a stiffener has been imported into the model, it is like a stiffener of the same type created using the command in the software. Attributes on a worksheet correspond to attributes on the Properties dialog or attributes created using a control on the software ribbon.

Multiple stiffeners of the same type may be defined on each worksheet. Each stiffener definition must end with a Finish row. Multiple worksheets may be defined in the same workbook.

Sections common to all worksheets:

Header-Main section

Contains attributes equivalent to using the Main Tab (Profile Properties Dialog) of the profile ribbon.

Name

Name (Main tab)

Naming Category

Naming Category (Main tab)

Type

Type (Main tab)

Continuity

Continuity (Main tab)

Priority

Continuity Priority (Main tab)

Description

Description (Main tab)

Header-XC section

Contains attributes equivalent to using the Properties dialog of the profile ribbon. See Cross Section Tab (Profile Properties Dialog) and Section Orientation Tab (Profile Properties Dialog).

This section is not used on the Tripping worksheet.

SectionType

Section Type (Cross Section tab)

SectionSize

Section Size (Cross Section tab)

Material

Material (Cross Section tab)

Grade

Grade (Cross Section tab)

PrimaryOrient

Primary Orientation (Section Orientation tab)

SecondaryOrient

Secondary Orientation (Section Orientation tab)

MountingFace

Mounting Face (Section Orientation tab)

LoadPoint

Load Point (Section Orientation tab)

ProjectionMethod

Landing Curve Projection Method (Section Orientation tab)

AttachmentMethod

Attachment Method (Section Orientation tab)

Header-Bound section

Contains attributes equivalent to using the Boundary Methods step of the profile ribbon.

Boundary 1

Name of the first boundary object. If the boundary is a grid plane, define the name using the grid plane name format (see below).

Boundary 2

Name of the second boundary object. If the boundary is a grid plane, define the name using the grid plane name format (see below).

Ambiguity

Defines whether the boundaries create an ambiguous solution, equivalent to using the Solve ambiguous boundaries step of the profile ribbon. Type True or False.

SHARED Tip The hull is the most common boundary to create an ambiguous solution.

AmbiX

X-coordinate on the selected solution.

AmbiY

Y-coordinate on the selected solution.

AmbiZ

Z-coordinate on the selected solution.

Header-Orient section

Contains attributes equivalent to using the Profile Orientation Definition step of the profile ribbon.

This section is not used on the Tripping worksheet.

OrientNumber

Sequential number for a point defining rule regions.

PointType

The type of point defining rule regions. Type StartPoint, RegionBoundary, or EndPoint.

  • The first point must always be StartPoint.

  • The last point must always be EndPoint.

OrientInt.Object

The object intersecting the landing curve to create the definition point. Type None or the object name. If the object is a grid plane, define the name using the grid plane name format (see below).

X

X-coordinate of the definition point.

Y

Y-coordinate of the definition point.

Z

Z-coordinate of the definition point.

Rule

Orientation rule used at the definition point. Type ProfileOrientationNormal, ProfileOrientationUpDown, ProfileOrientationPortStarboard, ProfileOrientationForeAft, ProfileOrientationPlanar, ProfileOrientationTwistLinearGirth, ProfileOrientationTwistLinearOrthogonal, or ProfileOrientationTwistCubic.

Angle

Angle used by the orientation rule at the definition point.

AngleRef

Plane in which to measure the angle. Type ProfileAnglePlaneNormal or ProfileAnglePlaneOrthogonal.

Plane

Angle reference plane from which the angle is measured. Type ProfileReferenceNormal, ProfileReferenceUpDown, ProfileReferencePortStarboard, or ProfileReferenceForeAft.

Intersection worksheet

The section order is: Header-Main, Header-XSec, Header- Bound, Header-Intersect, Header-Orient, and Finish.

Header-Intersection Section

Contains attributes equivalent to using the Stiffener Profile System by Projection Command .

Method

Type Coincident. This is the required value.

Object

Grid plane used to create the landing curve. Define the name using the grid plane name format (see below).

Offset

Type 0. This is the required value.

Offset worksheet

The section order is: Header-Main, Header-XSec, Header- Bound, Header-Offset, Header-Orient, and Finish.

Header-Offset section

Contains attributes equivalent to using the Stiffener Profile System by Offset command on the Stiffener Profile System by Offset Ribbon.

BaseCurve

Base curve definition. If the base curve is defined by a grid plane, define the name using the grid plane name format (see below).

Offset

Offset value for the landing curve from the base curve.

OffsetMethod

Method used to offset the landing curve from the base curve. Type Girth, Vertical, Transverse, or Longitudinal.

Projection worksheet

The section order is: Header-Main, Header-XSec, Header- Bound, Header-Project, Header-Orient, and Finish.

Header-Project section

Contains attributes equivalent to using the Stiffener Profile System by 2D Projection command on the Stiffener Profile System by Projection Ribbon.

SketchPlaneMethod

Sketch plane method used. Type Coincident or Offset. Other sketch plane methods, such as Angle from Plane, Plane by Point & Vector, Plane by Three Points, and Plane by Vectors Normal, cannot be used for import.

Offset

Offset value for the sketch plane if the Offset SketchPlaneMethod type is used. Type 0 if the Coincident SketchPlaneMethod type is used.

Object

Grid plane or object used to create as the sketch plane. If the object is a grid plane, define the name using the grid plane name format (see below).

FileName

Type the fully qualified path and the .sha file name containing the sketch curve. If the .sha file is in the same folder as the import workbook, then only the file name is required.

Table worksheet

The section order is: Header-Main, Header-XSec, Header- Bound, Header-Table, Header-IntPlane, Header-Orient, and Finish.

Header-Table section

Contains attributes equivalent to using the Stiffener Profile System by Table Command and the Landing Curve Table Dialog.

LCNumber

Sequential number for a point on the landing curve.

PointType

Type Definition or Knuckle.

IntTab.Object

Intersecting object that helps to define two coordinate values of the landing curve point.

X-Reference

X-coordinate of the landing curve point. Type 0 if the coordinate is derived.

X-Offset

Offset value form the X-reference. Type 0 is there is no offset.

Y-Reference

Y-coordinate of the landing curve point. Type 0 if the coordinate is derived.

Y-Offset

Offset value form the Y-reference. Type 0 is there is no offset.

Z-Reference

Z-coordinate of the landing curve point. Type 0 if the coordinate is derived.

Z-Offset

Offset value form the Z-reference. Type 0 is there is no offset.

DerivedCoord

Type X, Y, or Z for the derived coordinate.

Header-IntPlane section

Contains attributes equivalent to using the Intersection Plane option of the Stiffener Profile System by Table Command . This section is optional and is used when the coordinates of only two points are known for a landing curve on a plate system with curvature. See Landing Curve Table Dialog.

BasePlane

Grid plane in which to measure the angle used to define the intersection plane. Define the name using the grid plane name format (see below).

NormalToPlane

Normal to Base Plane. Defines whether the intersection plane is oriented normal to the base plane. Type True or False.

MeasureFrom

Defines the plane from which to measure the angle used to define the intersection plane. Type Horizontal or Vertical.

IntPlaneAngle

Angle. The angle of the intersection plane, measured from the Horizontal or Vertical plane.

Tripping worksheet

The section order is: Header-Main, Header-XSec, Header- Trip, and Finish.

Header-Trip section

Contains attributes equivalent to using the Tripping Stiffener System Command .

B1

Starting object for the tripping stiffener.

B1ConnectType

Connection type between the tripping stiffener and starting object. Type Connected, Lapped, Parallel, Perpendicular, Transverse, Vertical, Longitudinal, Fixed X, Fixed Y, Fixed Z, or End Connect.

B2

Ending object for the tripping stiffener.

B2ConnectType

Connection type between the tripping stiffener and ending object. Type Connected, Lapped, Parallel, Perpendicular, Transverse, Vertical, Longitudinal, Fixed X, Fixed Y, Fixed Z, or End Connect.

Configuration worksheet

Date

The date on which the export was performed. This field can be blank for import.

IntelliShip Version

The version of software from which the export was performed. This field can be blank for import.

User

The name of the active user. This field can be blank for import.

ModelDB

The name of the model database. This field can be blank for import.

CatalogDB

The name of the catalog database. This field can be blank for import.

PlateSystem

The plate system name. This field can be blank for import.

Number Exported

The number of stiffeners included in the export. This field can be blank for import.

CoordSystemSepa

A coordinate system separator character that is not part of the coordinate system or reference plane names.

Use the same character throughout the workbook. "@" is recommended.

Do not use the backslash character. ("\").

Distance Unit

This unit can be meters (M) or millimeters (MM).

Angle Unit

This unit can be Degrees or Radians.

Grid Plane Name Format

If an object is a grid plane, define the name by typing the coordinate system, a coordinate system separator character, and the grid plane name. For example, CS_O@L-21.

Choose a coordinate system separator character that is not part of the coordinate system or reference plane names.

Use the same character throughout the workbook. "@" is recommended.

Do not use the backslash character. ("\").

See Also

Import stiffener or seam data
Import Stiffeners Command (File Menu)