Support site for Simplebim users
Model Worksheet

On the Model worksheet you can edit the model schema and the data of the model.

The model worksheet has the following sections

Section Description
Set Units Units can be set for the model and for the template.
Add Identity to Object In this section you can add new identities (names) for Object Classes
Add Property to Object Class or Group In this section you can add new properties to Object Classes or Groups
Add Identity to Property In this section you can add new identities (names) for properties.
Swap Property Values In this section you can swap the values of two properties.
Trim Text Property Values You can use this section to trim away part of a text property value, for example a prefix or postfix.
Find and Replace Text Property Values You can use this section for setting the value of a text property based on the current value of the same property.
Set Property Values Based on Text Property Value In this section you can set the value of one property based on the text value of another property.
Copy Property Values In this section you can copy text property values from one property to another.
Move and Rotate Site In this section you can move and rotate the site object.
Move and Rotate Project In this section you can move and rotate the project object.

Rotate Site Around Pivot Point

In this section you can rotate the site around a given pivot point

Set Units -section

Units can be set for the model and for the template.

Setting the model units affects the unit definition of the model (the model is converted to these units) and thus also the exported IFC file. If no value is given for a model unit, the unit defined in the imported IFC model is used.

The template units define the interpretation of any measure values used in the template. If no value is given for a template unit the model unit is assumed. Template units have no effect on the units of the exported IFC file.

Add Identity to Object -section

In this section you can add new identities (names) for Object Classes. This has no effect on the IFC export but allows you for example to translate the names of object classes to your own language in the simplebim user interface.

Field Value Description
Object [+] Text The name or identity key of the Object Class
Identity to Add [+] Text The name or identity key of the identity to add
Make Default Yes/No Make this the default identity, i.e. the name that is shown in the simplebim user interface?

Add Property to Object Class or Group -section

In this section you can add new properties to Object Classes and Groups. You use the Identities defined on the Resources sheet for adding new properties.

Adding a property to an Object Class automatically includes that property in the model view. If you want to exclude the property you added, you must exclude it explicitly in the ‘Include/Exclude Property’ section of the ModelView worksheet. 

Field Value Description
Object or Group [+] Text

The name or identity key of a Object Class or the Name of a Group

When you add a property to a Group the property is added to the Group object itself, not to the objects contained by the group.

Property [+] Text The name or identity key of the Identity used for creating the new property
Property Type Choice The type of the property. Allowed values are: Yes/No, Number,  Whole Number, Logical, Text and the various measure types, such as length, area and volume.
Single/List Choice The aggregation of the property. Allowed values are: Single, List
Unit Symbol Text

The unit symbol of the property, e.g. mm - applies only to measure properties. Must be valid for the Unit Type, e.g. mm is valid for length, but not for area. If no Unit Symbol is given the Model Units are used, i.e. the property will have the Unit Symbol defined in the using of the model for the applicable Unit Type.

Add Identity to Property -section

In this section you can add new identities (names) for properties. This has no effect on the IFC export but allows you for example to translate the names of properties to your own language in the simplebim user interface.

Field Value Description
Object [+] Text The name or identity key of the Object Class
Existing Property Text The name or identity key of the property you want to add the new identity to. This property must already exist on the object class.
Identity to Add [+] Text The name or identity key of the identity to add
Make Default Yes/No Make this the default identity, i.e. the name that is shown in the simplebim user interface?

Swap Property Values -section

In this section you can swap the values of two properties. When you swap property values (instead of copy) the values of both properties remain in the model for future use.

Field Value Description
Object [+] Text The name or identity key of the Object Class
Property 1 Text The name or identity key of the first property
Property 2 Text The name or identity key of the second property

Trim Text Property Values -section

You can use this section to trim away part of a text property value, for example a prefix or postfix. You could for example trim a ‘Basic Wall’ prefix from the building element construction type of walls.

There is a separate section in the template for trimming before copy operations and after copy operations because the order of events determines if the trim is applied to a copied value or to the original value.

       
Field Value Description
Object or Group [+] Text The name or identity key of the Object Class or Group
Trim Property Text The name or identity key of the text property to trim
Trim Type Text The type of the trimming. Allowed values are: prefix, postfix, anywhere, regex and regex inverse.
Case Sensitive Yes/No Perform case sensitive comparison? This setting is ignored if the trim type is regex or regex inverse.
Text to Trim Text The text to trim from the position defined by the trim type. If the trim type is regex or regex inverse, the value in this cell is used as the regular expression.

Find and Replace Text Property Values -section

You can use this section for setting the value of a text property based on the current value of the same property. You could for example replace ‘Mtg.’ with ‘Meeting’ in space names.

NOTE: There is a separate section in the template for find and replace before copy operations and after copy operations because the order of events determines if the find and replace is applied to a copied value or to the original value.

Field Value Description
Object or Group [+] Text The name or identity key of the Object Class or Group
Find Property [+] Text The name or identity key of the property for which you want to find and replace values
Text Operator Choice The text operator for finding values
Case Sensitive Yes/No Perform case sensitive comparison?
Find Value [+] Text The value(s) to find. Leave empty to find empty values. You can specify multiple values by adding new rows to the cell (Alt + Enter)
Replace Value Text The value replacing the found value(s). Leave empty to replace the found value(s) with an empty value.
Replace Type Choice

The type of the replacement

Whole Text Any value matching the criteria will replaced by the Replace Value. For example if the criteria is 'Starts With A' and the Replace Value is 'B, then the value 'ABA' will become 'B'
Within Text The part of the value that matches criteria will be replaced by the Replace value.  For example if the criteria is 'Starts With A' and the Replace Value is 'B, then the value 'ABA' will become 'BBA'
                                  

Set Property Values Based on Text Property Value -section

In this section you can set the value of one property based on the text value of another property. You could for example set the IsExternal property to ‘Yes’ for all walls that have a building element construction type that starts with ‘EXT’.

There is a separate section in the template for setting property values before copy operations and after copy operations because the order of events determines if finding the objects for which the property values are set is done based on a copied value or to the original value.

If you need a large number of such operations the Enrichment system is probably the better alternative because it is much more compact and easy to manage. 

Field Value Description
Object or Group [+] Text The name or identity key of the Object Class or Group

The special value “All” applies the operation to all objects classes that have the Find Property, or if a Find Property is not given, the Set Property.

Find Property [+] Text

The name or identity key of the property for which you want to find and replace values.
If the Find Property is empty, the operation is applied to all objects of the given object class or object group.

Text Operator Choice The text operator for finding values
Case Sensitive Yes/No Perform case sensitive comparison?
Find Value [+] Text The value(s) to find. Leave empty to find empty values. You can specify multiple values by adding new rows to the cell (Alt + Enter). Or –logic is applied if there are multiple values.
Set Property Text The name or identity key of the property for which you want to set the value.
Set Value Mixed The value you want to set for the property. The value is converted to the data type of the Set Property. If you are setting measure values, please pay attention to the Template Units.

Copy Property Values -section

In this section you can copy text property values from one property to another. Using regular expression you can also copy only a part of the original value.

Field Value Description
Object or Group [+] Text The name or identity key of the Object Class or Group
From Property Text The name or identity key of the property from which you want to copy the values
To Property Text The name or identity key of the property into which you want to copy the values
Copy Empty Values Yes/No Should empty values be copied? Use No if you want to merge the values of the two properties.
Overwrite Non Empty Values Yes/No If the 'To Property' already has a value, should that value be overwritten by the value of the 'From Property'? Use No if you merge the values of the two properties and want to give priority to the values in the To Property.
Regular Expression Text You can optionally use regular expressions for modifying the property value that is being copied. Only the part of the original value that is selected by the specified regular expression will be copied.
The From Property can also be from another object or group, like a the space containing the object or the system the object belongs to

The syntax is: [Reference].Property

For example [Space].Space Name

The example above copies the value of the Space Name property from the space containing the object.

The notations are case insensitive and whitespace is ignored also within the text, for example 'building storey' is the same as 'BUILDINGSTOREY'. For groups the property Name is the name of the group, for example [System].Name copies the name of the system. If an object belongs to multiple groups within the same category, e.g. an object belongs to multiple systems, then the first group found is used.

The  notations in the following table are supported.

Notation Description
[Container] The container of the object regardless of object class
[Space] The space containing the object
[Building Storey] The building storey containing the object
[Building] The building containing the object
[Site] The site containing the object
[Project] The project containing the object
[Element Assembly] The element assembly containing the object
[Main Element Assembly] The main / top-most element assembly containing the object. This notation is useful if your model contains nested element assemblies, i.e. assemblies that contain other assemblies.
[Curtain Wall] The curtain wall containing the object
[Model] The model the object is part of
[Asset] The asset (group) the object belongs to
[Building System] The building system (group) the object belongs to
[Distribution Circuit] The building system (group) the object belongs to
[Distribution System] The distribution system (group) the object belongs to
[Group] The IFC group the object belongs to
[Inventory] The inventory (group) the object belongs to
[System] The system (group) the object belongs to
[Zone] The zone (group) the object belongs to
[Group|Group Category] The group from a custom group category the object belongs to. For example the notation [Group|DC:GROUPS:ERRORS] copies from the error groups that are created by various tools.
[Classification|Classification System] The classification notation from the specified classification system. For example the notation [Classification|Uniformat] copies from the classification notation assigned to the object from the Uniformat classification system
[Reference Property] Any reference found on the object can be used. For example the notation [DC:CONTAINEDBY] uses the Contained By property and copies from the container of the object
[Reference Property|Object Class] Same as Reference Property above, but follows the reference until an object from the specified object class is found. For example the notation  [DC:CONTAINEDBY|DC:SPACE] copies from the space containing the object
           

Rotate Site Around Pivot Point -section

In this section you can move and rotate the site object around a given pivot point, typically for preparing a model for use as part of a combined model.

X, Y and Z must be in the length unit measure (mm, m, inch, feet…) of the model.
Field Value Description
Pivot Point X Number X coordinate of the pivot point
Pivot Point Y Number Y coordinate of the pivot point
Pivot Point Z Number Z coordinate of the pivot point
Rotation (deg) Number Value between 0 and 360
Relative/Absolute Choice
Relative Rotates relative to the current rotation
Absolute Sets the rotation to the rotation value given here.

Move and Rotate Site -section

In this section you can move and rotate the site object, typically for preparing a model for use as part of a combined model.

X, Y and Z must be in the length unit measure (mm, m, inch, feet…) of the model.
Field Value Description
X Number X value of the offset
Y Number Y value of the offset
Z Number Z value of the offset
Rotation (deg) Number Value between 0 and 360
Relative/Absolute Choice
Relative Adds the X, Y and Z values given here to the current X, Y and Z values of the site, and rotates relative to the current rotation
Absolute Sets the X, Y and Z values of the site to the X, Y and Z values given here and sets the rotation to the rotation value given here.

Move and Rotate Project -section

In this section you can move and rotate the project object, typically for preparing a model for use as part of a combined model.

X, Y and Z must be in the length unit measure (mm, m, inch, feet…) of the model.

Field Value Description
X Number X value of the offset
Y Number Y value of the offset
Z Number Z value of the offset
Rotation (deg) Number Value between 0 and 360
Relative/Absolute Choice
Relative Adds the X, Y and Z values given here to the current X, Y and Z values of the project, and rotates relative to the current rotation
Absolute Sets the X, Y and Z values of the project to the X, Y and Z values given here and sets the rotation to the rotation value given here.