CN107818427B - Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering - Google Patents
Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering Download PDFInfo
- Publication number
- CN107818427B CN107818427B CN201711190632.9A CN201711190632A CN107818427B CN 107818427 B CN107818427 B CN 107818427B CN 201711190632 A CN201711190632 A CN 201711190632A CN 107818427 B CN107818427 B CN 107818427B
- Authority
- CN
- China
- Prior art keywords
- wbs
- node
- identification code
- tree
- code
- 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.)
- Expired - Fee Related
Links
- 230000008439 repair process Effects 0.000 title claims abstract description 42
- 230000006872 improvement Effects 0.000 title claims abstract description 35
- 238000010168 coupling process Methods 0.000 title claims abstract description 33
- 238000000034 method Methods 0.000 claims description 26
- 230000008878 coupling Effects 0.000 claims description 22
- 238000005859 coupling reaction Methods 0.000 claims description 22
- 230000004048 modification Effects 0.000 claims description 17
- 238000012986 modification Methods 0.000 claims description 17
- 238000010276 construction Methods 0.000 claims description 14
- 238000009434 installation Methods 0.000 claims description 11
- 230000009466 transformation Effects 0.000 claims description 5
- 230000005540 biological transmission Effects 0.000 claims description 4
- 238000004364 calculation method Methods 0.000 claims description 4
- 230000015556 catabolic process Effects 0.000 claims description 3
- 230000007547 defect Effects 0.000 abstract description 2
- 238000007726 management method Methods 0.000 description 9
- 230000008569 process Effects 0.000 description 5
- 230000008901 benefit Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000000354 decomposition reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 230000017105 transposition Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06K—GRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
- G06K17/00—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
- G06K17/0022—Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations arrangements or provisions for transferring data to distant stations, e.g. from a sensing device
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Health & Medical Sciences (AREA)
- Quality & Reliability (AREA)
- Primary Health Care (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Health & Medical Sciences (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a coupling method of project amount list information and WBS information for power grid technical improvement and major repair engineering, which overcomes the defect that WBS element architecture is not correspondingly coupled with a project amount list compared with the prior art. The invention comprises the following steps: establishing a WBS identification code tree structure, setting a WBS identification code format, establishing a WBS data dictionary of the WBS identification code, and establishing the WBS identification code tree structure according to the WBS data dictionary; establishing an engineering quantity list coding tree structure, acquiring list project codes of a power grid technical improvement major repair project, analyzing and constructing the engineering quantity list coding tree structure; the engineering quantity list information is coupled with the WBS information, and the WBS identification code tree structure is correspondingly associated with the engineering quantity list coding tree structure. The invention can effectively associate the project amount list information with the WBS information.
Description
Technical Field
The invention relates to the technical field of data analysis, in particular to a method and a system for coupling engineering quantity list information and WBS (work breakdown Structure) information for power grid technical improvement and major repair engineering.
Background
With the promotion of the construction of the three-in-five system, higher requirements are provided for the national power grid company and each electric power company to strengthen the specialized and lean management level. The technical improvement overhaul management is an important content of the electric power company management, how to reasonably and effectively manage and control the technical improvement overhaul project, and plays an important role in realizing the healthy and stable operation of the electric power company equipment.
In order to strengthen the management and control of the national grid technical improvement major repair project, reasonably invest, improve economic benefits and promote the healthy and stable development of the grid, the national energy agency issues a grid technical improvement project budget plan and calculation standard, a grid technical improvement project budget quota, a grid dismantling project budget quota and corresponding grid overhaul project files compiled by the Chinese power enterprise union to follow the execution. However, with the development of market economy, the quota project is seriously disconnected from the actual market situation, the medium price of the technical improvement and overhaul project is similar to the nominal price, and the completion settlement is carried out in and out greatly, so that the fair competition of enterprises is not facilitated.
The project amount list is a brand-new pricing mode, adopts comprehensive unit price, carries out cost budget with market price, and definitely and specifically reflects the real object consumption and other related expenses of technical improvement and major repair projects, including labor, materials, machinery, management expenses and profits. In the bidding process, when a tenderer compiles a project amount list, the market prices of manpower, materials and machinery are taken as pricing basis according to project codes, project names, measuring units and calculation rules unified in the project amount list pricing standard for power grid technical reconstruction and the project amount list pricing standard for power grid maintenance. The independent quotation of the enterprise is really realized by determining the management fee, the profit and the measure project fee by considering the self management and technical level of the enterprise. Therefore, enterprises can fully exert subjective initiative and all advantages of the enterprises, the price reasonability is guaranteed, and the 'fairness, openness and justice' principle of bidding can be implemented.
The WBS is an important basis for organizing, planning and controlling the project of the power grid technical improvement and major repair project, and the main work of the WBS is the decomposition of the project entity. The project quantity list provides an entity decomposition structure for the power grid technical improvement and major repair project, is used as a basis for the tender and quotation of contractors, is a platform for the contractors to exchange and deliver packages, and is an important basis for the project structure decomposition of the power grid technical improvement and major repair project.
The WBS element architecture of the current transmission and transformation project still belongs to a gross participation mode, that is, every time a new project is established, all WBS elements are mapped into the project, and the mapping and coupling with the project volume list are lacked, so that the WBS elements are heavy in content in the whole project architecture and redundant, and the investment benefit management of the engineering of the technical improvement and major repair project is seriously troubled. Therefore, how to perform fusion association of the engineering quantity inventory information and the WBS element data has become an urgent technical problem to be solved.
Disclosure of Invention
The invention aims to solve the defect that the WBS element architecture is not correspondingly coupled with an engineering quantity list in the prior art, and provides an engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering to solve the problems.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a project amount list information and WBS information coupling method for power grid technical improvement and major repair projects comprises the following steps:
establishing a WBS identification code tree structure, setting a WBS identification code format, establishing a WBS data dictionary of the WBS identification code, and establishing the WBS identification code tree structure according to the WBS data dictionary;
establishing an engineering quantity list coding tree structure, acquiring list project codes of a power grid technical improvement major repair project, analyzing and constructing the engineering quantity list coding tree structure;
the engineering quantity list information is coupled with the WBS information, and the WBS identification code tree structure is correspondingly associated with the engineering quantity list coding tree structure.
The establishment of the WBS identification code tree structure comprises the following steps:
setting the format of WBS identification code, setting the number of identification code to be 8 bits, and setting the format as:
identification code category + identification code major category + identification code middle category + identification code minor category + sequence code,
the identification code type is located at the first position of the identification code number and is a power transformation technical modification major repair type, a power transmission line technical modification major repair type, a converter station technical modification major repair type, a distribution network technical modification major repair type or a secondary system technical modification major repair;
the identification code is the 2 nd digit of the identification code, which is the construction project cost, the installation project cost or the equipment purchase cost;
the class in the identification code is the 3 rd bit of the identification code number, the subclass of the identification code is the 4 th bit of the identification code number, and the 5 th to 8 th bits of the identification code number are sequential codes;
acquiring WBS identification code data, wherein the input content of the WBS identification code data comprises data described by layers, WBS identification codes and identification codes, and a WBS data dictionary is obtained after the data acquisition is finished;
constructing a WBS identification code architecture in a tree structure according to the WBS data dictionary, and displaying the WBS identification code architecture in a layered mode to form a WBS identification code tree structure;
the WBS identity tree structure is set as follows:
setting each identification code category as a Tree, setting the Tree root nodes as the identification code categories, layering the Tree levels according to the categories, designing a Tree form table structure by adopting left and right value coding based on the traversal of the Tree's front sequence,
its Tree table structure is represented as: { WBS _ Node _ id, WBS _ Code, WBS _ Name, WBS _ Left, WBS _ Right },
wherein: WBS _ Node _ id is the WBS id tree Node number, WBS _ Code is the WBS id, WBS _ Name is the WBS element description, WBS _ Left is the WBS id tree Node Left, and WBS _ Right is the WBS id tree Node Right.
The establishment of the engineering quantity list coding tree structure comprises the following steps:
acquiring a list project division definition table of a power grid technical improvement major repair project;
acquiring a list item code in a list item division definition table, constructing a list item code framework in a tree structure according to the list item code, and displaying the list item code framework in a layered mode;
the manifest item encoding architecture is set as follows:
each list classification code is a tree, the tree root node is a list classification code, corresponding to the first two bits of the item code, the tree hierarchy is divided and layered according to the items, and a layer of large class code is added on the second layer;
the tree structure of the engineering quantity list code is set as follows: setting each list classification code as a Tree, setting the root node as the list classification code, dividing the Tree hierarchy into layers according to the items, designing the Tree form table structure by using left and right value coding based on the Tree's preorder traversal,
the Tree Table structure is represented as: { Node _ id, Code, Name, Left, Right },
wherein: node _ id is the Node number of the coding tree of the engineering quantity list, Code is the list coding, Name is the description of the list coding, Left is the Left value of the coding tree of the engineering quantity list, and Right is the Right value of the coding tree of the engineering quantity list.
The coupling of the project amount list information and the WBS information comprises the following steps:
establishing a relation table for storing the corresponding relation between the inventory code and the WBS identification code according to the inventory classification code in the engineering quantity inventory code architecture, wherein the attributes of the relation table comprise the inventory code, the inventory name, the WBS identification code corresponding to the construction engineering, the WBS identification code corresponding to the installation engineering, the WBS identification code corresponding to the equipment purchase and whether the corresponding judgment is carried out;
creating a main control pointer and an auxiliary pointer according to the designated engineering category, wherein the main control pointer points to an engineering quantity list coding tree in an engineering quantity list coding structure, the root node of the tree is read, the auxiliary pointer points to a WBS identification code tree of the WBS identification code structure, and the root node of the tree is read;
and sequentially and respectively traversing the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer according to a forward traversal method.
The method for sequentially and respectively traversing the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer according to the precedence traversal method comprises the following steps:
the main control pointer and the auxiliary pointer point to the second layer at the same time to start traversing;
the main control pointer and the auxiliary pointer are compared,
reading Code, Name, Left and Right in the node when the main control pointer points to an engineering quantity list coding tree node, synchronously pointing the auxiliary pointer to the tree node of the same layer of the WBS identification Code tree, and reading WBS _ Code, WBS _ Name, WBS _ Left and WBS _ Right in the tree node;
calculating the similarity of the Name contents of the nodes pointed by the two pointers,
the method for calculating the Name contents of the two nodes by adopting the cosine similarity comprises the following calculation formula:
P(A，B)＝sqrt(A×B)/(|A|×|B|)，
a, B are two character strings, axb is the same number of characters, | a | is the length of the character string a, | B | is the length of the character string B;
when P (A, B) > C and C are thresholds, the content of the A and the content of the B node are consistent, and the steps of storing the content of the current node and moving down the pointer are carried out;
if the contents of the node A and the node B do not accord with each other, the auxiliary pointer continuously points to the next node according to the forward traversal method, the WBS _ Code, the WBS _ Name, the WBS _ Left and the WBS _ Right in the current node are read, and the step of repeatedly calculating the similarity of the Name contents of the nodes pointed by the two pointers is carried out;
if the auxiliary pointer traverses all the descendant nodes of the third layer of nodes and does not find a node with similar content, the content of the node pointed by the main control pointer is not associated with a corresponding WBS (work breakdown site), the main control pointer moves to the next node, the auxiliary pointer returns to the first descendant node of the third layer, and the step of repeatedly calculating the similarity of the Name content of the nodes pointed by the two pointers is carried out;
the current node contents are saved and the pointer is moved down,
if the node Right-Left >1 in the engineering quantity list code tree and the WBS _ Right-WBS _ Left >1 of the node in the WBS identification code tree at this time,
setting temporary variable relationship as "Y", calling and storing the association relationship, and transferring to the step of storing the association relationship;
synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
if the node Right-Left in the engineering quantity list code tree is greater than 1, and the WBS _ Right-WBS _ Left of the node in the WBS identification code tree at the moment is 1, the node in the engineering quantity list code tree is a non-leaf node, and the node of the WBS identification code tree is a leaf node;
setting temporary variable relationship as "Y", calling and storing the association relationship, and transferring to the step of storing the association relationship;
the total number of descendant nodes of the current node pointed by the master pointer is calculated,
total number of offspring ═ (Right-Left-1)/2;
the main control pointer moves to the next Node, the auxiliary pointer is not moved, a temporary variable Node _ sum is set, the number of nodes Node _ sum is recorded as Node _ sum +1, the Code, the Name, the Left and the Right in the current Node of the main control pointer are read, a temporary variable relationship is set as Y, the association relationship is called and saved, and the step of saving the association relationship is carried out;
until Node _ sum is the total number of descendants;
synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
if the node Right-Left in the engineering quantity list code tree is 1, and the node WBS _ Right-WBS _ Left >1 in the WBS identification code tree at this time indicates that the list code tree node is a leaf node, the WBS identification code tree node is a non-leaf node,
and (3) calculating the total number of the descendants of the current node pointed by the auxiliary control pointer:
the total number of descendants is (WBS _ Right-WBS _ Left-1)/2, and the temporary variable relationship is set to "N";
the main control pointer is not moved, the auxiliary pointer moves to the next Node, a temporary variable Node _ sum is set, the number of nodes Node _ sum is recorded as Node _ sum +1, WBS _ Code and WBS _ Name in the current Node of the auxiliary pointer are read,
setting a temporary variable Temp _ Code ═ Temp _ Code + WBS _ Code;
until Node _ sum is the total number of descendants;
setting WBS _ Code ═ Temp _ Code of the node pointed by the auxiliary pointer; calling and storing the association relationship, and turning to the step of storing the association relationship;
synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
the association relationship is saved and the user can use the association relationship,
determining whether the first two digits of the WBS _ Code in the current pointer in the WBS identification Code tree are construction project cost, installation project cost or equipment purchase cost, and storing the Code, the Name and the relationship content of the node pointed by the main control pointer into a relationship table.
A system of project amount list information and WBS information coupling method for power grid technical and modification major repair project,
the WBS identification code tree structure building module is used for building the WBS identification code tree structure and sending the WBS identification code tree structure to the WBS information coupling module, the engineering quantity list coding tree structure building module is used for building the engineering quantity list coding tree structure and sending the engineering quantity list coding tree structure to the WBS information coupling module, and the engineering quantity list coding tree structure coupling module is used for correspondingly associating the WBS identification code tree structure with the engineering quantity list coding tree structure.
Advantageous effects
Compared with the prior art, the engineering quantity list information and WBS information coupling method and the system thereof for the power grid technical improvement major repair project can effectively correlate the engineering quantity list information and the WBS information, realize the direct utilization of the engineering quantity list information, solve the WBS frame redundancy problem in the power grid technical improvement major repair project management and control process, and reduce the WBS data volume in the ERP system of the power grid technical improvement major repair project.
The invention firstly establishes tree structures for WBS information and engineering quantity inventory information to overcome the problem that WBS data is not matched with engineering quantity data, and then sequentially traverses and compares the two tree structures by utilizing a precedence traversal method to form a relation table for storing the corresponding relation between inventory codes and WBS identification codes, and the two data types are coupled in a correlation mode through attributes in the relation table.
Drawings
FIG. 1 is a sequence diagram of the method of the present invention;
FIG. 2 is a system architecture connection diagram of the present invention;
FIG. 3 is a schematic diagram of a WBS ID tree structure;
FIG. 4 is a schematic diagram of a manifest encoding tree structure;
the system comprises a 1-WBS identification code tree structure establishing module, a 2-engineering quantity list coding tree structure establishing module and a 3-engineering quantity list information and WBS information coupling module.
Detailed Description
So that the manner in which the above recited features of the present invention can be understood and readily understood, a more particular description of the invention, briefly summarized above, may be had by reference to embodiments, some of which are illustrated in the appended drawings, wherein:
as shown in fig. 1, the method for coupling the engineering volume inventory information and the WBS information for the grid technical improvement and major repair project according to the present invention includes the following steps:
first, building a tree structure of WBS identification codes. Setting a WBS identification code format, constructing a WBS data dictionary of the WBS identification code, and constructing a WBS identification code tree structure according to the WBS data dictionary. The hierarchical relationship inside the WBS identification code data can be conveniently represented by establishing the WBS identification code tree structure, recursive query is eliminated when the WBS identification code tree structure is coupled with the list code, and the WBS identification code data retrieval efficiency is improved.
Which comprises the following steps:
(1) setting the format of WBS identification code, setting the number of identification code to be 8 bits, and setting the format as:
identification code category + identification code major category + identification code middle category + identification code minor category,
the identification code type is located at the first position of the identification code number and is a power transformation technical modification major repair type, a power transmission line technical modification major repair type, a converter station technical modification major repair type, a distribution network technical modification major repair type or a secondary system technical modification major repair;
the identification code is the 2 nd digit of the identification code, which is the construction project cost, the installation project cost and the equipment purchase cost;
the class in the identification code is the 3 rd bit of the identification code number, the subclass of the identification code is the 4 th bit of the identification code number, and the 5 th to 8 th bits of the identification code number are sequential codes;
as shown in table 1, table 1 indicates the identification code category and applicable service range represented by the first letter or number of the WBS identification code.
TABLE 1WBS identification code rule Table
(2) And acquiring WBS identification code data, wherein the recorded content of the WBS identification code data comprises data of layers, WBS identification codes and identification code descriptions, and acquiring a WBS data dictionary after the data acquisition is finished.
As shown in table 2. Table 2 shows a portion of the WBS overall architecture template of the power transformation technical improvement project in practical application.
Table 2 transformer technical improvement project WBS element table
| Hierarchy level | WBS identification code | Description of WBS elements | |
| 1 | | Transformer substation | |
| 2 | B1000000 | Cost of |
|
| 3 | B1100000 | Mainly for producing buildings | |
| 4 | B1110000 | Master control communication building | |
| 4 | B1120000 | Relay room of 1000kV and above | |
| 4 | B1130000 | 750kV relay room | |
| 4 | B1140000 | 500kV relay room | |
| 4 | B1150000 | 330kV relay room | |
| 4 | B1160000 | 220kV relay room | |
| 4 | B1170000 | 110kV relay room | |
| 4 | B1180000 | 66kV relay room | |
| 4 | B1190000 | 35kV relay room | |
| 4 | B11A0000 | 10kV (20kV) relay room | |
| 4 | B11B0000 | 1000kV and above distribution device room | |
| 4 | B11C0000 | 750kV distribution device room | |
| 4 | B11D0000 | 500kV distribution device room | |
| 4 | B11F0000 | 330kV distribution device room | |
| 4 | B11G0000 | 220kV power distribution unit room | |
| 4 | B11H0000 | 110kV distribution device room | |
| 4 | B11J0000 | 66kV distribution device room | |
| 4 | B11K0000 | 35kV distribution device room | |
| 4 | B11L0000 | 10kV (20kV) distribution transposition room | |
| 4 | B11M0000 | Power distribution equipment room for station | |
| 4 | B11N0000 | Other switchgear cabinets | |
| 5 | B11N1000 | Control room for fixed series compensation device | |
| 5 | B11N2000 | Controllable high-voltage reactor thyristor valve chamber | |
| 5 | B11N3000 | Controllable series compensation device control room | |
| 5 | B11N4000 | Thyristor valve chamber of static reactive |
|
| 3 | B1200000 | Main transformer and power distribution unit building | |
| 4 | B1210000 | Main transformer system foundation | |
| 4 | B1220000 | High-voltage reactor system foundation |
(3) And constructing a WBS identification code framework in a tree structure according to the WBS data dictionary, and displaying the WBS identification code framework in a layering manner to form the WBS identification code tree structure.
The WBS identity tree structure is set as follows:
as shown in fig. 3, each identifier category is set as a Tree, a Tree root node is set as an identifier category, Tree hierarchies are hierarchically classified, and a Tree table structure is designed by using left and right value coding based on Tree's forward traversal.
Its Tree table structure is represented as: { WBS _ Node _ id, WBS _ Code, WBS _ Name, WBS _ Left, WBS _ Right },
wherein: WBS _ Node _ id is the WBS id tree Node number, WBS _ Code is the WBS id, WBS _ Name is the WBS element description, WBS _ Left is the WBS id tree Node Left value, and WBS _ Right is the WBS id tree Node Right value, as shown in table 3.
Table 3 WBS identification code tree structure table based on left and right value encoding
| WBS_Node_Id | WBS_Code | WBS_Name | WBS_Left | WBS_Right |
| 1 | B0000000 | Technical improvement project of transformer substation | 1 | 916 |
| 2 | B1000000 | Cost of |
2 | 127 |
| 3 | B1100000 | Mainly for producing |
3 | 54 |
| 4 | B1110000 | Master control communication building | 4 | 5 |
| 5 | B1120000 | Relay room of 1000kV and above | 6 | 7 |
| 6 | B1130000 | 750kV relay room | 8 | 9 |
| 7 | B1140000 | 500kV relay room | 10 | 11 |
| 8 | B1150000 | 330kV relay room | 12 | 13 |
| 9 | B1160000 | 220kV relay room | 14 | 15 |
| 10 | B1170000 | 110kV relay room | 16 | 17 |
| 11 | B1180000 | 66kV relay room | 18 | 19 |
| 12 | B1190000 | 35kV relay room | 20 | 21 |
| 13 | B11A0000 | 10kV (20kV) relay room | 22 | 23 |
| 14 | B1180000 | 1000kV and above distribution device room | 24 | 25 |
| 15 | B11C0000 | 750kV distribution device room | 26 | 27 |
| 16 | B11D0000 | 500kV distribution device room | 28 | 29 |
| 17 | B11F0000 | 330kV distribution device room | 30 | 31 |
| 18 | B11G0000 | 220kV power distribution unit room | 32 | 33 |
| 19 | B11H0000 | 110kV distribution device room | 34 | 35 |
| 20 | B11J0000 | 66kV distribution device room | 36 | 37 |
| 21 | B11K0000 | 35kV distribution device room | 38 | 39 |
| 22 | B11L0000 | 10kV (20kV) distribution equipment room | 40 | 41 |
| 23 | B11M0000 | Power distribution equipment room for station | 42 | 43 |
| 24 | B11N0000 | Other switchgear cabinets | 44 | 53 |
| 25 | B11N1000 | Control room for fixed series compensation device | 45 | 46 |
| 26 | B11N2000 | Controllable high-voltage reactor thyristor valve chamber | 47 | 48 |
| 27 | B11N3000 | Controllable series compensation device control room | 49 | 50 |
| 28 | B11N4000 | Thyristor valve chamber of static reactive power compensation device | 51 | 52 |
And secondly, establishing an engineering quantity list coding tree structure. And acquiring a list project code of the power grid technical improvement major repair project, analyzing and constructing a project quantity list code tree structure. By establishing the engineering quantity list coding tree structure, the hierarchical relation in the list coding data can be conveniently determined, recursive query is eliminated when the list coding data is coupled with WBS identification codes, and the list coding data retrieval efficiency is improved. And establishing a hierarchical corresponding relation between the WBS identification code and the list code through the construction of the WBS identification code tree structure and the list code tree structure.
(1) And acquiring a list item division definition table of the power grid technical improvement and major repair project. The list project division definition of the power grid technical improvement major repair project indicates that the meaning and the service range of each bit of project codes are shown, the number of the project codes is 6, the first two are project classification codes, the 3 rd and 4 th are project professional projects, and the 5 th and 6 th are branch projects.
(2) Acquiring the list item codes in the list item division definition table, constructing a list item coding framework in a tree structure according to the list item codes, and displaying the list item coding framework in a layered mode. As shown in fig. 4, each list classification code is a tree, the tree root node is a list classification code corresponding to the first two digits of the project code, the tree hierarchy is divided into layers according to the projects, but corresponds to the WBS identification code tree hierarchy, and a layer of large class code is added on the second layer to correspond to the second layer of large class code in the WBS identification code tree, such as building engineering and installation engineering; the third layer is that the professional project of the list code corresponds to the middle class of the third layer in the WBS identification code tree, and the fourth layer is that the subsection project of the list code corresponds to the subclass of the WBS identification code, so that the hierarchical corresponding relation is constructed. The tree structure and the table structure method thereof are the same as the building process of the WBS tree structure.
The manifest item encoding architecture is set as follows:
each list classification code is a tree, the tree root node is a list classification code, corresponding to the first two bits of the item code, the tree hierarchy is divided and layered according to the items, and a layer of large class code is added on the second layer;
the tree structure of the engineering quantity list code is set as follows: setting each list classification code as a Tree, setting the root node as the list classification code, dividing the Tree hierarchy into layers according to the items, designing the Tree form table structure by using left and right value coding based on the Tree's preorder traversal,
the Tree Table structure is represented as: { Node _ id, Code, Name, Left, Right },
wherein: node _ id is the Node number of the coding tree of the engineering quantity list, Code is the list coding, Name is the description of the list coding, Left is the Left value of the coding tree of the engineering quantity list, and Right is the Right value of the coding tree of the engineering quantity list.
Third, the engineering volume inventory information is coupled with the WBS information. And correspondingly associating the WBS identification code tree structure with the engineering quantity list coding tree structure. Which comprises the following steps:
(1) and establishing a relation table for storing the corresponding relation between the inventory code and the WBS identification code according to the inventory classification code in the project amount inventory code framework, wherein the attributes of the relation table comprise the inventory code, the inventory name, the WBS identification code corresponding to the construction project, the WBS identification code corresponding to the installation project, the WBS identification code corresponding to the equipment purchase and whether the list code corresponds to the WBS identification code or not (Y represents correspondence, and N represents non-correspondence). The relation table of the corresponding relation between the list codes and the WBS identification codes is used for directly and accurately finding the WBS catalogue according to the list codes in the budget items when the ERP submits purchase application, so that the WBS structure in the ERP is simplified, the system redundancy is reduced, and the working efficiency is improved.
(2) And creating a main control pointer and an auxiliary pointer according to the designated engineering category, wherein the main control pointer points to an engineering quantity list coding tree in an engineering quantity list coding structure, the root node of the tree is read, the auxiliary pointer points to a WBS identification code tree of the WBS identification code structure, and the root node of the tree is read. And traversing, comparing and associating the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer.
(3) And sequentially and respectively traversing the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer according to a forward traversal method. The method comprises the following specific steps:
and step A, the main control pointer and the auxiliary pointer point to the second layer at the same time, and traversal is started.
And step B, comparing the main control pointer with the auxiliary pointer.
Whenever the main control pointer points to an engineering quantity list coding tree node, reading Code, Name, Left and Right in the node, synchronously pointing the auxiliary pointer to the tree node of the same layer of the WBS identification Code tree, and reading WBS _ Code, WBS _ Name, WBS _ Left and WBS _ Right in the tree node.
And C, calculating the Name content similarity of the nodes pointed by the two pointers.
The method for calculating the Name contents of the two nodes by adopting the cosine similarity comprises the following steps:
P(A，B)＝sqrt(A×B)/(|A|×|B|)，
a, B are two character strings, axb is the same number of characters, | a | is the length of the character string a, | B | is the length of the character string B;
and D, when P (A, B) > C and C are thresholds (can be set to 0.8 in practical application), if A is consistent with the content of the node B, the step of storing the content of the current node and moving down the pointer is carried out, and the step E is carried out for processing.
If the contents of the node A and the node B do not accord with each other, the auxiliary pointer continuously points to the next node according to the forward traversal method, the WBS _ Code, the WBS _ Name, the WBS _ Left and the WBS _ Right in the current node are read, the step of calculating the similarity of the contents of the names of the nodes pointed by the two pointers is repeated, and the step is switched to the step C.
If the auxiliary pointer traverses all the descendant nodes of the third-layer node and no node with similar content is found, the content of the node pointed by the main control pointer is not associated with the corresponding WBS, the main control pointer moves to the next node, the auxiliary pointer returns to the first descendant node of the third layer, the step of repeatedly calculating the Name content similarity of the nodes pointed by the two pointers is carried out, and the step C is carried out.
And E, saving the content of the current node and moving down the pointer.
If the node Right-Left >1 in the engineering quantity list code tree and the WBS _ Right-WBS _ Left >1 of the node in the WBS identification code tree at the moment indicate that the list code pointed by the main pointer and the WBS identification code pointed by the auxiliary pointer are in a many-to-many relationship, after the system stores the nodes pointed by the current two pointers into the list code and WBS identification code coupling relationship table, the main pointer and the auxiliary pointer synchronously move to the next node.
Step E1, the temporary variable relationship is set to "Y", the association relationship is saved, the process proceeds to the association relationship saving step, and the process proceeds to step H.
And E2, synchronously moving the main control pointer and the auxiliary pointer to the next node, repeating the comparison operation steps of the main control pointer and the auxiliary pointer, and turning to the step B.
Step F, if the node Right-Left in the engineering quantity list code tree is greater than 1, and the WBS _ Right-WBS _ Left of the node in the WBS identification code tree at this time is 1, it indicates that the node in the engineering quantity list code tree is a non-leaf node, the WBS identification code tree node is a leaf node, that is, the list code pointed by the main control pointer and the WBS identification code pointed by the auxiliary pointer are in a many-to-one relationship, all descendant nodes of the node pointed by the main control pointer are stored in the list code and WBS identification code coupling relationship table, and therefore, the main control pointer moves, and the auxiliary pointer does not move.
Step F1 is to set the temporary variable relationship to "Y", call the stored association relationship, proceed to the step of storing the association relationship, and proceed to step H.
Step F2, calculating the total number of descendant nodes of the current node pointed by the master pointer,
total number of offspring ═ (Right-Left-1)/2;
step F3, the master pointer moves to the next Node, the auxiliary pointer is not moved, a temporary variable Node _ sum is set, the number of nodes Node _ sum is recorded as Node _ sum +1, the Code, the Name, the Left and the Right in the current Node of the master pointer are read, a temporary variable relationship is set as Y, the association relationship is called and saved, the step is shifted to the step of saving the association relationship, and the step is shifted to step H.
Processing continues with step F3 until Node _ sum is the total number of descendants. Namely: the system counts once when the main control pointer reads one tree node, and stores the data and the node content pointed by the auxiliary pointer into the list code and WBS identification code coupling relation table until the counting number is equal to the total number of the descendants, which indicates that the list codes corresponding to the node pointed by the auxiliary pointer are traversed.
And step F4, synchronously moving the main control pointer and the auxiliary pointer to the next node, repeating the comparison operation steps of the main control pointer and the auxiliary pointer, and turning to the step B.
And G, if the node Right-Left in the engineering quantity list code tree is equal to 1, and the WBS _ Right-WBS _ Left >1 of the node in the WBS identification code tree at the moment indicates that the node of the list code tree is a leaf node and the node of the WBS identification code tree is a non-leaf node. That is, the list Code pointed by the main pointer and the WBS id pointed by the auxiliary pointer are in a one-to-many relationship, a piece of data according to the node pointed by the main pointer is stored in the list Code and WBS id coupled relationship table, and the corresponding WBS id field is a character string composed of WBS _ Code fields of all descendant nodes of the node pointed by the auxiliary pointer, so that the main pointer is not moved and the auxiliary pointer is moved.
And G1, calculating the total number of descendant nodes of the current node pointed by the auxiliary control pointer to determine the moving directions of the main control pointer and the auxiliary pointer.
The total number of descendants is (WBS _ Right-WBS _ Left-1)/2, and the temporary variable relationship is set to "N".
Step G2, the main control pointer is not moved, the auxiliary pointer is moved to the next Node, a temporary variable Node _ sum is set, the Node number Node _ sum +1 is recorded, the WBS _ Code and WBS _ Name in the current Node of the auxiliary pointer are read,
setting a temporary variable Temp _ Code ═ Temp _ Code + WBS _ Code;
until Node _ sum is the total number of descendants. And counting once by the system through reading one tree node by the auxiliary pointer until the system counting times is equal to the total number of the descendants, which indicates that the plurality of WBS identification codes corresponding to the node pointed by the main pointer are traversed.
Step G3, setting WBS _ Code of the node pointed by the auxiliary pointer to Temp _ Code; calling and storing the association relationship, and turning to the step of storing the association relationship;
574) and (4) synchronously moving the main control pointer and the auxiliary pointer to the next node, repeating the comparison operation steps of the main control pointer and the auxiliary pointer, and turning to the step B.
And H, storing the association relation.
Determining whether the first two digits of the WBS _ Code in the current pointer in the WBS identification Code tree are construction project cost, installation project cost or equipment purchase cost, and storing the Code, the Name and the relationship content of the node pointed by the main control pointer into a relationship table.
The Tree-form table structure is designed by constructing the list coding Tree and the WBS identification code Tree, and adopting the left and right value coding based on the traversal of the Tree's predecessor, so that the recursion phenomenon is avoided when the trees are searched, the searching and comparing efficiency of the two trees is improved, and particularly when the scale of the list coding and the WBS identification code data is large, the searching speed of the Tree-form searching method is more efficient. The establishment of the corresponding relation table of the list code and the WBS identification code is that after project budget, for construction project cost, installation project cost, dismantling project cost, equipment purchase cost, other cost and the like, when ERP submits purchase application, a WBS directory can be directly and accurately found according to the list project code, WBS structures in an ERP system are simplified, system redundancy is reduced, and working efficiency is improved.
As shown in fig. 2, a system of a coupling method of engineering quantity inventory information and WBS information for grid technical improvement and major repair engineering is further provided, which includes an establishing module 1 of a WBS identification code tree structure, an establishing module 2 of an engineering quantity inventory coding tree structure, and an engineering quantity inventory information and WBS information coupling module 3, where an output end of the establishing module 1 of the WBS identification code tree structure and an output end of the establishing module 2 of the engineering quantity inventory coding tree structure are both connected to an input end of the WBS information coupling module 3. The building module 1 of the WBS identification code tree structure is used for building the WBS identification code tree structure and sending the WBS identification code tree structure to the WBS information coupling module 3, the building module 2 of the engineering quantity list coding tree structure is used for building the engineering quantity list coding tree structure and sending the engineering quantity list coding tree structure to the WBS information coupling module 3, and the WBS information coupling module 3 is used for correspondingly associating the WBS identification code tree structure with the engineering quantity list coding tree structure.
The foregoing shows and describes the general principles, essential features, and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are merely illustrative of the principles of the invention, but that various changes and modifications may be made without departing from the spirit and scope of the invention, which fall within the scope of the invention as claimed. The scope of the invention is defined by the appended claims and equivalents thereof.
Claims (2)
1. A project amount list information and WBS information coupling method for power grid technical improvement and major repair projects is characterized by comprising the following steps:
11) establishing a WBS identification code tree structure, setting a WBS identification code format, establishing a WBS data dictionary of the WBS identification code, and establishing the WBS identification code tree structure according to the WBS data dictionary; the establishment of the WBS identification code tree structure comprises the following steps:
21) setting the format of WBS identification code, setting the number of identification code to be 8 bits, and setting the format as:
identification code category + identification code major category + identification code middle category + identification code minor category + sequence code,
the identification code type is located at the first position of the identification code number and is a power transformation technical modification major repair type, a power transmission line technical modification major repair type, a converter station technical modification major repair type, a distribution network technical modification major repair type or a secondary system technical modification major repair;
the identification code is the 2 nd digit of the identification code, which is the construction project cost, the installation project cost or the equipment purchase cost;
the class in the identification code is the 3 rd bit of the identification code number, the subclass of the identification code is the 4 th bit of the identification code number, and the 5 th to 8 th bits of the identification code number are sequential codes;
22) acquiring WBS identification code data, wherein the input content of the WBS identification code data comprises data described by layers, WBS identification codes and identification codes, and a WBS data dictionary is obtained after the data acquisition is finished;
23) constructing a WBS identification code architecture in a tree structure according to the WBS data dictionary, and displaying the WBS identification code architecture in a layered mode to form a WBS identification code tree structure;
the WBS identity tree structure is set as follows:
setting each identification code category as a Tree, setting the Tree root nodes as the identification code categories, layering the Tree levels according to the categories, designing a Tree form table structure by adopting left and right value coding based on the traversal of the Tree's front sequence,
its Tree table structure is represented as: { WBS _ Node _ id, WBS _ Code, WBS _ Name, WBS _ Left, WBS _ Right },
wherein: WBS _ Node _ id is WBS identification Code tree Node number, WBS _ Code is WBS identification Code, WBS _ Name is WBS element description, WBS _ Left is WBS identification Code tree Node Left value, and WBS _ Right is WBS identification Code tree Node Right value;
12) establishing an engineering quantity list coding tree structure, acquiring list project codes of a power grid technical improvement major repair project, analyzing and constructing the engineering quantity list coding tree structure; the establishment of the engineering quantity list coding tree structure comprises the following steps:
31) acquiring a list project division definition table of a power grid technical improvement major repair project;
32) acquiring a list item code in a list item division definition table, constructing a list item code framework in a tree structure according to the list item code, and displaying the list item code framework in a layered mode;
the manifest item encoding architecture is set as follows:
each list classification code is a tree, the tree root node is a list classification code, corresponding to the first two bits of the item code, the tree hierarchy is divided and layered according to the items, and a layer of large class code is added on the second layer;
the tree structure of the engineering quantity list code is set as follows: setting each list classification code as a Tree, setting the root node as the list classification code, dividing the Tree hierarchy into layers according to the items, designing the Tree form table structure by using left and right value coding based on the Tree's preorder traversal,
the Tree Table structure is represented as: { Node _ id, Code, Name, Left, Right },
wherein: node _ id is the Node number of the coding tree of the engineering quantity list, Code is the list coding, Name is the description of the list coding, Left is the Left value of the coding tree of the engineering quantity list, and Right is the Right value of the coding tree of the engineering quantity list;
13) coupling the engineering quantity list information with WBS information, and correspondingly associating the WBS identification code tree structure with the engineering quantity list coding tree structure; the coupling of the project amount list information and the WBS information comprises the following steps:
131) establishing a relation table for storing the corresponding relation between the inventory code and the WBS identification code according to the inventory classification code in the engineering quantity inventory code architecture, wherein the attributes of the relation table comprise the inventory code, the inventory name, the WBS identification code corresponding to the construction engineering, the WBS identification code corresponding to the installation engineering, the WBS identification code corresponding to the equipment purchase and whether the corresponding judgment is carried out;
132) creating a main control pointer and an auxiliary pointer according to the designated engineering category, wherein the main control pointer points to an engineering quantity list coding tree in an engineering quantity list coding structure, the root node of the tree is read, the auxiliary pointer points to a WBS identification code tree of the WBS identification code structure, and the root node of the tree is read;
133) sequentially and respectively traversing the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer according to a forward traversal method;
the method for sequentially and respectively traversing the engineering quantity list coding tree and the WBS identification code tree through the main control pointer and the auxiliary pointer according to the precedence traversal method comprises the following steps:
41) the main control pointer and the auxiliary pointer point to the second layer at the same time to start traversing;
42) the main control pointer and the auxiliary pointer are compared,
reading Code, Name, Left and Right in the node when the main control pointer points to an engineering quantity list coding tree node, synchronously pointing the auxiliary pointer to the tree node of the same layer of the WBS identification Code tree, and reading WBS _ Code, WBS _ Name, WBS _ Left and WBS _ Right in the tree node;
43) calculating the similarity of the Name contents of the nodes pointed by the two pointers,
the method for calculating the Name contents of the two nodes by adopting the cosine similarity comprises the following calculation formula:
P(A，B)=sqrt(A×B)/(|A|×|B|)，
a, B are two character strings, axb is the same number of characters, | a | is the length of the character string a, | B | is the length of the character string B;
44) when P (A, B) > C and C are thresholds, the content of the A and the content of the B node are consistent, and the steps of storing the content of the current node and moving down the pointer are carried out;
if the contents of the node A and the node B do not accord with each other, the auxiliary pointer continuously points to the next node according to the forward traversal method, the WBS _ Code, the WBS _ Name, the WBS _ Left and the WBS _ Right in the current node are read, and the step of repeatedly calculating the similarity of the Name contents of the nodes pointed by the two pointers is carried out;
if the auxiliary pointer traverses all the descendant nodes of the third layer of nodes and does not find a node with similar content, the content of the node pointed by the main control pointer is not associated with a corresponding WBS (work breakdown site), the main control pointer moves to the next node, the auxiliary pointer returns to the first descendant node of the third layer, and the step of repeatedly calculating the similarity of the Name content of the nodes pointed by the two pointers is carried out;
45) the current node contents are saved and the pointer is moved down,
if the node Right-Left >1 in the engineering quantity list code tree and the WBS _ Right-WBS _ Left >1 of the node in the WBS identification code tree at the moment;
451) setting a temporary variable relationship = 'Y', calling and saving the association relationship, and turning to a step of saving the association relationship;
452) synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
46) if the node Right-Left >1 in the engineering quantity list code tree and the WBS _ Right-WBS _ Left =1 in the node of the WBS identification code tree at the moment, the node of the engineering quantity list code tree is a non-leaf node, and the node of the WBS identification code tree is a leaf node;
461) setting a temporary variable relationship = 'Y', calling and saving the association relationship, and turning to a step of saving the association relationship;
462) the total number of descendant nodes of the current node pointed by the master pointer is calculated,
total number of descendants = (Right-Left-1)/2;
463) the main control pointer moves to the next Node, the auxiliary pointer is not moved, a temporary variable Node _ sum is set, the number of nodes Node _ sum = Node _ sum +1 is recorded, the Code, the Name, the Left and the Right in the current Node of the main control pointer are read, the temporary variable relationship = Y is set, the association relationship is called and saved, and the step of saving the association relationship is carried out;
until Node _ sum = total number of descendants;
464) synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
47) if the node Right-Left =1 in the engineering quantity list code tree and the node WBS _ Right-WBS _ Left >1 in the WBS id tree at this time indicates that the node of the list code tree is a leaf node, the node of the WBS id tree is a non-leaf node,
471) and (3) calculating the total number of descendants of the current node pointed by the auxiliary pointer:
total number of descendants = (WBS _ Right-WBS _ Left-1)/2, set temporary variable relationship = "N";
472) the main control pointer is not moved, the auxiliary pointer moves to the next Node, a temporary variable Node _ sum is set, the number of nodes Node _ sum = Node _ sum +1 is recorded, WBS _ Code and WBS _ Name in the current Node of the auxiliary pointer are read,
setting a temporary variable Temp _ Code = Temp _ Code + WBS _ Code;
until Node _ sum = total number of descendants;
473) setting WBS _ Code = Temp _ Code of the node pointed by the auxiliary pointer; calling and storing the association relationship, and turning to the step of storing the association relationship;
474) synchronously moving the main control pointer and the auxiliary pointer to the next node, and repeating the comparison operation steps of the main control pointer and the auxiliary pointer;
48) the association relationship is saved and the user can use the association relationship,
determining whether the first two digits of the WBS _ Code in the current pointer in the WBS identification Code tree are construction project cost, installation project cost or equipment purchase cost, and storing the Code, the Name and the relationship content of the node pointed by the main control pointer into a relationship table.
2. The system of the coupling method of the project amount list information and the WBS information for the electric network technical improvement and overhaul project according to claim 1, wherein the coupling method comprises the following steps:
the WBS identification code tree structure building method comprises a WBS identification code tree structure building module (1), an engineering quantity list coding tree structure building module (2) and an engineering quantity list information and WBS information coupling module (3), wherein the WBS identification code tree structure building module (1) is used for building a WBS identification code tree structure and sending the WBS identification code tree structure to the engineering quantity list information and WBS information coupling module (3), the engineering quantity list coding tree structure building module (2) is used for building an engineering quantity list coding tree structure and sending the engineering quantity list information and WBS information coupling module (3), and the engineering quantity list information and WBS information coupling module (3) is used for correspondingly associating the WBS identification code tree structure with the engineering quantity list coding tree structure.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711190632.9A CN107818427B (en) | 2017-11-24 | 2017-11-24 | Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711190632.9A CN107818427B (en) | 2017-11-24 | 2017-11-24 | Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107818427A CN107818427A (en) | 2018-03-20 |
| CN107818427B true CN107818427B (en) | 2020-06-05 |
Family
ID=61609929
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711190632.9A Expired - Fee Related CN107818427B (en) | 2017-11-24 | 2017-11-24 | Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107818427B (en) |
Families Citing this family (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109245980B (en) * | 2018-11-20 | 2021-08-06 | 厦门科灿信息技术有限公司 | Modbus communication protocol analysis method, system, equipment and storage medium |
| CN109766381A (en) * | 2018-12-29 | 2019-05-17 | 福建华闽通达信息技术有限公司 | A kind of method that assessment of project data are quoted automatically |
| CN109783492A (en) * | 2018-12-29 | 2019-05-21 | 福建华闽通达信息技术有限公司 | A kind of data referencing divided based on WBS and the method and apparatus summarized |
| CN109784843A (en) * | 2018-12-29 | 2019-05-21 | 福建华闽通达信息技术有限公司 | A kind of building cost management method and system based on WBS |
| CN111415133A (en) * | 2020-03-18 | 2020-07-14 | 成都智造天下科技有限公司 | Shield project cost and benefit monitoring system |
| CN112258075A (en) * | 2020-11-02 | 2021-01-22 | 杭州新中大科技股份有限公司 | Data processing method for project progress and yield value linkage |
| CN112465477B (en) * | 2020-12-17 | 2023-08-04 | 中国航空工业集团公司成都飞机设计研究所 | Project plan authority control method based on classification |
| CN112685804B (en) * | 2020-12-25 | 2022-02-01 | 四川省交通勘察设计研究院有限公司 | Highway engineering design information-based WBS automatic construction method and system |
| CN113269530B (en) * | 2021-06-02 | 2023-12-22 | 陈丰 | Method, device and equipment for reversely generating WBS structure and summarizing engineering cost |
| CN113343338B (en) * | 2021-06-08 | 2022-02-18 | 四川省交通勘察设计研究院有限公司 | Method and system for associating work breakdown structure and BIM (building information modeling) component in traffic field |
| CN113886433A (en) * | 2021-10-01 | 2022-01-04 | 浙江大学 | Hierarchical structure area retrieval method |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1885325A (en) * | 2005-06-23 | 2006-12-27 | 国际商业机器公司 | Work breakdown structure design manager, design tool and method thereof |
| CN102955982A (en) * | 2011-08-18 | 2013-03-06 | 大连博特软件科技有限公司 | System for managing construction project contracting |
| CN104112174A (en) * | 2013-04-17 | 2014-10-22 | 中广核工程有限公司 | Project regulating and controlling method and system of nuclear power plant |
| CN103440364B (en) * | 2013-07-31 | 2016-04-06 | 广联达软件股份有限公司 | Based on the method and system of BIM auto-building model WBS node |
| CN105590173A (en) * | 2015-12-29 | 2016-05-18 | 国网浙江省电力公司 | Association relation modeling method between power grid main network device and productive material |
-
2017
- 2017-11-24 CN CN201711190632.9A patent/CN107818427B/en not_active Expired - Fee Related
Also Published As
| Publication number | Publication date |
|---|---|
| CN107818427A (en) | 2018-03-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107818427B (en) | Engineering quantity list information and WBS information coupling method and system for power grid technical improvement and major repair engineering | |
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN112732924A (en) | Power grid data asset management system and method based on knowledge graph | |
| CN112132327A (en) | Multi-source data fusion-oriented intelligent planning system for power distribution network | |
| CN101930481B (en) | Method used for generating CIM model describing power grid change in designated time slot and system thereof | |
| CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
| CN108876154B (en) | Power grid planning big data analysis system | |
| CN110188972B (en) | 10kV power distribution network non-private line customer access method | |
| CN107392748A (en) | A kind of income index based on dimension map matching is efficiently entered an item of expenditure in the accounts system and method | |
| CN103606032B (en) | A kind of method in two dimension power grid GIS data set | |
| CN109064126B (en) | Hydropower engineering metering information management method based on quality driving | |
| CN108280599B (en) | Agricultural distribution network input-output evaluation method based on public service value model | |
| CN104881739B (en) | Data consistency verification method is matched somebody with somebody by a kind of battalion based on IEC61970/61968 CIM standards | |
| CN109447466A (en) | Overall process visual management and control system based on power distribution network communication network construction | |
| CN106503811A (en) | A kind of infrastructure full life cycle management method based on big data | |
| CN107871169A (en) | A kind of bill of quantities using Multiway Tree Structure encodes automatic generation method | |
| CN110688619A (en) | Theoretical line loss calculation system and method for power distribution network | |
| Luo et al. | Research on transmission and transformation engineering cost system based on BIM 3D modelling technology | |
| Zheng | Evaluation model of ecological economic benefits based on discrete mathematical algorithm | |
| CN114818632B (en) | Method and device for compiling power limit sequence table for super-planning | |
| CN110674235A (en) | Marketing and distribution topology file synchronous management system and method | |
| CN113807573A (en) | Construction prediction analysis method and system based on data management and three-dimensional search | |
| CN112183823A (en) | Electric energy metering device model selection method and system based on rule tree | |
| CN114493088A (en) | Information model construction method for electric power internet of things terminal equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20200605 |