Universiti Teknologi Malaysia Institutional Repository

Developing a spreadsheet application for BQ production.

Adul Hamid, Razali and Chong, Wan Siang (2004) Developing a spreadsheet application for BQ production. Jurnal Alam Bina, 6 (2). pp. 87-112. ISSN 1511-1369



The demand for information technology is continuously increasing. In the Quantity Surveying field, specific software for BQ production and estimating is widely available. However, there are still a lot of companies using the Microsoft Excel for doing calculation, scheduling and most imporlantly production of Bills of Quantities. However, these spreadsheet solutions does not offer total automation compared to the specific software as the BQ cannot be produced automatically. However, using the Visual Basic for Application (VBA) features in Microsoft Excel, this problem has been resolved. This paper presents the development of METa (Microsoft Excel For Taking-Off) which match the BQ production capabilities of the specific software. Each step in the development process was explained and the system architecture of this application is being highlighted. As a conclusion, a highly capable and user-friendly application for BQ production was developed using Microsoft Excel.

Item Type:Article
Uncontrolled Keywords:automation, BQ, taking-off, microsoft excel, software
Subjects:Q Science > QA Mathematics > QA76 Computer software
Divisions:Built Environment
ID Code:8771
Deposited By: Zalinda Shuratman
Deposited On:11 May 2009 06:44
Last Modified:02 Jun 2010 01:57

Repository Staff Only: item control page