row += 2 ws.cell(row=row, column=1, value="MIX DESIGN CALCULATIONS").font = header_font ws.cell(row=row, column=1).fill = header_fill ws.merge_cells(start_row=row, start_column=1, end_row=row, end_column=4) row += 1
To create a functional Excel sheet, the theoretical steps above must be mapped to cell logic. The following sections detail the specific Excel functions required for a deep implementation. aci concrete mix design excel sheet
| Parameter | Symbol | Example Value | Unit | |-----------|--------|---------------|------| | Required compressive strength | f'c | 4000 | psi | | Required slump | Slump | 3 | inch | | Nominal max aggregate size | NMAS | 1 | inch | | Fine aggregate fineness modulus | FM | 2.8 | - | | Fine aggregate specific gravity | SG_fa | 2.65 | - | | Coarse aggregate specific gravity | SG_ca | 2.70 | - | | Cement specific gravity | SG_c | 3.15 | - | | Water-cement ratio (from table) | w/c | 0.48 | - | | Coarse aggregate dry-rodded unit weight | DRUW | 100 | lb/ft³ | | Fine aggregate absorption | Abs_fa | 1.2 | % | | Coarse aggregate absorption | Abs_ca | 0.8 | % | | Fine aggregate moisture content | MC_fa | 5.0 | % | | Coarse aggregate moisture content | MC_ca | 2.0 | % | | Air content (entrapped/entrained) | Air | 1.5 | % | row += 2 ws
When you download or build an ACI concrete mix design Excel sheet, look for these advanced features: When you download or build an ACI concrete
This section requires user input and acts as the constraint variables.