Combined Footing Design Calculation in Excel Spreadsheet

Combined Footing Design Calculation in Excel Spreadsheet
Combined Footing Design Calculation in Excel Spreadsheet

Hey, I'm Engr. BalaRam, Today I share How to design combined footing by Ultimate Strength Design(USD) method. You can download this design calculation Spreadsheet in free.

How to Design Combined Footing?

This Excel Spreadsheet helps you with the design of combined footing. Following parts are considered in it to perform the Size of the Footing:

  • Size of combined footing.
  • Combined footing design in the longitudinal direction.
  • Combined footing design in a cross direction.
Step -01: Input your data For Example:

Combined Footing Design data

Step -02: Footing Size

Since the space between the bottom of the footing and the surface will be occupied partly by concrete and partly by soil (fill), the average unit weight of 125 lb/ft3 will be assumed.

So, Pressure of Soil, A1 = 125.00 pcf.
Let, Top of the Footing below GL, B1 = 8.00 ft.
The Soil Pressure at 8.00 ft depth, C1= A1xB1 = 1,000.00 psf.
Combined Footing Size Calculation
Combined Footing Size Calculation
Step -03: Calculating S.F & B.M at Different Points

Factored Load on Colm.A, PuA= 254.00 kips (Load taken from Staadpro)
Factored Load on Colm.B, PuB= 267.00 kips (Load taken from Staadpro)

Factored Load from Colms, Pu = 521.00 kips.

Upward pressure caused by the factored load of the column, Qu = Pu / (LxB) = 3.02 ksf.

The Net Upward pressure per linear foot in the longitudinal direction is,
Wu = Qu*B kips/ft. = 28.16 kips/ft.
Calculating S.F & B.M at Different Points
Calculating S.F & B.M at Different Points
Footing Design Calculation
Footing Design Calculation

Step -04: Checking "d" from Punching Shear

Let, the depth of the footing, d = 15.50 in 1.29 ft.
Punching shear should be checked on a perimeter section st a distance d/2 around the column.
Of the two columns, the left side column (Col.A) is more critical at a distance d/2 from the column face in regard to the punching shear.

Checking Punching Shear

Step -05: Checking "d" from Beam Shear

The selected value d= 15.50 inches will now be checked for one-way or beam shear at a distance "d" to the left side of Column B. The factored shear force acting on that section is:-
Checking Beam Shear

Step -06: Checking "d" from Maximum Moment

Checking Maximum Moment

Step -07: Steel Requirements in the Long Direction (L) (Top Bar)

Steel Requirements in the Long Direction
Steel Requirements in the Long Direction
Step -08: Development length of deformed bars in Tension Zone (Top Bar)

Development length of deformed bars in Tension Zone

The distance from the point of Max. Moment to the nearer left end of the bar is:-
= X+C2-3/12 (deducting 3" clear cover) = 7.99 ft.
Which is much larger than the required minimum development length. So, the selected reinforcement is therefore adequate for both bending and bond.

Step -11: Steel requirements under Column "A" (Longitudinal)

Steel requirements under Column

Reinforcement Required: -
Reinforcement Required
Reinforcement Required

Step -12: Steel requirements under Column "B" (Longitudinal)

Steel requirements under Column

Step -13: Design of Transverse Beam Under Column."A"

From Step-11, the width of the transverse beam under Col.A, b= 2.15 ft.

Since the transverse reinforcement is placed on the top of the longitudinal bars, the actual depth will be, d= Actual "d" - 1 in = 14.50 in
Factored Load on Colm.A, PuA= 254.00 kips.

Width of the Footing, B = 9.33 ft.
The net upward load per linear foot of the transverse beam, WuA = PuA / B
= 27.22 kip/ft = 27,224.01 lb/ft.

The moment at the edge of Col.A, Mu = WuA*X1*(X1/2)
X1= B/2 - Z1/2
= 236,130.50 lb-ft. = 4.17 ft.

Design of Transverse Beam Under Column

Step -14: Design of Transverse Beam Under Column."B"

From Step-11, the width of the transverse beam under Col.B, b= 2.13 ft.

Since the transverse reinforcement is placed on the top of the longitudinal bars, the actual depth will be, d= Actual "d" - 1 in = 14.50 inches.

Factored Load on Colm.B, PuB= 267.00 kips
Width of the Footing, B = 9.33 ft.

The net upward load per linear foot of the transverse beam, WuB = PuB / B
= 28.62 kip/ft = 28,617.36 lb/ft.

The moment at the edge of Col.A, Mu = WuB*X2*(X2/2)
X2= B/2 - Z2/2
= 233,540.58 lb-ft. = 4.04 ft.

Design of Transverse Beam Under Column
Step -15: Development Length for Column

Where D = Dia of Footing Reinforcement.
Development Length for Column
Where, SO = Perimeter of Reinf.
= 2*P*r
= P*d
P = 3.14

Download combined footing design calculation Excel Spreadsheet here. I'm also a shared Isolated Column Footing Design  Excel Spreadsheet in my previous post.

We hope that this excel sheet to design Combined Footing will be useful to professionals and students of civil engineering, always keep in mind good criteria when using any type of design software. Do not forget to share this design on your social networks, with your support. We reach more people interested in the different areas of civil engineering. We wait for your comments and opinions, Greetings to all. Thank you.

Post a Comment

5 Comments