Introduction

This guide explains how to extract the data stored in your BIMXtra Project and insert it into a COBie UK template.

This document is structured to match the tabs and columns from the COBie template, showing how each field in the COBie export is populated with data from the BIMXtra project schedules.

Where a COBie field is visible to you within BIMXtra (e.g. email), the screen it is found on is identified with the name of the area it is in (e.g. user profile).

Not all fields can be seen by users in BIMXtra, these fields are identified as 'system parameters' below.

Some fields are generated from COBie picklist values when the report is produced, these fields are identified as 'COBie default values' below.

General notes

The BIMXtra COBie function exports object information from the items that have been mapped into the BIMXtra project schedules and federates that data based on the building/site reference selected during the export.

The UK COBie Template Version 2 Release 4 is used to generate the BIMXtra COBie exports, while the picklists provided in the exported file are aligned to Uniclass 2015 Feb 2018 release.

You must map the building parameter for each schedule for it's components to be visible in the COBie export

COBie field types

Fields are either 'Required' or 'Optional' in the COBie export and they are formatted as shown below in the exported file.

Required & reference fields are formatted in the COBie export file as:

Optional fields are formatted in the COBie export file as:

Fields are grouped into tabs in the exported .csv file as shown:

Schedule configurations for COBie

BIMXtra provides a lot of flexibility for schedule configuration and COBie export and alignment is to be considered when configuring your project.

Therefore, please ensure you have followed the mandatory schedule column configuration required for correct COBie exports to be produced.

COBie tabs

The following section lists where the information is populated from when you generate a COBie export .csv file.

Field names are shown along with the source of that data in BIMXtra. Sources are:

User Profile - Data extracted form the BIMXtra user profile.
System Parameter - Data extracted from the BIMXtra system and its logs. Please submit a request to the Clearbox Support Desk to modify these values.
Project Parameter - Data extracted from the BIMXtra project configuration.
COBie Default Value - Data extracted from a picklist or a default COBie value.
Schedule Parameter - Data extracted from the BIMXtra Schedules. These entries require user configuration to map data from the model to the schedules the documentation identifies the column name in bold that relates to the output.

This guide lists each tab in the COBie export and details the fields it contains, showing whether they are Required & Reference Fields or Optional Fields.

Contacts Tab

For every BIMXtra user account that has been given access to the selected project, the following fields are exported:

Required & Reference Fields

E-mail (User Profile): The primary email address linked to the user account given access to the project.
CreatedBy (System parameter): The primary email address linked to the person who granted access to the user account.
CreatedOn (System parameter): The date the user account was granted access.
Category (COBie default value): Reference column from the Uniclass 2015 picklist. Defaults to "PM_10 : Project information".
Company (User Profile): The user account's "User Company".
Phone (User Profile): The phone number linked to the user account.
ExternalSystem (System Parameter): Fixed value set to "Clearbox: BIMXtra".
ExternalObject (COBie default value): Reference column from the COBie picklist template. Fixed value set to "IfcPersonAndOrganization".
ExternalIdentifier (System Parameter): The BIMXtra System ID for the user account. This will be a numeric number value.

Optional Fields

Department (User Profile): The Department of the user account given access to the project.
OrganizationCode (System Parameter): The BIMXtra Abbreviation of the User Company.
GivenName (User Profile): The user account Forename.
FamilyName (User Profile): The user account Surname.
Street (User Profile): The concatenation of the values of Address Line 1 & Line 2.
PostalBox (System Parameter): The PostalBox of the User Company.
Town (User Profile): The user account Town.
StateRegion (User Profile): The user account County.
PostalCode (User Profile): The user account Post Code.
Country (System Parameter): Defaults to UK.

Facility tab

Information in the Facility tab is based on data held in the BIMXtra Project module and Room Schedules.

Please note, BIMXtra only exports a single building at a time and will federate the model component data assigned to that building/site reference.

Required & Reference Fields

Name (project parameter): The Building/Site reference imported into the schedules.
CreatedBy (System parameter): The email address of the user account who first imported the value into the BIMXtra schedules.
CreatedOn (System parameter): The date at which the Building/Site reference first appeared in the schedules.
Category (COBie default value): Reference column from the Uniclass 2015 picklist. Defaults to "En_20 : Administrative, commercial and protective service entities".
ProjectName (Project Parameter): The concatenation of the values from the Project Configuration Project sector, Project No & Project Name.
SiteName (Project Parameter): The Project Address from the Project Configuration.
LinearUnits (COBie default value): Defaults to "meters".
AreaUnits (COBie default value): Defaults to "squaremeters".
VolumeUnits (COBie default value): Defaults to "cubicmeters".
CurrencyUnit (COBie default value): Defaults to "Pounds".
AreaMeasurement (COBie default value): Defaults to "Indicative".
ExternalSystem (System Parameter): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExternalProjectObject (COBie default value): Reference from the COBie picklist. Defaults to "IfcProject".
ExternalProjectIdentifier (Project Parameter): Populated with the Project Number from the Project landing page.
ExternalSiteObject (COBie default value): Reference column from the COBie picklist. Defaults to "IfcSite".
ExternalSiteIdentifier (Project Parameter): Populated with the Project Number from the Project landing page.
ExternalFacilityObject (COBie default value): Reference column from the COBie picklist. Defaults to "IfcBuilding".
ExternalFacilityIdentifier (Project Parameter): Populated with the Project Number from the Project landing page.
Description (Project Parameter): Populated with the Project Sector from the Project landing page.

Optional Fields

ProjectDescription (Project Parameter): Populated with the Project Description from the Project landing page.
SiteDescription (COBie default value): Defaults to "n/a".
Phase (Project Parameter): Populated with the value of Plan of Work Level of Detail from the Project landing page.
1. Stage * - Not set, equals RIBA 2013 0 : Strategic Definition.
2. Stage 1 - Preparation and Brief, equals RIBA 2013 1 : Preparation and Brief.
3. Stage 2 - Concept Design, equals RIBA 2013 2 : Concept Design.
4. Stage 3 - Developed Design, equals RIBA 2013 3 : Developed Design.
5. Stage 4 - Technical Design, equals RIBA 2013 4 : Technical Design.
6. Stage 5 – Construction, equals RIBA 2013 5 : Construction.

Floor tab

Information in the Floor tab is based on data held in the Room/Space schedule of BIMXtra.

Please note, floor references only appear once, based on the values in the Level column populating the Room/Space schedule.

Required & Reference Fields

Name (Schedule Parameter): Populated with the Level column values from the Room/Space schedule.
CreatedBy (System parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn (System parameter): Shows the date at which the Level reference first appeared in the Room/Space schedule.
Category (COBie default value): Defaults to "Floor" unless Floor Name contains text characters for "Roof" or "Site", then one of these will be populated instead.
ExternalSystem (System parameter): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject (COBie default value): Reference column from the picklist to the rear of the COBie template. Defaults to "IfcBuildingStorey".
ExtIdentifier (System parameter): Populated with the Project number from the Project Landing page.

Optional Fields

Description (Schedule Parameter): This is populated with the Level column values from the Room/Space schedule.
Elevation (COBie default value): Defaults to "n/a".
Height (COBie default value): Defaults to "n/a".

Space Tab

Information in the Space Tab is based on data held in the Room/Space schedule of BIMXtra.

Please note, Room/Space references appear based on the number of rows in the Room/Space schedule.

Required & Reference Fields

Name (Schedule Parameter): Populated with the Room/Space Number column values from the Room/Space schedule.
CreatedBy (System parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn (System parameter): Shows the date at which the Number reference first appeared in the Room/Space schedule.
Category (COBie default value): Defaults to "SL_20_15: Administrative spaces", unless the Name column from the BIMXtra schedule contains one of the text fields below:
1. Office, Board Room or Conference Room equals "SL_20_15_59 : Offices"
2. Circ, Lift, Corridor, Atrium, Light Bay or Bolthole equals "SL_90_10 : Circulation spaces"
3. Servery, Tea Point or Food Prep equals "SL_35_60_30 : Food preparation areas"
4. Plant, Biomass, Riser, Duct, Server, Hose Reel, Services, Void, Hydraulic, Power or HV equals "SL_90_90 : Plant and control spaces"
5. Store, Clnr or Cleaner equals "SL_90_50 : Storage spaces"
6. Pod, Library or Faith equals "SL_25_70 : Information spaces"
7. Class, Learning, Foundation, Key Skills, Programme, Business, PSHE or Association equals "SL_25_10_14 : Classrooms"
8. Workshop equals "SL_25_10_28 : Educational workshops"
9. Medical, Drug or First Aid equals "SL_35_10 : Medical spaces"
10. Laundry equals "SL_30_60_47 : Laundries"
11. Stair equals "SL_90_10_87 : Stairways"
12. WC or Toilet equals "SL_35_80_89 : Toilets"
13. Entrance or Lobby equals "SL_90_10_27 : Entrance halls"
14. Reception equals "SL_20_15_71 : Reception areas"
15. Meeting equals "SL_20_15_50 : Meeting rooms"
16. Kitchen equals "SL_45_10_44 : Kitchen-dining rooms"
FloorName (Schedule Parameter): This populates with the Level column value from the Room/Space schedule.
Description (Schedule Parameter): This populates with Room/Space Name column values from the Room/Space schedule.
ExternalSystem (System parameter): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject (COBie default value): Reference column from the COBie picklist. Defaults to "IfcSpace".
ExtIdentifier (Project parameter): The concatenation of the Project Number & Space Identifier values for each row in the Room/Space schedule.

Optional Fields

RoomTag (Schedule Parameter): This populates with Room/Space Name column values from the Room/Space schedule.
UsableHeight (Schedule Parameter): This populates with Height column values from the Room/Space schedule.
GrossArea (COBie default value): Defaults to "blank".
NetArea (Schedule Parameter): This populates with Area column values from the Room/Space schedule.

Zone tab

Information in the Zone tab is based on data held in the Room/Space schedule of BIMXtra.

Required & Reference Fields

Name (Schedule Parameter): Populated with the Room/Space Department column values from the Room/Space Schedule.
CreateBy (System parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn (System parameter): Shows the date at which the Department reference first appeared in the Room/Space schedule.
Category (COBie default value): Defaults to "Occupancy Zone".
SpaceNames (Schedule Parameter): Contains a comma separated list of the values mapped to the Number column in the room schedule that have matching department values.
ExternalSystem (System parameter): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject (COBie default value): Reference column from the picklist to the rear of the COBie template. Defaults to "IfcZone".
ExtIdentifier (COBie default value): Defaults to "n/a".

Optional Fields

Description (Schedule Parameter): Populated with the Room/Space Department column values from the Room/Space schedule.

Type tab

Information in the Type tab is based on data held across all selected schedules in BIMXtra.

Required & Reference Fields

Name (Schedule Parameter): The concatenation of the Schedule Name & Object Name column values from the selected schedules.
CreatedBy (System parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn (System parameter): Shows the date at which the object name reference first appeared in the selected schedule.

Category (COBie default value): Reference column from the Uniclass 2015 picklist based on schedule type. Please see lookup list below:

Schedule Name	Grouping	Uniclass 2015 Reference
Builderswork	Architectural	n/a
Ceiling	Architectural	Pr_35_90_43 : Interior wall and ceiling trims
Curtain Wall	Architectural	Pr_20_65_34 : Glazed structures
Door: Internal	Architectural	Pr_30_59_24 : Doorsets
Equipment	Architectural	Pr_40_70 : Equipment
External Doors	Architectural	Pr_30_59_24 : Doorsets
External Items	Architectural	n/a
External Wall	Architectural	Pr_20_93_52 : Masonry walling units
External Window	Architectural	Pr_30_59_98 : Window units
Furniture, Fixtures and Fittings	Architectural	Pr_40_50 : Furnishings
Glazed Screen	Architectural	Pr_35_90_43 : Interior wall and ceiling trims
Rooflight	Architectural	Pr_30_59_72 : Rooflights
Room	Architectural	n/a
Sanitary Fittings and Appliances	Architectural	Pr_40_20 : Sanitary fittings and accessories
Signage	Architectural	Pr_40_10_90_80 : Signage
Wall	Architectural	Pr_35_90_43 : Interior wall and ceiling trims
Window	Architectural	Pr_30_59_98 : Window units
Control Panel	Controls	Pr_75_50_18_17 : Control panels
Damper Actuator	Controls	Pr_75_50_18_21 : Damper actuators
Flow Device	Controls	Pr_40_70_96_31 : Flow control devices
Level Device	Controls	Pr_75_50_46 : Liquid level controllers and switches
Lifting Equipment	Controls	Pr_65_80_15 : Cranes and lifting systems
Moisture Device	Controls	Pr_25_57_53 : Moisture retention sheets
Odour Control Unit	Controls	Pr_60_45_58 : Odour control tank cover products
Operator Workstation	Controls	Pr_40_50_21_96 : Workstations
Pressure Device	Controls	Pr_60_50_67 : Pressure storage vessels
Screenings Handling	Controls	Pr_60_45_79 : Sludge screening products
Signal Interface	Controls	Pr_60_75_78 : Signal transmitters
Temperature Device	Controls	Pr_65_52_34_88 : Temperature gauges
User Interface	Controls	Pr_75_50_18 : Controllers and control panels
Valve Actuator	Controls	Pr_65_54 : Valve products
Communication	Electrical	Pr_70_75 : Communications products
Containment Fitting	Electrical	Pr_65_70_11 : Cable management
Containment Length	Electrical	Pr_65_70_11 : Cable management
DDA Equipment	Electrical	Pr_75_75_04 : Assistance and nurse call devices and control equipment
Distribution Equipment	Electrical	Pr_60_70_22 : Distribution boxes and switchboards
Electrical Capital Plant	Electrical	Pr_60_70 : Power supply products
External Luminaire	Electrical	Pr_70_70_48 : Luminaires, lighting track and lighting accessories
Final Outlet	Electrical	Pr_70_70 : Power and lighting outlet products
Fire and Safety Alarm	Electrical	Pr_75_75_30 : Fire alarm detection devices and control equipment
Lighting Control	Electrical	Pr_70_70_47 : Lighting controls and lighting distribution products
Luminaire	Electrical	Pr_70_70_48 : Luminaires, lighting track and lighting accessories
Mechanical Plant Drive	Electrical	Pr_75_51 : Motors, motor controls, control circuit devices and timeswitches
Protection	Electrical	Pr_65_70_46 : Lightning protection and earthing components
Public Address System	Electrical	Pr_75_75_94_72 : Radio public address interface boards
Security	Electrical	Pr_75_75 : Communications control products
Small Power System	Electrical	Pr_60_70 : Power supply products
Concrete Roads	External Works	Pr_15_31_26_37 : Highways Agency unbound mixtures Category B
Culvert	External Works	Pr_65_52_20 : Culverts
Drainage Run	External Works	Pr_65_52_24 : Drainage gullies and channels
Earthworks	External Works	Pr_15_31_26 : Excavated earth and fill materials
External Works	External Works	n/a
Footpath	External Works	Pr_15_31_26_46 : Landscape area fill materials
Gully	External Works	Pr_65_52_24 : Drainage gullies and channels
Inlet Screen	External Works	Pr_25_96_35_76 : Sewage screens
Manholes	External Works	Pr_65_52_01 : Access and inspection chambers and gullies
Road	External Works	Pr_15_31_26_37 : Highways Agency unbound mixtures Category B
Scaffolding	External Works	Pr_25_71_29_76 : Scaffolding and accessories
Service Chambers / Duct Boxes	External Works	Pr_65_52_01 : Access and inspection chambers and gullies
Service Run	External Works	Pr_65_52_01 : Access and inspection chambers and gullies
Slope Stability Works	External Works	Pr_15_31_12_42 : Injectable resinous soil stabilizers
Sprayed Concrete	External Works	Pr_20_31_16_84 : Sprayed concretes
Catchpits	External Works	Pr_25_93_60_12 : Combined drainage and kerb units
Detector Loop	External Works	Pr_70_75_72_22 : Detector loops
Drainage Runs	External Works	Pr_65_52_24_11 : Carriageway kerb and drainage channels
Emergency Telecom Equipment	External Works	Pr_70_75_88_27 : Emergency roadside telephones
Fencing and Barriers	External Works	Pr_20_85_07 : Barrier rails
Kerbs	External Works	Pr_25_30_86_72 : Rising kerbs
Linear Distribution Equipment	External Works	Pr_40_70 : Equipment
Road Earthworks	External Works	Pr_15_31_26 : Excavated earth and fill materials
Road Layers	External Works	n/a
Road Lighting	External Works	Pr_70_70_48 : Luminaires, lighting track and lighting accessories
Road Markings	External Works	Pr_35_31_85_27 : Epoxy paint road markings
Road Restraint	External Works	Pr_20_85 : Support and restraint products
Road Signs	External Works	Pr_40_10_77_72 : Road traffic signs
Structural Gantry	External Works	Pr_20_65_34_51 : Metal framed structures
Structural Masts	External Works	Pr_20_65_34_51 : Metal framed structures
Structural Parapets	External Works	Pr_25_71_57 : Non-metal barrier panels
Technology Sign and Signal	External Works	Pr_40_10_77_72 : Road traffic signs
Traffic Management	External Works	Pr_70_75_72 : Road traffic and pedestrian control signals
Demolitions & Abnormals	Facilitating Works	n/a
Site Establishment	Facilitating Works	n/a
Temporary Works	Facilitating Works	n/a
Ceiling Finishes	Finishes	Pr_35_31_22 : Decorative coatings
Coving Finishes	Finishes	Pr_35_31_22 : Decorative coatings
Floor Finishes	Finishes	Pr_35_31_22 : Decorative coatings
Skirting Finishes	Finishes	Pr_35_31_22 : Decorative coatings
Wall Finishes	Finishes	Pr_35_31_22 : Decorative coatings
Construction Navigation Points	HSE	Pr_40_10_57_50 : Marker posts
Design Navigation Points	HSE	Pr_40_10_57_50 : Marker posts
Environmental Hazard Markers	HSE	Pr_40_10_57_50 : Marker posts
Environmental Markers	HSE	Pr_40_10_57_50 : Marker posts
Exclusion Zones	HSE	n/a
H&S Hazard Markers	HSE	Pr_40_10_57_50 : Marker posts
Key Hazard Markers	HSE	Pr_40_10_57_50 : Marker posts
Plant or Equipment	HSE	Pr_40_70 : Equipment
Work Zone Equipment	HSE	Pr_40_70 : Equipment
Actuated Damper	HVAC Components	Pr_20_29_10_21 : Dampers
Air Handling Unit	HVAC Components	Pr_60_65_03 : Air handling units
Air Volume Control Device	HVAC Components	Pr_65_65_24_93 : Variable air volume boxes
Attenuator	HVAC Components	Pr_65_67_78 : Sound attenuators
Blowers	HVAC Components	Pr_60_45_03 : Air blower products
Boiler	HVAC Components	Pr_60_60_08 : Boilers
CHP	HVAC Components	Pr_60_70_65_60 : Packaged combined heat and power (CHP) units
Cooling Coil	HVAC Components	Pr_60_65_37 : Heating and cooling coils
Ductwork Fitting	HVAC Components	Pr_65_65_25 : Ductwork and fittings
Ductwork Insulation	HVAC Components	Pr_65_65_25 : Ductwork and fittings
Ductwork Length	HVAC Components	Pr_65_65_25 : Ductwork and fittings
Ductwork Termination	HVAC Components	Pr_65_65_25 : Ductwork and fittings
Exhaust Stack	HVAC Components	Pr_70_65_30_32 : Fume extract discharge stacks
Fan	HVAC Components	Pr_65_67_29 : Fans
Fan Coil and Induction Unit	HVAC Components	Pr_70_65_03_29 : Fan coil units
Filter (HVAC)	HVAC Components	Pr_65_57_02 : Air filters
Fire and Smoke Damper	HVAC Components	Pr_65_65_24_30 : Fire dampers
Flow Grid	HVAC Components	Pr_40_70_96_31 : Flow control devices
Heat Transfer Equipment	HVAC Components	Pr_60_65_37 : Heating and cooling coils
Heating Coil	HVAC Components	Pr_60_65_37 : Heating and cooling coils
Humidifier	HVAC Components	Pr_65_67_39 : Humidifiers and dehumidifiers
HVAC Capital Plant	HVAC Components	Pr_65_65 : Ductwork products
HVAC Parameter Gauge	HVAC Components	Pr_65_52_34 : Gauges and sight glasses
Manual Damper	HVAC Components	Pr_20_29_10_21 : Dampers
Plenum Box	HVAC Components	Pr_70_65_04_04 : Air plenum boxes
Supply and Extract Air Terminal	HVAC Components	Pr_65_70_46_01 : Air terminals
Commercial Manual Components	Manual Components	n/a
Design Manual Components	Manual Components	n/a
Unmapped Components	Other	n/a
Actuated Valve Body	Pipework Components	Pr_75_50_18_94 : Valve actuators
Ancillaries	Pipework Components	Pr_65_52_61 : Pipe accessories
Chilled Beam	Pipework Components	Pr_60_65_37_12 : Chilled water cooling coils
Condensate Pot	Pipework Components	Pr_65_53_86_17 : Condensate recovery units
Expansion Equipment	Pipework Components	Pr_60_50_20_28 : Expansion vessels
Filter (Pipe)	Pipework Components	Pr_65_57_96 : Water filters and strainers
FST PST Tank	Pipework Components	Pr_60_45_95 : Wastewater settlement products
Heat Emitter	Pipework Components	Pr_70_60_36 : Heat emitters
Heat Exchanger	Pipework Components	Pr_60_60_38_62 : Plate heat exchangers
Manual Valve	Pipework Components	Pr_65_54 : Valve products
Mixers	Pipework Components	Pr_60_75_08_54 : Mixers
Penstocks & Stop Logs	Pipework Components	Pr_60_45_30 : Flow control products
Pipework Capital Plant	Pipework Components	Pr_65_52_63 : Pipes and fittings
Pipework Fitting	Pipework Components	Pr_65_52_63 : Pipes and fittings
Pipework Insulation	Pipework Components	Pr_65_52_63 : Pipes and fittings
Pipework Length	Pipework Components	Pr_65_52_63 : Pipes and fittings
Pipework Parameter Gauge	Pipework Components	Pr_65_52_34 : Gauges and sight glasses
Pressurisation Equipment	Pipework Components	Pr_60_50_67 : Pressure storage vessels
Process Valve	Pipework Components	Pr_65_54 : Valve products
Pump	Pipework Components	Pr_65_53 : Pump products
Self Acting Valve	Pipework Components	Pr_65_54 : Valve products
Tank and Pressure Vessel	Pipework Components	Pr_60_50 : Tank, cylinder and vessel products
Termination	Pipework Components	Pr_65_52_63 : Pipes and fittings
Valve	Pipework Components	Pr_65_54 : Valve products
Elevated Slabs	Substructure	Pr_25_30_30 : Floor plates, gratings and edgings
Ground Bearing Slabs	Substructure	Pr_20_85_13 : Concrete base and foundation products
Pile Foundations	Substructure	Pr_20_85_62 : Piles and ancillary products
Slab and Topping	Substructure	Pr_20_85_13 : Concrete base and foundation products
Anchors	Superstructure	Pr_20_29_03 : Anchors and components
Bridge Structural Element	Superstructure	Pr_20_85_10 : Bridge bearings
Bridge Survey Defect	Superstructure	Pr_40_10_77_86 : Survey markers
Embedded Retaining Wall	Superstructure	Pr_20_93_71 : Retaining wall units
Foundations	Superstructure	Pr_20_85_13 : Concrete base and foundation products
Gravity Retaining Wall	Superstructure	Pr_20_93_71 : Retaining wall units
Insitu Beams	Superstructure	Pr_20_85_08 : Beams and joists
Insitu Columns	Superstructure	Pr_20_85_16 : Columns and column accessories
Insitu Walls	Superstructure	Pr_20_93_85 : Structural walling units
Precast Concrete Elements (manual)	Superstructure	Pr_20_85_13 : Concrete base and foundation products
Railing	Superstructure	Pr_25_30_36 : Handrails
Rebar	Superstructure	Pr_20_96_71_14 : Carbon steel ribbed bar reinforcement
Roofing	Superstructure	Pr_25_93_72 : Roofing and cladding units
Secondary Steelwork	Superstructure	Pr_20_65_34_51 : Metal framed structures
Stair	Superstructure	Pr_25_30_85 : Stair and ladder units
Structural Columns	Superstructure	Pr_20_85_16 : Columns and column accessories
Structural Frame	Superstructure	Pr_20_65_34_51 : Metal framed structures
Structural Panel	Superstructure	Pr_25_71 : Rigid board, panel and sheet products
Structural Precast Elements	Superstructure	Pr_20_93_71_17 : Concrete panels
Structural Wall	Superstructure	Pr_20_93_85 : Structural walling units

Description (Schedule Parameter): Populated with the Object Name column values from the selected schedules.
AssetType (System value): Defaults to "Fixed" unless the object is from the following schedules: Scaffolding, Demolition & Abnormals, Site Establishment, Temporary Works, Equipment and Furniture, Fixtures and Fittings - in which case the value is set to "Moveable".
Manufacturer (Schedule Parameter): Populated with the ManufacturerTypeRef column values from the selected schedules.
WarrantyGuarantorParts (Schedule Parameter): Populated with the ManufacturerName column values from the selected schedules.
WarrantyDurationParts (Schedule Parameter): Populated with the WarrantyDuration column values from the selected schedules.
WarrantyGuarantorLabor (Schedule Parameter): Populated with the ManufacturerName column values from the selected schedules.
WarrantyDurationLabor (Schedule Parameter): Populated with the WarrantyDuration column values from the selected schedules.
WarrantyDurationUnit (Schedule Parameter): Defaults to "Year" unless the WarrantyDuration column from the BIMXtra schedule contains one of the text fields below:
1. Day equals "Day"
2. Month equals "Month"
ExternalSystem (COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".

ExtObject (COBie default value): Reference column from the IFC type picklist, based on schedule type. Please see lookup list below:

Schedule Name	Grouping	IFC ObjType Value
Builderswork	Architectural	IfcOpeningElement
Ceiling	Architectural	IfcCoveringType
Curtain Wall	Architectural	IfcCurtainWallType
Door: Internal	Architectural	IfcDoorStyle
Equipment	Architectural	IfcEquipmentElement
External Doors	Architectural	IfcDoorStyle
External Items	Architectural	IfcBuildingElementProxyType
External Wall	Architectural	IfcWallType
External Window	Architectural	IfcWindowStyle
Furniture, Fixtures and Fittings	Architectural	IfcBuildingElementProxyType
Glazed Screen	Architectural	IfcFurnishingElementType
Rooflight	Architectural	IfcWindowStyle
Room	Architectural	IfcSpaceType
Sanitary Fittings and Appliances	Architectural	IfcSanitaryTerminalType
Signage	Architectural	IfcMemberType
Wall	Architectural	IfcWallType
Window	Architectural	IfcWindowStyle
Control Panel	Controls	IfcCostItem
Damper Actuator	Controls	IfcDamperType
Flow Device	Controls	IfcDistributionFlowElementType
Level Device	Controls	IfcFlowInstrumentType
Lifting Equipment	Controls	IfcBuildingElementProxyType
Moisture Device	Controls	IfcDistributionControlElementType
Odour Control Unit	Controls	IfcBuildingElementProxyType
Operator Workstation	Controls	IfcDistributionControlElementType
Pressure Device	Controls	IfcDistributionControlElementType
Screenings Handling	Controls	IfcBuildingElementProxyType
Signal Interface	Controls	IfcFlowInstrumentType
Temperature Device	Controls	IfcDistributionControlElementType
User Interface	Controls	IfcDistributionControlElementType
Valve Actuator	Controls	IfcValveType
Communication	Electrical	IfcElectricalElement
Containment Fitting	Electrical	IfcCableCarrierFittingType
Containment Length	Electrical	IfcCableSegmentType
DDA Equipment	Electrical	IfcDistributionElementType
Distribution Equipment	Electrical	IfcDistributionElementType
Electrical Capital Plant	Electrical	IfcElectricalElement
External Luminaire	Electrical	IfcLightFixtureType
Final Outlet	Electrical	IfcDistributionControlElementType
Fire and Safety Alarm	Electrical	IfcAlarmType
Lighting Control	Electrical	IfcDistributionControlElementType
Luminaire	Electrical	IfcLightFixtureType
Mechanical Plant Drive	Electrical	IfcDistributionElementType
Protection	Electrical	IfcProtectiveDeviceType
Public Address System	Electrical	IfcElectricApplianceType
Security	Electrical	IfcDistributionElementType
Small Power System	Electrical	IfcDistributionControlElementType
Concrete Roads	External Works	IfcBuildingElementProxyType
Culvert	External Works	IfcBuildingElementProxyType
Drainage Run	External Works	IfcBuildingElementProxyType
Earthworks	External Works	IfcTopologicalRepresentationItem
External Works	External Works	IfcBuildingElementProxyType
Footpath	External Works	IfcBuildingElementProxyType
Gully	External Works	IfcBuildingElementProxyType
Inlet Screen	External Works	IfcBuildingElementProxyType
Manholes	External Works	IfcBuildingElementProxyType
Road	External Works	IfcBuildingElementProxyType
Scaffolding	External Works	IfcBuildingElementProxyType
Service Chambers / Duct Boxes	External Works	IfcBuildingElementProxyType
Service Run	External Works	IfcBuildingElementProxyType
Slope Stability Works	External Works	IfcBuildingElementProxyType
Sprayed Concrete	External Works	IfcBuildingElementProxyType
Catchpits	External Works	IfcBuildingElementProxyType
Detector Loop	External Works	IfcBuildingElementProxyType
Drainage Runs	External Works	IfcBuildingElementProxyType
Emergency Telecom Equipment	External Works	IfcBuildingElementProxyType
Fencing and Barriers	External Works	IfcBuildingElementProxyType
Kerbs	External Works	IfcBuildingElementProxyType
Linear Distribution Equipment	External Works	IfcBuildingElementProxyType
Road Earthworks	External Works	IfcBuildingElementProxyType
Road Layers	External Works	IfcBuildingElementProxyType
Road Lighting	External Works	IfcLightFixtureType
Road Markings	External Works	IfcBuildingElementProxyType
Road Restraint	External Works	IfcBuildingElementProxyType
Road Signs	External Works	IfcBuildingElementProxyType
Structural Gantry	External Works	IfcBuildingElementProxyType
Structural Masts	External Works	IfcBuildingElementProxyType
Structural Parapets	External Works	IfcBuildingElementProxyType
Technology Sign and Signal	External Works	IfcBuildingElementProxyType
Traffic Management	External Works	IfcBuildingElementProxyType
Demolitions & Abnormals	Facilitating Works	IfcBuildingElementProxyType
Site Establishment	Facilitating Works	IfcBuildingElementProxyType
Temporary Works	Facilitating Works	IfcBuildingElementProxyType
Ceiling Finishes	Finishes	IfcCoveringType
Coving Finishes	Finishes	IfcCoveringType
Floor Finishes	Finishes	IfcCoveringType
Skirting Finishes	Finishes	IfcCoveringType
Wall Finishes	Finishes	IfcCoveringType
Construction Navigation Points	HSE	IfcBuildingElementProxyType
Design Navigation Points	HSE	IfcBuildingElementProxyType
Environmental Hazard Markers	HSE	IfcBuildingElementProxyType
Environmental Markers	HSE	IfcBuildingElementProxyType
Exclusion Zones	HSE	IfcBuildingElementProxyType
H&S Hazard Markers	HSE	IfcBuildingElementProxyType
Key Hazard Markers	HSE	IfcBuildingElementProxyType
Plant or Equipment	HSE	IfcBuildingElementProxyType
Work Zone Equipment	HSE	IfcBuildingElementProxyType
Actuated Damper	HVAC Components	IfcDamperType
Air Handling Unit	HVAC Components	IfcUnitaryEquipmentType
Air Volume Control Device	HVAC Components	IfcFlowControllerType
Attenuator	HVAC Components	IfcDuctSilencerType
Blowers	HVAC Components	IfcBuildingElementProxyType
Boiler	HVAC Components	IfcBuildingElementProxyType
CHP	HVAC Components	IfcBuildingElementProxyType
Cooling Coil	HVAC Components	IfcCoilType
Ductwork Fitting	HVAC Components	IfcDuctFittingType
Ductwork Insulation	HVAC Components	IfcDuctSegmentType
Ductwork Length	HVAC Components	IfcDuctSegmentType
Ductwork Termination	HVAC Components	IfcAirTerminalType
Exhaust Stack	HVAC Components	IfcBuildingElementProxyType
Fan	HVAC Components	IfcFanType
Fan Coil and Induction Unit	HVAC Components	IfcCoilType
Filter (HVAC)	HVAC Components	IfcFilterType
Fire and Smoke Damper	HVAC Components	IfcDamperType
Flow Grid	HVAC Components	IfcDuctFittingType
Heat Transfer Equipment	HVAC Components	IfcEnergyConversionDeviceType
Heating Coil	HVAC Components	IfcCoilType
Humidifier	HVAC Components	IfcHumidifierType
HVAC Capital Plant	HVAC Components	IfcUnitaryEquipmentType
HVAC Parameter Gauge	HVAC Components	IfcProduct
Manual Damper	HVAC Components	IfcDamperType
Plenum Box	HVAC Components	IfcAirTerminalBoxType
Supply and Extract Air Terminal	HVAC Components	IfcAirTerminalType
Commercial Manual Components	Manual Components	IfcCostItem
Design Manual Components	Manual Components	IfcBuildingElementProxyType
Unmapped Components	Other	IfcBuildingElementProxyType
Actuated Valve Body	Pipework Components	IfcValveType
Ancillaries	Pipework Components	IfcPipeFittingType
Chilled Beam	Pipework Components	IfcCooledBeamType
Condensate Pot	Pipework Components	IfcBuildingElementProxyType
Expansion Equipment	Pipework Components	IfcEvaporatorType
Filter (Pipe)	Pipework Components	IfcFilterType
FST PST Tank	Pipework Components	IfcFootingType
Heat Emitter	Pipework Components	IfcSpaceHeaterType
Heat Exchanger	Pipework Components	IfcHeatExchangerType
Manual Valve	Pipework Components	IfcValveType
Mixers	Pipework Components	IfcBuildingElementProxyType
Penstocks & Stop Logs	Pipework Components	IfcBuildingElementProxyType
Pipework Capital Plant	Pipework Components	IfcUnitaryEquipmentType
Pipework Fitting	Pipework Components	IfcPipeFittingType
Pipework Insulation	Pipework Components	IfcPipeSegmentType
Pipework Length	Pipework Components	IfcPipeSegmentType
Pipework Parameter Gauge	Pipework Components	IfcProduct
Pressurisation Equipment	Pipework Components	IfcUnitaryEquipmentType
Process Valve	Pipework Components	IfcValveType
Pump	Pipework Components	IfcPumpType
Self Acting Valve	Pipework Components	IfcValveType
Tank and Pressure Vessel	Pipework Components	IfcTankType
Termination	Pipework Components	IfcPipeFittingType
Valve	Pipework Components	IfcValveType
Elevated Slabs	Substructure	IfcSlab
Ground Bearing Slabs	Substructure	IfcWallType
Pile Foundations	Substructure	IfcPileType
Slab and Topping	Substructure	IfcSlabType
Anchors	Superstructure	IfcBuildingElementProxyType
Bridge Structural Element	Superstructure	IfcBeamType
Bridge Survey Defect	Superstructure	IfcBuildingElementProxyType
Embedded Retaining Wall	Superstructure	IfcWallType
Foundations	Superstructure	IfcBuildingElementProxyType
Gravity Retaining Wall	Superstructure	IfcWindowStyle
Insitu Beams	Superstructure	IfcBuildingElementProxyType
Insitu Columns	Superstructure	IfcBuildingElementProxyType
Insitu Walls	Superstructure	IfcBuildingElementProxyType
Precast Concrete Elements (manual)	Superstructure	IfcBuildingElementProxyType
Railing	Superstructure	IfcRailingType
Rebar	Superstructure	IfcReinforcingElement
Roofing	Superstructure	IfcRoofType
Secondary Steelwork	Superstructure	IfcBeamType
Stair	Superstructure	IfcStair
Structural Columns	Superstructure	IfcColumnType
Structural Frame	Superstructure	IfcBeamType
Structural Panel	Superstructure	IfcBuildingElementProxyType
Structural Precast Elements	Superstructure	IfcBeamType
Structural Wall	Superstructure	IfcWallType

ExtIdentifier (System Parameter): Populated with the Object ID from BIMXtra.

Optional Fields:

ReplacementCost (Schedule Parameter): Populated with the ReplacementCost column values from the selected schedules.
ExpectedLife (Schedule Parameter): Populated with the ExpectedLife column values from the selected schedules or n/a if the value is null/blank.
DurationUnit (COBie default value): Defaults to "Year".
WarrantyDescription (Schedule Parameter): Populated with the WarrantyDescription column values from the selected schedules.
NominalLength (Schedule Parameter): Populated with the Length column values from the selected schedules.
NominalWidth (Schedule Parameter): Populated with the Width column values from the selected schedules.
NominalHeight (Schedule Parameter): Populated with the Height column values from the selected schedules.
ModelReference (Schedule Parameter): Populated with the manufacturerTypeRef column values from the selected schedules.
Shape (COBie default value): Defaults to "n/a".
Size (COBie default value): Defaults to "n/a".
Color (COBie default value): Defaults to "n/a".
Finish (COBie default value): Defaults to "n/a".
Grade (COBie default value): Defaults to "n/a".
Material (Schedule Parameter): Populated with the Material column values from the selected schedules.
Constituents (COBie default value): Defaults to "n/a".
Features (COBie default value): Defaults to "n/a".
AccessibilityPerformance (COBie default value): Defaults to "n/a".
CodePerformance (COBie default value): Defaults to "n/a".
SustainabilityPerformance (COBie default value): Defaults to "n/a".

Component tab

Information in the Component tab is based on data held across all selected schedules in BIMXtra.

Required & Reference Fields

Name (Schedule Parameter): Concatenation of the Schedule name, name column & Object ID system value.
CreateBy (System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn (System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.
TypeName (System Parameter): To match the Type tab, this populates with the concatenated values of the Schedule name and Object name columns from the selected schedules.
Space: To match the Space Tab, this populates with the value of the Room/Space Number column value from the selected schedules.
Description: The concatenation of the Schedule name, Object name & Object ID column values from the selected schedules.
ExternalSystem: As BIMXtra generates this COBie spreadsheet, the value is defaulted to "Clearbox: BIMXtra".

ExtObject: Reference column from the IFC picklist, based on schedule type. Please see lookup list below:

Schedule Name	Grouping	Ifc objComponent Value
Builderswork	Architectural	IfcOpeningElement
Ceiling	Architectural	IfcCovering
Curtain Wall	Architectural	IfcCurtainWall
Door: Internal	Architectural	IfcDoor
Equipment	Architectural	IfcEquipmentElement
External Doors	Architectural	IfcDoor
External Items	Architectural	IfcBuildingElementProxy
External Wall	Architectural	IfcWall
External Window	Architectural	IfcWindow
Furniture, Fixtures and Fittings	Architectural	IfcBuildingElementProxy
Glazed Screen	Architectural	IfcFurnishingElement
Rooflight	Architectural	IfcWindow
Room	Architectural	ifcSpace
Sanitary Fittings and Appliances	Architectural	IfcFlowTerminal
Signage	Architectural	IfcMember
Wall	Architectural	IfcWall
Window	Architectural	IfcWindow
Control Panel	Controls	IfcCostItem
Damper Actuator	Controls	IfcFlowController
Flow Device	Controls	IfcDistributionFlowElement
Level Device	Controls	IfcProduct
Lifting Equipment	Controls	IfcBuildingElementProxy
Moisture Device	Controls	IfcDistributionControlElement
Odour Control Unit	Controls	IfcBuildingElementProxy
Operator Workstation	Controls	IfcDistributionControlElement
Pressure Device	Controls	IfcDistributionControlElement
Screenings Handling	Controls	IfcBuildingElementProxy
Signal Interface	Controls	IfcProduct
Temperature Device	Controls	IfcDistributionControlElement
User Interface	Controls	IfcDistributionControlElement
Valve Actuator	Controls	IfcFlowController
Communication	Electrical	IfcElectricalElement
Containment Fitting	Electrical	IfcFlowFitting
Containment Length	Electrical	IfcFlowSegment
DDA Equipment	Electrical	IfcDistributionElement
Distribution Equipment	Electrical	IfcDistributionElement
Electrical Capital Plant	Electrical	IfcElectricalElement
External Luminaire	Electrical	IfcFlowTerminal
Final Outlet	Electrical	IfcDistributionControlElement
Fire and Safety Alarm	Electrical	IfcDistributionControlElement
Lighting Control	Electrical	IfcDistributionControlElement
Luminaire	Electrical	IfcFlowTerminal
Mechanical Plant Drive	Electrical	IfcDistributionElement
Protection	Electrical	IfcFlowController
Public Address System	Electrical	IfcFlowTerminal
Security	Electrical	IfcDistributionElement
Small Power System	Electrical	IfcDistributionControlElement
Concrete Roads	External Works	IfcBuildingElementProxy
Culvert	External Works	IfcBuildingElementProxy
Drainage Run	External Works	IfcBuildingElementProxy
Earthworks	External Works	IfcTopologyRepresentation
External Works	External Works	IfcBuildingElementProxy
Footpath	External Works	IfcBuildingElementProxy
Gully	External Works	IfcBuildingElementProxy
Inlet Screen	External Works	IfcBuildingElementProxy
Manholes	External Works	IfcBuildingElementProxy
Road	External Works	IfcBuildingElementProxy
Scaffolding	External Works	IfcBuildingElementProxy
Service Chambers / Duct Boxes	External Works	IfcBuildingElementProxy
Service Run	External Works	IfcBuildingElementProxy
Slope Stability Works	External Works	IfcBuildingElementProxy
Sprayed Concrete	External Works	IfcBuildingElementProxy
Catchpits	External Works	IfcBuildingElementProxy
Detector Loop	External Works	IfcBuildingElementProxy
Drainage Runs	External Works	IfcBuildingElementProxy
Emergency Telecom Equipment	External Works	IfcBuildingElementProxy
Fencing and Barriers	External Works	IfcBuildingElementProxy
Kerbs	External Works	IfcBuildingElementProxy
Linear Distribution Equipment	External Works	IfcBuildingElementProxy
Road Earthworks	External Works	IfcBuildingElementProxy
Road Layers	External Works	IfcBuildingElementProxy
Road Lighting	External Works	IfcFlowTerminal
Road Markings	External Works	IfcBuildingElementProxy
Road Restraint	External Works	IfcBuildingElementProxy
Road Signs	External Works	IfcBuildingElementProxy
Structural Gantry	External Works	IfcBuildingElementProxy
Structural Masts	External Works	IfcBuildingElementProxy
Structural Parapets	External Works	IfcBuildingElementProxy
Technology Sign and Signal	External Works	IfcBuildingElementProxy
Traffic Management	External Works	IfcBuildingElementProxy
Demolitions & Abnormals	Facilitating Works	IfcBuildingElementProxy
Site Establishment	Facilitating Works	IfcBuildingElementProxy
Temporary Works	Facilitating Works	IfcBuildingElementProxy
Ceiling Finishes	Finishes	IfcCovering
Coving Finishes	Finishes	IfcCovering
Floor Finishes	Finishes	IfcCovering
Skirting Finishes	Finishes	IfcCovering
Wall Finishes	Finishes	IfcCovering
Construction Navigation Points	HSE	IfcBuildingElementProxy
Design Navigation Points	HSE	IfcBuildingElementProxy
Environmental Hazard Markers	HSE	IfcBuildingElementProxy
Environmental Markers	HSE	IfcBuildingElementProxy
Exclusion Zones	HSE	IfcBuildingElementProxy
H&S Hazard Markers	HSE	IfcBuildingElementProxy
Key Hazard Markers	HSE	IfcBuildingElementProxy
Plant or Equipment	HSE	IfcBuildingElementProxy
Work Zone Equipment	HSE	IfcBuildingElementProxy
Actuated Damper	HVAC Components	IfcFlowController
Air Handling Unit	HVAC Components	IfcEnergyConversionDevice
Air Volume Control Device	HVAC Components	IfcFlowController
Attenuator	HVAC Components	IfcFlowTreatmentDevice
Blowers	HVAC Components	IfcBuildingElementProxy
Boiler	HVAC Components	IfcBuildingElementProxy
CHP	HVAC Components	IfcBuildingElementProxy
Cooling Coil	HVAC Components	IfcEnergyConversionDevice
Ductwork Fitting	HVAC Components	IfcFlowFitting
Ductwork Insulation	HVAC Components	IfcFlowSegment
Ductwork Length	HVAC Components	IfcFlowSegment
Ductwork Termination	HVAC Components	IfcFlowTerminal
Exhaust Stack	HVAC Components	IfcBuildingElementProxy
Fan	HVAC Components	IfcFlowMovingDevice
Fan Coil and Induction Unit	HVAC Components	IfcEnergyConversionDevice
Filter (HVAC)	HVAC Components	IfcTreatmentDevice
Fire and Smoke Damper	HVAC Components	IfcFlowController
Flow Grid	HVAC Components	IfcFlowFitting
Heat Transfer Equipment	HVAC Components	IfcEnergyConversionDevice
Heating Coil	HVAC Components	IfcEnergyConversionDevice
Humidifier	HVAC Components	IfcEnergyConversionDevice
HVAC Capital Plant	HVAC Components	IfcEnergyConversionDevice
HVAC Parameter Gauge	HVAC Components	IfcFlowInstrumentType
Manual Damper	HVAC Components	IfcFlowController
Plenum Box	HVAC Components	IfcFlowController
Supply and Extract Air Terminal	HVAC Components	IfcFlowTerminal
Commercial Manual Components	Manual Components	IfcCostItem
Design Manual Components	Manual Components	IfcBuildingElementProxy
Unmapped Components	Other	IfcBuildingElementProxy
Actuated Valve Body	Pipework Components	IfcFlowController
Ancillaries	Pipework Components	IfcFlowFitting
Chilled Beam	Pipework Components	IfcEnergyConversionDevice
Condensate Pot	Pipework Components	IfcBuildingElementProxy
Expansion Equipment	Pipework Components	IfcEnergyConversionDevice
Filter (Pipe)	Pipework Components	IfcTreatmentDevice
FST PST Tank	Pipework Components	IfcFooting
Heat Emitter	Pipework Components	IfcEnergyConversionDevice
Heat Exchanger	Pipework Components	IfcEnergyConversionDevice
Manual Valve	Pipework Components	IfcFlowController
Mixers	Pipework Components	IfcBuildingElementProxy
Penstocks & Stop Logs	Pipework Components	IfcBuildingElementProxy
Pipework Capital Plant	Pipework Components	IfcEnergyConversionDevice
Pipework Fitting	Pipework Components	IfcFlowFitting
Pipework Insulation	Pipework Components	IfcFlowSegment
Pipework Length	Pipework Components	IfcFlowSegment
Pipework Parameter Gauge	Pipework Components	IfcFlowInstrumentType
Pressurisation Equipment	Pipework Components	IfcEnergyConversionDevice
Process Valve	Pipework Components	IfcFlowController
Pump	Pipework Components	IfcFlowMovingDevice
Self Acting Valve	Pipework Components	IfcFlowController
Tank and Pressure Vessel	Pipework Components	IfcFlowStorageDevice
Termination	Pipework Components	IfcFlowFitting
Valve	Pipework Components	IfcFlowController
Elevated Slabs	Substructure	IfcSlabType
Ground Bearing Slabs	Substructure	IfcWall
Pile Foundations	Substructure	IfcPile
Slab and Topping	Substructure	IfcSlab
Anchors	Superstructure	IfcBuildingElementProxy
Bridge Structural Element	Superstructure	IfcBeam
Bridge Survey Defect	Superstructure	IfcBuildingElementProxy
Embedded Retaining Wall	Superstructure	IfcWall
Foundations	Superstructure	IfcBuildingElementProxy
Gravity Retaining Wall	Superstructure	IfcWindow
Insitu Beams	Superstructure	IfcBuildingElementProxy
Insitu Columns	Superstructure	IfcBuildingElementProxy
Insitu Walls	Superstructure	IfcBuildingElementProxy
Precast Concrete Elements (manual)	Superstructure	IfcBuildingElementProxy
Railing	Superstructure	IfcRailing
Rebar	Superstructure	IfcReinforcingBar
Roofing	Superstructure	IfcRoof
Secondary Steelwork	Superstructure	IfcBeam
Stair	Superstructure	IfcStair
Structural Columns	Superstructure	IfcColumn
Structural Frame	Superstructure	IfcBeam
Structural Panel	Superstructure	IfcBuildingElementProxy
Structural Precast Elements	Superstructure	IfcBeam
Structural Wall	Superstructure	IfcWall

ExtIdentifier(System Parameter): This populated with the CAD Handle of the BIMXtra object.

Optional Fields:

SerialNumber(Schedule Parameter): Populated with the Material column values from the selected schedules.
InstallationDate(COBie default value): This defaults to "n/a".
WarrantyStartDate(Schedule Parameter): Populated with the WarrantyStartDate column values from the selected schedules.
TagNumber(Schedule Parameter): Populated with the Number column values from the selected schedules.
BarCode(Schedule Parameter): Populated with the AssetCode column values from the selected schedules.

System tab

Information in the System tab is based on data held across all selected schedules in BIMXtra which have system column values populated.

Required & Reference Fields

Name(Schedule Parameter): Populated with the System column values from the selected schedules.
CreateBy(System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn(System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.
Category(COBie default value): Reference column from the Uniclass 2015 picklist, based on schedule type. Please see table from Type Tab.
ComponentNames(Schedule Value): The concatenation of the Schedule name, Object Name column & Object ID values from the selected schedules. This is to match the Name column from the Component tab.
ExternalSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value is defaulted to "Clearbox: BIMXtra".
ExtObject(COBie default value): Reference column from the COBie picklist. Defaults to "IfcSystem".
ExtIdentifier(COBie default value): Defaults to "n/a".

Optional Fields:

Description: Populated with the System column values from the selected schedules.

Assembly Tab

Information contained in the Assembly tab is based on the data related to compound objects in the selected schedules. A compound object is a system family object made up of multiple components. An example of this is a wall or slab which is made of different layers of materials within a single object.

Required & Reference Fields

Name(Schedule Parameter): The concatenation of the Schedule name, Object Name & GUID column values from the selected schedules.
CreatedBy(System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn(System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.
AssemblyType(COBie default value): Defaults to "Layer".
SheetName(COBie default value): Defaults to "Component".
ParentName(Schedule Parameter): The concatenation of the Schedule name, Object Name column & Object ID values from the selected schedules. This is to match the Name column from the Component tab.
ChildNames(Schedule Parameter): The concatenation of the Material column & Object ID values from the selected schedules.
ExternalSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject(COBie default value): Reference column from the IFC picklist, based on schedule type. Please see lookup list in the component tab section.
ExtIdentifier(System Parameter): Populated with the IFC GUID for the compound element.

Optional Fields:

Description: Populated with material column values from the selected schedules.

Connection Tab

Information contained in the Connection tab is based on data held in the schedules you select on export. The full list is below:

HVAC Actuated Damper
Pipework Actuated Valve Body
HVAC Air Handling Unit
HVAC Air Volume Control Device
Pipework Ancillaries
HVAC Attenuator
Blower
Boiler
Pipework Chilled Beam
CHP
Electrical Communication
Condensate Pot
Control Panel
HVAC Cooling Coil
Control Damper Actuator
Electrical DDA Equipment
Electrical Distribution Equipment
Electrical Capital Plant
Exhaust Stack
Pipework Expansion Equipment
Luminaire External
HVAC Fan
HVAC Fan Coil and Induction Unit
HVAC Filter
Pipework Filter
Electrical Final Outlet
Electrical Fire And Safety Alarm System
HVAC Fire and Smoke Damper
Control Flow Device
HVAC Flow Grid
FST PST Tank
Pipework Heat Emitter
Pipework Heat Exchanger
HVAC Heat Transfer Equipment
HVAC Heating Coil
HVAC Humidifier
HVAC Capital Plant-
HVAC Parameter Gauge
Control Level Device
Lifting Equipment
Electrical Lighting
Luminaire
HVAC Manual Damper
Pipework Manual Valve
Electrical Mechanical Plant Drive
Mixers
ControlMoistureDevice
Odour_Control_Unit
ControlOperatorWorkstation
Penstocks_And_Stop_Logs
PipeworkCapitalPlant
PipeworkParameterGauge
HVACPlenumBox
ControlPressureDevice
PipeworkPressurisationEquipment
PipeworkProcessValve
ElectricalProtection
ElectricalPublicAddressSystem
PipeworkPump
Screenings_Handling
SecondarySteelwork
ElectricalSecurity
PipeworkSelfActingValve
ControlSignalInterface
SmallPowerSystem
StructuralFrame
HVACSupplyandExtractAirTerminal
PipeworkTankandPressureVessel
ControlTemperatureDevice
PipeworkTermination
ControlUserInterface
PipeworkValve
ControlValveActuator

Required & Reference Fields

Name(Schedule Parameter): The concatenation of the System & Object Name column values from the selected and compatible schedules.
CreatedBy(System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn(System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.

ConnectionType(System Parameter): Reference column from the connection type picklist base on schedule type. Please see lookup list below:

Schedule Name	Grouping	COBie Connection Type
Control Panel	Controls	Control
Damper Actuator	Controls	Control
Flow Device	Controls	Control
Level Device	Controls	Control
Lifting Equipment	Controls	Control
Moisture Device	Controls	Control
Odour Control Unit	Controls	Control
Operator Workstation	Controls	Control
Pressure Device	Controls	Control
Screenings Handling	Controls	Control
Signal Interface	Controls	Control
Temperature Device	Controls	Control
User Interface	Controls	Control
Valve Actuator	Controls	Control
Communication	Electrical	Data
Containment Fitting	Electrical	n/a
Containment Length	Electrical	n/a
DDA Equipment	Electrical	Data
Distribution Equipment	Electrical	Data
Electrical Capital Plant	Electrical	Data
External Luminaire	Electrical	Data
Final Outlet	Electrical	Data
Fire and Safety Alarm	Electrical	Data
Lighting Control	Electrical	Data
Luminaire	Electrical	Data
Mechanical Plant Drive	Electrical	Data
Protection	Electrical	Data
Public Address System	Electrical	Data
Security	Electrical	Data
Small Power System	Electrical	Data
Actuated Damper	HVAC Components	Control
Air Handling Unit	HVAC Components	Control
Air Volume Control Device	HVAC Components	Control
Attenuator	HVAC Components	Control
Blowers	HVAC Components	Control
Boiler	HVAC Components	Control
CHP	HVAC Components	Control
Cooling Coil	HVAC Components	Control
Ductwork Fitting	HVAC Components	n/a
Ductwork Insulation	HVAC Components	n/a
Ductwork Length	HVAC Components	n/a
Ductwork Termination	HVAC Components	n/a
Exhaust Stack	HVAC Components	Return
Fan	HVAC Components	Control
Fan Coil and Induction Unit	HVAC Components	Control
Filter (HVAC)	HVAC Components	Control
Fire and Smoke Damper	HVAC Components	Control
Flow Grid	HVAC Components	Control
Heat Transfer Equipment	HVAC Components	Control
Heating Coil	HVAC Components	Control
Humidifier	HVAC Components	Control
HVAC Capital Plant	HVAC Components	Control
HVAC Parameter Gauge	HVAC Components	Control
Manual Damper	HVAC Components	Control
Plenum Box	HVAC Components	Supply / Return / Flow
Supply and Extract Air Terminal	HVAC Components	Supply / Return / Flow
Actuated Valve Body	Pipework Components	Flow
Ancillaries	Pipework Components	Flow
Chilled Beam	Pipework Components	Flow
Condensate Pot	Pipework Components	Flow
Expansion Equipment	Pipework Components	Flow
Filter (Pipe)	Pipework Components	Flow
FST PST Tank	Pipework Components	Flow
Heat Emitter	Pipework Components	Flow
Heat Exchanger	Pipework Components	Flow
Manual Valve	Pipework Components	Flow
Mixers	Pipework Components	Flow
Penstocks & Stop Logs	Pipework Components	Flow
Pipework Capital Plant	Pipework Components	Flow
Pipework Fitting	Pipework Components	n/a
Pipework Insulation	Pipework Components	n/a
Pipework Length	Pipework Components	n/a
Pipework Parameter Gauge	Pipework Components	Flow
Pressurisation Equipment	Pipework Components	Flow
Process Valve	Pipework Components	Flow
Pump	Pipework Components	Flow
Self Acting Valve	Pipework Components	Flow
Tank and Pressure Vessel	Pipework Components	Flow
Termination	Pipework Components	Flow
Valve	Pipework Components	Flow

SheetName(COBie default value): Defaults to "Component".
RowName1(Schedule Parameter): The concatenation of the Schedule name, Object Name & Object ID column values from the selected schedules. This is to match the Name column from the Component Tab.
RowName2(Schedule Parameter): The concatenation of the System & Number column values from the selected schedules.
RealizingElement(COBie default value): Defaults to "n/a".
PortName1(Schedule Parameter): Populated with the value of the System column values from the selected schedules.
PortName2(Schedule Parameter): Populated with the value of the System column values from the selected schedules.
ExternalSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value is defaulted to "Clearbox: BIMXtra".
ExtObject(COBie default value): Reference column from the IFC picklist base on schedule type. Please see Lookup list in the component tab section.
ExtIdentifier(System Parameter): Populated with the IFC GUID for the compound element.

Optional Fields:

Description(Schedule Parameter): Populated with the value of the Object Name column from the selected and compatible schedules.

Spare tab

BIMXtra does not currently support population of this tab from the BIMXtra Project Data Manager.

Resource tab

BIMXtra does not currently support population of this tab from the BIMXtra Project Data Manager.

Job tab

Information contained in the Job tab is based on data held across all selected schedules in BIMXtra which have populated Maintenance Details column values.

Required & Reference Fields

Name(Schedule Parameter): Populated with the value of the MaintenanceDetails column from the selected schedules.
CreatedBy(System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn(System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.
Category(COBie default value): Defaults to "Operation".
Status(COBie default value): Defaults to "Not Yet Started".
TypeName(Schedule Parameter): To match the Type Tab, this populates with the concatenation of the Schedule name & Object Name column values from the selected schedules.
Description(Schedule Parameter): The concatenation of the MaintenanceDetails & Object Name column values from the selected schedules.
Duration(COBie default value): Defaults to "minute".
Start(Schedule Parameter): This populates with the value of the MaintenanceStartDate column from the selected schedules.
TaskStartUnit(COBie default value): Defaults to "Date".
Frequency(Schedule Parameter): This populates with the value of the MaintenanceFrequency column from the selected schedules.
FrequencyUnit(Schedule Parameter): This populates with the value of the MaintenanceFrequencyType column from the selected schedules.
ExternalSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject(COBie default value): Defaults to "IfcTask".
ExtIdentifier(COBie default value): Defaults to "blank".
TaskNumber(COBie default value): Defaults to "n/a".
Priors(COBie default value): Defaults to "blank".
ResourceNames(COBie default value): Defaults to "blank".

Impact Tab

Information in the Impact tab is based on data held across all selected schedules in BIMXtra which have populated Replacement Cost column values.

Required & Reference Fields

Name(Schedule Parameter): Populated with the value of the Name column from the selected schedules.
CreatedBy(System Parameter): Populated with the email address of the user who first imported the value into the BIMXtra schedules.
CreatedOn(System Parameter): Shows the date at which the object name reference first appeared in the selected schedule.
ImpactType(COBie default value): Defaults to "Cost".
ImpactStage(COBie default value): Defaults to "Replacement".
SheetName(COBie default value): Defaults to "Component".
RowName(Schedule Parameter): The concatenation of the Schedule name, Object Name column & Object ID values from the selected schedules. This is to match the Name column from the Component Tab.
Value(Schedule Parameter): This populates with the value of the ReplacementCost column value from the selected schedules.
ImpactUnit(COBie default value): Defaults to "Currency".
ExtSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value is defaulted to "Clearbox: BIMXtra".
ExtObject(COBie default value): Defaults to "IfcPropertySet".
ExtIdentifier(System Parameter): Populated with the Object ID from BIMXtra.

Optional Fields:

LeadInTime(COBie default value): Defaults to "n/a".
Duration(COBie default value): Defaults to "n/a".
LeadOutTime(COBie default value): Defaults to "n/a".
Description(COBie default value): Defaults to "Estimated replacement cost".

Document tab

Information in the Document tab is based on data held across the folders listed below, where link documents are stored in the DMS:

BIMXtra Document Folders	Discipline	BIMXtra Location	COBie Document Type	StageType
As-Built Information	FM	DMS\Published\Z. System Outputs\FM\As-Built Information	Manufacturer Instructions	S7- Aim Authorization
Commissioning Data	FM	DMS\Published\Z. System Outputs\FM\Commissioning Data	Test Reports	S7- Aim Authorization
FaultReporting	FM	DMS\Published\Z. System Outputs\FM\FaultReporting	Test Reports	S7- Aim Authorization
Guarentees / Warranties	FM	DMS\Published\Z. System Outputs\FM\Guarentees / Warranties	Certificates	S7- Aim Authorization
Installation Details	FM	DMS\Published\Z. System Outputs\FM\Installation Details	Manufacturer Instructions	S7- Aim Authorization
Installation Instructions	FM	DMS\Published\Z. System Outputs\FM\Installation Instructions	Manufacturer Instructions	S7- Aim Authorization
Maintenance Manual	FM	DMS\Published\Z. System Outputs\FM\Maintenance Manual	Manufacturer Instructions	S7- Aim Authorization
Manufacturers Literature	FM	DMS\Published\Z. System Outputs\FM\Manufacturers Literature	Product Data	S7- Aim Authorization
Operational Instructions	FM	DMS\Published\Z. System Outputs\FM\Operational Instructions	Operation and Maintenance	S7- Aim Authorization
Photos	FM	DMS\Published\Z. System Outputs\FM\Photos	Operation and Maintenance	S7- Aim Authorization
Record Drawings	FM	DMS\Published\Z. System Outputs\FM\Record Drawings	Contract Drawings	S7- Aim Authorization
Regulatory Compliance	FM	DMS\Published\Z. System Outputs\FM\Regulatory Compliance	Operation and Maintenance	S7- Aim Authorization
Safety Risk Assessment	FM	DMS\Published\Z. System Outputs\FM\Safety Risk Assessment	Operation and Maintenance	S7- Aim Authorization
Spare Part Listing	FM	DMS\Published\Z. System Outputs\FM\Spare Part Listing	Operation and Maintenance	S7- Aim Authorization
Specifications	FM	DMS\Published\Z. System Outputs\FM\Specifications	Specifications	S7- Aim Authorization
Supporting Document	FM	DMS\Published\Z. System Outputs\FM\Supporting Document	Operation and Maintenance	S7- Aim Authorization
RFI	RFI	Document Library\System Folders\RFI Attachment	Request for Information	S2- Information
Drawings	Drawing Manager	Document Library\System Folders\Drawings	Shop Drawings	S2- Information
Field BIM Floor Plans	Drawing Manager	Document Library\System Folders\Field BIM Floor Plans	Shop Drawings	S2- Information
Forms	Forms	Document Library\System Folders\Forms	Manufacturer Field Reports	S2- Information
Insight Visualisation	CBX	Document Library\System Folders\Insight Visualisation	Design Data	S2- Information

Required & Reference Fields

Name(System Parameter): Populated with the filename of the document store in the O&M/FM System folders which are linked to objects.
CreatedBy(System Parameter): Populated with the email address of the user who first uploaded the document into BIMXtra.
CreatedOn(System Parameter): Shows the date at which the document was uploaded to BIMXtra.
Category(System Parameter): Populated by the COBie Document Type, as referenced in the table above, based on the file location within BIMXtra.
ApprovalBy(COBie default value): Defaults to "Information Only".
Stage(System Parameter): This is populated by the Stage Type, as referenced in the table above, based on the file location within BIMXtra.
SheetName(COBie default value): Defaults to "Type".
RowName(Schedule Parameter): To match the Type tab, this populates with the concatenated values of the Schedule name & Object Name columns from the selected schedules.
Directory(System Parameter): Populated with the file location from within BIMXtra.
File(System Parameter): Populated with the filename and extension of the linked file, as stored in the BIMXtra DMS.
ExtSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject(COBie default value): Defaults to "IfcDocumentReference".
ExtIdentifier(System Parameter): Populated with the document revision stored against the filename in the BIMXtra DMS.

Optional Fields

Description(System Parameter): The concatenation of the file location and filename, including the extension of the linked file, as stored in the BIMXtra DMS.
Reference(System Parameter): Populated with the document revision stored against the filename in the BIMXtra DMS.

Attribute tab

Information contained in the Attribute tab is based on data held across all selected schedules in BIMXtra which are populated with column values.

Required & Reference Fields

Name(System Parameter): This is populated with the column property UserFriendlyName (or System Name property if UserFriendlyName is Blank).
CreatedBy(System Parameter): Populated with the email address of the user who last updated the schedule either via a model import or an Excel upload.
CreatedOn(System Parameter): Shows the date at which the schedule was last updated.
Category(COBie default value): Defaults to "Product Data".
SheetName(COBie default value): Defaults to "Component".
RowName(Schedule Parameter): The concatenation of the Schedule name, Object Name column & Object ID values from the selected schedules. This is to match the Name column from the Component Tab.
Value(System Parameter): Populated with the Object Attribute/Parameter Value (Based on Populated Cells only) from the select BIMXtra schedules.
Unit(System Parameter): Populated by the column property value for "HdrLevel0".
ExtSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject(COBie default value): Defaults to "IfcPropertySingleValue".
ExtIdentifier(COBie default value): Defaults to "n/a".

Optional Fields:

Description(System Parameter):The concatenation of the schedule column properties HdrLevel3, HdrLevel2, HdrLevel1 and HdrLevel0.
AllowedValues(COBie default value): Defaults to "n/a".

Coordinate tab

Information contained in the Coordinate tab is based on the Object position held across all selected schedules in BIMXtra.

Required & Reference Fields

Name(Schedule Parameter): The concatenation of the Object name & Object ID column values from the selected schedules.
CreatedBy(System Parameter): Populated with the email address of the user who last imported the model file into BIMXtra.
CreatedOn(System Parameter): Shows the date at which the model was last imported.
Category(COBie default value): Defaults to "Point".
SheetName(COBie default value): Defaults to "Component".
RowName(Schedule Parameter): The concatenation of the Schedule name, Object Name column & Object ID values from the selected schedules. This is to match the Name column from the Component tab.
CoordinateXAxis(System Parameter): Populated with the X Axis value of the CAD model, as stored in the CAD Software.
CoordinateYAxis(System Parameter): Populated with the Y Axis value of the CAD model, as stored in the CAD Software.
CoordinateZAxis(System Parameter): Populated with the Z Axis value of the CAD model, as stored in the CAD Software.
ExtSystem(COBie default value): As BIMXtra generates this COBie spreadsheet, the value defaults to "Clearbox: BIMXtra".
ExtObject(COBie default value): Defaults to "IfcCartesianPoint".
ExtIdentifier(System Parameter): Populated with the Object ID from BIMXtra.
ClockwiseRotation(System Parameter): Populated with the Rotation value of the CAD as stored in the CAD Software.
ElevationalRotation(System Parameter): Populated with the Rotation value of the CAD as stored in the CAD Software.
YawRotation(System Parameter): Populated with the Rotation value of the CAD as stored in the CAD Software.

Issue tab

BIMXtra does not currently support population of this tab from the BIMXtra Project Data Manager.