| A | B | C | D | |---|---|---|---| | | Value | Unit | Formula/Reference | | Required f'c | 4000 | psi | Input | | Slump | 3 | in | Input | | NMAS | 1 | in | Input | | Water (ACI table) | 340 | lb/yd³ | =VLOOKUP(...) | | w/c ratio | 0.48 | – | Input | | Cement | 708 | lb/yd³ | =B5/B6 | | CA weight (SSD) | 1850 | lb/yd³ | =SG_ca*62.4*CA_vol | | FA weight (SSD) | 1350 | lb/yd³ | =(27 - sum_volumes)*SG_fa*62.4 | | Total weight (SSD) | 4250 | lb/yd³ | =SUM(...) |
Formulas that compute water-cement ratio, total water, coarse aggregate amount, and air content based on standard ACI tables .
The ACI method is an , widely accepted for its logical simplicity and its applicability to various materials, including lightweight aggregates and air-entrained concrete . The procedure is traditionally broken down into eight distinct steps . A robust Excel sheet is designed to seamlessly walk a user through each of these steps, which are: aci concrete mix design excel sheet
Run the script, then simply edit the input cells in Excel – all formulas will recalculate automatically.
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. | A | B | C | D
Open the Excel sheet and navigate to the “Input” section. You will see fields such as:
The ACI code provides two methods for determining $w/c$: (Table 6.3.4(a)) or Durability-based (Table 6.3.4(b)). A robust Excel sheet calculates both and selects the governing value using a logical test: A robust Excel sheet is designed to seamlessly
Embedded ACI table values and formulas that transform inputs into volumes.
– it generates an Excel file named ACI_Concrete_Mix_Design.xlsx .