Mix Design Excel Sheet !!top!! | Aci Concrete
Technical White Paper: Development and Algorithmic Logic of an Automated Excel-Based Concrete Mix Design Tool (ACI 211.1-91)
Abstract The proportioning of concrete mixtures is a fundamental aspect of civil engineering, requiring iterative calculations to balance workability, strength, durability, and economy. While the American Concrete Institute (ACI) Committee 211 provides the standard "Normal, Heavyweight, and Mass Concrete" mix design methodology, manual application is prone to arithmetic error and time-consuming iteration. This paper explores the development of a robust Excel-based computational tool that automates the ACI 211.1-91 procedure. We examine the algorithmic translation of empirical tables, the handling of aggregate moisture correction, and the logic structure required for a dynamic mix design sheet.
Instant Adjustments: Easily update the mix for different slump requirements or aggregate moisture levels without restarting the entire process. aci concrete mix design excel sheet
What is ACI Concrete Mix Design?
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 Technical White Paper: Development and Algorithmic Logic of
ACI Mix Design Excel Sheet – Step-by-Step Structure
1. Input Section (User Data)
| Parameter | Symbol | Example Value | Unit | |-----------|--------|---------------|------| | Required compressive strength | f'c | 4000 | psi | | Required slump | Slump | 3 | inch | | Nominal max aggregate size | NMAS | 1 | inch | | Fine aggregate fineness modulus | FM | 2.8 | - | | Fine aggregate specific gravity | SG_fa | 2.65 | - | | Coarse aggregate specific gravity | SG_ca | 2.70 | - | | Cement specific gravity | SG_c | 3.15 | - | | Water-cement ratio (from table) | w/c | 0.48 | - | | Coarse aggregate dry-rodded unit weight | DRUW | 100 | lb/ft³ | | Fine aggregate absorption | Abs_fa | 1.2 | % | | Coarse aggregate absorption | Abs_ca | 0.8 | % | | Fine aggregate moisture content | MC_fa | 5.0 | % | | Coarse aggregate moisture content | MC_ca | 2.0 | % | | Air content (entrapped/entrained) | Air | 1.5 | % | We examine the algorithmic translation of empirical tables,