Free Concrete Mix Design Calculator
Professional Excel Template for Mix Design Calculations
Our Mix Design Spreadsheet is a comprehensive Excel template designed for concrete professionals, engineers, and contractors. This free downloadable tool simplifies concrete mix design calculations following BS EN 206 standards and industry best practices in 2026.
The spreadsheet automates complex calculations for water-cement ratio, aggregate proportions, cement content, and workability requirements. Whether you're designing concrete mixes for residential, commercial, or infrastructure projects, this tool ensures accuracy and compliance with Concrete Society guidelines.
Free Excel template for concrete mix design calculations
File Type: Microsoft Excel (.xlsx)
File Size: ~850 KB
Version: 2026 Edition
Compatible: Excel 2016 and later, Google Sheets
License: Free for personal and commercial use
No registration required • Instant download • Regular updates
Our Mix Design Spreadsheet includes comprehensive tools and automatic calculations that streamline the concrete mix design process. The template is pre-formatted with all necessary formulas and validation rules.
All formulas pre-built for water-cement ratio, aggregate proportions, and mix quantities
Templates for standard concrete, high-strength, lightweight, and specialized mixes
Follows UK and European standards for concrete specification and production
Built-in checks ensure input values are within acceptable ranges
Professional formatted output suitable for documentation and approval
Easy modification tools for adjusting mixes based on trial batch results
The Mix Design Spreadsheet contains multiple worksheets covering all aspects of concrete mix design from initial calculations to final proportioning and quality control.
Target Strength: Input characteristic strength (fck)
Cement Type: CEM I, CEM II, CEM III options
Aggregate Types: Coarse and fine aggregate specifications
Water-Cement Ratio: Automatic calculation based on strength requirements
Outputs: Complete mix proportions in kg/m³
Cement Data: Specific gravity, strength classes, setting times
Aggregate Properties: Bulk density, specific gravity, absorption
Admixtures: Water reducers, plasticizers, retarders
Supplementary Materials: Fly ash, GGBS, silica fume
Pre-filled Values: Common UK material properties included
Slump Target: Define required consistency class
Water Content: Calculate free water requirements
Admixture Dosage: Determine plasticizer quantities
Consistence Classes: S1 to S5 slump classes
Adjustments: Automatic recalculation for changes
Sieve Analysis: Input grading data for aggregates
Fineness Modulus: Automatic calculation
Combined Grading: Calculate blended aggregate proportions
Zone Classification: Determine sand grading zone
Charts: Visual representation of grading curves
Test Results: Input trial batch performance data
Strength Adjustment: Modify mix for target strength
Workability Correction: Adjust water and admixtures
Yield Calculation: Verify actual vs theoretical yield
Iteration Tracking: Record all mix modifications
Material Prices: Input current market rates
Cost per m³: Calculate total mix cost
Batch Costing: Cost analysis for different volumes
Comparison: Compare multiple mix options
Currency: Default GBP £ with customization option
Follow this step-by-step guide to complete your concrete mix design using the spreadsheet. The template guides you through each calculation phase with clear instructions and validation.
✅ Step-by-Step Guide:
⚠️ Before Using the Spreadsheet:
The spreadsheet incorporates requirements from British Standards, European Norms, and industry best practices ensuring your mix designs meet all regulatory requirements for UK construction projects in 2026.
📋 Standards Incorporated:
Reference table showing typical concrete mix designs for various applications. Use these as starting points and adjust based on specific project requirements and local materials.
| Concrete Grade | Cement (kg) | Water (litres) | Fine Agg (kg) | Coarse Agg (kg) | W/C Ratio |
|---|---|---|---|---|---|
| C20/25 (Gen 3) | 300 | 180 | 720 | 1100 | 0.60 |
| C25/30 (RC25) | 340 | 170 | 700 | 1090 | 0.50 |
| C30/37 (RC30) | 380 | 165 | 680 | 1075 | 0.43 |
| C35/45 (RC35) | 420 | 160 | 660 | 1060 | 0.38 |
| C40/50 (RC40) | 450 | 155 | 640 | 1050 | 0.34 |
| C45/55 (RC45) | 480 | 150 | 625 | 1035 | 0.31 |
| C50/60 (RC50) | 510 | 145 | 605 | 1020 | 0.28 |
Professional spreadsheet tools offer significant advantages over manual calculations for concrete mix design, improving accuracy, efficiency, and documentation quality.
Complete mix designs in 10-15 minutes versus 1-2 hours for manual calculations. Automatic formulas eliminate repetitive arithmetic and reduce design time by 80%.
Pre-validated formulas and data checks prevent calculation errors. Built-in warnings flag unrealistic values before they cause problems in production.
Standardized format ensures all mix designs follow the same methodology. Multiple engineers produce identical results from the same inputs.
Professional formatted output suitable for quality records, client submissions, and regulatory approval. Complete audit trail of all design decisions.
Instantly see effects of changing any parameter. Optimize mixes by testing multiple scenarios in minutes rather than hours.
Embedded guidance and tooltips help less experienced engineers. Built-in standards references provide learning opportunities.