G&P GEOTECHNICS SDN. BHD.
Project
Project No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
Work Ref.
Sheet No.
Rev.
DESIGN SHEET
TITLE
Design
Piles Setting Out Diagram
y (+ve)
Pile
Check
column
position
(0,0)
Review
y (+ve)
My (+ve)
x
(+ve)
y (deviation):
(+ve)
Date
column position
(0,0)
x (deviation):
(+ve)
Mx (+ve)
x
(+ve)
Consider column position at coordinates (0,0)
X and Y (Original) refer to the original pile location with respect to column position.
X and Y (deviations) refer to the shifting of the pile head after installation.
Grid Line :
F/3B
Pilecap Ref : 2P2
No. of Piles :
40
Total Column Load :
Allowable
Pile No W.Load
(kN)
1
2
3
500
500
500
nos.
1500
kN
Moment about x-direction, Mx=
Moment about y-direction, My=
0
0
exx
Fcu
x
y
dx
dy Asbuilt Asbuilt eyy
Lengt
h (m) (kN/mm2) (mm) (mm) (mm) (mm) x (mm) y (mm) (mm) (mm)
6
6
6
25
25
25
-375 -217
375 -217
0
433.3
-44
-64
-58
5
-73
-31
-419 -212
311 -290
-58 402.3
###
###
kNm
kNm
P1
(kN)
Mxx
(kN)
Myy Reaction
(kN)
(kN)
500
###
###
500
###
###
500
###
###
#VALUE! #VALUE!
#VALUE! #VALUE!
#VALUE! #VALUE!
Status
Overstressing
#VALUE!
#VALUE!
#VALUE!
-
GUE & PARTNERS SDN. BHD.
Project Title
Job No.
Work Ref.
Sheet No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
DESIGN SHEET
Design
TITLE
REF.
Check
Review
Date
F/3B
Pilecap ref:
CALCULATIONS
OUTPUT
Calculation For Load Distribution in Pile Group
Number of Pile =
40
Total Column Load =
1500
Gridline:
Less Than Total Working Load, OK
y (+ve)
Moment about X direction, Mx =
Moment about y direction, My =
y (+ve)
column position
(0,0)
Pile
My (+ve)
x (+ve)
y (deviation):
(+ve)
x (+ve)
Mx (+ve)
column position
(0,0)
x (deviation): (+ve)
Consider column position at coordinates (0,0)
X and Y (Original) refer to the original pile location with respect to column position.
X and Y (deviations) refer to the shifting of the pile head after installation.
No. Pile
Working
Load, A
Pile
Length, L
Concrete
Grade, fcu
Young
Modulus, Ecs
(kN)
(m)
(kN/mm2)
(kN/mm2)
Vertical
Stiffness
Stiffness
Ratio
500
25
25
2.0833
0.3333
500
25
25
2.0833
0.3333
500
25
25
2.0833
0.3333
Total Vertical
Stiffness
6.2500
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
=
Total
Working
Load
1500
2P2
kNm
kNm
GUE & PARTNERS SDN. BHD.
Project Title
Job No.
Serial No.
Sheet No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
DESIGN SHEET
2
Design
TITLE
REF.
Check
CALCULATIONS
No. Pile
original
deviations
Review
Date
OUTPUT
original - deviations
x (mm)
y (mm)
x (mm)
y (mm)
x (mm)
-375
-216.7
-44
-419
y (mm)
-211.7
2
3
375
0
-216.7
433.3
-64
-58
-73
-31
311
-58
-289.7
402.3
GUE & PARTNERS SDN. BHD.
Project Title
Job No.
Serial No.
Sheet No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
DESIGN SHEET
3
Design
TITLE
REF.
Check
Review
Date
CALCULATIONS
No. Pile
X (mm)
Y (mm)
-419
-211.7
2
3
311
-58
-289.7
402.3
resultant eyy
(xdirection)
#VALUE!
resultant exx
(y-direction)
OUTPUT
Xn (mm)
Yn (mm)
Ixx
(=AnYn2)
Iyy
(=Anxn2)
#VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
Total
#VALUE!
#VALUE!
GUE & PARTNERS SDN. BHD.
Project Title
Job No.
Serial No.
Sheet No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
DESIGN SHEET
4
Design
TITLE
REF.
Check
Review
CALCULATIONS
Date
OUTPUT
No. Pile
P1 (kN)
(Nexx+Mx)YnAi/Ixx (kN)
(Neyy+My)XnAi/Iyy(kN)
Final Load (kN)
500
#VALUE!
#VALUE!
#VALUE!
###
2
3
500
500
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
#VALUE!
###
###
Total
#VALUE!
GUE & PARTNERS SDN. BHD.
Project
Project No.
Work Ref.
Sheet No.
(GEOTECHNICAL CONSULTANTS)
Company No. 490887A
Rev.
DESIGN SHEET
TITLE
Design
REF.
Check
Review
DESIGN
Date
OUTPUT
DETERMINATION OF CENTER GRAVITY FOR COMBINED COLUMN LOADING
GridLine :
F/3B
Pilecap Ref:
2P2
Methodology
Column 1
y
yi
(x,y)
Column
2
Center of
Gravity
x
CG
Datum
xi
Column
Load (kN)
Distance xi
Distance yi
From Datum
From Datum
(mm)
(mm)
Load * Distance
Total
Gue & Partners Sdn Bhd - 296439294.xls
Centroid ,
Centroid ,
y =
#DIV/0!
#DIV/0!
Quality Service - Our Commitment
Explanatory Notes: Title :
AD015 - Pile Eccentricity Analysis
Revision :
R0
Objective :
1. To compute each pile reaction due to column loading
Notes :
1. Key in the following details for the pile eccentricity analysis:
a.) Number of piles
b.) Total Column Loading
c.) Moment at x & y directions
d.) Each Pile Allowable Working Load
e.) Pile Length after cut off
d.) Pile Characteristic Strength, Fcu
f.) Pile Eccentricity
Concept & Method:
1. Loading on piles (considering column loading only)
P = Pile Stiffness Ratio x Total Column Loading
Pile Stiffness Ratio =
Pile Vertical Stiffness , (Ecs x A) / L
Total Pile Vertical Stiffness , (Ecs x A) / L
Where
Ecs = Pile's Young Modulus (based on BS8110 Part 2:1985, Eq.17)
A = Pile Allowable Working Load
L = Pile Length after cut off
2. Additional loading on piles (considering pile deviation and moment)
Padd = (Nexx/yy + Mx/y) x Yn x Ai
Ixx/yy
Where
N
= Total Column Loading
exx/yy = Resultant eccentricity, exx (in y direction) , eyy (in x direction)
Mx/y = Moment at x / y direction
Yn = Resultant Y - coordinate for pile n
Ai = Allowable Pile Working Load for pile i
Ixx/yy = Total Moment Inertia in x / y direction
Limitation:
1. Limited to only three (3) to forty (40) nos. of piles.
2. Column position is always consider located at position 0,0.
3. X and Y (Original) refer to the original pile location
with respect to column position.
4. Use worksheet "Determination of C.G" to compute the
centroid of combined column.
