Aci Concrete Mix Design Excel Sheet Free Jun 2026

Compute the solid volume of cement, water, coarse aggregate, and air using their respective specific gravities.

👉 Looking for a ready-to-use ACI Concrete Mix Design Excel Sheet? Download our free template with SI/Imperial units and full moisture correction – [Link to downloadable file or email signup] Or leave a comment below with your most common concrete strength – we’ll help you calibrate the sheet for your local aggregates.

| f'c (psi) | Non-air-entrained | Air-entrained | |-----------|------------------|---------------| | 6000 | 0.41 | – | | 5000 | 0.48 | 0.40 | | 4000 | 0.57 | 0.48 | | 3000 | 0.68 | 0.59 | | 2000 | 0.82 | 0.74 |

| NMAS (in) | FM 2.4 | 2.6 | 2.8 | 3.0 | |-----------|--------|-----|-----|-----| | ½″ | 0.50 | 0.48 | 0.46 | 0.44 | | ¾″ | 0.59 | 0.57 | 0.55 | 0.53 | | 1″ | 0.66 | 0.64 | 0.62 | 0.60 | | 1½″ | 0.71 | 0.69 | 0.67 | 0.65 | aci concrete mix design excel sheet

=IF(MC > Abs, DesignWater - (AggWeight * (MC - Abs)), DesignWater + (AggWeight * (Abs - MC)))

Use the trial‑batch weights to mix a small amount of concrete in the lab. Measure slump, air content and unit weight. If the fresh concrete properties differ from the target, the spreadsheet should help you adjust the proportions (e.g., increase sand if the mix is too harsh, add water if slump is too low, adjust the air‑entraining admixture dosage). Re‑run the sheet with the adjusted parameters and repeat until the fresh‑concrete properties are within specification.

: Select a ratio based on the target compressive strength (e.g., 0.48 for 34.5 MPa/5000 psi) and exposure conditions. Calculation of Cement Content Compute the solid volume of cement, water, coarse

The ACI code provides two methods for determining $w/c$: (Table 6.3.4(a)) or Durability-based (Table 6.3.4(b)). A robust Excel sheet calculates both and selects the governing value using a logical test:

Calculate by the "Absolute Volume Method." Subtract the sum of volumes of Water, Cement, Air, and Coarse Aggregate from (one cubic yard). Volume of Ingredient Specific Gravity

Manual concrete mix design requires navigating multiple charts, interpolation tables, and multi-step volumetric equations. Transitioning this framework into Microsoft Excel offers several distinct engineering advantages: | f'c (psi) | Non-air-entrained | Air-entrained |

Helps in adjusting aggregate proportions for better workability.

Increases the batch weights of the aggregates to account for internal/surface water.

A typical ACI mix design Excel sheet follows these nine fundamental steps. The sheet's built-in formulas and lookup functions guide the user through each one.

(Severe, Moderate, or Non-exposed) to determine air entrainment requirements. 2. Material Properties (Input Section) Specific Gravity: