Editing USER PSET / QSET

Overview

• The USER PSET sheet and USER QSET sheet in InfoX Sheet are areas where users can directly add and edit property and quantity information.

• While the PROPERTY SET sheet / QUANTITY SET sheet are automatically generated from the Predefined items defined in Edit Default Set, USER PSET / USER QSET allow users to freely add rows and input information.

• Predefined PROPERTY SET / QUANTITY SET are based on Object-level members, so they cannot be applied to higher-level entities such as projects or facilities to which no physical object is assigned. USER PSET / USER QSET serve as the channel for assigning user-defined data — such as project information, ordering information, and facility information — to these higher WBS levels, and also allow users to freely define additional properties and quantities for individual objects beyond the Predefined items.

• Information is mapped based on each object's IFCGUID, and the entered data is utilized across CIM workflows including BOQ aggregation, IFC Export, and Field Viewer.

Description

Editing the USER PSET Sheet

The USER PSET sheet is an area for entering additional property information for objects or upper levels.

• Editable Area

Information can be entered directly in the Field Input Area (Data Group ~ Description columns).
Identification areas such as IFCGUID and Structure cannot be edited.

• Adding Rows

To enter multiple properties for a single object, additional rows can be added. When adding a row, the Classification / Entity ID Area must be filled in identically to the row directly above, so that the entry is registered as an additional property of the same object.

• Using Functions

Excel functions referencing the headers of other sheets in InfoX Sheet (MEMBER, TENDON, STIFFENER, etc.) can be used when entering Value.
Using the QSET UDF Library introduced in the Use Case section below, object information can be automatically retrieved based on IFCGUID.

Editing the USER QSET Sheet

The USER QSET sheet is the area for entering additional quantity information per object.

• Editable Area

As with USER PSET, information is entered in the Field Input Area (Field ~ Description columns).
Only real or integer values related to quantities can be entered in the Value column.

• Adding Rows

Rows are added in the same way as USER PSET, and the added row is mapped to the IFCGUID of the row directly above.

• Referencing Information Sheet Values

Quantities can be calculated by referencing values from Information sheet.
For example, complex quantity calculations such as length × width area calculations or step-based formwork area calculations can be automated using Excel functions.

CIM Reflection Rules

Information entered in USER PSET / USER QSET is reflected in CIM according to the following rules.

• GUID-based Mapping : All entered information is mapped to objects based on IFCGUID.

• Added Row Mapping : User-added rows are mapped based on the IFCGUID entered in that row. To register additional properties on the same object, the IFCGUID must be identical to the row directly above.

• Empty Rows : Empty rows with no entered information are ignored during update.

• Deleted Objects : GUID rows for objects deleted in CIM have no mapping target and are ignored.

Use Case — VBA Function Library

Overview

• UtilforInfoSheet ⬇is a VBA User-Defined Function (UDF) library for use in USER PSET / USER QSET formulas in the InfoX Sheet environment.

• Using IFCGUID as the link, it automatically connects each object row in InfoX Sheet with the data in the Information sheet, handling value lookup · formwork quantity · paint quantity calculations in a single formula.

• The library consists of the following three function groups.

• Value Lookup : GV
• FormWork : FWS, FWH, FWAE, FWAI, FWA, FWD
• Paint : PTE, PTI, PTA

Common Operating Principles

• IFCGUID-based Automatic Matching

All functions read the IFCGUID from column E of the same row as the calling cell, then match it against column E of the MEMBER sheet (or the 6 sheets MEMBER / TENDON / STIFFENER / BOLT / LAYOUT / ETC for GV), and return the value from the matched row.

Object information is automatically linked by IFCGUID alone, without requiring users to specify rows or columns.

• Step Range Rules

The height step ranges used by formwork functions are defined as follows.

• Step 1 : 0m ~ 7m or less
• Step n (n ≥ 2) : greater than (7 + (n−2)×3)m ~ (7 + (n−1)×3)m or less

In other words, Step 1 covers up to 7m, and from Step 2 onward the range is divided in 3m increments.

• Tapered Section Handling

If the Tapered column of the MEMBER sheet has a value, the section is judged as tapered.
For tapered sections, the area functions (FWAE / FWAI / FWA / PTE / PTI / PTA) use a lateral formwork area distribution method, calculated through perimeter linear interpolation and trapezoidal-area-based weighted distribution.

For linearly varying tapered sections, the result is exact; for parabolic or other variations, an approximate value is calculated.
However, even in the case of approximate values, the total sum across all objects remains consistent.

GV — Get Value

Sequentially searches the MEMBER, TENDON, STIFFENER, BOLT, LAYOUT, and ETC sheets based on IFCGUID and returns the value of the specified column. Since IFCGUID is unique, the function locates the value automatically without requiring sheet specification.

• Syntax

=GV("col_name")

• Parameters

col_name (String, required) : Name of the column to look up. Must match the Header exactly. However, the lookup is case-insensitive.

• Return Value

The value of the matched cell. Returns [NO COLUMN: column_name] if the column does not exist, or an empty string if the value is empty.

• Examples

FWA — FormWork Area

Returns the combined exterior + interior formwork area (m²) at the specified step of the current object. Formwork deduction (FWD) is not included, so it must be subtracted separately.

• Uniform section : FWH × (PerimeterExt(S) + PerimeterInt(S))

• Tapered section : Perimeter linear interpolation + trapezoidal-area-based weighted distribution

• Syntax

=FWA(step_no)
=FWA(step_no, prev_length)

• Parameters

step_no (Long, required) : Relative step number based on the current object (1, 2, 3...)

prev_length (Variant, optional) : Accumulated height of previous objects (m). Defaults to 0 if omitted.

• Examples

Uniform section : Length=13m, ExtS=4.2m, IntS=3.0m

Formwork deduction example

PTA — Paint Area

Returns the combined exterior + interior paint area (m²) based on the full member length. Calculated for the entire member without step subdivision.

• Uniform section : Length × (PerimeterExt(S) + PerimeterInt(S))

• Tapered section : SurfaceArea - FaceArea(S) - FaceArea(E) (total lateral area as is)

• Syntax

=PTA()

• Examples

Function Summary

The complete list of functions provided by the QSET UDF Library.

Error Message List

References

• Generate(InfoX Sheet)

• Edit Default Property Set

• Edit Default Quantity Set 

• Open Link InfoX Sheet / Update Object Name

Attachment: UtilforInfoSheet.bas