codebook bim data workflow

IntelligentRoom & Asset Data

Management

Capture Manage Validate Report

Coordinates and socialises BIM data during project life cycle from inception to handover

without duplication of data or effort

Over 20 years managing non graphical building data for

projects of all sizes and sectors

• 325,000 Sq. M. • 6 Buildings• 14,000 Rooms • 500,000 Equipment • 27,000 Doors• 100,000 Power Outlets

`

50 Million +

Many peoples BIM datajourney starts here!

Data Management Status?

a

Schedule of Accommodation

Schedule of Fixtures, Fittings

& Equipment

Program

Coordinate Syncronize Validate Report Output

Time

Data

Design BuildEngineering Post Build

BIM Lifecycle

Schedule of Accommodation

Schedule of FFE

ProgramOwner

ArchitectsInterior

Designers

Engineers

Construction

Client

AuthorsOwner Library

Designers Library

Engineers Library

Client Library

Revit Model (s)

Sources

Navisworks

Excel

Access

SQL

Word

PDF

Handwritten

Formats

Photos

Sketch's

RVT

DWG

NVS

DataRooms

FFE

Finishes

Doors

Windows

Services

Project

Revit Model (s)

OutputsRoom Data Sheets

(RDS)COBieESRIXML

AccessSQL

Design BuildEngineering Post Build

BIM Data World

More, more and more meta data

• Rooms• Furniture• Equipment• Finishes• Doors• MEP • Activities• Etc.

Datasets

Model

Floor 1

Floor 2

Floor 3

Floor N

Multiple Models

Floor N

• Architecture• Equipment• MEP• FFE

Multiple Disciplines

Typically a room contains at least 3,000 data items excluding MEP & Doors!

• Room Name• Room Number• Room Description• Room Function• Department Name• Department Number• Floor Number • Building Number• Required Area• Volume• Height - Floor to Floor• Height – Floor to ceiling• Wall Type – North, South, East , West• Wall Colour - North, South, East , West• Floor Coverings• Ceiling Type• Circulation

• Heat • Cooling• Lighting• Lighting Lux• Occupancy• Fire• Adjacencies• Doors• Windows• Power Outlets• Data Outlets• Equipping

Room Data

• Manufacturer• Manufacturer Model

Number• Equipment Code • Fix Height• Location• Group • Classification• Services Required• Purchase Information• Facilities Information • O&M Information

FFE Door MEP Data

Data Mixture

Data Manage - SingleModel

Data Manage - MultipleModels

Data Manage - Assets

Design Validation

Our approach

Capture Manage Validate Report

Schedule of Accommodation

Schedule of FFE

ProgramOwner

ArchitectsInterior

Designers

Engineers

Construction

Client

AuthorsOwner Library

Designers Library

Engineers Library

Client Library

CodeBook Data Model

Revit Model (s)

Sources

Navisworks

Excel

Access

SQL

Word

PDF

Handwritten

Formats

Photos

Sketch's

RVT

DWG

NVS

DataRooms

FFE

Finishes

Doors

Windows

Services

Project

Revit Model (s)

OutputsRoom Data Sheets

COBieESRI

MaximoXML

AccessSQL

Maximo

Coordinate Bi directional Syncronize Validate Report Export

CodeBookData Model

Design BuildEngineering Post Build

Schedule of Accommodation

Schedule of FFE

ProgramOwner

ArchitectsInterior

Designers

Engineers

Construction

Client

Authors Owner Library

Designers Library

Engineers Library

Client Library

CodeBook Data Model

Revit Model (s)

Sources

Navisworks

Excel

Access

SQL

Word

PDF

Handwritten

Formats

Photos

Sketch's

RVT

DWG

NVS

DataRooms

FFE

Finishes

Doors

Windows

Services

Project

Revit Model (s)

OutputsRoom Data Sheets

COBieESRI

MaximoXML

AccessSQL

Maximo

Coordinate Bi directional Syncronize Validate Report Export

CodeBookData Model

Facilities Management

Tool

Design BuildEngineering Post Build Operations

Room Data Collector

Project Room Data ManagerCodebook

Project Data Model

Asset Data Collector

CodeBook Project Server

3rd Party Server

PC Client

Client On Premises Server

Room DataCollector Project Room Data Manager

ReportsWordExcelPDF

C-SheetsCrystal Export

SQLAccess

XMLCOBieESRI

Maximo

FMSystem

CodeBookProject Data

Model

Asset Data Collector

CAD / 3D

Models

ImportWizard

ExcelAccess

SQL

ManualInput

Data Sources

Room & Asset Data Management Tools

API

Architect InteriorDesigners Engineers Construction OwnerClient

PostBuild OperationsPre Design Design Build

Room DataCollector Project Room Data Manager

ReportsWordExcelPDF

C-SheetsCrystal Export

SQLAccess

XMLCOBieESRI

Maximo

FMSystem

CodeBookProject Data

Model

Asset Data Collector

CAD / 3D

Models

ImportWizard

ExcelAccess

SQL

ManualInput

Data Sources

Project Workflow

Stakeholders

API

Exemplar CodeBookWorkflow

Campus

Buildings

Rooms, Spaces, Zones

FixturesFittings

Equipment

Project Overview• School• Hospital• Laboratory • Airport• Sports Arena• Theatre• Mass Transit Station• Prison• University• Hospitality

Client

Architect

Interior Designers

Engineers

Construction

Owner

Generic Data Sources

Create

Best Practice

Consolidating Room Design

Layouts

Consolidating Fixtures, Fittings, Equipment

Identifying the best!

Rooms, Zones, Spaces

Name Number

DescriptionFunction

Dimensions Volumes

FinishesDoors

WindowsServices

LocationActual Number of Each

Schedule of Accommodation

Room Components

FixturesFittings

Equipment

NameDescriptionDimensions

LocationActual Number of

Each

Schedule of FFE

FFE Components

In-house Library

• Excel• Access• SQL• Word• Pdf

CodeBook Library• SQL• Access

RevitRooms

Client’s Library

• Excel• Access• SQL• Word• PDF

Briefing Program

• Excel• Access• SQL• Word• PDF

Schedule of Accommodation

• Excel

Room Data Sources to createSchedule of Accommodation

Schedule of Accommodation

Create Room Templates• Creates a one to many relationship• Typically only between 80 – 100 templates required

depending on complexity of building

Produces CodeBookTemplateLibrary

• Allows multiple instances of same room to managed centrally

• Allows room data to be changed globally from the central library

Templates used to create CodeBook Room Library

• Allows rooms to deviate from templates

Load and Link Rooms in CodeBook to Revit

•CodeBook knows the XYZ coordinates for every room across all models and if it changes

Syncronize CodeBook and RevitCreating Room Library

Room Requirements ChangesAmended CodeBookTemplate and Room

Library

Load and Link Rooms in CodeBook to Revit

Syncronize CodeBook and Revit

Maintaining Room Program

In-house Library• Excel• Access• SQL• Word• PDF

Client’s Library • Excel• Access• SQL• Word• PDF

CodeBook Library • Access• SQL

RevitFamilies

• Either directly imported or data imported via wizard

NavisworksBriefing Program

• Excel• Access• SQL

Schedule of FFE

FFE Data Sourcesto create Scheduleof FFE

Schedule of Equipment

Create CodeBook Equipment Library• Creates one to many relationship• Information for each instance of equipment can

be amended & updated from the central library across multiple models

Manual drag & drop equipment from equipment library in room templates

•Option – Either via Room Data Collector or Project Room Data Manager

Bulk load equipment into room templates

•Option - If Schedule of Equipment includes unique room identifier against each item of equipment

Load and Link Equipment in CodeBook to Revit

•CodeBook knows the XYZ coordinate of each instance of equipment across multiple models

Syncronize CodeBook & RevitCreating EquipmentLibrary, Unions & Assemblies

Create Equipment Unions &

AssembliesPlus

• Standard equipment combinations• Generate complete room FFE standards

FFE Changes

Manual drag and drop equipment from equipment library in room templates

•Option – Either via Room Data Collector or Project Room Data Manager

Bulk load equipment into room templates

•Option - If Schedule of Equipment includes unique room identifier against each item of equipment

Load and Link Equipment in CodeBook to Revit

Syncronize CodeBook and Revit

Maintaining FFEProgram

CodeBookRoom Library CodeBook FFE Library

CodeBookProjectData Model

CodeBook Data Model Schema

Campus Building

Department Floor

Room

Reporting / Auditing / Analysis• Room• Area• FFE• Changes

Flexible, Extensive and Customisable Reports

BIM data journey ends here FM takes over