Scribd
Upload
4K views6 pages

Pile Foundation Excel

1. This document provides design calculations for a bored cast in-situ pile foundation, including calculations for pile capacity, depth of fixity, bending and axial load design, and lateral tie spacing. 2. Key parameters calculated include the pile length below cut-off level, depth of fixity, factored loads, moment and axial capacities, steel reinforcement areas, and lateral tie diameter and spacing. 3. Reinforcement is designed for tension, compression, and bending conditions based on load combinations and limit states specified in relevant codes.

Uploaded by

Vishnu Priya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
4K views6 pages

Pile Foundation Excel

1. This document provides design calculations for a bored cast in-situ pile foundation, including calculations for pile capacity, depth of fixity, bending and axial load design, and lateral tie spacing. 2. Key parameters calculated include the pile length below cut-off level, depth of fixity, factored loads, moment and axial capacities, steel reinforcement areas, and lateral tie diameter and spacing. 3. Reinforcement is designed for tension, compression, and bending conditions based on load combinations and limit states specified in relevant codes.

Uploaded by

Vishnu Priya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

BORED CAS

PILE FOUND

DATA

Load factor FL =
Diameter of pile D =
Radius r =
Pile capacity in compression P =
Pile capacity in tension T =
Pile capacity in lateral H =
Grade of concrete Fck =
Grade of steel Fy =
Clear cover C =
Minimum % of steel reinforcement Pt, min =
Diameter of helical reinforcement t =
Minimum diameter of Main reinforcement 1 =
Maximum diameter of secondary reinforcemet 2 =
Area of pile cross section Ac =
=
Length of pile below cut of level L =

Circle to square conversion r =

Area of square b

DEPTH OF FIXITY CALCULATION (AS PER APPENDIX C IS 2911 PART 1/SEC 1)

Modulus of subgrade reaction K1 =


Length of pile above GL L1 =
Modulus of Elasticity of concrete E =
=
=
Momement of inertia of pile I =
=
Pile stiffness for granular soil T =
=
L1/T =
For fixed head file Lf/T =
Length of Fixity Lf =

Design of pile from cut off level to depth of fixity

Design for Tension with Bending


Factored lateral load Hu =
Factored Bending Moment for fixed head pile Mu =
=
Moment Reduction factor =
Design Bending Moment Mu =
Effective cover d' =
d'/D =
Factored Uplift load (Tension) Tu =
Mu/Fck*b 3
=
Tu/Fck*b2 =
p/fck =
p =
Ast =
Area of steel required Ast =

Design for Compression with Bending

Slenderness ratio =

Minimum eccentricity e =
e =

Factored compressive load Pu =


Pu/fckD 2
=
Mu/fckD3 =
p/fck =
p =
Area of steel required Ast req =

Design for Bending Only

Factored compressive load Pu =


Pu/fckD 2
=
Mu/fckD 3
=
p/fck =
p =
Area of steel required Ast req =

Provide 7 Nos of 25mm bar


Ast pro =

Design of pile below depth of fixity

Vertical Compression

Factored compressive load Pu =


Axial capacity Pa,u =

Vertical Tension

Factored tensile load Tu =


Area of steel required Ast, req =

Provide 7 nos of 16mm dia bar


Ast pro =

LATERAL TIES

Diameter of Circular ties =

Spacing of the circular ties


Least of the following
1 Dia of pile =
2 16 1 =
3 300 mm =
Provide 8mm dia @ 200mm c/c
BORED CAST IN -SITU PILE
PILE FOUNDATION DESIGN

1.5
450 mm 0.45 m
225
750 kN
120 kN
45 kN
25 N/mm2
415 N/mm2
60 mm
0.4 %
8 mm
16 mm
25 mm
r2
159013.125 mm2 0.159013
19 m

0.225
0.050625
0.16 m2
0.4 m

3.34 MN/m3 From Soil report


0m
5000Fck From IS 456
25000 N/mm 2

25000 MN/m2
/64*D4

0.0020125099 m4
(EI/K1)1/5
1.720 m
0m
2.2 Fig no 4 from IS 2911 Part-1/Sec 2
3.78 m
3785 mm

67.5 kN
Hu(L1+Lf)/2 From IS 2911 part 1/sec 2 class C-4.3
128 kNm
0.83 Fig No 5B From IS 2911 part 1/sec 2 class C-4.3
106 kNm
72.5 mm
0.16
180
0.0663 From SP 16 chat 81
0.0450
0.071
1.775 %
p*D2*(3.141/4)
2822 mm2

10.09
Hence, designed as short
(Lf/500)+(d/30) As per IS 456
22.57 mm

1125 kN
0.2222222222 Refer chat 58 in SP 16
0.0465
0.038
0.95 %
1511 mm2

0 kN
0 Refer chat 58 in SP 16
0.047
0.057
1.425 %
2266 mm2

3435 mm2

OK

1125
0.4 fck Ac
1590 kN

OK

180
Tu/0.87 fy
499 mm2

1407 mm2

OK

8 mm

450 mm
256 mm
300 mm

You might also like