• 中国科学引文数据库(CSCD)来源期刊
  • 中文核心期刊中文科技核心期刊
  • Scopus RCCSE中国核心学术期刊
  • 美国EBSCO数据库 俄罗斯《文摘杂志》
  • 《日本科学技术振兴机构数据库(中国)》
二维码

隧道建设(中英文) ›› 2006, Vol. 26 ›› Issue (1): 32-34.DOI: B

• 研究与探索 • 上一篇    下一篇

Excel在道路中线逐桩坐标计算中的应用

张宝利, 薛志勤, 杨舒诚   

  1. 1.长安大学地测学院2.榆林市建筑工程有限公司
  • 收稿日期:2005-05-17 出版日期:2006-02-20 发布日期:2010-01-26
  • 作者简介:张宝利(1974-)|男|工程师,在中隧集团三处有限公司精测队从事测量工作|现长安大学研究生在读.

Application of EXCEL in Calculation of Coordinates
of Stakes on Centerline of Alignment

 ZHANG Bao-Li, XUE Zhi-Qi, YANG Shu-Cheng   

  1. 1.School of Geology &|Survey of Chang'an University2.Yulin Construction Co., Ltd
  • Received:2005-05-17 Online:2006-02-20 Published:2010-01-26

摘要:

不论是在铁路还是公路的设计和建设中都不可避免地遇到大量的曲线计算。城市轻轨、地下铁道、水建工程等大型工程亦是如此。红外测距仪、全站仪的广泛应用,使得坐标法曲线放样的应用更加广泛。手工计算器计算,耗时、费人且易出错。数据处理软件——Excel——具有强大的计算功能,将其应用于曲线计算,会极大地节约计算量,简化计算过程,起到事半功倍的作用。结合工程实例,介绍了相应的计算方法。

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 practice, the article describes the calculation method.

中图分类号: