Automated Excel-Based Mix Proportioning Framework for High-Strength Concrete (M70) Using IS 10262:2019

DOI

10.2991/978-94-6239-713-2_32How to use a DOI?

Keywords

IS 10262:2019; M70 High-Strength Concrete; Excel Automation; Mix Proportioning; Silica Fume; Superplasticizer; Compressive Strength

Abstract

According to IS 10262:2019, designing a concrete mix includes complicated calculations that can easily go wrong, especially for high-strength concrete mixes. This document discusses the creation and testing of an automated framework for proportioning concrete mixes using Microsoft Excel that completely meets the requirements of IS 10262:2019. This framework works with all grades of concrete mix, from M10 to M100. It includes statistical target strength calculation, water-cement ratio calculation, supplementary cementitious material compensation, volumetric yield correction, and IS 456:2000 durability constraint satisfaction in one tool. We tested this framework by using it on a detailed example of an M70 grade high-strength concrete mix using UltraTech OPC 53 grade cement, a 10% silica fume replacement, and a PCE-based superplasticizer at a dose of 1.20%. Nine cube specimens were tested for compressive strength as part of the experimental validation. The average compressive strength was 45.82 MPa at 7 days, 48.74 MPa at 14 days, and 78.94 MPa at 28 days, which is much higher than the goal strength for the M70 grade mix, which is 77 MPa. This tool cuts down on the time it takes to develop a mix and makes a quality control batch sheet that is ready to use on site.

Copyright

© 2026 The Author(s)

Open Access

Open Access This chapter is licensed under the terms of the Creative Commons Attribution-NonCommercial 4.0 International License (http://creativecommons.org/licenses/by-nc/4.0/), which permits any noncommercial use, sharing, adaptation, distribution and reproduction in any medium or format, as long as you give appropriate credit to the original author(s) and the source, provide a link to the Creative Commons license and indicate if changes were made.

Download article (PDF)

TY  - CONF
AU  - Darshana Sorte
AU  - Priyanka Pandey
PY  - 2026
DA  - 2026/06/25
TI  - Automated Excel-Based Mix Proportioning Framework for High-Strength Concrete (M70) Using IS 10262:2019
BT  - Proceedings of the International Conference on Advances in Computing Technology and Artificial Intelligence (COMPUTATIA 2026)
PB  - Atlantis Press
SP  - 419
EP  - 431
SN  - 2589-4919
UR  - https://doi.org/10.2991/978-94-6239-713-2_32
DO  - 10.2991/978-94-6239-713-2_32
ID  - Sorte2026
ER  -