Abstract: Concrete mix design plays a crucial role in achieving the desired strength, durability, and workability of concrete in construction projects. The conventional manual method based on IS 10262:2019 is often time-consuming and prone to calculation errors. This study presents the development and application of a Microsoft Excel-based tool to automate the concrete mix design process in accordance with IS 10262:2019 guidelines.The proposed Excel model integrates standard design procedures, including target mean strength calculation, selection of water-cement ratio, estimation of water content, determination of cement content, and proportioning of fine and coarse aggregates. Built-in formulas and logical functions are used to streamline calculations and reduce human intervention. The model allows users to input parameters such as grade of concrete, exposure conditions, workability requirements, and material properties, and automatically generates accurate mix proportions.
Ansari et al. (2026) studied this question.