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 Fadeyi

Dr. Moshood Olawale Fadeyi, a creative professor, is an Associate Professor of Sustainable Building Value Delivery at the Singapore Institute of Technology. Dr. Fadeyi holds four university degrees, including a Ph.D. in Indoor Environment and Energy from the National University of Singapore and Technical University of Denmark. Dr. Fadeyi is architecture (BSc Arch and M.Arch.), building science (MSc.), and engineering (Ph.D.) trained. Dr. Fadeyi is an architect, an indoor air quality expert, chartered engineer (UK) – building services, chartered construction manager (UK), and specialist adult educator. Dr. 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. Currently, Dr. Fadeyi research aims to enhance applied learning pedagogy to make students job-ready upon graduation and improve industry and community practices. His applied learning pedagogy enhancement is informed by applied research, artistic research, and case study research grounded in design, critical, reflective, scientific, and lean thinking and digital solutions adoption. He has written more than 180 published scholarly and peer-reviewed articles in line with applied learning pedagogy enhancement and basic research. Dr. Fadeyi research and scholarship domain are in (i) value-oriented productivity in healthy and energy-efficient indoor air delivery, (ii) value-oriented productivity in design, construction, and facility management practices, and (iii) problem-based learning. Dr. Fadeyi researches to educate and solve industry and community-related problems. Dr. Fadeyi expertise and leadership are highly sought after by companies and government agencies. Dr. Fadeyi is the Editor, Author, and Cartoonist of Indoor Air Cartoon Journal – an online learning resource providing applied learning on IAQ with audiences from over 100 countries. Dr. 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 )

Google photo

You are commenting using your Google 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: