ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
CALCULATION OF LOADS ON PILESREMARKS:1-Maximum no. of Piles = 35, Maximum no. of Load Application points = 4.
2
UNITS ARE IN TONNE/ TONNE METER/METER
2-Input cells are the first 4 columns of "PILES INFORMATION", the "PILE CAPACITY" and ALL "LOADS INFORMATION".
3
PILES INFORMATION
3-Click button "N" to hide unused cells in tables "1 & 3" and button "NN" to reshow the cells hidden by "N".
4
PILEPILE(Xi)(Yi)PILE CROSS-1=PILE EXISTSX-SECT. AREAX-SECT. AREA(Yi-Yp)(Xi-Xp)
5
No.DIAMETERX-COORDINATEY-COORDINATE
SECTIONAL AREA
0=NO PILE* X-COORD.* Y-COORD.
6
10,650,50,50,33210,1660,166-5,500-3,650
7
20,652,90,50,33210,9620,166-5,500-1,250
8
30,655,30,50,33211,7590,166-5,5001,150
9
40,657,90,50,33212,6210,166-5,5003,750
10
50,650,52,70,33210,1660,896-3,300-3,650
11
60,652,92,70,33210,9620,896-3,300-1,250
12
70,655,32,70,33211,7590,896-3,3001,150
13
80,657,92,70,33212,6210,896-3,3003,750
14
90,650,54,90,33210,1661,626-1,100-3,650
15
100,652,94,90,33210,9621,626-1,100-1,250
16
110,655,34,90,33211,7591,626-1,1001,150
17
120,657,94,90,33212,6211,626-1,1003,750
18
130,650,57,10,33210,1662,3561,100-3,650
19
140,652,97,10,33210,9622,3561,100-1,250
20
150,655,37,10,33211,7592,3561,1001,150
21
160,657,97,10,33212,6212,3561,1003,750
22
170,650,59,30,33210,1663,0863,300-3,650
23
180,652,99,30,33210,9623,0863,300-1,250
24
190,655,39,30,33211,7593,0863,3001,150
25
200,657,99,30,33212,6213,0863,3003,750
26
210,650,511,50,33210,1663,8165,500-3,650
27
220,652,911,50,33210,9623,8165,500-1,250
28
230,655,311,50,33211,7593,8165,5001,150
29
240,657,911,50,33212,6213,8165,5003,750
30
0
31
0
32
0
33
0
34
0
35
0
36
0
37
0
38
0
39
0
40
0
41
42
PILE CAPACITY=115No. of PILES=24SUM33,05047,784
43
SUM OF X-SECT. AREA=7,964
44
X-COORD. OF PILES C.G.: Xp=4,150
45
Y-COORD. OF PILES C.G.: Yp=6,000
46
47
Moment of Inertia of PILES about X-axis: Ix=338,800
48
Moment of Inertia of PILES about Y-axis: Iy=181,620
49
50
51
LOADS INFORMATION
52
53
PILE CAP O.W. =256,2
54
FILL O.W. =164
55
SURCHARGE =102,5
56
LOADS FROM COLUMNS/WALLS/CORES/PEDESTALS
57
LOAD No.12341=load exists,1111
58
Vert. Force "N"5311901902500=no load
59
X-COORD. "Xj"4,17191,1293,2797,029W,U/42W1W2W3
60
Y-COORD. "Yj"2,57548,8888,8888,888
61
Hor.Force "Hx"0000
62
Arm "Ax"1111
63
Hor.Force "Hy"0212531
64
Arm "Ay"1111
65
"Mx"4-505-465-705
66
"My"0000
67
Mx-total=Mx-1822,4626-1074,72-1038,72-1458
68
N(Yj-Yp)-HyAy
69
My-total=My+11,6289-573,99-165,49719,75
70
N(Xj-Xp)+HxAx
71
No. of LOAD APPLICATION POINTS =
4
72
Total Normal Force, Nt=
1683,7
73
Total Horizontal Force, Hxt=
0
74
Total Horizontal Force, Hyt=
77
75
Total Moment about X, Mxt=
-1748,9774
76
Total Moment about Y, Myt=
-8,1011
77
78
79
80
CALCULATION OF LOADS ON PILES
81
PILE No.LOADHxHySTATUSMxt(Yi-Yp)/IxMyt(Xi-Xp)/Iy
82
83
141,9240,0003,208SAFE-28,3920,163
84
241,8170,0003,208SAFE-28,3920,056
85
341,7100,0003,208SAFE-28,392-0,051
86
441,5940,0003,208SAFE-28,392-0,167
87
553,2810,0003,208SAFE-17,0350,163
88
653,1740,0003,208SAFE-17,0350,056
89
753,0670,0003,208SAFE-17,035-0,051
90
852,9510,0003,208SAFE-17,035-0,167
91
964,6380,0003,208SAFE-5,6780,163
92
1064,5310,0003,208SAFE-5,6780,056
93
1164,4240,0003,208SAFE-5,678-0,051
94
1264,3080,0003,208SAFE-5,678-0,167
95
1375,9950,0003,208SAFE5,6780,163
96
1475,8880,0003,208SAFE5,6780,056
97
1575,7810,0003,208SAFE5,678-0,051
98
1675,6650,0003,208SAFE5,678-0,167
99
1787,3520,0003,208SAFE17,0350,163
100
1887,2450,0003,208SAFE17,0350,056