- CSCD核心中文核心科技核心
- RCCSE(A+)公路运输高质量期刊T1
- Ei CompendexScopusWJCI
- EBSCOPж(AJ)JST
收稿日期: 2008-01-16
修回日期: 2008-02-26
网络出版日期: 2009-11-19
Calculation of Coordinates of Stakes on Centerline and Sideline Using Excel
Received date: 2008-01-16
Revised date: 2008-02-26
Online published: 2009-11-19
利用坐标增量的基本思想,将道路曲线坐标的计算归结为3种最基本的形式——直线段、圆曲线段、缓和曲线段,直接计算出中、边线的测量坐标,省去了切线支距法坐标向测量坐标的转换过程,简化了计算思路,节约了计算量。并利用办公软件Excel的强大计算功能进行实例计算。
张宝利,薛志勤 . 利用EXCEL进行道路中边线逐桩坐标计算[J]. 隧道建设, 2008 , 28(3) : 302 -304,308 . DOI: B
The coordinate calculation of the highway curves is divided into three basic types, i.e., straight section, circular curve and transition curve, on basis of the coordinate increment principle. Without coordinate transformation, the survey coordinates of the stakes on the alignment of the centerline and sideline are directly worked out, which simplifies the calculation principle and reduces the calculation quantity. Furthermore, coordinate calculation is made for project cases by using the strong calculation functions of Excel.
/
| 〈 |
|
〉 |