Site Elevation Optimization & Earthwork Volume Calculation And Excel VBA Program Realization

Due to the accurate degree is worse, the calculation while revising and adjusting is complicated and easily makes mistakes, the efficiency in the traditional method of site elevation ascertainment and earthwork volume calculation is lowly. In order to accurately ascertain and simplify the calculation method, also to convenient the designer, this paper makes use of the Excel VBA programming technique to carry out the automatic calculation method of site elevation optimization and earthwork volume bjn ascertainment.This paper studies theory of site elevation ascertainment and the method of least squares to optimize and adjust principles. It builds up mathematic model of the earthwork volume calculation. With the help of Excel saving and processing data, VBA programming technique, this paper carries out the automatic calculation method of site elevation optimization and earthwork volume ascertainment. Also it gives two examples of regular site and irregular site to indicate the procedure is feasible and it can be satisfied to calculate conveniently, fast, reliably and exactly.The result of this paper can be applied to the vertical design of general layout system, especially to site elevation optimization and earthwork volume ascertainment. Owing to the usage of Excel with strong function, cheap cost and familiar to everyone, it will be well applied to the designer.