), required slump (workability), and exposure conditions (e.g., air-entrained for freeze-thaw). Material Properties: Type (e.g., Type I, II) and specific gravity. Coarse Aggregate:
If adding supplementary cementitious materials (SCM), the Excel sheet must adjust the cement volume calculation by accounting for the lower specific gravity of fly ash (typically ~2.3) compared to Portland cement (~3.15).
(if not already installed):
Determine the required workability based on the type of construction (e.g., heavily reinforced walls vs. simple slabs). aci concrete mix design excel sheet
Ensures every engineer or technician in your organization follows the exact same ACI 211.1 protocol.
ws.cell(row=row, column=1, value="Fine Aggregate Weight (SSD)") ws.cell(row=row, column=2, value="lb/yd³") ws.cell(row=row, column=3, value="=D19 B8 62.4") ws.cell(row=row, column=4).fill = result_fill row += 2
ACI Concrete Mix Design Excel Sheet: Comprehensive Guide and Free Tools ), required slump (workability), and exposure conditions (e
Don't forget to account for air entrainment, even in non-air-entrained concrete (usually 1-2%). Conclusion
Are you looking to integrate (like plasticizers or air-entrainers) or pozzolans (like fly ash or slag) into the design?
: Divide the estimated water content (Step 3) by the W/C ratio (Step 4). Coarse Aggregate Content ("Coarse Aggregate (wet)"
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
The spreadsheet must subtract absorption weight from the aggregate batch weights and add it to the mixing water. 3. Designing Your Excel Workbook Architecture
The sheet should clearly translate the volumetric fractions into practical, usable weights for the batch plant operator. It should output: Weights for a 1-cubic-meter (or 1-cubic-yard) batch.
import openpyxl from openpyxl.styles import Font, PatternFill, Alignment, Border, Side from openpyxl.utils import get_column_letter from openpyxl.formula import Tokenizer
[Net Mixing Water] = Design Water - [Dry Coarse Agg * (Moisture % - Absorption %)] - [Dry Fine Agg * (Moisture % - Absorption %)] 5. Best Practices for Developing Your Spreadsheet