ISSN 2096-4498

   CN 44-1745/U

二维码

Tunnel Construction ›› 2008, Vol. 28 ›› Issue (3): 302-304,308.DOI: B

• wenzhang • Previous Articles     Next Articles

Calculation of Coordinates of Stakes on Centerline and Sideline Using Excel

HANG Baoli1,XUE Zhiqin2   

  1. 1. College of Resources and Environment, Northwest A&F University2. College of Information and Software, South China Agricultural University
  • Received:2008-01-16 Revised:2008-02-26 Online:2008-06-20 Published:2009-11-19

Abstract:

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.

Key words:  , Excelhighway sidelinehighway centerlinecoordinates of stakescircular curvetransition curve

CLC Number: