Here is another spreadsheet I created recently. It is actually supposed to be a part of something big which might take a while to come up. There is also a Spreadsheet for Rectangular Footing Design. Anyways, this is a Square footing design spreadsheet and it can be used for designing a square footing. Actually, two footing simultaneously it can be useful for the purpose of comparison and learning. So, one can easily compare the effect of change any parameter.
Off course as usual I have tried to make it in such a way that it can be used by learner, designers, students and also teachers. keeping everything open and simple. Nothing which I haven’t used or explained in my previous spreadsheets have been done in this one.
Using Square Footing Design Spreadsheet
The Spreadsheet is basically comprised of five sections as mentioned below one by one in details.
“Input” Section of Square Footing Design Spreadsheet
This is the portion where most of the inputs are to be entered. “Most of the inputs” as there are some choices that can be entered at a later stage.
Input data only in cells with filled background. At the position where there is some advised value but a user may want to change the value for example. “Factor of safety” a default value is entered and an input place is provided after “or” where required value can be entered and value that will be used further is shown after “use”.
“Representation” Section of Square Footing Design Spreadsheet
The 2nd section of the spreadsheet is representation where a diagram of the footing is shown and various dimension are also entered. It is shown in the image below.
“Depth of Footing” Section of Square Footing Design Spreadsheet
This portion shows the calculations involved in finding the depth of footing. It is founded using Bending moment consideration as well as Punching shear consideration as shown in the image below.
However usually value calculated due to punching shear consideration is smaller. After calculating depth by punching shear consideration an option to manually enter the depth is also given which can come handy when the failure can be eliminated by increasing or decreasing the depth of the footing. Depth of the footing at the edge is kept one-third the depth of footing at the face of the column which can also be altered manually in the cell with filled background.
“Steel Calculation” Section of Square Footing Design Spreadsheet
In this section amount of the steel reinforcement is calculated as shown below.
“Check for shear” Section of Square Footing Design Spreadsheet
In a foundation, it is very important to check the safety against shear forces at both the critical section. In this spreadsheet, conditional formatting is used to highlight if there is a failure in shear as shown below.
Version 1_0 of Square Footing Design Spreadsheet
Click Here for the Protected version 1_0 of spreadsheet.
In order to obtain the unprotected version you will have to do some effort contacting me.
If you like my work. Like it, share with your mates and comment in the section down below. I will appreciate if can suggest me some improvements.