Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)

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/).

Download article (PDF)

Volume Title
Proceedings of the 2017 2nd International Conference on Materials Science, Machinery and Energy Engineering (MSMEE 2017)
Series
Advances in Engineering Research
Publication Date
May 2017
ISBN
10.2991/msmee-17.2017.306
ISSN
2352-5401
DOI
10.2991/msmee-17.2017.306How to use a DOI?
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  -