Developing a spreadsheet application for BQ production.

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 prod...

Full description

Bibliographic Details
Main Authors: Adul Hamid, Razali (Author), Chong, Wan Siang (Author)
Format: Article
Language:English
Published: Faculty of Built Environment, UTM, 2004-12.
Subjects:
Online Access:Get fulltext
LEADER 01463 am a22001453u 4500
001 8771
042 |a dc 
100 1 0 |a Adul Hamid, Razali  |e author 
700 1 0 |a Chong, Wan Siang  |e author 
245 0 0 |a Developing a spreadsheet application for BQ production. 
260 |b Faculty of Built Environment, UTM,   |c 2004-12. 
856 |z Get fulltext  |u http://eprints.utm.my/id/eprint/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf 
520 |a 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. 
546 |a en 
650 0 4 |a QA76 Computer software