RECTANGULAR SPREAD FOOTING ANALYSIS
Description
Rigid Spread Footing Bearing Pressure and Stability (Biaxial Eccentricity)
Analyses rigid spread footings carrying one or more piers with vertical loads, horizontal loads and moments. It works out the resultant and its eccentricities, checks overturning, sliding and uplift, and calculates the soil pressure at each corner, including biaxial cases where part of the base lifts off.
Sheets
- Footing (8 net pier loads) and (16 net pier loads) – up to 8 or 16 piers anywhere on a rectangular base
- Footing (breakdown of loads) – dead, live and wind or seismic loads entered separately
- Unsymmetrical Footing Base and Octagonal Footing – non-rectangular bases
- Footings (Table) and Footings (Pier Table) – many single-pier footings in rows, with one-way shear, punching shear and flexural reinforcement to ACI 318 (99 to 11, selectable)
Method
Linear bearing pressure under a rigid footing on uniform soil. Footing, soil and pier weights are included. For biaxial eccentricity with partial bearing, the method of Czerniak gives the bearing area and corner pressures. Sliding resistance is base friction plus passive pressure.
Inputs
- Footing size, soil depth and unit weights, Kp, base friction, surcharge
- For each pier: position, size, height, Pz, Hx, Hy, Mx, My
Outputs
Eccentricities, safety factors against overturning, sliding and uplift, bearing area, corner pressures and maximum net soil pressure.
The stored example, an 8 ft × 5 ft × 2 ft footing with an 80 kip column load and 20 kips horizontal at 3 ft above the footing, gives a total load of 102.4 kips, ex = 0.98 ft, safety factors of 4.10 (overturning) and 2.59 (sliding), and corner pressures of 4.44 and 0.68 ksf.
Please note
- Bearing pressures are not compared with an allowable value, and no minimum safety factors are imposed; the user must judge these.
- US customary units. Sheets protected without a password, formulas hidden. No macros.
- Written by Alex Tomanovich, P.E. References: E. Czerniak, “Analytical Approach to Biaxial Eccentricity”, ASCE J. Struct. Div. (1962, 1963); K.E. Wilson, “Bearing Pressures for Rectangular Footings with Biaxial Uplift”, J. Bridge Eng. (1997).
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
I'm not sure why you are having issues with using my FOOTINGS.xls spreadsheet workbook. I make use of input data validation comments as well as other general comments (denoted by red triangles) to hopefully clarify the user input or explain any restrictions or limitations in the input.
All of the spreadsheets that I write make use of comments to varying degrees, and I've never had any complaints from anyone else before about them.
The worksheets are protected, but not with a password. However, unprotecting them will not make the comments go away, but you can blow them away in your own personal copies if you choose.
That's about all I can offer you on this subject.
Regards,
Alex
Also, in the "Unsymmetrical Footing Base" worksheet, I added/expanded the comment boxes pertaining to the original general stress equation used to better clarify the equation's use and how the sign convention used in the worksheet relates to the original equation.
Finally, in all of the worksheets where a plan view plot of the footing is created, I revised the procedure for obtaining/maintaining a more correct aspect ratio for the plot. Off of the calculation page and to the upper right, the user now inputs a value which is termed as "Axes Lengths Ratio"......the ratio of the actual on-screen measured lengths of the X and Y axes. This should keep the plots looking more to correct scale than they have in many cases in the past.
The current version of this workbook is now version 3.7.
I have made the necessary corrections.
This workbook is now version 3.6.
While I was at it, I decided to update both the "Footings (Table)" and "Footings (Pier Table)" worksheets to be applicable for ACI 318 Codes, now up through the ACI 318-11 Code version. As best that I could tell, there have been no real changes to the ACI 318 Code (methodology, phi factors, etc.) , at least as far as flexure, shear, compression, and bearing are concerned, since the 2002 version. So it was a relatively easy modification to get those two worksheets updated.
This workbook is now version 3.5.
The "Footing (16 net pier loads)" worksheet should help particularly with bearing pressure and stability analysis for equipment foundations involving several piers/pedestals and short walls all on a common rigid foundation. The "Unsymmetrical Footing Base" worksheet should help with analysis of maximum soil pressure for situations where a non-rectangular shaped rigid footing base has to be used.
The current version is now 3.4.
I have corrected this, and the updated workbook is now version 3.3.
I have corrected this, and the updated workbook is now version 3.2.
While I was at it, I made the following couple of additional changes which hopefully are useful improvements:
In the first 2 worksheets which analyze a single footing at a time, a summary of results was added just off of the main calculation page to the right. This allows the user to quickly check the results during the process of iterating the footing dimensions, etc. in the input data, without having to take the time to either scroll down or "split-screen" the display to view the results.
I grouped all of the separate drawing components which composed the individual sketches in the worksheets into individual grouped drawing objects. This will allow the user to unprotect the worksheet, select the drawing object as a whole, and re-position it in the worksheet to make room for any additional text comments/verbiage if desired.
In the "Footings (Table)" worksheet, the program still assumes "phi" = 0.90 for the sake of being able to calculate and suggest numbers of reinforcing bars and size of bars. I've added caution notes in the calculations as well as the "DOC" worksheet to alert the user. Most often in the design of footings the cross section will be "tension controlled", and thus the flexural tension "phi" factor will be = 0.90 anyway. This worksheet now calculates the strain in the tension reinforcing and then calculates the "phi" factor. The user can then review the results for the calculated "phi" factor to determine if it is in fact = 0.90 so that the determined reinforcing can be used. If the calculated "phi" factor is < 0.90, then the user will have to increase the footing thickness until the calculated value of "phi" = 0.90.
In the "Footings (Pier Table)" worksheet for the point on the interaction curve for pure moment (no axial load), the program now calculates the strain in the tension reinforcing, then calculates the "phi" factor, and finally calculates the ultimate moment capacity, (phi)Mn.
I have a message in many, but not all, of my spreadsheets about clearing the contents of input cells not used, and NOT to use the Space Bar to do this. This is just a reminder to you all that just to be safe, always highlight the cells to be cleared, Right-Click the mouse, and then select "Clear Contents". Of course, in most of the programs where a numerical value is expected, inputting values of 0 will also work, but usually that takes more effort and often looks too busy.
If you want to [email me](/404/), I'll be glad to send you a PDF copy of that Czerniak article.
Alex