Done-Navigate

Liquefaction Evaluation

INSTRUCTIONS
This spreadsheet identifies possible zones of liquefaction in a soil profile. It
compares the anticipated cyclic shear stresses induced by an earthquake to
the esitmated cyclic strength of the soil. Zones where the induced stress is
greater than the cyclic strength are deemed zones of liquefaction. The
methodology involves two distinct processes:
1. Compute the equivalent cyclic shear stress induced by an earthquake vs.
depth
2. Compute the cyclic shear strength of the soil profile
Step (1) can be accomplished in many ways, however the simplest is the
method developed by Seed and Idriss (1971) where induced stresses are
determined by earthquake magnitudes and depth of the soil deposit. Other
methods include field correlations by authors on site-specific earthquakes, or
1-D wave propagation analysis by computer (Shake, MocEQ1).
Step (2) is most-easily done by correlating cyclic strength to corrected SPT
blow count. Alternatively, CPT data, laboratory data, and other measures of
soil cyclic strength can be used.
Done-Navigate
Project Information
Project Title Example Calculation
Project Site Chaaalston Saaath Caaraaaliner
Project Structure Big ol pier
Job Number 1234321
Date 12-Jul-01
Computed by R^2
Remarks Enter remarks here
A B C D

1
Soil profiles Done-Navigate
2 Soils Report Reference Geotechical Firm Inc., Rept #124 December 1989
3 Profile Generated By Ray
4 Number of Profiles 3
Add Profile Accept Changes
Delete Profile Start/Resets
5 Profile 1 2 3
6
Description Boring 33 Kramer W.P. 1

7 Start Depth (ft) 0 0 0

8 End Depth (ft) 100 66.3000030517578 50
9 Number of Soil Layers 3 1 4
10 Depth to Groundwater (ft) 10 4.90000009536743 5
11 Groundwater wt (lb/ft^3) 64 62.4000015258789 62.4000015258789
12 Layer 1 1 1
13
Description Light Tan Fine Sand Brown and Red Fine Yellow Red Sand
with Silt Seams and Sand
14 Layer Start Depth Pockets 0 0 0
15 Layer End Depth 20 66.3000030517578 10
16 Dry unit wt 100 112 90
17 Sat'd unit wt 120 136 110
18 UCS Classification SP SP SM
19 Percent Fines 0 0 5
20 Layer 2 2
21
Brown Sand Tan Medium Sand
Description
22 Layer Start Depth 20 10
23 Layer End Depth 40 20
24 Dry unit wt 100 95
25 Sat'd unit wt 120 115
26 UCS Classification SP SC
27 Percent Fines 0 20
28 Layer 3 3
Description Light Brown Sand Yellow Red Silty Sand
29

30 Layer Start Depth 40 20

31 Layer End Depth 100 45
32 Dry unit wt 105 95
33 Sat'd unit wt 115 105
34 UCS Classification SP SC
35 Percent Fines 10 25
36 Layer 4
37
Description White Fine Sand

38 Layer Start Depth 35

39 Layer End Depth 50
40 Dry unit wt 90
41 Sat'd unit wt 110
42 UCS Classification SM
43 Percent Fines 5
44 Layer
45
Description

46 Layer Start Depth

47 Layer End Depth
48 Dry unit wt
49 Sat'd unit wt
50 UCS Classification
51 Percent Fines
52 Layer
53
Description

54 Layer Start Depth

55 Layer End Depth
56 Dry unit wt
57 Sat'd unit wt
58 UCS Classification
59 Percent Fines
60 Layer
61
Description

62 Layer Start Depth

63 Layer End Depth
64 Dry unit wt
65 Sat'd unit wt
66 UCS Classification
67 Percent Fines
Done-Navigate
Field Profiles, SPT, CPT, or Gmax
Number of Add Profile Delete Profile Accept Changes Start/Resets
Profiles 1
Profile Num 1 2 3 4 5

Description Some Other Some Other Kramer Workshop

Descriptions Descriptions Example Problem 1
Profile Type SPT SPT
Num Data Pairs 20 12
Soil Profile 1 3
Depth/Value z (ft) N(bpf) z (ft) N(bpf)
1 0.0 12
2 5.0 10
3 10.0 18
4 15.0 15
5 19.0 9
6 25.0 12
7 30.0 14
8 35.0 22
9 40.0 31
10 45.0 33
11 50.0 15
12 55.0 11
13 59.0 23
14 65.0 25
15 70.0 28
16 75.0 33
17 80.0 26
18 85.0 32
19 90.0 34
20 95.0 27
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Add Done-Navigate
Delete
Recompute
Check/Accept
Profile
Profile
Computation of Loading Conditions
Total Profiles
Profile Num
3
1 Profile Num 2 Profile Num 3
Method Seed & Idriss Method Seed & Idriss Method Dobry et al
Amax(g) 0.22 Notes:Workshop Problem 1 amax Amax(g) 0.16 Notes: Amax(g) 0.2 Notes:
Mag vs. Neq Mean = 0.22 Mag vs. Neq Mean Mag vs. Neq Mean
Eq. Mag 7 Eq. Mag 7.5 Eq. Mag 7.5
Rd Curve Avg Rd Rd Curve Avg Rd Rd Curve Avg Rd
Greduction none Greduction none Greduction Dobry & Vu
Soil Profile 3 W.P. 1 Soil Profile 2 Kramer Soil Profile 3 W.P. 1
Field Profile 5 Workshop Problem 1 Field Profile 4 Kramer Example Field Profile 1 Some Other Descriptions
Start Depth 1 Start Depth 1 Start Depth 1
End Depth 50 End Depth 66.300003 End Depth 50
Num Data 49 Num Data 65 Num Data 49
Neq 10 Neq 15 Neq 15
Depth s tot seff rd tcyc Depth stot seff rd tcyc Depth stot seff rd gcyc
(ft) (psf) (psf) (---) (psf) (ft) (psf) (psf) (---) (psf) (ft) (psf) (psf) (---) (%)
1.00 90.00 90.00 0.998 12.85 1.00 116.93 116.93 0.998 12.14 1.00 90.00 90.00 0.998 3.189E-05
2.02 181.88 181.88 0.995 25.89 2.02 236.24 236.24 0.995 24.46 2.02 181.88 181.88 0.995 7.275E-05
3.04 273.75 273.75 0.993 38.86 3.04 355.54 355.54 0.993 36.71 3.04 273.75 273.75 0.993 1.116E-04
4.06 365.63 365.63 0.990 51.77 4.06 474.85 474.85 0.990 48.90 4.06 365.63 365.63 0.990 1.495E-04
5.08 459.17 453.97 0.988 64.85 5.08 597.61 586.30 0.988 61.39 5.08 459.17 453.97 0.988 1.792E-04
6.10 571.46 502.56 0.985 80.53 6.10 736.37 661.39 0.985 75.47 6.10 571.46 502.56 0.985 2.224E-04
7.13 683.75 551.15 0.983 96.14 7.12 875.13 736.49 0.983 89.49 7.13 683.75 551.15 0.983 2.653E-04
8.15 796.04 599.74 0.981 111.69 8.14 1013.89 811.58 0.981 103.46 8.15 796.04 599.74 0.981 3.079E-04
9.17 908.33 648.33 0.979 127.19 9.16 1152.66 886.68 0.979 117.38 9.17 908.33 648.33 0.979 3.504E-04
10.19 908.33 584.63 0.977 126.92 10.18 1291.42 961.77 0.977 131.24 10.19 908.33 584.63 0.977 3.352E-04
11.21 1026.67 639.27 0.975 143.16 11.20 1430.18 1036.87 0.975 145.04 11.21 1026.67 639.27 0.975 3.780E-04
12.23 1144.06 692.96 0.973 159.20 12.22 1568.94 1111.96 0.973 158.78 12.23 1144.06 692.96 0.973 4.204E-04
13.25 1261.46 746.66 0.971 175.16 13.24 1707.71 1187.06 0.971 172.46 13.25 1261.46 746.66 0.971 4.627E-04
14.27 1378.85 800.35 0.969 191.04 14.26 1846.47 1262.15 0.969 186.06 14.27 1378.85 800.35 0.969 5.049E-04
15.29 1496.25 854.05 0.967 206.83 15.28 1985.23 1337.25 0.967 199.58 15.29 1496.25 854.05 0.967 5.250E-04
16.31 1613.65 907.75 0.964 222.51 16.30 2123.99 1412.34 0.964 213.01 16.31 1613.65 907.75 0.964 5.654E-04
17.33 1731.04 961.44 0.962 238.09 17.33 2262.76 1487.44 0.962 226.35 17.33 1731.04 961.44 0.962 6.056E-04
18.35 1848.44 1015.14 0.959 253.54 18.35 2401.52 1562.53 0.959 239.57 18.35 1848.44 1015.14 0.959 6.457E-04
19.38 1965.83 1068.83 0.956 268.86 19.37 2540.28 1637.63 0.956 252.68 19.38 1965.83 1068.83 0.956 6.587E-04
20.40 1965.83 1005.13 0.953 268.03 20.39 2679.04 1712.72 0.953 265.66 20.40 1965.83 1005.13 0.953 6.566E-04
21.42 2069.06 1044.66 0.950 281.17 21.41 2817.81 1787.82 0.950 278.50 21.42 2069.06 1044.66 0.950 6.895E-04
22.44 2176.25 1088.15 0.947 294.69 22.43 2956.57 1862.91 0.947 291.18 22.44 2176.25 1088.15 0.947 7.236E-04
23.46 2283.44 1131.64 0.943 308.03 23.45 3095.33 1938.01 0.943 303.69 23.46 2283.44 1131.64 0.943 7.573E-04
24.48 2390.63 1175.12 0.940 321.18 24.47 3234.09 2013.10 0.940 316.01 24.48 2390.63 1175.12 0.940 7.907E-04
25.50 2497.81 1218.61 0.935 334.12 25.49 3372.86 2088.20 0.935 328.14 25.50 2497.81 1218.61 0.935 7.922E-04
26.52 2605.00 1262.10 0.931 346.84 26.51 3511.62 2163.29 0.931 340.06 26.52 2605.00 1262.10 0.931 8.234E-04
27.54 2712.19 1305.59 0.926 359.32 27.53 3650.38 2238.39 0.927 351.74 27.54 2712.19 1305.59 0.926 8.542E-04
28.56 2819.38 1349.07 0.922 371.54 28.55 3789.14 2313.48 0.922 363.18 28.56 2819.38 1349.07 0.922 8.844E-04
29.58 2926.56 1392.56 0.916 383.49 29.57 3927.91 2388.58 0.916 374.36 29.58 2926.56 1392.56 0.916 9.141E-04
30.60 3033.75 1436.05 0.911 395.15 30.59 4066.67 2463.67 0.911 385.26 30.60 3033.75 1436.05 0.911 9.080E-04
31.63 3140.94 1479.54 0.905 406.50 31.61 4205.43 2538.77 0.905 395.87 31.63 3140.94 1479.54 0.905 9.352E-04
32.65 3248.12 1523.02 0.899 417.52 32.63 4344.19 2613.86 0.899 406.17 32.65 3248.12 1523.02 0.899 9.617E-04
33.67 3355.31 1566.51 0.892 428.21 33.65 4482.96 2688.96 0.893 416.14 33.67 3355.31 1566.51 0.892 9.875E-04
34.69 3462.50 1610.00 0.886 438.53 34.67 4621.72 2764.05 0.886 425.76 34.69 3462.50 1610.00 0.886 1.013E-03
35.71 3569.69 1653.49 0.879 448.47 35.69 4760.48 2839.15 0.879 435.03 35.71 3569.69 1653.49 0.879 9.992E-04
36.73 3676.88 1696.97 0.871 458.02 36.71 4899.24 2914.24 0.871 443.92 36.73 3676.88 1696.97 0.871 1.022E-03
37.75 3784.06 1740.46 0.863 467.16 37.73 5038.01 2989.34 0.863 452.41 37.75 3784.06 1740.46 0.863 1.043E-03
38.77 3891.25 1783.95 0.855 475.87 38.75 5176.77 3064.43 0.855 460.50 38.77 3891.25 1783.95 0.855 1.063E-03
39.79 3998.44 1827.44 0.847 484.13 39.77 5315.53 3139.53 0.847 468.17 39.79 3998.44 1827.44 0.847 1.083E-03
40.81 4105.63 1870.93 0.838 491.93 40.79 5454.29 3214.62 0.838 475.39 40.81 4105.63 1870.93 0.838 1.063E-03
41.83 4212.81 1914.41 0.829 499.25 41.81 5593.06 3289.72 0.829 482.17 41.83 4212.81 1914.41 0.829 1.079E-03
42.85 4320.00 1957.90 0.819 506.09 42.83 5731.82 3364.81 0.819 488.47 42.85 4320.00 1957.90 0.819 1.095E-03
43.88 4427.19 2001.39 0.809 512.42 43.85 5870.58 3439.91 0.810 494.30 43.88 4427.19 2001.39 0.809 1.109E-03
44.90 4534.38 2044.87 0.799 518.22 44.87 6009.34 3515.00 0.799 499.63 44.90 4534.38 2044.87 0.799 1.123E-03
45.92 4534.38 1981.17 0.789 511.41 45.89 6148.11 3590.10 0.789 504.46 45.92 4534.38 1981.17 0.789 1.069E-03
46.94 5751.25 3134.35 0.778 639.74 46.91 6286.87 3665.19 0.778 508.76 46.94 5751.25 3134.35 0.778 1.357E-03
47.96 5863.54 3182.94 0.767 642.88 47.93 6425.63 3740.29 0.767 512.55 47.96 5863.54 3182.94 0.767 1.364E-03
48.98 5975.83 3231.53 0.755 645.39 48.95 6564.39 3815.38 0.756 515.79 48.98 5975.83 3231.53 0.755 1.370E-03
50.00 6088.12 3280.12 0.747 650.01 49.98 6703.16 3890.48 0.744 518.49 50.00 6088.12 3280.12 0.747 1.381E-03
51.00 6841.92 3965.57 0.735 523.33
52.02 6980.68 4040.67 0.725 526.00
53.04 7119.44 4115.76 0.714 528.71
54.06 7258.21 4190.86 0.704 531.44
55.08 7396.97 4265.95 0.694 534.21
56.10 7535.73 4341.05 0.685 537.03
57.12 7674.50 4416.14 0.676 539.89
58.14 7813.26 4491.24 0.668 542.79
59.16 7952.02 4566.33 0.660 545.75
60.18 8090.78 4641.43 0.652 548.75
61.20 8229.54 4716.52 0.645 551.80
62.22 8368.31 4791.62 0.638 554.91
63.24 8507.07 4866.71 0.631 558.06
64.26 8645.83 4941.81 0.624 561.26
65.28 8784.60 5016.90 0.618 564.50
66.30 8923.36 5092.00 0.612 567.79
Chart title goes here
x-axis title here N, BPF Soil

0.0 500.0 1000.0 1500.0 2000.0 2500.0 3000.0 3500.0

0.00

Column A
Column A

10.00

20.00
Depth

30.00

40.00

50.00

60.00
60.00
Chart title goes here
x-axis title here N, BPF Soil

0.0 500.0 1000.0 1500.0 2000.0 2500.0 3000.0 3500.0

0.00

10.00

Column A
Column A

20.00
Depth

30.00

40.00

50.00
50.00

60.00
Soil
Done-Navigate
Computation of Soil Resistance
Add Profile Delete Profile Recompute Check/Accept

Num Profiles 5
Profile Num 1 Here is where the description goes for the Profile Num 2
Method SPT Data analysis as you would like Method SPT Data
Soil Profile 3 W.P. 1 Soil Profile 2
Field Profile 5 Workshop Problem 1 Field Profile 4
Load Profile 1 Notes:Workshop Problem 1 amax = 0.22 Load Profile 2
Start Depth 1 Start Depth 1
End Depth 50 End Depth 66.3
Number Data 49 Number Data 65
Depth Load,tcyc (N1)60 Resist,tcyc Depth Load,tcyc
(ft) (psf) (bpf) (psf) (ft) (psf)
1.00 12.85 56.6 90.00 5 SM 1.00 12.14
2.02 25.89 39.8 181.88 5 SM 2.02 24.46
3.04 38.86 34.7 273.75 5 SM 3.04 36.71
4.06 51.77 31.9 365.63 5 SM 4.06 48.90
5.08 64.85 30.3 453.97 5 SM 5.08 61.39
6.10 80.53 29.6 240.30 5 SM 6.10 75.47
7.13 96.14 29.1 227.45 5 SM 7.12 89.49
8.15 111.69 28.7 236.69 5 SM 8.14 103.46
9.17 127.19 29.2 282.28 5 SM 9.16 117.38
10.19 126.92 32.5 1023.11 20 SC 10.18 131.24
11.21 143.16 32.7 1118.72 20 SC 11.20 145.04
12.23 159.20 32.8 1212.68 20 SC 12.22 158.78
13.25 175.16 32.2 1306.65 20 SC 13.24 172.46
14.27 191.04 31.8 1400.62 20 SC 14.26 186.06
15.29 206.83 31.4 1494.59 20 SC 15.28 199.58
16.31 222.51 31.1 1588.56 20 SC 16.30 213.01
17.33 238.09 30.8 1682.52 20 SC 17.33 226.35
18.35 253.54 28.7 1776.49 20 SC 18.35 239.57
19.38 268.86 23.3 1870.46 20 SC 19.37 252.68
20.40 268.03 19.3 470.18 25 SC 20.39 265.66
21.42 281.17 14.3 345.45 25 SC 21.41 278.50
22.44 294.69 11.2 294.71 25 SC 22.43 291.18
23.46 308.03 10.6 293.08 25 SC 23.45 303.69
24.48 321.18 10.0 291.04 25 SC 24.47 316.01
25.50 334.12 9.4 289.34 25 SC 25.49 328.14
26.52 346.84 9.5 300.59 25 SC 26.51 340.06
27.54 359.32 10.1 325.02 25 SC 27.53 351.74
28.56 371.54 10.6 350.75 25 SC 28.55 363.18
29.58 383.49 11.2 377.03 25 SC 29.57 374.36
30.60 395.15 12.2 415.53 25 SC 30.59 385.26
31.63 406.50 13.4 463.43 25 SC 31.61 395.87
32.65 417.52 14.6 515.44 25 SC 32.63 406.17
33.67 428.21 15.8 573.05 25 SC 33.65 416.14
34.69 438.53 17.0 632.97 25 SC 34.67 425.76
35.71 448.47 18.1 704.39 25 SC 35.69 435.03
36.73 458.02 19.2 784.79 25 SC 36.71 443.92
37.75 467.16 20.3 931.40 25 SC 37.73 452.41
38.77 475.87 21.3 2675.92 25 SC 38.75 460.50
39.79 484.13 22.3 2741.16 25 SC 39.77 468.17
40.81 491.93 23.9 2806.39 25 SC 40.79 475.39
41.83 499.25 25.7 2871.62 25 SC 41.81 482.17
42.85 506.09 27.4 2936.85 25 SC 42.83 488.47
43.88 512.42 29.0 3002.08 25 SC 43.85 494.30
44.90 518.22 30.7 3067.31 25 SC 44.87 499.63
45.92 511.41 0.0 0.00 5 SM 45.89 504.46
46.94 639.74 0.0 0.00 5 SM 46.91 508.76
47.96 642.88 0.0 0.00 5 SM 47.93 512.55
48.98 645.39 0.0 0.00 5 SM 48.95 515.79
50.00 650.01 0.0 0.00 5 SM 49.98 518.49
51.00 523.33
52.02 526.00
53.04 528.71
54.06 531.44
55.08 534.21
56.10 537.03
57.12 539.89
58.14 542.79
59.16 545.75
60.18 548.75
61.20 551.80
62.22 554.91
63.24 558.06
64.26 561.26
65.28 564.50
66.30 567.79
Profile Num 3
Method Castro-Settlement
Kramer Soil Profile 3 W.P. 1
Kramer Example Field Profile 1 Some Other Descriptions
Notes: Load Profile 3 Notes:
Start Depth 1
End Depth 50
Number Data 49
(N1)60 Resist,tcyc Depth Load,gcyc (N1)60 Inc. Settle
(bpf) (psf) (ft) (%) (bpf) (ft)
34.7 116.93 0.00 SP 1.00 3.189E-05 0.0 0.000E+00
24.4 66.94 0.00 SP 2.02 7.275E-05 0.0 0.000E+00
19.9 78.65 0.00 SP 3.04 1.116E-04 0.0 0.000E+00
16.7 87.19 0.00 SP 4.06 1.495E-04 0.0 0.000E+00
13.0 84.27 0.00 SP 5.08 1.792E-04 0.0 0.000E+00
10.4 76.52 0.00 SP 6.10 2.224E-04 0.0 0.000E+00
8.1 66.34 0.00 SP 7.13 2.653E-04 0.0 0.000E+00
7.0 62.87 0.00 SP 8.15 3.079E-04 0.0 0.000E+00
6.1 59.68 0.00 SP 9.17 3.504E-04 0.0 0.000E+00
5.4 55.87 0.00 SP 10.19 3.352E-04 0.0 0.000E+00
5.0 55.87 0.00 SP 11.21 3.780E-04 0.0 0.000E+00
4.8 57.80 0.00 SP 12.23 4.204E-04 0.0 0.000E+00
4.7 59.67 0.00 SP 13.25 4.627E-04 0.0 0.000E+00
5.0 67.70 0.00 SP 14.27 5.049E-04 0.0 0.000E+00
5.7 83.84 0.00 SP 15.29 5.250E-04 0.0 0.000E+00
6.5 100.73 0.00 SP 16.31 5.654E-04 0.0 0.000E+00
7.4 122.26 0.00 SP 17.33 6.056E-04 0.0 0.000E+00
8.9 156.04 0.00 SP 18.35 6.457E-04 0.0 0.000E+00
10.4 188.87 0.00 SP 19.38 6.587E-04 0.0 0.000E+00
11.7 222.47 0.00 SP 20.40 6.566E-04 0.0 0.000E+00
12.7 250.05 0 SP 21.42 6.895E-04 0.0 0.000E+00
13.6 278.59 0 SP 22.44 7.236E-04 0.0 0.000E+00
14.4 308.19 0 SP 23.46 7.573E-04 0.0 0.000E+00
14.4 318.37 0 SP 24.48 7.907E-04 0.0 0.000E+00
14.1 324.28 0 SP 25.50 7.922E-04 0.0 0.000E+00
13.8 330.15 0 SP 26.52 8.234E-04 0.0 0.000E+00
14.0 346.41 0 SP 27.54 8.542E-04 0.0 0.000E+00
14.5 369.80 0 SP 28.56 8.844E-04 0.0 0.000E+00
15.0 393.68 0 SP 29.58 9.141E-04 0.0 0.000E+00
14.5 392.75 0 SP 30.60 9.080E-04 0.0 0.000E+00
12.6 353.40 0 SP 31.63 9.352E-04 0.0 0.000E+00
10.8 313.29 0 SP 32.65 9.617E-04 0.0 0.000E+00
10.1 303.67 0 SP 33.67 9.875E-04 0.0 0.000E+00
14.4 439.73 0 SP 34.69 1.013E-03 0.0 0.000E+00
18.6 583.90 0 SP 35.71 9.992E-04 0.0 0.000E+00
22.7 748.40 0 SP 36.73 1.022E-03 0.0 0.000E+00
19.6 650.56 0 SP 37.75 1.043E-03 0.0 0.000E+00
16.4 552.38 0 SP 38.77 1.063E-03 0.0 0.000E+00
13.2 457.07 0 SP 39.79 1.083E-03 0.0 0.000E+00
11.9 422.32 0 SP 40.81 1.063E-03 0.0 0.000E+00
11.1 407.00 0 SP 41.83 1.079E-03 0.0 0.000E+00
10.4 391.16 0 SP 42.85 1.095E-03 0.0 0.000E+00
10.1 385.98 0 SP 43.88 1.109E-03 0.0 0.000E+00
10.0 390.36 0 SP 44.90 1.123E-03 0.0 0.000E+00
9.9 394.69 0 SP 45.92 1.069E-03 0.0 0.000E+00
10.9 443.74 0 SP 46.94 1.357E-03 0.0 0.000E+00
14.3 590.74 0 SP 47.96 1.364E-03 0.0 0.000E+00
17.7 743.61 0 SP 48.98 1.370E-03 0.0 0.000E+00
20.7 898.81 0 SP 50.00 1.381E-03 0.0 0.000E+00
21.3 944.86 0 SP
21.9 991.54 0 SP
22.5 1043.83 0 SP
17.3 800.15 0 SP
11.6 547.01 0 SP
5.9 279.59 0 SP
4.2 199.23 0 SP
4.4 213.23 0 SP
4.6 227.42 0 SP
4.5 224.54 0 SP
4.0 200.99 0 SP
3.5 177.84 0 SP
5.0 264.85 0 SP
13.1 713.35 0 SP
21.0 1174.80 0 SP
0.0 0.00 0 SP
Profile Num 4
Method SPT Data
Soil Profile 3 W.P. 1
Descriptions Field Profile 5 Workshop Problem 1
Load Profile 1 Notes:Workshop Problem 1 amax = 0.22
Start Depth 1
End Depth 50
Number Data 49
Depth Load,tcyc (N1)60 Resist,tcyc
(ft) (psf) (bpf) (psf)
5 SM 1.00 12.85 56.6 101.31 5 SM
5 SM 2.02 25.89 39.8 204.74 5 SM
5 SM 3.04 38.86 34.7 308.16 5 SM
5 SM 4.06 51.77 31.9 411.58 5 SM
5 SM 5.08 64.85 30.3 511.03 5 SM
5 SM 6.10 80.53 29.6 270.51 5 SM
5 SM 7.13 96.14 29.1 256.04 5 SM
5 SM 8.15 111.69 28.7 266.44 5 SM
5 SM 9.17 127.19 29.2 317.76 5 SM
20 SC 10.19 126.92 32.5 1151.71 20 SC
20 SC 11.21 143.16 32.7 1259.34 20 SC
20 SC 12.23 159.20 32.8 1365.12 20 SC
20 SC 13.25 175.16 32.2 1470.90 20 SC
20 SC 14.27 191.04 31.8 1576.68 20 SC
20 SC 15.29 206.83 31.4 1682.46 20 SC
20 SC 16.31 222.51 31.1 1788.24 20 SC
20 SC 17.33 238.09 30.8 1894.02 20 SC
20 SC 18.35 253.54 28.7 1999.80 20 SC
20 SC 19.38 268.86 23.3 2105.57 20 SC
25 SC 20.40 268.03 19.3 529.29 25 SC
25 SC 21.42 281.17 14.3 388.87 25 SC
25 SC 22.44 294.69 11.2 331.76 25 SC
25 SC 23.46 308.03 10.6 329.92 25 SC
25 SC 24.48 321.18 10.0 327.63 25 SC
25 SC 25.50 334.12 9.4 325.71 25 SC
25 SC 26.52 346.84 9.5 338.38 25 SC
25 SC 27.54 359.32 10.1 365.88 25 SC
25 SC 28.56 371.54 10.6 394.84 25 SC
25 SC 29.58 383.49 11.2 424.42 25 SC
25 SC 30.60 395.15 12.2 467.77 25 SC
25 SC 31.63 406.50 13.4 521.69 25 SC
25 SC 32.65 417.52 14.6 580.23 25 SC
25 SC 33.67 428.21 15.8 645.08 25 SC
25 SC 34.69 438.53 17.0 712.53 25 SC
25 SC 35.71 448.47 18.1 792.93 25 SC
25 SC 36.73 458.02 19.2 883.43 25 SC
25 SC 37.75 467.16 20.3 1048.48 25 SC
25 SC 38.77 475.87 21.3 3012.29 25 SC
25 SC 39.79 484.13 22.3 3085.72 25 SC
25 SC 40.81 491.93 23.9 3159.15 25 SC
25 SC 41.83 499.25 25.7 3232.58 25 SC
25 SC 42.85 506.09 27.4 3306.01 25 SC
25 SC 43.88 512.42 29.0 3379.44 25 SC
25 SC 44.90 518.22 30.7 3452.87 25 SC
5 SM 45.92 511.41 0.0 0.00 5 SM
5 SM 46.94 639.74 0.0 0.00 5 SM
5 SM 47.96 642.88 0.0 0.00 5 SM
5 SM 48.98 645.39 0.0 0.00 5 SM
5 SM 50.00 650.01 0.0 0.00 5 SM
Profile Num 5
Method Lab Strain Data
Soil Profile 3 W.P. 1
Field Profile 1 Some Other Descriptions
Load Profile 3 Notes:
Start Depth 1
End Depth 50
Number Data 49
Depth Load,gcyc (N1)60 Resist,gcyc
(ft) (%) (bpf) (%)
1.00 3.189E-05 0.0 0.000E+00 5 SM
2.02 7.275E-05 0.0 0.000E+00 5 SM
3.04 1.116E-04 0.0 0.000E+00 5 SM
4.06 1.495E-04 0.0 0.000E+00 5 SM
5.08 1.792E-04 0.0 0.000E+00 5 SM
6.10 2.224E-04 0.0 0.000E+00 5 SM
7.13 2.653E-04 0.0 0.000E+00 5 SM
8.15 3.079E-04 0.0 0.000E+00 5 SM
9.17 3.504E-04 0.0 0.000E+00 5 SM
10.19 3.352E-04 0.0 0.000E+00 20 SC
11.21 3.780E-04 0.0 0.000E+00 20 SC
12.23 4.204E-04 0.0 0.000E+00 20 SC
13.25 4.627E-04 0.0 0.000E+00 20 SC
14.27 5.049E-04 0.0 0.000E+00 20 SC
15.29 5.250E-04 0.0 0.000E+00 20 SC
16.31 5.654E-04 0.0 0.000E+00 20 SC
17.33 6.056E-04 0.0 0.000E+00 20 SC
18.35 6.457E-04 0.0 0.000E+00 20 SC
19.38 6.587E-04 0.0 0.000E+00 20 SC
20.40 6.566E-04 0.0 0.000E+00 25 SC
21.42 6.895E-04 0.0 0.000E+00 25 SC
22.44 7.236E-04 0.0 0.000E+00 25 SC
23.46 7.573E-04 0.0 0.000E+00 25 SC
24.48 7.907E-04 0.0 0.000E+00 25 SC
25.50 7.922E-04 0.0 0.000E+00 25 SC
26.52 8.234E-04 0.0 0.000E+00 25 SC
27.54 8.542E-04 0.0 0.000E+00 25 SC
28.56 8.844E-04 0.0 0.000E+00 25 SC
29.58 9.141E-04 0.0 0.000E+00 25 SC
30.60 9.080E-04 0.0 0.000E+00 25 SC
31.63 9.352E-04 0.0 0.000E+00 25 SC
32.65 9.617E-04 0.0 0.000E+00 25 SC
33.67 9.875E-04 0.0 0.000E+00 25 SC
34.69 1.013E-03 0.0 0.000E+00 25 SC
35.71 9.992E-04 0.0 0.000E+00 25 SC
36.73 1.022E-03 0.0 0.000E+00 25 SC
37.75 1.043E-03 0.0 0.000E+00 25 SC
38.77 1.063E-03 0.0 0.000E+00 25 SC
39.79 1.083E-03 0.0 0.000E+00 25 SC
40.81 1.063E-03 0.0 0.000E+00 25 SC
41.83 1.079E-03 0.0 0.000E+00 25 SC
42.85 1.095E-03 0.0 0.000E+00 25 SC
43.88 1.109E-03 0.0 0.000E+00 25 SC
44.90 1.123E-03 0.0 0.000E+00 25 SC
45.92 1.069E-03 0.0 0.000E+00 5 SM
46.94 1.357E-03 0.0 0.000E+00 5 SM
47.96 1.364E-03 0.0 0.000E+00 5 SM
48.98 1.370E-03 0.0 0.000E+00 5 SM
50.00 1.381E-03 0.0 0.000E+00 5 SM
Liquefaction Load and Resistance
Cyclic Stress (psf)

0.00 1000.00 2000.00 3000.00 4000.00

0.00

5.00

10.00
Depth (ft)

15.00

20.00

25.00 Load
Resistance
30.00

35.00

40.00

45.00

50.00

Liquefaction Factor of Safety

Factor of Safety
Liquefaction Factor of Safety
Factor of Safety

0 1 2 3 4 5 6 7 8 9 10
0.00

5.00

10.00
Depth (ft)

Factor of
15.00 Safety
FS=1
20.00

25.00 ZoneofofPotential
Potential
Zone
Liquefaction
Liquefaction
30.00

35.00

40.00

45.00

50.00
FS
1.00 12.85 56.6 90.00 7.004453
2.02 25.89 39.8 181.88 7.025247
3.04 38.86 34.7 273.75 7.044627
4.06 51.77 31.9 365.63 7.062785
5.08 64.85 30.3 453.97 6.999727
6.10 80.53 29.6 240.30 2.984007
4000.00 7.13 96.14 29.1 227.45 2.365745
8.15 111.69 28.7 236.69 2.119072
9.17 127.19 29.2 282.28 2.219395
10.19 126.92 32.5 1023.11 8.060765
11.21 143.16 32.7 1118.72 7.814235
12.23 159.20 32.8 1212.68 7.617314
13.25 175.16 32.2 1306.65 7.459697
14.27 191.04 31.8 1400.62 7.331594
15.29 206.83 31.4 1494.59 7.226327
16.31 222.51 31.1 1588.56 7.139199
17.33 238.09 30.8 1682.52 7.066819
18.35 253.54 28.7 1776.49 7.006682
19.38 268.86 23.3 1870.46 6.956916
20.40 268.03 19.3 470.18 1.754218
21.42 281.17 14.3 345.45 1.228616
22.44 294.69 11.2 294.71 1.000085
23.46 308.03 10.6 293.08 0.951458
24.48 321.18 10.0 291.04 0.906172
25.50 334.12 9.4 289.34 0.865981
26.52 346.84 9.5 300.59 0.866659
27.54 359.32 10.1 325.02 0.904552
28.56 371.54 10.6 350.75 0.94404
29.58 383.49 11.2 377.03 0.983156
30.60 395.15 12.2 415.53 1.05159
31.63 406.50 13.4 463.43 1.140064
32.65 417.52 14.6 515.44 1.234522
33.67 428.21 15.8 573.05 1.33825
34.69 438.53 17.0 632.97 1.443391
35.71 448.47 18.1 704.39 1.570642
36.73 458.02 19.2 784.79 1.713428
37.75 467.16 20.3 931.40 1.993758
38.77 475.87 21.3 2675.92 5.623285
39.79 484.13 22.3 2741.16 5.662049
40.81 491.93 23.9 2806.39 5.704856
41.83 499.25 25.7 2871.62 5.751811
42.85 506.09 27.4 2936.85 5.803038
9 10 43.88 512.42 29.0 3002.08 5.858679
44.90 518.22 30.7 3067.31 5.918889
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Defaults and Start-up Values
Default Soil Profile Default Field Profile Useful Things to Copy
Profile 1 Fprofile 1 Depth stot seff
Start Depth (ft) 0 Type SPT (ft) (psf) (psf)
End Depth (ft) 100 Num Data 20 (N1)60
Number of Soil Layer 3 Soil Match 1 (bpf)
Depth to Groundwater 10 Depth/Value 0 12
Groundwater wt (lb/ft 64 2 5 10 Depth stot seff
Layer 1 3 10 18 (ft) (psf) (psf)
Layer Start Depth 0 4 15 15
Layer End Depth 20 5 19 9
Dry unit wt 100 6 25 12
Sat'd unit wt 120 7 30 14
UCS Classification SP 8 35 22
Percent Fines 0 9 40 31
Layer 2 10 45 33
Layer Start Depth 20 11 50 15
Layer End Depth 60 12 55 11
Dry unit wt 100 13 59 23
Sat'd unit wt 120 14 65 25
UCS Classification SP 15 70 28
Percent Fines 0 16 75 33
Layer 1 3 17 80 26
Layer Start Depth 60 18 85 32
Layer End Depth 100 19 90 34
Dry unit wt 100 20 95 27
Sat'd unit wt 120
UCS Classification SP
Percent Fines 0
rd tcyc gcyc
(---) (psf) (%)

Resist,tcycResist,gcycInc. Settle
rd (psf) (%) (ft)
(---) Load,tcycLoad,gcycLoad,gcyc
hi (psf) (%) (%)
Induced Stress Correlations

Seed and Idriss (1975) *taken from fig 3.5, Dobry, Ladd, Yokel, Chung, and Powell
Earthquake Equivalent Number of Cycles Correction Factor
Magnitude (-1 std dev) Mean (+1 std dev) (-1 std dev Mean (+1 std dev)
5 2 3.5 5 10.5 6 4.2
5.5 2 3.5 5 10.5 6 4.2
6 2.5 4 6 8.4 5.25 3.5
6.5 3.5 6 9 6 3.5 2.333333
7 5 10 14 4.2 2.1 1.5
7.5 8 15 23 2.625 1.4 0.913043
8 10 21 33 2.1 1 0.636364
8.5 13 27 42 1.615385 0.777778 0.5
(***caution extrapolation)
Seed and Idriss(1971) *taken from fig 3.4, Dobry, Ladd, Yokel, Chung, and Powell
Depth Stress Reduction Values, rd
(ft) Low Avg High
0 1.000 1.000 1.000
5 0.980 0.990 1.000
10 0.960 0.980 1.000
15 0.945 0.965 0.990
20 0.930 0.950 0.980
25 0.905 0.938 0.970 Stress Reduction vs. Depth
30 0.880 0.920 0.960
0
35 0.820 0.883 0.945
Depth, ft

40 0.760 0.845 0.930 10

45 0.685 0.795 0.905 20

50 0.610 0.745 0.880 30 Low

Polynomial
55 0.540 0.700 0.860 40 (Low )
60 0.460 0.650 0.840 Avg
50 High
65 0.420 0.620 0.820
60
70 0.380 0.590 0.800
75 0.360 0.570 0.780 70

80 0.340 0.550 0.760 80

85 0.325 0.533 0.740 90

90 0.310 0.515 0.720 100
95 0.305 0.505 0.705 Stress Reduction Factor
0.200 0.300 0.400 0.500 0.600 0.700 0.8

100 0.300 0.495 0.690

Seed & Idriss
Eq Num Cy

Equiv. Num. Cycles vs. Earthquake Magnitude EERI Curves

45
Mag N
40 1
35
(-1 std dev)
1.5
30 Polynomial ((-1 2.6
std dev))
25 Mean 6.00 6
Polynomial
20 (Mean) 6.75 10
15 7.50 15
10 8.50 26
5 60
0 100
5 5.5 6Earthquake
6.5 7Magnitude,
7.5 M
8 8.5 9

T/Tl vs N Seed & Idriss

1
0.9
0.8
0.7
T/Tl
0.6
ress Reduction vs. Depth 0.5
0.4
0.3
0.2
Low 0.1
Polynomial 0
(Low )
Avg 1 10
N
High

ress Reduction Factor, rd

00 0.400 0.500 0.600 0.700 0.800 0.900 1.000
Seed & Idriss
EERI Curves
T/Tl tt/ttn15 log10 Neq y = 0.2776x6 - 2.1555x5 + 6.5006x4 - 9.6829x3 + 7.9121x2 - 4.4657x + 2.7395
1 2.739726 0 2.7395

CSR Multiplier
0.785 2.150685 0.176091 2.151491 Log Neq vs CSR Multiplier
0.63 1.726027 0.414973 1.724564
0.482 1.320548 0.778151 1.323107 3
0.412 1.128767 1 1.1257
f(x) = 0.277641 x⁶ − 2.15552 x⁵ + 6.50056 x⁴ − 9.68292 x³
2.5
0.365 1 1.176091 1.001185 + 7.91212 x² − 4.46566 x + 2.73951
0.325 0.890411 1.414973 0.890473 R²
2 = 0.999994470271155
0.3 0.821918 1.778151 0.821232
1.5
0.29 0.794521 2 0.7933
Colu
1 mn S

/Tl vs N Seed & Idriss 0.5

0
0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 2
log Neq

10 100
N
121x2 - 4.4657x + 2.7395

ultiplier

y = 0.2776x6 - 2.1555x5 + 6.5006x4 - 9.6829x3 + 7.9121x2 - 4.4657x + 2.7395

50056 x⁴ − 9.68292 x³
R2 = 1

Colu
mn S

2
657x + 2.7395
Liquefaction Resistance Correlations
Cyclic stress ratios causing liquefaction and (N1)60
Seed et al, 1984
Raw Data Interpolated Values
<5% fines 15% fines 35% fines <5% fines
15% fines 35% fines
t/so (N1)60 (N1)60 (N1)60 (N1)60 t/sot/so t/so
0 0 -5 -8 0 0
0.045455 0.072222
0.05 4.67 0.5 -2 1 0.010707
0.055556 0.083333
0.1 8.92 5 2.5 2 0.021413
0.066667 0.094444
0.15 13.61 9.67 7.17 3 0.03212
0.077778 0.105353
0.2 18.17 13.73 10.93 4 0.042827
0.088889 0.11606
0.25 22.3 17.21 14.67 5 0.053882 0.1 0.126767
0.3 25.51 20.23 17.33 6 0.065647
0.110707 0.137473
0.35 27.7 22.3 19 7 0.077412
0.121413 0.14818
0.4 28.92 23.54 20 8 0.089176
0.13212 0.161037
0.45 29.51 24.1 20.26 9 0.100853
0.142827 0.174335
0.5 29.84 24.59 20.49 10 0.111514
0.154064 0.187633
0.6 30.5 24.92 20.82 11 0.122175
0.166379 0.200936
12 0.132836
0.178695 0.214305
13 0.143497
0.19101 0.227674
14 0.154276
0.203879 0.241043
15 0.165241
0.218247 0.256203
16 0.176206
0.232615 0.275
17 0.187171
0.246983 0.293797
18 0.198136
0.263079 0.32006
19 0.210048
0.279636 0.35
20 0.222155
0.296192 0.4
21 0.234262
0.318599 0.654545
22 0.246368
0.342754 0
23 0.260903
0.378226 0
24 0.27648
0.441071 0
25 0.292056
0.624242 0
26 0.311187 0 0
27 0.334018 0 0
28 0.362295 0 0
29 0.40678 0 0
30 0.524242 0 0
0
0
N vs taucyc/sigv'
tau/sigma

0
0.5 Column
A
Column
0.4 A
Column
0.3 A
N vs taucyc/sigv'

tau/sigma
0.5 Column
A
Column
0.4 A
Column
0.3 A
Column
F
0.2

0.1

0
0 5 10 15 20 25 30
(N1)60

CPT correlations V o l. C o m p re ssio n , %

Castro correlations
Strain Vol-SP Vol-SP-SC Vol-SC
0.0001 0 0 0
0.00026 0.1 0.0689 0.0566
0.0004 0.23 0.1 0.0822 Cyclic Shear Strain vs. V
10 (Castro, 1991)
0.00054 0.33 0.145 0.1
0.0008 0.53 0.225 0.17
1
0.001 0.65 0.274 0.215
0.002 1.1 0.44 0.34
0.005 1.5 0.73 0.58 0.1
0.01 1.75 1.08 0.85
0.02 2.2 1.58 1.3 0.01
0.05 2.82 2.2411 1.895 0.0001 0.001
Cyclic Shear Strain, m

Unknown Correlation form Liquefac 3.04

CPT Corr

512 2.4
577.64 2.2
735.18 1.9
971.49 1.6
1601.64 1.3
2048 1
3072 0.78
4096 0.65
6144 0.5
10000 0.45
Magnitude Correlations
Mag CSR/CSR7.5
4 1.8
5.25 1.5
6 1.32
6.75 1.13
7.5 1
8.5 0.89
9 0.835

N vs C
0.5

Column
A
0.4 Column
A
Column
A
Column
CSR

0.3 F
A
0.4 Column
A
Column
A
Column

CSR
0.3 F

0.2

30 0.1

0
0 5 10 1
(N1
Cyclic Shear Strain vs. Vol Comp.
(Castro, 1991)

SP
SP-SC
SC

0.001 0.01
Cyclic Shear Strain, mm/mm 0.1
N vs CSR

Column
A
Column
A
Column
A
Column
F
A
Column
A
Column
A
Column
F

10 15 20 25 30
(N1)60
SP SP-SC SC
Cyclic Shear Volumetric Cyclic Shear Volumetric Cyclic Shear Volumetric
(mm/mm) (%) (mm/mm) (%) (mm/mm) (%)
0.0001 0.01 0.0001 0.01 0.0001 0.01
0.000255 0.100000 0.000401 0.100000 0.000525 0.100000
0.000377 0.200000 0.000732 0.200000 0.000961 0.200000
0.000495 0.300000 0.001151 0.300000 0.001653 0.300000
0.000637 0.400000 0.001756 0.400000 0.002599 0.400000
0.000759 0.500000 0.002522 0.500000 0.003733 0.500000
0.000904 0.600000 0.003410 0.600000 0.005047 0.600000
0.001117 0.700000 0.004474 0.700000 0.006622 0.700000
0.001299 0.800000 0.005525 0.800000 0.008429 0.800000
0.001604 0.900000 0.007033 0.900000 0.010410 0.900000
0.001922 1.000000 0.008178 1.000000 0.012476 1.000000
0.003210 1.268961 0.012858 1.268961 0.019614 1.268961
0.004212 1.410670 0.015881 1.410670 0.023506 1.410670
0.005695 1.589093 0.020000 1.589093 0.030000 1.589093
0.011965 2.000000 0.050000 2.241100 0.050000 1.895000
0.020000 2.314024
0.030000 2.579255
0.050000 2.920904
Vol. Comp e vol %
Castro, 1991
10.00 10.00 Settle
Vol. Comp. %

1.00 1.00

0.10 SP 0.10
SP-
SC
SC

0.01 0.01
0.0001 0.0010 0.0100 0.1000 0.0001
Cyclic Shearing Strain (mm/mm) Cyclic
Vol. Comp e vol %

10.00 Settlement Correlation

1.00

SP
SP-SC
0.10 SC

0.01
0.0001 0.0010 0.0100 0.1000
Cyclic Shearing Strain g cyc (mm/mm)
Greduction Curves

Dobry and Vucetic

Shear Strai Log10 of Plasticity Index
%,S-A Shear strain 0 15 30 50 100 200
[Modulus] 0.0001 -4 1 1 1 1 1 1
0.0002 -3.69897 1 1 1 1 1 1
0.0005 -3.30103 0.99 1 1 1 1 1
0.001 -3 0.984 0.992 1 1 1 1
0.002 -2.69897 0.916 0.965 0.992 1 1 1
0.005 -2.30103 0.818 0.898 0.953 0.982 0.999 1
0.01 -2 0.711 0.818 0.898 0.953 0.982 0.992
0.02 -1.69897 0.578 0.719 0.816 0.898 0.951 0.984
0.05 -1.30103 0.381 0.549 0.664 0.781 0.893 0.945
0.1 -1 0.256 0.408 0.537 0.676 0.818 0.898
0.2 -0.69897 0.16 0.287 0.416 0.535 0.713 0.818
0.5 -0.30103 0.067 0.158 0.266 0.377 0.527 0.648
1 0 0.027 0.096 0.162 0.246 0.365 0.461
2 0.30103 0.008 0.055 0.09 0.135 0.217 0.285
5 0.69897 0.004 0.028 0.045 0.068 0.109 0.142
10 1 0.002 0.014 0.023 0.034 0.054 0.071
Computational Check
pi
Strain Log strain 0 15 30 50 100 200
0.0001 -4 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.0002 -3.69897 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.0005 -3.30103 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.001 -3 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.002 -2.69897 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.005 -2.30103 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.01 -2 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.02 -1.69897 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.05 -1.30103 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.1 -1 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.2 -0.69897 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
0.5 -0.30103 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
1 0 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
2 0.30103 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
5 0.69897 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
10 1 #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
xvalue pi gmax sigv
0.0001 0 5000 650
0.011799 1.002651 0.01183
0.017626 0.671168 0.01183
0.0199 0.594478 0.01183
0.020728 0.57072 0.01183
0.021024 0.562697 0.01183
0.021128 0.559908 0.01183
0.021165 0.558929 0.01183
0.021179 0.558584 0.01183
0.021183 0.558463 0.01183
0.021185 0.55842 0.01183
0.021185 0.558405 0.01183
0.021186 0.558399 0.01183
0.021186 0.558397 0.01183
0.021186 0.558397 0.01183
0.021186 0.558397 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
0.021186 0.558396 0.01183
Greduction vs SA strain

f(x)
f(x) == −
0.000795763
0.00026416
− 0.00107787
0.000261913
0.000926923
0.000846733 x⁶
x⁶x⁶x⁶
−x⁶
+−0.0026474
0.012891
+−0.009660
0.00135
0.0125
0.0100
Strain S-A, %

Colum

+− 0.0675765
0.145385
0.0326065
0.0452499
0.0496464
0.0309078x³x³
x⁴
x³
x⁴−++0.0600847
−
+0.125005
0.141303
0.120904
0.0176587
0.0250999 x²
x²
x³x³
−−
+ 0+
0
nD
t 1 p6
Colum
nE

+−+
− 0.245011
0.474512
0.49812
0.0228865
0.171764
0.27535 xxx+++0.374009
Polyn
omial
(Colu
0.162617
0.0898399
R²
R² == 0.999835628618827
0.999081133018277
0.999468715452437
0.999740659083168
0.999903129134639
0.999917443934229
mn E)
Colum
nF
t6
Colum
nG
Polyn
omial G/Gmax
-4 (Colu-3.5 -3 -2.5 -2 -1.5 -1
mn G)

12

10
Colu
8 mn C
Colu
6 mn D
Colu
4 mn E
Colu
12

10
Colu
8 mn C
Colu
6 mn D
Colu
4 mn E
Colu
2 mn F

0
-5 -4 -3 -2 -1 0 1 2
on vs SA strain
1

0.00264745
0.0128915
+−0.00966097
0.00135836
0.0125155
0.0100459 x⁵
x⁵x⁵
x⁵
+x⁵
−−0.0721288
0.0324541
0.015239x⁴
0.9
0.8
x⁴
x⁴
76587
50999
005
847
303
904 x²x²
x³x³
−−
+ 0.375677
0.566445
+
0.0845461
0.0303356
0.174018
0.152334 x xx²
x²0.7
0.6
399
7 0.5

789
0.4
0.3
0.2
0.1
0
G/Gmax
-1.5 -1 -0.5 0 0.5 1

Colu
mn C
Colu
mn D
Colu
mn E
Colu
Colu
mn C
Colu
mn D
Colu
mn E
Colu
mn F

2
1.000
f(x)
f(x) == −1.1888E-07
3.1469E-08
3.9627E-08x⁴x⁴− +1.4926E-05
5.0000E-06
3.6908E-06x³x³+ −4.3572E-04
1.3336E-04
1.5332E-04x²x²− +7.2049E-03
3.2625E-03
9.7999E-04x x+ +1.0022E+00
1.0015E+00
9.9983E-01
R²
R² == 9.9883E-01
9.9919E-01
9.9876E-01
0.900
f(x) = 1.3986E-08 x⁴ − 3.7762E-06 x³ + 3.7727E-04 x² − 2.0528E-02 x + 1.3479E+00
R² = 9.9995E-01
0.800

f(x) = 2.2145E-08 x⁴ − 7.8671E-06 x³ + 1.0923E-03 x² − 7.2735E-02 x + 2.4976E+00

0.700
R² = 9.9925E-01

0.600
f(x) = 3.0303E-08 x⁴ − 1.1958E-05 x³ + 1.8074E-03 x² − 1.2494E-01 x + 3.6472E+00
R² = 9.9823E-01
0.500

0.400

0.300

low Polynomial (low)

0.200 avg Polynomial (avg)
high Polynomial (high)
low2 Polynomial (low2)
avg2 Polynomial (avg2)
0.100
high2 Polynomial (high2)
0 10 20 30 40 50 60 70 80 90 100
CPT vs SPT correlation chart
Qc A Qc/2 siltB Qc/3.5 ClC Qc/5 CoaD Qc/6 SanE Qc/4 CleF Qc/4.5 Silty Sand
0 0 0 0 0 0 0
200 100 57.14286 40 33.33333 50 44.44444

A Qc/2 silts,sandy silts, slightly cohesive sand-silt mixture

B Qc/3.5 Clean, fine-med sands and sl. silty sands
C Qc/5 Coarse sands and sands w/gravel
D Qc/6 Sandy gravels and gravel
E Qc/4 Clean sand
F Qc/4.5 Silty Sand

100
90
80
70
N

60
50
40
100

SPT N
30
20 80
10
0 Qc
0 40 80 120 160 200 60

40

20

0
0 40
Con
CPT to SPT Conversion
100
SPT N

80 Silts
60 Fine Sand
Sand
40
Silty Sand
20 Coarse Sands
Sandy
0
0 40 80 120 160 200 Gravel
Cone Tip Resistance, Qc (tsf)
nd

and
Sands
Kramer Example (reworked) GWT(m) 1.5 gamma sat 1.874 gamma sub 1.18
(Mg/m^3) (Mg/m^3)
Depth sigv Rd tcyc N N160 CSRl sigv' Tcycl FSL
(m) (kPa) (kPa) (kPa) (kPa)
1.2 22.1 0.994 2.28 7 17.3 22.1
2.2 42.6 0.989 4.38 4 7.9 0.087 36.40 3.17 0.72
3.2 64.0 0.982 6.53 3 5.1 0.056 47.30 2.65 0.41
4.2 85.3 0.976 8.66 3 4.6 0.051 58.80 3.00 0.35
5.2 106.7 0.968 10.80 5 7.0 0.077 70.40 5.42 0.50
6.2 128.1 0.960 12.80 9 11.7 0.130 82.00 10.70 0.84
7.2 149.5 0.951 14.80 12 14.6 0.161 93.60 15.10 1.02
8.2 170.9 0.940 16.70 12 13.7 0.151 105.30 15.90 0.95
9.2 192.3 0.926 18.50 14 15.2 0.167 116.80 19.50 1.05
10.2 213.8 0.910 20.20 9 9.3 0.102 128.40 13.10 0.65
11.2 235.1 0.886 21.70 23 22.8 0.250 140.00 35.00 1.61
12.2 256.5 0.864 23.10 13 12.4 0.136 151.30 20.60 0.89
13.2 277.9 0.835 24.10 11 10.1 0.111 163.10 18.10 0.75
14.2 299.3 0.813 25.30 11 9.8 0.108 174.70 18.90 0.75
15.2 320.7 0.767 25.60 24 20.7 0.228 186.30 42.50 1.66
16.2 342.1 0.739 26.30 27 22.5 0.245 197.90 48.50 1.84
17.2 363.5 0.704 26.60 5 4.1 0.045 209.40 9.42 0.35
18.2 384.8 0.671 26.90 6 4.7 0.052 221.10 11.50 0.43 3.28084
19.2 406.2 0.642 27.10 4 3.1 0.034 232.70 7.91 0.29 10.76391
20.2 427.7 0.625 27.80 38 28.5 0.350 244.30 85.50 3.08
gam sat 136.032 kPa>psf
Converting to American Standard Units GWT(m) 4.9 gamma dry 116.9376 gam sub 73.632 0.224809 20.88543
Depth sigv Rd tcyc N N160 CSRl sigv' Tcycl FSL
(ft) (psf) (psf) (psf) (psf)
3.9 462 0.994 48 7.0 17.3 0.000 462 0 0.00 117.2383
7.2 890 0.989 91 4.0 7.9 0.087 760 66 0.72
10.5 1337 0.982 136 3.0 5.1 0.056 988 55 0.41 136.0667
13.8 1782 0.976 181 3.0 4.6 0.051 1228 63 0.35 73.66667
17.1 2228 0.968 226 5.0 7.0 0.077 1470 113 0.50
20.3 2675 0.960 267 9.0 11.7 0.130 1713 223 0.84
23.6 3122 0.951 309 12.0 14.6 0.161 1955 315 1.02
26.9 3569 0.940 349 12.0 13.7 0.151 2199 332 0.95
30.2 4016 0.926 386 14.0 15.2 0.167 2439 407 1.05
33.5 4465 0.910 422 9.0 9.3 0.102 2682 274 0.65
36.7 4910 0.886 453 23.0 22.8 0.250 2924 731 1.61
40.0 5357 0.864 482 13.0 12.4 0.136 3160 430 0.89
43.3 5804 0.835 503 11.0 10.1 0.111 3406 378 0.75
46.6 6251 0.813 528 11.0 9.8 0.108 3649 395 0.75
49.9 6698 0.767 535 24.0 20.7 0.228 3891 888 1.66
53.1 7145 0.739 549 27.0 22.5 0.245 4133 1013 1.84
56.4 7592 0.704 556 5.0 4.1 0.045 4373 197 0.35
59.7 8037 0.671 562 6.0 4.7 0.052 4618 240 0.43
63.0 8484 0.642 566 4.0 3.1 0.034 4860 165 0.29
66.3 8933 0.625 581 38.0 28.5 0.350 5102 1786 3.08

Depth 3.9 SPT 17.36556 SigmaV 456.3 TauCyc 85.40616

Depth 7.184211 SPT 7.941792 SigmaV 741.4179 TauCyc 57.39447
Depth 10.46842 SPT 5.150437 SigmaV 983.1359 TauCyc 52.97367
Depth 13.75263 SPT 4.600186 SigmaV 1224.854 TauCyc 52.45626
Depth 17.03684 SPT 6.986621 SigmaV 1466.572 TauCyc 96.27611
Depth 20.32105 SPT 11.65388 SigmaV 1708.289 TauCyc 208.71
Depth 23.60526 SPT 14.56477 SigmaV 1950.007 TauCyc 300.8399
Depth 26.88947 SPT 13.75575 SigmaV 2191.725 TauCyc 314.5056
Depth 30.17369 SPT 15.22382 SigmaV 2433.443 TauCyc 402.1051
Depth 33.4579 SPT 9.348758 SigmaV 2675.161 TauCyc 269.7977
Depth 36.74211 SPT 22.84015 SigmaV 2916.879 TauCyc 718.6257
Depth 40.02632 SPT 12.41341 SigmaV 3158.597 TauCyc 419.5749
Depth 43.31053 SPT 10.12347 SigmaV 3400.315 TauCyc 379.1823
Depth 46.59474 SPT 9.805766 SigmaV 3642.033 TauCyc 367.3095
Depth 49.87895 SPT 20.67523 SigmaV 3883.751 TauCyc 862.7946
Depth 53.16316 SPT 22.48325 SigmaV 4125.468 TauCyc 1016.383
Depth 56.44737 SPT 4.064557 SigmaV 4367.187 TauCyc 187.0315
Depth 59.73158 SPT 4.73317 SigmaV 4608.904 TauCyc 197.3835
Depth 63.0158 SPT 3.27119 SigmaV 4850.623 TauCyc 155.8016
Depth 66.3 SPT 28.57248 SigmaV 5092.34 TauCyc 1844.93
Revsion History for Liquefac
Version 0 First version sent to SouthDiv NavFac April 18, 2002
Version 0-1 Added automatic chartbuilding capability