Page tree
Skip to end of metadata
Go to start of metadata

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. Contact
    1. Target Type: User
    2. Name: Contact
    3. Attributes: 
      1. Add: General: Email
      2. Add fixed value: dRofus_admin
      3. Add fixed value: n/a
      4. Add fixed value: Planner
      5. Add fixed value: n/a
      6. Add fixed value: n/a
      7. Add fixed value: dRofus
    4. Save
  2. Facility
    1. Target Type: Project
    2. Name: Project
    3. Attributes:
      1. Add: General: Name
    4. Save
  3. Floor
    1. Target Type: Group
    2. Name: Floor
    3. Attributes:
      1. Add: General: Name
      2. Add: Created by: Created by: Email
      3. Add: Group Type: Group Type: Created
      4. Add: General: Reference
      5. Add fixed value: dRofus
      6. Add fixed value: ifcBuildingStorey
      7. Add fixed value: n/a
      8. Add: General: Description
      9. Add fixed value: n/a
      10. Add fixed value: n/a
    4. Save
  4. Space
    1. Target Type: Room
    2. Name: Space
    3. Attributes:
      1. Add: Room: Room Function #
      2. Add: Created by: Created by: Email
      3. Add fixed value: n/a
      4. Add: Level: Level: Name **
      5. Add Complex value: Room Name, Room Name Description
        1. Format Template: {0} {1}

        2. E.g: Room Name Room Name Description
      6. Add fixed value: dRofus
      7. Add fixed value: IfcSpace
      8. Add fixed value: n/a
      9. Add: Room: Name on Drawing
      10. Add: Room: Prog. Area
      11. Add: Room: Designed Area
      12. Add: Room: Ceiling Height
    4. Save
  5.  Zone
    1. Target Type: Room 
    2. Name: Room
    3. Attributes:
      1. Add Complex Value: Room Function: Number, Room Function: Name
        1. Format Template: {0} {1}
        2. E.g: Room function: Number Room function: Name
      2. Add fixed value: dRofus_admin
      3. Add fixed value: n/a
      4. Add fixed value: Occupancy Zone
      5. Add: Room: Room Function #:
      6. Add fixed value: dRofus
      7. Add fixed value: n/a
      8. Add fixed value: n/a
      9. Add: Room: Room Name
    4. Save
  6. Type:
    1. Target Type: Item
    2. Name: Item
    3. Attributes: 
      1. Add: General: Item Number

      2. Add Fixed Value: ( leave blank)
      3. Add: Log History: Created
      4. Add: General: Name 
      5. Add: Categorization: Sub Set (Name)
      6. Add: Specification - Description (Flag) - Asset Type (Group) - Fixed/Movable (Element) - (Radio buttons/ combo box)*
      7. Add fixed value: n/a
      8. Add fixed value: n/a
      9. Add fixed value: n/a
      10. Add fixed value: n/a
      11. Add fixed value: n/a
      12. Add fixed value: n/a
      13. Add fixed value: n/a
      14. Add fixed value: dRofus
      15. Add fixed value: n/a
      16. Add fixed value: n/a
      17. Add: General: Budget Price 
      18. Add fixed value: n/a
      19. Add fixed value: n/a
      20. Add fixed value: n/a
      21. Add: General: Item Number
      22. Add: Specification-Building I (Flag): Max dimensions and weight (Group) - With/length (Element) - inch (Numeric Field) *
      23. Add: Specification-Building I: Max dimensions and weight - Depth (Element) - inch (Numeric Field) *
      24. Add: Specification-Building I : Max dimensions and weight - Height (Element) - inch (Numeric Field) *
    4. Save

*Attribute Added to Item Specification GUI

** Added type to Groups

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


  • No labels