CN111797625A - Transformer substation engineering method based on import Excel and three-dimensional model complementation - Google Patents
Transformer substation engineering method based on import Excel and three-dimensional model complementation Download PDFInfo
- Publication number
- CN111797625A CN111797625A CN202010630577.6A CN202010630577A CN111797625A CN 111797625 A CN111797625 A CN 111797625A CN 202010630577 A CN202010630577 A CN 202010630577A CN 111797625 A CN111797625 A CN 111797625A
- Authority
- CN
- China
- Prior art keywords
- excel
- list
- dimensional model
- identification
- method based
- 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
- 238000012407 engineering method Methods 0.000 title claims abstract description 9
- 230000008676 import Effects 0.000 title claims abstract description 9
- 239000000463 material Substances 0.000 claims abstract description 54
- 238000000034 method Methods 0.000 claims abstract description 11
- 238000005516 engineering process Methods 0.000 claims abstract description 9
- 230000011218 segmentation Effects 0.000 claims abstract description 9
- 238000013461 design Methods 0.000 claims abstract description 7
- 238000000605 extraction Methods 0.000 claims abstract description 4
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/289—Phrasal analysis, e.g. finite state techniques or chunking
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Tourism & Hospitality (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Data Mining & Analysis (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a substation engineering method based on import Excel and three-dimensional model complementation, and belongs to the technical field of substation engineering. The method is characterized by comprising the following steps: A) and a distinguishing module: according to the service characteristics and the design investment condition, a distinguishing step is carried out; B) importing an Excel inventory form: searching a tab in the Excel table, and positioning a table header line according to the field; identifying the form format and importing the form content into the system; C) matching material types through a word segmentation technology: the system searches the material name and matches the material name with the given material classification through keywords; D) extracting material attribute information according to the identification rule: an extraction method of attribute identification rules is enumerated according to material classification and a ladder form of a user, and the method is applied to subsequently imported Excel material identification; E) quotum, list and item division association: and collecting quota, list and associated item division according to specific attribute rules.
Description
Technical Field
The invention relates to a substation engineering method based on import Excel and three-dimensional model complementation, and belongs to the technical field of substation engineering.
Background
Since the three-dimensional design has just begun, it may take some time to reach the maturity stage. At present, the whole manufacturing cost cannot be completed according to the three-dimensional model. For the realization of the part, the model is taken as a main part, and the Excel inventory is assisted to realize automatic manufacturing cost.
Introduction to the prior art
At present, if a part drawn by a three-dimensional model can be automatically generated directly through the three-dimensional model, other parts which are not modeled still need technicians to manually identify the calculated amount of the drawing according to the calculation specification through drawing and information of a filing and inventory, and the quota needs to be manually collected according to information such as quota description and the like.
However, due to the mode, technicians invest a great deal of effort to judge quota and material selection, and under the background that the construction task of the power grid engineering project is heavy and time is tight, sufficient time is difficult to guarantee to check the quality of budget estimate compilation, so that the development process of the power grid engineering project design work towards high efficiency, lean and standardization is restricted to a certain extent.
Disadvantages of the prior art
Problems with current handling mechanisms:
1. the manual resource input needs a great deal of time and is easy to make mistakes;
2. the conditions of selection error or omission and the like are easy to occur in the process of manually applying the quota and the attribution list.
Disclosure of Invention
The invention provides a transformer substation engineering method based on import Excel and three-dimensional model complementation;
the invention aims to realize the intelligent construction cost of the transformer substation engineering by introducing a three-dimensional model as a main mode and assisting Excel inventory introduction, thereby improving the efficiency and quality of manual compilation of technicians.
The main technical problem who solves has:
1) classifying similar or similar materials through a word segmentation technology;
2) associating the item name, the item characteristics and the work content column in the user Excel table to realize the mounting of related content on the same list;
3) analyzing material attributes, and extracting identification rules; the material corresponds to quota, list and attribution project division rules.
In order to achieve the purpose, the invention adopts the following technical scheme:
a transformer substation engineering method based on import Excel and three-dimensional model complementation comprises the following steps:
A) and a distinguishing module: according to the service characteristics and the design investment condition, a distinguishing step is carried out;
B) importing an Excel inventory form: searching a tab in the Excel table, and positioning a table header line according to the field; identifying the form format and importing the form content into the system;
C) matching material types through a word segmentation technology: the system searches the material name and matches the material name with the given material classification through keywords;
D) extracting material attribute information according to the identification rule: an extraction method of attribute identification rules is enumerated according to material classification and a ladder form of a user, and the method is applied to subsequently imported Excel material identification;
E) quotum, list and item division association: and collecting quota, list and associated item division according to specific attribute rules.
Further, in the step C), the materials are classified as follows: and (5) sorting the material keywords and classifying the material keywords.
The main points of the invention are summarized as follows: classifying the same similar or similar materials by a word segmentation technology according to a material inventory in an Excel format; and (4) sorting the attributes of the type of materials and extracting a method how to identify the type of materials to form a rule, and matching the rule with quota, list, item division and the like. The purpose of intelligent cost is achieved.
The invention has the beneficial effects that:
the method classifies similar or similar materials by a word segmentation technology; associating the item name, the item characteristics and the work content column in the user Excel table to realize the mounting of related content on the same list; extracting material attribute information according to the identification rule, and collecting quota, list and associated item division according to specific attributes.
The invention achieves the purpose of outputting the result quickly and accurately, improves the efficiency of manual programming and avoids manual omission and errors.
Drawings
FIG. 1 is a flow chart of the method of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
As shown in the flowchart of fig. 1, a substation engineering method based on import of Excel and complementation of a three-dimensional model includes the following steps:
A) and a distinguishing module: according to the service characteristics and the design investment condition, a distinguishing step is carried out;
B) importing an Excel inventory form: searching a tab in the Excel table, and positioning a table header line according to the field; identifying the form format and importing the form content into the system;
C) matching material types through a word segmentation technology: the system searches the material name and matches the material name with the given material classification through keywords;
D) extracting material attribute information according to the identification rule: an extraction method of attribute identification rules is enumerated according to material classification and a ladder form of a user, and the method is applied to subsequently imported Excel material identification;
E) quotum, list and item division association: and collecting quota, list and associated item division according to specific attribute rules.
Further, in the step C), the materials are classified as follows: and (5) sorting the material keywords and classifying the material keywords.
The implementation technical effect is that the three-dimensional model information is mainly imported and the Excel inventory is taken as an auxiliary, so that the comprehensive input of the cost information is realized, technical staff are helped to quickly finish the cost compilation, and the cost compilation quality and efficiency are improved.
The invention is different from the improvement of the prior art, effectively covers the information required by the manufacturing cost, and does not realize the input of materials and the matching of quota, list and item division in a manual supplement mode. Compared with the prior art, the invention not only improves the accuracy, but also improves the programming efficiency.
Summary of the invention
Classifying the same similar or similar materials by a word segmentation technology according to a material inventory in an Excel format; and (4) sorting the attributes of the type of materials and extracting a method how to identify the type of materials to form a rule, and matching the rule with quota, list, item division and the like. The purpose of intelligent cost is achieved.
System architecture or scenario of applications
The system realizes the flow: according to the service characteristics, the Excel list is divided into a secondary cable list, an electrical primary list, an electrical secondary list and a small installation list.
And each module is used for matching material types through introducing an Excel inventory form and a word segmentation technology, extracting material attribute information according to an identification rule and collecting quota, list and associated item division according to specific attributes.
The above-described embodiments are merely illustrative of the preferred embodiments of the present invention and do not limit the spirit and scope of the present invention. Various modifications and improvements of the technical solutions of the present invention may be made by those skilled in the art without departing from the design concept of the present invention, and the technical contents of the present invention are all described in the claims.
Claims (2)
1. A transformer substation engineering method based on import Excel and three-dimensional model complementation is characterized by comprising the following steps:
A) and a distinguishing module: according to the service characteristics and the design investment condition, a distinguishing step is carried out;
B) importing an Excel inventory form: searching a tab in the Excel table, and positioning a table header line according to the field; identifying the form format and importing the form content into the system;
C) matching material types through a word segmentation technology: the system searches the material name and matches the material name with the given material classification through keywords;
D) extracting material attribute information according to the identification rule: an extraction method of attribute identification rules is enumerated according to material classification and a ladder form of a user, and the method is applied to subsequently imported Excel material identification;
E) quotum, list and item division association: and collecting quota, list and associated item division according to specific attribute rules.
2. The substation engineering method based on import Excel and three-dimensional model complementation according to claim 1, characterized in that: in step C), the materials are classified as: and (5) sorting the material keywords and classifying the material keywords.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630577.6A CN111797625A (en) | 2020-07-03 | 2020-07-03 | Transformer substation engineering method based on import Excel and three-dimensional model complementation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010630577.6A CN111797625A (en) | 2020-07-03 | 2020-07-03 | Transformer substation engineering method based on import Excel and three-dimensional model complementation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111797625A true CN111797625A (en) | 2020-10-20 |
Family
ID=72810151
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010630577.6A Pending CN111797625A (en) | 2020-07-03 | 2020-07-03 | Transformer substation engineering method based on import Excel and three-dimensional model complementation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111797625A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112329178A (en) * | 2020-11-26 | 2021-02-05 | 国网河北省电力有限公司经济技术研究院 | Method and device for establishing three-dimensional construction cost model of angle steel tower and terminal equipment |
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080010237A1 (en) * | 2006-07-06 | 2008-01-10 | American Express Travel Related Services Company, Inc. | System and Method for Managing Multi-Dimensional Data |
| CN107391110A (en) * | 2017-06-22 | 2017-11-24 | 国家电网公司 | Distribution network engineering designs technical economy integrated software design method |
| CN111026718A (en) * | 2019-12-11 | 2020-04-17 | 广州地铁集团有限公司 | Technical method for analyzing excel file of rail transit engineering cost achievement |
-
2020
- 2020-07-03 CN CN202010630577.6A patent/CN111797625A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080010237A1 (en) * | 2006-07-06 | 2008-01-10 | American Express Travel Related Services Company, Inc. | System and Method for Managing Multi-Dimensional Data |
| CN107391110A (en) * | 2017-06-22 | 2017-11-24 | 国家电网公司 | Distribution network engineering designs technical economy integrated software design method |
| CN111026718A (en) * | 2019-12-11 | 2020-04-17 | 广州地铁集团有限公司 | Technical method for analyzing excel file of rail transit engineering cost achievement |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112329178A (en) * | 2020-11-26 | 2021-02-05 | 国网河北省电力有限公司经济技术研究院 | Method and device for establishing three-dimensional construction cost model of angle steel tower and terminal equipment |
| CN113268966A (en) * | 2021-06-11 | 2021-08-17 | 中国中元国际工程有限公司 | Automatic generation method for cable inventory of automatic control system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108256074B (en) | Verification processing method and device, electronic equipment and storage medium | |
| CN110599131B (en) | Electric drawing identification and examination method and device and readable storage medium | |
| CN109446689A (en) | DC converter station electrical secondary system drawing recognition methods and system | |
| CN111260413A (en) | Vector graph-based rapid calculation method for construction cost of power main network engineering | |
| CN111797625A (en) | Transformer substation engineering method based on import Excel and three-dimensional model complementation | |
| CN112163553B (en) | Material price accounting method, device, storage medium and computer equipment | |
| CN109766416A (en) | A kind of new energy policy information abstracting method and system | |
| CN103268362A (en) | Auxiliary design method of virtual terminals on basis of general template and key character matching | |
| CN115630621A (en) | PDF financial data report form-based data acquisition and processing method and system | |
| CN115329556A (en) | Transformer substation CAD drawing auditing method and device | |
| CN112396437A (en) | Trade contract verification method and device based on knowledge graph | |
| CN109086985B (en) | Professional test information management system for spacecraft assembly | |
| CN110851577A (en) | Knowledge graph expansion method and device in electric power field | |
| CN117216214A (en) | Question and answer extraction generation method, device, equipment and medium | |
| CN115688729A (en) | Power transmission and transformation project cost data integrated management system and method thereof | |
| CN110765986A (en) | Method for automatically auditing monitoring signals of main station of power system | |
| CN110515926A (en) | Heterogeneous data source mass data carding method based on participle and semantic dependency analysis | |
| CN106649599A (en) | Knowledge service oriented scientific research data processing and predictive analysis platform | |
| CN106055684A (en) | SCD file comparison method of transformer substation | |
| CN115171136A (en) | Method, equipment and storage medium for classifying and identifying content of banking business material | |
| CN113918726A (en) | Retrieval method and system for fault knowledge of electric power main transformer equipment | |
| CN111680985A (en) | Method for realizing automatic attribution installation subentry engineering based on system code and equipment code | |
| CN112612841A (en) | Knowledge extraction construction method, device, equipment and storage medium | |
| CN107341603B (en) | Character matching-based multi-source power transmission line ledger correspondence checking device and method | |
| CN113760913B (en) | Elasticity-extensible equipment cost acquisition method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20201020 |