| Excel在道路中线逐桩坐标计算中的应用 |
| |
| 引用本文： | 张宝利,薛志勤,杨舒诚.Excel在道路中线逐桩坐标计算中的应用[J].隧道建设,2006,26(1):32-34. |
| |
| 作者姓名： | 张宝利 薛志勤 杨舒诚 |
| |
| 作者单位： | 1. 长安大学地测学院,陕西,西安,710054
2. 榆林市建筑工程有限公司,陕西,榆林,719000 |
| |
| 摘 要： | 不论是在铁路还是公路的设计和建设中都不可避免地遇到大量的曲线计算。城市轻轨、地下铁道、水建工程等大型工程亦是如此。红外测距仪、全站仪的广泛应用，使得坐标法曲线放样的应用更加广泛。手工计算器计算，耗时、费人且易出错。数据处理软件——Excel——具有强大的计算功能，将其应用于曲线计算，会极大地节约计算量，简化计算过程，起到事半功倍的作用。结合工程实例，介绍了相应的计算方法。
|
| 关 键 词： | Excel 圆曲线 缓和曲线 |
| 收稿时间： | 2005-05-17 |
| 修稿时间： | 2005年5月17日 |
Application of EXCEL in Calculation of Coordinates
of Stakes on Centerline of Alignment |
| |
| ZHANG Bao-li,XUE Zhi-qin,YANG Shu-cheng.Application of EXCEL in Calculation of Coordinates
of Stakes on Centerline of Alignment[J].Tunnel Construction,2006,26(1):32-34. |
| |
| Authors: | ZHANG Bao-li XUE Zhi-qin YANG Shu-cheng |
| |
| Institution: | 1.School of Geology &;|Survey of Chang'an University2.Yulin Construction Co., Ltd |
| |
| Abstract: | The calculation of curves is inevitably encountered in the design and construction of railways, highways, mass rapid transit systems and water delivery projects. Due to the wide application of infrared distance meters and total stations, coordinate method is widely used in the layout of curves. When calculators are used in the coordinate calculations, the working efficacy is low and it is subject to make mistakes. However, if the software of EXCEL is used, the working efficiency will be greatly improved and the mistakes will be eliminated. In connection with the engineering pracrice, the article describes the calculation method. |
| |
| Keywords: | Excel |
| 本文献已被 维普 万方数据 等数据库收录！ |
| 点击此处可从《隧道建设》浏览原始摘要信息 |
| 点击此处可从《隧道建设》下载免费的PDF全文 |
|
