EC2-1-1 RC Design Excel Toolkit (v3.2)
The EC2-1-1 RC Design Excel Toolkit (v3.2) is a specialized, standards-compliant spreadsheet-based software tool developed to automate and verify reinforced concrete structural design in accordance with Eurocode 2: Design of Concrete Structures — Part 1-1 (EN 1992-1-1:2004+A1:2014). It integrates material models, section analysis, ultimate and serviceability limit state checks, and code-prescribed safety factors into an organized, transparent, and auditable Excel environment. The toolkit supports both metric units and common European design conventions, enabling rapid iterative design and educational validation of RC elements.
📖 Overview
📑 Key Components
🎯 Applications
- ✓ Preliminary and detailed design of RC beams, slabs, and columns in building structures
- ✓ Academic teaching and verification of EC2-1-1 compliance in university coursework
- ✓ Peer review and independent checking of commercial software outputs
📐 Key Formulas
Design Concrete Compressive Strength
f_cd = α_cc × f_ck / γ_C
Calculates the design compressive strength of concrete, where α_cc is the long-term effects coefficient (typically 0.85), f_ck is the characteristic cylinder strength (MPa), and γ_C is the partial safety factor for concrete (typically 1.5).
Moment Resistance of Rectangular Section
M_Rd = f_yd × A_s × (d − 0.4×x) where x = (f_yd × A_s) / (0.8×f_cd × b)
Computes the ultimate moment resistance of a singly reinforced rectangular concrete section under bending, based on equilibrium and strain compatibility assumptions per EC2 §6.1.
Crack Width (Effective Strain Method)
w_k = s_{r,max} × (ε_sm − ε_cm)
Estimates characteristic crack width using maximum crack spacing (s_r,max) and difference between mean strain in reinforcement and concrete (ε_sm − ε_cm), per EC2 §7.3.4.