| Excel规划求解在桥墩沉降趋势分析中的应用 |
| |
| 引用本文： | 杨发群,邱卫宁,王俊丰,叶珉吕.Excel规划求解在桥墩沉降趋势分析中的应用[J].测绘信息与工程,2012,37(6):20-22. |
| |
| 作者姓名： | 杨发群 邱卫宁 王俊丰 叶珉吕 |
| |
| 作者单位： | 武汉大学测绘学院 武汉大学灾害监测与防治研究中心,武汉市珞喻路129号,430079 |
| |
| 摘 要： | 介绍Excel规划求解得出模型参数的方法,以武咸城际铁路桥墩沉降为例,采用双曲线和对数曲线模型,利用Excel自带的宏-规划求解来解算出两种模型的参数,从而对桥墩的沉降趋势进行分析和对最终沉降量进行预测,比较两种拟合曲线的拟合结果,选取适合桥墩沉降拟合的曲线并对拟合的残差进行二次曲线拟合,用残差二次拟合得到的最终残差值对最终沉降量进行修正,进一步提高了预测值的精度。用该方法得到了较好的效果,为铁路的铺轨以及运营提供了技术性保障。
|
| 关 键 词： | Excel规划求解 武咸城际铁路 桥墩沉降趋势分析 双曲线 对数曲线 |
Application of Excel Solver in the Bridge Pier Subsidence Trend Analysis |
| |
| YANG Faqun,QIU Weining,WANG Junfeng,YE Minlv.Application of Excel Solver in the Bridge Pier Subsidence Trend Analysis[J].Journal of Geomatics,2012,37(6):20-22. |
| |
| Authors: | YANG Faqun QIU Weining WANG Junfeng YE Minlv |
| |
| Institution: | 1 School of Geodesy and Geomatics,Wuhan University;2 Disaster Monitoring and Prevention Research Center of Wuhan University,129 Luoyu Road,Wuhan 430079,China) |
| |
| Abstract: | The paper introduces Excel solver solutions of model parameters,Taking the Wuhan-xianning intercity railway pier settlement as an example,a hyperbolic and logarithmic curve model found in Excel macros-planning two model parameters can be calculated by solving pier subsidence trend analysis and predict the final settlement amount.By comparing the two curve fitting fitting results,users ultimately can select a suitable pier settlement fitting curve,residuals,fit a quadratic curve,and correct the residual quadratic fit to get the final residuals of settlement,.This tools can further improve the prediction the accuracy of those values.By using this method better results have been achieved,providing technical support for laying railway track and train operations. |
| |
| Keywords: | excel solver Wuhan-xianning intercity railway bridge pier subsidence trend analysis hyperbola logarithmic curve |
| 本文献已被 维普 万方数据 等数据库收录！ |
|
