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

Assoc. Prof. Moshood Olawale Fadeyi is an Associate Professor of Sustainable Building Value Delivery Education at the Singapore Institute of Technology. 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. Assoc. Prof. Fadeyi is architecture (BSc Arch and M.Arch.), building science (MSc.), and engineering (Ph.D.) trained. Assoc. Prof. Fadeyi is an architect, an indoor air quality expert, chartered engineer (UK) – building services, chartered construction manager (UK), cartoonist, and specialist adult educator. Assoc. Prof. Fadeyi is a member of the Chartered Institution of Building Services Engineers (UK), Chartered Institute of Building (UK), and American Society of Heating, Refrigerating, and Air-conditioning Engineers. Assoc. Prof. Fadeyi is well suited for architecture, interior design, building science, and architectural/building services engineering education. Assoc. Prof. Fadeyi has experience and expertise in developing undergraduate and postgraduate curricula to make students job-ready upon graduation. Since 2018, Assoc. Prof. Fadeyi focuses more on education. Assoc. Prof. Fadeyi's education practice includes research that aims to understand how students and industry professionals should be educated to develop the fundamental knowledge and skillsets for defining and solving a problem for value delivery instead of solving a problem that does not exist or providing a solution to a problem that exists. The theme of his education practice is sustainable building value delivery education. Under this theme, he has in-depth expertise in indoor air quality value delivery education and value-oriented productivity education (in sustainable design, construction, and facility management practices). Assoc. Prof. Fadeyi's education practice is enhanced by his fundamental knowledge and skillsets in design, critical, reflective, scientific, and lean thinking, fine art, oral and written communication, building information modelling and other digital solutions adoption, and storytelling. Assoc. Prof. Fadeyi has published more than 200 applied learning, discovery research, and literature review articles and creative works (fine art and creative writing) contributing to applied learning pedagogy enhancement and scientific evidence on new knowledge. Assoc. Prof. Fadeyi's expertise and leadership are highly sought after by companies and government agencies. Assoc. Prof. Fadeyi is the Editor, Author, and Cartoonist of Indoor Air Cartoon Journal – an applied learning journal providing education on indoor air quality, with audiences from over 100 countries. Assoc. Prof. Fadeyi 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: