- CSCD核心中文核心科技核心
- RCCSE(A+)公路运输高质量期刊T1
- Ei CompendexScopusWJCI
- EBSCOPж(AJ)JST
收稿日期: 2005-05-17
网络出版日期: 2010-01-26
Application of EXCEL in Calculation of Coordinates
of Stakes on Centerline of Alignment
Received date: 2005-05-17
Online published: 2010-01-26
不论是在铁路还是公路的设计和建设中都不可避免地遇到大量的曲线计算。城市轻轨、地下铁道、水建工程等大型工程亦是如此。红外测距仪、全站仪的广泛应用,使得坐标法曲线放样的应用更加广泛。手工计算器计算,耗时、费人且易出错。数据处理软件——Excel——具有强大的计算功能,将其应用于曲线计算,会极大地节约计算量,简化计算过程,起到事半功倍的作用。结合工程实例,介绍了相应的计算方法。
张宝利 , 薛志勤 , 杨舒诚 . Excel在道路中线逐桩坐标计算中的应用[J]. 隧道建设, 2006 , 26(1) : 32 -34 . DOI: B
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 practice, the article describes the calculation method.
/
| 〈 |
|
〉 |