One-Way RCC Cantilever Slab Design Excel Sheet – IS 456

Description

This One-Way RCC Cantilever Slab Design Excel Sheet provides a structured and transparent solution for the limit state design of reinforced concrete cantilever slabs in accordance with IS 456. Users can enter the slab width, cantilever length, concrete grade, reinforcement steel grade, support condition, imposed loads, reinforcement diameter, nominal cover and other required design parameters. The spreadsheet calculates the minimum effective depth at the fixed support, minimum depth at the free edge, average effective depth and effective span of the cantilever slab. It can therefore be used for the design of a tapered cantilever slab having different depths at the support and free edge. The load calculation includes slab self-weight, live load and superimposed dead load. The sheet calculates the total service load, factored load per metre width, maximum cantilever bending moment and maximum shear force. Based on the calculated bending moment, the spreadsheet determines the required area of tension reinforcement and the spacing of the selected main reinforcement bars. It also calculates the minimum temperature and distribution reinforcement and provides the required bar spacing. The spreadsheet performs the slab shear verification using the calculated nominal shear stress, design shear strength of concrete and maximum permissible shear stress. A clear “Safe” indication is provided when the selected slab section satisfies the shear requirements. Development length is checked using both anchorage bond and flexural bond requirements. The sheet calculates the required development length and verifies whether sufficient reinforcement anchorage is available at the fixed support. The final output includes a graphical plan and sectional reinforcement arrangement showing the slab geometry, main reinforcement, distribution reinforcement and bar spacing. Clear result indicators are provided for shear safety, development length and deflection. This spreadsheet is suitable for structural engineers, civil engineers, consultants, designers, contractors and engineering students who require a quick and reusable tool for designing one-way RCC cantilever slabs.

Features

• One-way RCC cantilever slab design
• Designed in accordance with IS 456
• Limit state design calculations
• Slab width input
• Cantilever length input
• One-way slab classification check
• Concrete grade input
• Reinforcement steel grade input
• Support condition selection
• Tapered slab design
• Support depth calculation
• Free-edge depth calculation
• Average effective depth calculation
• Effective span calculation
• Span-to-effective-depth ratio check
• Slab self-weight calculation
• Live load consideration
• Superimposed dead load consideration
• Total service load calculation
• Factored load calculation
• Maximum cantilever bending moment calculation
• Maximum shear force calculation
• Required effective depth calculation
• Overall slab depth calculation
• Nominal cover input
• Main reinforcement diameter input
• Required tension reinforcement calculation
• Main reinforcement spacing calculation
• Minimum reinforcement check
• Temperature reinforcement calculation
• Distribution reinforcement calculation
• Distribution bar spacing calculation
• Nominal shear stress calculation
• Concrete shear strength check
• Maximum permissible shear stress check
• Automatic shear safety indication
• Anchorage bond calculation
• Flexural bond calculation
• Required development length calculation
• Development length verification
• Maximum permitted reinforcement bar size check
• Deflection check
• Graphical slab cross-section
• Graphical reinforcement plan
• Clear input and result indications
• Editable and reusable Excel format