摘要
本文基于Microsoft Office Excel中函数和高等数学中求导的运用对路基地基系数试验进行拟合作图,主要阐述拟合曲线程序的设计[1]及结合相关规范对其进行分析,该程序实用性强,只需输入检测数据后,曲线图(荷载强度σ-下沉量S关系)自动生成并在图像下侧显示曲线的二元二次方程及曲线相关性R2,所得效果完全符合《铁路工程土工试验规程》(TB10102-2010)中对曲线的拟合和修正的要求。
This article is based on Microsoft Office Excel function and application of higher mathematics in the derivation of drawing on subgrade foundation coefficient test,mainly including the design of the fitted curve program [1],and in combination with the relevant specification to analyze it,the program is practical,simply type test data,graph(load strength sink of sigma-S relationship) automatically generated and side under the image display curve of binary quadratic equation and curve correlation R2,The results are in full compliance with the requirements of curve fitting and modification in tb10102-2010.
引文
[1]刘琼,龚劬.数学实验[M].北京:高等教育出版社,2004.
[2]王智超,罗迎社,龚卫锋,等.高填方路基压实土力学性状实验[J].铁道科学与工程学报,2010(4):77-80.WANG Zhi-chao,LUO Ying-she,GONG Wei-feng,et al.Study on me-chanical characters of high-filled subgrade compacted soil by experiment[J].Journal of Railway Science and Engineering,2010(4):74-77.
[3]TB10102-2010铁路工程土工试验规程[S].TB10102-2010Code for Soil Test of Railway Engineering[S].