dRofus Help & Learning
dRofus Help & Learning
Breadcrumbs

COBie Compliant Export

There are times when a COBie deliverable is required and with the growing trend toward using COBie via the buildingSMART Alliance we have created a short guide to how to use our excel export settings to meet these needs. There are several levels to COBie compliance and in the example below we are using the Example provided by NIBS. 

1. Excel Export:

  1. Administration→ Configure Excel Export

  2. New Export

  3. Name COBie

  4. Shared for multi user access

  5. Select template 

  6. Save

2. Name Sheets by Selecting the New within the"Sheet" tab. Ensure that the naming convention of each sheet is consistent with CoBie Standards. By default, the starting row is 1. Switch the starting row for each sheet to 2. Save Each Sheet. 

  1. Instruction 

  2. Contact

  3. Facility

  4. Floor

  5. Space

  6. Zone

  7. Type

  8. Component

  9. System

  10. Assembly

  11. Spare

  12. Resource

  13. Job

  14. Impact

  15. Document

  16. Attribute

  17. Coordinate

  18. Connection

  19. Issues

  20. PickLists

3. Assign Data Sources to the following Sheets.

1.jpg

attributes.jpg

complex value.jpg

  1. ContactTarget Type: UserName: ContactAttributes: Add: General: EmailAdd fixed value: dRofus_adminAdd fixed value: n/aAdd fixed value: PlannerAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: dRofusSave

  2. FacilityTarget Type: ProjectName: ProjectAttributes:Add: General: NameSave

  3. FloorTarget Type: GroupName: FloorAttributes:Add: General: NameAdd: Created by: Created by: EmailAdd: Group Type: Group Type: CreatedAdd: General: ReferenceAdd fixed value: dRofusAdd fixed value: ifcBuildingStoreyAdd fixed value: n/aAdd: General: DescriptionAdd fixed value: n/aAdd fixed value: n/aSave

  4. SpaceTarget Type: RoomName: SpaceAttributes:Add: Room: Room Function #Add: Created by: Created by: EmailAdd fixed value: n/aAdd: Level: Level: Name **Add Complex value: Room Name, Room Name DescriptionFormat Template: {0} {1}E.g: Room Name Room Name DescriptionAdd fixed value: dRofusAdd fixed value: IfcSpaceAdd fixed value: n/aAdd: Room: Name on DrawingAdd: Room: Prog. AreaAdd: Room: Designed AreaAdd: Room: Ceiling HeightSave

  5.  ZoneTarget Type: Room Name: RoomAttributes:Add Complex Value: Room Function: Number, Room Function: NameFormat Template: {0} {1}E.g: Room function: Number Room function: NameAdd fixed value: dRofus_adminAdd fixed value: n/aAdd fixed value: Occupancy ZoneAdd: Room: Room Function #:Add fixed value: dRofusAdd fixed value: n/aAdd fixed value: n/aAdd: Room: Room NameSave

  6. Type:Target Type: ItemName: ItemAttributes: Add: General: Item NumberAdd Fixed Value: ( leave blank)Add: Log History: CreatedAdd: General: Name Add: Categorization: Sub Set (Name)Add: Specification - Description (Flag) - Asset Type (Group) - Fixed/Movable (Element) - (Radio buttons/ combo box)*Add fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd fixed value: dRofusAdd fixed value: n/aAdd fixed value: n/aAdd: General: Budget Price Add fixed value: n/aAdd fixed value: n/aAdd fixed value: n/aAdd: General: Item NumberAdd: Specification-Building I (Flag): Max dimensions and weight (Group) - With/length (Element) - inch (Numeric Field) *Add: Specification-Building I: Max dimensions and weight - Depth (Element) - inch (Numeric Field) *Add: Specification-Building I : Max dimensions and weight - Height (Element) - inch (Numeric Field) *Save

*Attribute Added to Item Specification GUI

** Added type to Groups

This page references https://www.nibs.org/?page=bsa_commonbimfiles