Product(s):	OpenBuildings Designer
	Version(s):	CONNECT Edition
	Area:	Import/Export
	Subarea:	COBie

Problem: 

I have exported a COBie spread sheet. What do these different colors on the spread sheet indicate?

Solution:

COBie is designed to enhance collaboration and facilitate the transition from construction to facility management. Its standardized format helps improve the accuracy and accessibility of asset information throughout the building’s lifecycle.

COBie files can be accessed using MS excel sheets which eliminates the requirement of complicated and expensive tools to access the data and at the same time makes it easier for everyone to contribute their part.

In a COBie (Construction-Operations Building Information Exchange) spreadsheet, different colors are used to signify specific information. Let’s break it down:

1. Yellow and Salmon Columns:
○ These columns are required and clearly defined for a minimum deliverable.
○ They contain essential information that must be included in the COBie dataset.
○ Examples of required columns include asset names, types, and locations.

2. Purple and Green Columns:
○ These columns are source software or owner-specific.
○ They may contain additional data relevant to specific software tools or customized requirements.
○ Examples of source-specific columns include manufacturer details, warranty information, or custom classifications.
COBie aims to streamline the exchange of building information, making it more efficient for facility managers, maintenance teams, and owners.

The format of a typical COBie spread sheet looks like the following:

The COBie spreadsheet is comprised of multiple worksheets that represent different data tables, with yellow columns for required primary and core element attributes, salmon for required foreign keys, purple for references back to authoring software platforms, and green for additional information needed for specific projects. Please refer the below image as a summary of the colors used.

The various COBie worksheets come together to present a complete data picture of a building, including information about the building, floors, spaces, zones, types, components, systems, and documents.

COBie is intended to be a collaborative effort that evolves with the project, with everyone from the building owner to the trade contractors playing a critical role. The building owner holds the keys to team efficiency and accuracy in collecting and capturing COBie data, and clearly defining their requirements is crucial.