CN111275409A - Power grid overhaul audit data processing system and processing method - Google Patents
Power grid overhaul audit data processing system and processing method Download PDFInfo
- Publication number
- CN111275409A CN111275409A CN202010127559.6A CN202010127559A CN111275409A CN 111275409 A CN111275409 A CN 111275409A CN 202010127559 A CN202010127559 A CN 202010127559A CN 111275409 A CN111275409 A CN 111275409A
- Authority
- CN
- China
- Prior art keywords
- audit data
- project
- power grid
- characteristic values
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000012550 audit Methods 0.000 title claims abstract description 52
- 238000012545 processing Methods 0.000 title claims abstract description 15
- 238000003672 processing method Methods 0.000 title claims abstract description 11
- 238000006243 chemical reaction Methods 0.000 claims abstract description 14
- 238000011156 evaluation Methods 0.000 claims abstract description 12
- 238000000605 extraction Methods 0.000 claims abstract description 9
- 239000000463 material Substances 0.000 claims description 14
- 238000009434 installation Methods 0.000 claims description 6
- 230000009466 transformation Effects 0.000 claims description 4
- 230000015572 biosynthetic process Effects 0.000 claims 1
- 238000000034 method Methods 0.000 abstract description 12
- 238000007726 management method Methods 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/10—Office automation; Time 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Water Supply & Treatment (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a processing system and a processing method of power grid overhaul audit data, wherein the processing system comprises: the evaluation feature extraction module is used for acquiring a project evaluation book and extracting a feature value to be audited from the project evaluation book; the structuring module is used for performing structuring conversion on the characteristic values and storing the characteristic values; the actual value acquisition module is used for detecting and acquiring the actual value of the information system; the project quota acquisition module is used for acquiring the project quota of the power grid overhaul, performing structured conversion and storing; and the audit data output module is used for comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data. Compared with the prior art, the method has the advantages of high efficiency, comprehensive audit and the like.
Description
Technical Field
The invention relates to the technical field of automatic processing of electric power data, in particular to a power grid overhaul audit data processing system and a processing method.
Background
With the increasing development of information technology, power grid enterprises put the production, management and financial data into informationization and integration by means of various information management systems, and the control mode of the enterprises is also converted from a pure manual control mode to a system control mode. And the auditing service of the power grid overhaul project also starts to carry out computer on-line auditing by virtue of the information system.
However, in the current stage, the overhaul data of the power grid is dispersed, the information system only stores part of service data, the data required for auditing is dispersed in each information system, paper files and various electronic files, and auditors need to manually search, process and compare the dispersed data to search auditing doubt points of projects to be overhauled of the power grid, so that the efficiency is low and the error rate is high.
Disclosure of Invention
The invention aims to overcome the defects in the prior art and provide a power grid overhaul audit data processing system and a processing method which are high in efficiency and complete in audit.
The purpose of the invention can be realized by the following technical scheme:
a power grid overhaul audit data processing system comprises:
the evaluation feature extraction module is used for acquiring a project evaluation book and extracting a feature value to be audited from the project evaluation book;
the structuring module is used for performing structuring conversion on the characteristic values and storing the characteristic values;
the actual value acquisition module is used for detecting and acquiring the actual value of the information system;
the project quota acquisition module is used for acquiring the project quota of the power grid overhaul, performing structured conversion and storing;
and the audit data output module is used for comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data.
Further, the characteristic values include total investment, material acquisition, installation works, civil engineering and other cost information.
Further, the structured transformation specifically is: and converting the corresponding data into a searchable two-dimensional table.
Further, in the process of forming the two-dimensional table, the extraction of the empty row is skipped.
Further, the audit data comprises comparison data between all characteristic values, comparison data between an actual value and the characteristic value, comparison data between a project quota and the characteristic value, and comparison data between materials.
Further, the specific process of acquiring the comparison data of the project quota and the characteristic value is as follows:
the project expense name comprises a material name keyword, and a data field is extracted by compiling according to the condition that the keyword comprises a letter X; searching keywords contained in the record item cost name field, and if the quota item name and the standard field of the record also contain the searched keywords, setting the comparison result of the record overhaul content keywords as consistent; intercepting the voltage level from the item name field of the record and putting the voltage level into a custom field c1, if the rated voltage level of the record does not contain a V letter, setting the comparison result of the voltage levels to be consistent, if the rated voltage level of the record contains the V letter, intercepting the voltage level in the rated voltage level of the record and putting the voltage level into c2, inquiring whether the rated voltage level contains 'and below' or 'below', and if the rated voltage level contains 'and below', judging: if c1< ═ c2, the voltage level comparison result is set to be consistent, otherwise, the comparison result is inconsistent; if "the following" is included, then the determination is made: if c1< c2, the comparison result of the voltage levels is set as 'consistent', otherwise, the comparison result is 'inconsistent'; if neither "and the following" or "the following" are included, then it is determined: if c1 is c2, "consistent" is set, otherwise, "inconsistent".
The invention also provides a power grid overhaul audit data processing method, which comprises the following steps:
s1: acquiring a project estimation book, and extracting a characteristic value to be audited from the project estimation book;
s2: carrying out structural conversion on the characteristic values and storing the characteristic values;
s3: detecting and acquiring an actual numerical value of an information system;
s4: acquiring a project quota of the power grid overhaul, and performing structured conversion and storage;
s5: and comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data.
Compared with the prior art, the invention has the following beneficial effects:
1) the power grid overhaul estimation book is extracted as structured data to form a searchable two-dimensional table structure, and detailed corresponding relations of materials and construction are established, so that generation of follow-up audit data is facilitated, manual intervention is avoided, and efficiency is improved.
2) Data processing in different forms and different standards are integrated into a unified form and standard, and a data basis is provided for calculation of audit doubtful points.
3) The intelligent comparison according to keywords is realized, the method is not limited to typical structured data, more audit doubtful points can be found conveniently, and the working efficiency and the result are improved.
4) The invention extracts the characteristic value of the project estimation book, including the contents of total investment, material purchase, installation project, civil engineering and other cost information, has comprehensive audit data, improves the use convenience and the experience of users, and more intuitively obtains the audit result.
5) The invention designs specific judgment logic for the audit comparison process, and has high audit intellectualization and accuracy.
Drawings
FIG. 1 is a schematic flow diagram of the process of the present invention.
Detailed Description
The invention is described in detail below with reference to the figures and specific embodiments. The present embodiment is implemented on the premise of the technical solution of the present invention, and a detailed implementation manner and a specific operation process are given, but the scope of the present invention is not limited to the following embodiments.
Example 1
The embodiment provides a power grid overhaul audit data processing system which comprises an estimation feature extraction module, a structuring module, an actual value acquisition module, a project quota acquisition module and an audit data output module. The evaluation feature extraction module is used for acquiring a project evaluation book and extracting a feature value to be audited from the project evaluation book; the structuring module is used for performing structuring conversion on the characteristic values and storing the characteristic values; the actual value acquisition module is used for detecting and acquiring an actual value of the information system; the project quota acquisition module is used for acquiring the project quota of the power grid overhaul, performing structured conversion and storing; and the audit data output module is used for comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data.
And the estimation characteristic extraction module is used for converting the corresponding data into a retrievable two-dimensional table according to characteristic values extracted from the project estimation book, including total investment, material purchase, installation engineering, civil engineering, other cost information and the like.
In this embodiment, the process of extracting feature values and performing structural transformation on an item estimate book includes:
s11: and extracting the content with the page name of 'overhaul project summary table one', writing the read content into the two-dimensional table, and reading the empty row without reading. If the record of the main key already exists in the table, the piece of record content is updated, and if the page content is not extracted, the process proceeds to step S12.
S12: and when the contents in the first column are identified as capital figures such as 'one, two, three and the like', the overhaul large field contents of the current row and the subsequent row are the contents in the third column of the cell of the current row until new capital figures are met. When the first column recognizes the lower case numbers of 1, 2, 3 and the like, the content of the subclass field of the current row and the subsequent rows is examined and repaired as the content of the cell of the third column of the current row until a new lower case number is read. If the record of the main key exists in the table, the record content is updated, and if the page content is not extracted. The step S13 is executed.
S13: and extracting the content with the page name of 'A supply assembly summary table attached with table one', writing the read content into the two-dimensional table, wherein the empty row does not need to be read, if the record of the main key exists in the table, updating the record content, and if the page is not extracted, continuing to the step S14.
S14: and extracting the content with the page name of 'B supply assembly summary table attached with table two', writing the read content into the two-dimensional table, wherein the empty row does not need to be read, if the record of the main key exists in the table, updating the record content, and if the page content is not extracted. The next step is continued.
And in the audit data output module, the audit data comprises ratio data among all characteristic values, actual numerical value and characteristic value comparison data, project quota and characteristic value comparison data and material comparison data. The specific process of acquiring the comparison data of the project quota and the characteristic value is as follows:
the project expense name comprises a material name keyword, and a data field is extracted by compiling according to the condition that the keyword comprises a letter X; searching keywords contained in the record item cost name field, and if the quota item name and the standard field of the record also contain the searched keywords, setting the comparison result of the record overhaul content keywords as consistent; intercepting the voltage level from the item name field of the record and putting the voltage level into a custom field c1, if the rated voltage level of the record does not contain a V letter, setting the comparison result of the voltage levels to be consistent, if the rated voltage level of the record contains the V letter, intercepting the voltage level in the rated voltage level of the record and putting the voltage level into c2, inquiring whether the rated voltage level contains 'and below' or 'below', and if the rated voltage level contains 'and below', judging: if c1< ═ c2, the voltage level comparison result is set to be consistent, otherwise, the comparison result is inconsistent; if "the following" is included, then the determination is made: if c1< c2, the comparison result of the voltage levels is set as 'consistent', otherwise, the comparison result is 'inconsistent'; if neither "and the following" or "the following" are included, then it is determined: if c1 is c2, "consistent" is set, otherwise, "inconsistent".
Example 2
As shown in fig. 1, the present embodiment provides a method for processing audit data of power grid overhaul, including the following steps:
s1: acquiring a project estimation book, and extracting a characteristic value to be audited from the project estimation book, wherein the characteristic value comprises total investment, material purchase, installation project, civil engineering, other cost information and the like;
s2: carrying out structural conversion on the characteristic values and storing the characteristic values;
s3: detecting and acquiring an actual numerical value of an information system;
s4: acquiring a project quota of the power grid overhaul, and performing structured conversion and storage;
s5: and comparing the characteristic values, the actual values and the project quota to form audit data and outputting the audit data, wherein the audit data comprises comparison data among the characteristic values, comparison data of the actual values and the characteristic values, comparison data of the project quota and the characteristic values and comparison data of materials.
The rest is the same as example 1.
The foregoing detailed description of the preferred embodiments of the invention has been presented. It should be understood that numerous modifications and variations could be devised by those skilled in the art in light of the present teachings without departing from the inventive concepts. Therefore, the technical solutions that can be obtained by a person skilled in the art through logic analysis, reasoning or limited experiments based on the prior art according to the concept of the present invention should be within the protection scope determined by the present invention.
Claims (10)
1. A power grid overhaul audit data processing system is characterized by comprising:
the evaluation feature extraction module is used for acquiring a project evaluation book and extracting a feature value to be audited from the project evaluation book;
the structuring module is used for performing structuring conversion on the characteristic values and storing the characteristic values;
the actual value acquisition module is used for detecting and acquiring the actual value of the information system;
the project quota acquisition module is used for acquiring the project quota of the power grid overhaul, performing structured conversion and storing;
and the audit data output module is used for comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data.
2. The grid overhaul audit data processing system of claim 1 wherein the characteristic values include total investment, material procurement, installation work, civil work, and other cost information.
3. The grid overhaul audit data processing system according to claim 1 wherein the structured transformation is specifically: and converting the corresponding data into a searchable two-dimensional table.
4. The grid overhaul audit data processing system of claim 3 wherein in forming the two dimensional table, the extraction of empty rows is skipped.
5. The system of claim 1, wherein the audit data includes data of comparisons between characteristic values, data of comparisons between actual values and characteristic values, data of comparisons between project quota and characteristic values, and data of comparisons between materials.
6. A power grid overhaul audit data processing method is characterized by comprising the following steps:
s1: acquiring a project estimation book, and extracting a characteristic value to be audited from the project estimation book;
s2: carrying out structural conversion on the characteristic values and storing the characteristic values;
s3: detecting and acquiring an actual numerical value of an information system;
s4: acquiring a project quota of the power grid overhaul, and performing structured conversion and storage;
s5: and comparing the characteristic value, the actual value and the project quota to form audit data and outputting the audit data.
7. The grid overhaul audit data processing method of claim 6 wherein the characteristic values include total investment, material procurement, installation work, civil work and other cost information.
8. The power grid overhaul audit data processing method according to claim 6, wherein the structured transformation specifically is: and converting the corresponding data into a searchable two-dimensional table.
9. The power grid overhaul audit data processing method according to claim 6 wherein during the formation of the two-dimensional table, the extraction of empty rows is skipped.
10. The power grid overhaul audit data processing method according to claim 6, wherein the audit data includes ratio data between characteristic values, actual value and characteristic value comparison data, project quota and characteristic value comparison data, and material comparison data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010127559.6A CN111275409A (en) | 2020-02-28 | 2020-02-28 | Power grid overhaul audit data processing system and processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010127559.6A CN111275409A (en) | 2020-02-28 | 2020-02-28 | Power grid overhaul audit data processing system and processing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111275409A true CN111275409A (en) | 2020-06-12 |
Family
ID=71000501
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010127559.6A Pending CN111275409A (en) | 2020-02-28 | 2020-02-28 | Power grid overhaul audit data processing system and processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111275409A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112308388A (en) * | 2020-10-22 | 2021-02-02 | 国网天津市电力公司 | Electric power engineering overhaul project risk auditing method based on semantic analysis |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107705055A (en) * | 2017-11-24 | 2018-02-16 | 国网内蒙古东部电力有限公司 | Power network technology innovation project backlog control method based on bill of quantities |
| CN107798488A (en) * | 2017-11-24 | 2018-03-13 | 国网内蒙古东部电力有限公司 | A kind of grid maintenance engineering Stores Management System |
| CN107909280A (en) * | 2017-11-24 | 2018-04-13 | 国网内蒙古东部电力有限公司 | A kind of electricity power engineering managing and control system and its control method based on bill of quantities |
| CN109784689A (en) * | 2018-12-28 | 2019-05-21 | 远光软件股份有限公司 | A kind of power grid infrastructure project method for processing report data |
-
2020
- 2020-02-28 CN CN202010127559.6A patent/CN111275409A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107705055A (en) * | 2017-11-24 | 2018-02-16 | 国网内蒙古东部电力有限公司 | Power network technology innovation project backlog control method based on bill of quantities |
| CN107798488A (en) * | 2017-11-24 | 2018-03-13 | 国网内蒙古东部电力有限公司 | A kind of grid maintenance engineering Stores Management System |
| CN107909280A (en) * | 2017-11-24 | 2018-04-13 | 国网内蒙古东部电力有限公司 | A kind of electricity power engineering managing and control system and its control method based on bill of quantities |
| CN109784689A (en) * | 2018-12-28 | 2019-05-21 | 远光软件股份有限公司 | A kind of power grid infrastructure project method for processing report data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112308388A (en) * | 2020-10-22 | 2021-02-02 | 国网天津市电力公司 | Electric power engineering overhaul project risk auditing method based on semantic analysis |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109669933B (en) | Transaction data intelligent processing method and device and computer readable storage medium | |
| CN102110123B (en) | Method for establishing inverted index | |
| CN110889310B (en) | Financial document information intelligent extraction system and method | |
| CN111125116B (en) | Method and system for positioning code field in service table and corresponding code table | |
| CN103440232A (en) | Automatic sScientific paper standardization automatic detecting and editing method | |
| CN105389344A (en) | Self-service novelty retrieval method and system | |
| CN103440233A (en) | Automatic sScientific paper standardization automatic detecting and editing system | |
| CN110362596A (en) | A kind of control method and device of text Extracting Information structural data processing | |
| CN116451665A (en) | Method for intelligently generating design BOM based on drawing | |
| CN112328805A (en) | Entity mapping method of vulnerability description information and database table based on NLP | |
| CN111984673B (en) | Fuzzy retrieval method and device for tree structure of power grid electric energy metering system | |
| CN111275409A (en) | Power grid overhaul audit data processing system and processing method | |
| CN111177401A (en) | Power grid free text knowledge extraction method | |
| CN112258061B (en) | Intelligent risk analysis early warning system and early warning method for whole process of project | |
| CN112183037A (en) | Data classification and summarization method and system in parallel enterprise finance and tax SaaS system | |
| CN109783716B (en) | Automatic extraction and processing system and method for power supply and demand data | |
| CN112036150A (en) | Electricity price policy term analysis method, storage medium and computer | |
| CN114722159B (en) | Multi-source heterogeneous data processing method and system for numerical control machine tool manufacturing resources | |
| CN114495138A (en) | Intelligent document identification and feature extraction method, device platform and storage medium | |
| CN112488593A (en) | Auxiliary bid evaluation system and method for bidding | |
| CN112559609A (en) | Method for reading transformer data from Word and storing transformer data into Excel | |
| CN114385794A (en) | Method, device, equipment and storage medium for generating enterprise knowledge graph | |
| CN111666378A (en) | Chinese yearbook title classification method based on word vectors | |
| CN111597775A (en) | HTML-based information intelligent extraction technology method | |
| CN115168399B (en) | Data processing method, device and equipment based on graphical interface and storage medium |
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 |