Stiffener Import Workbook - Intergraph Smart 3D - Help

Intergraph Smart 3D Molded Forms

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Help
Version_S3D
11.x(2016)

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 box 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 Properties dialog box of the profile ribbon. For more information, see Main Tab (Profile Properties Dialog Box).

Name

Name (Main tab)

NamingCategory

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 box of the profile ribbon. For more information, see Cross Section Tab (Profile Properties Dialog Box) and Section Orientation Tab (Profile Properties Dialog Box).

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 Definition step of the profile ribbon. For more information, see Boundary Methods.

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 Ambiguity step of the profile ribbon. Type True or False. For more information, see Solve ambiguous solution created by selected boundaries.

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. For more information, see Profile Orientation.

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 Intersection command. For more information, see Stiffener Profile System by Intersection Ribbon in Stiffener Profile System by Projection.

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. For more information, see 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. For more information, see 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. For more information, see Stiffener Profile System by Table Ribbon in Stiffener Profile System by Table and Landing Curve Table Dialog Box.

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. For more information, see Stiffener Profile System by Table Ribbon in Stiffener Profile System by Table and Landing Curve Table Dialog Box.

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 command. For more information, see Tripping Stiffener System Ribbon in Tripping Stiffener System.

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 (File Menu)