Concrete Beam design [xls] [Excel sheet ]

 Concrete Beam design [xls] [Excel sheet ]

• You can input concrete characteristics, such as concrete grade and concrete strength, as well as, beam properties, such as concrete cover and dimensions of beam.
• The spreadsheet also includes a deflection check which uses the beam’s modulus of rupture, elasticity and modular ratio, and the cracked section of moment of inertia. Moreover, it shows deflection behavior under different cases (eg. under DL, under LL, and under DL + LL). This gives the user the flexibility to change the different types of applied loads to design the appropriate beam.
• The spreadsheet also calculates for short term and long term deflection, where initial deflection must be < L/360 and long term deflection must be < L/240.

Link