The Application of Excel in Highway Vertical Curve

DOI

10.2991/icwcsn-16.2017.121How to use a DOI?

Keywords

vertical curve; elevation; superelevation; visual basic for application

Abstract

When we are layouting field route, the calculation of designed elevation in vertical and horizontal section is big workload and very tedious. So using Excel which has powerful data processing function and convenient operation of the form to complete a large number of height calculation in vertical and horizontal section is very convenient and practical. The paper discussed about the elevation's calculation principle of middle and side stakes in vertical curve, and mainly studied the calculation method of superelevation transition section's elevation on the winding mountain road which was accomplished by Visual Basic for Application (VBA). Then we transform the result to the required format which can transfer to the total station, so the result could layout quickly and accurately at the scene. In short, using Excel to calculate vertical curve elevation is very simple and practical. It will not only greatly improve working efficiency, but also reduce the chance of errors.

Copyright

© 2017, the Authors. Published by Atlantis Press.

Open Access

This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

TY  - CONF
AU  - Shan Li
AU  - Li-Hong Shi
PY  - 2016/12
DA  - 2016/12
TI  - The Application of Excel in Highway Vertical Curve
BT  - Proceedings of the 3rd International Conference on Wireless Communication and Sensor Networks (WCSN 2016)
PB  - Atlantis Press
SP  - 598
EP  - 602
SN  - 2352-538X
UR  - https://doi.org/10.2991/icwcsn-16.2017.121
DO  - 10.2991/icwcsn-16.2017.121
ID  - Li2016/12
ER  -