Aci Concrete Mix Design Excel Sheet <Real ◆>

Oven-dry rodded weight, Specific Gravity, Absorption, and Moisture Content.

: User-defined project requirements like target strength, exposure conditions, and material properties. ACI Reference Tables

| Feature | Benefit | |---------|---------| | | Reduces risk in water-cement ratio, aggregate moisture adjustments. | | Built-in ACI tables | Embeds Table 6.3.3 (water vs. slump), Table 6.3.6 (coarse aggregate volume), etc. | | Moisture correction | Properly adjusts batch weights for SSD to actual moisture conditions. | | Air entrainment handling | Includes target air % based on exposure (freeze-thaw, sulfate). | | Unit conversion | Converts between lb/yd³ and kg/m³, plus volume (ft³ to m³). | | Trial batch scaling | Allows small (e.g., 0.5–2 ft³) batch adjustments before plant production. |

Using the absolute volume method , the sheet adds the known volumes of water, cement, air, and coarse aggregate. The remaining volume is subtracted from 1 cubic yard (or 1 cubic meter) to find the volume required for the fine aggregate. This volume is then converted into a weight.

If your aggregate moisture content changes on-site, updating one cell instantly recalculates the batch weights. aci concrete mix design excel sheet

The ACI 211.1 method is built on established empirical relationships between material properties and concrete performance: Water-Cementitious Materials Ratio (

Select a ratio based on the target compressive strength and exposure conditions.

Before touching the spreadsheet, you must have the following data from laboratory tests or supplier certificates:

Do you need help formatting the for your spreadsheet? Tell me where you are in the mix design process! Share public link | | Built-in ACI tables | Embeds Table 6

: Drop-down menus and built-in tables that automatically pull values for slump, water content, and W/C ratios directly from ACI standards. Instant Volume-to-Weight Conversion

Ensure the mix meets exposure requirements (e.g., sulfate resistance or freeze-thaw) beyond just compressive strength.

The w/cm ratio is perhaps the most crucial parameter, as it governs the concrete’s compressive strength and durability. The ACI code provides tables correlating w/cm ratios to compressive strength (f'c). Using the target average strength (f'cr) calculated from the specified strength (f'c), the spreadsheet selects or interpolates the correct w/cm ratio.

The spreadsheet typically displays a clear output section: | | Air entrainment handling | Includes target

Absorb water from the mix. You must add water to the mixing batch and subtract weight from the aggregate target. Core Formulas for the Excel Template

Program formulas sequentially down the sheet to calculate material volumes and weights. Use distinct columns for:

Not all Excel sheets are created equal. A truly effective ACI concrete mix design template should incorporate several key features. When evaluating a sheet, look for the following:

: Adjust the weight of aggregates and mixing water based on the actual moisture content of the stockpiled materials. Trial Batching