ðŸ•‘ Reading time: 1 minute

Following topics are covered in this spread sheet as per IS 456-2000 and IS 3370-1965Modification factor for tension reinforcement

Modification factor for compression reinforcement

Permissible shear stress in concrete (tc) for beams in limit state design method

Permissible shear stress in concrete (tc) for beams in working stress design method

Permissible shear stress in concrete (ktc) for solid slabs in limit state design method

Permissible shear stress in concrete (ktc) for solid slabs in working stress design method

Permissible compressive & tensile stress in concrete for working stress design method

Area of steel calculation by limit state design method

Area of steel calculation by working stress method

Development length of bars by limit state design method

Development length of bars by working stress method of design

Minimum reinforcement in either direction of slab

Modulus of elasticity of concrete

Flexural strength of concrete

Maximum shear stress in concrete for limit state method of design

Maximum shear stress in concrete for working stress method of design

Design of beam (singly reinforced) subjected to torsion by limit state design method

Equivalent shear

Longitudinal reinforcement for beams subjected to torsion

Transverse reinforcement for beams subjected to torsion

Check for shear in beams for limit state design method

Check for shear in beams for working stress design method

Check for shear in solid slabs for limit state design method

Check for shear in solid slabs for working stress design method

Design of shear reinforced - vertical stirrups by limit state method of design

Design of shear reinforced - vertical stirrups by working stress method of design

Minimum shear reinforcement in the form of stirrups

Max. spacing of shear reinforcement

Minimum and maximum tensile reinforcement in beams

Maximum compression reinforcement in beams

Maximum diameter of bars for slabs

Limiting moment of resistance and reinforcement index for singly reinforced rectangular sections

Basic values of l/d ratio for beams and solid slabs in general

l/d ratio for two way slabs of shorter spans (up to 3.5m) and live load up to 3 kN/m2

Pitch and diameter of lateral ties

Pitch and diameter of lateral ties

Strength of shear reinforcement - single bent up bar (Limit State Method)

Strength of shear reinforcement - single bent up bar (Working Stress Method)

Determination of xu/d value

Determination of total loads on the short span and long span due to one loaded panel

Determination of equivalent uniform load ' w/m ' for calculation of B.M. for beams for solid slabs

Determination of creep coefficient of concrete

Permissible bearing stress on full area of concrete (Working stress method)

Permissible bearing stress on full area of concrete (Limit state method)

Check for short and slender compression members

Check for Deep beam action-continuous beam

Check for Deep beam action-simply supported beam

Check for cont. deep beam action, minimum thick.of beam to prevent buckling w.r.t span and depth

Permissible shear stress in concrete (tc) for footings (two way action) in limit state design method

Permissible shear stress in concrete (kstc) for footings (two way action) in working stress method

Design check equation for members subjected to combined axial load and biaxial bending

Design check equation for members subjected to combined axial load and biaxial bending

Coefficient of thermal expansion for concrete/oc

Partial safety factor 'gm' for material

Design of shear reinforcement - vertical stirrups by limit state method of design

Minimum percentage of steel for liquid retaining structures (RCC member)

Permissible concrete stresses-resistance to cracking

Calculation of stress due to bending tension in concrete

Calculation of stress due to direct tension in concrete

Check for interaction ratio for members on liquid retaining face subjected to direct tensionand flexural tension in concrete

Calculation of tensile stress due to bending in concrete, fbt (alternate)

Calculation of thickness required for a structural member for permissible sbt and assumed p

Following topics are covered in this spread sheet in Annex-A.

Design for area of steel and shear for singly reinforced beam by limit state design method

Design of beam (singly reinf.) subjected to torsion by limit state design method

Design of column subjected to biaxial bending (with reinforcement equally on all the four sides.)

Design for area of steel and shear for doubly reinforced beam by limit state design method

Design for area of steel and shear for singly reinforced one way slab by limit state design method

Design for area of steel and shear for two way slab by limit state design method

Annex-B

Design for area of steel and shear for singly reinforced beam by working stress design method

Design for area of steel and shear for singly reinforced beam by working stress design method

Design of one-way slab as uncracked section design

Area of steel calculation at mid-span

Check for thickness (concrete tensile stress) using moment @ mid-span

Download The Spread Sheet From Here