📦 Resource excel

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

The EC2-1-1 RC Design Excel Toolkit (v3.2) implements the fundamental design philosophy of Eurocode 2—limit state design—with explicit separation between Ultimate Limit State (ULS) and Serviceability Limit State (SLS) verifications. It embeds key EC2 provisions such as the parabolic-rectangular stress block for concrete, design strengths (f_cd = α_cc·f_ck/γ_C), and steel constitutive models (bilinear elastic–perfectly plastic with f_yk and γ_S). The toolkit typically includes modular worksheets for beam flexure & shear, column interaction diagrams (N-M and N-M-V), slab design (including punching shear per EN 1992-1-1 §6.4.5), crack width estimation (using effective modulus and tension stiffening), and deflection control via deemed-to-satisfy span-to-depth ratios or rigorous quasi-permanent combination analysis. Each worksheet enforces mandatory input validation, automatic unit consistency checks (e.g., kN, MPa, mm), and clear visual feedback (e.g., pass/fail flags, color-coded results), promoting transparency and reducing manual calculation errors. Furthermore, v3.2 introduces enhanced features such as parametric section geometry definition, automated anchorage length verification per §8.4, and export-ready summary reports aligned with common engineering deliverables.

📑 Key Components

1 ULS Flexural Design Module
2 SLS Crack Width & Deflection Calculator
3 Column Interaction Diagram Generator

🎯 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.

🔗 Related Concepts

Limit State Design Parabolic-Rectangular Stress Block Tension Stiffening

📚 References

#Eurocode 2 #Reinforced Concrete #Excel Engineering Tool