三轴压缩试验数据处理 EXCEL程序绘图模版

132.243
6
试样面积A 0= 12.007 cm2 试样密度r 0= 2.02 g/cm3 周围压力s 3= 400 kwk.baidu.coma
轴向
应变
校正后
应变
减量
试样面积
/%
/ cm2
e 1=SDh /h 0 0
0.00375
1-e 1 0
0.99625
A =A 0/(1-e 1) 0
12.05244211
0.0075
118.2685908 218.2685908
127.1336549 227.1336549
135.8463109 235.8463109
144.406559 244.406559
152.8143992 252.8143992
151.5951353 251.5951353
159.7743635 259.7743635
R
P = CR
SDh
0
0
0
1
5
61
0.3
2
6
73.2
0.6
3
7
85.4
0.9
4
8
97.6
1.2
5
9
109.8
1.5
6
10
122
1.8
7
11
134.2
2.1
8
12
146.4
2.4
9
13
158.6
3
10
14
170.8
3.6
11
15
183
4.2
12
16
195.2
4.8
13
16
195.2
5.4
14
17
207.4
0.98125 12.23668327
1.8
0.0225
0.9775
12.28362707
2.1
0.02625
0.97375 12.33093243
2.4
0.03
0.97
12.37860356
3
0.0375
0.9625
12.47506022
3.6
0.045
0.955
12.57303189
4.2
0.0525
0.9925
12.09798031
0.01125
0.98875 12.14386393
0.015
0.985
12.19009691
0.01875
0.98125 12.23668327
0.0225
0.9775
12.28362707
0.02625
0.97375 12.33093243
0.03
0.97
12.37860356
0.8575
14.00261861
12
0.15
0.85
14.12617113
160
主应力差 (s1-s3) / kPa
120
80
40
0
0
0.02
0.04
0.06
0.08
0.1
轴向应变 e1
cm2 /cm3 kPa
cm2 cm3 a
主应力差
轴向
/ kPa
应力
/ kPa
s 1-s 3=P /A
s1
0.0375
0.9625
12.47506022
0.045
0.955
12.57303189
0.0525
0.9475
12.67255457
0.06
0.94
12.77366538
0.0675
0.9325
12.87640263
0.075
0.925
12.9808059
15
53
16
55
17
57
18
59
19
61
三轴压缩试验成果整理
试样直径d 0 = 3.91 cm
试样高度h 0= 8.0 cm
试样体积V 0 = 96.058 cm3
试样质量m 0= 194.45 g
测力计系数C = 12.20 N/0.01mm 剪切速率 1.5 mm/min
测力计
轴向
轴向
序号
读数 / 0.01mm
荷重 /N
变形 / 0.01mm
0.15
0.85
14.12617113
试样直径d 0 = 3.91 cm
试样高度h 0= 8.0 cm
试样体积V 0 = 96.058 cm3
试样质量m 0= 194.45 g
测力计系数C = 12.20 N/0.01mm 剪切速率 1.5 mm/min
测力计
轴向
轴向
序号
读数 / 0.01mm
荷重 /N
0.0675
0.9325
12.87640263
6
0.075
0.925
12.9808059
6.6
0.0825
0.9175
13.08691603
7.2
0.09
0.91
13.19477523
7.8
0.0975
0.9025
13.3044271
8.4
0.105
0.895
13.41591671
9
0.1125
0.8875
0.0225
0.9775
12.28362707
7
10
8
11
9
11
10
12
11
13
12
13
13
14
14
14
15
15
16
15
17
16
18
16
19
17
20
17
21
17
22
18
23
18
24
18
122 134.2 134.2 146.4 158.6 158.6 170.8 170.8 183 183 195.2 195.2 207.4 207.4 207.4 219.6 219.6 219.6
/%
/ cm2
e 1=SDh /h 0
1-e 1
A =A 0/(1-e 1)
0 0.00375
0 0.99625
0 12.05244211
0.0075
0.9925
12.09798031
0.01125
0.98875 12.14386393
0.015
0.985
12.19009691
0.01875
0.98125 12.23668327
0.9475
12.67255457
4.8
0.06
0.94
12.77366538
5.4
0.0675
0.9325
12.87640263
6
0.075
0.925
12.9808059
6.6
0.0825
0.9175
13.08691603
7.2
0.09
0.91
13.19477523
7.8
0.0975
0.9025
13.3044271
12.67255457
0.06
0.94
12.77366538
0.0675
0.9325
12.87640263
0.075
0.925
12.9808059
0.0825
0.9175
13.08691603
0.09
0.91
13.19477523
0.0975
0.9025
13.3044271
0.105
0.895
13.41591671
轴向
应变
校正后
应变
减量
试样面积
/%
/ cm2
e 1=SDh /h 0
1-e 1
A =A 0/(1-e 1)
0 0.00375
0 0.99625
0 12.05244211
0.0075
0.9925
12.09798031
0.01125
0.98875 12.14386393
0.015
0.985
12.19009691
184.5660612 284.5660612
13.52929066
9.6
0.12
0.88
13.64459711
10.2
0.1275
0.8725
13.76188591
10.8
0.135
0.865
13.88120862
11.4
0.1425
0.8575
14.00261861
12
0.15
0.85
14.12617113
试样直径d 0 = 3.91 cm
试样体积V 0 = 96.058 cm3
试样质量m 0= 194.45 g
测力计系数C = 3.48 N/0.01mm 剪切速率 1.5 mm/min
测力计
轴向
轴向
序号
读数 / 0.01mm
荷重 /N
变形 / 0.01mm
试样面积A 0= 12.007 cm2 试样密度r 0= 2.02 g/cm3 周围压力s 3= 200 kPa
轴向
应变
校正后
应变
减量
试样面积
/%
/ cm2
序号
R
0
1
20
2
24
3
27
4
29
5
31
6
33
7
34
8
36
9
39
10
41
11
43
12
45
13
47
14
49
15
51
16
53
17
54
18
55
19
56
20
61
21
65
22
67
23
67
24
68
P = CR 0
69.6 83.52 93.96 100.92 107.88 114.84 118.32 125.28 135.72 142.68 149.64 156.6 163.56 170.52 177.48 184.44 187.92 191.4 194.88 212.28 226.2 233.16 233.16 236.64
158.4788957 258.4788957
166.4295118 266.4295118
174.22772 274.22772
172.7798443 272.7798443
180.3494405 280.3494405
178.8253607 278.8253607
186.166345 286.166345
0
0
50.61214932 150.6121493
60.50596722 160.5059672
70.32358113 170.3235811
80.06499105 180.064991
89.73019698 189.730197
99.31919892 199.3191989
108.8319969 208.8319969
2.1
0.02625
0.97375 12.33093243
2.4
0.03
0.97
12.37860356
3
0.0375
0.9625
12.47506022
3.6
0.045
0.955
12.57303189
4.2
0.0525
0.9475
12.67255457
4.8
0.06
0.94
12.77366538
5.4
变形 / 0.01mm
R
P = CR
SDh
0
0
0
1
6
73.2
0.3
2
7
85.4
0.6
3
8
97.6
0.9
4
9
109.8
1.2
5
9
109.8
1.5
6
10
122
1.8
试样面积A 0= 12.007 cm2 试样密度r 0= 2.02 g/cm3 周围压力s 3= 300 kPa
轴向
应变
校正后
应变
减量
试样面积
SDh
e 1=SDh /h 0
1-e 1
A =A 0/(1-e 1)
0
0
0
0
0.3
0.00375
0.99625 12.05244211
0.6
0.0075
0.9925
12.09798031
0.9
0.01125
0.98875 12.14386393
1.2
0.015
0.985
12.19009691
1.5
0.01875
20
64
21
66
22
69
23
69
24
70
200
137.429 142.615 147.801 152.987 158.173 165.952 171.138 178.917 178.917 181.51
6.6
0.0825
0.9175
13.08691603
7.2
0.09
0.91
13.19477523
7.8
试样高度h 0= 8.0 cm
试样体积V 0 = 96.058 cm3
试样质量m 0= 194.45 g
测力计系数C = 2.593 N/0.01mm 剪切速率 1.5 mm/min
测力计
轴向
轴向
序号
读数 / 0.01mm
荷重 /N
变形 / 0.01mm
R
P = CR
SDh
0
0
0
1
3
7.779
0.3
6
15
17
207.4
6.6
16
18
219.6
7.2
17
19
231.8
7.8
18
19
231.8
8.4
19
20
244
9
20
20
244
9.6
21
21
256.2
10.2
22
21
256.2
10.8
23
22
268.4
11.4
24
22
268.4
12
试样面积A 0= 12.007 cm2 试样密度r 0= 2.02 g/cm3 周围压力s 3= 100 kPa
0.01875
0.98125 12.23668327
0.0225
0.9775
12.28362707
0.02625
0.97375 12.33093243
0.03
0.97
12.37860356
0.0375
0.9625
12.47506022
0.045
0.955
12.57303189
0.0525
0.9475
0.0975
0.9025
13.3044271
8.4
0.105
0.895
13.41591671
9
0.1125
0.8875
13.52929066
9.6
0.12
0.88
13.64459711
10.2
0.1275
0.8725
13.76188591
10.8
0.135
0.865
13.88120862
11.4
0.1425
2
4
10.372
0.6
3
5
12.965
0.9
4
5
12.965
1.2
5
16
41.488
1.5
6
22
57.046
1.8
7
25
64.825
2.1
8
28
72.604
2.4
9
33
85.569
3
10
37
95.941
3.6
11
41
106.313
4.2
12
44
114.092
4.8
13
48
124.464
5.4
14
51
8.4
0.105
0.895
13.41591671
9
0.1125
0.8875
13.52929066
9.6
0.12
0.88
13.64459711
10.2
0.1275
0.8725
13.76188591
10.8
0.135
0.865
13.88120862
11.4
0.1425
0.8575
14.00261861
12
0.1125
0.8875
13.52929066
0.12
0.88
13.64459711
0.1275
0.8725
13.76188591
0.135
0.865
13.88120862
0.1425
0.8575
14.00261861
0.15
0.85
14.12617113
试样直径d 0 = 3.91 cm
试样高度h 0= 8.0 cm