Excel VBA在道路工程测量中的应用

在道路工程测量中,为了避免变坡点处的坡度出现急剧变化,保证车辆运行安全稳定,竖曲线的测设是至关重要的,其中竖曲线的曲线要素计算是测设的第一个关键步骤,以往大部分数据计算都由人工手算,计算过程繁琐、效率低、出错概率高。文章分析了竖曲线的计算原理,使用EXCEL表格中的VBA进行简单的程序编写,自动进行曲线要素的计算,为进行竖曲线测设提供了快速准确的数据。

In the road engineering survey,in order to avoid the sharp change of the slope at the slope change point and ensure the safe and stable operation of the vehicle,the measurement and design of the vertical curve is very important,in which the calculation of the curve elements of the vertical curve is the first key step of the survey.In the past,most of the data were calculated by manual,which has the advantages of tedious calculation process,low efficiency and high error probability.This paper analyzes the calculation principle of vertical curve,compiles a simple program with VBA in EXCEL table,and calculates the elements of curve automatically,which provides fast and accurate data for vertical curve measurement.