Aci Concrete Mix Design Excel Sheet -

Building an ACI Concrete Mix Design Excel Sheet allows for quick, repeatable calculations according to ACI 211.1. This guide follows the Absolute Volume Method, which is the standard approach for precise batch proportioning. 1. Structure Your Spreadsheet

✅ 3. Graphical Output

• A bar chart showing proportion of each material (cement, water, CA, FA, air).

Part 9: Case Study – Designing a 4,000 psi Sidewalk Mix Using an Excel Sheet

Inputs:

• f’c = 4,000 psi, Slump = 4 in., Max agg size = ¾ in.
• CA SG=2.65, dry rodded density=100 lb/ft³, absorption=0.5%, moisture=2%
• FA SG=2.62, FM=2.7, absorption=0.8%, moisture=5% (wet sand)

Save the file

filename = "ACI_Concrete_Mix_Design.xlsx" wb.save(filename) print(f"✅ Excel file created: filename") print("Open the file and enter your material properties in the INPUT PARAMETERS section.") print("All calculations will update automatically (Excel formulas included).") aci concrete mix design excel sheet

1. Water-Cement Ratio ($w/c$): Should use Table 6.3.4(a) or (b) to select $w/c$ based on $f'c$, OR calculate required $w/c$ based on exposure limits (e.g., 0.45 for severe sulfate).
2. Water Content: Uses Table 6.3.3 to determine mixing water based on Slump and Max Aggregate Size.
3. Cement Content: Calculated as Water Content / (w/c ratio).
4. Coarse Aggregate Volume: Uses Table 6.3.6. This is the most critical step. It calculates the volume of dry-rodded coarse aggregate per unit volume of concrete based on the Fineness Modulus and Max Aggregate Size.

   : User-defined project requirements like target strength, exposure conditions, and material properties. ACI Reference Tables Building an ACI Concrete Mix Design Excel Sheet

   Professionally developed templates are available from various engineering communities and government bodies: A bar chart showing proportion of each material

   • Bulk/unit weights (oven-dry rodded unit weight or SSD unit weight)
   • Specific gravities of fine and coarse aggregates
   • Absorption percentages
   • Fineness modulus of sand (if required)