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.
|Uncontrolled Keywords:||automation, BQ, taking-off, microsoft excel, software|
|Subjects:||Q Science > QA Mathematics > QA76 Computer software|
|Deposited By:||Ms Zalinda Shuratman|
|Deposited On:||11 May 2009 06:44|
|Last Modified:||02 Jun 2010 01:57|
Repository Staff Only: item control page