DOWNLOAD FREE EXCEL SHEET FOR THE DESIGN OF ISOLATED FOOTING

“Feel the structure” MSA

Hello Friends!

Here is the attachment of verified excel sheet based on IS 456-2000 for the design of isolated footing.

Download Excel for the design of isolated footing from below link.

DOWNLOAD EXCEL SHEET FOR THE DESIGN OF ISOLATED FOOTING

This is easiest way to work. Only you should put your inputs in the highlighted areas for  reactive forces, external moments and results for checking of footing for one way shear and punching will come in the same excel sheet. Also, reinforcement with diameter and spacing will be highlighted in the same sheet.

            You can see all calculation in the same excel sheet.

Download excel sheet for the design of isolated footing

Thanks & regards!

MSA

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

EXCEL SHEET FOR THE DESIGN OF ISOLATED FOOTING WITH ACTUAL SURCHARGE/EARTH FILLING LOAD

“Feel the structure” MSA

Dear Friend,

Here i am attaching a valuable excel sheet for the design of isolated footing with actual surcharge /earth filling weight calculated in the same sheet. Generally, as a designer, we take 10% of total axial load for self weight of footing and filling but when you will actually calculate surcharge/filling weight & self weight of footing, it will be 30% to 40% and in some cases it may even  be 50%.

        Hence, it is better to calculate self wight of footing and filling weight instead of taking it 10% of total axial load (1.1xP).

From here, download this excel sheet which will automatically take filling and self weight of footing when you put size and thickness of footing.

Download Excel Sheet for the design of Design of Isolated footing with actual surcharge /filling load.

Thanks & regards!

MSA

CHARTS, TABLES & ANNEXES OF IS-456-2000 & IS-3370 IN EXCEL FORMAT

“Feel the structure”MSA

This incredible master excel data sheet for code  IS:456-2000 & IS:3370-1965 in which tables, charts & annexes has been generated in excel format .It will save your time and will be a tremendous help to practicing engineers as well as beginners. This is one of the most vital document that i am sharing to you. You can take out data of tables ,charts & annexes of IS:456-2000.

From below link, download excel sheet on IS-456-2000

DOWNLOAD TABLES & CHARTS IN EXCEL ON IS -456-2000


        You can take out data of Annexes A & B of IS:456-200 from this excel sheet.

Download Annex A & B of IS456-2000 in Excel format from the below link.

DOWNLOAD ANNEX-A & B OF IS-456-2000 IN EXCEL FORMAT

From Below Link, download IS-3370 tables & charts in Excel format

DOWNLOAD TABLES & CHARTS OF IS3370-1965 IN EXCEL FORMAT


There is no need to do interpolation. This excel sheet will be like a handbook for limit state design & working stress method of design for reinforced concrete where  it will help you to save your time  doing so much iteration with various grade of concrete,reinforcement and sizes of structural elements to check serviceability limit,either under reinforced or over reinforced, singly reinforced ,doubly reinforced & so on so forth. When you will start using this excel sheet, undoubtedly, you will say its a treasure. Now, enjoy working with this.
         Wish you all a great future in Structural Engineering field .This exceptional excel sheet is going to bring an opportunity for you to explore more and more and will indulge you to dive into huge depth in Structural Engineering.

Thanks & regards!

MSA