CN114139883B - Calculation method of material domain evaluation index of power enterprise - Google Patents
Calculation method of material domain evaluation index of power enterprise Download PDFInfo
- Publication number
- CN114139883B CN114139883B CN202111325615.8A CN202111325615A CN114139883B CN 114139883 B CN114139883 B CN 114139883B CN 202111325615 A CN202111325615 A CN 202111325615A CN 114139883 B CN114139883 B CN 114139883B
- Authority
- CN
- China
- Prior art keywords
- formula
- text
- index
- term
- physical model
- 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.)
- Active
Links
- 238000011156 evaluation Methods 0.000 title claims abstract description 54
- 238000004364 calculation method Methods 0.000 title claims abstract description 10
- 230000014509 gene expression Effects 0.000 claims description 9
- 238000000034 method Methods 0.000 abstract description 4
- 238000012544 monitoring process Methods 0.000 description 8
- 238000003908 quality control method Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention relates to a calculation method of a material domain evaluation index of an electric power enterprise, and belongs to the technical field of material domain evaluation of electric power systems. According to the method, firstly, texts corresponding to the fields of a business module, a statistics period and an index formula are analyzed from a material domain evaluation index card file, then an index evaluation formula is constructed from the texts corresponding to the fields of the index formula, then a data source and a statistics range are determined from the texts corresponding to the fields of the business module and the statistics period, a material physical model is constructed from an information system according to the index evaluation formula, and finally the material physical model is calculated by using the index evaluation formula, so that an index evaluation value is obtained.
Description
Technical Field
The invention relates to a calculation method of a material domain evaluation index of an electric power enterprise, and belongs to the technical field of material domain evaluation of electric power systems.
Background
The evaluation index of the material domain is monitored, and the method is one of internal control modes adopted by power enterprises. At present, the monitoring of the evaluation index mainly adopts a manual mode, manual calculation is carried out through an electronic table, the working efficiency is low, mass data cannot be processed, and automatic monitoring cannot be realized. Specifically, the following problems exist in monitoring the material domain evaluation index by adopting a manual mode:
1. the manual mode mainly adopts an electronic table to manually calculate the evaluation index, and the requirement of automatic monitoring management cannot be met.
2. The material field evaluation index generally relates to the calculation of hundreds of millions of data, and the electronic table can not be directly opened in a computer due to the excessive data volume. Therefore, manual means cannot monitor large amounts of data.
Disclosure of Invention
The invention aims to solve the technical problem of providing a calculation method of the material domain evaluation index of an electric power enterprise, which is used for automatically calculating the evaluation index value by constructing an evaluation index formula and a material physical model and improving the monitoring efficiency of the material domain evaluation index.
The technical scheme of the invention is as follows: a calculation method of an evaluation index of a material domain of an electric power enterprise comprises the following specific steps:
step1: and analyzing texts corresponding to the fields of the business module, the statistical period and the index formula from the material domain evaluation index card file.
Step2: and constructing an index evaluation formula from the text corresponding to the field of the index formula.
Step3: determining data source and statistical range from text corresponding to the 'business module' and 'statistical period' fields, and constructing physical model of material from information system according to index evaluation formula
Step4: and calculating the physical model of the material by using an index evaluation formula to obtain an index evaluation value.
Preferably, step2 is specifically:
step2.1: for the text corresponding to the field of the index formula, the text is scanned from left to right, and the text is cut into two text segments, which are respectively called a left text segment and a right text segment, and are characterized by "=".
Step2.2: for the left text segment, a left formula term is matched by using a left term matching mode, and the left term matching mode is defined by using a regular expression, specifically defined as: [ (] is [_4E00-_9FA5 ]) ]? ? And (4) the cost is reduced.
Step2.3: for the right text segment, if the text segment contains a "=" symbol, step2.1 is returned and executed. If not, the text is scanned from left to right, characterized by "%", and the text is cut into two text segments, referred to as a right left text segment and a right text segment, respectively.
Step2.4: for the right-left text segment, a right term matching mode is used for matching a right formula term, and the right term matching mode is defined by using a regular expression, and specifically defined as follows: [ (] is [_4E00-_9FA5 ]) ]? [ × ]? [0-9] [% ]? And (4) the cost is reduced.
Step2.5: for right and right text segments, matching left formula terms and operators from the right and right text segments by using left term matching patterns and operator matching patterns, wherein the operator matching patterns are defined by using regular expressions, and specifically defined as follows: [ =, +, -, ×,/, Σ ].
Step2.6: and constructing an index evaluation formula aiming at the matched left formula term, right formula term and operator. The index formula is predefined by the power enterprise according to priori knowledge.
Preferably, step3 is specifically:
step3.1: and determining a data source from the information system according to the text corresponding to the service module.
The data source refers to a table in a database of the information system.
The table in the database means: purchasing and supplier table, warehouse and distribution table, reverse material table, demand management table, performance and quality control table.
Step3.2: and determining the statistical range of the data from the information system according to the text corresponding to the statistical period.
The statistical range refers to the statistical range in the table determined by week, month, quarter, half year and year.
Step3.3: and constructing a physical model of the materials by using projection operation and full connection operation according to an index evaluation formula.
If the formula item involved in the index evaluation formula corresponds to the column name of 1 table, a physical model of the material is constructed from 1 data table determining the statistical range using a projection operation. Otherwise, a projection operation is used to construct a physical model of the material from a plurality of data tables that determine the statistical range.
Step3.4: the physical model comprises a table name, a field name, a data type of a field, a data length of the field, a primary key and a foreign key.
The beneficial effects of the invention are as follows: according to the invention, the evaluation index formula and the physical model of the material are constructed, so that the evaluation index value is automatically calculated, and the monitoring efficiency of the material domain evaluation index is improved. Compared with the monitoring of the material domain evaluation index based on the manual mode, the method and the device can not only avoid the defect that the manual mode cannot monitor a large amount of data, but also realize the automatic calculation of the evaluation index and improve the monitoring efficiency of the material domain evaluation index.
Drawings
Fig. 1 is a flow chart of the steps of the present invention.
Detailed Description
The invention will be further described with reference to the drawings and detailed description.
As shown in fig. 1, a method for calculating an evaluation index of a material domain of an electric power enterprise specifically includes the following steps:
step1: and analyzing texts corresponding to the fields of the business module, the statistical period and the index formula from the material domain evaluation index card file.
Step2: and constructing an index evaluation formula from the text corresponding to the field of the index formula.
Step3: and determining a data source and a statistical range from texts corresponding to the 'business module' and the 'statistical period' fields, and constructing a physical model of the materials from the information system according to an index evaluation formula.
Step4: and calculating the physical model of the material by using an index evaluation formula to obtain an index evaluation value.
The Step1 specifically comprises the following steps:
step1.1: using a numpy library in python language, a material domain evaluation index card file (excel file) is read.
Step1.2: and analyzing texts corresponding to the 'business module' field, the 'statistical period' field and the 'index formula' field.
The Step2 specifically comprises the following steps:
step2.1: for the text corresponding to the field of the index formula, the text is scanned from left to right, and the text is cut into two text segments, which are respectively called a left text segment and a right text segment, and are characterized by "=".
Step2.2: for the left text segment, the left formula term is matched using the left term matching pattern. The left term matching pattern is defined by using a regular expression, and is specifically defined as follows: [ (] is [_4E00-_9FA5 ]) ]? ? And (4) the cost is reduced.
Step2.3: for the right text segment, if the text segment contains a "=" symbol, step2.1 is returned and executed. If not, the text is scanned from left to right, characterized by "%", and the text is cut into two text segments, referred to as a right left text segment and a right text segment, respectively.
Step2.4: for the right-left text segment, the right formula term is matched using the right term matching pattern. The right term matching pattern is defined by using a regular expression, and is specifically defined as follows: [ (] is [_4E00-_9FA5 ]) ]? [ × ]? [0-9] [% ]? And (4) the cost is reduced.
Step2.5: for the right-right text segment, a left formula term and operator are matched from the right-right text segment using a left term matching pattern and an operator matching pattern. The operator matching pattern is defined using a regular expression, specifically defined as: [ =, +, -, ×,/, Σ ].
Step2.6: and constructing an index evaluation formula aiming at the matched left formula term, right formula term and operator.
The Step3 specifically comprises the following steps:
step3.1: and determining a data source from the information system according to the text corresponding to the service module. In particular, a data source refers to a table in a database of an information system. The table in the database indicates: purchasing and supplier table, warehouse and distribution table, reverse material table, demand management table, performance and quality control table.
Step3.2: and determining the statistical range of the data from the information system according to the text corresponding to the statistical period. Specifically, the statistical range refers to the statistical range in the table determined in units of weeks, months, quarters, half years, and years.
Step3.3: and constructing a physical model of the materials by using projection operation and full connection operation according to an index evaluation formula. Specifically, if the formula item to which the index evaluation formula relates corresponds to a column name in 1 table, a physical model of the material is constructed from the data table that determines the statistical range using the projection operation. Otherwise, using full connection operation to construct physical model of materials from multiple data tables in definite statistical range.
Step3.4: the physical model includes a table name, a field name, a data type of the field, a data length of the field, a primary key, and a foreign key.
While the present invention has been described in detail with reference to the drawings, the present invention is not limited to the above embodiments, and various changes can be made without departing from the spirit of the present invention within the knowledge of those skilled in the art.
Claims (1)
1. A calculation method of an evaluation index of a material domain of an electric power enterprise is characterized by comprising the following steps:
step1: analyzing texts corresponding to the fields of the business module, the statistical period and the index formula from the material domain evaluation index card file;
step2: constructing an index evaluation formula from the text corresponding to the field of the index formula;
step3: determining a data source and a statistical range from texts corresponding to the fields of the service module and the statistical period, and constructing a physical model of materials from an information system according to an index evaluation formula;
step4: calculating the physical model of the materials by using an index evaluation formula to obtain an index evaluation value;
the Step2 specifically comprises the following steps:
step2.1: for the text corresponding to the field of the index formula, scanning the text from left to right, and cutting the text into two text segments, which are respectively called a left text segment and a right text segment, by taking the "=" as a characteristic;
step2.2: for the left text segment, a left formula term is matched by using a left term matching mode, and the left term matching mode is defined by using a regular expression, specifically defined as:
;
step2.3: for the right text segment, if the text segment contains a "=" sign, step2.1 is returned and executed; if the text is not included, scanning the text from left to right, and cutting the text into two text segments, namely a right left text segment and a right text segment, by taking "%" as a characteristic;
step2.4: for the right-left text segment, a right term matching mode is used for matching a right formula term, and the right term matching mode is defined by using a regular expression, and specifically defined as follows:
;
step2.5: for right and right text segments, matching left formula terms and operators from the right and right text segments by using left term matching patterns and operator matching patterns, wherein the operator matching patterns are defined by using regular expressions, and specifically defined as follows:
;
step2.6: constructing an index evaluation formula aiming at the matched left formula term, right formula term and operator;
the Step3 specifically comprises the following steps:
step3.1: determining a data source from the information system according to the text corresponding to the service module;
step3.2: determining the statistical range of data from an information system according to the text corresponding to the statistical period;
step3.3: constructing a physical model of the material by using projection operation and full connection operation according to an index evaluation formula;
if the formula item related to the index evaluation formula corresponds to the column name of 1 table, constructing a physical model of the material from the 1 data table for determining the statistical range by using projection operation; otherwise, constructing a physical model of the materials from a plurality of data tables with determined statistical ranges by using projection operation;
step3.4: the physical model comprises a table name, a field name, a data type of a field, a data length of the field, a primary key and a foreign key.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111325615.8A CN114139883B (en) | 2021-11-10 | 2021-11-10 | Calculation method of material domain evaluation index of power enterprise |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111325615.8A CN114139883B (en) | 2021-11-10 | 2021-11-10 | Calculation method of material domain evaluation index of power enterprise |
Publications (2)
Publication Number | Publication Date |
---|---|
CN114139883A CN114139883A (en) | 2022-03-04 |
CN114139883B true CN114139883B (en) | 2024-03-29 |
Family
ID=80392689
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111325615.8A Active CN114139883B (en) | 2021-11-10 | 2021-11-10 | Calculation method of material domain evaluation index of power enterprise |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114139883B (en) |
Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109885658A (en) * | 2019-02-19 | 2019-06-14 | 安徽省泰岳祥升软件有限公司 | Achievement data extracting method, device and computer equipment |
CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
CN110990400A (en) * | 2019-11-20 | 2020-04-10 | 浙江大搜车软件技术有限公司 | Database query method and device, computer equipment and storage medium |
CN111127186A (en) * | 2019-12-10 | 2020-05-08 | 云南电网有限责任公司信息中心 | Application method of customer credit rating evaluation system based on big data technology |
CN111143339A (en) * | 2019-12-20 | 2020-05-12 | 东方微银科技(北京)有限公司 | Method, device, equipment and storage medium for distributing service resources |
CN111815487A (en) * | 2020-06-28 | 2020-10-23 | 珠海中科先进技术研究院有限公司 | Health education assessment method, device and medium based on deep learning |
CN112182371A (en) * | 2020-09-22 | 2021-01-05 | 珠海中科先进技术研究院有限公司 | Health management product combination and pricing method and medium |
WO2021068683A1 (en) * | 2019-10-11 | 2021-04-15 | 平安科技(深圳)有限公司 | Method and apparatus for generating regular expression, server, and computer-readable storage medium |
WO2021093821A1 (en) * | 2019-11-14 | 2021-05-20 | 中兴通讯股份有限公司 | Intelligent assistant evaluation and recommendation methods, system, terminal, and readable storage medium |
-
2021
- 2021-11-10 CN CN202111325615.8A patent/CN114139883B/en active Active
Patent Citations (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109885658A (en) * | 2019-02-19 | 2019-06-14 | 安徽省泰岳祥升软件有限公司 | Achievement data extracting method, device and computer equipment |
CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
WO2021068683A1 (en) * | 2019-10-11 | 2021-04-15 | 平安科技(深圳)有限公司 | Method and apparatus for generating regular expression, server, and computer-readable storage medium |
WO2021093821A1 (en) * | 2019-11-14 | 2021-05-20 | 中兴通讯股份有限公司 | Intelligent assistant evaluation and recommendation methods, system, terminal, and readable storage medium |
CN110990400A (en) * | 2019-11-20 | 2020-04-10 | 浙江大搜车软件技术有限公司 | Database query method and device, computer equipment and storage medium |
CN111127186A (en) * | 2019-12-10 | 2020-05-08 | 云南电网有限责任公司信息中心 | Application method of customer credit rating evaluation system based on big data technology |
CN111143339A (en) * | 2019-12-20 | 2020-05-12 | 东方微银科技(北京)有限公司 | Method, device, equipment and storage medium for distributing service resources |
CN111815487A (en) * | 2020-06-28 | 2020-10-23 | 珠海中科先进技术研究院有限公司 | Health education assessment method, device and medium based on deep learning |
CN112182371A (en) * | 2020-09-22 | 2021-01-05 | 珠海中科先进技术研究院有限公司 | Health management product combination and pricing method and medium |
Non-Patent Citations (3)
Title |
---|
基于XGBoost算法模型的金融客户信用评估研究;陆健健;江开忠;;软件导刊;20190104(第04期);139-142 * |
基于正则抽取的竹种数据结构化方法研究;李欣;李绍稳;许高建;林建彬;;计算机技术与发展;20180208(第06期);153-156+161 * |
项目验收的同行评议辅助决策评价方法研究――基于贝叶斯正则化修正的BP人工神经网络模型;万昊;谭宗颖;张福俊;朱相丽;刘小玲;;情报杂志;20171118(第11期);196-203 * |
Also Published As
Publication number | Publication date |
---|---|
CN114139883A (en) | 2022-03-04 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8533235B2 (en) | Infrastructure and architecture for development and execution of predictive models | |
Gabrovšek et al. | Twitter sentiment around the Earnings Announcement events | |
CN114462133A (en) | Digital twin technology equipment product-based carbon footprint digital accounting method and system | |
CN106528511B (en) | Form analysis method and device | |
CN104732307A (en) | Project workload acquisition method and system | |
CN112860769A (en) | Energy planning data management system | |
Zhao et al. | Digital transformation, life cycle and internal control effectiveness: Evidence from China | |
CN114139883B (en) | Calculation method of material domain evaluation index of power enterprise | |
CN109101541B (en) | Newly added index management method, device and computer readable storage medium | |
Krishna | Big Data in risk management | |
CN113590607A (en) | Electric power marketing report realization method and system based on report factor | |
CN104391986A (en) | Business reclassification device and business reclassification method | |
CN116883184A (en) | Financial tax intelligent analysis method based on big data | |
Yang et al. | Research and application of business ability evaluation based on DBSCAN algorithm and entropy method | |
Assey et al. | Factors influencing fixed asset losses in local government authorities in Tanzania | |
Wei et al. | Advanced Artificial Intelligence Model for Financial Accounting Transformation Based on Enterprise Unstructured Text Data | |
CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
US20200320452A1 (en) | Solution Proposal Support System and Solution Proposal Support Method | |
CN113191868A (en) | Intelligent risk identification method of tax system | |
CN108052522B (en) | Method and system for dynamically optimizing OLAP pre-calculation model | |
CN110110979A (en) | Low-carbon target assessment system | |
Syamsuddin | The effect of information technology on the quality of financial reports in the regional financial management agency of Takalar Regency | |
Wu et al. | AQapprox: Aggregation Queries Approximation with Distribution-Aware Online Sampling | |
CN117151493A (en) | Standard analysis method based on TextRank algorithm | |
Hatam et al. | The Event Research in the Effect of Clear Rumor Declarations on Abnormal Stock Returns Behavior |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |