A solution to optimise the process for consolidating asset information into asset information requirements (AIR) template

Abstract:

The maintenance and operations of the building to ensure suitable building performance requires 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 files and pasting on an excel template cell by cell. This practice causes more time to be spent on consolidation. Companies usually deploy several more staff to do consolidation tasks to reduce the time taken. 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 the accurate consolidation of building asset information into an AIR template within a short period and with the 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 consolidate. 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 improving productivity in the facility management industry.

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

Download Full paper

Cite as: “Ng HM and Fadeyi MO (2020). 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.”

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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