三轴压缩试验数据处理 EXCEL程序绘图模版
测力计
轴向
轴向轴向应变校正后读数
荷重变形应变减量试样面积/ 0.01mm
/ N / 0.01mm / %/ cm 2R
P = CR SD h e 1=SD h /h 01-e 1 A =A 0/(1-e 1)0
000001
5610.30.003750.9962512.052442112
673.20.60.00750.992512.097980313
785.40.90.011250.9887512.143863934
897.6 1.20.0150.98512.190096915
9109.8 1.50.018750.9812512.236683276
10122 1.80.02250.977512.283627077
11134.2 2.10.026250.9737512.330932438
12146.4 2.40.030.9712.378603569
13158.630.03750.962512.4750602210
14170.8 3.60.0450.95512.5730318911
15183 4.20.05250.947512.6725545712
16195.2 4.80.060.9412.7736653813
16195.2 5.40.06750.932512.8764026314
17207.460.0750.92512.980805915
17207.4 6.60.08250.917513.0869160316
18219.67.20.090.9113.1947752317
19231.87.80.09750.902513.304427118
19231.88.40.1050.89513.4159167119
2024490.11250.887513.5292906620
202449.60.120.8813.6445971121
21256.210.20.12750.872513.7618859122
21256.210.80.1350.86513.8812086223
22268.411.40.14250.857514.002618612422
268.4120.150.8514.12617113试样直径d 0 = 3.91 cm 试样高度h 0= 8.0 cm 试样面积A 0= 12.007 cm 2试样体积V 0 = 96.058 cm 3 试样质量m 0= 194.45 g 试样密度r 0= 2.02 g/cm 3测力计系数C = 12.20 N/0.01mm 剪切速率 1.5 mm/min 周围压力s 3= 100 kPa
序号三轴压缩试验成果整理
R
P = CR SD h e 1=SD
h /h 01-e 1 A =A 0/(1-e 1)0
000001
2069.60.30.003750.9962512.052442112
2483.520.60.00750.992512.097980313
2793.960.90.011250.9887512.143863934
29100.92 1.20.0150.98512.190096915
31107.88 1.50.018750.9812512.236683276
33114.84 1.80.02250.977512.283627077
34118.32 2.10.026250.9737512.330932438
36125.28 2.40.030.9712.378603569
39135.7230.03750.962512.4750602210
41142.68 3.60.0450.95512.5730318911
43149.64 4.20.05250.947512.6725545712
45156.6 4.80.060.9412.7736653813
47163.56 5.40.06750.932512.8764026314
49170.5260.0750.92512.980805915
51177.48 6.60.08250.917513.0869160316
53184.447.20.090.9113.1947752317
54187.927.80.09750.902513.304427118
55191.48.40.1050.89513.4159167119
56194.8890.11250.887513.5292906620
61212.289.60.120.8813.6445971121
65226.210.20.12750.872513.7618859122
67233.1610.80.1350.86513.8812086223
67233.1611.40.14250.857514.002618612468
236.64120.150.8514.12617113
7
10122 2.10.026250.9737512.330932438
11134.2 2.40.030.9712.378603569
11134.230.03750.962512.4750602210
12146.4 3.60.0450.95512.5730318911
13158.6 4.20.05250.947512.6725545712
13158.6 4.80.060.9412.7736653813
14170.8 5.40.06750.932512.8764026314
14170.860.0750.92512.980805915
15183 6.60.08250.917513.0869160316
151837.20.090.9113.1947752317
16195.27.80.09750.902513.304427118
16195.28.40.1050.89513.4159167119
17207.490.11250.887513.5292906620
17207.49.60.120.8813.6445971121
17207.410.20.12750.872513.7618859122
18219.610.80.1350.86513.8812086223
18219.611.40.14250.857514.002618612418219.6120.150.8514.12617113测力计
轴向轴向轴向应变校正后读数
荷重变形应变减量试样面积/ 0.01mm
/ N / 0.01mm / %/ cm 2R
P = CR SD h e 1=SD h /h 01-e 1 A =A 0/(1-e 1)0
000001
37.7790.30.003750.9962512.052442112
410.3720.60.00750.992512.097980313
512.9650.90.011250.9887512.143863934
512.965 1.20.0150.98512.190096915
1641.488 1.50.018750.9812512.236683276
2257.046 1.80.02250.977512.283627077
2564.825 2.10.026250.9737512.330932438
2872.604 2.40.030.9712.378603569
3385.56930.03750.962512.4750602210
3795.941 3.60.0450.95512.5730318911
41106.313 4.20.05250.947512.6725545712
44114.092 4.80.060.9412.7736653813
48124.464 5.40.06750.932512.876402631451
132.24360.0750.92512.9808059试样直径d 0 = 3.91 cm 试样高度h 0= 8.0 cm 试样面积A 0= 12.007 cm 2试样体积V 0 = 96.058 cm 3 试样质量m 0= 194.45 g 试样密度r 0= 2.02 g/cm 3测力计系数C = 2.593 N/0.01mm 剪切速率 1.5 mm/min 周围压力s 3= 400 kPa
序号
1553137.429 6.60.08250.917513.08691603 1655142.6157.20.090.9113.19477523 1757147.8017.80.09750.902513.3044271 1859152.9878.40.1050.89513.41591671 1961158.17390.11250.887513.52929066 2064165.9529.60.120.8813.64459711 2166171.13810.20.12750.872513.76188591 2269178.91710.80.1350.86513.88120862 2369178.91711.40.14250.857514.00261861 2470181.51120.150.85
14.12617113
cm2
/cm3
Pa
主应力差轴向
/ kPa应力
/ kPa
s1-s3=P/A s 1
00
50.61214932150.6121493
60.50596722160.5059672
70.32358113170.3235811
80.06499105180.064991
89.73019698189.730197
99.31919892199.3191989
108.8319969208.8319969
118.2685908218.2685908
127.1336549227.1336549
135.8463109235.8463109
144.406559244.406559
152.8143992252.8143992
151.5951353251.5951353
159.7743635259.7743635
158.4788957258.4788957
166.4295118266.4295118
174.22772274.22772
172.7798443272.7798443
180.3494405280.3494405
178.8253607278.8253607
186.166345286.166345
184.5660612284.5660612
191.6784335291.6784335
190.0019458290.0019458
cm2
cm3
a
主应力差轴向
/ kPa应力
/ kPa
s1-s3=P/A s 1
00
57.74763267257.7476327
69.03631669269.0363167
77.37240846277.3724085
82.78851328282.7885133
88.16114435288.1611444
93.49030167293.4903017
95.95381423295.9538142
101.2068925301.2068925
108.793062308.793062
113.4809815313.4809815
118.0819535318.0819535
122.595978322.595978
127.023055327.023055
131.3631845331.3631845
135.6163665335.6163665
139.7826009339.7826009
141.2462172341.2462172
142.6663598342.6663598
144.0430285344.0430285
155.5780638355.5780638
164.3670072364.3670072
167.9680829367.9680829
166.5117122366.5117122
167.5188541367.5188541
cm2
cm3
Pa
主应力差轴向
/ kPa应力
/ kPa
s1-s3=P/A s 1
00
60.73457918360.7345792
70.59029509370.5902951
80.369807380.369807
90.0731*******.0731149
89.73019698389.730197
99.31919892399.3191989
98.93817897398.938179
108.4128749408.4128749
107.5746311407.5746311
116.4396951416.4396951
125.1523512425.1523512
124.1616993424.1616993
132.6457434432.6457434
131.5788876431.5788876
139.8343197439.8343197
138.6912599438.6912599
146.71808446.71808
145.4988162445.4988162
153.2970244453.2970244
152.0015566452.0015566
150.7060888450.7060888
158.199481458.199481
156.8278092456.8278092
155.4561374455.4561374
cm2
/cm3
Pa
主应力差轴向
/ kPa应力
/ kPa
s1-s3=P/A s 1
00
6.454293599406.4542936
8.573331858408.5733319
10.67617365410.6761736
10.63568247410.6356825
33.90461213433.9046121
46.4406805446.4406805
52.57104469452.5710447
58.65281946458.6528195
68.59205369468.5920537
76.30697259476.3069726
83.89231973483.8923197
89.31813744489.3181374
96.66053752496.6605375
101.8758011501.8758011
105.0125176505.0125176 108.0844482508.0844482 111.091593511.091593 114.0339518514.0339518 116.9115248516.9115248 121.6246978521.6246978 124.3565025524.3565025 128.8915143528.8915143 127.7739579527.7739579 128.4920014
528.4920014