Download a practical BS 8500 / BRE DOE-style concrete mix design guide for UK projects — estimate water, cement, aggregate split, moisture correction, batch quantities and ready-mix specification notes for 2026.
Download the Free Concrete Mix Design Spreadsheet
Use this free XLSX workbook as a starting point for UK concrete mix design estimates, batching working and specification checks.
What you get in the workbook
The file includes a Start Here dashboard, editable measurements sheet, formula-driven Mix Design sheet, Batch Sheet, Reference Data tables and a Sources & Notes section. It determines target mean strength, water/cement ratio, cement content, total aggregate, fine/coarse aggregate split, moisture correction, admixture dosage and custom batch quantities.
What Is Included in the Free Concrete Mix Design Spreadsheet?
ThisFree Concrete Mix Design Spreadsheet UKis designed for builders, guides, students, site engineers and small contractors who need a practical way to understand concrete quantities before ordering, batching or discussing a design with a supplier. The workbook is not a replacement for a certified concrete technologist, structural engineer, laboratory trial mix, ready-mix supplier specification or the full British Standards, but it gives a strong starting point for ordinary UK concrete projects.
The spreadsheet is built around a simplifiedBS 8500 / BRE DOE-style workflow. You choose the strength class, exposure class, slump class, maximum aggregate size, aggregate density, cement density, fine/coarse aggregate split, moisture values, absorption values, admixture dosage and batch volume. The resource then determines the free water content, selected water/cement ratio, cement content, total aggregate, fine aggregate, coarse aggregate, moisture-adjusted batch water, admixture quantity and custom batch quantities.
The workbook has been created for 2026 website use. It includes source notes, editable reference tables and warning messages that remind users to verify final specifications against current BS 8500, BS EN 206, supplier data, project drawings and trial-mix test results. It is especially useful as a lead magnet or resource page for a UK construction guide site because users can download the spreadsheet and keep returning to the guide for specification notes.
Downloadable XLSX
Works as a practical Excel workbook with editable measurements, formulas, batch working and reference tables. Upload it to WordPress and link it from this page.
BRE DOE-Style Logic
Uses the familiar sequence of strength target, water demand, water/cement ratio, cement content and aggregate working by volume.
BS 8500 Notes
Includes strength classes, exposure class prompts, minimum cement guidance and practical specification warnings for UK concrete projects.
Spreadsheet sheets included
- Start Here:a dashboard showing the selected strength class, exposure class, target strength, w/c ratio, cement content, aggregate quantities and specification string.
- measurements:editable user measurements for project name, specification route, strength class, exposure class, slump, aggregate size, cement type, densities, moisture correction and batch volume.
- Mix Design:formula-driven material figure per cubic metre including water, cement, fine aggregate, coarse aggregate, admixture and design checks.
- Batch Sheet:converts the per-m³ mix into common site batch sizes such as 0.10m³, 0.20m³, 0.50m³ and any custom volume entered by the user.
- Reference Data:editable strength classes, exposure limits, water demand table and design checklist.
- Sources & Notes:plain-text URLs and assumptions so users know what must be verified before real construction use.
Important limitation
The spreadsheet gives an indicative mix. Final structural concrete must be specified by a competent person and confirmed by the ready-mix supplier or laboratory. A spreadsheet cannot confirm aggregate grading, cement compatibility, chloride class, sulphate class, DC class, admixture performance, pumpability, curing behaviour or 28-day cube strength.
BS 8500 Concrete Specification Guide for 2026
BS 8500is the UK complementary British Standard to BS EN 206. In practical terms, it helps specifiers choose and describe concrete for UK conditions. It deals with strength class, exposure class, consistence, aggregate size, cement type, intended working life, chloride class and other durability issues that affect whether concrete will perform properly in the environment where it is placed.
For normal building work, the most common mistake is to think that a strength class alone is enough. It is not. A specification such as “C25 concrete” may be too vague because it does not tell the supplier the exposure class, slump, maximum aggregate size, chloride class, cement type or whether the concrete is designed, designated or prescribed. A better specification might identify a strength class such as C25/30, an exposure class such as XC2, a consistence class such as S3, a maximum aggregate size such as 20mm and any project-specific requirements for sulphate resistance, pumpability or finish.
BS 8500 also matters because concrete durability is often governed by environment rather than strength. A slab inside a dry building, a foundation in wet ground, an external driveway exposed to freezing and de-icing salts, and a marine splash-zone structure may all need very different water/cement ratios and cement contents even if the structural strength looks similar.
Official standards to check
Use the official BSI pages forBS 8500-1:2023andBS 8500-2:2023, plus practical industry guidance fromThe Concrete Centre. Standards pages can change, so always verify the current edition before using values on a live project.
Common specification routes in BS 8500
- Specification Route: Designed Concrete; What It Means: Concrete is specified by required performance such as strength, exposure class and consistence.; Typical Use: Structural concrete, reinforced concrete, durability-led work.; Risk / Responsibility: Producer designs mix
- Specification Route: Designated Concrete; What It Means: Standard UK designations such as GEN, RC, FND and PAV are used for common applications.; Typical Use: House foundations, slabs, drives, domestic and small commercial work.; Risk / Responsibility: Good for standard uses
- Specification Route: Prescribed Concrete; What It Means: Specifier states the exact mix proportions or material quantities.; Typical Use: Small jobs, site batching, specialist heritage or non-standard work.; Risk / Responsibility: Specifier carries more risk
- Specification Route: Standardized Prescribed Concrete; What It Means: Predefined standard recipes for simple applications.; Typical Use: Small non-critical work where exact performance design is not needed.; Risk / Responsibility: Limited scope
- Specification Route: Proprietary Concrete; What It Means: Supplier-owned mix for a defined performance or branded use.; Typical Use: Self-compacting, waterproof, fibre, low-carbon or rapid-strength concrete.; Risk / Responsibility: Check data sheets
How the BRE DOE Concrete Mix Design Method Works
TheBRE DOE concrete mix design methodis a widely used British approach for designing normal concrete mixes. It starts with a required strength, estimates a target mean strength, selects an appropriate water/cement ratio, estimates free water content based on workability and aggregate size, determines cement content, and then balances the remaining volume using aggregates. The spreadsheet follows that sequence in a simplified form suitable for estimation, learning and early-stage checking.
The key idea is that concrete is not designed by random “1:2:4” ratios when performance matters. Instead, the designer considers the required strength, durability exposure, workability, aggregate grading, cement type, water demand and measured material properties. The mix is then adjusted through trial batches and test results until it meets the required fresh and hardened properties.
The official BRE publication is still the proper reference for the method, particularly where statistical margin, standard deviation, aggregate grading curves, cement type effects, pulverised-fuel ash, GGBS and detailed trial-mix corrections are important. This page and spreadsheet simplify the method for practical website use, but they repeatedly flag where professional verification is required.
Target Strength
Start with characteristic cube strength and add a margin so the average mix is safely above the minimum required strength.
Water/Cement Ratio
Select a w/c ratio that satisfies both strength and durability. Exposure class can be more restrictive than strength alone.
Absolute Volume
After water, cement and air are accounted for, the remaining volume is filled by fine and coarse aggregate.
Core formulas used in the spreadsheet
- Target mean strength:characteristic cube strength + design margin.
- Cement content:free water content divided by selected water/cement ratio, checked against minimum cement content.
- Total aggregate:remaining absolute volume after subtracting water, cement and air volume.
- Fine aggregate:total aggregate multiplied by selected fine aggregate percentage.
- Coarse aggregate:total aggregate minus fine aggregate.
- Moisture correction:surface moisture and absorption are used to adjust batch water and aggregate mass.
Trial mix still required
No spreadsheet can prove final concrete performance. A real mix must be checked by trial batch, consistence testing, density checks, cube testing and supplier quality-control procedures. For structural or durability-critical work, consult a concrete technologist, structural engineer or accredited ready-mix supplier.
Example Concrete Mix Design figures
The examples below show how different UK concrete applications can change the specification route, strength class, exposure risk and quality-control requirement. These are indicative examples only. Your project drawings, ground conditions, reinforcement design, exposure class, sulphate class, chloride class and supplier recommendations must take priority.
- Project Type: House footing / strip foundation; Indicative Class: C25/30 or FND concrete; Key Design Driver: Ground conditions, sulphate class, depth and width; Spreadsheet Use: Estimate cement and aggregate quantities for learning or planning; Professional Check: Ground + Building Control
- Project Type: Internal ground-bearing slab; Indicative Class: C20/25 to C25/30; Key Design Driver: Loading, DPM, curing and finish; Spreadsheet Use: Estimate general mix and batch quantities; Professional Check: DPM + curing
- Project Type: Reinforced suspended slab; Indicative Class: C30/37 or engineer specified; Key Design Driver: Structural design and reinforcement cover; Spreadsheet Use: Understand material proportions only; Professional Check: Engineer required
- Project Type: Driveway / external pavement; Indicative Class: PAV or C30/37+; Key Design Driver: Freeze/thaw, de-icing salts and abrasion; Spreadsheet Use: Check workability and approximate material balance; Professional Check: Air + finish
- Project Type: Marine or chloride exposure; Indicative Class: Designed concrete; Key Design Driver: Chloride ingress and low permeability; Spreadsheet Use: Not enough on its own; use only for education; Professional Check: Specialist design
Best practice for 2026 projects
For projects with embodied-carbon targets, ask suppliers for Environmental Product Declarations, cement combination options, GGBS or limestone/calcined clay combinations where appropriate, and clear cradle-to-gate carbon information. Lower-carbon concrete should still meet the same strength, durability and curing requirements as a conventional mix.
Low-Carbon Concrete and Mix Design in 2026
Concrete specification in 2026 is increasingly influenced by embodied carbon. This does not mean choosing the weakest or cheapest mix. It means avoiding over-specification, using the correct exposure class, choosing efficient cement combinations, and allowing realistic curing and strength-gain times where the programme permits. A lower-carbon mix can still fail if it is badly cured, placed with excess water, incorrectly finished or used in the wrong exposure condition.
The free spreadsheet includes a cement replacement percentage measurement to help users think about binder combinations, but it does not work out verified carbon values. Carbon assessment requires supplier-specific Environmental Product Declarations or project-specific data. Two concretes with the same strength class can have different carbon footprints depending on cement type, cement content, aggregate source, transport distance, admixtures and production method.
From a specification point of view, the most sustainable concrete is the lowest-impact concrete that still meets every structural, durability, fire, construction and service-life requirement. Over-designing every slab as a high-strength mix can waste cement. Under-designing a mix can cause premature repair, replacement and higher whole-life carbon. The right answer is a balanced specification.
How to Use the Spreadsheet Safely
Start with the project drawings and specification. Do not guess the required strength class or exposure class from a blog article. If the engineer, architect or ready-mix supplier has already specified a concrete designation, enter that information first. If you are only planning an early budget, use the spreadsheet to compare approximate quantities and understand why water, cement and aggregate numbers move when workability or exposure changes.
Next, enter realistic material data. Relative density, aggregate moisture and absorption can change actual batch quantities. Wet sand can add a surprising amount of water to a mix. If site workers then add extra water “to make it easier,” the real water/cement ratio can rise beyond the durability limit. That is one of the most common reasons site-batched concrete underperforms.
Finally, review the design checks. If the selected water/cement ratio is higher than the exposure limit, or if cement content is below the minimum, the mix should not be used as-is. Adjust water demand, cement content, admixture strategy, slump expectation or ask the supplier for a designed concrete mix that meets the required class.
- Use the workbook for estimating, learning and internal checking.
- Use official standards and supplier data for final specification.
- Do not add uncontrolled site water to ready-mix or site-mixed concrete.
- Record cement type, aggregate source, admixture and batch proportions.
- Carry out trial mixes and cube tests where strength performance matters.
- Check curing requirements, especially in hot, cold, windy or dry weather.
- Confirm sulphate class and aggressive ground conditions for foundations.
This Spreadsheet Is a Design Aid — Not a Certified Concrete Specification
Use it to understand quantities and check assumptions. Final concrete mixes must be verified against BS 8500, BS EN 206, project drawings, supplier data, trial batches, testing and competent professional advice.
Free Concrete Mix Design Spreadsheet — FAQ
Common questions about using a UK BS 8500 / BRE DOE-style concrete mix design spreadsheet in 2026.
It is suitable for estimating and learning, but not as a final structural specification by itself. Structural concrete must be specified by a competent person and verified through the project specification, BS 8500 / BS EN 206 requirements, ready-mix supplier data, trial mixes and cube tests. The spreadsheet helps you understand the mix logic; it does not certify the concrete.
Yes. The workbook includes common strength classes such as C20/25, C25/30, C30/37, C32/40, C35/45 and C40/50. These are starting points only. Higher strength and more aggressive exposure classes need careful checking of water/cement ratio, cement content, aggregate quality, curing and test data.
No spreadsheet can automatically prove full compliance because BS 8500 specification depends on more than a few visible measurements. You may need chloride class, DC class, sulphate class, intended working life, cement combination, aggregate limits, conformity data and project-specific requirements. This workbook provides a structured estimating workflow and prompts users to verify those items.
A simple ratio mix is a rough recipe. BRE DOE-style design is performance-led: it considers target strength, water demand, water/cement ratio, cement content, aggregate properties and trial mix adjustment. For anything structural or durability-sensitive, performance-led design is much safer than relying on a traditional volume ratio.
Wet aggregate can add water to the concrete mix. If that water is not deducted from the batch water, the real water/cement ratio increases. Higher w/c ratio can reduce strength, increase permeability and harm durability. That is why the spreadsheet includes fine and coarse aggregate moisture and absorption measurements.
For structural and larger pours, ready-mix from a quality-assured supplier is usually more reliable than site batching because the producer controls materials, mixing, batching accuracy and conformity procedures. Site batching may be acceptable for small, non-critical jobs, but it needs careful measuring and moisture control.
It can help you understand cement content and replacement percentage, but it does not work out verified embodied carbon. For low-carbon concrete, ask suppliers for Environmental Product Declarations, cement combination options and project-specific carbon data. Never reduce cement content below durability requirements just to lower carbon.
Related UK Concrete Guides & Guides
Use these related resources with the mix design spreadsheet to estimate volume, batch quantities, supplier options and specification requirements.
For related concrete mix design and proportion working, see MixDesignCalc.xyz.