Crack Width Prediction Spreadsheet (ACI 24.3 & EC2 7.3)

Crack width prediction is a critical serviceability check in reinforced concrete design, ensuring that cracks remain within tolerable limits to prevent corrosion of reinforcement, maintain aesthetics, and preserve structural integrity and durability. ACI 24.3 employs an empirical expression based on effective tension area, bar spacing, and steel stress—emphasizing practical simplicity and conservatism—while EC2 7.3 adopts a semi-analytical approach rooted in the ‘effective moment of inertia’ and ‘average strain’ concepts, incorporating bond characteristics, concrete cover, bar diameter, and strain distribution across the cracked section. The spreadsheet automates iterative calculations such as effective depth, tension stiffening, stress in reinforcement at SLS, and crack spacing estimation (e.g., using the ‘maximum crack spacing’ model per EC2 or the ‘basic equation’ per ACI), often including built-in checks for minimum reinforcement, maximum bar spacing, and cover requirements. Advanced versions may feature sensitivity analysis, graphical output of crack width vs. load level or bar size, and conditional formatting to flag non-compliant results—enhancing usability for designers, reviewers, and educators alike.