利用EXCEL进行道路中边线逐桩坐标计算

利用坐标增量的基本思想，将道路曲线坐标的计算归结为3种最基本的形式--直线段、圆曲线段、缓和曲线段，直接计算出中、边线的测量坐标，省去了切线支距法坐标向测量坐标的转换过程，简化了计算思路，节约了计算量。并利用办公软件Excel的强大计算功能进行实例计算。

Calculation of Coordinates of Stakes on Centerline and Sideline Using Excel

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.