| 常规三轴试验数据处理的电子表格法 |
| |
| 引用本文： | 陈立宏,唐松涛,张洪涛.常规三轴试验数据处理的电子表格法[J].北京交通大学学报(自然科学版),2010,34(1):54-57. |
| |
| 作者姓名： | 陈立宏 唐松涛 张洪涛 |
| |
| 作者单位： | 北京交通大学,土木建筑工程学院,北京,100044;北京交通大学,土木建筑工程学院,北京,100044;北京交通大学,土木建筑工程学院,北京,100044 |
| |
| 摘 要： | 常规三轴试验是岩土工程中最为重要的试验之一.由于三轴试验数据较多,在处理过程中采用作图法,试验结果受人为因素的影响很大.本文采用Excel对试验结果进行记录和处理,通过Excel的线性拟合函数直接求得三轴试验的抗剪强度指标,并利用Excel内置的VBA语言编写程序绘制莫尔圆.该方法简单,直观,便于操作,对三轴试验的数据处理具有参考价值.
|
| 关 键 词： | 三轴实验 电子表格 抗剪强度 莫尔圆 |
Excel Method in Triaxial Test Data Processing |
| |
| CHEN Lihong,TANG Songtao,ZHANG Hongtao.Excel Method in Triaxial Test Data Processing[J].JOURNAL OF BEIJING JIAOTONG UNIVERSITY,2010,34(1):54-57. |
| |
| Authors: | CHEN Lihong TANG Songtao ZHANG Hongtao |
| |
| Institution: | 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 of the massive test data and the use of graphing method in data processing,the test results are affected by human factors greatly.Aiming at the situation mentioned above,this paper uses Excel to record and process the test data,calculates the shear strength index directly via the linear fitting function,and draws the Mohr circle by coding a program of VBA.This method is simple,direct,and easy to use,and is also of great... |
| |
| Keywords: | triaxial test excel shear strength Mohr circle |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
