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)
2
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 =
0
Moment about y direction, My =
0
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
1
=
500
6
25
25
2.0833
0.3333
2
=
500
6
25
25
2.0833
0.3333
3
=
500
6
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)
2
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)
1
-375
-216.7
-44
5
-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)
2
Company No. 490887A
DESIGN SHEET
3 Design
TITLE
REF.
Check
Review
Date
CALCULATIONS
No. Pile
X (mm)
Y (mm)
1
-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)
2
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)
1
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)
X
Y
Load * Distance
1
0
0
0
0
0
2
0
0
0
0
0
3
0
0
0
4
0
0
0
5
0
0
0
6
0
0
0
7
0
0
0
Total
0
0
0
Gue & Partners Sdn Bhd - 296439294.xls
Centroid ,
x
=
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.