Have a personal or library account? Click to login
Linking life cycle BIM data to a facility management system using Revit Dynamo Cover
Open Access
|Mar 2022

Figures & Tables

Fig. 1

Research methodology.
Research methodology.

Fig. 2

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

Fig. 3

Example of the “Parts” tab.
Example of the “Parts” tab.

Fig. 4

Summary of the proposed Dynamo workflow.
Summary of the proposed Dynamo workflow.

Fig. 5

Step 1: Identifying model elements.
Step 1: Identifying model elements.

Fig. 6

Step 2: Querying model parameters.
Step 2: Querying model parameters.

Fig. 7

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

Fig. 8

Python code for converting OmniClass values.
Python code for converting OmniClass values.

Fig. 9

Step 4.1: Access all elements of a specific asset group.
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).
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.
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.
Step 4.2: Column 3—Writing Attribute ID for each asset.

Fig. 13

Step 4.2: Column 4—Writing attribute values.
Step 4.2: Column 4—Writing attribute values.

Fig. 14

Step 4.3: Preparing to read data from temporary file.
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.
Steps 4.3 and 4.4: Reading temporary data and writing to final file.

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-1 Basement—Mech/Elec Rm 7
FANF-2ERURoof
FCUFC-1 through FC-8 Main Floor
FCUFC-9 Basement
HTRHUH-1 Basement—Mech/Elec Rm 7
HTRECH-1ERURoof
HTRECH-2, ECH-3, ECH-4MAU-1Roof
HUDHUMMAU-1Roof
PHWP-1, HWP-2 Basement—Mech/Elec Rm 7
PERP-1ERURoof
PCWP-1 Basement—Mech/Elec Rm 7
SEPAS-1 Basement—Mech/Elec Rm 7
SEPAS-2ERURoof
TNKPET-1 Mech/Elec Rm 7
TNKPET-2 Roof
EMER-ATSATS-1, ATS-2 Basement—Mech. Equip. Rm
EMER-GENEmergency Generator Basement—Mech. Equip. Rm

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

Parameter types and corresponding input list

SheetParameter name (input)List used as input

List.FilterByBoolMaskFamilyInstance.Type
GeneralASSET_TAG*X
ASSET_GROUP X
DESCRIPTIONX
LOCATION_CODEX
DATE_PURCHASEDX
LONG_DESC X
SERIAL_NOX
LOCKOUT X
MANU_PART_NUMBER X
MANUFACTURE_CODE X
PROCEDURE_YN X
PARENT_ASSET_TAGX
YEAR_INSTALLEDX
ClassificationASSET_TAG*X
CLASS_STANDARD X
LEVEL_1 X
LEVEL_2 X
LEVEL_3 X
LEVEL_4 X
LEVEL_5 X
LEVEL_6 X
LocationASSET_TAG*X
LOCATIONX
USAGE_FACTORX
PartsASSET_TAG*X
PART X
QUANTITY X
WarrantyASSET_TAG*X
WARR_DESC X
WARR_DATE_FRX
WARR_DATE_TOX

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

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

Stored OmniClass values

Element index

01

Value indexValueValue indexValue
0202
1313
2.2.
3232
4747
5.5.
6161
7977
8.8.
9191
105103
DOI: https://doi.org/10.2478/otmcj-2022-0001 | Journal eISSN: 1847-6228 | Journal ISSN: 1847-5450
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

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