Overview
• Generate is a function that creates an Excel sheet (InfoX Sheet) from the property information of each object in the CIM model.
• It organizes sheets by object category and provides an information sheet that allows you to look up property information for each object based on IFC Guid.
• InfoX Sheet Structure :
| Sheet Name | Description |
|---|---|
MEMBER |
Properties of concrete/steel members and object groups |
TENDON |
Tendon properties |
STIFFENER |
Stiffener properties |
BOLT |
Bolt properties |
LAYOUT |
Alignment properties |
ETC |
Properties of terrain and other miscellaneous objects |
PROPERTY SET |
Default Property Set (non-editable) |
QUANTITY SET |
Default Quantity Set (non-editable) |
USER PSET |
User-defined Property Set (can be added and edited) |
USER QSET |
User-defined Quantity Set (can be added and edited) |
Execution
[Base Mode]
• Ribbon Menu > [Base] Tab > [Property] Group > Information > Generate
Description
Generate Function
Generates property information for each object as category-specific Excel sheets, based on the Structure hierarchy defined in the CIM model.
• (1) Structure Selection
Select the Structure hierarchy to be used as the basis for the InfoX Sheet from the list of Structures defined in the project (Structure-1, Structure-2, Structure-3, etc.).
The WBS (Structure, StructureLevel, StructureName, etc.) of objects in the sheet is determined by the selected Structure.
• (2) Edit Default Property Set
Opens the Default Property Set configuration screen.
For details, refer to the Edit Default Property Set page.
• (3) Edit Default Quantity Set
Opens the Default Quantity Set configuration screen.
For details, refer to the Edit Default Quantity Set page.
• (4) Clear User Property/Quantity Set
Option to reset User Property / Quantity Set.
Checked: Initializes and recreates the USER PSET / USER QSET sheets.
Unchecked: Keeps the existing USER PSET / USER QSET sheets as they are.
Caution
When unchecked, the existing USER PSET / USER QSET sheets are preserved, but columns A–E (Structure, StructureLevel, StructureName, StructureCode, IFCGUID) and information for newly added objects will not be updated.
It is recommended to check the Clear option in the following cases:
• When a large number of new objects have been added
• When the Structure hierarchy has been changed or newly configured
However, when Clear is executed, all user-entered User P/Q Set data will be reset,
so please back up the existing InfoX Sheet via [Base] Tab > [Export] Group > Xls > Information Data before proceeding.
• (4) Generate InfoX Sheet
Generates the InfoX Sheet based on the selected Structure.
Common Sheet Structure
All category sheets share the same structure for columns A through E.
| Column | Item | Description |
|---|---|---|
A |
Structure | Structure hierarchy number |
B |
StructureLevel | Hierarchy level of the Structure (e.g., 1.1.1.1.2.5.2) |
C |
StructureName | Name of the Structure (e.g., Slab_N_Misc) |
D |
StructureCode | Structure code |
E |
IFCGUID | IFC GUID (unique identifier) of the object |
From column F onward, category-specific property items are arranged.
Property Items by Category Sheet
Detailed property items included in each sheet can be found below.
MEMBER Sheet Property Items
Outputs property information for concrete/steel members (1D, 1D General, 2D, 3D) and Object Groups.
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Object ID Ex) 6 |
All |
|
Name |
Object Name Ex) Beam-06 |
All |
Editable |
ObjectType |
Object classification Ex) Concrete |
All |
|
SubType |
Member Type - 1D : 1D Concrete or Steel - 1G : 1D General - 2D : 2D Member(Plate) - 3D : 3D Member(Solid) |
All |
|
ObjectGroup |
Object Group ID and Name Ex) 1 : Bearing |
When the object belongs to an Object Group | |
ObjectCategory |
Object Category Ex) Concrete Beam |
All |
|
Material |
Material Name Ex) C27 |
All |
|
MaterialDB |
Material DB Ex) C27 |
All |
|
SubEntity |
Sub-component of 1G Ex) Section Line-1 |
1G(Line Type) |
|
Length |
Length of the object - 1D/1G : Geometry Line length - Object Group : Sum of lengths - Solid : Bounding Box Height |
1D / 1G / 3D |
Length considering Cutting |
OGLength |
Total Length defined in the Object Group | Object Group |
|
SubLength |
Length of Section Line (Line Type) | 1G(Line Type) |
|
BetaAngle |
Beta Angle Ex) 0 (deg) |
1D / 1G |
|
SectionType |
Section type Ex) Solid Box / Plane Type |
1D / 1G |
|
PerimeterExt(S) |
Outer perimeter of the start section | 1D / 1G / 2D |
|
PerimeterExt(E) |
Outer perimeter of the end section | 1D / 1G / 2D |
|
PerimeterInt(S) |
Inner perimeter of the start section | 1D / 1G / 2D |
|
PerimeterInt(E) |
Inner perimeter of the end section | 1D / 1G / 2D |
|
BoxHeight(S) |
Vertical height of the start section | 1D / 1G / 2D |
Before Beta Angle consideration |
BoxHeight(E) |
Vertical height of the end section | 1D / 1G / 2D |
|
BoxWidth(S) |
Horizontal width of the start section | 1D / 1G / 2D |
|
BoxWidth(E) |
Horizontal width of the end section | 1D / 1G / 2D |
|
Thickness |
Plate thickness | 2D |
|
Area |
Member area | 2D |
|
OGArea |
Total Area defined in the Object Group | Object Group |
|
SurfaceArea |
Closed surface area of the object | All |
|
FaceArea(S) |
Area of the start section | 1D / 1G / 2D |
Area considering Skew |
FaceArea(E) |
Area of the end section | 1D / 1G / 2D |
Area considering Skew |
Volume |
Volume of the object | All |
|
OGVolume |
Total Volume defined in the Object Group | Object Group |
|
Weight |
Member weight | All |
|
WeightDensity |
Unit weight | All |
|
Tapered |
Tapered or not Ex) No / Yes |
1D / 1G |
|
Section Dimensions |
Detailed dimension information of template sections | 1D |
Separate dimensions output for start/end |
Sub-Property |
Values defined by Sub-Property | All |
TENDON Sheet Property Items
Outputs property information for tendon objects.
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Tendon ID | All |
|
Name |
Tendon Name Ex) Top01_19R |
All |
Editable |
ObjectType |
Object classification Ex) Tendon |
All |
|
TendonType |
Tendon Type Ex) Internal(Post-Tendon) |
All |
|
SubType |
Tendon direction Ex) Longitudinal / Transverse |
All |
|
ObjectCategory |
Object Category Ex) Tendon |
All |
|
Material |
Material | All |
|
GroupName |
Group Name Ex) Tendon group-737 |
All |
|
StrandDiameter |
Strand diameter | All |
|
NumberOfStrands |
Number of strands | All |
|
NumberOfTendons |
Number of tendons | All |
|
TendonArea |
Area of individual tendon | All |
|
DuctType |
Duct Type Ex) Round / Flat |
All |
Blank if duct is not defined |
DuctDiameter |
Duct diameter (for Round type) | Round Duct |
|
DuctHeight |
Duct Height (for Flat type) | Flat Duct |
|
DuctWidth |
Duct Width (for Flat type) | Flat Duct |
|
StartAnchorage |
Start anchorage Name Ex) WK30_12T |
All |
Blank if not defined |
EndAnchorage |
End anchorage Name Ex) WK30_12T |
All |
Blank if not defined |
NumberOfStartAnchor |
Number of start anchorages | All |
|
NumberOfEndAnchor |
Number of end anchorages | All |
|
NumberOfDeadAnchor |
Number of dead anchorages | All |
|
NumberOfLiveAnchor |
Number of live/plate anchorages | All |
|
NumberOfFlatAnchor |
Number of flat anchorages | All |
|
ActualSpacing |
Spacing of transverse tendons | Transverse |
|
TendonLength |
Individual tendon length 120233.890 |
All |
|
DuctLength |
Duct length | All |
|
StrandLength |
Total strand length (Tendon length × Number of strands) |
All |
|
TotalTendonLength |
Total tendon length | All |
Longitudinal: same as tendon length. Transverse: tendon length × number of tendons |
Weight |
Tendon weight | All |
|
Anchorage Details |
Detailed dimension information of anchorages | All |
Separate dimensions output for start/end |
STIFFENER Sheet Property Items
Outputs property information for stiffener objects.
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Stiffener ID | All |
|
Name |
Stiffener Name | All |
Editable |
ObjectType |
Object classification | All |
|
StiffenerType |
Stiffener Type Ex) Trans / Long / Close / Diaph / Manhole |
All |
|
ObjectCategory |
Object Category Ex) Stiffener |
All |
|
Material |
Material | All |
|
SubEntity |
Split Stiffener Name Ex) S1 |
Manhole Stif. (Flat Stif.) |
|
SectionType |
Section type Ex) Flat / T-Section / Closed |
All |
|
ActualSpacing(L) |
Actual spacing in longitudinal direction | All |
|
ActualSpacing(T) |
Actual spacing in transverse direction | Longitudinal Stiff. |
|
MaximumLength |
Maximum length among individual stiffeners | All |
|
MinimumLength |
Minimum length among individual stiffeners | All |
|
AverageLength |
Average length among individual stiffeners | All |
|
TotalLength |
Total stiffener length | All |
|
Thickness |
Stiffener thickness | Closed Stiff. only |
|
Height |
Stiffener height | Closed Stiff. only |
|
Area |
Stiffener cardinal area | All |
Considering Slot/End Shape |
SurfaceArea |
Total closed surface area of stiffener | All |
Considering Slot/End Shape |
FaceArea(S) |
Area of stiffener start section | Except Closed |
Based on dimensions |
FaceArea(E) |
Area of stiffener end section | Except Closed |
Based on dimensions |
Volume |
Stiffener volume | All |
Closed type considers manhole deduction |
Weight |
Stiffener weight | All |
|
Number |
Number of stiffeners | All |
Split stiffeners use the split count |
Tapered |
Tapered or not Ex) No / Yes |
Tapered Stiffener |
Stiffeners with Section Table applied |
BOLT Sheet Property Items
Outputs property information for bolt/stud objects.
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Bolt ID | All |
|
Name |
Bolt Group Name Ex) BoltGrp-3450 |
All |
Editable |
ObjectType |
Object classification Ex) Bolt |
All |
|
BoltType |
Bolt Type Ex) Hex Bolt / Welding Stud |
All |
|
ObjectCategory |
Object Category Ex) Bolt |
All |
|
Material |
Material | All |
|
BoltList |
Defined Bolt List Ex) Bolt-1 |
All |
|
NumberOfBolt |
Number of bolts | All |
|
NumberOfNut |
Number of nuts | All |
|
NumberOfWasher |
Number of washers | All |
|
NumberOfStud |
Number of studs | All |
|
BoltLength |
Body length of bolt/stud | All |
|
ActualSpacing1 |
Actual spacing in Dir-1 direction | All |
|
ActualSpacing2 |
Actual spacing in Dir-2 direction | All |
|
SurfaceArea |
Total closed surface area of Bolt/Nut/Washer | All |
|
Volume |
Total volume of Bolt/Nut/Washer | All |
|
Weight |
Total weight of Bolt/Nut/Washer | All |
|
BoltStd |
Bolt Standard Ex) KS / None |
All |
None for Welding Stud |
BoltDB |
Bolt DB Ex) M22 |
All |
Blank when Standard is None |
HeadWidth |
Bolt Head Width | All |
|
BodyDiameter |
Bolt/Stud Body Diameter | All |
|
HeadHeight |
Bolt/Stud Head Height | All |
|
NutStd |
Nut Standard Ex) KS |
All |
|
NutDB |
Nut DB Ex) M22 |
All |
Blank when Standard is None |
NutWidth |
Nut Width | All |
|
NutHeight |
Nut Height | All |
|
WasherStd |
Washer Standard Ex) KS |
All |
|
WasherDB |
Washer DB Ex) D22 |
All |
Blank when Standard is None |
ODiaWasher |
Washer outer diameter | All |
|
IDiaWasher |
Washer inner diameter | All |
|
ThkWasher |
Washer thickness | All |
LAYOUT Sheet Property Items
Outputs property information for alignment objects.
The structure is based on the IFC Alignment schema (AlignmentCommon / AlignmentHorizontal / AlignmentVertical / AlignmentCant).
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Layout ID | All |
|
Name |
Alignment Name Ex) Alignment-1 |
All |
Editable |
ObjectType |
Object classification Ex) Layout |
All |
|
SubType |
Sub Type Ex) Layout / Guide Path |
All |
|
SegmentID |
Segment internal identifier H001 : Horizontal alignment segment V001 : Vertical alignment segment L001 : Left superelevation segment R001 : Right superelevation segment |
Curve Segment |
|
StartStation |
Station of start point Ex) 20400.0000 |
Alignment Common |
|
EndStation |
Station of end point Ex) 22942.6360 |
Alignment Common |
|
StartPoint2D |
Coordinates of start point (N, E) or (X, Y) Ex) 602264.3621, 201212.1277 |
Alignment Common |
|
EndPoint2D |
Coordinates of end point (N, E) or (X, Y) | Alignment Common |
|
StartDirection |
Direction angle of start point Based on +X axis, CCW direction (Degree) Ex) 35.0° |
Alignment Common |
|
CoordinateReferenceSystem |
Coordinate system Ex) Korea Central Belt 2010 |
Alignment Common |
|
StartElevation |
Elevation of alignment start point Ex) 20.324 m |
Alignment Common |
|
TransitionType |
Horizontal transition curve type Ex) Clothoid ... |
Alignment Common |
|
MinAppliedGradient |
Minimum applied vertical gradient (%) Ex) -8.00% |
Alignment Vertical |
|
MaxAppliedGradient |
Maximum applied vertical gradient (%) Ex) +8.00% |
Alignment Vertical |
|
VerticalCurveType |
Applied vertical curve type Ex) None / Parabolic / Arc / Mixed |
Alignment Vertical |
|
MinAppliedCant |
Minimum applied crossfall (%) Ex) -8.00% |
Alignment Cant |
|
MaxAppliedCant |
Maximum applied crossfall (%) Ex) 8.00% |
Alignment Cant |
|
PredefinedType |
Geometric type of segment - Horizontal : Line / Clothoid ... - Vertical : Line / ParabolicArc ... - Cant : Line |
Curve Segment |
|
StartPoint2D |
Plan coordinates (X, Y) of segment start point Ex) (10234.1250, 24567.8900) |
Curve Segment |
|
StartDirection |
Tangent direction angle at segment start point Based on +X axis, CCW direction (Degree) |
Curve Segment |
|
SegmentLength |
Segment length Ex) 80.0 |
Curve Segment |
|
StartRadius |
Curve radius at segment start point | Curve Segment |
|
EndRadius |
Curve radius at segment end point | Curve Segment |
|
StartGradient |
Vertical gradient at segment start point (%) | Curve Segment |
|
EndGradient |
Vertical gradient at segment end point (%) | Curve Segment |
|
StartCrossfall |
Crossfall at start point (%) | Curve Segment |
|
EndCrossfall |
Crossfall at end point (%) | Curve Segment |
|
SL_SPoint3D |
Start point coordinates of Sub-Layout Ex) (0, 0, 0) |
Sub-Layout |
|
SL_EPoint3D |
End point coordinates of Sub-Layout Ex) (0, 0, 0) |
Sub-Layout |
|
SL_SSkew |
Skew angle at Sub-Layout start point Ex) 10.00° |
Sub-Layout |
|
SL_ESkew |
Skew angle at Sub-Layout end point Ex) 10.00° |
Sub-Layout |
|
SL_SLSuperelevation |
Left superelevation at Sub-Layout start point Ex) -2.00% |
Sub-Layout |
|
SL_ELSuperelevation |
Left superelevation at Sub-Layout end point Ex) -2.00% |
Sub-Layout |
|
SL_SRSuperelevation |
Right superelevation at Sub-Layout start point Ex) -2.00% |
Sub-Layout |
|
SL_ERSuperelevation |
Right superelevation at Sub-Layout end point Ex) -2.00% |
Sub-Layout |
|
GP_RefrenceLayout |
Name of the referenced alignment Ex) Main Line |
Guide Path |
|
GP_ReferencePoint |
Reference point defined in CIM Ex) 0.000 |
Guide Path |
|
GP_CalculationPoint |
Calculation point defined in CIM Ex) 0.000 |
Guide Path |
|
GP_SuperElevation |
Superelevation defined in Guide Path | Guide Path |
ETC Sheet Property Items
Outputs property information for terrain, slope, borehole, and other miscellaneous objects.
| Property Name | Definition | Applicable To | Remarks |
|---|---|---|---|
ID |
Object ID | All |
|
Name |
Object Name Ex) Terrain-1 |
All |
Editable |
ObjectType |
Object classification Ex) Terrain Surface / Borehole / Slope Surface / Slope Solid |
All |
|
SubType |
Sub-type of ETC Ex) Cut Slope / Fill Slope, etc. |
All |
|
SubID |
Individual Boring Name of Borehole Ex) BoreHoleSet-1-1 |
Borehole |
|
SoilType |
Soil Type Ex) Gravel... |
All |
|
SoilLayer |
Soil Layer name Ex) SoilLayer-1 |
Borehole |
|
Area |
Slope area | Slope Surface |
|
Volume |
Earthwork volume | Slope Solid |
|
Coordinate(XY) |
X, Y coordinates (geographic) of Borehole Ex) 202.26, 2515.77 |
Borehole |
Model coordinates if not set |
Elevation |
Z coordinate of Borehole | Borehole |
|
Layer1~5 Thk. |
Soil layer thickness | Borehole |
How to Generate InfoX Sheet
① Execute Information > Generate.
② Select the Structure to be used as the basis for the InfoX Sheet.
③ Click the Generate InfoX-Sheet button to create the InfoX Sheet containing 6 category-specific sheets.
Caution
All information in the InfoX Sheet is tracked based on IFC GUID.
IFC GUID is assigned to each object only after the IFC Export function has been performed at least once.
Since objects will not have a GUID if IFC Export has not been performed, be sure to perform IFC Export before executing Generate.
References
• Edit Default Property Set : How to configure default Property Set
• Edit Default Quantity Set : How to configure default Quantity Set
• Open Link InfoX Sheet / Update Object Name