Development of a solution to optimise the process for consolidating asset information into asset information requirements (AIR) template


The maintenance and operations of building to ensure suitable building performance require consolidation of complete and accurate building asset information. The consolidation of building asset information is done in the asset information requirement (AIR) template. The AIR template is designed according to the building owner’s requirements. The risk of consolidating inaccurate asset information into an AIR template increases with an increasing number of building asset information to be consolidated. The current practice in the industry involves manual on and forth coping of critical asset information from PDF file and pasting on excel template cell by cell. This practice causes more time to be spent on consolidation. To reduce the time taken, companies usually deploy more several staff to do consolidation tasks. The risk of errors occurring in the current manual consolidation practice is high due to inherent human error.  An automated solution was developed and tested to examine how it could aid accurate consolidation of building asset information into an AIR template within a short period and with potential for lesser manpower.  The developed solution reduces the time taken to consolidate asset information into an AIR template by 99% with zero error. The developed solution also reduces the need for experienced staff to do the consolidation. The findings suggest the number of staff required, even with a large building with many critical assets can be reduced significantly. The solution developed and reported in this paper is essential to the effort needed to improve productivity in the facility management industry.

Keywords: Facility management, Asset information, Asset Information Requirements (AIR), Digital Facility Management, Productivity

Download full paper:

Full paper

Cite as: “Ng HM and Fadeyi MO (2020). Development of a solution to optimise the process for consolidating asset information into asset information requirements (AIR) template. Built Environment Applied Research Sharing #02, ISSUU Digital Publishing Platform.”

Published by Moshood Olawale Fadeyi

Dr. Moshood Olawale Fadeyi is a sustainable building professor with specialisation in sustainable building value delivery education at the Singapore Institute of Technology. He is also an architect, an indoor air quality expert, a chartered engineer (UK) – building services, a chartered construction manager (UK), a cartoonist, and a specialist adult educator. He holds four university degrees, including a Ph.D. in Indoor Environment and Energy from the National University of Singapore and the Technical University of Denmark. He is architecture (BSc Arch and M.Arch.), building science (MSc.), and engineering (Ph.D.) trained. He is a member of the Chartered Institution of Building Services Engineers (UK), Chartered Institute of Building (UK), and American Society of Heating, Refrigerating, & Air-conditioning Engineers. He is well suited for architecture, interior design, building science, and architectural/building services engineering education. He has experience and expertise in developing undergraduate and postgraduate curricula to make students job-ready upon graduation. He is currently researching to develop an understanding that provides direction for educating learners on how to solve sustainable building value delivery problems. He engages in research for education because he wants to contribute to the human empowerment needed to improve industry practice and healthy living. Under the sustainable building value delivery theme, he focuses on indoor air quality value delivery and value-oriented productivity in sustainable building design, construction, and management practices. His research for education effort is enhanced by his fundamental knowledge and skillsets in building information modelling and other digital solutions adoption, design, critical, reflective, scientific, and lean thinking, fine art, oral and written communication, and storytelling. He has published more than 200 applied learning, discovery research, and literature review articles and creative works (fine art and creative writing) to develop an understanding of solving sustainable building value delivery problems. Companies and government agencies highly seek his expertise and leadership skills. He is the Editor, Author, and Cartoonist of Indoor Air Cartoon Journal – a creative and applied learning journal providing education on indoor air quality, with audiences from over 100 countries. He is a former National Taekwondo Champion in Singapore – Black Belt Middle-Heavy Weight category, 2006.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: