Aci Concrete Mix Design Excel Sheet ((new)) -
ACI Mix Design Excel Sheet – Step-by-Step Structure
8. Conclusion
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.
Step 6: Coarse Aggregate Volume
From ACI Table 6.3.6: based on FM of sand and max aggregate size.
For FM=2.6 and ¾ in. max → ~0.68 ft³ of CA per ft³ of concrete.
Excel calculates dry weight of CA = volume fraction × dry rodded density. aci concrete mix design excel sheet
✅ 1. Unit Flexibility
- Switch between SI (kg/m³, mm) and Imperial (lb/yd³, in) using a dropdown.
4. Excel Sheet Layout Example
| A | B | C | D |
|---|---|---|---|
| Parameter | Value | Unit | Formula/Reference |
| Required f'c | 4000 | psi | Input |
| Slump | 3 | in | Input |
| NMAS | 1 | in | Input |
| Water (ACI table) | 340 | lb/yd³ | =VLOOKUP(...) |
| w/c ratio | 0.48 | – | Input |
| Cement | 708 | lb/yd³ | =B5/B6 |
| CA weight (SSD) | 1850 | lb/yd³ | =SG_ca*62.4*CA_vol |
| FA weight (SSD) | 1350 | lb/yd³ | =(27 - sum_volumes)*SG_fa*62.4 |
| Total weight (SSD) | 4250 | lb/yd³ | =SUM(...) | ACI Mix Design Excel Sheet – Step-by-Step Structure
8
1. Overview & Purpose
The Excel sheet is designed to automate the trial batch proportioning of concrete following ACI 211.1. It takes user inputs (required strength, slump, aggregate properties, exposure conditions) and calculates quantities of cement, water, fine aggregate, coarse aggregate, and admixtures per cubic yard or cubic meter. Step 6: Coarse Aggregate Volume From ACI Table 6
1. Input Section (User Data)
| Parameter | Symbol | Example Value | Unit | |-----------|--------|---------------|------| | Required compressive strength | f'c | 4000 | psi | | Required slump | Slump | 3 | inch | | Nominal max aggregate size | NMAS | 1 | inch | | Fine aggregate fineness modulus | FM | 2.8 | - | | Fine aggregate specific gravity | SG_fa | 2.65 | - | | Coarse aggregate specific gravity | SG_ca | 2.70 | - | | Cement specific gravity | SG_c | 3.15 | - | | Water-cement ratio (from table) | w/c | 0.48 | - | | Coarse aggregate dry-rodded unit weight | DRUW | 100 | lb/ft³ | | Fine aggregate absorption | Abs_fa | 1.2 | % | | Coarse aggregate absorption | Abs_ca | 0.8 | % | | Fine aggregate moisture content | MC_fa | 5.0 | % | | Coarse aggregate moisture content | MC_ca | 2.0 | % | | Air content (entrapped/entrained) | Air | 1.5 | % |
5. Admixtures (Optional)
- Water reducer – % dosage
- Air-entraining agent – target air volume (e.g., 5%)