ISSN 2096-4498
CN 44-1745/U
Tunnel Construction ›› 2008, Vol. 28 ›› Issue (6): 731-735.DOI: A
• wenzhang • Previous Articles Next Articles
WANG Jun
Received:
Revised:
Online:
Published:
Abstract:
Taking the calculation of the coordinates of the connecting traverses and the calculation of the coordinates of highway centerline stakes as examples, the author analyses some related functions of Excel in highway survey calculations. According to the actual calculation process of each case and the worksheet structures designed by the program, the author presents the functions and equations used in the main cells with screen capture of the worksheets. Moreover, the author mainly analyses how to use IF nested function to reduce the manual judgment and how to rationally dispose the worksheet structures by means of detailed calculation process and program analysis.
Key words: excel, survey functionconnecting traverse coordinatecalculationworksheet
CLC Number:
U 452
WANG Jun. Application of Excel in Survey Calculations in Jiping Highway in Qingdao[J]. Tunnel Construction, 2008, 28(6): 731-735.
0 / / Recommend
Add to citation manager EndNote|Ris|BibTeX
URL: http://www.suidaojs.com/EN/A
http://www.suidaojs.com/EN/Y2008/V28/I6/731