Centralized Quotation Management System for Quantity Surveyors

Quotation management is a core pre-contract responsibility of quantity surveyors; however, in current construction practice, it remains predominantly manual, fragmented across emails, paper records, and isolated spreadsheets. Such practices contribute to processing delays, inconsistent data, limited cost transparency, and a higher risk of errors during the pre-contract stage. Despite the growing availability of digital tools in the construction industry, quotation management in quantity surveying continues to lack affordable, structured systems tailored to the operational needs of small- and medium-scale practices. To address this gap, this study proposes a centralized quotation management system in Microsoft Excel, integrated with Visual Basic for Applications (VBA). A system development methodology was adopted, comprising workflow mapping, identification of process weaknesses, system design, and prototype implementation. The proposed system design consolidates supplier quotations, material specifications, unit rates, and basic project indicators within a single platform, incorporating limited automation and data verification features to reduce duplication and improve record traceability. While the system was not empirically tested through live project deployment or formal user evaluation, the prototype demonstrates the practical feasibility of using spreadsheet-based tools to improve the organization, consistency, and accessibility of quotation data. The findings suggest that, although not a substitute for fully integrated commercial software, a structured Excel-VBA solution can offer a low-cost, transitional digital approach for enhancing quotation management in resource-constrained quantity surveying environments.

Quantity Surveying, Quotation Management, Cost Estimation, Microsoft Excel, Visual Basic for Applications (VBA)

1. Abbas, J. (2020). Impact of total quality management on corporate sustainability through the mediating effect of knowledge management. Journal of Cleaner Production, 244. https://doi.org/10.1016/j.jclepro.2019.118806 [Google Scholar] [Crossref]

2. Abdelalim, A. M., Salem, M., Salem, M., Al-Adwani, M., & Tantawy, M. (2025). An Analysis of Factors Contributing to Cost Overruns in the Global Construction Industry. Buildings, 15(1). https://doi.org/10.3390/buildings15010018 [Google Scholar] [Crossref]

3. Abedi, M., Rawai, N. M., Fathi, M. S., & Mirasa, A. K. (2014). Cloud computing as a construction collaboration tool for precast supply chain management. Jurnal Teknologi, 70(7), 1–7. https://doi.org/10.11113/jt.v70.3569 [Google Scholar] [Crossref]

4. Akinshipe, O., Aigbavboa, C., Oke, A., & Sekati, M. (2021). Transforming Quantity Surveying Firms in South Africa Through Digitalisation. Lecture Notes in Networks and Systems. https://www-scopuscom.ezproxy.utm.my/pages/publications/85112286547?origin=scopusAI [Google Scholar] [Crossref]

5. AlMaian, R. Y., Needy, K. L., Walsh, K. D., & Da C L Alves, T. (2015). Supplier quality management inside and outside the construction industry. Engineering Management Journal, 27(1), 11–22. https://doi.org/10.1080/10429247.2015.11432032 [Google Scholar] [Crossref]

6. Bascoul, A. M., Tommelein, I. D., & Douthett, D. (2020). Visual Management of Daily Construction Site Space Use. Frontiers in Built Environment, 6. https://doi.org/10.3389/fbuil.2020.00139 [Google Scholar] [Crossref]

7. Bemelmans, J., Voordijk, H., & Vos, B. (2012). Supplier‐contractor collaboration in the construction industry. Engineering Construction & Architectural Management, 19(4), 342–368. https://doi.org/10.1108/09699981211237085 [Google Scholar] [Crossref]

8. Bir, V., Kumar, T., Tanwar, P., & Kumar, P. (2024). Developing an advanced tool for transforming spreadsheet data into interactive dashboards with predictive insights. 2024 2nd International Conference on Advances in Computation, Communication and Information Technology (ICAICCIT). https://wwwscopus-com.ezproxy.utm.my/pages/publications/105001281836?origin=scopusAI [Google Scholar] [Crossref]

9. Bocchi, E., Mellia, M., & Sarni, S. (2014). Cloud storage service benchmarking: Methodologies and experimentations. 2014 IEEE 3rd International Conference on Cloud Networking (CloudNet). https://www-scopus-com.ezproxy.utm.my/pages/publications/84925859035?origin=scopusAI [Google Scholar] [Crossref]

10. Chatvichienchai, S. I. (2023). Empowering database manipulation skills: A holistic approach integrating user-friendly database tools and spreadsheet software. Proceedings - 2023 5th International Workshop on Artificial Intelligence and Education (WAIE). https://www-scopuscom.ezproxy.utm.my/pages/publications/85191721270?origin=scopusAI [Google Scholar] [Crossref]

11. Da C L Alves, T., Desai, P., Needy, K. L., Hegwood, A., & Musick, S. (2017). Impact of supplier evaluation on product quality. Annual Conference of the International Group for Lean Construction, 11– 18. https://doi.org/10.24928/2017/0268 [Google Scholar] [Crossref]

12. Daher, Z., & Hajjdiab, H. (2018). Cloud storage comparative analysis Amazon Simple Storage vs. Microsoft Azure Blob Storage. International Journal of Machine Learning and Computing. https://www-scopus-com.ezproxy.utm.my/pages/publications/85042547105?origin=scopusAI [Google Scholar] [Crossref]

13. Daoud, A. O., El Hefnawy, M., & Wefki, H. (2023). Investigation of critical factors affecting cost overruns and delays in Egyptian megaconstruction projects. Alexandria Engineering Journal, 83, 326– 334. https://doi.org/10.1016/j.aej.2023.10.052 [Google Scholar] [Crossref]

14. Dehghanimohammadabadi, M. (2022). Data-driven simulation-optimization (DSO): An efficient approach to optimize simulation models with databases. Communications in Computer and Information Science. https://www-scopus-com.ezproxy.utm.my/pages/publications/85145251219?origin=scopusAI [Google Scholar] [Crossref]

15. Duarte, B. M., & Sousa, S. D. (2020). Supplier pre-qualification method for the Portuguese construction industry. Procedia Manufacturing, 51, 1703–1708. https://doi.org/10.1016/j.promfg.2020.10.237 [Google Scholar] [Crossref]

16. Ershov, M., Avramenko, Y., Häkkinen, J., & Beloglazov, I. (2012). Quotation Tool for Process Equipment. Computer Aided Chemical Engineering. https://www-scopuscom.ezproxy.utm.my/pages/publications/84862862372?origin=scopusAI [Google Scholar] [Crossref]

17. Hamzah, N., Khoiry, M. A., Arshad, I., Tawil, N. M., & Ani, A. I. C. (2012). Causes of construction delay - Theoretical framework. Procedia Engineering, 20, 490-495. [Google Scholar] [Crossref]

18. Hu, G., Liu, Y., Liu, K., & Yang, X. (2023). Research on Data-Driven Dynamic Decision-Making Mechanism of Mega Infrastructure Project Construction. Sustainability (Switzerland), 15(12). https://doi.org/10.3390/su15129219 [Google Scholar] [Crossref]

19. Jeyaprabha, B., Kumar, S. R. R., Bolla, R. L., & Arora, K. (2025). Data-driven decision making in management: Leveraging big data analytics for strategic planning. 1st International Conference on Advances in Computer Science, Electrical, Electronics, and Communication Technologies (CE2CT). https://www-scopus-com.ezproxy.utm.my/pages/publications/105002700729?origin=scopusAI [Google Scholar] [Crossref]

20. Keng, T. C., & Ching, Y. K. (2011). A study on the use of measurement software in the preparation of bills of quantities among Malaysian quantity surveying firms. International Conference on ICT and Knowledge Engineering. https://www-scopus-com.ezproxy.utm.my/pages/publications/84858788960?origin=scopusAI [Google Scholar] [Crossref]

21. Laryea, S., & Lubbock, A. (2013). Tender pricing environment of subcontractors in the United Kingdom. Journal of Construction Engineering and Management, 140(1). https://doi.org/10.1061/(asce)co.1943-7862.0000749 [Google Scholar] [Crossref]

22. Maheshkar, C., Poulose, J., & Sharma, V. (2024). Data-driven decision making in the VUCA context: Harnessing data for informed decisions. Data-Driven Decision Making. https://www-scopuscom.ezproxy.utm.my/pages/publications/85216028617?origin=scopusAI [Google Scholar] [Crossref]

23. Memon, A. H., Asmi, A., Azis, A., Rahman, I. A., Tarmizi, A., & Karim, A. (2013). Controlling Cost Overrun Factors in Construction Projects in Malaysia. Research Journal of Applied Sciences, Engineering and Technology, 5(8), 2621–2629. [Google Scholar] [Crossref]

24. Mohd, N. I., Md Yusoff, N. N. S., Tajul Ariffin, H. L., & Fauzi, A. F. A. A. (2024). Cloud computing adoption at quantity surveying firms: Are We Ready? Insights on Resiliency and Urban Development. https://www-scopus-com.ezproxy.utm.my/pages/publications/85201338493?origin=scopusAI [Google Scholar] [Crossref]

25. Nasrun, M., Nawi, M., Baluch, N., & Bahauddin, A. Y. (2014.). Impact of Fragmentation Issue in Construction Industry: An Overview. https://doi.org/10.1051/C [Google Scholar] [Crossref]

26. Ojha, V. K., Goyal, S., & Chand, M. (2024). Data-driven decision making in advanced manufacturing systems: Modeling and analysis of critical success factors. Journal of Decision Systems. https://wwwscopus-com.ezproxy.utm.my/pages/publications/85173737550?origin=scopusAI [Google Scholar] [Crossref]

27. Rao, L. S., & Reddy, I. R. (2016). Study and comparison of non-traditional cloud storage services for high load text data. Smart Innovation, Systems and Technologies. https://www-scopuscom.ezproxy.utm.my/pages/publications/84969188091?origin=scopusAI [Google Scholar] [Crossref]

28. Safavi, A., Bigham, B. S., & Mazyar Zahedi-Seresht. (2025). Supplier Selection Utilizing AHP and TOPSIS in a Fuzzy Environment Based on KPIs. Contemporary Mathematics, 574–593. https://doi.org/10.37256/cm.6120256152 [Google Scholar] [Crossref]

29. Sarkar, S. J., Kundu, P. K., & Sarkar, G. (2018). Realization of a cloud server based power system operational data management system. ICECE 2018 - 10th International Conference on Electrical and Computer Engineering. https://www-scopus-com.ezproxy.utm.my/pages/publications/85062846707?origin=scopusAI [Google Scholar] [Crossref]

30. Shan, M., Chan, A. P. C., Le, Y., Hu, Y., & Xia, B. (2016). Understanding collusive practices in Chinese construction projects. Journal of Professional Issues in Engineering Education and Practice, 143(3). https://doi.org/10.1061/(asce)ei.1943-5541.0000314 [Google Scholar] [Crossref]

31. Srinivasan, S., & Krishnan, R. B. (2013). Data property analyzer for information storage in cloud. Proceedings of the 2013 International Conference on Pattern Recognition, Informatics and Mobile Engineering (PRIME). https://www-scopus-com.ezproxy.utm.my/pages/publications/84876755933?origin=scopusAI [Google Scholar] [Crossref]

32. Thiess, T., & Müller, O. (2018). Towards design principles for data-driven decision making - An action design research project in the maritime industry. 26th European Conference on Information Systems (ECIS). https://www-scopus-com.ezproxy.utm.my/pages/publications/85061307906?origin=scopusAI [Google Scholar] [Crossref]

33. Whang, S., Donyavi, S., Flanagan, R., & Kim, S. (2022). Balanced approach for tendering practice at the pre-contract stage: The UK practitioner’s perspective. Journal of Civil Engineering and Management, 28(5), 338–348. https://doi.org/10.3846/jcem.2022.16580 [Google Scholar] [Crossref]

34. Xiao, L., Ye, K., Zhou, J., Ye, X., & Tekka, R. S. (2021). A social network-based examination on bid riggers’ relationships in the construction industry: A case study of China. Buildings, 11(8). https://doi.org/10.3390/buildings11080363 [Google Scholar] [Crossref]

35. Youssef, M. A., Ibrahim, A. H., & Bakry, R. A. (2023). Technical audit and unethical practices in the construction industry. Civil Engineering Journal, 9, 173–191. https://doi.org/10.28991/cej-sp2023-09014 [Google Scholar] [Crossref]

• Ai-Based Automated Grading and Feedback Systems: Technologies, Challenges and Future Directions in Higher Education
• An Efficient Desktop-Based File and Folder Encryption Framework Using Fernet Cryptography