RCC Beam Design Excel Sheet – IS 456 & IS 13920

Description

RCC Beam Design Excel Sheet – IS 456 & IS 13920 This Excel sheet is developed for the analysis, design and reinforcement detailing of rectangular RCC beams as per IS 456 and IS 13920. It provides a simple and automated solution for designing singly reinforced, doubly reinforced and ductile beams, including checks for flexure, shear, torsion, reinforcement limits and bar spacing. The user only needs to enter the required beam data in the designated input cells. The sheet automatically performs the calculations and generates clear design results that can be used for engineering review and report preparation. Main Features Singly reinforced beam design Doubly reinforced beam design Flexural reinforcement design as per IS 456 Shear reinforcement and stirrup spacing calculation Torsion design and combined shear–torsion checks Ductile detailing as per IS 13920 Minimum and maximum reinforcement checks Minimum shear reinforcement check Maximum stirrup-spacing verification Effective cover and reinforcement-layer consideration Reinforcement bar selection and spacing checks Capacity-based shear design Deflection-related design checks Clear warnings when the beam depth or reinforcement arrangement needs revision Automated and printable calculation report Flexural Design The sheet calculates the required tension and compression reinforcement using the factored bending moment, beam dimensions, concrete grade, steel grade and effective cover. For bending moments within the limiting capacity, the beam is designed as a singly reinforced section. When the bending moment exceeds the limiting capacity, the sheet calculates both tension and compression reinforcement for a doubly reinforced section. It also verifies minimum reinforcement, maximum reinforcement and allowable spacing between longitudinal bars as required by the relevant code provisions. Shear and Torsion Design The sheet calculates the required shear reinforcement based on the factored shear force, concrete shear strength, stirrup diameter, number of legs and reinforcement grade. It checks: Minimum shear reinforcement Required stirrup spacing Maximum permitted stirrup spacing Shear capacity of the section Combined shear and torsion effects Closed stirrup requirements for torsion It also calculates the level of shear force that can safely be resisted using minimum shear reinforcement, helping the designer identify beam regions where minimum stirrups are sufficient. Ductile Detailing Ductile detailing requirements are considered in accordance with IS 13920, including support reinforcement, capacity-based shear design and closer stirrup spacing in critical beam regions. How to Use Enter the required project and beam data in the white input cells shown in red font. The Excel sheet will automatically complete the calculations, display the required reinforcement and generate the design results. Input → Automatic Calculation → Design Check → Reinforcement Details → Report This tool is suitable for structural engineers, consultants, designers, students and professionals who require a fast, reliable and easy-to-use RCC beam design solution.

Features

• Singly reinforced beam design
• Doubly reinforced beam design
• Flexural design as per IS 456
• Shear design as per IS 456
• Torsion design and combined checks
• Ductile detailing as per IS 13920
• Capacity-based shear design
• Tension reinforcement calculation
• Compression reinforcement calculation
• Minimum and maximum steel checks
• Stirrup spacing calculation
• Minimum shear reinforcement check
• Maximum stirrup spacing verification
• Top and bottom reinforcement detailing
• Left and right support design
• Bar diameter and spacing checks
• Effective cover calculation
• Steel stress-strain calculations
• Deflection check
• Automated design calculations
• Clear design warnings
• Printable calculation report
• User-friendly input format