CN109766381A - A kind of method that assessment of project data are quoted automatically - Google Patents
A kind of method that assessment of project data are quoted automatically Download PDFInfo
- Publication number
- CN109766381A CN109766381A CN201811638168.XA CN201811638168A CN109766381A CN 109766381 A CN109766381 A CN 109766381A CN 201811638168 A CN201811638168 A CN 201811638168A CN 109766381 A CN109766381 A CN 109766381A
- Authority
- CN
- China
- Prior art keywords
- node
- wbs
- field
- template
- data
- 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 29
- 238000011156 evaluation Methods 0.000 claims abstract description 59
- 230000003213 activating effect Effects 0.000 claims abstract description 5
- 238000013215 result calculation Methods 0.000 claims description 7
- 238000010276 construction Methods 0.000 claims description 4
- 238000012360 testing method Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000007689 inspection Methods 0.000 description 3
- 238000012795 verification Methods 0.000 description 3
- 235000013399 edible fruits Nutrition 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000002689 soil Substances 0.000 description 1
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention provides a kind of method that assessment of project data are quoted automatically, include the following steps: step 10, pre-establish WBS every template node, and evaluation node therein and source data node are chosen on the basis of WBS every template node, create the incidence relation between node and node；The original table of step 20, the source data node that selection needs to quote in evaluating the evaluation form under node, and original table respective field field corresponding with evaluation form is created into adduction relationship；Step 30 creates WBS example according to WBS every template node, in the evaluation task for activating to open WBS example, automatically parse the source data node that incidence relation is corresponded in WBS every template node, and obtain the table field content that corresponding original table is cited, it is automatically filled in the evaluation form, completes the automatic reference of assessment of data in evaluation form.The method of the present invention can realize automatically generating for evaluation form assessment of data, reduce typing work, improve working efficiency.
Description
Technical field
The present invention relates to a kind of methods that assessment of project data are quoted automatically.
Background technique
Traditional project assessment of data be filled according to on-site test data by designated person and be calculated one by one it is final
The information content of table, the process manual entry is larger, should usually fill in on-site test data, fills in corresponding evaluation form again
Lattice, middle section data are filled in repeatedly, are easy error, are unable to ensure the authenticity and integrality of data.
Summary of the invention
The technical problem to be solved in the present invention, be to provide a kind of method that assessment of project data are quoted automatically, it can be achieved that
Evaluation form assessment of data automatically generates, and reduces typing work, improves working efficiency.
The present invention is implemented as follows: a kind of method that assessment of project data are quoted automatically, includes the following steps:
Step 10 pre-establishes WBS every template node, and evaluation node and source data are chosen on the basis of WBS every template node
Node creates the incidence relation between node；
The original table in source data node is chosen in step 20, the evaluation form hung in the case where evaluating node, and will be described original
Adduction relationship is created between table respective field and the corresponding evaluation literary name section；
Step 30 creates WBS example according to WBS every template node, in the evaluation task for activating to open WBS example, automatically
The source data node of incidence relation is corresponded in parsing WBS every template node, and obtains the table field that corresponding original table is cited
Content is automatically filled in the evaluation form, completes the automatic reference of assessment of data in evaluation form.
Further, the mode of the adduction relationship of field is created in the step 20 specifically: respectively to evaluation form and original
Field in beginning table there are adduction relationship is defined, and the field includes field name, cell location and field data
Type, the title that the field of adduction relationship will be present are arranged to the dtd--data type definition for the field being unanimously cited in original table
To introduce data, the data type for the field quoted in evaluation form is argument, and the original table respective field is corresponding with evaluation form
Field uniquely determined by cell location.
It further, further include that evaluation result calculation formula, institute have been pre-created according to business demand in the step 20
Directly using in original table, there are the fields of adduction relationship with evaluation form for the calculating variable for stating in evaluation result calculation formula.
Further, a plurality of WBS every template node forms a WBS and divides template, under every WBS every template node
Specific operation table is hung with according to business demand, all WBS every template nodes that the WBS is divided in template are according to tree structure
Form is created, included at least from high to low by level stage node locating for contract section node, engineering, construction unit node,
Partitioned project node, subdivisional work node, sub- subdivisional work node and working procedure node.
Further, whether the WBS every template node is determines according to actual conditions before the working procedure node of most sub- grade
Add subunit node and sub- branch's node.
The present invention has the advantage that the method for quoting source data automatically using assessment of project data, automatically generates correspondence
Evaluation result, only need to fill in on-site test data in whole process, eliminate and manually summarize assessment of data, calculate evaluation knot
The process of fruit ensure that the authenticity and integrality of data.
Detailed description of the invention
The present invention is further illustrated in conjunction with the embodiments with reference to the accompanying drawings.
Fig. 1 is the method for the present invention execution flow chart.
Fig. 2 is that the WBS in one embodiment of the invention divides every template node schematic diagram.
Fig. 3 is the interfacial effect schematic diagram of one embodiment of the invention interior joint correlation inquiry result.
Fig. 4 is the definition interfaces schematic diagram of original table in one embodiment of the invention.
Fig. 5 is the definition interfaces schematic diagram of evaluation form in one embodiment of the invention.
Specific embodiment
As shown in Figure 1, a kind of method that assessment of project data are quoted automatically of the invention, includes the following steps:
Step 10 pre-establishes WBS every template node, and choose on the basis of WBS every template node evaluation node therein with
Source data node creates the incidence relation between node and node；
Step 20, selection needs the original table of source data node quoted in evaluating the evaluation form under node, and by institute
State original table respective field field creation adduction relationship corresponding with evaluation form；
Step 30 creates WBS example according to WBS every template node, in the evaluation task for activating to open WBS example, automatically
The source data node of incidence relation is corresponded in parsing WBS every template node, and obtains the table field that corresponding original table is cited
Content is automatically filled in the evaluation form, completes the automatic reference of assessment of data in evaluation form.
In a preferred embodiment, the mode of the adduction relationship of field is created in the step 20 specifically: respectively to commenting
Determine the field in table and original table there are adduction relationship to be defined, the field include field name, cell location and
Field data types, the title that the field of adduction relationship will be present are arranged to the data for the field being unanimously cited in original table
Type definition is to introduce data, and the data type for the field quoted in evaluation form is argument, the original table respective field with comment
Determine the corresponding field of table to uniquely determine by cell location.
It in a preferred embodiment, further include that evaluation result calculating has been pre-created according to business demand in the step 20
Formula, directly using in original table, there are the words of adduction relationship with evaluation form for the calculating variable in the evaluation result calculation formula
Section.
In a preferred embodiment, a plurality of WBS every template nodes forms a WBS and divides template, every WBS mould
Specific operation table is hung with according to business demand under plate node, or does not hang operation table, the WBS divides all WBS in template
Every template node is created according to tree structure form, is included at least from high to low locating for contract section node, engineering by level
Stage node, construction unit node, partitioned project node, subdivisional work node, sub- subdivisional work node and working procedure node.
Whether the WBS every template node before the working procedure node of most sub- grade adds subunit node and son determines according to actual conditions
Branch's node.
Below with reference to a specific embodiment, the present invention will be further described:
It is obtained as shown in Fig. 2, being created by taking science of bridge building as an example, science of bridge building-partitioned project node of construction unit node
Basis and the sub- partitioned project node of infrastructure-the sub- subdivisional work node of pier (platform)-subdivisional work node pile foundation-
The concreting of artificial digging pile-working procedure node, creation WBS divide template on select need node into
Row association, such as click subdivisional work verification select mixing for the subdivisional work verification and working procedure in WBS every template node later
Solidifying soil, which pours, to be combined and saves, and completes incidence relation in the database at this time, it is available to inquire corresponding table
Associated record, the record of two associated nodes of WBS data summary table as shown in Figure 3, with one of them identical content field
Indicate incidence relation.It is divided in the corresponding WBS division template table of template in WBS later and also inquires corresponding nodes records letter
It ceases, after the subsequent division template generation WBS division example according to WBS, can also inquire WBS and divide corresponding record information in example.
As shown in Figure 4 and Figure 5, (such as the borehole quality of pile of the evaluation form in the case where evaluating node (such as subdivisional work verification)
Test evaluation table) in selection original table (such as the caisson of source data node (such as concreting node) that needs to quote
Quality in site inspection report), and the original table respective field (such as concrete strength measured value) is corresponding with evaluation form
Field (such as concrete strength measured value) create adduction relationship；It is specific: respectively in evaluation form and original table exist draw
It is defined with the field of relationship, the field includes field name, cell location and field data types, will be present and draws
It is arranged to consistent (such as concrete strength measured value) with the title of the field of relationship, the data for the field being cited in original table
Type definition is to introduce data, and the data type for the field quoted in evaluation form is argument, the original table respective field with comment
Determine the corresponding field of table to uniquely determine by cell location, is convenient for subsequent automatic reference.In addition, can also be pre- according to business demand
First create evaluation result calculation formula, the calculating variable in the evaluation result calculation formula directly using in original table with comment
Determine field of the table there are adduction relationship, is convenient for subsequent automatic calculating.
After creating WBS example according to WBS every template node, in the evaluation task for activating to open WBS example, automatically parse
The source data node (such as concreting node) of incidence relation is corresponded in WBS every template node, and obtains corresponding original table
Table field (such as concrete strength measured value) content that (such as caisson quality in site inspection report) is cited, automatically
It inserts in the evaluation form, completes the production of evaluation form (such as caisson quality inspection and evaluation table).
The method that the present invention uses assessment of project data to quote source data automatically, automatically generates corresponding evaluation result, whole
It only needs to fill in on-site test data during a, eliminates the process for manually summarizing assessment of data, calculating evaluation result, guarantee
The authenticity and integrality of data.
Although specific embodiments of the present invention have been described above, those familiar with the art should be managed
Solution, we are merely exemplary described specific embodiment, rather than for the restriction to the scope of the present invention, it is familiar with this
The technical staff in field should be covered of the invention according to modification and variation equivalent made by spirit of the invention
In scope of the claimed protection.
Claims (5)
1. a kind of method that assessment of project data are quoted automatically, characterized by the following steps:
Step 10 pre-establishes WBS every template node, and chooses evaluation node therein and source number on the basis of WBS every template node
According to node, the incidence relation between node and node is created；
Step 20, selection needs the original table of source data node quoted in evaluating the evaluation form under node, and by the original
Beginning table respective field field corresponding with evaluation form creates adduction relationship；
Step 30 is automatically parsed according to WBS every template node creation WBS example in the evaluation task for activating to open WBS example
The source data node of incidence relation is corresponded in WBS every template node, and obtains the table field content that corresponding original table is cited,
It is automatically filled in the evaluation form, completes the automatic reference of assessment of data in evaluation form.
2. a kind of method that assessment of project data are quoted automatically according to claim 1, it is characterised in that: the step 20
The mode of the adduction relationship of middle creation field specifically: there are the progress of the field of adduction relationship in evaluation form and original table respectively
Definition, the field includes field name, cell location and field data types, and the name of the field of adduction relationship will be present
Title is arranged to unanimously, and the dtd--data type definition for the field being cited in original table is to introduce data, the field quoted in evaluation form
Data type be argument, original table respective field field corresponding with evaluation form is uniquely determined by cell location.
3. a kind of method that assessment of project data are quoted automatically according to claim 2, it is characterised in that: the step 20
In further include that evaluation result calculation formula has been pre-created according to business demand, calculating in the evaluation result calculation formula becomes
Amount is directly using there are the fields of adduction relationship with evaluation form in original table.
4. a kind of method that assessment of project data are quoted automatically according to claim 1, it is characterised in that: a plurality of institutes
It states WBS every template node and forms WBS and divide template, specific operation is hung with according to business demand under every WBS every template node
Table, all WBS every template nodes that the WBS is divided in template are created according to tree structure form, by level from height to
It is low include at least contract section node, stage node, construction unit node locating for engineering, partitioned project node, subdivisional work node,
Sub- subdivisional work node and working procedure node.
5. a kind of method that assessment of project data are quoted automatically according to claim 4, it is characterised in that: the WBS mould
Whether plate node adds subunit node and sub- branch's node determines according to actual conditions before the working procedure node of most sub- grade.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811638168.XA CN109766381A (en) | 2018-12-29 | 2018-12-29 | A kind of method that assessment of project data are quoted automatically |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811638168.XA CN109766381A (en) | 2018-12-29 | 2018-12-29 | A kind of method that assessment of project data are quoted automatically |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109766381A true CN109766381A (en) | 2019-05-17 |
Family
ID=66453112
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811638168.XA Pending CN109766381A (en) | 2018-12-29 | 2018-12-29 | A kind of method that assessment of project data are quoted automatically |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109766381A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112036148A (en) * | 2020-08-31 | 2020-12-04 | 湖南美石信息技术有限公司 | Concrete test detection management system |
| WO2021073077A1 (en) * | 2019-10-15 | 2021-04-22 | 深圳逻辑汇科技有限公司 | Method, apparatus and device for automatically generating spreadsheet, and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140189858A1 (en) * | 2012-12-27 | 2014-07-03 | Industrial Technology Research Institute | Generation Method and Device for generating anonymous dataset, and method and device for risk evaluation |
| CN106940839A (en) * | 2017-03-13 | 2017-07-11 | 中国南方电网有限责任公司超高压输电公司 | A kind of project of transmitting and converting electricity qualitative data managing and control system and method |
| CN107818427A (en) * | 2017-11-24 | 2018-03-20 | 国网内蒙古东部电力有限公司 | A kind of bill of quantities information for power network technological transformation overhaul engineering and WBS information coupling process and its system |
| CN108537440A (en) * | 2018-04-09 | 2018-09-14 | 四川交通职业技术学院 | A kind of building scheme project management system based on BIM |
-
2018
- 2018-12-29 CN CN201811638168.XA patent/CN109766381A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140189858A1 (en) * | 2012-12-27 | 2014-07-03 | Industrial Technology Research Institute | Generation Method and Device for generating anonymous dataset, and method and device for risk evaluation |
| CN106940839A (en) * | 2017-03-13 | 2017-07-11 | 中国南方电网有限责任公司超高压输电公司 | A kind of project of transmitting and converting electricity qualitative data managing and control system and method |
| CN107818427A (en) * | 2017-11-24 | 2018-03-20 | 国网内蒙古东部电力有限公司 | A kind of bill of quantities information for power network technological transformation overhaul engineering and WBS information coupling process and its system |
| CN108537440A (en) * | 2018-04-09 | 2018-09-14 | 四川交通职业技术学院 | A kind of building scheme project management system based on BIM |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021073077A1 (en) * | 2019-10-15 | 2021-04-22 | 深圳逻辑汇科技有限公司 | Method, apparatus and device for automatically generating spreadsheet, and storage medium |
| CN112036148A (en) * | 2020-08-31 | 2020-12-04 | 湖南美石信息技术有限公司 | Concrete test detection management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109785436B (en) | BIM technology-based reinforcing steel bar information full life cycle management method | |
| US7835893B2 (en) | Method and system for scenario and case decision management | |
| Peña-Mora et al. | Dynamic planning and control methodology for design/build fast-track construction projects | |
| Wu et al. | Calibrating water distribution model via genetic algorithms | |
| US8902221B2 (en) | Prospect assessment and play chance mapping tools | |
| US8749549B2 (en) | Prospect assessment and play chance mapping tools | |
| CN109766381A (en) | A kind of method that assessment of project data are quoted automatically | |
| CN109635485A (en) | Tunnel Dynamic Construction information model component entity extended method based on IFC standard | |
| CN109144474A (en) | A kind of document and the integrated management system of code and method | |
| CN109064126B (en) | Hydropower engineering metering information management method based on quality driving | |
| CN112948947B (en) | Gravity dam structural design compliance checking method based on BIM | |
| Yuan et al. | Construction schedule early warning from the perspective of probability and visualization | |
| CN109783492A (en) | A kind of data referencing divided based on WBS and the method and apparatus summarized | |
| CN109903008A (en) | A kind of subway work construction project progress visualization managing and control system and management-control method | |
| CN109766343A (en) | The method and apparatus of different flowline numberings is generated based on WBS instantiated nodes | |
| Brinkgreve et al. | Automatic Finite Element Modelling and Parameter Determination for Geotechnical Design | |
| CN110851900A (en) | Method, device, storage medium and equipment for reinforcing ribs of geometric shapes and automatically updating geometric shapes | |
| Moavenzadeh et al. | Simulation model for tunnel construction costs | |
| CN109767104B (en) | Engineering test task starting method based on WBS division and computer equipment | |
| AU2012203388A1 (en) | Prospect assessment and play chance mapping tools | |
| CN113139704B (en) | Drilling multi-parameter computing system and method for drilling simulation | |
| CN114358525A (en) | Progress measurement integration method and system based on EBS mapping relation | |
| CN109783493A (en) | A kind of engineering toponym quoting method divided based on WBS | |
| Song et al. | Stochastic look-ahead scheduling method for linear construction projects | |
| Hassanein et al. | Automated data acquisition and planning of highway construction |
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: 20190517 |