CN108536981A - Communication pipe engineering design efforts and the automation of material budget table generate model - Google Patents
Communication pipe engineering design efforts and the automation of material budget table generate model Download PDFInfo
- Publication number
- CN108536981A CN108536981A CN201810348912.6A CN201810348912A CN108536981A CN 108536981 A CN108536981 A CN 108536981A CN 201810348912 A CN201810348912 A CN 201810348912A CN 108536981 A CN108536981 A CN 108536981A
- Authority
- CN
- China
- Prior art keywords
- hole
- communication pipe
- automation
- budget
- sheet
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/18—Network design, e.g. design based on topological or interconnect aspects of utility systems, piping, heating ventilation air conditioning [HVAC] or cabling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2113/00—Details relating to the application field
- G06F2113/14—Pipes
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Analysis (AREA)
- Computational Mathematics (AREA)
- Mathematical Optimization (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to construction budget establishment technique fields, and in particular to communication pipe engineering design efforts and the automation of material budget table generate model.The invention discloses communication pipe engineering design efforts and the automation of material budget table generates model and application method, the model construction include:S1. key parameter extracts;S2. the gauge that works takes;S3. material utilization amount meter takes;S4. model foundation;S5. quantity sheet and material usage sheet generate five steps of output.By designing and producing " key parameter Data source table ", " workload transfer table ", " material transfer table " and auto-associating, non-" 0 " data entry in automation extraction " workload transfer table " and " material transfer table " generates, exports independent quantity sheet and material usage sheet.The automation, standardization and standardization for realizing communication pipe engineering design efforts and material budget, improve design efficiency and designing quality, specification design operation.
Description
Technical field
The invention belongs to construction budget establishment technique fields, are related to the budget compilation of communication pipe engineering, and in particular to logical
Fuse tube road engineering design efforts and the automation of material budget table generate model.
Background technology
Communication pipe is indispensable basic resource in the communication network development, is the base of various types of communication business normal operation
Plinth.In the design process, Budget making needs designer to search, count from every design drawing and calculates each single item work
Make required quota quantity and material utilization amount.
Workload and material budget are mainly using the artificial side for counting and calculating one by one in communication pipe engineering design at present
Method, drawing amount is big, and artificial statistical work amount and calculation amount are very big, very labor intensive, and cannot be guaranteed accuracy rate, cause to set
Meter personnel's design efficiency is low, of low quality;In addition, due to designer's subjective factor, the workload and material extracted is pre-
Calculation is usually present not uniquely, nonstandard, lacks normative problem.
Based on the above problem of the existing technology, workload and material budget in communication pipe engineering design how are improved
Working efficiency and accuracy rate, the budget level of Uniting, realize standardization, it is necessary to solve pipeline budget workload and
The problem of material is automated and standardizes generation.
Invention content
The purpose of the present invention is overcome the deficiencies in the prior art, for the above-mentioned technical problem present in the prior art, originally
Invention is by extracting communication pipe engineering design key parameter, and meter takes workload and material utilization amount, based on this, using data
Processing software, it includes " key parameter Data source table ", " workload transfer table ", " material transfer table " corresponding electrical form to generate
Communication pipe Engineering Task amount and material budget model file, then by giving the parameters of " key parameter Data source table " to carry out
Assignment handles quantity sheet and the material utilization amount budget for generating independent communication pipe engineering design with corresponding data processing software
Table.By design by corresponding data be associated between link in each link, realize the Various types of data such as pre- operator workload, material utilization amount oneself
Dynamic association, automation generate budget quantity sheet and material usage sheet.Realize that communication pipe engineering design efforts and material are pre-
Automation, standardization and the standardization of calculation improve design efficiency and designing quality, Specification Design standard.Thus algorithm obtains
Budget result meets Ministry of Industry and Information and communicates [2016] No. 451 quota regulations.
To achieve the above object, the technical solution adopted by the present invention is:
Communication pipe engineering design efforts and the automation of material budget table generate model, which is characterized in that grasp as follows
It builds:
S1. key parameter extracts:The work norm for analyzing existing communication pipeline engineering, communication tube will be calculated by induction and conclusion
The underlying parameter sorting-out in statistics of road Engineering Task amount comes out, and " the key ginseng taken with material utilization amount meter is taken as follow-up work gauge
Number ".
S2. the gauge that works takes:According to the functional relation of communication pipe engineering design pre- operator workload and key parameter, item by item
List work norm calculation formula.
S3. material utilization amount meter takes:According to communication pipe engineering design budget various types of materials dosage and key parameter, workload
Between functional relation, list material utilization amount quota calculation formula item by item.
S4. model foundation:Using data processing software, designed and produced according to " key parameter " that step S1 is obtained " crucial
Supplemental characteristic source table " gives the preset valuator of each key parameter;The work norm calculation formula listed according to step S2, if
Meter makes " workload transfer table ";The material utilization amount quota calculation formula listed according to step S3, designs and produces " material transfer
Table ";" key parameter Data source table ", " workload transfer table ", " material transfer table " three tables are interrelated, collectively form communication tube
Road Engineering Task amount and material budget model file.
By step S4, realize that the workload of communication pipe engineering design budget is associated with and generates with material total data.
S5. quantity sheet and material usage sheet generate output:Using data processing software to " workload made of step S4
Transfer table " and " material transfer table " handled, it is non-in screening extraction " workload transfer table " and " material transfer table " respectively
" 0 " data entry automatically generates, exports independent quantity sheet and material usage sheet.
Further, in step s 4, the data processing software be Excel, easy table, MATLAB, Origi, Foxtable,
Any one in Mathmatica, Maple, Hadoop.
Further, in step s 5, the data processing software be Excel, easy table, MATLAB, Origi, Foxtable,
Any one in Mathmatica, Maple, Hadoop.
Further, in step s 4, the data processing software is Excel;In step s 5, described to utilize data processing
Software processing is meant to be handled using the macros of Excel.
Further, in step s 5, described when automatically generating, exporting independent quantity sheet and material usage sheet, it utilizes
The filename and comspec of Excel formula and macros structure autonomous working scale and material usage sheet.
Further, in step s 5, the quantity sheet and material usage sheet generate, before export, first with data processing
Software handles " workload transfer table " made of step S4 and " material transfer table ", and screening extraction is " in workload respectively
Turn table " and " material transfer table " in non-" 0 " data entry, by result copy to belonging to table specified the selection result region,
The data in the selection result region are recycled to automatically generate, export independent quantity sheet and material usage sheet;The selection result
Region and original data region non-overlapping.
Further, in step s 5, the quantity sheet and material usage sheet generate, before export, soft by data processing
Part processing carries out initialization null clear operation to the selection result area data, to ensure that new the selection result entry number is less than existing item
Correct result can be obtained when mesh number.
Preferably, the data processing software processing is handled for the macros of operation Excel.
Further, communication pipe engineering design efforts of the invention and the automation of material budget table generate the use of model
Method operates as follows:
A1. " the key parameter Data source table " for opening communication pipe Engineering Task amount and material budget model file, in each pass
The preset valuator typing corresponding parametric values of bond parameter.
A2. " workload transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then is extracted
Non- " 0 " data entry in " workload transfer table " automatically generates, exports independent quantity sheet.
A3. " material transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then extracts " material
Non- " 0 " data entry in material transfer table " automatically generates, exports independent material usage sheet.
Further, in step A2 and A3, at macros of the data processing software processing for operation Excel
Reason.
Beneficial effects of the present invention.
1. realizing design automation:Promote design efficiency.
The workload and material practical joke price budget for realizing communication pipe engineering design automate, budget improved efficiency 35%,
Communication pipe engineering effort whole efficiency is set to promote 10%.
2. realizing design standard:Promote designing quality.
It by incidence relation algorithm, realizes that master data input, mass data calculate generation automatically, avoids a large amount of artificial
Typing mistake caused by operation element realizes that each link data are mutually unified, designing quality is substantially improved.
3. realizing design specification:Promote design uniformity.
It realizes design specification uniformity, keeps in mind design work day, that the specifications such as material utilization amount take is fixed, it is unified automatic to calculate life
At not changing because of human factor.
Description of the drawings
Fig. 1 is the model construction operational flowchart of the present invention.
Fig. 2 is communication pipe Engineering Task amount of the present invention and the total algorithm relational graph of material budget model.
Fig. 3 is communication pipe Engineering Task amount of the present invention and material budget model E xcel file interface master drawings.
Specific implementation mode
Technical scheme of the present invention is described in detail below in conjunction with the accompanying drawings, but present disclosure is not limited to
This.
As shown in Figure 1, communication pipe engineering design efforts and the automation of material budget table generate model, feature exists
In operation as follows is built:
S1. key parameter extracts:The work norm for analyzing existing communication pipeline engineering, communication tube will be calculated by induction and conclusion
The underlying parameter sorting-out in statistics of road Engineering Task amount comes out, and " the key ginseng taken with material utilization amount meter is taken as follow-up work gauge
Number ".
The selection of key parameter uses " minimized, most simplified " principle, can calculate the work amount of doing and material completely
Under the premise of, the quantity " minimized " of key parameter, key parameter fills in " most simplified ", each key parameter has necessity
Property.Compared to traditional workload extracting mode, this mode reduces, simplifies data and the letter for artificially needing to obtain from drawing
Breath.
Specific key parameter is as shown in table 1.
The key parameter that table 1. extracts
Serial number | Key parameter | Unit | Remarks |
1 | Create small hand | It is a | |
2 | Create small hand window number (1 hole) | Place | |
3 | Create small hand window number (holes 2-4) | Place | |
4 | Newly-built operating pit | It is a | |
5 | Original manhole wall windowing | Place | |
6 | Mechanical jacking (1 hole) | Rice | |
7 | Mechanical jacking (2 hole) | Rice | |
8 | Mechanical jacking (3 hole) | Rice | |
9 | Mechanical jacking (4 hole) | Rice | |
10 | Coating steel pipe pipeline (1 hole) | Rice | |
11 | Coating steel pipe pipeline (2 hole) | Rice | |
12 | Coating steel pipe pipeline (3 hole) | Rice | |
13 | Coating steel pipe pipeline (4 hole) | Rice | |
14 | Excavated pavement length (concrete) (1 hole) | Rice | |
15 | Excavated pavement length (asphalt tar) (1 hole) | Rice | |
16 | Excavated pavement length (sandstone) (1 hole) | Rice | |
17 | Excavated pavement length (concrete segment) (1 hole) | Rice | |
18 | Excavated pavement length (cement tile) (1 hole) | Rice | |
19 | Excavated pavement length (rectangular slab of stone) (1 hole) | Rice | |
20 | Excavate pipe alley length (common soil) (1 hole) | Rice | |
21 | Excavate pipe alley length (pan soil) (1 hole) | Rice | |
22 | Excavate pipe alley length (gravel soil) (1 hole) | Rice | |
23 | Excavate pipe alley length (soft rock) (1 hole) | Rice | |
24 | Excavated pavement length (concrete) (2 hole) | Rice | |
25 | Excavated pavement length (asphalt tar) (2 hole) | Rice | |
26 | Excavated pavement length (sandstone) (2 hole) | Rice | |
27 | Excavated pavement length (concrete segment) (2 hole) | Rice | |
28 | Excavated pavement length (cement tile) (2 hole) | Rice | |
29 | Excavated pavement length (rectangular slab of stone) (2 hole) | Rice | |
30 | Excavate pipe alley length (common soil) (2 hole) | Rice | |
31 | Excavate pipe alley length (pan soil) (2 hole) | Rice | |
32 | Excavate pipe alley length (gravel soil) (2 hole) | Rice | |
33 | Excavate pipe alley length (soft rock) (2 hole) | Rice | |
34 | Excavated pavement length (concrete) (3 hole) | Rice | |
35 | Excavated pavement length (asphalt tar) (3 hole) | Rice | |
36 | Excavated pavement length (sandstone) (3 hole) | Rice | |
37 | Excavated pavement length (concrete segment) (3 hole) | Rice | |
38 | Excavated pavement length (cement tile) (3 hole) | Rice | |
39 | Excavated pavement length (rectangular slab of stone) (3 hole) | Rice | |
40 | Excavate pipe alley length (common soil) (3 hole) | Rice | |
41 | Excavate pipe alley length (pan soil) (3 hole) | Rice | |
42 | Excavate pipe alley length (gravel soil) (3 hole) | Rice | |
43 | Excavate pipe alley length (soft rock) (3 hole) | Rice | |
44 | Excavated pavement length (concrete) (4 hole) | Rice | |
45 | Excavated pavement length (asphalt tar) (4 hole) | Rice | |
46 | Excavated pavement length (sandstone) (4 hole) | Rice | |
47 | Excavated pavement length (concrete segment) (4 hole) | Rice | |
48 | Excavated pavement length (cement tile) (4 hole) | Rice | |
49 | Excavated pavement length (rectangular slab of stone) (4 hole) | Rice | |
50 | Excavate pipe alley length (common soil) (4 hole) | Rice | |
51 | Excavate pipe alley length (pan soil) (4 hole) | Rice | |
52 | Excavate pipe alley length (gravel soil) (4 hole) | Rice | |
53 | Excavate pipe alley length (soft rock) (4 hole) | Rice |
S2. the gauge that works takes:
According to the functional relation of communication pipe engineering design pre- operator workload and key parameter, work norm calculating is listed item by item
Formula.The key parameter obtained using step S1 can calculate all working amount completely, not need other conditions auxiliary.By
The workload quantity that this algorithm obtains meets Ministry of Industry and Information and communicates [2016] No. 451 quota regulations.Specific works amount(Quota entry)
Algorithm is as shown in table 2.
2. workload of table(Quota entry)Algorithm table
Sequence Number | Quota is compiled Number | Project 1 | Project 2 | Unit | Algorithm | Remarks |
1 | TGD1- 001 | Construction survey | Hundred meters | { [excavated pavement length (concrete) (1 Hole)+excavated pavement length (asphalt tar) (1 hole)+excavated pavement length (sandstone) (1 Hole)+excavated pavement length (build by concrete Block) (1 hole)+excavated pavement length (cement Ornamental slab for paving the floor) (1 hole)+excavated pavement length (item Stone) (1 hole)+excavated pavement length (coagulation Soil) (2 hole)+excavated pavement length (pitch Pitch) (2 hole)+excavated pavement length (sand Stone) (2 hole)+excavated pavement length (coagulation Earth building blocks) (2 hole)+excavated pavement length (cement tile) (2 hole)+excavated pavement is long Spend (rectangular slab of stone) (2 hole)+excavated pavement length (concrete) (3 hole)+excavated pavement length (asphalt tar) (3 hole)+excavated pavement is long Spend (sandstone) (3 hole)+excavated pavement length (concrete segment) (3 hole)+excavated pavement Length (cement tile) (3 hole)+excavation road Face length (rectangular slab of stone) (3 hole)+excavated pavement Length (concrete) (4 hole)+excavated pavement Length (asphalt tar) (4 hole)+excavation road Face length (sandstone) (4 hole)+excavated pavement Length (concrete segment) (4 hole)+excavation Road surface length (cement tile) (4 hole)+open Road breaking face length (rectangular slab of stone) (4 hole)]+[plating Zinc steel pipeline (1 hole)+coating steel pipe pipe Road (2 hole)+coating steel pipe pipeline (3 hole)+ Coating steel pipe pipeline (4 hole)]+[machinery top Manage (1 hole)+mechanical jacking (2 hole)+machinery Push pipe (3 hole)+mechanical jacking (4 hole)] }/ 100 | ||
2 | TGD1- 002 | Hand excavation road Surface concrete | 100 with Under | Hundred is flat Square rice | Excavated pavement length (concrete) (1 hole) * Excavation width (1 hole)+excavated pavement length (concrete) (2 hole) * excavation widths (2 Hole)+excavated pavement length (concrete) (3 Hole) * excavation widths (3 hole)+excavated pavement Length (concrete) (4 hole) * excavation widths (4 hole) | Excavation width by Pore number determines |
3 | TGD1- 004 | Hand excavation road Face asphalt tar | 100 with Under | Hundred is flat Square rice | Excavated pavement length (asphalt tar) (1 Hole) * excavation widths (1 hole)+excavated pavement Length (asphalt tar) (2 hole) * excavates wide Spend (2 hole)+excavated pavement length (pitch Pitch) (3 hole) * excavation widths (3 hole)+ Excavated pavement length (asphalt tar) (4 Hole) * excavation widths (4 hole) | Excavation width by Pore number determines |
4 | TGD1- 006 | Hand excavation road Facing sand stone | 100 with Under | Hundred is flat Square rice | Excavated pavement length (sandstone) (1 hole) * is opened Dig width (1 hole)+excavated pavement length (sandstone) (2 hole) * excavation widths (2 hole)+ Excavated pavement length (sandstone) (3 hole) * is opened Dig width (3 hole)+excavated pavement length (sandstone) (4 hole) * excavation widths (4 hole) | Excavation width by Pore number determines |
5 | TGD1- 008 | Hand excavation road Surface concrete is built Block | Hundred is flat Square rice | Excavated pavement length (concrete segment) (1 Hole) * excavation widths (1 hole)+excavated pavement Length (concrete segment) (2 hole) * is excavated Width (2 hole)+excavated pavement length is (mixed Solidifying earth building blocks) (3 hole) * excavation widths (3 Hole)+excavated pavement length (build by concrete Block) (4 hole) * excavation widths (4 hole) | Excavation width by Pore number determines | |
6 | TGD1- 009 | Hand excavation road Face cement tile | Hundred is flat Square rice | Excavated pavement length (cement tile) (1 Hole) * excavation widths (1 hole)+excavated pavement Length (cement tile) (2 hole) * excavates wide Spend (2 hole)+excavated pavement length (cement Ornamental slab for paving the floor) (3 hole) * excavation widths (3 hole)+ Excavated pavement length (cement tile) (4 Hole) * excavation widths (4 hole) | Excavation width by Pore number determines | |
7 | TGD1- 010 | Hand excavation road Noodles stone | Hundred is flat Square rice | Excavated pavement length (rectangular slab of stone) (1 hole) * is opened Dig width (1 hole)+excavated pavement length (rectangular slab of stone) (2 hole) * excavation widths (2 hole)+ Excavated pavement length (rectangular slab of stone) (3 hole) * is opened Dig width (3 hole)+excavated pavement length (rectangular slab of stone) (4 hole) * excavation widths (4 hole) | Excavation width by Pore number determines | |
8 | TGD1- 017 | Hand excavation manages Dao Gou and people (Hand)It cheats in hole | Commonly Soil | Hundred is flat Square rice | [excavate pipe alley length (common soil) (1 Hole) * pipe alleies cross-sectional area (1 hole)+open Dig pipe alley length (common soil) (2 hole) * Pipe alley cross-sectional area (2 hole)+excavation pipe Road ditch length (common soil) (3 hole) * pipelines Ditch cross-sectional area (3 hole)+excavation pipe alley Length (common soil) (4 hole) * pipe alleies are horizontal Sectional area (4 hole)+newly-built small hand * 5+ are new Build operating pit * 3]/100 | Pipe alley is transversal Area is by pore Number determines;Newly Build small hand and new Build operating pit Earth excavation is silent Recognize by common soil Keep in mind |
9 | TGD1- 018 | Hand excavation manages Dao Gou and people (Hand)It cheats in hole | Pan soil | Hundred is flat Square rice | [excavate pipe alley length (pan soil) (1 Hole) * pipe alleies cross-sectional area (1 hole)+open Dig pipe alley length (pan soil) (2 hole) * pipes Road ditch cross-sectional area (2 hole)+excavation pipeline Ditch length (pan soil) (3 hole) * pipe alleies are horizontal Sectional area (3 hole)+excavation pipe alley length (pan soil) (4 hole) * pipe alley cross-sectional areas (4 hole)]/100 | Pipe alley is transversal Area is by pore Number determines |
10 | TGD1- 019 | Hand excavation manages Dao Gou and people (Hand)It cheats in hole | Gravel Soil | Hundred is flat Square rice | [excavate pipe alley length (gravel soil) (1 Hole) * pipe alleies cross-sectional area (1 hole)+open Dig pipe alley length (gravel soil) (2 hole) * Pipe alley cross-sectional area (2 hole)+excavation pipe Road ditch length (gravel soil) (3 hole) * pipelines Ditch cross-sectional area (3 hole)+excavation pipe alley Length (gravel soil) (4 hole) * pipe alleies are horizontal Sectional area (4 hole)]/100 | Pipe alley is transversal Area is by pore Number determines |
11 | TGD1- 021 | Hand excavation manages Dao Gou and people (Hand)It cheats in hole | Soft rock | Hundred is flat Square rice | [excavate pipe alley length (soft rock) (1 Hole) * pipe alleies cross-sectional area (1 hole)+open Dig pipe alley length (soft rock) (2 hole) * pipes Road ditch cross-sectional area (2 hole)+excavation pipeline Ditch length (soft rock) (3 hole) * pipe alleies are horizontal Sectional area (3 hole)+excavation pipe alley length (soft rock) (4 hole) * pipe alley cross-sectional areas (4 hole)]/100 | Pipe alley is transversal Area is by pore Number determines |
12 | TGD1- 028 | Backfill the earthwork | Rammer is filled out Original soil | Hundred is flat Square rice | [excavate pipe alley length (common soil) (1 Hole) * backfill abode house sectional areas (1 hole)+open Dig pipe alley length (common soil) (2 hole) * Backfill abode house sectional area (2 hole)+excavation pipe Road ditch length (common soil) (3 hole) * backfills Abode house sectional area (3 hole)+excavation pipe alley Length (common soil) (4 hole) * backfills abode house Sectional area (4 hole)+newly-built small hand * 1+ are new Build operating pit * 0.6]/100+ [excavation pipes Road ditch length (pan soil) (1 hole) * backfills Room sectional area (1 hole)+excavation pipe alley is long Spend (pan soil) (2 hole) * backfill abode houses section Product (2 hole)+excavate pipe alley length (firmly Soil) (3 hole) * backfill abode houses sectional area (3 Hole)+excavate pipe alley length (pan soil) (4 Hole) * backfill abode house sectional areas (4 hole)]/ 100+ [excavates pipe alley length (gravel Soil) (1 hole) * backfill abode houses sectional area (1 Hole)+excavate pipe alley length (gravel soil) (2 hole) * backfill abode house sectional areas (2 hole)+ Excavate pipe alley length (gravel soil) (3 Hole) * backfill abode house sectional areas (3 hole)+open Dig pipe alley length (gravel soil) (4 hole) * Backfill abode house sectional area (4 hole)]/100+ [excavate pipe alley length (soft rock) (1 Hole) * backfill abode house sectional areas (1 hole)+open Pipe alley length (soft rock) (2 hole) * is dug to return Banket room sectional area (2 hole)+excavation pipeline Ditch length (soft rock) (3 hole) * backfills abode house Sectional area (3 hole)+excavation pipe alley length (soft rock) (4 hole) * backfills abode house sectional area (4 hole)]/100 | The earthwork is backfilled to cut Area=pipeline Ditch sectional area- Tubing section Product, by pore Number determines |
13 | TGD2- 085 | Lay plastic tube Road | 1 hole | Hundred meters | [excavate pipe alley length (common soil) (1 Hole)+excavate pipe alley length (pan soil) (1 Hole)+excavate pipe alley length (gravel soil) (1 hole)+excavate pipe alley length (soft rock Soil) (1 hole)]/100 | |
14 | TGD2- 086 | Lay plastic tube Road | 2 holes (2*1) | Hundred meters | [excavate pipe alley length (common soil) (2 Hole)+excavate pipe alley length (pan soil) (2 Hole)+excavate pipe alley length (gravel soil) (2 hole)+excavate pipe alley length (soft rock Soil) (2 hole)]/100 | |
15 | TGD2- 087 | Lay plastic tube Road | 3 holes (3*1) | Hundred meters | [excavate pipe alley length (common soil) (3 Hole)+excavate pipe alley length (pan soil) (3 Hole)+excavate pipe alley length (gravel soil) (3 hole)+excavate pipe alley length (soft rock Soil) (3 hole)]/100 | |
16 | TGD2- 089 | Lay plastic tube Road | 4 holes (2*2) | Hundred meters | [excavate pipe alley length (common soil) (4 Hole)+excavate pipe alley length (pan soil) (4 Hole)+excavate pipe alley length (gravel soil) (4 hole)+excavate pipe alley length (soft rock Soil) (4 hole)]/100 | |
17 | TGD2- 103 | Lay galvanized steel Pipeline | 1 hole | Hundred meters | Coating steel pipe pipeline (1 hole)/100 | |
18 | TGD2- 104 | Lay galvanized steel Pipeline | 2 holes (2*1) | Hundred meters | Coating steel pipe pipeline (2 hole)/100 | |
19 | TGD2- 105 | Lay galvanized steel Pipeline | 3 holes (3*1) | Hundred meters | Coating steel pipe pipeline (3 hole)/100 | |
20 | TGD2- 106 | Lay galvanized steel Pipeline | 4 holes (2*2) | Hundred meters | Coating steel pipe pipeline (4 hole)/100 | |
21 | TGD2- 036 | Plastic conduit base Plinth basis is wide 230 | C15 | Hundred meters | Create small hand window number (1 hole) * 0.04 | |
22 | TGD2- 039 | Plastic conduit base Plinth basis is wide 360 | C15 | Hundred meters | Create small hand window number (holes 2-4) * 0.04 | |
23 | TGD2- 054 | Plastic conduit base Plinth reinforcement(People Hole/hand hole window Place) | Basis It is wide by 230 | At ten | Create small hand window number (1 hole) * 0.2 | |
24 | TGD2- 055 | Plastic conduit base Plinth reinforcement(People Hole/hand hole window Place) | Basis It is wide by 360 | At ten | Create small hand window number (holes 2-4) * 0.2 | |
25 | TGD3- 026 | Brick hand hole(It is existing Field pours overlying) | 90* 120 | It is a | Create small hand | |
26 | TGD3- 094 | Brick wiring hand Hole(SK2) | It is a | Newly-built operating pit | ||
27 | TGD4- 014 | Manhole wall opens a window Mouthful | Place | Original manhole wall windowing | ||
28 | TGD9- 098 | Mechanical jacking | 1 hole | Rice | Mechanical jacking (1 hole)+mechanical jacking (2 Hole)+mechanical jacking (3 hole)+mechanical jacking (4 hole) | The quota entry It is artificially defined |
29 | TGD9- 099 | Mechanical jacking | Often increase Add 1 hole | Rice | Mechanical jacking (2 hole)+mechanical jacking 3 Hole) * 2+ mechanical jackings (4 hole) * 3 | The quota entry It is artificially defined |
30 | TXL1- 005 | GPS positioning | Point | Create small hand+newly-built operating pit |
S3. material utilization amount meter takes:Similarly, according to communication pipe engineering design budget various types of materials dosage and key parameter, work
Functional relation between amount lists material utilization amount quota calculation formula item by item.
Material quantity is considered by workload and key parameter to be calculated(Since workload itself had both been key parameter
Function, substantially material quantity is still calculated by key parameter).Thus it is logical that the material quantity that algorithm obtains meets Ministry of Industry and Information
[2016] No. 451 quotas of letter provide.Specific material algorithm is as shown in table 3.
3. material of table(Quota entry)Algorithm table
Sequence Number | Title material | Model | Unit | Algorithm | It is standby Note |
1 | Cable tray | 60cm | Root | TGD3-026*4 | |
2 | Cable tray Drift bolt | M16 | Root | TGD3-026*8 | |
3 | Water accumulation tank band Lid | Set | TGD3-026*1 | ||
4 | Tension ring | It is a | TGD3-026*2 | ||
5 | Operating pit lid Plate | It is a | TGD3-094*1 | ||
6 | Manhole mouth circle | It is compound | Set | TGD3-026*1 | |
7 | Cement | 425# | Ton | [TGD3-026*0.53+TGD3-094*0.145]*0.86 | |
8 | Coarse sand | Cubic meter | [TGD3-026*1.38+TGD3-094*0.63]/1.5 | ||
9 | Rubble | Cubic meter | [TGD3-026*0.72+TGD3-094*0.359]/1.65 | ||
10 | Machine made brick | Thousand pieces | TGD3-026*0.83+TGD3-094*0.48 | ||
11 | Coil pipe | Rice | TGD2-085*1*101+TGD2-086*2*101+TGD2-087* 3*101+TGD2-089*4*101 | ||
12 | Hot-rolled reinforced bar φ6 | HPB235 I grade | Kilogram | TGD2-054*3.81+TGD2-055*5.8 | |
13 | Hot-rolled reinforced bar φ10 | HPB235 I grade | Kilogram | TGD2-054*29.55+TGD2-055*39.4+TGD3-026* 1.63 | |
14 | Hot-rolled reinforced bar φ12 | HPB235 I grade | Kilogram | TGD3-026*20.94 | |
15 | Hot-rolled reinforced bar φ14 | HPB235 I grade | Kilogram | TGD3-026*13.82 | |
16 | Mechanical jacking | 1 hole | Hole/rice | Mechanical jacking (1 hole) | |
17 | Mechanical jacking | 2 holes | Hole/rice | Mechanical jacking (2 hole) | |
18 | Mechanical jacking | 3 holes | Hole/rice | Mechanical jacking (3 hole) | |
19 | Mechanical jacking | 4 holes | Hole/rice | Mechanical jacking (4 hole) | |
20 | Coating steel pipe | φ110 | Rice | TGD2-103*1+TGD2-104*2+TGD2-105*3+TGD2- 106*4 |
S4. model foundation:According to the thinking and algorithm of step S1 to S3, in Excel file, " closed according to what step S1 was obtained
Bond parameter " designs and produces " key parameter Data source table ", gives the preset valuator of each key parameter;The work listed according to step S2
Work amount quota calculation formula designs and produces " workload transfer table ";The material utilization amount quota calculation listed according to step S3 is public
Formula designs and produces " material transfer table ";As shown in Fig. 2, " key parameter Data source table ", " workload transfer table ", " material transfer
Three sheet tables of table " are interrelated, collectively form communication pipe Engineering Task amount and material budget model file.
In step S4, the workload and material whole relational links and data that realize pipeline budget generate.
S5. quantity sheet and material usage sheet generate output:It is handled using the macros of Excel, screening respectively carries
Take non-" 0 " data entry in " workload transfer table " and " material transfer table ", automatically generate, export independent quantity sheet and
Material usage sheet.
Automatically generating and exporting for independent quantity sheet and material usage sheet, is operated using Excel macros,
The thinking of the two and method are completely the same.Illustrate by taking the generation of quantity sheet output as an example below.
The Excel macros of the generation output of quantity sheet is as follows:
Sub workloads generate ()
Range("A2:I550").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=
Range( _
"J2:J3"), CopyToRange:=Range("L2:T550"), Unique:=False
* in A2:The regions I550 are with J2:The condition that the regions J3 are indicated(Quantity is not 0)It is screened, the selection result copies to
L2:The regions T550.It is exactly the entry that filter out quantity not be 0 for quantity sheet, is then copied to specified the selection result area
Domain waits for be operated in next step.
Dim fname0
Dim fname
Range("J1").Select
Selection.Copy
Range("K1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
fname = ActiveSheet.Cells(1, 11).Value
Range("F1").Select
Selection.Copy
Range("H1").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
fname0 = ActiveSheet.Cells(1, 8).Value
* it constructs generated workload in next step using excel formula and macros and leads filename and comspec needed for table,
It is stored in fname and fname0 respectively.
Workbooks.Add
ActiveWorkbook.SaveAs Filename:=fname, _
FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
ActiveWindow.Close
Workbooks.Open Filename:=fname
Windows (" telecomm base station optical cable accesses .xlsm ") .Activate
Range("L2:T550").Select
Selection.Copy
Windows(fname0).Activate
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub
* the excel files of an entitled fname, storing path fname0 are created.Result after screening is copied into this document
(As finally import budget software leads table), Save and Close.
The Excel macros of quantity sheet initialization is as follows:
Sub deletes workload ()
Range("L2:T550").ClearContents
Sheets (" workload generation ") .Select
End Sub
* the operation for initializing progress is to carry out data to the selection result region to empty(It deletes), to ensure new the selection result item
Mesh number can obtain correct result when being less than existing entry number.
Communication pipe engineering design efforts and material budget the table automation of the present invention generates the application method of model such as
Under:
A1. " the key parameter Data source table " for opening communication pipe Engineering Task amount and material budget model file, in each pass
The preset valuator typing corresponding parametric values of bond parameter.
A2. " workload transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then is extracted
Non- " 0 " data entry in " workload transfer table " automatically generates, exports independent quantity sheet.As shown in figure 3, clicking " just
Beginningization " macros button carries out initialization null clear operation, clicks " production work amount derived table " macros button, you can a key
Non- " 0 " data entry in extraction " workload transfer table " automatically generates, exports independent quantity sheet.
A3. similarly, " material transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then is carried
Non- " 0 " data entry in " material transfer table " is taken to automatically generate, export independent material usage sheet.
Typical pipeline engineering pertains only to small size manual, operating pit, and pore number is usually no more than 4 holes, and the present invention is current
Complete part pertains only to the related content no more than 4 holes, and algorithm can support the demand in 4 holes from now on or more.
The above is only presently preferred embodiments of the present invention, not to limit the present invention interest field.It is any with this
The technical solution or any technical person familiar with the field that the interest field that claim is covered is implemented utilize
The method content of the disclosure above makes the scheme of many possible changes and modifications, all belongs to the scope of protection of the present invention.
Claims (10)
1. communication pipe engineering design efforts and the automation of material budget table generate model, which is characterized in that as follows
Operation structure:
S1. key parameter extracts:The work norm for analyzing existing communication pipeline engineering, communication tube will be calculated by induction and conclusion
The underlying parameter sorting-out in statistics of road Engineering Task amount comes out, and " the key ginseng taken with material utilization amount meter is taken as follow-up work gauge
Number ";
S2. the gauge that works takes:According to the functional relation of communication pipe engineering design pre- operator workload and key parameter, list item by item
Work norm calculation formula;
S3. material utilization amount meter takes:According between communication pipe engineering design budget various types of materials dosage and key parameter, workload
Functional relation, list material utilization amount quota calculation formula item by item;
S4. model foundation:Using data processing software, " key parameter is designed and produced according to " key parameter " that step S1 is obtained
Data source table " gives the preset valuator of each key parameter;The work norm calculation formula listed according to step S2, design system
Make " workload transfer table ";The material utilization amount quota calculation formula listed according to step S3 designs and produces " material transfer table ";
" key parameter Data source table ", " workload transfer table ", " material transfer table " three tables are interrelated, collectively form communication pipe work
Journey workload and material budget model file;
S5. quantity sheet and material usage sheet generate output:Using data processing software to " workload transfer made of step S4
Table " and " material transfer table " handled, non-" 0 " in screening extraction " workload transfer table " and " material transfer table " counts respectively
According to entry, automatically generates, exports independent quantity sheet and material usage sheet.
2. communication pipe engineering design efforts as described in claim 1 and the automation of material budget table generate model, special
Sign is:In step s 4, the data processing software be Excel, easy table, MATLAB, Origi, Foxtable,
Any one in Mathmatica, Maple, Hadoop.
3. communication pipe engineering design efforts as described in claim 1 and the automation of material budget table generate model, special
Sign is:In step s 5, the data processing software be Excel, easy table, MATLAB, Origi, Foxtable,
Any one in Mathmatica, Maple, Hadoop.
4. communication pipe engineering design efforts as described in claim 1 and the automation of material budget table generate model, special
Sign is:In step s 4, the data processing software is Excel;In step s 5, described to be handled using data processing software
It means and is handled using the macros of Excel.
5. communication pipe engineering design efforts as claimed in claim 4 and the automation of material budget table generate model, special
Sign is:In step s 5, described when automatically generating, exporting independent quantity sheet and material usage sheet, utilize Excel formula
The filename and comspec of autonomous working scale and material usage sheet are built with macros.
6. communication pipe engineering design efforts as described in claim 1 and the automation of material budget table generate model, special
Sign is:In step s 5, the quantity sheet and material usage sheet generate, before export, first with data processing software to step
" workload transfer table " made of rapid S4 and " material transfer table " handled, respectively screening extract " workload transfer table " and
Result is copied to the specified the selection result region of affiliated table, recycles sieve by non-" 0 " data entry in " material transfer table "
It selects the data of results area to automatically generate, export independent quantity sheet and material usage sheet;The selection result region and original
Beginning data area non-overlapping.
7. communication pipe engineering design efforts as claimed in claim 6 and the automation of material budget table generate model, special
Sign is:In step s 5, the quantity sheet and material usage sheet generate, before export, pass through data processing software processing pair
The selection result area data carries out initialization null clear operation.
8. communication pipe engineering design efforts as claimed in claim 7 and the automation of material budget table generate model, special
Sign is:The data processing software processing is handled for the macros of operation Excel.
9. communication pipe engineering design efforts as described in claim 1 and the automation of material budget table generate model, special
Sign is:The communication pipe engineering design efforts and the automation of material budget table generate the application method of model, by as follows
Step operation:
A1. " the key parameter Data source table " for opening communication pipe Engineering Task amount and material budget model file, in each pass
The preset valuator typing corresponding parametric values of bond parameter;
A2. " workload transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then extracts " work
Non- " 0 " data entry in amount transfer table " automatically generates, exports independent quantity sheet;
A3. " material transfer table " is opened, is handled using data processing software and carry out initialization null clear operation, then is extracted " in material
Turn table " in non-" 0 " data entry automatically generate, export independent material usage sheet.
10. communication pipe engineering design efforts as claimed in claim 8 and the automation of material budget table generate model, special
Sign is:In step A2 and A3, the data processing software processing is handled for the macros of operation Excel.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810348912.6A CN108536981A (en) | 2018-04-18 | 2018-04-18 | Communication pipe engineering design efforts and the automation of material budget table generate model |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810348912.6A CN108536981A (en) | 2018-04-18 | 2018-04-18 | Communication pipe engineering design efforts and the automation of material budget table generate model |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108536981A true CN108536981A (en) | 2018-09-14 |
Family
ID=63477727
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810348912.6A Pending CN108536981A (en) | 2018-04-18 | 2018-04-18 | Communication pipe engineering design efforts and the automation of material budget table generate model |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108536981A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111784123A (en) * | 2020-06-12 | 2020-10-16 | 江苏省广电有线信息网络股份有限公司南京分公司 | Building block model-based broadcast and television pipeline engineering cost fine generation method |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102306338A (en) * | 2011-06-21 | 2012-01-04 | 中核能源科技有限公司 | Automatic material expense estimating system based on three-dimensional factory model |
CN103679373A (en) * | 2013-04-12 | 2014-03-26 | 国家电网公司 | Full chain budget data processing system and method for production infrastructure standard cost system |
CN105320806A (en) * | 2015-08-21 | 2016-02-10 | 中国核电工程有限公司 | Method for summarizing nuclear power technology piping materials by combing PML with Excel-VBA to perform data processing |
CN106934540A (en) * | 2017-03-07 | 2017-07-07 | 西安理工大学 | A kind of architecture engineering material cost budgeting method based on Revit |
-
2018
- 2018-04-18 CN CN201810348912.6A patent/CN108536981A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102306338A (en) * | 2011-06-21 | 2012-01-04 | 中核能源科技有限公司 | Automatic material expense estimating system based on three-dimensional factory model |
CN103679373A (en) * | 2013-04-12 | 2014-03-26 | 国家电网公司 | Full chain budget data processing system and method for production infrastructure standard cost system |
CN105320806A (en) * | 2015-08-21 | 2016-02-10 | 中国核电工程有限公司 | Method for summarizing nuclear power technology piping materials by combing PML with Excel-VBA to perform data processing |
CN106934540A (en) * | 2017-03-07 | 2017-07-07 | 西安理工大学 | A kind of architecture engineering material cost budgeting method based on Revit |
Non-Patent Citations (2)
Title |
---|
强飞等: "联合建设项目预算的EXCEL实现", 《有线电视技术》 * |
詹冰: "浅谈Excel在计算管道工程量中的运用", 《城市建设理论研究》 * |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111784123A (en) * | 2020-06-12 | 2020-10-16 | 江苏省广电有线信息网络股份有限公司南京分公司 | Building block model-based broadcast and television pipeline engineering cost fine generation method |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN103544533B (en) | A kind of water diversion project water resource optimal allocation dynamic model constructing system | |
Solís-Guzmán et al. | A Spanish model for quantification and management of construction waste | |
Ren et al. | Evaluating the stormwater management model to improve urban water allocation system in drought conditions | |
CN109783924A (en) | The Numerical Analysis methods that Groundwater iron shield tunnel construction influences | |
CN104809516B (en) | Irrigation areas Programming for Multiobjective Water Resources Optimal Allocation Model and its method for solving | |
CN111581767B (en) | Calibrating method for checking characteristic parameters of pipe network-river coupling model | |
CN105625293A (en) | Dissolution rock strong-development construction site filling-type geological processing structure and construction method thereof | |
CN108549624B (en) | Automatic generation system and method for communication engineering design budget and description text | |
CN108536981A (en) | Communication pipe engineering design efforts and the automation of material budget table generate model | |
CN106874560A (en) | A kind of riverside well field optimizes well-arranging procedure | |
Dobbins et al. | Excavations in the Sanctuary of Apollo at Pompeii, 1997 | |
Gao et al. | Dynamic evolution of karst water levels and its controlling and influencing factors in Northern China: a case study in the Dawu water source area | |
CN106548022A (en) | The Forecasting Methodology and prognoses system of shield tunnel construction carbon emission amount | |
Ding et al. | Drainage and ecological service of irrigation schemes in China | |
Bugosh et al. | A summary of some land surface and water quality monitoring results for constructed GeoFluv landforms | |
CN110826127A (en) | Design optimization method for large industrial site | |
CN111523164A (en) | Excel-based visualization channel longitudinal section design method | |
Hurst | White castle and the dating of medieval pottery | |
Al-Rawas et al. | Construction problems in traditional irrigation systems: A case study from the Aflaj of Oman | |
CN208899306U (en) | A kind of complex conditions lower water-supply-pipe bridge structure | |
Fang et al. | Application of the GA-BP neural network in earthwork calculation | |
Wang et al. | Quantity and treatment status of C&D waste in China | |
Egboka et al. | Soil and gully erosion models for effective control programmes | |
Wenting | The design and optimization of Central Core Dam Based on CATIA | |
Cui et al. | Floor area ratio ANFIS model affected by causes of land subsidence |
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: 20180914 |