Concrete Durability and Strength Calculator Spreadsheet: BRE 2nd Edition (Excel Tool)

Facing GGBS or Fly Ash shortages? Stop wasting weeks on failed laboratory trial mixes.

Designing durable concrete with 100% Ordinary Portland Cement (OPC) feels like walking a tightrope. Without SCMs, passing strict project specifications for Rapid Chloride Permeability, Water Absorption, and Chloride Migration usually means endless trial batches, inflated lab testing costs, and severe project delays. Guesswork in your w/c ratio or aggregate packing can cost your plant thousands in rejected mix designs.

The Solution & Convenience:
The 100% OPC Concrete Durability & Performance Calculator puts full quality control right at your fingertips. Built on the trusted BRE 2nd Edition design method, this template instantly evaluates your mix proportions against global standards (ASTM, BS, and EN).

Input your raw material data & concrete mixture parameters, and the spreadsheet automatically calculates predicted durability and compressive strength values at 28 days:

✅️RCP (ASTM C1202) – Rapid Chloride Permeability
✅️WA (BS 1881-122) – Water Absorption %
✅️WP (BS EN 12390-8) – Water Permeability Depth (mm)
✅️CMT (NT BUILD 492) – Chloride Migration Coefficient
✅️Compressive Strength Curves & Combined Aggregate Grading Envelopes

Also, includes:
✅️Dynamic Aggregate Grading Graph: Interactive sieve analysis chart (0.063 mm to 63.0mm) plots lower/upper envelope limits according to BS EN 12620 / PD 6682-1.
✅️Smart Moisture & Batching Engine: Automatically converts saturated surface-dry (SSD) weights into real batch weights based on aggregate moisture and water absorption.
✅️ Integrated Trial Mix Form Tab: Dedicated trial batching worksheet linked directly to adjusted batch weights for seamless laboratory batching.
✅️Client Submittal Layout: Professional template pre-formatted with dedicated fields for mix codes, project logos, contractor details, and consultant reviews
​✅️ FREE Guidebooks
✅️ Compatible with Excel 2010 onwards / Mac and PC.

Transform your workflow from risky trial-and-error to instant, data-backed confidence. Before casting a single physical cube sample, know exactly whether your mix design will PASS or FAIL. Save valuable lab time, optimize paste volumes, and submit ready-to-approve mix proportions directly to project consultants.

Digital simplicity, professional engineering accuracy, and complete peace of mind—all on your tablet, laptop, or desktop.

📲 Download yours today!

Design Concrete Smarter, not Harder!

​⚠️ Terms of Use & Licensing (Please Read)
Your purchase of this digital item constitutes your agreement to the following terms.

​🔒 Professional & Internal Business Use License:
✅️ Your purchase grants you a license for use within your personal capacity or for your Professional/Business operations (i.e., managing client projects, internal team use, etc.). Use your Company/Business Logo with minor modifications to suit your needs/wants.

​⛔️ What You CANNOT Do (Strictly Prohibited):
​❌️ Sharing: You may NOT share, distribute, email, or upload the files to any public or private platform, website, marketplace, or file-sharing group.
​​❌ Strict Prohibition on Resale & Distribution: You may NOT resell, redistribute, sub-license, or transfer the original file or a modified version of the template itself.
​❌️ The template cannot be the product you sell. You may use it to deliver a service or manage your business, but you cannot sell it to clients or others as a standalone template.
​❌️ Claiming Ownership: You may NOT claim ownership, remove any existing branding, or redistribute the template as your own.
​Note: The templates remain the intellectual property of ConcretebyCesar.

​💻 Product & Purchase Policy:
▪️​Digital Product Only: This is a DIGITAL DOWNLOAD; no physical items will be shipped. Please ensure you download and save your files immediately after purchase.
​▪️All Sales Final: Due to the nature of digital files, all purchases are non-refundable and non-exchangeable. However, if you have any issues downloading or using the file, please contact me for assistance!
​▪️Customization: I offer a one-time minor revision/customization per purchase. Please message me to discuss your needs.

​🔴 Disclaimer & Terms of Use

1. Engineering & Informational Purpose Only: This calculation tool and digital template (the "Tool") are developed solely for preliminary mix design optimization, internal quality control, and predictive estimation. The algorithms and models embedded within this Tool are based on empirical laboratory trial data, statistical correlations, and over ten (10) years of practical field and laboratory experience in concrete technology.

2. No Regulatory or Third-Party Endorsement: This Tool is an independent engineering utility. It is not officially endorsed by, affiliated with, or certified by any standardizing body, regulatory authority, or international testing organization (including, but not limited to, ASTM, BS, EN, ISO, AASHTO, or local Ministry standards). Calculated outputs do not constitute formal compliance certificates or legal guarantees of performance.

3. Laboratory & Site Verification Required: Concrete durability performance—including Rapid Chloride Permeability (RCP), Water Absorption (WA), Water Permeability (WP), and Chloride Migration Transport (CMT)—is heavily influenced by local raw material properties (e.g., aggregate geology, cement chemistry, admixture compatibility), batching accuracy, placing, compaction, and curing conditions.
The outputs generated by this Tool are intended to serve as a predictive guideline to minimize trial-and-error laboratory batches.
This Tool does not replace formal project trial mixes or mandatory third-party laboratory testing required by project specifications.

4. Limitation of Liability: The creator and seller of this Tool shall not be held liable for any direct, indirect, incidental, or consequential damages, financial losses, project delays, mix rejections, or structural failures arising from the use, misuse, or reliance upon the predictions generated by this software. The end user (Quality Control Manager, Technical Director, or Concrete Engineer) retains full professional responsibility for verifying, testing, and approving all mix designs prior to commercial batching and structural placement.

▪️ConcretebyCesar is not responsible for errors or issues arising from the improper modification or use of the templates by the user.
▪️Concrete By Cesar Digital products are professional-grade engineering aids. While our calculations are meticulously developed based on ACI, ASTM, BRE, BS EN standards, they are intended for use by qualified professionals. The ultimate responsibility for the accuracy of input data, successful application, and final compliance with project specifications and local building codes rests solely with the user.

Thank you!