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...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Faculty of Built Environment, UTM
2004
|
| Subjects: | |
| Online Access: | http://eprints.utm.my/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf |
| _version_ | 1825910251245797376 |
|---|---|
| author | Adul Hamid, Razali Chong, Wan Siang |
| author_facet | Adul Hamid, Razali Chong, Wan Siang |
| author_sort | Adul Hamid, Razali |
| collection | ePrints |
| 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. |
| first_indexed | 2024-03-05T18:14:18Z |
| format | Article |
| id | utm.eprints-8771 |
| institution | Universiti Teknologi Malaysia - ePrints |
| language | English |
| last_indexed | 2024-03-05T18:14:18Z |
| publishDate | 2004 |
| publisher | Faculty of Built Environment, UTM |
| record_format | dspace |
| spelling | utm.eprints-87712010-06-02T01:57:51Z http://eprints.utm.my/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/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 |
| spellingShingle | QA76 Computer software Adul Hamid, Razali Chong, Wan Siang Developing a spreadsheet application for BQ production. |
| title | 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_short | Developing a spreadsheet application for BQ production. |
| title_sort | developing a spreadsheet application for bq production |
| topic | QA76 Computer software |
| url | http://eprints.utm.my/8771/1/RazaliAdulHamid2004_DevelopingASpreadsheetApplicationFor.pdf |
| work_keys_str_mv | AT adulhamidrazali developingaspreadsheetapplicationforbqproduction AT chongwansiang developingaspreadsheetapplicationforbqproduction |