The core calculation to ensure total volume equals 1 ydĀ³ or 1 mĀ³.
At this stage, the weights of water, cement, and coarse aggregate are known. The remaining volume belongs to the fine aggregate (sand). Excel calculates this using the :
Determine the required workability for the specific "piece" or structural element being cast. aci concrete mix design excel sheet
A comprehensive Excel tool for ACI mix design should include:
Calculate the w/c ratio based on the compressive strength requirement and durability (e.g., exposure to freezing/thawing). 5. Calculation of Cement Content The core calculation to ensure total volume equals
| Parameter | Manual Calc | Excel Sheet | Deviation | |-----------|-------------|-------------|-----------| | Water (lb/ydĀ³) | 305 | 305 | 0% | | Cement (lb/ydĀ³) | 678 | 678 | 0% | | Coarse agg (SSD) | 1850 | 1852 | +0.1% | | Fine agg (SSD) | 1265 | 1262 | -0.2% | | Yield (ftĀ³) | 27.0 | 27.02 | Acceptable |
Verdict: Matches manual ACI method within rounding tolerance. Excel calculates this using the : Determine the
Cement Weight=Weight of Waterw/cm ratioCement Weight equals the fraction with numerator Weight of Water and denominator w / c m ratio end-fraction Step 6: Estimation of Coarse Aggregate Content
ws.cell(row=row, column=2, value="Water (Unadjusted)") ws.cell(row=row, column=3, value=formula_water) ws.cell(row=row, column=4, value="=D3") # placeholder actual value ws.cell(row=row, column=4).fill = result_fill row += 1
This is where you define the raw ingredients you are working with. You should be able to input: Type and Specific Gravity (usually around Water: Specific Gravity (
Total moisture content and absorption capacity percentage for both aggregate types. Reference Tables Zone (Hidden or Locked Sheet)