Cover Image

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

Saved in:
Bibliographic Details
Main Authors: Adul Hamid, Razali, Chong, Wan Siang
Format: Article
Language:English
Published: Faculty of Built Environment, UTM 2004
Subjects:
QA76 Computer software
Online Access:http://eprints.utm.my/id/eprint/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf
http://eprints.utm.my/id/eprint/8771/
Tags: Add Tag
No Tags, Be the first to tag this record!
id my.utm.8771
record_format eprints
spelling my.utm.87712010-06-02T01:57:51Z http://eprints.utm.my/id/eprint/8771/ Developing a spreadsheet application for BQ production. Adul Hamid, Razali Chong, Wan Siang QA76 Computer software 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. Faculty of Built Environment, UTM 2004-12 Article PeerReviewed application/pdf en http://eprints.utm.my/id/eprint/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf 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
institution Universiti Teknologi Malaysia
building UTM Library
collection Institutional Repository
continent Asia
country Malaysia
content_provider Universiti Teknologi Malaysia
content_source UTM Institutional Repository
url_provider http://eprints.utm.my/
language English
topic QA76 Computer software
spellingShingle QA76 Computer software
Adul Hamid, Razali
Chong, Wan Siang
Developing a spreadsheet application for BQ production.
description 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.
format Article
author Adul Hamid, Razali
Chong, Wan Siang
author_facet Adul Hamid, Razali
Chong, Wan Siang
author_sort Adul Hamid, Razali
title Developing a spreadsheet application for BQ production.
title_short Developing a spreadsheet application for BQ production.
title_full Developing a spreadsheet application for BQ production.
title_fullStr Developing a spreadsheet application for BQ production.
title_full_unstemmed Developing a spreadsheet application for BQ production.
title_sort developing a spreadsheet application for bq production.
publisher Faculty of Built Environment, UTM
publishDate 2004
url http://eprints.utm.my/id/eprint/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf
http://eprints.utm.my/id/eprint/8771/
_version_ 1643645067568611328
score 13.211869

Similar Items