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.
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. ("\").