Aci Concrete Mix Design Excel Sheet Jun 2026
Based on ACI Table 6.3.1 (for reinforced foundations, walls, slabs). Excel uses a lookup table to suggest a slump range.
). The remaining volume is assigned to the fine aggregate, which is then converted back to weight using its specific gravity. 8. Adjustments for Aggregate Moisture
Excel sheets serve as a living document of the design process. Every input, intermediate value, and final proportion is visible and can be traced, creating a clear and auditable record. This is invaluable for quality control, project submission, and peer review. Furthermore, a sheet can be set up to perform sensitivity analyses or "what-if" scenarios. For instance, a user can instantly see the impact of changing the target slump on the final mix proportions.
Take the time to spot-check a few of the sheet's manual calculations against a known example from a textbook or ACI publication. This verification step builds confidence that the sheet is functioning correctly. aci concrete mix design excel sheet
Ensures all mix designs follow the same ACI guidelines.
), slump, max aggregate size, air entrainment requirement, fine aggregate fineness modulus (FM), specific gravities, and field moisture percentages.
The w/c ratio is determined by either the required compressive strength at 28 days or durability constraints (such as sulfate exposure). Based on ACI Table 6
Excel Implementation: Matrix lookup from ACI Table 6.3.6. The spreadsheet calculates:
Weight of Coarse Aggregate=Bulk Volume×Dry-Rodded Unit Weight (DRUW)Weight of Coarse Aggregate equals Bulk Volume cross Dry-Rodded Unit Weight (DRUW) 7. Estimation of Fine Aggregate Content
The sheet uses lookup tables to find the approximate water requirement (e.g., pounds per cubic yard or kg per cubic meter) and expected entrapped air percentage, based on the slump, NMAS, and air-entrainment choice. The remaining volume is assigned to the fine
The Ultimate Guide to ACI Concrete Mix Design Excel Sheet (ACI 211.1)
Creates clean, professional submittal sheets for client or regulatory approvals. Step-by-Step ACI 211.1 Mix Design Methodology
When developing or downloading a trial verification sheet, ensure it follows clean design parameters to protect data integrity: