CN114564474B - Photovoltaic ledger data automatic verification method and related device - Google Patents
Photovoltaic ledger data automatic verification method and related device Download PDFInfo
- Publication number
- CN114564474B CN114564474B CN202210455080.4A CN202210455080A CN114564474B CN 114564474 B CN114564474 B CN 114564474B CN 202210455080 A CN202210455080 A CN 202210455080A CN 114564474 B CN114564474 B CN 114564474B
- Authority
- CN
- China
- Prior art keywords
- data
- photovoltaic
- abnormal
- distribution transformer
- power generation
- 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
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000012795 verification Methods 0.000 title claims abstract description 23
- 230000002159 abnormal effect Effects 0.000 claims abstract description 147
- 238000012216 screening Methods 0.000 claims abstract description 32
- 230000010354 integration Effects 0.000 claims abstract description 24
- 238000010248 power generation Methods 0.000 claims description 110
- 238000005259 measurement Methods 0.000 claims description 11
- 230000009466 transformation Effects 0.000 claims description 9
- 230000005611 electricity Effects 0.000 claims description 5
- 238000004458 analytical method Methods 0.000 abstract description 17
- 230000008569 process Effects 0.000 description 10
- 238000007726 management method Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000013479 data entry Methods 0.000 description 2
- 238000013524 data verification Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 238000007619 statistical method Methods 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000014509 gene expression Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008521 reorganization Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Computational Linguistics (AREA)
- Water Supply & Treatment (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Primary Health Care (AREA)
- Quality & Reliability (AREA)
- Marketing (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a photovoltaic ledger data automatic verification method and a related device, wherein the method comprises the following steps: firstly, photovoltaic standing book data are obtained through a marketing system and are recombined to obtain photovoltaic standing book integration data; then, automatically screening out abnormal data of the account number, abnormal data of the access mode, abnormal data of the capacity, abnormal data of the power supply distribution transformer and abnormal data of the power supply circuit from the integrated data of the photovoltaic standing book according to different screening rules; and finally, generating an abnormal result list of the photovoltaic ledger data according to the abnormal data of the account number, the abnormal data of the access mode, the abnormal data of the capacity, the abnormal data of the distribution transformer and the abnormal data of the power supply circuit. According to the method and the device, automatic verification and analysis of photovoltaic ledger data abnormity are realized, and the working efficiency of business personnel is greatly improved; meanwhile, related abnormal data are output to achieve closed-loop management, and the data quality of the photovoltaic ledger is improved. Thereby the lower technical problem of prior art to photovoltaic ledger data check-up efficiency has been solved.
Description
Technical Field
The application relates to the technical field of electric power, in particular to a photovoltaic ledger data automatic verification method and a related device.
Background
In order to realize the orderly access of the photovoltaic, ensure the full acceptance of the online of the photovoltaic and realize the maximum application of green energy, the photovoltaic needs to be orderly managed, and the input and operation management of the related data of the photovoltaic is mainly performed through a professional marketing system at present.
Because the construction life of the power grid enterprise marketing system is long, photovoltaic users as emerging users only serve as general users to perform data entry, and the problem that some special information entry is unclear exists; meanwhile, as the data volume of photovoltaic users is large and the quality of basic service personnel is uneven, errors and omissions are difficult to avoid during data entry. Furthermore, the photovoltaic user data volume is large, the data fields are multiple, and the abnormal analysis of the photovoltaic standing book data is difficult to perform manually, so that the requirement of the photovoltaic user on fine management is difficult to meet, and the maximum application of photovoltaic power generation is guaranteed.
Disclosure of Invention
The application provides an automatic verification method and a related device for photovoltaic standing book data, which are used for solving the technical problem that the photovoltaic standing book data verification efficiency is low in the prior art.
In view of this, a first aspect of the present application provides a method for automatically verifying photovoltaic ledger data, where the method includes:
the method comprises the steps of obtaining photovoltaic account data, and recombining the photovoltaic account data through a power generation account number and an internet access account number to obtain photovoltaic account integration data;
screening out abnormal data of the account number from the photovoltaic standing book integration data according to the state of the internet user, the state of the power generation user and the electric quantity data of the power generation user;
screening abnormal data of an access mode from the photovoltaic standing book integrated data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
acquiring converted capacity through a power generation account number correlation measurement automatic system, and screening capacity abnormal data from the photovoltaic standing book integrated data according to the relation between the converted capacity and installed capacity in the photovoltaic standing book integrated data;
acquiring first distribution transformer and line information through a power generation account number association marketing system, acquiring second distribution transformer and line information through an association metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information;
and generating an abnormal result list of the photovoltaic standing book data according to the abnormal account number data, the abnormal access mode data, the abnormal capacity data, the abnormal distribution and transformation data and the abnormal power supply line data.
Optionally, the screening of abnormal data of the account number from the photovoltaic standing book integrated data according to the internet user state, the power generation user state and the power generation user electric quantity data specifically includes:
if the access mode is self-generation self-use residual electric quantity for surfing the Internet and the user surfing the Internet is in a missing state, the user number is defined as abnormal data;
acquiring power generation user electric quantity data from a metering automation system according to the power generation user number, and defining the power generation user electric quantity data as user number abnormal data if the power generation user electric quantity data exceeds a preset threshold value and the user state of the power generation user number is pause or account cancellation.
Optionally, the screening out access mode abnormal data from the photovoltaic ledger integration data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode specifically includes:
if the power generation user electric quantity data and the internet user electric quantity data are equal and are not zero, and meanwhile, the photovoltaic access mode is fully self-used, the power generation user electric quantity data and the internet user electric quantity data are defined as access mode abnormal data;
and if the electricity quantity data of the on-line users is zero and the electricity quantity data of the electricity generation users is not zero, and the photovoltaic access mode is full on-line, the data is defined as access mode abnormal data.
Optionally, the obtaining of the converted capacity by the power generation account number correlation measurement automation system, and screening capacity anomaly data from the photovoltaic ledger integration data according to a relation between the converted capacity and installed capacity in the photovoltaic ledger integration data specifically include:
acquiring the converted capacity through a power generation user number correlation measurement automatic system;
if the converted capacity is not less than the installed capacity in the photovoltaic ledger integration data, defining the converted capacity as capacity abnormal data;
and if the installed capacity of the power generation client is not equal to the installed capacity of the internet client, defining the installed capacity as capacity abnormal data.
Optionally, the obtaining, by the power generation subscriber number-associated marketing system, first distribution transformer and line information, and the obtaining, by the associated metering automation system, second distribution transformer and line information, and screening power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic grid account integrated data according to a state of the first distribution transformer and line information and a relationship between the first distribution transformer and line information and the second distribution transformer and line information specifically include:
acquiring a first distribution transformer name and a first distribution transformer GIS ID through a power generation subscriber number associated marketing system, and defining the first distribution transformer name or the first distribution transformer GIS ID as power supply distribution transformer abnormal data if the first distribution transformer name or the first distribution transformer GIS ID is empty; acquiring a second distribution transformer name and a second distribution transformer GIS ID through a correlation metering automation system, and if the first distribution transformer name and the second distribution transformer name or the first distribution transformer GIS ID is different from the second distribution transformer GIS ID, defining the first distribution transformer name and the second distribution transformer GIS ID as power supply distribution transformer abnormal data;
acquiring a first line name and a first line GIS ID through a power generation subscriber number correlation marketing system, and if the first line name or the first line GIS ID is empty, defining the first line name or the first line GIS ID as power supply line abnormal data; and acquiring a second line name and a second line GIS ID through the associated metering automation system, and defining the first line name and the second line name or the first line GIS ID and the second line GIS ID as power supply line abnormal data if the first line name and the second line name or the first line GIS ID are different from the second line GIS ID.
Optionally, the obtaining of the photovoltaic account book data, and the recombining of the photovoltaic account book data through the power generation account number and the internet access account number to obtain the photovoltaic account book integration data specifically include:
acquiring photovoltaic standing book data through a marketing system;
and associating the internet surfing house number and the power generation house number in the photovoltaic standing book data, and associating a plurality of corresponding fields by taking the internet surfing house number or the power generation house number as a keyword to obtain photovoltaic standing book integration data.
Optionally, the several fields include: photovoltaic user name, grid connection project, installed capacity, access voltage grade, access mode, user state, power supply distribution transformer and power supply line.
This application second aspect provides a photovoltaic standing book data automatic check-up system, the system includes:
the acquisition unit is used for acquiring photovoltaic account data and recombining the photovoltaic account data through a power generation account number and an internet access account number to obtain photovoltaic account integration data;
the first checking unit is used for screening out abnormal data of the account number from the photovoltaic account integrated data according to the state of the online user, the state of the power generation user and the electric quantity data of the power generation user;
the second checking unit is used for screening abnormal data of the access mode from the photovoltaic ledger integration data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
the third checking unit is used for acquiring the converted capacity through a power generation user number correlation measurement automation system and screening capacity abnormal data from the photovoltaic standing book integrated data according to the relation between the converted capacity and the installed capacity in the photovoltaic standing book integrated data;
the fourth verification unit is used for acquiring first distribution transformer and line information through a power generation subscriber number associated marketing system, acquiring second distribution transformer and line information through an associated metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic station account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information;
and the output unit is used for generating an abnormal result list of the photovoltaic ledger data according to the abnormal account number data, the abnormal access mode data, the abnormal capacity data, the abnormal distribution and transformation data and the abnormal power supply line data.
The third aspect of the present application provides a photovoltaic ledger data automatic check-up device, the device includes a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the steps of the photovoltaic ledger data automatic verification method according to the first aspect described above according to instructions in the program code.
A fourth aspect of the present application provides a computer-readable storage medium, where the computer-readable storage medium is used to store a program code, and the program code is used to execute the photovoltaic ledger data automatic verification method according to the first aspect.
According to the technical scheme, the method has the following advantages:
the application provides a photovoltaic ledger data automatic verification method, which comprises the following steps: acquiring photovoltaic account book data, and recombining the photovoltaic account book data through a power generation account number and an internet access account number to obtain photovoltaic account book integration data; screening out abnormal account number data from the photovoltaic standing book integration data according to the internet surfing state, the power generation state and the power generation amount data; screening abnormal data of an access mode from the photovoltaic standing book integrated data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode; acquiring converted capacity through a power generation account number correlation measurement automatic system, and screening capacity abnormal data from photovoltaic standing book integrated data according to the relation between the converted capacity and installed capacity in the photovoltaic standing book integrated data; acquiring first distribution transformer and line information through a power generation number associated marketing system, acquiring second distribution transformer and line information through an associated metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from photovoltaic account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information; and generating an abnormal result list of the photovoltaic ledger data according to the abnormal data of the account number, the abnormal data of the access mode, the abnormal data of the capacity, the abnormal data of the distribution transformer and the abnormal data of the power supply line.
Compared with the prior art, the photovoltaic machine account data abnormity automatic checking analysis method has the advantages that the traditional working mode that manual checking is carried out one by one is replaced, and the working efficiency of business personnel is greatly improved; meanwhile, related abnormal data are output to achieve closed-loop management, the data quality of the photovoltaic ledger is improved, and support is provided for guaranteeing maximum photovoltaic consumption. Thereby the technical problem that the efficiency of checking photovoltaic ledger data is lower in the prior art is solved.
Drawings
Fig. 1 is a schematic flowchart of an embodiment of a method for automatically verifying photovoltaic ledger data provided in an embodiment of the present application;
fig. 2 is a schematic structural diagram of an embodiment of an automatic photovoltaic ledger data verification system provided in an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without making any creative effort belong to the protection scope of the present application.
Referring to fig. 1, an automatic verification method for photovoltaic ledger data provided in an embodiment of the present application includes:
it should be noted that, in the embodiment, the photovoltaic ledger data is acquired through the marketing system, and the acquired photovoltaic ledger is subjected to data reorganization and analysis. The specific implementation process comprises the following steps: the method comprises the steps that a photovoltaic platform account power generation number is associated with a corresponding internet access number or the internet access number is associated with a corresponding power generation number, and key fields such as a corresponding photovoltaic user name, a grid connection project, an installed capacity, an access voltage grade, an access mode, a user state, a power supply distribution transformer and a power supply circuit are associated by taking the photovoltaic power generation number and the internet access number as key words; thereby obtain photovoltaic standing book integration data.
102, screening abnormal account number data from photovoltaic account integrated data according to the state of the online user, the state of the power generation user and the electric quantity data of the power generation user;
it should be noted that, in this embodiment, the photovoltaic house number abnormal data is output by performing verification analysis on the house number abnormality. The specific implementation process comprises the following steps: 1) the power generation users and the internet access users are complete: and no processing is performed, and the photovoltaic number data is defined to be normal. 2) Power generation user loss: and (4) performing statistical analysis on related electric quantity data in the metering automation system by replacing the power generation user number with a user on the internet, and defining that the photovoltaic user number data is normal. 3) The user accessing the network is lost: and for the access mode of all internet surfing, the power generation user replaces the internet surfing user to perform statistical analysis on related electric quantity data in the metering automation system, and the photovoltaic user number data is defined to be normal. And for the access mode which is all self-use, keeping the internet user empty, namely keeping the data of the related electric quantity of the internet zero, and defining the data of the photovoltaic user number to be normal. And for the access mode that the self-power-consumption residual electric quantity is used for surfing the Internet, defining the missing of the online user as the abnormal data of the photovoltaic user number. 4) And analyzing the user state of the user in the marketing system through the power generation user number, associating the power generation user number with the power data of the user in the current month in the metering automation system through the power generation user number, and if the power data is more than 10kWh and the power generation user number is in a suspended and sales state, defining that the photovoltaic user number data is abnormal. Based on the analysis, the photovoltaic house number which is lost and has the access mode of self-using residual electric quantity for surfing the Internet, and the monthly electric quantity data of the power generator house is more than 10kWh, and the power generator house number state is the pause state and the customer sales state is defined as house number abnormal data.
103, screening abnormal data of an access mode from the photovoltaic standing book integration data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
it should be noted that, in the embodiment, the output of the abnormal data of the photovoltaic access mode is realized by performing the abnormal verification analysis on the access mode. The specific implementation process comprises the following steps: and for the photovoltaic accounts with the photovoltaic power generation users and the internet users, current month electric quantity data of the photovoltaic accounts in the metering automation system associated with the power generation users and the internet users are analyzed. 1) And if the photovoltaic access mode is fully self-used, the photovoltaic access mode data is defined to be abnormal. 2) And if the photovoltaic access mode is full online, defining that the photovoltaic access mode data is abnormal. Based on the analysis, the photovoltaic ledger data meeting the conditions are defined as access mode abnormal data.
104, acquiring the converted capacity through a power generation account number correlation measurement automation system, and screening capacity abnormal data from the photovoltaic standing book integrated data according to the relation between the converted capacity and the installed capacity in the photovoltaic standing book integrated data;
it should be noted that, in the embodiment, the output of the abnormal photovoltaic capacity data is realized by performing verification analysis on the abnormal capacity. The specific implementation process comprises the following steps: 1) and associating the generated energy data of the photovoltaic power generation users in the current month in the metering automation system and calculating the converted capacity of the photovoltaic power generation users, wherein the converted capacity = the electric quantity in the current month/(the statistical days in the current month: 24 hours per day: 0.8 of the capacity utilization rate), and if the converted capacity is more than or equal to the installed capacity in the photovoltaic standing book, the abnormal capacity of the photovoltaic standing book is defined. 2) And respectively associating the installed capacities corresponding to the photovoltaic power generation users and the internet users, and if the installed capacity of the photovoltaic power generation users is not equal to the installed capacity of the photovoltaic internet users, defining that the capacity of the photovoltaic machine account is abnormal. Based on the analysis, photovoltaic ledger data meeting the conditions are defined as capacity anomaly data.
105, acquiring first distribution transformer and line information through a power generation account number associated marketing system, acquiring second distribution transformer and line information through an associated metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from photovoltaic account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information;
it should be noted that, in the embodiment, the output of abnormal data of the photovoltaic power supply distribution transformer is realized by performing abnormal verification analysis on the power supply distribution transformer; and outputting abnormal data of the photovoltaic power supply circuit by performing abnormal check analysis on the power supply circuit.
The specific implementation process for carrying out the abnormity verification analysis on the power supply distribution transformer comprises the following steps: 1) and associating the distribution transformer name and the distribution transformer GIS ID (GIS is a geographic information system) corresponding to the marketing system through the photovoltaic power generation user number, and if the distribution transformer name or the distribution transformer GIS ID is empty, defining that the photovoltaic power supply distribution transformer is abnormal. 2) And further associating the corresponding distribution transformer name and distribution transformer GIS ID in the metering automation system through the photovoltaic power generation user number, and if the distribution transformer name and the distribution transformer GIS ID respectively associated by the photovoltaic power generation user in the marketing system and the metering automation system are not consistent, defining that the photovoltaic power supply distribution transformer is abnormal. Based on the analysis, the photovoltaic ledger data meeting the conditions are defined as power supply distribution transformation abnormal data.
The specific implementation process of carrying out the anomaly checking analysis on the power supply line comprises the following steps: 1) and associating the line name and the line GIS ID corresponding to the marketing system through the photovoltaic power generation user number, and if the line name or the line GIS ID is empty, defining that the photovoltaic power supply line is abnormal. 2) And further associating the corresponding line name and line GIS ID in the equipment center through the photovoltaic power generation user number, and if the line name and the line GIS ID respectively associated by the photovoltaic power generation user in the marketing system and the equipment center are inconsistent, defining that the photovoltaic power supply line is abnormal. Based on the analysis, the photovoltaic ledger data meeting the conditions are defined as power supply line abnormal data.
And 106, generating an abnormal result list of the photovoltaic ledger data according to the abnormal data of the account number, the abnormal data of the access mode, the abnormal data of the capacity, the abnormal data of the distribution transformer and the abnormal data of the power supply line.
It should be noted that the list fields of the various types of abnormal data in this embodiment include: (1) and outputting the abnormal data result of the account number. The data output list mainly comprises fields including a district office to which the photovoltaic user belongs, a power supply station, an internet user number, a power generation user number, a user name and a user state. (2) And outputting the access mode abnormal data result. The data output list mainly comprises a regional office to which the photovoltaic user belongs, a power supply station, an internet user number, a power generation user number, a user name and an access mode. (3) And outputting a capacity abnormal data result. The data output list mainly comprises a district office to which the photovoltaic user belongs, a power supply station, an online user number, a power generation user number, a user name, a power generation user installed machine capacity, an online user installed capacity, a monthly generated energy, a monthly deadline and a converted capacity. (4) And outputting the abnormal result of the power distribution transformer. The data output list mainly comprises a district office to which the photovoltaic user belongs, a power supply station, an internet access number, a power generation number, a user name, a marketing system distribution and transformation GIS ID, a metering automation system distribution and transformation name and a metering automation system distribution and transformation GIS ID. (5) And outputting the abnormal result of the power supply line. The data output list mainly comprises a regional office to which the photovoltaic user belongs, a power supply station, an internet user number, a power generation user number, a user name, a marketing system line GIS ID, an equipment center name and an equipment center line GIS ID.
According to the automatic checking method for the photovoltaic ledger data, provided by the embodiment, the automatic checking analysis of the photovoltaic ledger data abnormity is realized, the traditional working mode that manual checking is carried out one by one is replaced, and the working efficiency of business personnel is greatly improved; meanwhile, the related abnormal data are output to achieve closed-loop management, the data quality of the photovoltaic ledger is improved, and support is provided for guaranteeing maximum photovoltaic consumption. Thereby the lower technical problem of prior art to photovoltaic ledger data check-up efficiency has been solved.
The above is an embodiment of a method for automatically checking photovoltaic ledger data provided in the embodiment of the present application, and the following is an embodiment of a system for automatically checking photovoltaic ledger data provided in the embodiment of the present application.
Referring to fig. 2, an automatic verification system for photovoltaic ledger data provided in an embodiment of the present application includes:
the acquisition unit 201 is configured to acquire photovoltaic account data, and recombine the photovoltaic account data by using the power generation account number and the internet access account number to obtain photovoltaic account integration data;
the first checking unit 202 is used for screening out abnormal data of the account number from the photovoltaic account integrated data according to the state of the online user, the state of the power generation user and the electric quantity data of the power generation user;
the second checking unit 203 is used for screening abnormal data of the access mode from the photovoltaic ledger integration data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
the third checking unit 204 is configured to acquire the converted capacity through the power generation account number correlation measurement automation system, and screen capacity anomaly data from the photovoltaic account integrated data according to a relation between the converted capacity and installed capacity in the photovoltaic account integrated data;
the fourth checking unit 205 is configured to acquire the first distribution transformer and the line information through the power generation subscriber number associated marketing system, acquire the second distribution transformer and the line information through the associated metering automation system, and screen power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic ledger integration data according to the state of the first distribution transformer and the line information and the relationship between the first distribution transformer and the line information and the second distribution transformer and the line information;
and the output unit 206 is configured to generate an abnormal result list of the photovoltaic ledger data according to the subscriber number abnormal data, the access mode abnormal data, the capacity abnormal data, the distribution transformer abnormal data, and the power supply line abnormal data.
Further, the embodiment of the present application further provides an automatic check-up device for photovoltaic ledger data, where the device includes a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is used for executing the photovoltaic standing book data automatic verification method according to the program code according to the instructions in the program code.
Further, an embodiment of the present application further provides a computer-readable storage medium, where the computer-readable storage medium is used to store a program code, and the program code is used to execute the photovoltaic ledger data automatic verification method described in the above method embodiment.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The terms "first," "second," "third," "fourth," and the like in the description of the present application and in the above-described drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Moreover, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that, in this application, "at least one" means one or more, "a plurality" means two or more. "and/or" for describing an association relationship of associated objects, indicating that there may be three relationships, e.g., "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of the singular or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one position, or may be distributed on multiple network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit may be implemented in the form of hardware, or may also be implemented in the form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a portable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (9)
1. A photovoltaic standing book data automatic verification method is characterized by comprising the following steps:
acquiring photovoltaic account data, and recombining the photovoltaic account data through a power generation account number and an internet access account number to obtain photovoltaic account integration data;
if the access mode is self-using residual electric quantity to surf the internet and the user is in a missing state, the user number is defined as abnormal data; acquiring power generation user electric quantity data from a metering automation system according to a power generation user number, and defining the power generation user electric quantity data as user number abnormal data if the power generation user electric quantity data exceeds a preset threshold value and the user state of the power generation user number is pause or account cancellation;
screening abnormal data of an access mode from the photovoltaic standing book integrated data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
acquiring converted capacity through a power generation account number correlation measurement automatic system, and screening capacity abnormal data from the photovoltaic standing book integrated data according to the relation between the converted capacity and installed capacity in the photovoltaic standing book integrated data;
acquiring first distribution transformer and line information through a power generation account number association marketing system, acquiring second distribution transformer and line information through an association metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information;
and generating an abnormal result list of the photovoltaic standing book data according to the abnormal account number data, the abnormal access mode data, the abnormal capacity data, the abnormal distribution and transformation data and the abnormal power supply line data.
2. The method for automatically verifying the photovoltaic standing book data according to claim 1, wherein the step of screening abnormal data of an access mode from the photovoltaic standing book integrated data according to the relation between the power generation user power data and the internet user power data and the photovoltaic access mode specifically comprises the steps of:
if the power generation user electric quantity data and the internet user electric quantity data are equal and are not zero, and the photovoltaic access mode is fully self-used, the power generation user electric quantity data and the internet user electric quantity data are defined as access mode abnormal data;
and if the electricity quantity data of the users on the internet is zero and the electricity quantity data of the power generation users is not zero, and the photovoltaic access mode is full internet access, the data are defined as abnormal data of the access mode.
3. The method according to claim 1, wherein the obtaining of the converted capacity by the power generation account number correlation measurement automation system and the screening of the capacity anomaly data from the photovoltaic account integrated data according to the relationship between the converted capacity and the installed capacity in the photovoltaic account integrated data specifically include:
acquiring the converted capacity through a power generation user number correlation measurement automatic system;
if the converted capacity is not less than the installed capacity in the photovoltaic ledger integration data, defining the converted capacity as capacity abnormal data;
and if the installed capacity of the power generation client is not equal to the installed capacity of the internet client, defining the installed capacity as capacity abnormal data.
4. The method according to claim 1, wherein the obtaining of the first distribution transformer and the line information by the power generation account number correlation marketing system and the obtaining of the second distribution transformer and the line information by the correlation metering automation system are performed, and power supply distribution transformer abnormal data and power supply line abnormal data are screened from the photovoltaic account integrated data according to the state of the first distribution transformer and the line information and the relationship between the first distribution transformer and the line information and the second distribution transformer and the line information, and specifically includes:
acquiring a first distribution transformer name and a first distribution transformer GIS ID through a power generation subscriber number association marketing system, and defining the first distribution transformer name or the first distribution transformer GIS ID as power supply distribution transformer abnormal data if the first distribution transformer name or the first distribution transformer GIS ID is empty; acquiring a second distribution transformer name and a second distribution transformer GIS ID through a correlation metering automation system, and if the first distribution transformer name and the second distribution transformer name or the first distribution transformer GIS ID is different from the second distribution transformer GIS ID, defining the first distribution transformer name and the second distribution transformer GIS ID as power supply distribution transformer abnormal data;
acquiring a first line name and a first line GIS ID through a power generation subscriber number correlation marketing system, and if the first line name or the first line GIS ID is empty, defining the first line name or the first line GIS ID as power supply line abnormal data; and acquiring a second line name and a second line GIS ID through the correlation metering automation system, and defining the first line name and the second line name or the first line GIS ID as abnormal data of the power supply line if the first line name and the second line name or the first line GIS ID are different from the second line GIS ID.
5. The method according to claim 1, wherein the step of obtaining photovoltaic account data and recombining the photovoltaic account data through a power generation account number and a network access account number to obtain photovoltaic account integration data specifically comprises:
acquiring photovoltaic standing book data through a marketing system;
and associating the internet surfing house number and the power generation house number in the photovoltaic standing book data, and associating a plurality of corresponding fields by taking the internet surfing house number or the power generation house number as a keyword to obtain photovoltaic standing book integration data.
6. The photovoltaic ledger data automatic check-up method of claim 5, characterized in that the several fields comprise: the photovoltaic power distribution system comprises photovoltaic user names, grid connection projects, installed capacity, access voltage grades, access modes, user states, power supply distribution and transformation and power supply lines.
7. The utility model provides a photovoltaic machine account data automatic check-up system which characterized in that includes:
the acquisition unit is used for acquiring photovoltaic account data and recombining the photovoltaic account data through a power generation account number and an internet access account number to obtain photovoltaic account integration data;
the first checking unit is used for analyzing according to an access mode and an online user, and if the access mode is self-using residual electric quantity to surf the internet and the online user is in a missing state, the first checking unit is defined as abnormal data of the user number; acquiring power generation user electric quantity data from a metering automation system according to a power generation user number, and defining the power generation user electric quantity data as user number abnormal data if the power generation user electric quantity data exceeds a preset threshold value and the user state of the power generation user number is pause or account cancellation;
the second checking unit is used for screening abnormal data of the access mode from the photovoltaic standing book integrated data according to the relation between the power generation user electric quantity data and the internet user electric quantity data and the photovoltaic access mode;
the third checking unit is used for acquiring converted capacity through a power generation account number correlation measurement automation system and screening capacity abnormal data from the photovoltaic standing book integrated data according to the relation between the converted capacity and installed capacity in the photovoltaic standing book integrated data;
the fourth verification unit is used for acquiring first distribution transformer and line information through a power generation subscriber number associated marketing system, acquiring second distribution transformer and line information through an associated metering automation system, and screening power supply distribution transformer abnormal data and power supply line abnormal data from the photovoltaic station account integrated data according to the state of the first distribution transformer and line information and the relation between the first distribution transformer and line information and the second distribution transformer and line information;
and the output unit is used for generating an abnormal result list of the photovoltaic ledger data according to the abnormal account number data, the abnormal access mode data, the abnormal capacity data, the abnormal distribution and transformation data and the abnormal power supply line data.
8. The utility model provides a photovoltaic standing book data automatic check-up equipment which characterized in that, equipment includes processor and memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the photovoltaic ledger data automatic verification method of any one of claims 1 to 6 according to instructions in the program code.
9. A computer-readable storage medium for storing program code for executing the photovoltaic ledger data automatic verification method of any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210455080.4A CN114564474B (en) | 2022-04-28 | 2022-04-28 | Photovoltaic ledger data automatic verification method and related device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210455080.4A CN114564474B (en) | 2022-04-28 | 2022-04-28 | Photovoltaic ledger data automatic verification method and related device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114564474A CN114564474A (en) | 2022-05-31 |
| CN114564474B true CN114564474B (en) | 2022-07-26 |
Family
ID=81721152
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210455080.4A Active CN114564474B (en) | 2022-04-28 | 2022-04-28 | Photovoltaic ledger data automatic verification method and related device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114564474B (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110784175A (en) * | 2019-12-04 | 2020-02-11 | 国网上海市电力公司 | User photovoltaic operation monitoring method based on mobile terminal |
| CN113205431A (en) * | 2021-07-07 | 2021-08-03 | 广东电网有限责任公司佛山供电局 | Multi-source account data abnormity monitoring system and method for distribution network line |
| CN113282594A (en) * | 2021-07-26 | 2021-08-20 | 广东电网有限责任公司佛山供电局 | Automatic extraction and analysis method and system for basic data of distribution transformer |
| CN114004588A (en) * | 2021-10-27 | 2022-02-01 | 孙悦 | Distributed photovoltaic user integrated settlement platform |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105262440B (en) * | 2015-11-24 | 2017-06-13 | 国网山东省电力公司济宁供电公司 | A kind of movable distributive photovoltaic generation comprehensive test platform |
| CN106786547A (en) * | 2017-01-12 | 2017-05-31 | 沃太能源南通有限公司 | A kind of new micro-grid system and the networking scheduling method based on the system |
| US11532056B2 (en) * | 2017-08-17 | 2022-12-20 | Siemens Aktiengesellschaft | Deep convolutional neural network based anomaly detection for transactive energy systems |
| US20210201304A1 (en) * | 2019-12-27 | 2021-07-01 | Google Llc | System and Method for Performing Transactions with an Electronic Ledger |
-
2022
- 2022-04-28 CN CN202210455080.4A patent/CN114564474B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110784175A (en) * | 2019-12-04 | 2020-02-11 | 国网上海市电力公司 | User photovoltaic operation monitoring method based on mobile terminal |
| CN113205431A (en) * | 2021-07-07 | 2021-08-03 | 广东电网有限责任公司佛山供电局 | Multi-source account data abnormity monitoring system and method for distribution network line |
| CN113282594A (en) * | 2021-07-26 | 2021-08-20 | 广东电网有限责任公司佛山供电局 | Automatic extraction and analysis method and system for basic data of distribution transformer |
| CN114004588A (en) * | 2021-10-27 | 2022-02-01 | 孙悦 | Distributed photovoltaic user integrated settlement platform |
Non-Patent Citations (1)
| Title |
|---|
| 电网设备光伏渗透率智能统计分析及应用;邱桂华等;《机电信息》;20191125;第160-161页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114564474A (en) | 2022-05-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110659273B (en) | Data abnormity monitoring and repairing method of distributed big data acquisition platform | |
| CN110705107B (en) | Power distribution network voltage evaluation method, system, equipment and storage medium | |
| CN113283096B (en) | Method for acquiring distribution network line account data and analyzing abnormal data and related device | |
| CN108681599A (en) | A kind of electrical equipment fault analyzing processing householder method | |
| CN107918907A (en) | A kind of order checking method and system | |
| CN107194562A (en) | Electric company's platform area outage analysis system | |
| CN110689185A (en) | Power utilization processing method and device, storage medium and processor | |
| CN111178676A (en) | Power distribution network project investment assessment method and system | |
| CN107577769A (en) | A kind of method for digging and system for measuring expert data | |
| CN114564474B (en) | Photovoltaic ledger data automatic verification method and related device | |
| CN105260401A (en) | Method and device for querying and storing electric data | |
| CN206480045U (en) | A kind of customer care server and customer service system | |
| CN111723942A (en) | Enterprise power load prediction method, power grid service subsystem and prediction system | |
| CN113052417A (en) | Resource allocation method and device | |
| CN114860790A (en) | Marketing meter reading abnormity analysis system | |
| CN106066860B (en) | Method for managing electric energy metering device | |
| CN114614509A (en) | Analysis method for influence of photovoltaic access on electric energy quality and related device | |
| CN112651136B (en) | CIM equipment measurement model generation method, device, equipment and medium | |
| CN115085195B (en) | Distribution transformer annual maximum load rate prediction method and related device thereof | |
| CN114282907A (en) | Resident arrearage power-off and power-restoration management method and related device | |
| CN109492930B (en) | Method and device for evaluating contribution degree of power distribution network project to power supply reliability | |
| CN117132157A (en) | Performance data processing method, system, terminal and storage medium | |
| CN117913974A (en) | Daily electric quantity monitoring and analyzing system | |
| CN113626535A (en) | Method and device for analyzing power utilization characteristics of power supply area | |
| CN114723421A (en) | Safety tool test management system |
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 |