Aci Concrete Mix Design Excel Sheet Jun 2026

ratio for both non-air-entrained and air-entrained concrete. Step 5: Calculate Cement Content The formula in Excel is straightforward:

A robust engineering workbook must follow a systematic flow where user parameters, reference standards, and calculation formulas interact seamlessly. To build a clean, scannable architecture, divide your workbook into four distinct zones:

), slump, max aggregate size, air entrainment requirement, fine aggregate fineness modulus (FM), specific gravities, and field moisture percentages.

| Slump (in) | NMAS ½″ | ¾″ | 1″ | 1½″ | |------------|---------|----|----|-----| | 1–2 | 350 | 335 | 315 | 300 | | 3–4 | 385 | 365 | 340 | 325 | | 5–6 | 410 | 385 | 360 | 340 | aci concrete mix design excel sheet

Calculates the absolute solid volumes of water, cement, coarse aggregate, and air. It subtracts the sum of these volumes from the total unit volume (

Fine Aggregate: Bulk Specific Gravity (SSD), Absorption (%), Total Moisture (%), Fineness Modulus (FM) Backend Database (Hidden Sheets)

: Many templates generate a ready-to-print submittal worksheet that you can hand directly to a general contractor or structural engineer for approval. Critical Considerations (Cons) Aci concrete mix design example pdf ratio for both non-air-entrained and air-entrained concrete

Using an ACI concrete mix design Excel sheet can simplify the mix design process and provide several benefits, including:

Program a lookup table based on ACI Table 6.3.4(a). Excel inputs the target strength ( fcr′f sub c r end-sub prime ) and fetches the maximum allowable

final_comp = [ ("Cement", "=D6"), ("Water", "=B29"), ("Coarse Aggregate (wet)", "=B30"), ("Fine Aggregate (wet)", "=B31"), ] for name, formula in final_comp: ws.cell(row=row, column=1, value=name) ws.cell(row=row, column=2, value=formula) ws.cell(row=row, column=2).fill = result_fill row += 1 | Slump (in) | NMAS ½″ | ¾″

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

Total moisture and water absorption capacity of both aggregates. Vital for adjusting the final mixing water batch weights. 3. Step-by-Step ACI 211.1 Calculation Logic

Excel Implementation: Use VLOOKUP or nested IF statements to pull values from ACI Table 6.3.3. This assigns the exact gallons or kilograms of water per unit volume based on your inputs. 4. Selection of Water-Cement (W/C) Ratio

An effective Excel spreadsheet replicates the exact sequence outlined in the ACI 211.1 manual. Below is the technical breakdown of the steps coded into a standard calculation template. 1. Choice of Slump