Spreadsheet of Consolidation Test
Spreadsheet of Consolidation Test
Spreadsheet of Consolidation Test
INPUT DATA
initial height of soil sample Ho 2 cm
Dia of sample Dia 6 cm Load Kpa 25
Cross sectional area A 28.27404 cm2 time (min) DR
Least count LC 0.001 cm 0 0
Specific Gravity Gs 2.65 1 2.5
density of water 1 g/cm3 2 4
Drainage condition doubly 4 5
Method used for curves Taylor 8 6
Weight of ring W1 42.25 g 15 7
Weight of wet soil + ring before test W2 157.76 g 30 8
60 9
120 10
1440 11
Preconsolidation Pressure Ch
0.80
0.70
Preconsolidation Press Preconsolidation Pressure Ch
Pressure void ratio 0.80
Kpa e
0.70
25 0.70
0.60
50 0.69
100 0.66 0.50
Cv for 25 KPa
Cv for 25 kPa 0.00 5.00 10.00 15.00 20.00 25.00 30.00
0
Time(min) Sqrt time DR
0 0.00 0 2
1 1.00 2.5
2 1.41 4 4
4 2.00 5
6
8 2.83 6
15 3.87 7 8
30 5.48 8
60 7.75 9 10
120 10.95 10
12
1440 37.95 11
Cv for 50 kPa
timw sqrt time DR Cv for 50 KPa
0 0.00 11 0.00 5.00 10.00 15.00 20.00 25.00 30.00
0
1 1.00 16
5
2 1.41 18
4 2.00 20 10
15
20
25
0.00 5.00 10.00 15.00 20.00 25.00 30.00
0
5
10
8 2.83 22 15
15 3.87 24 20
30 5.48 26
25
60 7.75 28
30
120 10.95 30
1440 37.95 33 35
1440 37.95 61 70
350
Cv for 800 kPa
0 0.00 167 Cv for 800 kPa
1 1.00 172 0.00 5.00 10.00 15.00 20.00 25.00 30.00
0
2 1.41 177 50
4 2.00 183 100
8 2.83 189 150
200
15 3.87 197 250
30 5.48 206 300
60 7.75 216 350
400
120 10.95 220 450
1440 37.95 445 500
SUMMARY OF RESUL
e vs log P
0.8
0.7
0.6 e1 0.61
0.5 e2 0.54
0.4
Cc 0.397521
0.3
e1 0.7
0.2 z e2 0.69
0.1 Cs 0.056789
0
1 10 100 1000 10000
s P Graph
210 kPa P1 100 e1 0.661314
P2 200 e2 0.559356
av 0.00102
mv 0.000595
for 25 KPa
20.00 25.00 30.00 35.00 40.00 Cv for 25 kPa
T90 0.848
t90 24.01 min
Hdr 0.9945 cm
Cv 0.034931 cm2/min
v for 50 KPa
0 20.00 25.00 30.00 35.00 40.00
Cv for 50 kPa
T90 0.848
Find value of t90 from t90 1
graph and put in green box
as explained in video.
0 20.00 25.00 30.00 35.00 40.00
0.557684 cm2/min
EO FOR PROPER UNDERSTANDING AND USE OF THIS SPREADHSEET.Do SUBSCRIBE FOR MORE SUCH DATASHEETS AND ALSO JOIN OUR
FACEBOOK GROUP FOR LEARNING PROGRAMS.THE LINK FOR YOUTUBE AND FACEBOOK ARE GIVEN BELOW.
= https://youtu.be/7gdSFD098xM
NK = https://www.facebook.com/groups/2837680689793038/?
SUMMARY OF RESULTS
e0 0.713578
Hs 1.167148 cm
Cc 0.397521
Cr 0.056789
ure 140 kPa
sion av 0.00102
ompressibility mv 0.000595
Vertical Consolidation Cv cm2/min
800 1600
DR Dr
167 225
172 240
177 252
183 260
189 272
197 280
206 285
216 290
220 300
445 575
P1 200
P2 300
P1 60
P2 90
Cr
SHEETS AND ALSO JOIN OUR
ELOW.
0