The Excel sheet does all this in seconds. A manual re-check confirms accuracy.
The American Concrete Institute (ACI) provides a standardized, empirical method for this selection—specifically . While the manual calculations are straightforward, they are repetitive and highly susceptible to mathematical errors. Utilizing an automated Excel sheet streamlines this workflow, ensures accuracy, and saves engineering hours. Why Use an Excel Sheet for ACI Mix Design?
Excel references ACI Table 6.3.4(a) to find the required ratio for target strengths (e.g., 3000 psi, 4000 psi).
Group all primary variables into a single input block to keep the interface clean: Required compressive strength ( fc′f sub c prime ) at 28 days. Slump Requirement: Design slump in inches or millimeters.
Multiply the remaining volume by the specific gravity of the sand and the unit weight of water to find the dry weight of the fine aggregate. 8. Adjustments for Aggregate Moisture
Aggregates on a real job site are rarely in a bone-dry state; they contain surface moisture or absorb water. The Excel sheet requires inputs for total moisture content (%) and absorption capacity (%) for both aggregates. It then automatically:
The weights calculated in Steps 6 and 7 assume bone-dry aggregates. In practice, field aggregates contain moisture that alters the mix proportions:
If you need assistance setting up specific formulas, let me know you are using (US Customary or Metric) and if your project requires air-entrained concrete . Share public link
Based on MSA and FM of fine aggregate (Table 6.3.6).
The Excel sheet provides a theoretical mix. Always conduct lab trial mixes to verify slump and strength.