Low-Cost Predictive Modelling of Asphalt Mix Design Using Excel-Based Regression: A Sustainability-Oriented Engineering Approach from Nigeria

Abstract:

The need and quest for sustainable road infrastructure demands alternative, cost-effective and readily available tools that reduce environmental impacts during asphalt mix design. This study examines the application of Excel-based regression modelling as a cost-effective Artificial Intelligence tool to predict the optimum bitumen content in asphaltic concrete mixtures. Traditional mix design methods are resource-intensive and carbon-heavy, particularly in low-income countries. This study utilizes a dataset collected from six geopolitical zones in Nigeria and applies Multiple Linear Regression via Microsoft Excel to develop a predictive model. The model was calibrated and validated using standard error indices and physical lab tests. Results showed that the Excel-based model reduced the need for full-scale experimental mixes by over 90%, achieving an R² of 0.996 and a standard error of less than 0.35. This method significantly reduces material waste, emissions, and energy consumption. The study positions Excel-based regression modelling as a practical AI-enabled tool for engineers in resource-constrained environments. Future research should explore the integration of Excel with other add-in tools and the incorporation of real-time climate and traffic variables.

• Periodical: Construction Technologies and Architecture (Volume 22)
• Pages: 111-122
• DOI: https://doi.org/10.4028/p-T9wLy3
• Online since: March 2026
• Authors: Okechukwu Joseph Ifeanyi Ezekwesili*, Onuegbu O. Ugwu, Olamide Bamgboye
• Keywords: Artificial Intelligence, Asphalt Mix Design, Carbon Reduction, Excel Regression, Predictive Modelling, Sustainable Pavement Engineering

References

[1] K.A. Ali, M.I. Ahmad, Y. Yusup, Issues, impacts, and mitigations of carbon dioxide emissions in the building sector, Sustainability 12 (18) (2020) 7427

DOI: 10.3390/su12187427

[2] K.M.O. Oba, O.O. Ugwu, F.O. Okafor, Predicting the split tensile strength of saw dust ash–fine aggregate concrete, Niger. J. Technol. 39 (1) (2020) 87–96

DOI: 10.4314/njt.v39i1.9

[3] N. Mouratidis, The 7 challenges of road management towards sustainability and development, J. Infrastruct. Policy Dev. 4 (2) (2020) 249

DOI: 10.24294/jipd.v4i2.1174

[4] D. Paunova, D. Tzonevska, Strategic development of the national road network, IOP Conf. Ser. Mater. Sci. Eng. 1297 (1) (2023) 012016

DOI: 10.1088/1757-899X/1297/1/012016

[5] A. Ruiz, J. Guevara, Sustainable decision-making in road development: analysis of road preservation policies, Sustainability 12 (3) (2020) 872

DOI: 10.3390/su12030872

[6] M.T. Aslan, E. İskender, A. Aksoy, Performance investigation of diatomite-modified asphalt mixtures for different diatomite ratios and grinding sizes, Turk. J. Civ. Eng. (2024)

DOI: 10.18400/tjce.1387917

[7] Z. Florkova, S. Sedivy, J. Pastorkova, Environmental impact of asphalt mixtures production for road infrastructure, IOP Conf. Ser. Mater. Sci. Eng. 1015 (1) (2021) 012097

DOI: 10.1088/1757-899x/1015/1/012097

[8] K.M.M. Othman, H. Abdelwahab, Prediction of the optimum asphalt content using artificial neural networks, Metall. Mater. Eng. 27 (2) (2021) 227–242

DOI: 10.30544/579

[9] J.L.O. Lucas Júnior, L.F.A.L. Babadopulos, J.B. Soares, Effect of aggregate shape properties and binder adhesiveness on compression and tension/compression tests of hot mix asphalt, Mater. Struct. 53 (2) (2020) 1–15

DOI: 10.1617/s11527-020-01472-1

[10] S. Heydari, A. Hajimohammadi, N.H.S. Javadi, N. Khalili, Use of plastic waste in asphalt: a critical review on asphalt mix design and Marshall properties, Constr. Build. Mater. 309 (2021) 125185

DOI: 10.1016/j.conbuildmat.2021.125185

[11] H. Sebaaly, S. Varma, J.W. Maina, Optimizing asphalt mix design process using artificial neural network and genetic algorithm, Constr. Build. Mater. 168 (2018) 660–670

DOI: 10.1016/j.conbuildmat.2018.02.118

[12] N.S. Aliyu Yaro, et al., Soft computing applications in asphalt pavement: a comprehensive review of data-driven techniques using response surface methodology and machine learning, J. Road Eng. 5 (2) (2025) 129–163

DOI: 10.1016/j.jreng.2024.12.003

[13] M.A. Dalhat, S.A. Osman, Artificial neural network modelling of theoretical maximum specific gravity for asphalt concrete mix, Int. J. Pavement Res. Technol. (2022)

DOI: 10.1007/s42947-022-00244-0

[14] H. Mahdi, A.H. Albayati, Model development for the prediction of the resilient modulus of warm mix asphalt, Civ. Eng. J. (Iran) 6 (4) (2020)

DOI: 10.28991/cej-2020-03091502

[15] S. Dündar, Ş. Şitilbay, M.S. Yardim, Modelling the effects of hydrated lime additives on asphalt mixtures by fuzzy logic and ANN, Teknik Dergi (2019)

DOI: 10.18400/tekderg.402816

[16] D.V. Dao, N.-L. Nguyen, H.-B. Ly, B.T. Pham, T.-T. Le, Cost-effective approaches based on machine learning to predict dynamic modulus of warm mix asphalt with high reclaimed asphalt pavement, Materials 13 (15) (2020) 3272

DOI: 10.3390/ma13153272

[17] M. Svilar, I. Peško, M. Šešlija, Model for estimating the modulus of elasticity of asphalt layers using machine learning, Appl. Sci. 12 (20) (2022)

DOI: 10.3390/app122010536

[18] E. Özgan, Modelling the stability of asphalt concrete with fuzzy logic and statistical methods for various freezing and thawing cycles, Math. Comput. Appl. 15 (2) (2010) 176–186

DOI: 10.3390/mca15020176

[19] H.K. Shanbara, F. Ruddock, W. Atherton, A viscoplastic model for permanent deformation prediction of reinforced cold mix asphalt, Constr. Build. Mater. 186 (2018)

DOI: 10.1016/j.conbuildmat.2018.07.127

[20] R. Zbiciak, R. Michalczyk, K. Brzeziński, Time–temperature superposition for viscoelastic materials with application to asphalt–aggregate mixes, Int. J. Environ. Sci. Technol. 16 (9) (2019)

DOI: 10.1007/s13762-018-1874-9

[21] L. Al Khateeb, K. Anupam, S. Erkens, T. Scarpas, Micromechanical simulation of porous asphalt mixture compaction using discrete element method, Constr. Build. Mater. 301 (2021)

DOI: 10.1016/j.conbuildmat.2021.124305

[22] Z. Dong, X. Gong, L. Zhao, L. Zhang, Mesostructural damage simulation of asphalt mixture using microscopic interface contact models, Constr. Build. Mater. 53 (2014) 665–673

DOI: 10.1016/j.conbuildmat.2013.11.109

[23] M. Milad, et al., Development of a hybrid machine learning model for asphalt pavement temperature prediction, IEEE Access 9 (2021)

DOI: 10.1109/ACCESS.2021.3129979

[24] A. Garcia-Hernandez, L. Wan, S. Dopazo-Hilario, A. Chiarelli, A. Dawson, Generation of virtual asphalt concrete in a physics engine, Constr. Build. Mater. 286 (2021)

DOI: 10.1016/j.conbuildmat.2021.122972

[25] S. Komaragiri, A. Gigliotti, A. Bhasin, Feasibility of using a physics engine to virtually compact asphalt mixtures in a gyratory compactor, Constr. Build. Mater. 308 (2021)

DOI: 10.1016/j.conbuildmat.2021.124977

[26] Z. Tan, et al., Virtual-specimen modelling of aggregate contact effects on asphalt concrete, Constr. Build. Mater. 400 (2023)

DOI: 10.1016/j.conbuildmat.2023.132638

[27] K. Othman, Prediction of the hot asphalt mix properties using deep neural networks, Beni-Suef Univ. J. Basic Appl. Sci. 11 (1) (2022)

DOI: 10.1186/s43088-022-00221-3

[28] H.L. Nguyen, V.Q. Tran, Data-driven approach for investigating and predicting rutting depth of asphalt concrete containing reclaimed asphalt pavement, Constr. Build. Mater. 377 (2023)

DOI: 10.1016/j.conbuildmat.2023.131116

[29] M. Khashei, A.Z. Hamadani, M. Bijari, A novel hybrid classification model of artificial neural networks and multiple linear regression models, Expert Syst. Appl. 39 (3) (2012) 2606–2620

DOI: 10.1016/j.eswa.2011.08.116

[30] M.A. Montoya, J.E. Haddock, Estimating asphalt mixture volumetric properties using seemingly unrelated regression equations approaches, Constr. Build. Mater. 225 (2019) 829–837

DOI: 10.1016/j.conbuildmat.2019.07.266

[31] I. Nwaobakata, S.N. Eluozo, Development of mathematical model to predict Marshall stability on modified asphalt, Glob. J. Eng. Sci. 1 (5) (2019) 1–8

DOI: 10.33552/gjes.2019.01.000524

[32] R. Botella, et al., Machine learning techniques to estimate the degree of binder activity of reclaimed asphalt pavement, Mater. Struct. 55 (4) (2022)

DOI: 10.1617/s11527-022-01933-9

[33] M. Miani, et al., Bituminous mixtures experimental data modelling using a hyperparameters-optimized machine learning approach, Appl. Sci. 11 (24) (2021) 11710

DOI: 10.3390/app112411710

[34] M. Claesen, B.L.R. De Moor, Hyperparameter search in machine learning, (2015). https://www.researchgate.net/publication/272195620

[35] J. Huang, G.S. Kumar, J. Ren, J. Zhang, Y. Sun, Accurately predicting dynamic modulus of asphalt mixtures in low-temperature regions using hybrid artificial intelligence model, Constr. Build. Mater. 297 (2021) 123655

DOI: 10.1016/j.conbuildmat.2021.123655

[36] Q. Fu, X. Chen, X. Qiu, Spatial distribution characterization of the temperature-induced gradient viscoelasticity inside asphalt pavement, Constr. Build. Mater. 346 (2022) 128454

DOI: 10.1016/j.conbuildmat.2022.128454

[37] J. Liu, F. Liu, L. Wang, Automated, economical, and environmentally friendly asphalt mix design based on machine learning and multi-objective grey wolf optimization, J. Traffic Transp. Eng. (Engl. Ed.) 11 (3) (2024) 381–405

DOI: 10.1016/j.jtte.2023.10.002

[38] S.M. Hadi, S.J. Radi, A.R. Abdulaali, et al., A study of using spreadsheet modelling as an ideal tool for synergies managerial knowledge with uncertain marketing information, PalArch J. Archaeol. Egypt/Egyptol. 17 (9) (2020) 2831–2850. https://archives.palarch.nl/index.php/jae/ article/view/3485

[39] E. Levenberg, Viscoelastic pavement modelling with a spreadsheet, in: Proc. 8th Int. Conf. Maintenance and Rehabilitation of Pavements (MAIREPAV), (2016), p.746–755. https://doi.org/

DOI: 10.3850/978-981-11-0449-7-132-cd

[40] O.J.I. Ezekwesili, O.O. Ugwu, U. Onyia, Integrated virtual modelling and aggregation framework for optimized management of asphaltic concrete mixtures data, Adv. Model. Anal. B 66 (1–4) (2023) 43–50

DOI: 10.18280/ama_b.661-408

[41] I. Marović, I. Androjić, Development of artificial neural network and multiple linear regression models in the prediction process of the hot mix asphalt properties, Can. J. Civ. Eng. 44 (2017) 994–1004

DOI: 10.1139/cjce-2017-0300

[42] P. Mireault, Structured spreadsheet modelling and implementation, (2015). https://www.researchgate.net/publication/273472137

[43] S. Powell, Spreadsheet modelling for insight, in: Proc. Int. Workshop Found. Spreadsheets, (2004). http://web.engr.oregonstate.edu/~erwig/FoS04/proc/FOS04Papers.pdf

[44] O. Sokolov, Designing of optimal grading of asphalt mixtures in the MS Excel environment, Dorogi i Mosti 28 (2023) 159–171

DOI: 10.36100/dorogimosti2023.28.159

[45] F.K.A. Awuah, A. Garcia-Hernandez, J. Valentin, A digital design method for asphalt mixtures that incorporates aggregate geometry, Constr. Build. Mater. 416 (2024) 135281

DOI: 10.1016/j.conbuildmat.2024.135281

[46] M.W. Witczak, M. El-Basyouny, J. Uzan, Adapting specification criteria for simple performance tests to HMA mix design, Transp. Res. Board (2011)

DOI: 10.17226/22895

[47] S. Bressi, J. Santos, M. Orešković, M. Losa, Comparative environmental impact analysis of asphalt mixtures containing crumb rubber and reclaimed asphalt pavement using life cycle assessment, Int. J. Pavement Eng. (2019) 1–15

DOI: 10.1080/10298436.2019.1623404

[48] M. Boarie, M. Abdelsalam, A. Gamal, M. Rabah, Laboratory and environmental assessment of asphalt mixture modified with a compound of reclaimed asphalt pavement and waste polyethylene, Buildings 14 (5) (2024) 1186

DOI: 10.3390/buildings14051186

[49] H. Elnaml, H. Dylla, J. Liu, L.N. Mohammad, S.B. Cooper, Incorporating environmental impact analysis into Louisiana's balanced asphalt mixture design, Transp. Res. Rec. (2023)

DOI: 10.1177/03611981231214231

[50] G. Sollazzo, S. Longo, M. Cellura, C. Celauro, Impact analysis using life cycle assessment of asphalt production from primary data, Sustainability 12 (24) (2020) 10171

DOI: 10.3390/su122410171

[51] C. Movilla-Quesada, M. Lagos-Varas, A.C. Raposeiras, O. Muñoz-Cáceres, V.C. Andrés-Valeri, C. Aguilar-Vidal, Analysis of greenhouse gas emissions and the environmental impact of the production of asphalt mixes modified with recycled materials, Sustainability 13 (14) (2021) 8081

DOI: 10.3390/su13148081

[52] R. Yang, S. Kang, H. Ozer, I.L. Al-Qadi, Environmental and economic analyses of recycled asphalt concrete mixtures based on material production and potential performance, Resour. Conserv. Recycl. 104 (2015) 141–151

DOI: 10.1016/j.resconrec.2015.08.014

[53] L.V. Araujo, J. Santos, G. Martinez-Arguelles, Environmental performance evaluation of warm mix asphalt with recycled concrete aggregate for road pavements, Int. J. Pavement Eng. (2022) 1–14

DOI: 10.1080/10298436.2022.2064999

[54] Federal Republic of Nigeria, Highway Manual Part 1: Design, Vol. 3, Pavements and Materials Design, Federal Ministry of Works and Housing, Abuja (2013). https://worksandhousing.gov.ng/management/uploads_images/1569354557.pdf

[55] Federal Republic of Nigeria, General Specifications (Roads and Bridges), Vol. 2, Federal Ministry of Works and Housing, Abuja (2016).