COBie : Ironmongery Schedules

In COBie there is no published example in the offical documentation of how to include assemblies of asset types (products) and associate them to asset instances (components) such as doors with ironmongery sets. The primary driver of COBie was to focus on managed assets. Door furniture, card key access and automatic closing systems are more prevalent in buildings. Door ironmongery is a fericely competive market and capital costs with long warranty periods of between 10-25 years are often overlooked but can prove very valuable in reducing whole life costs.

The objective of including ironmongery sets in the Cobie asset data set is to provide detailed information for the purposes of maintenance and repair in FM.

The assembly table allows you to create assemblies of types or components but does not allow a mixture of both. However by using the Attribute table it is possible to connect instances to assemblies of types. The COBie specification did allow the extension of any table but the use of custom fields and how they relate will not automatically be recognised by Cobie Readers and may result in data being lost. The following method ensures data is not lost. However it is import that is structure is conveyed so that the data can be consumed.

Tables to be populated

  • Contact
  • Type
  • Component
  • Assembly
  • Attribute

CobieIronmongerySchedule

Steps

  1. A door type must exist in Cobie.Type and an instance in Cobie.Component
    Cobie.Type.Name = Doors_Type_A
    Cobie.Component.Name = Doors_Type_A_DR001
    Cobie.Component.TypeName = Doors_Type_A
    Cobie.Component.TagNumber = DR001
  2. In an ironmongery set add all the parts to the Cobie.Type table and include the manufacturer in the Cobie.Type.Manufacturer as the email reference to Cobie.Contact.
    Cobie.Type.Name = ironmongery-part-01
    Cobie.Contact.Email = info@manufacturer.com
  3. Create for each Ironmongery set a record in Cobie.Type
    Type.Name = ironmongery-set-01
    It the set is not composed of products from the same ironmongery manufacturer then use the installation contractor as manufacturer which may be the door manufacturer when the door is preassembled as a set.
  4. Create in the Cobie.Assembly table a record for each part in the ironmongery set.
    Each Cobie.Assembly.Name will need to be unique so that Quantities can be associated to the record.
    Assembly.Name = as-ironmongery-set-01-01
    cobie.Assembly.Sheet = type
    Cobie.Assembly.Parent = ironmongery-set-01
    Cobie.Assembly.Child = ironmongery-part-01
  5. In Cobie.Attribute create a record
    Attribute.Name = Quantity
    Cobie.Attibute.SheetName = Assembly
    Cobie.Attribute.RowName = as-ironmongery-set-01-01
    Cobie.Attribute.Value = 1.5
    Cobie.Attribute.Unit = pair
  6. To associate the ironmongery set to the instance of the door create an Attribute that connects the Type (which has an assembly) to the Component (instance of the door).
    Attribute.Name = IronmongerySet
    Cobie.Attibute.SheetName = Compononent
    Cobie.Attribute.RowName = Doors_Type_A_DR001
    Cobie.Attribute.Value = ironmongery-set-01
    Cobie.Attribute.Unit = type

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s