Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri

The needs for computer-aided tools for fast and accurate engineering computing are increasingly becoming indispensable in the ever-challenging construction industry as well as academia. In this regards, the technical demands and public expectations largely dictate the way the profession are tackled...

Full description

Bibliographic Details
Format: Article
Language:English
Published: Universiti Teknologi MARA, Pulau Pinang & Pusat Penerbitan Universiti (UPENA) 2015
Online Access:https://ir.uitm.edu.my/id/eprint/17015/
_version_ 1848804162326757376
building UiTM Institutional Repository
collection Online Access
description The needs for computer-aided tools for fast and accurate engineering computing are increasingly becoming indispensable in the ever-challenging construction industry as well as academia. In this regards, the technical demands and public expectations largely dictate the way the profession are tackled in modern Malaysia. However, these programs are often computationally opaque or complex, not customize to local contexts, expensive due to specialized target market, and potentially requiring hardware-software-specific environment. As an alternative, this paper proposed the use of Visual Basic for Application (VBA) with MS EXCEL as the parent platform and adopting analytical formulations readily familiar to Malaysian practitioners and academicians. The selection is based on the ubiquity of the said platform and established competency among users. The program developed involved determination of allowable pile capacity. Finally, the program was run and tested against a real world pile foundation problem based on geotechnical data borelog. The results were found to be in agreement with manual computational procedures, and thus confirming its veracity and applicability for the prescribed technical determination.
first_indexed 2025-11-14T21:50:45Z
format Article
id uitm-17015
institution Universiti Teknologi MARA
institution_category Local University
language English
last_indexed 2025-11-14T21:50:45Z
publishDate 2015
publisher Universiti Teknologi MARA, Pulau Pinang & Pusat Penerbitan Universiti (UPENA)
recordtype eprints
repository_type Digital Repository
spelling uitm-170152017-07-11T00:56:42Z https://ir.uitm.edu.my/id/eprint/17015/ Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri The needs for computer-aided tools for fast and accurate engineering computing are increasingly becoming indispensable in the ever-challenging construction industry as well as academia. In this regards, the technical demands and public expectations largely dictate the way the profession are tackled in modern Malaysia. However, these programs are often computationally opaque or complex, not customize to local contexts, expensive due to specialized target market, and potentially requiring hardware-software-specific environment. As an alternative, this paper proposed the use of Visual Basic for Application (VBA) with MS EXCEL as the parent platform and adopting analytical formulations readily familiar to Malaysian practitioners and academicians. The selection is based on the ubiquity of the said platform and established competency among users. The program developed involved determination of allowable pile capacity. Finally, the program was run and tested against a real world pile foundation problem based on geotechnical data borelog. The results were found to be in agreement with manual computational procedures, and thus confirming its veracity and applicability for the prescribed technical determination. Universiti Teknologi MARA, Pulau Pinang & Pusat Penerbitan Universiti (UPENA) 2015 Article PeerReviewed text en https://ir.uitm.edu.my/id/eprint/17015/1/AJ_MOHAMAD%20IRWAN%20PANDAPOTAN%20HARAHAP%20ESTEEM%2015.pdf UNSPECIFIED (2015) Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri. (2015) Esteem Academic Journal : Engineering, Science & Technology <https://ir.uitm.edu.my/view/publication/Esteem_Academic_Journal_=3A_Engineering,_Science_=26_Technology.html>, 11 (1). pp. 57-69. ISSN 1675-7939
spellingShingle Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title_full Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title_fullStr Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title_full_unstemmed Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title_short Development of VBA for assessment of practical allowable pile capacity / Mohamad Irwan P. Harahap and Muhammad Safwan Mohd Sobri
title_sort development of vba for assessment of practical allowable pile capacity / mohamad irwan p. harahap and muhammad safwan mohd sobri
url https://ir.uitm.edu.my/id/eprint/17015/