(Note: Multiplied by 27 if working in cubic yards, or adapted to cubic meters depending on the unit system). 7. Estimation of Fine Aggregate Content
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.
To build or effectively use an ACI mix design Excel sheet, you must understand the sequential engineering steps the spreadsheet automates. 1. Choice of Slump
Program a "sanity check" cell that adds up the total absolute volumes of all components. If the sum does not equal exactly (for a cubic yard) or (for a cubic meter), the cell should flag an error. Share public link aci concrete mix design excel sheet
Cement Weight equals the fraction with numerator Water Content and denominator W/C Ratio end-fraction Coarse Aggregate Volume:
ACI determines the bulk volume of coarse aggregate per unit volume of concrete based on the nominal maximum size of the aggregate and the fineness modulus of the fine aggregate (sand).
Manual concrete mix design involves referencing multiple tables, performing iterative volume calculations, and adjusting for aggregate moisture. Using an Excel template offers several key advantages: (Note: Multiplied by 27 if working in cubic
ws.cell(row=row, column=1, value="Coarse Aggregate Correction (lb/yd³)") ws.cell(row=row, column=2, value="=D10*(B16-B14)/100") ws.cell(row=row, column=3, value="Adjustment") row += 1 ws.cell(row=row, column=1, value="Fine Aggregate Correction (lb/yd³)") ws.cell(row=row, column=2, value="=D21*(B17-B15)/100") row += 1 ws.cell(row=row, column=1, value="Water Adjustment (lb/yd³)") ws.cell(row=row, column=2, value="=-(B25+B26)") row += 1 ws.cell(row=row, column=1, value="Adjusted Water (lb/yd³)") ws.cell(row=row, column=2, value="=D3+B27") row += 1 ws.cell(row=row, column=1, value="Adjusted CA Weight (lb/yd³)") ws.cell(row=row, column=2, value="=D10+B25") row += 1 ws.cell(row=row, column=1, value="Adjusted FA Weight (lb/yd³)") ws.cell(row=row, column=2, value="=D21+B26") row += 2
Excel Implementation: Matrix lookup from ACI Table 6.3.6. The spreadsheet calculates:
An effective ACI mix design Excel sheet automates these manual steps to reduce errors and save time. Key components typically include: Input Section This link or copies made by others cannot be deleted
ACI 211.1 Table 6.3.3 provides the approximate mixing water requirements based on the chosen slump, aggregate size, and whether the concrete is air-entrained or non-air-entrained. Air entrainment is vital for concrete exposed to freeze-thaw cycles. 4. Selection of Water-Cement ( The target compressive strength ( fc′f sub c prime ) determines the ratio. If durability requirements dictate a lower
If you are developing your own spreadsheet, organizing the data structure is critical for maintainability and accuracy. Essential Input Fields
An is more than a convenience – it is a necessity for any concrete professional who values accuracy, efficiency, and documentation. By automating the 211.1 method, you reduce errors, speed up trial batches, and gain confidence that your concrete will perform as intended on site.
Enter your email address so we can save the contents of your basket for you.