Skip to main content
Have a personal or library account? Click to login
Linking life cycle BIM data to a facility management system using Revit Dynamo Cover

Linking life cycle BIM data to a facility management system using Revit Dynamo

Organization, Technology and Management in Construction: an International Journal
Volume 14 (2022): Issue 1 (January 2022)
By: ,   and    
Open Access
|Mar 2022
Figures & tables

Figures & Tables

Fig. 1

Research methodology.

Tab. 1

Asset groups and equipment information

Asset groupEquipment nameParentLocation
AHUMAU-1 (Supply Air Handler)Roof
AHUEAU-1 (Exhaust Air Handler)Roof
ERUEnergy Recovery UnitEAU-1Roof
FANSupply FanMAU-1Roof
FANExhaust FanEAU-1Roof
FANF-1Basement—Mech/Elec Rm 7
FANF-2ERURoof
FCUFC-1 through FC-8Main Floor
FCUFC-9Basement
HTRHUH-1Basement—Mech/Elec Rm 7
HTRECH-1ERURoof
HTRECH-2, ECH-3, ECH-4MAU-1Roof
HUDHUMMAU-1Roof
PHWP-1, HWP-2Basement—Mech/Elec Rm 7
PERP-1ERURoof
PCWP-1Basement—Mech/Elec Rm 7
SEPAS-1Basement—Mech/Elec Rm 7
SEPAS-2ERURoof
TNKPET-1Mech/Elec Rm 7
TNKPET-2Roof
EMER-ATSATS-1, ATS-2Basement—Mech. Equip. Rm
EMER-GENEmergency GeneratorBasement—Mech. Equip. Rm
Tab. 2

Common asset attributes for MAU-1 (AHU asset group)

Common attributesCommon attribute valueData source/remarks
ASSET_TAG00441-AHU-RT-0001VT Asset Tag Naming Convention
ASSET_GROUPAHUVT Asset Groups List
DESCRIPTIONMAU-1—MAKEUP AIR HANDLING UNITSHEET M1.2
LOCATION_CODEROOFSHEET M2.6
DATE_PURCHASED
LONG_DESCAIR INTAKE SECTION W/FILTERS (100 PERCENT OUTDOOR AIR HOOD), ENERGY RECOVERY COIL SECTION (GLYCOL LOOP), 24″ ACCESS SECTION, STEAM PREHEAT COIL SECTION, 24″ ACCESS SECTION, CW COIL SECTION, PLENUM SUPPLY FAN, HUMIDIFICATION SECTION FOR DISPERSION MANIFOLD, 48″ PLENUM W/TWO BOTTOM DISCHARGE OPENINGS. OVERALL UNIT DIMENSIONS APPROX. 27′–6″L ′ 7′–10″W ′ 5′–8″H. APPROXIMATE UNIT OPERATING WEIGHT 8,000 LBS; OMNICLASS23: BUILT UP ROOFTOP AIR HANDLING UNITSOMNI CLASS 23
LOCKOUTYSUBMITTAL EAU_MAU_050216—p12
SERIAL_NOK16E36891Bldg. Walkthrough
MANUFACTURE_CODETRANESHEET M1.2
MANU_PART_NUMBERCSAA030UBSUBMITTAL EAU_MAU_050216—p37
PROCEDURE_YNYSUBMITTAL EAU_MAU_050216
PARENT_ASSET_TAGN/A
YEAR_INSTALLED2017
PART12′ 24 2″ Pleated Media MERV 8SUBMITTAL EAU_MAU_050216—p35
QUANTITY3
PART20 ′ 20 2″ Pleated Media MERV 8SUBMITTAL EAU_MAU_050216—p35
QUANTITY8
PARTBX-98 Belt
QUANTITY2
PART12 ′ 24 12″Cartridge 95% MERV 15SUBMITTAL EAU_MAU_050216—p35
QUANTITY3
PART20 ′ 20 12″Cartridge MERV 15SUBMITTAL EAU_MAU_050216—p35
QUANTITY8
WARR_DESC1 YEAR PARTS AND LABOR; 5 YEARS PARTS ONLY for ECONOMIZERSUBMITTAL EAU_MAU_050216—p3, 11
WARR_DATE_FR
WARR_DATE_TO
LOCATIONBLDG441—BASEMENT & MAIN FLOORM2.4, M2.5 AND M2.6
USAGE_FACTOR50, 50
CLASS_STANDARDOMNICLASS, Master FormatOMNI CLASS 23, Master Format 2016
LEVEL_123, 23OMNI CLASS 23, Master Format 2016
LEVEL_233, 74OMNI CLASS 23, Master Format 2016
LEVEL_325, 16OMNI CLASS 23, Master Format 2016
LEVEL_411OMNI CLASS 23, Master Format 2016
LEVEL_513OMNI CLASS 23, Master Format 2016
LEVEL_6
Fig. 2

Allocation of asset properties and attributes in the formatted Excel spreadsheet.

Tab. 3

Specific asset attributes for Air Handler Unit (AHU) asset group

AHU common attributeCommon attribute value (MAU-1)Source/remarks
Bas point addressCMMU1SAFBldg. WALKTHROUGH
Heating sourceBOILERSHEET M1.2
Heating capacity13,500
Total air flow13,330SHEET M1.2
External static pressure1.5SHEET M1.2
Min. outside air
Max. outside air
Cooling sourceCHILLER
Total cooling capacity704.09SUBMITTAL EAU_MAU_050216
Sensible cooling cap455.52SUBMITTAL EAU_MAU_050216
EconomizerY
Economizer type
Total static pressure5.006SUBMITTAL EAU_MAU_050216
TypeRT (Roof Top)SHEET M1.2
Fig. 3

Example of the “Parts” tab.

Fig. 4

Summary of the proposed Dynamo workflow.

Fig. 5

Step 1: Identifying model elements.

Tab. 4

Parameter types and corresponding input list

SheetParameter name (input)List used as input
List.FilterByBoolMaskFamilyInstance.Type
GeneralASSET_TAG*X
ASSET_GROUPX
DESCRIPTIONX
LOCATION_CODEX
DATE_PURCHASEDX
LONG_DESCX
SERIAL_NOX
LOCKOUTX
MANU_PART_NUMBERX
MANUFACTURE_CODEX
PROCEDURE_YNX
PARENT_ASSET_TAGX
YEAR_INSTALLEDX
ClassificationASSET_TAG*X
CLASS_STANDARDX
LEVEL_1X
LEVEL_2X
LEVEL_3X
LEVEL_4X
LEVEL_5X
LEVEL_6X
LocationASSET_TAG*X
LOCATIONX
USAGE_FACTORX
PartsASSET_TAG*X
PARTX
QUANTITYX
WarrantyASSET_TAG*X
WARR_DESCX
WARR_DATE_FRX
WARR_DATE_TOX

* ASSET_TAG appears at the top of each list; when output to Excel, it is only queried once.

Fig. 6

Step 2: Querying model parameters.

Fig. 7

Step 3: Writing data to Excel (“General” tab).

Fig. 8

Python code for converting OmniClass values.

Tab. 5

Stored OmniClass values

Element index
01
Value indexValueValue indexValue
0202
1313
2.2.
3232
4747
5.5.
6161
7977
8.8.
9191
105103
Tab. 6

Query functions to access value

Query functionValue
f[0]23.27.19.15
f[0][0]2
f[0][1]3
f[1]23.27.17.13
f[1][4]7
Fig. 9

Step 4.1: Access all elements of a specific asset group.

Fig. 10

Step 4.2: Creating column 1 (ASSET_TAG) and column 2 (ASSET_GROUP).

Fig. 11

Step 4.2: Transpose and write columns 1 and 2 to a temporary Excel file.

Fig. 12

Step 4.2: Column 3—Writing Attribute ID for each asset.

Fig. 13

Step 4.2: Column 4—Writing attribute values.

Fig. 14

Step 4.3: Preparing to read data from temporary file.

Fig. 15

Steps 4.3 and 4.4: Reading temporary data and writing to final file.

DOI: https://doi.org/10.2478/otmcj-2022-0001 | Journal eISSN: 1847-6228 | Journal ISSN: 1847-5450
Journal RSS Feed
Language: English
Page range: 2539 - 2558
Submitted on: May 12, 2020
Accepted on: Jun 16, 2020
Published on: Mar 1, 2022
Published by: University of Zagreb
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year
Keywords:
facility management,
BIM,
life cycle,
Dynamo,
data
Related subjects:
Engineering,
Introductions and overviews,
Engineering, other

© 2022 Walid Thabet, Jason Lucas, Sai Srinivasan, published by University of Zagreb
This work is licensed under the Creative Commons Attribution 4.0 License.

Volume 14 (2022): Issue 1 (January 2022)
Next article