1、cI|: 1673- 0291( 2010) 01-0054- 04? k ) 0VE陈立宏,唐松涛,张洪涛(Yvr !y,100044)K 1:常规三轴试验是岩土工程中最为重要的试验之一.由于三轴试验数据较多,在处理过程中采用作图法,试验结果受人为因素的影响很大.本文采用 Excel对试验结果进行记录和处理,通过Excel的线性拟合函数直接求得三轴试验的抗剪强度指标, 并利用 Excel内置的VBA 语言编写程序绘制莫尔圆. 该方法简单,直观, 便于操作, 对三轴试验的数据处理具有参考价值.1oM:三轴实验;电子表格; 抗剪强度; 莫尔圆ms |: TU 41117 DS : AExcel
2、Method in Triaxial Test Data ProcessingCHEN Lihong, TANG Songtao, ZHANG Hongtao( School of Civil Engineering, Beijing Jiaotong University, Beijing 100044, China)Abstract:The triaxial test is one of the most important tests in Geotechnical engineering. Because ofthe massive test data and the use of g
3、raphing method in data processing, the test results are affected byhuman factors greatly. Aim ing at the situation mentioned above, this paper uses Excel to record andprocess the test data, calculates the shear strength index directly via the linear fitting function, anddraw s the Mohr circle by cod
4、ing a program of VBA. T his method is simple, direct, and easy to use,and is also of great reference value for the triaxial test data processing.Key words:triaxial test; excel; shear strength; Mohr circlel : 2008-10-16Te: ( 1975) ) , 3,Z U , q,p V. email:lhchen bjtu. edu. cn. k i =r8 Fg B1ZE,9 d1ZE,
5、g kM1, g M kZE1 . r“ Hq V ea s vl V e,7O V r8 = d# 8M, H kV sg M K. k$ ,A ) M1 k , _M1“ wLa # L, Fg S. 5r k?6 1 k W% : cVa9 TmZE,9Bt Z q ? k 1) .t qM1,Excel 7? k) 0V / :1)0V T a k i% P, q 2.2)L Pg.3)m 4a?S,7 O V3) qWord LC .1 k : c) ks%g M s(% k5g MV). k“% -8? 3M,1,Y L9 Me 9 ZE, V1 U. : h0aA 0aV 0sY
6、 k“ Sa a8; hcaA caVcsY k“%a a8; $ha$VsY%/ % .34 1 2010 M2 Y v JOURNAL OF BEIJING JIAOTONG UNIVERSITY Vol. 34 No. 1Feb. 2010V1 k“%a a89 Tab. 1 Calculation of the height, area,volume of t he specimen after consolidat ion Y 8 Sh0 A 0= PD2/ 4 V0= h 0A 0 L9 h c= h 0- $h c A c=V0- $Vh c Vc= h cA cMe9 h c=
7、 h0 1-$VV01/ 3A c= A 0 1- $VV02/ 3Vc= h cA c L= k“%Mi_ (,“ L 9 T , H%/ 1 4, k?Me 9 .g MV, “ k“ ,r8 ?3M,yN1n.UU (% ) k, n A a = A 0/ (1 - E1) ( 1)CU(% ) k, n A a = A c/ ( 1- E1) ( 2)CD(% ) k, n A a = ( Vc - $Vi )/ ( hc - $hi) ( 3) ( R1 - R3) = CR/ A a ( 4)T: $Vi kg M k“8M;$hig M H k“_M; E1g M H k“_M;
8、 C “ ( N/ 0101 mm ) ; R sV ( 0101 mm ) ; R1v ; R3l . Lr“8? 3M,8M$Vi ,yN 8MEv = $ViVc(5)Mr“_MEr = Ev - E12 (6) V1 T( 1) T( 6),I m1 U/ k ) 0V.Vs / s. P k SHqr“j, % -r“ a8 ML !9 % k“a 8.V/g MVMsV a sV 8 ,5 T(1) T(6)9 k“Z_M.m1A U TV/ CD1g M0,100 kPa HCDg M k 9 T. )Y/ k | i MTV, / CD2g M0 / CD6g M0.m1 :
9、c k TVFig. 1 Worksheet for triaxial test data recording551 :? k ) 0VEm3 9 r8 Fg mTVFig. 3 W orksheet for the shear strength parameters calculation and graphics drawing2 Fg S9 Fg ,?Syp TmZE1 .B : ML, | q ;= YV (L, L A aW p*c = “ f ( m2 U) 2 .TmEm2 r8 Fg 9 UimFig. 2 Graphics for calculating the shear
10、strengthparameters of soilVE y ,+Y k“ v2 H, :L 4 m. Fg ZET;) V 3 , 1 Kl=E EZE:B Ep - qE,9 m m2 U;6B E Hv l R1- R3E,V7 p Fg S. p - qEM1Tq = a + p tan A ( 7)f = tan U= tan( arcsin(tan A)c = acos U= acos( arcsin( tan A) ) ( 8)7vl 1“ VV UR1 = 2 ctan U2 + P4 +R3tan2 U2 + P4 = A + BR3 (9)yN,f = tan U= tan
11、 2arctanB 015 - P2c = A2tan U2 + P4= A2B015 (10)Excel4 Kl=EL E9 fINTERCEPT , SLOPECORREL,sY p a| qM1“ . f INTERCEPT,SLOPE VZL p L| qtanA a#R3- R1L| qA B.“,T(8) T(10) V y p F k Fg .m3 UV I L H)Y, JM/ H , KaLaM5 pv apq.O5aO6 p - qL E| q, O8O95 T( 7)a T( 8) pFg . P R1- R3E pT. F k V ?C k“ f ,9 T+YIff 9
12、F k“ ,“I3 F k k“,9 V1.56 Y v 34 3 m L m -_M wLa8M-_Y wL :. - wLm V L 9 TExcelmV.7 :5M ,yExcelmVi 3 ?,7OExcelmVxayUS1 ,1 n5 3 : , Excel =VBAImV, PmVxayUS1 . : H|s12s, 12sUS9 TRdj = p - qsin j P12 (11)Sdj = qcos j P12 (12)T: p = R1+ R32 , q= R1- R32 ; j = 0 12sI|.T( 11) T( 12) 3 m3 UTV/ Graph017 29, t
13、 VM :. mV, P :A U1 ,TV/ Graph09F B 7 f,i IM, :Private Sub CmdAdjust- Click( )Dim Rowst , Rowst1 As IntegerRowst= 34Rowst1= Rowst + 1-* * . !mVUSa YActiveSheet. ChartObjects(/mV60) . ActivateWith ActiveChart. Axes( xlCategory). M inimumScale= Cells( Rowst, 10). M aximumScale= Cells( Rowst, 11). M ino
14、rUnitIsAuto= True. M ajorUnit= Cells( Row st, 12)End W ithWith ActiveChart. Axes( xlValue). M inimumScale= Cells( Rowst1, 10). M aximumScale= Cells( Rowst1, 11). M inorUnitIsAuto= True. M ajorUnit = Cells( Rowst1, 12)End With-* * .mVxay1 ActiveSheet. ChartObjects(/mV60 ) . ActivateActiveChart. PlotA
15、rea. SelectSelection. W idth= 318Ylen= Cells( Row st1, 11) - Cells( Rowst1, 10)Xlen= Cells( Rowst, 11) - Cells( Rowst, 10)Selection. Height= Selection. Width * Ylen/ XlenEnd Sub Pm 4,9F xayUSKvKl# Y e.V/| u M1 , / :1 0 f, V m, m3 U.4 Excel ) q, Excel9m ?I ? L ) 0V, PeaZL.Excel =LBf f LC Fg 1 p,iVBAI
16、 :mf . 0V V p* = ,E )V y , ? a kwL. ID: 1 SL237- 1999,r k? S .:S , 1999.SL237-1999, Specification of Soil T est S . Beijing: ChinaW ater Pow er Press, 1999. ( in Chinese) 2J, .r M .: bv, 1994.CHEN Zhongyi, ZHOU Jingxing, WANG Hongjin. SoilM echanics M . Beijing: Tsinghua University Press, 1994.( in Chinese) 3 ,C, . k Fg SLBZE) J .r , 2005, 26( 11) : 1785 -1789.CHEN Lihong, CHEN Zuyu, LI Guangxin. Discussion ofLinear Regression M ethod to Estimate Shear Strength Pa-rameters From Results of T riaxial Tests J . Rock and SoilM echanics, 2005, 26( 11) : 1785- 1789. ( in Chinese)571 :? k ) 0VE
