ALPAXL Ver 1.

Qt

Axially loaded pile analysis tool Layer 1 H1

Layer 2 H2

 
Lp
Layer i Hi

 
Circular pile
Layer m B = 2rp HN-1

Layer m+1

 
Developed by Hoyoung Seo Layer j
Advisor: Prof. Monica Prezzi  
Layer N

z
 Qt Bx

x
H1 By
H2


Hi
Qt
y
 r
1 H1 rectangular pile
HN-1
2 H2


Lp
 Hi r

 

m  B = 2rp HN-1 Br = 2rp

circular pile
m+1
z



N

z
Pile geometry Soil properties
Depth to the Young's modulus
Pile diameter Br (m) 0.2 Layer i layer Hi (m) of the soil Esi (MPa)
Pile length Lp (m) 19 1 12 50

Young's modulus of
27 2 19 117
the pile Ep (GPa)

3 21 117

4 40 138

Soil layers 5

Number of soil layers

2 6
within the pile
Number of soil layers
2 7
below the pile base
8

Load 9

Load at the
542 10
pile head Qt (kN)
 Output
Poisson's ratio Head settlement
3.61
of the soil nsi wt (mm)
Base settlement
0.3 0.13
wb (mm)
Base load
0.3 17
Qb (kN)

0.3 gr 0.0227335

0.3
Original shear modulus

Modified shear modulus

Run 5 iterations
Qt (kN) = 542

Qb (kN) = 17
● Original configuration

Deformed configuration

plot scale factor

5

Soil displacement was magnified by 200 times

for a better view.
 0 100 200 300 400 500 600 0 2 4 6 8 10 12 14 16 18 20
0 0

0.5 0.5
pile head settlement (mm)

soil displacement (mm)

1 1

1.5 1.5

2 2

2.5 2.5

3 3 At the pile head

3.5 3.5 At the pile base

4 4
Axial load (kN) Radial distance from pile axis (m)

0 0.5 1 1.5 2 2.5 3 3.5 4 0 100 200 300 400 500 600
0 0

2 2

4 4
6 6
Depth (m)
Depth (m)

8 8
10 10
12 12
14 14
16 16
18 18
20 20
Pile displacement (mm) Axial load (kN)
 8 10 12 14 16 18 20

At the pile head

At the pile base

ance from pile axis (m)

0 300 400 500 600

ial load (kN)

Layer Hi (m) ki (Pa) ti (N) zi (m-1) ai (N/m) Bi (m) Ci (m)
1 12 2.25E+07 6.34E+07 0.152041 1.48E+08 -2.198E-05 3.634E-03
2 19 5.27E+07 1.48E+08 0.214624 2.46E+08 5.156E-07 5.824E-03
3 21 5.27E+07 1.48E+08 0.419880 1.26E+08 -6.748E-10 3.884E-01
4 40 6.22E+07 1.75E+08 0.419880 1.48E+08 0.000E+00 3.565E-01
msi (Nm) nsi (N/m) gr
648.9 32.8 0.02273
18.0 1.4 0.02273
0.6 0.2 0.02273
0.1 0.1 0.02273
If ALPAXLVer 1.0 does not work properly, please check whether the Analysis TookPak add-in is intalled.

The installation procedures of the Analysis ToolPak are as follows:

1. On the Tools menu, click Add-Ins.

2. In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

3. Restart Microsoft Excel.

ak add-in is intalled.