CN107577903A - A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD - Google Patents
A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD Download PDFInfo
- Publication number
- CN107577903A CN107577903A CN201711042524.7A CN201711042524A CN107577903A CN 107577903 A CN107577903 A CN 107577903A CN 201711042524 A CN201711042524 A CN 201711042524A CN 107577903 A CN107577903 A CN 107577903A
- Authority
- CN
- China
- Prior art keywords
- autocad
- earthwork
- topographic survey
- ele
- carried out
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 17
- 238000009412 basement excavation Methods 0.000 claims abstract description 8
- 238000000605 extraction Methods 0.000 claims abstract description 7
- 238000004513 sizing Methods 0.000 claims description 5
- 238000005259 measurement Methods 0.000 claims description 4
- 238000004364 calculation method Methods 0.000 abstract description 13
- 239000003086 colorant Substances 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000001105 regulatory effect Effects 0.000 description 2
- 230000000717 retained effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 206010016256 fatigue Diseases 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012876 topography Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Landscapes
- Instructional Devices (AREA)
Abstract
The present invention provides a kind of method that the earthwork smooth calculating in place is carried out using AutoCAD, including：Topographic survey data are obtained by plotting board, topographic survey will be formed in the AutoCAD of topographic survey data input to processor；The division of grid is carried out to topographic survey in AutoCAD；The elevation information of the terrain is inputted for each grid in topographic survey；Using the elevation information in the VBA modules extraction topographic survey in AutoCAD and calculated, obtain earthwork excavation and filling amount.The present invention is calculated the data of extraction automatically using VBA, saves the time manually calculated；The precision of Earthwork calculation can be controlled by the control to grid division size.
Description
Technical field
The present invention relates to a kind of method that the earthwork smooth calculating in place is carried out using AutoCAD.
Background technology
In the construction projects such as building, water conservancy, the smooth of place is the important procedure built engineering early stage, in levelling of the land
The earthwork excavation and filling quantities being related to also has an impact to whole construction costs.The smooth calculating of traditional earthwork is manually entered using topographic map
Row calculates, and precision is not high and workload is big.Although and utilize satellite remote sensing technology or three-dimensional reverse modeling stroke analysis quantities
Accurately, fast, but cost is larger, very uneconomical for some less engineerings.
The content of the invention
The present invention provides a kind of method for carrying out levelling of the land Earthwork calculation, and this method utilizes measurement figure extraction site elevation
Information, then calculated using VBA modules.This method it is easy and can regulating calculation precision as needed, closed suitable for grey field
In the levelling of the land Earthwork calculations such as storehouse, mountain area building.
The present invention uses following technical scheme：
A kind of method that the earthwork smooth calculating in place is carried out using AutoCAD, including：
Topographic survey data are obtained by plotting board, will form ground in the AutoCAD of topographic survey data input to processor
Shape measurement figure；
The division of grid is carried out to topographic survey in AutoCAD；
The elevation information of the terrain is inputted for each grid in topographic survey；
Using the elevation information in the VBA modules extraction topographic survey in AutoCAD and calculated, obtain earthwork excavation and filling
Amount.
The sizing grid is adjustable.
After the completion of the elevation information input, the other information in topographic survey is deleted, only retains altitude data.
Beneficial effects of the present invention：The data of extraction are calculated automatically using VBA, save manually calculate when
Between；The precision of Earthwork calculation can be controlled by the control to grid division size.
Brief description of the drawings
Fig. 1 is the topographic survey that AutoCAD is opened.
Fig. 2 is the topographic survey of grid division.
Fig. 3 is the topographic survey for only retaining altitude data.
Embodiment
The present invention is described in further detail with reference to the accompanying drawings and detailed description.
The method that the earthwork smooth calculating in place is carried out using AutoCAD of the present invention, this method is easy and can be as needed
Regulating calculation precision, closed suitable for grey field the levelling of the land Earthwork calculations such as storehouse, mountain area building.
Comprise the following steps that：
（1）Topographic survey data are obtained by plotting board, will be formed in the AutoCAD of topographic survey data input to processor
Topographic survey；
（2）The division of grid is carried out to topographic survey in AutoCAD；
（3）The elevation information of the terrain is inputted for each grid in topographic survey；
（4）Using the elevation information in the VBA modules extraction topographic survey in AutoCAD and calculated, obtain the earthwork and dig
The amount of filling out.
Sizing grid is adjustable, you can be needed to adjust sizing grid according to precision, the smaller precision of grid is higher.
In order to improve calculating speed, after the completion of elevation information input, the other information in topographic survey is deleted, is only retained
Altitude data.
It is a kind of schematic diagram that storehouse is closed applied to certain grey field as shown in Fig. 1 ~ 3.
Fig. 1 is the figure of surveying the topography of AutoCAD certain engineering opened, newly-built two figure layers data1, data2 in CAD,
Unmodified and amended data are placed respectively.Data1 should be arranged to different colors from data2 figure layer color.
Grid is added on topographic map, and adds initial absolute altitude value, absolute altitude value can be inputted arbitrarily, and the data of input are placed on
In data1 figure layers.Result such as Fig. 2 after input.Sizing grid is 5m × 5m in this example, and precision that can be as requested adjusts grid
Size.
Data in grid are changed according to the topographic map of actual measurement.Because input data is more, needed after some data are inputted
Outputlet () module is run, the data after modification are placed into data2 figure layers, also placed if not changing
In data1 figure layers.Because two figure layer colors are different, data in grid can be significantly distinguished either with or without changing.
Outputlet () VBA codes are：
Sub outputlet()
On Error Resume Next
Dim objtext As Object
For Each objtext In ThisDrawing.ModelSpace
If objtext.Layer = data1 Then
If objtext.TextString <> "250" Then
objtext.Layer = data2
End If
End If
Next objtext
End Sub
The unnecessary pel such as landform can be deleted after the completion of input data, to improve program operation speed, elevation is only retained after deletion
Data, as shown in Figure 3.
Then co_earth () is called to be calculated with the data in co_elevation () reading figure, wherein co_
Elevation () process carries out the calculating of excavation and filling amount for inputting after tentative calculation elevation.A dialogue can be ejected after operation program
Frame, program can calculate the difference between each altitude data and tentative calculation elevation after input tentative calculation elevation in dialog box.It is if high
Number of passes is according to tentative calculation elevation is more than, then difference is included in upon_ele variables；Difference is tired out if altitude data is less than tentative calculation elevation
It is included in bottom_ele variables.Upon_ele and bottom_ele difference is the difference between excavation and embankment, and is made
The difference is shown with message box.It is required height value when the tentative calculation elevation of input makes the difference minimum of excavation and embankment,
Close the leveling absolute altitude of grey field behind storehouse.Co_elevation () VBA codes are as follows：
Public Sub co_elevation ()
Dim ele_obj As Object
Dim upon_ele As Double
Dim bottom_ele As Double
Dim test_ele As Double
test_ele = MsgBox()
For Each ele_obj In ThisDrawing.ModelSpace
If ele_obj.Layer = Data2 Then
If CLng(ele_obj.TextString) > test_ele Then
upon_ele = upon_ele + CLng(ele_obj.TextString) - test_ele
End If
If CLng(ele_obj.TextString) < test_ele Then
bottom_ele = bottom_ele + CLng(ele_obj.TextString) -
test_ele
End If
End If
Next
MsgBox bottom_ele + upon_ele
End Sub
Co_earth () process is used to calculate calculates excavated-in t4 amount after having required smooth elevation, uses the same co_ of process
elevation ().Co_earth () VBA codes are：
Public Sub co_elevation ()
Dim ele_obj As Object
Dim upon_ele As Double
Dim bottom_ele As Double
Dim test_ele As Double
test_ele = MsgBox()
For Each ele_obj In ThisDrawing.ModelSpace
If ele_obj.Layer = Data2 Then
If CLng(ele_obj.TextString) > test_ele Then
upon_ele = upon_ele + CLng(ele_obj.TextString) - test_ele
End If
If CLng(ele_obj.TextString) < test_ele Then
bottom_ele = bottom_ele + CLng(ele_obj.TextString) -
test_ele
End If
End If
Next
MsgBox（" amount of excavation is " ＆ upon_ele）
MsgBox（" amount of fill is " ＆ bottom_ele）
End Sub
After calculating, the area of grid need to be multiplied by, as 25 should be multiplied by this example（5×5）, finally try to achieve required excavated-in t4
Amount.
Above-described is only the preferred embodiment of the present invention, it is noted that for those skilled in the art,
Under the premise of general idea of the present invention is not departed from, some changes and improvements can also be made, these should also be considered as the present invention's
Protection domain.
Claims (3)
- A kind of 1. method that the earthwork smooth calculating in place is carried out using AutoCAD, it is characterised in that including：Topographic survey data are obtained by plotting board, will form ground in the AutoCAD of topographic survey data input to processor Shape measurement figure；The division of grid is carried out to topographic survey in AutoCAD；The elevation information of the terrain is inputted for each grid in topographic survey；Using the elevation information in the VBA modules extraction topographic survey in AutoCAD and calculated, obtain earthwork excavation and filling Amount.
- 2. a kind of method that the earthwork smooth calculating in place is carried out using AutoCAD according to claim 1, its feature are existed In：The sizing grid is adjustable.
- 3. a kind of method that the earthwork smooth calculating in place is carried out using AutoCAD according to claim 1, its feature are existed In：After the completion of the elevation information input, the other information in topographic survey is deleted, only retains altitude data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042524.7A CN107577903A (en) | 2017-10-31 | 2017-10-31 | A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711042524.7A CN107577903A (en) | 2017-10-31 | 2017-10-31 | A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107577903A true CN107577903A (en) | 2018-01-12 |
Family
ID=61041091
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711042524.7A Pending CN107577903A (en) | 2017-10-31 | 2017-10-31 | A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107577903A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110516398A (en) * | 2019-09-03 | 2019-11-29 | 贵州正业工程技术投资有限公司 | A kind of Karst depression ball crown type of spherical coordinates is peeled off earthwork calculation method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101750037A (en) * | 2008-11-28 | 2010-06-23 | 中国二十冶建设有限公司 | Accurate measuring method of large-scale irregular earthwork excavated volume |
| US20110071803A1 (en) * | 2003-07-08 | 2011-03-24 | Meiners Robert E | System and Method of Sub-Surface System Design and Installation |
| CN105760581A (en) * | 2016-01-29 | 2016-07-13 | 中国科学院地理科学与资源研究所 | Channel drainage basin renovation planning simulating method and system based on OSG |
-
2017
- 2017-10-31 CN CN201711042524.7A patent/CN107577903A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110071803A1 (en) * | 2003-07-08 | 2011-03-24 | Meiners Robert E | System and Method of Sub-Surface System Design and Installation |
| CN101750037A (en) * | 2008-11-28 | 2010-06-23 | 中国二十冶建设有限公司 | Accurate measuring method of large-scale irregular earthwork excavated volume |
| CN105760581A (en) * | 2016-01-29 | 2016-07-13 | 中国科学院地理科学与资源研究所 | Channel drainage basin renovation planning simulating method and system based on OSG |
Non-Patent Citations (3)
| Title |
|---|
| 吴金国: "基于AutoCAD平台的土方量计算程序设计", 《科技创新论坛》 * |
| 杨胜军 等: "利用DEM 实现场地平整与土方量均衡计算", 《科技与经济》 * |
| 熊声顺: "场区土方平整CAD软件TFPZ编制的基本方法", 《开发与借鉴》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110516398A (en) * | 2019-09-03 | 2019-11-29 | 贵州正业工程技术投资有限公司 | A kind of Karst depression ball crown type of spherical coordinates is peeled off earthwork calculation method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Bastola et al. | The role of vegetation on gully erosion stabilization at a severely degraded landscape: A case study from Calhoun Experimental Critical Zone Observatory | |
| CN111125821B (en) | BIM+GIS foundation and foundation subsection engineering analysis and type selection method | |
| Malagò et al. | Regional scale hydrologic modeling of a karst-dominant geomorphology: The case study of the Island of Crete | |
| CN102282925A (en) | Land leveling method and device as well as land leveling control device | |
| CN117910265B (en) | A method for calculating ground settlement considering changes in total stress and soil parameters when groundwater level drops | |
| CN110287511B (en) | Pile foundation type selection and construction quality control method based on BIM technology | |
| CN111143922A (en) | Multi-platform structure stratum digital twin modeling method and system | |
| CN113742827B (en) | A Construction Method of Highway Slope Monitoring Network System Based on Finite Difference Analysis | |
| CN107515976A (en) | Surface subsidence Forecasting Methodology based on slurry shield construction main contral parameter | |
| CN103473394B (en) | Earthwork balance optimization design method for multiple station section type field leveling layout | |
| Liu et al. | A boundary model of terrain reconstruction in a coal-mining subsidence waterlogged area | |
| Zhang et al. | A case study on integrated modeling of spatial information of a complex geological body | |
| CN108109203B (en) | Geological boundary point cloud data extraction method and system based on BIM environment | |
| CN111353681A (en) | BIM technology-based high-precision calculation method for in-site earth and stone engineering quantity | |
| CN112668076A (en) | Multi-order high slope comprehensive information construction method for soil-rock combined stratum | |
| CN120338292A (en) | A method and system for urban land subsidence analysis based on multi-source data fusion | |
| CN118278175A (en) | Digital twin-driven high and steep slope deformation enhanced visualization method and system | |
| CN107577903A (en) | A kind of method that the earthwork smooth calculating in place is carried out based on AutoCAD | |
| CN113806846A (en) | Airport three-dimensional clearance limiting surface optimization method based on runway center line control method | |
| CN116776449A (en) | Sketchup software-based nuclear power plant area total plane layout method and system | |
| CN116629023A (en) | A New Method for 3D Reservoir Characterization Combining Stratigraphic Forward Modeling and Geostatistics | |
| CN105205863B (en) | A kind of 3-dimensional digital basin modeling method for grading | |
| Lønøy et al. | Paleokarst reservoir architecture derived from forward modelling of modern cave systems-a case study | |
| CN110379009A (en) | A kind of parametrization geological model generation method based on BIM technology | |
| CN113832978B (en) | Tuff slope anti-weathering excavation method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180112 |