地基系数拟合曲线的设计与分析

Design and Analysis of Fitting Curve of Foundation Coefficient

本文基于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.