Article Per Year (5 Year)
p-Index From 2021 - 2026
0.23
P-Index
This Author published in this journals
All Journal Journal of Applied Engineering and Technological Science (JAETS)
L. Nguyen-Son
Industrial University of Ho Chi Minh City
Civil Engineering, Building, Construction & Architecture Computer Science & IT Decision Sciences, Operations Research & Management Electrical & Electronics Engineering Industrial & Manufacturing Engineering

Published : 1 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 1 Documents
Search

 1 
Enhancing efficiency in construction scheduling for SMEs: A novel matrix-based VBA-excel model L. Nguyen-Son; T. Thai-Phuong
Journal of Applied Engineering and Technological Science (JAETS) Vol. 7 No. 2 (2026): Journal of Applied Engineering and Technological Science (JAETS)
Publisher : Yayasan Riset dan Pengembangan Intelektual (YRPI)

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.37385/jaets.v7i2.9232

Abstract

Small and medium-sized enterprises (SMEs) in construction face challenges managing complex project schedules cost-effectively. This study develops a user-friendly, matrix-based VBA-Excel model to enhance scheduling efficiency. The objective is to create an accessible tool that automates task dependency management without requiring advanced coding skills. The model employs the Precedence Diagramming Method (PDM), integrating all dependency types (FS, SS, FF, SF) with lag/lead adjustments through VBA automation in Excel. Implementation involved designing a novel matrix structure for dependency handling and a simple interface, validated via case studies with 11 and 9 tasks, benchmarked against industry standards. Results show accurate schedule calculations matching benchmarks, with seamless adjustments, though processing slows for large projects. The tool enables SMEs to optimize resources, reduce delays, and improve competitiveness at no cost. Limitations include Excel’s computational limits and omission of real-world calendar constraints like holidays. Future enhancements could include cloud-based scalability and risk integration. This innovative model fosters inclusive project management, reducing infrastructure disparities in underserved regions.
Co-Authors T. Thai-Phuong