Highway Middle Pile Coordinate Automatic Calculation based on Combine of Excel and Excel VBA Program
Authors
Guo-wen Che
Corresponding Author
Guo-wen Che
Available Online May 2017.
- DOI
- 10.2991/msmee-17.2017.306How to use a DOI?
- Keywords
- Excel software, Excel VBA program, Highway Horizontal Alignment, circular curve, transition curve, pile point coordinate
- Abstract
In the highway design and construction, it is common to calculate the middle pile point coordinates. Application the data calculation, data processing function and function library of Excel software establish worksheet calculation model of route transverse. Then using Excel VBA program achieves automatic calculation of road middle pile point coordinates. Results show, this fast and accurate calculation method has strong practicality and generality and can be used as a reference for the highway construction personnel.
- 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/).
Cite this article
TY - CONF AU - Guo-wen Che PY - 2017/05 DA - 2017/05 TI - Highway Middle Pile Coordinate Automatic Calculation based on Combine of Excel and Excel VBA Program BT - Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017) PB - Atlantis Press SP - 1690 EP - 1696 SN - 2352-5401 UR - https://doi.org/10.2991/msmee-17.2017.306 DO - 10.2991/msmee-17.2017.306 ID - Che2017/05 ER -