【作者】 孙洪月； 袁希雨； 秦晓鹏； 陈立宏；

【Author】 SUN Hong-yue;YUAN Xi-yu;QIN Xiao-peng;CHEN Li-hong;Beijing Jiaotong University,School of Civil Engineering;Beijing Zhongjiao Construction Engineering Tender Co.,Ltd;

【机构】 北京交通大学土木建筑工程学院； 北京中交建设工程招标有限公司；

【摘要】 三轴实验是室内土工实验中最重要的实验之一,其数据处理工作量大,并且具有一定的复杂度。现在实验员虽大多使用Excel进行数据处理,但使用时却缺乏一定规范性。因此,为保证三轴实验数据处理的正确性,提高工作效率,有必要编制标准规范的三轴实验数据自动化电子表格:(1)采用规范的格式,便于存档,检查;(2)自动生成实验曲线,计算抗剪强度指标;(3)制作专用功能菜单,并且能生成试验报告,能直接打印存档。本文表格的编制流程及方法对开发其他土工实验以及相关计算标准化、自动化电子表格具有参考价值。更多还原

【Abstract】 The triaxial test is one of the most important tests in the geotechnical test with the characteristics of complexities and tremendous data to calculate.Nowadays,Excel can be used by most experimenters as the implement of dealing with data.However,it lacks the normalization.Therefore,it is significant to work out the normally and standardly triaxial spreadsheet to guarantee the validity of data and promote work efficiency.The triaxial spreadsheet has the following features:①using the standardized format in order to be filed and examined;②drawing up graphs automatically and further calculating the shear strength;③producing special function menu off eringsome detailed introductions.The process and method to work out the triaxial spreadsheet are of great reference value for other standardized and automated spreadsheets of the geotechnical test.更多还原