for col in range(1,5): ws.column_dimensions[get_column_letter(col)].width = 35
| Step | Description | Formula (Excel syntax) |
|------|-------------|------------------------|
| 1 | Water amount (lb/yd³) – from ACI table for slump & NMAS | =VLOOKUP(slump,NMAS_table,2) |
| 2 | Cement content (lb/yd³) | =Water / w_c_ratio |
| 3 | Coarse aggregate volume (ft³/yd³) | =DRUW * 27 / 100 (or ACI table method) |
| 4 | Coarse aggregate weight (lb/yd³) | =Coarse_vol_ft3 * SG_ca * 62.4 |
| 5 | Air volume (ft³/yd³) | =Air / 100 * 27 |
| 6 | Water volume (ft³/yd³) | =Water / 62.4 |
| 7 | Cement volume (ft³/yd³) | =Cement / (SG_c * 62.4) |
| 8 | Coarse aggregate volume (ft³/yd³) | =Coarse_agg_weight / (SG_ca * 62.4) |
| 9 | Total volume of above (ft³/yd³) | =SUM(air_vol,water_vol,cement_vol,ca_vol) |
| 10 | Fine aggregate volume (ft³/yd³) | =27 - Total_vol_above |
| 11 | Fine aggregate weight (lb/yd³) | =FA_vol * SG_fa * 62.4 |
| 12 | Batch weights (SSD) | =Cement, Water, CA, FA |
| 13 | Moisture correction – CA | =CA_SSD * (1 + MC_ca/100 - Abs_ca/100) |
| 14 | Moisture correction – FA | =FA_SSD * (1 + MC_fa/100 - Abs_fa/100) |
| 15 | Adjusted water | =Water - (CA_SSD*(MC_ca-Abs_ca)/100) - (FA_SSD*(MC_fa-Abs_fa)/100) |
Developing a deep Excel sheet for ACI 211.1-91 concrete mix design requires more than listing formulas; it requires algorithmic logic that mimics the decision-making process of an engineer. By embedding lookup tables, automating moisture corrections, and implementing logical safety checks for water-cement ratios, the spreadsheet becomes a dynamic tool that enhances quality control and accelerates the design process. Such a tool bridges the gap between the theoretical code and practical field application. aci concrete mix design excel sheet
Using ACI Table 6.3.3:
$$Weight_Adjusted = Weight_SSD \times (1 + MC\%)$$
Excel Implementation:
Use an IF statement to check if $MC > Abs$: for col in range(1,5):
ws
=IF(MC > Abs, DesignWater - (AggWeight * (MC - Abs)), DesignWater + (AggWeight * (Abs - MC)))
This transforms the sheet from a theoretical design tool into a practical batching tool.
Cement = Water / (w/c ratio)
Abstract The proportioning of concrete mixtures is a fundamental aspect of civil engineering, requiring iterative calculations to balance workability, strength, durability, and economy. While the American Concrete Institute (ACI) Committee 211 provides the standard "Normal, Heavyweight, and Mass Concrete" mix design methodology, manual application is prone to arithmetic error and time-consuming iteration. This paper explores the development of a robust Excel-based computational tool that automates the ACI 211.1-91 procedure. We examine the algorithmic translation of empirical tables, the handling of aggregate moisture correction, and the logic structure required for a dynamic mix design sheet.
ws.cell(row=row, column=1, value="1. Water Requirement (from ACI Table 6.3.3)").font = subheader_font ws.cell(row=row, column=2, value="lb/yd³") formula_water = 'IF(AND(B6<=0.75, B6>=0.5), IF(B8="Yes", 305, 335), IF(B6=1, IF(B8="Yes", 315, 345), IF(B6=1.5, IF(B8="Yes", 340, 365), "Check ACI Table")))' ws.cell(row=row, column=3, value="Formula").font = Font(italic=True) ws.cell(row=row, column=4, value=formula_water) row += 1 Developing a deep Excel sheet for ACI 211
ws.cell(row=row, column=2, value="Water (Unadjusted)") ws.cell(row=row, column=3, value=formula_water) ws.cell(row=row, column=4, value="=D3") # placeholder actual value ws.cell(row=row, column=4).fill = result_fill row += 1