Pile-Capacity -all calculation (www.theengineeringcommunity.org).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	S
1	Option 2
2		1,0	Input
3
4		1,1	Design Soil Parameters
5
6			Sl.No.	Description	Reduced Level		Depth of layer from ground		Soil Parameters			Interaction Parameters
7					Reduced Level		Depth of layer from ground		c	f	gSub	k	d	a
8					From	To	From	To	kN/m2	deg.	kN/m3		deg.
9			1	Silty Sand	0	10,5	0,0	-10,5	0	30	18	1,99	30	0
10			2	Rock	10,5	25	-10,5	-25,0	21	40	24	0,25	40	0	-14,5
11			3
12			4
13			5
14			6
19
20		1,2	Pile Details
21
22			Existing ground level					=	0	m
23			Pile Diameter, D					=	1,5	m
24			Pile Cut-off level					=	0,0	m
25			Dredge level					=	0,0	m
26			Scour level					=	0,0	m
27			Pile Founding level					=	-5,0	m
28			Depth from G.L.corresponding to F.L.					=	5,0	m
29			Pile Embedment length					=	5,0	m
30			Total Pile Length, L					=	5,0	m
31			Pile Density					=	35,0	kN/m3
32			Factor of Safety					=	2,5
33
34			Pile Fixity condition at top					=	fixed	(Fixed or Free)
35			Grade of Concrete					=	35	N/mm2
36			Modulus of subgrade reaction at fixity zone					=	4000	kN/m3
37			Type of soil in fixity zone					=	Sand	(Sand or Clay)
38			Unsupported Length of Pile, L1					=	0,0	m
39			Allowable displacement of pile at head					=	2,0	mm
40			(For Horizontal capacity)
41
42		1,3	Sketch
43				0	m, EBL
44
45				0,0	m Cut-Off Level
46
47
48
49
50
51
52
53
54
55
56				-5,0	m, Found. Level
57
58
59		2,0	Calculation of Vertical Capacity
60
61			Ultimate Capacity of Pile , Qult = Qb + Qs - Wp
62
63			Whetre, Qb = Ultimate End Bearing
64				Qs = Ultimate Skin Resistance
65				Wp = Self weight of Pile
66
67			Qsafe = Qult / FOS
68			Where, FOS = Factor of Safety
69
70
71		2,1	Calculation of Skin Resistances
72
73		2.1.1	Layer-1:
74			Layer thickness, L1								=	10,5	m
75			Pile embedment in the layer, h1								=	5	m
76
77			Ultimate Skin Resistance, Qs1 =				(a * c1 + K * Pd1 * tand ) x As1
78
79			Where, Reduction factor, a								=	0
80				Cohesion, c1							=	0	kN/m2
81				Coefficient of Lateral earth pressure, K							=	1,99
82				Unit weight of soil , g1							=	18	kN/m3
83				Effective Overburden Pressure at middle of layer, Pd1
84				Pd1 = h1/2 *g1							=	94,5	kN/m2
85				Angle of wall friction, d							=	30	deg.
86				Surface area of Pile in layer 1, As1 = pi * D * h1							=	23,55	m2
87
88			Ultimate Skin Resistance, Qs1 =				(ac1 + KPd1*tand ) x As1				=	2555,341218	kN
89
90
91		2.1.2	Layer-2:
92			Layer thickness, L2								=		m
93			Pile embedment in the layer, h1								=		m
94
95			Ultimate Skin Resistance, Qs2 =				(a * c2 + K * Pd2 * tand ) x As2
96
97			Where, Reduction factor, a								=	0
98				Cohesion, c2							=	0	kN/m2
99				Coefficient of Lateral earth pressure, K							=
100				Unit weight of soil, g2							=	0	kN/m3
101				Effective Overburden Pressure at middle of layer, Pd2
102				Pd2 = Pd1 + h1/2 g1 + h2/2 g2							=	189	kN/m2
103				Angle of wall friction, d							=	40	deg.
104				Surface area of Pile in layer 2, As2 = pi * D * h2							=	0	m2