Aci Concrete Mix Design Excel Sheet (FRESH • 2024)
| Criteria | Score (1–10) | |----------|---------------| | Ease of use | 8 (with proper instructions) | | Calculation accuracy | 9 | | Compliance with ACI 211.1 | 8.5 | | Flexibility for materials | 7 | | Error trapping | 6 (needs manual cell locking) | | Overall | 7.8 / 10 |
Conclusion: An ACI concrete mix design Excel sheet is highly valuable for engineers, technicians, and students – provided it is validated against lab trials. It saves time and reduces arithmetic mistakes, but it cannot replace field adjustments for moisture, temperature, or workability. Use it as a starting point, not the final answer. aci concrete mix design excel sheet
ws.cell(row=row, column=1, value="2. Water-to-Cementitious Ratio (from ACI Table 6.3.4)").font = subheader_font ws.cell(row=row, column=2, value="w/cm") formula_wcm = 'IF(B4>=4000, IF(B4=4000, 0.57, IF(B4=5000, 0.48, "Interpolate")), 0.68)' ws.cell(row=row, column=3, value="Formula") ws.cell(row=row, column=4, value=formula_wcm) row += 1 | Criteria | Score (1–10) | |----------|---------------| |
ws.cell(row=row, column=2, value="Selected w/cm") ws.cell(row=row, column=3, value=formula_wcm) ws.cell(row=row, column=4, value="=D4") ws.cell(row=row, column=4).fill = result_fill row += 1 Conclusion: An ACI concrete mix design Excel sheet
Input: f`c = 4000 psi, slump = 4 in, NMAS = ¾ in, w/cm = 0.45, cement SG = 3.15, CA SG = 2.68, FA SG = 2.62
| Parameter | Manual Calc | Excel Sheet | Deviation | |-----------|-------------|-------------|-----------| | Water (lb/yd³) | 305 | 305 | 0% | | Cement (lb/yd³) | 678 | 678 | 0% | | Coarse agg (SSD) | 1850 | 1852 | +0.1% | | Fine agg (SSD) | 1265 | 1262 | -0.2% | | Yield (ft³) | 27.0 | 27.02 | Acceptable |
Verdict: Matches manual ACI method within rounding tolerance.





