Method and system for automatically generating material inventory of power grid production technical improvement project

Abstract

The invention relates to a method and system for automatically generating a material inventory of a power grid production technical improvement project, and the method comprises the steps: obtaining and integrating material key data of different sources of the power grid production technical improvement project, and mapping the material key data to a constructed demand standard library; performing standard review and check on the mapped demand standard library to obtain a checked demand standard library; matching the checked demand standard library into a corresponding batch; and generating a material inventory of the power grid production technical improvement project according to a batch matching result and the checked demand standard library. Compared with the prior art, the device has the advantages of automation, high efficiency and the like.

Description

Technical Field

[0001] The present invention relates to the field of material data technology, and in particular to a method and system for automatically generating a material list for a power grid production technical transformation project. Background Art

[0002] In current power grid production and technical transformation projects, project cost documents play a crucial role. They not only determine the project budget and cost control, but also directly impact the efficiency and quality of project implementation. This is particularly true when it comes to material selection: every item listed in the cost documents is closely linked to the actual project performance. However, traditional material review methods rely heavily on manual review by experts. This process is not only time-consuming and labor-intensive, but also susceptible to human error, making it difficult to ensure the accuracy and efficiency of the review results.

[0003] With the rapid development of the power industry and the increasing demands of management departments for optimal material selection, power grid production technical transformation projects are placing higher demands on material management. Furthermore, the strengthening of post-assessment quality evaluation mechanisms has led to stricter scrutiny of the accuracy and rationality of material selection. Against this backdrop, traditional material management methods are no longer able to meet the needs of current power grid production technical transformation projects.

[0004] Therefore, it is imperative to conduct a comprehensive review of existing materials for power grid production technical transformation projects. This comprehensive review will allow for automatic adjustment and optimization of material inventories as project requirements, market conditions, and technological advancements change. This will improve the accuracy and efficiency of material selection, reduce project costs, and enhance overall implementation effectiveness. This will also provide management with more accurate data support, enabling them to make more scientific and reasonable decisions. Summary of the Invention

[0005] The purpose of the present invention is to provide a method and system for automatically generating a material list for a power grid production technical transformation project, which improves the efficiency of generating the material list.

[0006] The purpose of the present invention can be achieved by the following technical solutions:

[0007] A method for automatically generating a material list for a power grid production technical transformation project comprises the following steps:

[0008] Acquire and integrate key material data from different sources for power grid production technical transformation projects, and map the key material data to the established demand standard library;

[0009] Conduct specification review and verification on the mapped demand standard library to obtain the verified demand standard library;

[0010] Matching the verified demand standard library to the corresponding batch;

[0011] Generate a material list for the power grid production technical transformation project based on the batch matching results and the verified demand standard library.

[0012] Furthermore, the steps of constructing the demand standard library include:

[0013] Define standard design specifications for materials and save them in a Word document. The standard design specifications for materials include material review points, policy requirements, and key material data. The key material data includes the solidification ID, material code, technical specification ID, and material status.

[0014] Set up a solidified data template;

[0015] Map the standard design specifications of materials in the Word document according to the structured format of the data template to form a demand standard library.

[0016] Furthermore, the steps of conducting specification review and verification include:

[0017] Divide the standard design specifications of materials into two categories: universal and non-universal;

[0018] For universal standard design specifications, configure conventional verification rules, wherein the conventional verification rules include field format, field length, and number size;

[0019] Conducting specification review and verification on the universal standard design specifications in the mapped demand standard library according to the conventional verification rules;

[0020] For the non-universal standard design specifications in the mapped demand standard library, a traversal method is used to review whether they comply with the preset rules, and verification is performed based on the review results.

[0021] Furthermore, the batch matching process includes:

[0022] (1) Match batch name:

[0023] Based on the verified demand standard library, a combination of "subcategory description + material voltage level + project voltage level" of the material is constructed;

[0024] The combination is matched with the preset batch rule mapping table to determine whether the match is successful. If so, the next step is executed. If not, it is considered that the material belongs to the provincial recruitment batch;

[0025] The combination is matched with the preset complete set material management table to determine whether it is a supporting material. If it is a supporting material and there is a main equipment under the same reserve project, the material is considered to belong to the State Grid batch. If it is a supporting material but there is no main equipment under the same reserve project, the material is considered to belong to the provincial recruitment batch. If it is not a supporting material, the combination is matched with the preset ID table. If the match is successful, the material is considered to belong to the digital batch. If the match is unsuccessful, the material is considered to belong to the State Grid batch.

[0026] (2) Matching time optimal batch:

[0027] Obtain the bidding time for the main equipment of the formal project milestone;

[0028] Get the deadline for each batch based on the matching results of the batch names;

[0029] The bidding time is compared with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is selected as the recommended batch.

[0030] Furthermore, the material list generation process includes:

[0031] Develop material inventory templates;

[0032] The batch matching results and the verified demand standard library are imported into the material list template according to the material code, and the material status is verified to form a material list, wherein the material status includes preferred materials and non-preferred materials.

[0033] The present invention also provides a system for automatically generating a material inventory for a power grid production technical transformation project, comprising:

[0034] Data acquisition and mapping module: used to acquire and integrate key material data from different sources of power grid production technical transformation projects, and map the key material data to the established demand standard library;

[0035] Review and verification module: used to conduct specification review and verification on the mapped demand standard library to obtain the verified demand standard library;

[0036] Batch matching module: used to match the verified demand standard library to the corresponding batch;

[0037] Material list generation module: used to generate the material list of the power grid production technical transformation project based on the batch matching results and the verified demand standard library.

[0038] Furthermore, the steps of constructing the demand standard library include:

[0039] Define standard design specifications for materials and save them in a Word document. The standard design specifications for materials include material review points, policy requirements, and key material data. The key material data includes the solidification ID, material code, technical specification ID, and material status.

[0040] Set up a solidified data template;

[0041] Map the standard design specifications of materials in the Word document according to the structured format of the data template to form a demand standard library.

[0042] Furthermore, the review and verification module includes:

[0043] Standard design specification classification unit: used to classify the standard design specifications of materials into general and non-general categories;

[0044] Conventional verification rule configuration unit: configured for configuring conventional verification rules for universal standard design specifications, wherein the conventional verification rules include field format, field length, and number size;

[0045] Universality review and verification unit: used for reviewing and verifying the universal standard design specifications in the mapped demand standard library according to the conventional verification rules;

[0046] Non-universality review and verification unit: used for reviewing whether the non-universal standard design specifications in the mapped demand standard library comply with the preset rules in a traversal manner, and verifying them according to the review results.

[0047] Furthermore, the batch matching module includes:

[0048] The batch name matching unit includes:

[0049] Combination construction subunit: used to construct the material's "subcategory description + material voltage level + project voltage level" combination based on the verified demand standard library;

[0050] Batch initial matching subunit: used to match the combination with the preset batch rule mapping table to determine whether the match is successful. If so, the next step is executed. If not, it is considered that the material belongs to the provincial recruitment batch;

[0051] Batch re-matching subunit: used to match the combination with the preset complete set material management table to determine whether it is a supporting material. If it is a supporting material and the main equipment exists under the same reserve project, the material is considered to belong to the State Grid batch. If it is a supporting material but the main equipment does not exist under the same reserve project, the material is considered to belong to the provincial recruitment batch. If it is not a supporting material, the combination is matched with the preset ID table. If the match is successful, the material is considered to belong to the digital batch. If the match is unsuccessful, the material is considered to belong to the State Grid batch.

[0052] The time-optimal batch matching unit includes:

[0053] Tender Time Acquisition Subunit: used to obtain the tender time for main equipment of the formal project milestone;

[0054] Deadline acquisition subunit: used to obtain the deadline of each batch based on the matching results of the batch name;

[0055] Time comparison subunit: used to compare the bidding time with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is used as the recommended batch.

[0056] Furthermore, the material list generation module includes:

[0057] Template development unit: used to develop material inventory templates;

[0058] Generation unit: used to import the batch matching results and the verified demand standard library into the material list template according to the material code, and verify the material status to form a material list, where the material status includes preferred materials and non-preferred materials.

[0059] Compared with the prior art, the present invention has the following beneficial effects:

[0060] (1) The present invention maps key material data to a demand standard library, performs automated model review and verification, matches corresponding batches, and finally integrates and generates a material list for the power grid production technical transformation project. The present invention reduces manual operations through automated processes, can quickly generate a material list, and improves the efficiency of material list generation.

[0061] (2) In the process of constructing the demand standard library, the present invention stores the standard design specifications of the materials in a Word document. The Word document can be used to update the standard design specifications in a rolling manner according to the actual situation, and the retrieval and viewing are simple. It is then mapped to a solidified data template, realizing the automatic update of the demand standard library, thereby realizing the automatic update of the material list to a certain extent.

[0062] (3) The present invention can automatically update the material list by updating the standard design specifications and review rules of the materials.

[0063] (4) The present invention reduces the time and cost of manual operations, reduces human errors, and improves the accuracy of material inventory generation. BRIEF DESCRIPTION OF THE DRAWINGS

[0064] Figure 1 Schematic diagram of the method of the present invention. DETAILED DESCRIPTION

[0065] The present invention is described in detail below with reference to the accompanying drawings and specific embodiments. This embodiment is implemented based on the technical solution of the present invention, and provides a detailed implementation method and specific operation process, but the protection scope of the present invention is not limited to the following embodiments.

[0066] Example 1

[0067] This embodiment provides a method for automatically generating a material list for a power grid production technical transformation project, which is used to sort out project materials and form a list, such as Figure 1 As shown, the method includes the following steps:

[0068] Step 1: Material Standards

[0069] (1) Maintenance and management of standards and specifications

[0070] Build a demand standard library that covers review points (preparation requirements), policy requirements, key material information (solidified ID, preferred materials, standard materials, frozen status), etc. as standard design specifications, providing a basis for automatic verification in subsequent preparation links.

[0071] First, the defined standard design specifications are stored in a Word document. The Word document can realize rolling updates, keyword searches, and viewing of information such as standard specifications, review points, and policy requirements, while setting a solidified data template. Secondly, the standard design specifications of the materials in the Word document are mapped according to the structured format of the data template to form a demand standard library.

[0072] (2) Integration of key material data

[0073] By adding RPA (Robotic process automation) robots, they can automatically log into the different systems involved in the power grid production technical transformation project, obtain key material data from different sources, integrate it into a unified platform, and then map it to the demand standard library constructed above.

[0074] Step 2: Review and verify

[0075] The standard requirements library automatically reviews, prompts, and controls material requirements during the design phase. It also automatically verifies, prompts, and controls equipment and material inventories during each plan submission phase. Some standard design specifications with common characteristics are now configurable. For example, common validation rules for field format, length, and numeric value can be configured. Therefore, based on these configured validation rules, the common standard design specifications in the mapped standard requirements library are reviewed and verified.

[0076] For some special standard design specifications that cannot be configured, that is, non-universal features, after the requirements are screened, the code can be used to automatically review them by traversing to see whether they comply with the preset rules, and verify them based on the review results.

[0077] Step 3: Batch matching

[0078] Project materials should be included in the corresponding batches, so batch matching is required to clearly know which batch the materials are in.

[0079] (1) Match the information contained in the batch name

[0080] From the verified demand standard library, build a "subcategory description + material voltage level + project voltage level" combination to match the "batch rule mapping table", where the "batch rule mapping table" is the bidding and procurement batch arrangement issued to ensure that materials that have passed the review can be included in the bidding and procurement batch.

[0081] If no match is found, the material is "Provincial Recruitment Batch".

[0082] If a match is found, continue matching.

[0083] Then go to the "Complete Material Management Table" to match whether it is supporting data. The "Complete Material Management Table" mainly summarizes the supporting relationships of related materials based on historical material procurement situations.

[0084] If it is a supporting material and there is a main equipment under the same reserve project, it is a "State Grid batch"; if it is a supporting material but there is no main equipment under the same reserve project, it is a "Provincial Recruitment Batch"

[0085] For non-matching materials, match the "ID table". If it matches, it is the "digital batch". If it does not match, it is the "State Grid batch".

[0086] (2) Batch with optimal matching time

[0087] Obtain the bidding time for the main equipment of the formal project milestone;

[0088] Get the deadline for each batch based on the matching results of the batch names;

[0089] The bidding time is compared with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is selected as the recommended batch.

[0090] For batches that have not gone through the ERP upload process, batches can be recommended based on the project, matching the nearest reasonable batch, and reminding the project quantity during the process stage.

[0091] Step 4: Generate material list

[0092] Develop material inventory templates;

[0093] The batch matching results and the verified demand standard library are imported into the material list template according to the material code, and the material status is verified to form a material list, wherein the material status includes preferred materials and non-preferred materials.

[0094] The material list generated according to the above steps is as follows:

[0095] Table 1 Partial material list

[0096]

[0097] Example 2

[0098] This embodiment provides a system for automatically generating a material inventory for a power grid production technical transformation project, the system comprising:

[0099] Data acquisition and mapping module: used to acquire and integrate key material data from different sources of power grid production technical transformation projects, and map the key material data to the established demand standard library;

[0100] Review and verification module: used to conduct specification review and verification on the mapped demand standard library to obtain the verified demand standard library;

[0101] Batch matching module: used to match the verified demand standard library to the corresponding batch;

[0102] Material list generation module: used to generate the material list of the power grid production technical transformation project based on the batch matching results and the verified demand standard library.

[0103] The review and verification modules include:

[0104] Standard design specification classification unit: used to classify the standard design specifications of materials into general and non-general categories;

[0105] Conventional verification rule configuration unit: configured for configuring conventional verification rules for universal standard design specifications, wherein the conventional verification rules include field format, field length, and number size;

[0106] Universality review and verification unit: used for reviewing and verifying the universal standard design specifications in the mapped demand standard library according to the conventional verification rules;

[0107] Non-universality review and verification unit: used for reviewing whether the non-universal standard design specifications in the mapped demand standard library comply with the preset rules in a traversal manner, and verifying them according to the review results.

[0108] The batch matching module includes:

[0109] The batch name matching unit includes:

[0110] Combination construction subunit: used to construct the material's "subcategory description + material voltage level + project voltage level" combination based on the verified demand standard library;

[0111] Batch initial matching subunit: used to match the combination with the preset batch rule mapping table to determine whether the match is successful. If so, the next step is executed. If not, it is considered that the material belongs to the provincial recruitment batch;

[0112] Batch re-matching subunit: used to match the combination with the preset complete set material management table to determine whether it is a supporting material. If it is a supporting material and the main equipment exists under the same reserve project, the material is considered to belong to the State Grid batch. If it is a supporting material but the main equipment does not exist under the same reserve project, the material is considered to belong to the provincial recruitment batch. If it is not a supporting material, the combination is matched with the preset ID table. If the match is successful, the material is considered to belong to the digital batch. If the match is unsuccessful, the material is considered to belong to the State Grid batch.

[0113] The time-optimal batch matching unit includes:

[0114] Tender Time Acquisition Subunit: used to obtain the tender time for main equipment of the formal project milestone;

[0115] Deadline acquisition subunit: used to obtain the deadline of each batch based on the matching results of the batch name;

[0116] Time comparison subunit: used to compare the bidding time with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is used as the recommended batch.

[0117] The material list generation module includes:

[0118] Template development unit: used to develop material inventory templates;

[0119] Generation unit: used to import the batch matching results and the verified demand standard library into the material list template according to the material code, and verify the material status to form a material list, where the material status includes preferred materials and non-preferred materials.

[0120] The rest is the same as in Example 1.

[0121] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0122] Obviously, those skilled in the art may make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if such changes and modifications fall within the scope of the claims and their equivalents, the present invention is intended to include such changes and modifications.

Claims

1. A method for automatically generating a material list for a power grid production technical transformation project, characterized in that: The following steps are involved: Acquire and integrate key material data from different sources for power grid production technical transformation projects, and map the key material data to the established demand standard library; Conduct specification review and verification on the mapped demand standard library to obtain the verified demand standard library; Matching the verified demand standard library to the corresponding batch; Generate a material list for the power grid production technical transformation project based on the batch matching results and the verified demand standard library.

2. The method for automatically generating a material list for a power grid production technical transformation project according to claim 1, characterized in that: The steps for building the required standard library include: Define standard design specifications for materials and save them in a Word document. The standard design specifications for materials include material review points, policy requirements, and key material data. The key material data includes the solidification ID, material code, technical specification ID, and material status. Set up a solidified data template; Map the standard design specifications of materials in the Word document according to the structured format of the data template to form a demand standard library.

3. The method for automatically generating a material list for a power grid production technical transformation project according to claim 1, characterized in that: The steps for conducting code review and verification include: Divide the standard design specifications of materials into two categories: universal and non-universal; For universal standard design specifications, configure conventional verification rules, wherein the conventional verification rules include field format, field length, and number size; Conducting specification review and verification on the universal standard design specifications in the mapped demand standard library according to the conventional verification rules; For the non-universal standard design specifications in the mapped demand standard library, a traversal method is used to review whether they comply with the preset rules, and verification is performed based on the review results.

4. The method for automatically generating a material list for a power grid production technical improvement project according to claim 1, characterized in that: The batch matching process includes: (1) Match batch name: Based on the verified demand standard library, a material combination of "subcategory description + material voltage level + project voltage level" is constructed; The combination is matched with the preset batch rule mapping table to determine whether the match is successful. If so, the next step is executed. If not, it is considered that the material belongs to the provincial recruitment batch; The combination is matched with the preset complete set material management table to determine whether it is a supporting material. If it is a supporting material and there is a main equipment under the same reserve project, the material is considered to belong to the State Grid batch. If it is a supporting material but there is no main equipment under the same reserve project, the material is considered to belong to the provincial recruitment batch. If it is not a supporting material, the combination is matched with the preset ID table. If the match is successful, the material is considered to belong to the digital batch. If the match is unsuccessful, the material is considered to belong to the State Grid batch. (2) Matching time optimal batch: Obtain the bidding time for the main equipment of the formal project milestone; Get the deadline for each batch based on the matching results of the batch names; The bidding time is compared with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is selected as the recommended batch.

5. The method for automatically generating a material list for a power grid production technical transformation project according to claim 1, characterized in that: The material list generation process includes: Develop material inventory templates; The batch matching results and the verified demand standard library are imported into the material list template according to the material code, and the material status is verified to form a material list, wherein the material status includes preferred materials and non-preferred materials.

6. A material inventory automatic generation system for power grid production technical transformation projects, characterized by: include: Data acquisition and mapping module: used to acquire and integrate key material data from different sources of power grid production technical transformation projects, and map the key material data to the established demand standard library; Review and verification module: used to conduct specification review and verification on the mapped demand standard library to obtain the verified demand standard library; Batch matching module: used to match the verified demand standard library to the corresponding batch; Material list generation module: used to generate the material list of the power grid production technical transformation project based on the batch matching results and the verified demand standard library.

7. The automatic material inventory generation system for a power grid production technical transformation project according to claim 6 is characterized in that: The steps for building the required standard library include: Define standard design specifications for materials and save them in a Word document. The standard design specifications for materials include material review points, policy requirements, and key material data. The key material data includes the solidification ID, material code, technical specification ID, and material status. Set up a solidified data template; Map the standard design specifications of materials in the Word document according to the structured format of the data template to form a demand standard library.

8. The automatic material inventory generation system for a power grid production technical transformation project according to claim 6 is characterized in that: The review and verification modules include: Standard design specification classification unit: used to classify the standard design specifications of materials into general and non-general categories; Conventional verification rule configuration unit: configured for configuring conventional verification rules for universal standard design specifications, wherein the conventional verification rules include field format, field length, and number size; Universality review and verification unit: used for reviewing and verifying the universal standard design specifications in the mapped demand standard library according to the conventional verification rules; Non-universality review and verification unit: used for reviewing whether the non-universal standard design specifications in the mapped demand standard library comply with the preset rules in a traversal manner, and verifying them according to the review results.

9. The automatic material inventory generation system for a power grid production technical transformation project according to claim 6 is characterized in that: The batch matching module includes: The batch name matching unit includes: Combination construction subunit: used to construct the material's "subcategory description + material voltage level + project voltage level" combination based on the verified demand standard library; Batch initial matching subunit: used to match the combination with the preset batch rule mapping table to determine whether the match is successful. If so, the next step is executed. If not, it is considered that the material belongs to the provincial recruitment batch; Batch re-matching subunit: used to match the combination with the preset complete set material management table to determine whether it is a supporting material. If it is a supporting material and the main equipment exists under the same reserve project, the material is considered to belong to the State Grid batch. If it is a supporting material but the main equipment does not exist under the same reserve project, the material is considered to belong to the provincial recruitment batch. If it is not a supporting material, the combination is matched with the preset ID table. If the match is successful, the material is considered to belong to the digital batch. If the match is unsuccessful, the material is considered to belong to the State Grid batch. The time-optimal batch matching unit includes: Tender Time Acquisition Subunit: used to obtain the tender time for main equipment of the formal project milestone; Deadline acquisition subunit: used to obtain the deadline of each batch based on the matching results of the batch name; Time comparison subunit: used to compare the bidding time with the deadline of each batch, and based on the comparison result, the batch closest to the bidding time and reasonable is used as the recommended batch.

10. The automatic material inventory generation system for a power grid production technical transformation project according to claim 6, characterized in that: The material list generation module includes: Template development unit: used to develop material inventory templates; Generation unit: used to import the batch matching results and the verified demand standard library into the material list template according to the material code, and verify the material status to form a material list, where the material status includes preferred materials and non-preferred materials.

Images