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

测力计轴向轴向轴向应变校正后读数荷重变形应变减量 试样面积/ 0.01mm/ N/ 0.01mm/ %/ cm2RP = CRSDhe 1=SDh /h 01-e 1A =A 0/(1-e 1)00000015610.30.003750.9962512.052442112673.20.60.00750.992512.097980313785.40.90.011250.9887512.143863934897.61.20.0150.98512.1900969159109.81.50.018750.9812512.236683276101221.80.02250.977512.28362707711134.22.10.026250.9737512.33093243812146.42.40.030.9712.37860356913158.630.03750.962512.475060221014170.83.60.0450.95512.5730318911151834.20.05250.947512.672554571216195.24.80.060.9412.773665381316195.25.40.06750.932512.876402631417207.460.0750.92512.98080591517207.46.60.08250.917513.086916031618219.67.20.090.9113.194775231719231.87.80.09750.902513.30442711819231.88.40.1050.89513.41591671192024490.11250.887513.5292906620202449.60.120.8813.644597112121256.210.20.12750.872513.761885912221256.210.80.1350.86513.881208622322268.411.40.14250.857514.002618612422268.4120.150.8514.12617113测力计轴向轴向轴向应变校正后读数荷重变形应变减量 试样面积/ 0.01mm/ N/ 0.01mm/ %/ cm2试样直径d 0 = 3.91 cm 试样高度h 0= 8.0 cm 试样面积A 0= 12.007 cm2试样体积V 0 = 96.058 cm3 试样质量m 0= 194.45 g 试样密度r 0= 2.02 g/cm3测力计系数C = 12.20 N/0.01mm 剪切速率 1.5 mm/min 周围压力s 3= 100 kPa序号试样直径d 0 = 3.91 cm 试样高度h 0= 8.0 cm 试样面积A 0= 12.007 cm2试样体积V 0 = 96.058 cm3 试样质量m 0= 194.45 g 试样密度r 0= 2.02 g/cm3测力计系数C = 3.48 N/0.01mm 剪切速率 1.5 mm/min 周围压力s 3= 200 kPa序号三轴压缩试验成果整理RP = CRSDhe 1=SDh /h 01-e 1A =A 0/(1-e 1)00000012069.60.30.003750.9962512.0524421122483.520.60.00750.992512.0979803132793.960.90.011250.9887512.14386393429100.921.20.0150.98512.19009691531107.881.50.018750.9812512.23668327633114.841.80.02250.977512.28362707734118.322.10.026250.9737512.33093243836125.282.40.030.9712.37860356939135.7230.03750.962512.475060221041142.683.60.0450.95512.573031891143149.644.20.05250.947512.672554571245156.64.80.060.9412.77366538134716...