非线性方程的Excel拟合及在沉降评估中的应用

曲线拟合是沉降评估的重要步骤,处理方法和过程比较复杂,需要编制专门程序进行数据处理与计算.作者利用Excel中的规划求解功能,分步实现沉降观测中的曲线方程拟合;利用Excel的表格功能,可实现沉降预估指标的计算.本文叙述的方法直接利用Excel的数据格式和功能,方便快捷,能满足铁路沉降观测计算的需要,方便工程技术人员掌握和应用.

Non-linear equation's fitting by using Excel and its application in sedimentation evaluation

The curve fitting was an important step in sedimentation evaluation.Processing method and procedure were so complex that need compile special program to process or calculate data.In this paper,the curve fitting for evaluating the sedimentation was achieved by using the Planning Solution of Excel.The calculation for estimating index of sedimentation was also approached by using the table function of Excel.Thus,the method which utilized the special functions of Excel adequately could apply for the calculating the sedimentation amount in railway.Engineers could hold the method easily.