Finalize field weights by adjusting for the actual moisture content of aggregates (subtract surface moisture from mixing water and add it to aggregate weights). Public Resource Key Spreadsheet Features
: Automated formulas that determine the absolute volume of each ingredient and adjust for aggregate moisture. The 9-Step Design Procedure aci concrete mix design excel sheet
=IF(MC > Abs, DesignWater - (AggWeight * (MC - Abs)), DesignWater + (AggWeight * (Abs - MC))) Finalize field weights by adjusting for the actual
$$V_Total = V_Water + V_Cement + V_Air + V_Coarse + V_Fine$$ Coarse Aggregate Factor (from ACI Table 6
ws.cell(row=row, column=1, value="4. Coarse Aggregate Factor (from ACI Table 6.3.6)").font = subheader_font ws.cell(row=row, column=2, value="vol/vol") fm_input = 'B18' # Fineness modulus ca_factor = 'IF(AND(B6>=0.75, B6<=1), 0.68, IF(B6=1.5, 0.67, 0.7))' # simplified ws.cell(row=row, column=3, value="Formula based on NMAS & FM") ws.cell(row=row, column=4, value=ca_factor) row += 1
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