From ACI Table 6.3.6: based on FM of sand and max aggregate size.
For FM=2.6 and ¾ in. max → ~0.68 ft³ of CA per ft³ of concrete.
Excel calculates dry weight of CA = volume fraction × dry rodded density.
| Slump (in) | NMAS ½″ | ¾″ | 1″ | 1½″ | |------------|---------|----|----|-----| | 1–2 | 350 | 335 | 315 | 300 | | 3–4 | 385 | 365 | 340 | 325 | | 5–6 | 410 | 385 | 360 | 340 | aci concrete mix design excel sheet
You can run this script to create an interactive Excel workbook. The sheet includes all major steps: slump selection, max aggregate size, water requirement, w/cm ratio, cementitious content, coarse aggregate factor, fine aggregate by absolute volume, and adjustments for moisture. From ACI Table 6
import openpyxl
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter
from openpyxl.formula import Tokenizer
Once the weights are established, the sheet should calculate the Yield (volume of concrete produced per batch) and the Cement Factor. You can run this script to create an
In Excel, these act as sanity checks. If the Yield deviates significantly from 27 ft³ (1 cy), it indicates an error in the specific gravity inputs or volume logic.
Based on ACI Table 6.3.1 (for reinforced foundations, walls, slabs).
Excel uses a lookup table to suggest a slump range.
| Issue | Explanation |
|-------|-------------|
| No rheology feedback | Sheet cannot adjust for pumpability, segregation, or slump loss over time. |
| Static tables | ACI tables are average guidelines – local aggregates may require calibration. |
| Admixture interaction | Simple sheets ignore synergy between HRWR and retarders. |
| No air temperature correction | Does not adjust air entrainment for hot/cold concrete. |
| Overreliance risk | Users may skip lab trial batches, leading to job-site failures. |
From ACI Table 6.3.6: based on FM of sand and max aggregate size.
For FM=2.6 and ¾ in. max → ~0.68 ft³ of CA per ft³ of concrete.
Excel calculates dry weight of CA = volume fraction × dry rodded density.
| Slump (in) | NMAS ½″ | ¾″ | 1″ | 1½″ | |------------|---------|----|----|-----| | 1–2 | 350 | 335 | 315 | 300 | | 3–4 | 385 | 365 | 340 | 325 | | 5–6 | 410 | 385 | 360 | 340 |
You can run this script to create an interactive Excel workbook. The sheet includes all major steps: slump selection, max aggregate size, water requirement, w/cm ratio, cementitious content, coarse aggregate factor, fine aggregate by absolute volume, and adjustments for moisture.
import openpyxl
from openpyxl.styles import Font, PatternFill, Alignment, Border, Side
from openpyxl.utils import get_column_letter
from openpyxl.formula import Tokenizer
Once the weights are established, the sheet should calculate the Yield (volume of concrete produced per batch) and the Cement Factor.
In Excel, these act as sanity checks. If the Yield deviates significantly from 27 ft³ (1 cy), it indicates an error in the specific gravity inputs or volume logic.
Based on ACI Table 6.3.1 (for reinforced foundations, walls, slabs).
Excel uses a lookup table to suggest a slump range.
| Issue | Explanation |
|-------|-------------|
| No rheology feedback | Sheet cannot adjust for pumpability, segregation, or slump loss over time. |
| Static tables | ACI tables are average guidelines – local aggregates may require calibration. |
| Admixture interaction | Simple sheets ignore synergy between HRWR and retarders. |
| No air temperature correction | Does not adjust air entrainment for hot/cold concrete. |
| Overreliance risk | Users may skip lab trial batches, leading to job-site failures. |