阅读说明：本技术 基于导入Excel与三维模型互补的变电站工程方法 (Transformer substation engineering method based on import Excel and three-dimensional model complementation ) 是由 焦红 李云伟 张旭超 朱英魁 陈红 张帅 于 2020-07-03 设计创作，主要内容包括：本发明涉及一种基于导入Excel与三维模型互补的变电站工程方法,属于变电站工程技术领域。其特征在于该方法包含如下步骤：A)、区分模块：按照业务特性以及设计提资情况,做区分步骤；B)、导入Excel清册表格：检索Excel表格中页签,根据字段定位到表头行；对表格格式进行识别,将表格内容导入到系统中；C)、通过分词技术匹配物料类型：系统检索物料名称,通过关键字匹配到给定的物料分类中；D)、根据识别规则提取物料属性信息：根据物料分类以及用户的梯子表格穷举出属性识别规则的提取方法,并且在后续导入的Excel物料识别中应用；E)、定额、清单、项目划分关联：根据具体属性规则套取定额、清单、关联项目划分。(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.)

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.

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.

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.