EXCEL SHEET FOR THE DESIGN OF RCC BEAM AS PER IS456-2000 WITH DEFLECTION CHECK

“Feel the structure” MSA

This treasure having an attachment of excel sheet for the design of RCC beam with defection check with modification factors in IS456:2000 with empirical formula (Mentioned in SP-24) instead taking result from fig-4 &5 of IS456:2000 which is tedious and lot of interpolation is required. 

Dear friends and junior civil engineers who are aspiring to be a structural engineer. This excel sheet is for the design of beam with deflection check.

From below link, download excel sheet for design of beam with deflection check.

DOWNLOAD EXCEL SHEET FOR THE DESIGN OF BEAM WITH DEFLECTION CHECK AS PER IS-456-2000

                               

 This excel sheet is going to help many civil engineers entered or trying to make a career  in the field of structural engineering. It is also very helpful to many practicing structural engineers as well. In this attached sheet, you will find beam designed with deflection check with modification factors for tension and compression reinforcement. Normally in STAAD, you can find out deflection for any beam but that is not appropriate. STAAd give deflection with respect to stiffness only without considering the role of tension and compression reinforcement. But, here in this sheet you will find complete beam design with different check like singly or doubly reinforced beam, under or over reinforced beam along with deflection check with appropriate modification factors as per fig. 4& 5 in IS-456-2000.

                                My main aim is to bring treasure that is hidden in this sheet is to evaluate modification factor for tension and compression steel directly from this sheet rather than from figure No-4 & figure No-5. Calculating modification factors from fig-4 & 5 is quite seditious and we can’t correctly take value from this.

                                You can ask what innovation I have done to convert all those difficultly to simplicity. Actually I have used SP-24, an explanatory handbook on Indian Standard code of practice for Plain and reinforced concrete. There is an empirical formula on this explanatory handbook on basis of which graph for fig -4 & 5 has been developed in  IS 456:2000. I have used this empirical formula directly in the excel sheet. There is no need to do any interpolation.

                                Please download this and enjoy working with this. You need to put your input in highlighted area with yellow color. Results will come automatically in the same sheet.

                               This treasure having an attachment of excel sheet for the design of RCC beam with defection check with modification factors in IS456:2000 with empirical formula (Mentioned in SP-24) instead taking result from fig-4 &5 of IS456:2000 which is tedious and lot of interpolation is required. 

          Please enjoy with this sheet and download here in the below link. 

DOWNLOAD EXCEL SHEET FOR THE DESIGN OF BEAM WITH DEFLECTION CHECK AS PER IS-456-2000

Thanks & regards!

MSA

Leave a Reply

Your email address will not be published. Required fields are marked *