| Earthwork engineering is an important work content in the current construction project.It is the focus of construction progress and project cost control,and creates conditions for the foundation construction of buildings.The determination of earthwork volume and earthwork allocation scheme is the key work of earthwork engineering.In the actual construction process,the determination of earthwork volume usually adopts the method of semi-manual and semi-computer calculation.The calculation process is complicated and the calculation results have large errors.The earthwork transportation work in earthwork allocation is usually based on the on-site construction experience of construction personnel,which easily leads to the occurrence of repeated transportation and increased workload.When combining the existing software to calculate the amount of earthwork and determine the earthwork allocation scheme,it is necessary to go through multiple software to complete these tasks.Data may be lost in repeated import and export.With the birth and continuous development of BIM technology,the use of BIM technology to build terrain models makes earthwork calculation and deployment three-dimensional and visualized,thus greatly improving the quality and efficiency of earthwork construction.Therefore,aiming at the problems of difficult cost control and low management efficiency in earthwork construction,this paper studies the method of automatic earthwork calculation and earthwork allocation scheme optimization through mathematical analysis and computer secondary development technology,and completes the following work :(1)Aiming at the calculation of site earthwork,the research on the development of earthwork calculation method library plug-in based on Revit software was carried out.Using Revit software to establish the terrain model,obtain the parameter information of the three-dimensional model,compile the calculation algorithms of the square grid method,the contour line method,the scatter point method and the section method,and transform the scope of application of each earthwork calculation method into specific numerical conditions and set the method.The automatic discrimination program realizes that the selected terrain area can automatically determine the calculation method according to its terrain characteristics and obtain the earthwork quantity by one click.Through engineering cases,the accuracy of earthwork calculation method library calculation is verified.(2)Aiming at the optimization of site earthwork allocation scheme,the research on using CPLEX solver to determine earthwork allocation scheme is carried out.In this paper,the earthwork allocation engineering problem is transformed into a mathematical model of linear programming.Based on VS2017 software,the model is placed in the CPLEX solution environment by using C # programming language,and the optimization engine and function solution package of CPLEX are used to realize the rapid solution of earthwork allocation scheme.Through practical examples,the table operation method and CPLEX are used to solve the earthwork allocation scheme.The results show that the CPLEX solver is faster and more accurate than the table operation method.(3)Design and development of earthwork calculation and deployment plug-in.Based on the Revit software platform,with the help of Revit API and C # programming language,the secondary development of Revit is carried out.By compiling and designing the plug-in interface and completing the construction of data,the development of Revit earthwork allocation and expansion function is realized,and the plug-in is applied in the three small projects in Pingyao to prove the feasibility of its function.Through the research of this paper,the development of earthwork calculation and deployment plug-in based on Revit software is realized,which provides technical support for site leveling work,and also provides relevant experience for the application of BIM technology in earthwork engineering. |