Power spot transaction data monitoring and analysis method, device, and computer equipment
By analyzing the abnormal user profile list and operation data of the power spot transaction data collection system, a list of defects is generated, which solves the problems of data update lag and analysis and dispersion in the existing system, real-time monitoring and accurate processing of power spot transaction data is realized. , improve operation and maintenance efficiency and transaction settlement accuracy.
Patent Information
- Application Number
- CN202210021833.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-01-10
- Publication Date
- 2024-11-12
- Estimated Expiration
- 2042-01-10
AI Technical Summary
The existing power spot trading data collection and monitoring system lacks comprehensive display of the overall collection status of spot users, resulting in dispersed operating conditions, and requires the deficit list to be exported in batches, which is easy to cause judgment errors, data updates are lagging, resulting in false alarms or failures. Use will affect the settlement of spot power transactions.
Through data comparison between the marketing system and the measurement automation system, an abnormal user profile list is generated, the number of missing times is calculated, the operating status is determined and the processing method is determined, and the spot user defect list is generated to realize real-time monitoring and classified display of data.
It improves the judgment efficiency of operation and maintenance personnel, ensures the accuracy and real-time data, handles faults in a timely manner, and improves the accuracy and efficiency of spot trading settlement of power.
Smart Images

Figure CN114386630B_ABST
Abstract
Description
Technical Field
[0001] Embodiments of the present invention relate to the technical field of electricity, and in particular, to a method, device, computer equipment and storage medium for monitoring and analyzing electricity spot transaction data. Background Art
[0002] During the trial operation of electricity spot trading settlement, the real-time electricity energy market is settled on an hourly basis. The power supply bureaus of various cities need to generate a list of missing data for electricity spot trading based on the meter code collection status on the monitoring trading day, determine the operating status including the fault type and its treatment suggestions, send it to the relevant work responsible personnel for processing, and make up the data to obtain the correct amount of electricity, and push it to the trading center to publish the official results of the real-time market on the operation day as the basis for settlement. The list of missing data for electricity spot trading needs to locate the operating status and fault type, confirm the treatment method and send it to different functional and responsible units for elimination.
[0003] The current power spot trading data collection and monitoring system lacks a comprehensive display of the overall collection status of all participating spot users. It is necessary to export a list of spot users that need to be eliminated in batches. The operating status analysis function modules are scattered, and different problems need to be found in different modules. The triggered abnormal work orders are assigned to operation and maintenance personnel. The methods to solve the problems require the judgment of the operation and maintenance personnel, which is prone to misjudgment. The operating data is updated with lags, and even false alarms, omissions, or unusable data may occur, delaying the settlement of power spot transactions. Summary of the invention
[0004] The embodiment of the present invention proposes a method, device, computer equipment and storage medium for monitoring and analyzing electricity spot transaction data to solve the problem of locating a spot user's fault elimination list in a large amount of operation data, quickly classifying faults and calibrating processing methods.
[0005] In a first aspect, an embodiment of the present invention provides a method for monitoring and analyzing power spot transaction data, comprising:
[0006] Obtaining an abnormal user file list of the metering automation system according to the first spot user file data preset by the marketing system and the second spot user file data in the metering automation system;
[0007] Calculate the number of missing items of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system;
[0008] Determine the operating status corresponding to the spot user according to the first spot user file data, the operating data in the metering automation system and the number of missing numbers;
[0009] A corresponding processing method is determined according to the operating status.
[0010] In a second aspect, an embodiment of the present invention further provides a device for monitoring and analyzing electric power spot transaction data, comprising:
[0011] An abnormal user profile list determination module is used to obtain an abnormal user profile list of the metering automation system according to the first spot user profile data preset by the marketing system and the second spot user profile data in the metering automation system;
[0012] A missing number calculation module, used for calculating the missing number of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system;
[0013] An operation status analysis module, used to determine the operation status corresponding to the spot user according to the first spot user file data, the operation data in the metering automation system and the number of missing data;
[0014] The processing method determination module is used to determine the corresponding processing method according to the operating status.
[0015] In a third aspect, an embodiment of the present invention further provides a computer device, the computer device comprising:
[0016] one or more processors;
[0017] a memory for storing one or more programs,
[0018] When the one or more programs are executed by the one or more processors, the one or more processors implement the method for monitoring and analyzing electricity spot transaction data as described in the first aspect.
[0019] In a fourth aspect, an embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the method for monitoring and analyzing electricity spot transaction data as described in the first aspect is implemented.
[0020] In this embodiment, according to the first spot user file data preset by the marketing system and the second spot user file data in the metering automation system, the abnormal user file list of the metering automation system is obtained; according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system, the number of missing numbers of the spot user is calculated; according to the first spot user file data, the operation data and the number of missing numbers in the metering automation system, the operation status corresponding to the spot user is determined; according to the operation status, the corresponding processing method is determined; according to the operation data, the number of missing numbers, the operation status and the processing method of the spot user, the spot user's missing list is generated. The collection status of the spot user on the day can be monitored and classified, and the daily operation status and processing method can be clearly grasped and displayed. All the collected data can obtain the operation status of all spot users at one time, and the abnormal situation and processing suggestions are marked, which is convenient for the relevant operation and maintenance personnel and supervisors to view the faults and suggestions that need to be handled, so as to handle and follow up in time, and improve the efficiency of management; and the operation data is updated in real time, and the guidance opinions of the spot user's missing list are highly accurate and real-time. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] Figure 1 A flowchart of a method for monitoring and analyzing power spot transaction data provided in the first embodiment of the present invention;
[0022] Figure 2 A schematic diagram of the structure of a device for monitoring and analyzing power spot transaction data provided by Embodiment 2 of the present invention;
[0023] Figure 3 A schematic diagram of the structure of a computer device provided in Embodiment 3 of the present invention. DETAILED DESCRIPTION
[0024] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It is to be understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for ease of description, only parts related to the present invention, rather than all structures, are shown in the accompanying drawings.
[0025] Embodiment 1
[0026] Figure 1A flowchart of a method for monitoring and analyzing power spot transaction data provided in Embodiment 1 of the present invention is provided. This embodiment can be applied to uniformly display abnormal conditions and processing suggestions of all spot users, so as to facilitate relevant operation and maintenance personnel and supervisory personnel to view faults that need to be processed and processing suggestions to improve efficiency. The method can be executed by a power spot transaction data monitoring and analysis device, which can be implemented by software and / or hardware and can be configured in a computer device, such as a server, a personal computer, etc., and specifically includes the following steps:
[0027] Step 101: Obtain an abnormal user file list of the metering automation system according to the first spot user file data preset in the marketing system and the second spot user file data in the metering automation system.
[0028] The electricity spot market is an important part of the complete electricity market system, and together with the medium and long-term market, it plays a role in discovering the price of electricity commodities. In other words, through the evaluation of spot prices over the years and the prediction of factors that may affect costs in the future, the two parties who intend to trade electricity for a long time can negotiate a price that both parties agree on. This price is based on the spot market.
[0029] The marketing system stores some spot user profile data, including the user's metering point number, user number, etc.
[0030] The metering automation system can automatically obtain the meter and terminal files corresponding to the metering point number, and extract operating data such as the power consumption of the user terminal.
[0031] In some embodiments of the present invention, step 101 includes:
[0032] Step 1011: Obtain the first spot user profile data preset by the marketing system.
[0033] The user profile data pre-stored in the marketing system is exported as the first spot user profile data.
[0034] Step 1012: Acquire the second spot user profile data in the metering automation system.
[0035] The user profile data obtained in real time in the metering automation system is exported as the second spot user profile data.
[0036] Step 1013: Compare the first spot user file data with the second spot user file data using the metering point number as a key field to obtain an abnormal user file list of the metering automation system.
[0037] The first spot user profile data obtained in the marketing system is used as the basic list, and the metering point number is used as the key field to compare the second spot user profile data of the metering automation system. When the two spot user profile data of the same metering point number are inconsistent, the spot user corresponding to the metering point number is marked as an abnormal user. All abnormal users and their data form an abnormal user profile list for output. Relevant staff will check and process these abnormal users one by one according to the abnormal user profile list to find out the reasons for the inconsistency between the user profile data of the marketing system and the metering automation system.
[0038] Exemplarily, when the first user profile data of a certain metering point number exists but the second user profile data thereof does not exist, the spot user corresponding to the metering point number is listed as an abnormal user.
[0039] It should be noted that the use of the metering point number as the key field in the above embodiment is an exemplary description of the embodiment of the present invention. In other embodiments of the present invention, other features may also be used as key fields, and the present invention is not limited here.
[0040] Step 102: Calculate the number of missing items for the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system.
[0041] Missing data refers to the fact that during the process of power transmission and use, due to abnormalities or defects in equipment, the spot user's operating data at a certain moment in the metering automation system is partially missing.
[0042] Remove the abnormal users from the abnormal user file list, classify the operating conditions of other spot users with normal user file data, and generate corresponding processing methods. Before classifying the operating conditions, it is necessary to calculate the number of missing spot users according to the acceptance status type of the spot users in the metering automation system.
[0043] In some embodiments of the present invention, step 102 includes:
[0044] Step 1021: Obtain the acceptance status type of the spot user in the metering automation system.
[0045] There are two types of acceptance status for spot users: acceptance success and acceptance failure, which are stored in the measurement automation system.
[0046] In the metering automation system, the status acceptance type of the spot user is obtained, whether it is acceptance success or acceptance failure, so as to facilitate the subsequent calculation of the number of missing spot users.
[0047] Step 1022, determine the acceptance status type of the spot user; if the acceptance status type is acceptance success, execute step 1023; if the acceptance status type is acceptance failure, execute step 1024.
[0048] The acceptance type of the spot user is judged. If the acceptance is successful, it means that the data of the spot user at each time is basically consistent with the real value. Therefore, step 1023 is executed to determine that the table code type of the spot user is a curve table code, and the user's curve table code data type is obtained as the table code data of the spot user; if the acceptance fails, it means that the data of the spot user at certain times does not meet the relevant requirements. Therefore, step 1024 is executed to determine that the table code type of the spot user is a real-time table code, and the real-time table code data corresponding to the spot user is obtained as the table code data.
[0049] Step 1023: Determine that the table code type of the spot user is a curve table code, and obtain the curve table code data corresponding to the spot user as the table code data.
[0050] Determine that the table code type of the spot user is a curve table code type, and obtain the curve table code data corresponding to the spot user in the metering automation system as the table code data corresponding to the spot user.
[0051] Step 1024: determine that the table code type of the spot user is a real-time table code, and obtain the real-time table code data corresponding to the spot user as the table code data.
[0052] Determine that the meter code type of the spot user is a real-time meter code type, and obtain the real-time meter code data corresponding to the spot user in the metering automation system as the meter code data corresponding to the spot user.
[0053] Step 1025: Calculate the number of times the spot user is short of stock based on the table code data.
[0054] According to the table code data obtained in step 1023, the number of missing data of the spot user is specifically analyzed and calculated to find out the number of missing operation data of the spot user on that day.
[0055] In some embodiments of the present invention, step 1025 includes:
[0056] Step 10251, count the number of positive and negative active power and the number of positive and negative reactive power corresponding to the table code type.
[0057] With metering point number, meter address and terminal logic address as key fields, the total number of positive and negative active power and total number of positive and negative reactive power of corresponding meter code types in the metering automation system are counted.
[0058] Step 10252: Use the preset total number of forward and reverse records, the number of forward and reverse active records, and the number of forward and reverse reactive records to calculate the number of missing records using the following formula:
[0059] Number of missing records = total number of forward and reverse records - number of forward and reverse active records - number of forward and reverse reactive records.
[0060] The preset total number of forward and reverse records is the total number of forward and reverse active power and forward and reverse reactive power when the metering automation system can count normally. The number of missing numbers for forward and reverse active power or forward and reverse reactive power that cannot be recorded can be obtained by subtracting the forward and reverse active power and the forward and reverse reactive power from the preset total number of forward and reverse records.
[0061] Exemplarily, the preset total number of forward and reverse records is 48 times, the forward and reverse active times obtained in the metering automation system are 23 times, and the forward and reverse reactive times are 22 times, then the number of missing times is (48-23-22), that is, the number of missing times is 3 times.
[0062] It should be noted that the preset total number of forward and reverse records in the above embodiment is an exemplary description of the embodiment of the present invention. In other embodiments of the present invention, the preset total number of forward and reverse records can also be other numbers, and the present invention is not limited here.
[0063] In some embodiments of the present invention, step 1025 includes:
[0064] Step 10253: Use the deficiency query function preset in the metering automation system to obtain the number of deficiency times of the spot user.
[0065] The metering automation system is preset with a defect query function. When the defect query function operates normally, the defects with missing data and the corresponding occurrence time can be continuously obtained.
[0066] Count the number of all shortcomings of a certain spot user on that day to get the number of shortages of the spot user.
[0067] It should be noted that the above-mentioned embodiments in which the number of missing times is obtained through the number of forward and reverse active times and the number of forward and reverse reactive times or by using the defect query function preset by the metering automation system are exemplary descriptions of the embodiments of the present invention. In other embodiments of the present invention, the number of missing times of spot users can also be obtained by other methods, and the present invention is not limited here.
[0068] Step 103: Determine the operating status corresponding to the spot user according to the first spot user file data, the operating data in the metering automation system, and the number of missing numbers.
[0069] First, the spot user file data records the basic information of the spot user, such as whether the user has redundant files with historical problems that are difficult to rectify, such as being in a non-operating state, or whether the user is in a fixed ratio state or a disabled state.
[0070] The operating status of the spot user on that day is determined based on the first spot user profile data in the marketing system, the operating data generated in real time in the metering automation system, and the number of missing numbers calculated in step 102.
[0071] The operating status of the spot user determined based on the above data reflects whether the spot user has any abnormalities on that day and what kind of abnormal faults there are, and can intuitively reflect to the operation and maintenance personnel the faults of a certain spot user that need to be eliminated or repaired.
[0072] In some embodiments of the present invention, step 103 includes:
[0073] Step 1031, judging whether the user meets the preset condition of the spot user being in a temporarily unprocessed state according to the first spot user profile data; if so, executing step 1032; if not, executing step 1033.
[0074] If there are redundant files in the first spot user file data of a certain user, or the file data shows status marks such as fixed ratio and deactivated, and the preset conditions of the temporarily unprocessed status are met, it means that the spot user is in the temporarily unprocessed status, and it is necessary to execute step 1032 to mark the operating status marked by the spot user as the temporarily unprocessed status; if the preset conditions for the spot user to be in the temporarily unprocessed status are not met, then execute step 1033 to determine whether the number of missing numbers of the spot user is 0, and find the corresponding operating status of the spot user in combination with the number of missing numbers.
[0075] Step 1032: Mark the running status of the spot user as not being processed yet.
[0076] Mark the spot user as temporarily unprocessed and obtain the running status of the spot user for the day.
[0077] Step 1033: determine whether the number of times the spot user is out of stock is 0; if the number of times the spot user is out of stock is 0, execute step 1034. If the number of times the spot user is out of stock is not 0, execute step 1035.
[0078] It is determined whether the number of missing numbers of a spot user is 0 to distinguish whether there is any missing in the table code data of the spot user. If the number of missing numbers of a spot user is 0, it means that the table code data of the spot user is not missing and there is no abnormal condition. Step 1034 is executed to mark the operating status marked by the spot user as normal. If the number of missing numbers of a spot user is not 0, it means that the table code data of the spot user is missing due to some faults or abnormalities. Step 1035 is executed to further determine the corresponding operating status of the spot user in combination with the operating data in the metering automation system.
[0079] Step 1034: Mark the running status of the spot user as normal.
[0080] Mark the spot user as normal and obtain the running status of the spot user on that day.
[0081] Step 1035: Determine the operating status corresponding to the spot user according to the operating data in the metering automation system.
[0082] The operating data in the metering automation system at least includes whether there is a power outage alarm information for spot users on that day, whether they are always online, the offline time, the system meter visibility, the call-back progress, etc.
[0083] When the number of missing times of the spot user is not 0, it is necessary to further determine the corresponding operating status of the spot user according to the operating data in the metering automation system, and determine the fault or abnormal reason causing the number of missing times of the spot user to be not 0.
[0084] It should be noted that the operating data in the above embodiment is an exemplary description of the embodiment of the present invention. In other embodiments of the present invention, other operating data may also be included, and the present invention is not limited here.
[0085] In some embodiments of the present invention, step 1035 includes:
[0086] According to the operation data in the metering automation system, the reasons why the number of shortages of spot users on the same day is not 0 are determined, and the abnormal information and alarm information in the operation data are matched with the operation status one by one, and the operation status of the spot users is marked. No manual judgment is required, and the operation status of all spot users can be judged at one time, which is convenient for operation, improves efficiency and intuitiveness of data.
[0087] If the operation data contains abnormal terminal power outage alarm information, execute step 10351; if the operation data contains abnormal terminal offline information, execute step 10352; if the operation data contains abnormal system meter synchronization information, execute step 10353; if the operation data shows that the terminal is always in real-time online status and there is no abnormal information, execute step 10354; if the operation data shows that the terminal returns offline abnormal information or the terminal returns data abnormal information during the supplementary call process, execute step 10355.
[0088] Step 10351: If there is a power outage alarm mark at a certain missing time, the operating status of the spot user is marked as a power outage alarm abnormal status.
[0089] If the operation data contains abnormal terminal power outage alarm information, the spot user is marked as abnormal power outage alarm status, and the operation status of the spot user on that day is obtained.
[0090] Step 10352: Mark the spot user's operating status as the real-time offline status of the terminal.
[0091] If the operation data contains abnormal information of terminal real-time offline, the spot user is marked as the terminal real-time offline status, and the operation status of the spot user on that day is obtained.
[0092] Step 10353: Mark the spot user's operating status as an abnormal meter clock status.
[0093] If the operation data contains abnormal information about the time synchronization of the system electric meter, the spot user is marked as having an abnormal electric meter clock condition, and the operation condition of the spot user on that day is obtained.
[0094] Step 10354: Mark the spot user's operating status as the background supplementary call data status.
[0095] If the operation data shows that the terminal is always in real-time online status and there is no abnormal information, the spot user is marked as background supplementary call data status, and the operation status of the spot user on that day is obtained.
[0096] Step 10355: Mark the spot user's operating status as online replenishment failure status.
[0097] If the operation data shows that the terminal returns offline abnormal information or the terminal returns data abnormal information during the supplementary call process, the spot user is marked as an online supplementary call failure, and the operation status of the spot user on that day is obtained.
[0098] It should be noted that the operating conditions in the above-mentioned embodiments are exemplary descriptions of the embodiments of the present invention. In other embodiments of the present invention, other operating conditions may also be included, and the present invention is not limited here.
[0099] Step 104: Determine a corresponding processing method according to the operating status.
[0100] The processing method is preset and mapped to the operating status. The corresponding processing method is determined according to the operating status, and guiding processing opinions can be given quickly, which is convenient for relevant operation and maintenance personnel to follow up and handle the situation, thereby improving management efficiency.
[0101] In some embodiments of the present invention, step 104 includes:
[0102] Step 1041, determine the operating status of the spot user; if the operating status is normal, execute step 1042; if the operating status is not processed yet, execute step 1043; if the operating status is a power outage alarm abnormality, execute step 1044; if the operating status is a terminal real-time offline abnormality, execute step 1047; if the operating status is an electric meter clock abnormality, execute step 1048; if the operating status is a background supplementary call data status, execute step 1049; if the operating status is an online supplementary call failure status, execute step 10450.
[0103] According to the preset mapping relationship between the operating status and the processing method, the operating status of the spot user is judged and the corresponding processing method is determined.
[0104] Step 1042: Mark the corresponding spot user as a normal user.
[0105] The spot users whose operating status is normal are marked as normal users, which is used as the processing method for the spot users on that day.
[0106] Step 1043: Mark the corresponding spot user as a user not to be processed temporarily, and confirm that its fitted power is 0.
[0107] The spot users whose operating status is not being processed temporarily are marked as users who are not being processed temporarily, and their fitted power is determined to be 0, which is used as the processing method for the spot users on that day.
[0108] Step 1044, determine the cause of the abnormal power outage alarm condition; if the cause of the abnormal power outage alarm condition is that a power outage condition actually occurred at the missing time corresponding to the power outage alarm mark, execute step 1045; if the cause of the abnormal power outage alarm condition is a false power outage alarm, execute step 1046.
[0109] When the operating status of the spot user is an abnormal power outage alarm condition, the time corresponding to the missing number is sent to the power supply station to verify whether there is indeed a power outage. If a power outage does occur at the missing number time corresponding to the power outage alarm mark, step 1045 is executed to determine that the processing method for the spot user on that day is to enter the power outage event in the metering automation system and confirm that its fitted power quantity is 0, which is used as the processing method for the spot user on that day; if the power outage alarm is caused by a false power outage alarm, step 1046 is executed to determine that the processing method for the spot user on that day is to notify the operation and maintenance personnel to make up for the data corresponding to the spot user at the missing number time, and complete the missing data, which is used as the processing method for the spot user on that day.
[0110] Step 1045: Enter the power outage event into the metering automation system and confirm that the fitted power is 0.
[0111] Step 1046: Notify the operation and maintenance personnel to replenish the data of the spot users at the time when the data is missing.
[0112] Step 1047: Notify the operation and maintenance personnel to handle the terminal offline failure.
[0113] When the running status of the spot user is the real-time offline abnormal status of the terminal, it is determined that the processing method for the spot user on that day is to notify the operation and maintenance personnel to handle the terminal offline failure, which is used as the processing method for the spot user on that day.
[0114] Step 1048: Export the clock anomaly list and notify the operation and maintenance personnel to handle the meter clock anomaly failure.
[0115] When the operating status of the spot user is an abnormal meter clock status, it is determined that the processing method for the spot user on that day is to notify the operation and maintenance personnel to handle the abnormal meter clock failure, which is used as the processing method for the spot user on that day.
[0116] Step 1049: Notify the operation and maintenance personnel to recall and save the data.
[0117] When the running status of the spot user is the background supplementary data call status, the processing method for the spot user on that day is determined to be to notify the operation and maintenance personnel to supplement the data and save it, and to supplement the data at the corresponding time containing missing numbers in the table code data to complete the table code data, as the processing method for the spot user on that day.
[0118] Step 1050: Notify the operation and maintenance personnel to handle the make-up call failure.
[0119] When the running status of the spot user is an online supplementary call failure status, it is determined that the processing method for the spot user on that day is to notify the operation and maintenance personnel to handle the supplementary call failure fault, which is used as the processing method for the spot user on that day.
[0120] It should be noted that the processing methods corresponding to the operating conditions in the above embodiments are exemplary descriptions of the embodiments of the present invention. Other processing methods may also be included in other embodiments of the present invention, and the present invention is not limited thereto.
[0121] Step 105: Generate a spot user shortage elimination list based on the spot user's operating data, shortage times, operating status, and processing method.
[0122] The spot user's operating data, number of missing data, operating status and corresponding processing methods are aggregated to generate a spot user's missing data list. The spot user missing data list includes the user's operating data, number of missing data, operating status and processing methods for the day, allowing operation and maintenance personnel to quickly view the content that needs to be processed, and also facilitates monitoring personnel to follow up on the processing situation, and has an intuitive display of the operating data collected every day. The ability to quickly classify the operating status based on the data in the metering automation system and attach instructive processing methods greatly improves work efficiency and accuracy.
[0123] It should be noted that the contents included in the spot user deficiency elimination list in the above embodiment are illustrative descriptions of the embodiments of the present invention. In other embodiments of the present invention, other contents may be included, or some of the contents may not be included, and the present invention is not limited thereto.
[0124] It should be noted that, for the sake of simplicity, the method embodiments are described as a series of action combinations, but those skilled in the art should be aware that the embodiments of the present invention are not limited by the order of the actions described, because according to the embodiments of the present invention, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the embodiments of the present invention.
[0125] In this embodiment, according to the first spot user file data preset by the marketing system and the second spot user file data in the metering automation system, the abnormal user file list of the metering automation system is obtained; according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system, the number of missing numbers of the spot user is calculated; according to the first spot user file data, the operation data and the number of missing numbers in the metering automation system, the operation status corresponding to the spot user is determined; according to the operation status, the corresponding processing method is determined; according to the operation data, the number of missing numbers, the operation status and the processing method of the spot user, the spot user's missing list is generated. The collection status of the spot user on the day can be monitored and classified, and the daily operation status and processing method can be clearly grasped and displayed. All the collected data can obtain the operation status of all spot users at one time, and the abnormal situation and processing suggestions are marked, which is convenient for the relevant operation and maintenance personnel and supervisors to view the faults and suggestions that need to be handled, so as to handle and follow up in time, and improve the efficiency of management; and the operation data is updated in real time, and the guidance opinions of the spot user's missing list are highly accurate and real-time.
[0126] Embodiment 2
[0127] Figure 2A structural block diagram of a power spot transaction data monitoring and analysis device provided in Embodiment 2 of the present invention may specifically include the following modules:
[0128] The abnormal user file list determination module 201 is used to obtain the abnormal user file list of the metering automation system according to the first spot user file data preset by the marketing system and the second spot user file data in the metering automation system;
[0129] In some embodiments of the present invention, the abnormal user profile list determination module 201 includes:
[0130] A first spot user profile data acquisition submodule, used to acquire the first spot user profile data preset by the marketing system;
[0131] A second spot user file data acquisition submodule, used to acquire second spot user file data in the metering automation system;
[0132] The abnormal user file list generating submodule is used to compare the first spot user file data with the second spot user file data with the metering point number as the key field to obtain the abnormal user file list of the metering automation system.
[0133] A missing number calculation module 202, configured to calculate the missing number of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system;
[0134] In some embodiments of the present invention, the missing number calculation module 202 includes:
[0135] An acceptance status type acquisition submodule, used to acquire the acceptance status type of the spot user in the metering automation system;
[0136] An acceptance status type judgment submodule, used to judge the acceptance status type of the spot user;
[0137] A curve table code data acquisition submodule, used to determine that the table code type of the spot user is a curve table code, and acquire the curve table code data corresponding to the spot user as the table code data;
[0138] A real-time table code data acquisition submodule, used to determine that the table code type of the spot user is a real-time table code, and acquire the real-time table code data corresponding to the spot user as the table code data;
[0139] The number of missing numbers calculation submodule is used to calculate the number of missing numbers of the spot user according to the table code data.
[0140] In some embodiments of the present invention, the missing number calculation submodule includes:
[0141] A table code data statistics unit, used to count the number of positive and negative active power and the number of positive and negative reactive power of the table code data;
[0142] The missing number calculation unit is used to use the preset total number of forward and reverse records, the forward and reverse active times, and the forward and reverse reactive times to calculate the missing number by the following formula:
[0143] Missing times = total number of forward and reverse records - forward and reverse active times - forward and reverse reactive times
[0144] The preset total number of forward and reverse records is the total number of forward and reverse active power and forward and reverse reactive power when the metering automation system can count normally.
[0145] In some embodiments of the present invention, the missing number calculation submodule includes:
[0146] The missing number acquisition unit is used to use the defect query function preset in the metering automation system to acquire the missing number of the spot user.
[0147] The operation status analysis module 203 is used to determine the operation status corresponding to the spot user according to the first spot user file data, the operation data in the metering automation system and the number of missing data;
[0148] A condition judgment submodule for a status of not processing temporarily, used for judging whether the user satisfies a preset condition that the user is in a status of not processing temporarily according to the first spot user profile data;
[0149] A "not-processed-temporarily" status marking submodule, used to mark the operating status of the spot user as "not-processed-temporarily";
[0150] A number-of-missing-numbers judging submodule, used to judge whether the number-of-missing-numbers of the spot user is 0;
[0151] A normal status marking submodule, used to mark the operating status of the spot user as normal;
[0152] The operating status judgment submodule is used to determine the operating status corresponding to the spot user according to the operating data in the metering automation system.
[0153] In some embodiments of the present invention, the operation status judgment submodule includes:
[0154] A power outage alarm abnormal condition marking unit, used for marking the operating condition of the spot user as a power outage alarm abnormal condition when a power outage alarm mark exists at a certain missing data moment;
[0155] A terminal real-time offline status marking unit, used to mark the operating status of the spot user as a terminal real-time offline status;
[0156] An electric meter clock abnormality marking unit, used for marking the operating condition of the spot user as an electric meter clock abnormality;
[0157] A background supplementary call data status marking unit, used to mark the operating status of the spot user as a background supplementary call data status;
[0158] The online replenishment call failure status marking unit is used to mark the operating status of the spot user as an online replenishment call failure status.
[0159] A processing method determination module 204, used to determine a corresponding processing method according to the operating status;
[0160] An operation status judgment submodule, used to judge the operation status of the spot user;
[0161] A normal status processing submodule, used for marking the corresponding spot user as a normal user;
[0162] The temporary non-processing status processing submodule is used to mark the corresponding spot user as a temporary non-processing user and confirm that its fitted power is 0;
[0163] A power outage alarm abnormal condition cause determination submodule, used to determine the cause of the power outage alarm abnormal condition;
[0164] A first power outage alarm abnormal condition processing submodule is used to record a power outage event in the metering automation system and confirm that the fitted power quantity is 0;
[0165] The second power outage alarm abnormal condition processing submodule is used to notify the operation and maintenance personnel to make up for the data corresponding to the spot user at the time of the shortage;
[0166] The terminal real-time offline abnormal condition processing submodule is used to notify the operation and maintenance personnel to handle the terminal offline failure;
[0167] The meter clock abnormality processing submodule is used to export the clock abnormality list and notify the operation and maintenance personnel to handle the meter clock abnormality failure;
[0168] The backend supplementary call data status processing submodule is used to notify the operation and maintenance personnel to perform data supplementary call and storage work;
[0169] The online make-up call failure processing submodule is used to notify the operation and maintenance personnel to handle the make-up call failure failure.
[0170] The spot user defect elimination list generation module 205 is used to generate a spot user defect elimination list according to the operating data of the spot user, the number of defects, the operating status and the processing method.
[0171] The power spot transaction data monitoring and analysis device provided in the embodiment of the present invention can execute the power spot transaction data monitoring and analysis method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.
[0172] Embodiment 3
[0173] Figure 3 A schematic diagram of the structure of a computer device provided in Embodiment 3 of the present invention. Figure 3 A block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention is shown. Figure 3 The computer device 12 shown is only an example and should not bring any limitation to the functions and scope of use of the embodiments of the present invention.
[0174] like Figure 3 As shown, the computer device 12 is in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, and a bus 18 that connects various system components (including the system memory 28 and the processing unit 16).
[0175] Bus 18 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, an accelerated graphics port, a processor or a local bus using any of a variety of bus architectures. By way of example, these architectures include, but are not limited to, an Industry Standard Architecture (ISA) bus, a Micro Channel Architecture (MAC) bus, an Enhanced ISA bus, a Video Electronics Standards Association (VESA) local bus, and a Peripheral Component Interconnect (PCI) bus.
[0176] The computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 12, including volatile and non-volatile media, removable and non-removable media.
[0177] The system memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. The computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 34 may be used to read and write non-removable, non-volatile magnetic media ( Figure 3 not shown, usually called a "hard drive"). Although Figure 3Not shown in the figure, a disk drive for reading and writing to a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing to a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 18 via one or more data medium interfaces. The memory 28 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.
[0178] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in the memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment. The program modules 42 generally perform the functions and / or methods of the embodiments described herein.
[0179] The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboards, pointing devices, displays 24, etc.), may communicate with one or more devices that enable a user to interact with the computer device 12, and / or may communicate with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network cards, modems, etc.). Such communication may be performed via an input / output (I / O) interface 22. Furthermore, the computer device 12 may also communicate with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and / or public networks, such as the Internet) via a network adapter 20. As shown, the network adapter 20 communicates with other modules of the computer device 12 via a bus 18. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the computer device 12, including, but not limited to, microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0180] The processing unit 16 executes various functional applications and data processing by running the programs stored in the system memory 28, such as implementing the power spot transaction data monitoring and analysis method provided in the embodiment of the present invention.
[0181] Embodiment 4
[0182] Embodiment 4 of the present invention further provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the various processes of the above-mentioned electricity spot trading data monitoring and analysis method are implemented, and the same technical effect can be achieved. To avoid repetition, it will not be repeated here.
[0183] Among them, computer-readable storage media may include, for example, but are not limited to, electrical, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or devices, or any combination of the above. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection with one or more wires, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the above. In this document, a computer-readable storage medium may be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, device or device.
[0184] Note that the above are only preferred embodiments of the present invention and the technical principles used. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and that various obvious changes, readjustments and substitutions can be made by those skilled in the art without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in more detail through the above embodiments, the present invention is not limited to the above embodiments, and may include more other equivalent embodiments without departing from the concept of the present invention, and the scope of the present invention is determined by the scope of the appended claims.
Claims
1. A method for monitoring and analyzing power spot transaction data, characterized in that: include: According to the first spot user file data preset in the marketing system and the second spot user file data in the metering automation system, a list of abnormal user files of the metering automation system is obtained; Calculate the number of missing items of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system; Determine the operating status corresponding to the spot user according to the first spot user file data, the operating data in the metering automation system and the number of missing numbers; Determine a corresponding processing method according to the operating status; Generate a spot user shortage elimination list according to the spot user's operation data, the shortage times, the operation status and the processing method; Wherein, determining the operating status corresponding to the spot user according to the first spot user file data, the operating data in the metering automation system and the number of missing data includes: Determining whether the user meets the preset condition that the spot user is in a temporarily unprocessed state according to the first spot user profile data; If yes, then mark the operation status of the spot user as a temporary unprocessed status; If not, determining whether the number of times the spot user is short of a certain number is 0; If the number of times the spot user is short of a number is 0, the operating status of the spot user is marked as normal; If the number of missing numbers of the spot user is not 0, determining the operating status corresponding to the spot user according to the operating data in the metering automation system; Wherein, determining the operating status corresponding to the spot user according to the operating data in the metering automation system includes: If the operation data contains abnormal terminal power outage alarm information, and there is a power outage alarm mark at a certain missing data moment, the operation status of the spot user is marked as abnormal power outage alarm status; If the operation data contains abnormal information of terminal real-time offline, marking the operation status of the spot user as the terminal real-time offline status; If the operation data contains abnormal time synchronization information of the system electric meter, the operation status of the spot user is marked as an abnormal status of the electric meter clock; If the operation data shows that the terminal is always in real-time online status and there is no abnormal information, then the operation status of the spot user is marked as the background call data status; If the operation data shows that the terminal returns offline abnormal information or the terminal returns data abnormal information during the replenishment call process, the operation status of the spot user is marked as an online replenishment call failure status; Wherein, determining a corresponding processing method according to the operating status includes: Determining the operating status of the spot user; If the operating status is the normal status, marking the corresponding spot user as a normal user; If the operating status is the temporarily unprocessed status, the corresponding spot user is marked as a temporarily unprocessed user, and its fitted power is confirmed to be 0; If the operating condition is the power outage alarm abnormal condition, determining the cause of the power outage alarm abnormal condition; If the cause of the abnormal power outage alarm condition is that a power outage condition actually occurred at the missing time corresponding to the power outage alarm mark, then a power outage event is recorded in the metering automation system to confirm that the fitted power quantity is 0; If the cause of the abnormal power outage alarm is a false power outage alarm, the operation and maintenance personnel are notified to make up for the data corresponding to the spot user at the time of missing data; If the operating status is an abnormal terminal offline status, the operation and maintenance personnel are notified to handle the terminal offline fault; If the operating condition is an abnormal condition of the electric meter clock, a clock abnormality list is exported to notify the operation and maintenance personnel to handle the abnormal fault of the electric meter clock; If the operating status is a background data call status, the operation and maintenance personnel are notified to call and save the data; If the operating status is an online make-up call failure status, the operation and maintenance personnel are notified to handle the make-up call failure fault.
2. The method according to claim 1, characterized in that The abnormal user file list of the metering automation system is obtained according to the first spot user file data preset by the marketing system and the second spot user file data in the metering automation system, including: Acquire the first spot user profile data preset by the marketing system; Acquire the second spot user profile data in the metering automation system; The first spot user file data is compared with the second spot user file data with the metering point number as a key field to obtain an abnormal user file list of the metering automation system.
3. The method according to claim 1, characterized in that Calculating the number of missing items of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system includes: Acquire the acceptance status type of the spot user in the metering automation system; Determining the acceptance status type of the spot user; If the acceptance status type is acceptance success, determining that the table code type of the spot user is a curve table code, and obtaining the curve table code data corresponding to the spot user as the table code data; If the acceptance status type is acceptance failure, determining that the table code type of the spot user is a real-time table code, and obtaining the real-time table code data corresponding to the spot user as the table code data; The number of times the spot user is short of goods is calculated according to the table code data.
4. The method according to claim 3, characterized in that Calculating the number of times the spot user is out of stock according to the table code data includes: Counting the number of positive and negative active power and the number of positive and negative reactive power of the table code data; The preset total number of forward and reverse records, the forward and reverse active times, and the forward and reverse reactive times are used to calculate the missing times by the following formula: Number of missing numbers = total number of forward and reverse records - number of forward and reverse active numbers - number of forward and reverse reactive numbers. The preset total number of forward and reverse records is the total number of forward and reverse active numbers and forward and reverse reactive numbers when the metering automation system can count normally.
5. The method according to claim 3, characterized in that: Calculating the number of times the spot user is out of stock according to the table code data includes: The shortage query function preset in the metering automation system is used to obtain the shortage times of the spot user.
6. A device for monitoring and analyzing electricity spot trading data, characterized in that: include: An abnormal user profile list determination module is used to obtain an abnormal user profile list of the metering automation system according to the first spot user profile data preset by the marketing system and the second spot user profile data in the metering automation system; A missing number calculation module, used for calculating the missing number of the spot user according to the abnormal user file list and the acceptance status type of the spot user in the metering automation system; An operation status analysis module, used to determine the operation status corresponding to the spot user according to the first spot user file data, the operation data in the metering automation system and the number of missing data; A processing method determination module, used to determine a corresponding processing method according to the operating status; A spot user shortage elimination list generation module is used to generate a spot user shortage elimination list according to the operation data of the spot user, the shortage number, the operation status and the processing method; Wherein, the operation status analysis module is specifically used for: Determining whether the user meets the preset condition that the spot user is in a temporarily unprocessed state according to the first spot user profile data; If yes, then mark the operation status of the spot user as a temporary unprocessed status; If not, determining whether the number of times the spot user is short of a certain number is 0; If the number of times the spot user is short of a number is 0, the operating status of the spot user is marked as normal; If the number of missing numbers of the spot user is not 0, determining the operating status corresponding to the spot user according to the operating data in the metering automation system; Wherein, the operation status analysis module is also used for: If the operation data contains abnormal terminal power outage alarm information, and there is a power outage alarm mark at a certain missing data moment, the operation status of the spot user is marked as abnormal power outage alarm status; If the operation data contains abnormal information of terminal real-time offline, marking the operation status of the spot user as the terminal real-time offline status; If the operation data contains abnormal time synchronization information of the system electric meter, the operation status of the spot user is marked as an abnormal status of the electric meter clock; If the operation data shows that the terminal is always in real-time online status and there is no abnormal information, then the operation status of the spot user is marked as the background call data status; If the operation data shows that the terminal returns offline abnormal information or the terminal returns data abnormal information during the replenishment call process, the operation status of the spot user is marked as an online replenishment call failure status; Wherein, the processing method determination module is specifically used for: Determining the operating status of the spot user; If the operating status is the normal status, marking the corresponding spot user as a normal user; If the operating status is the temporarily unprocessed status, the corresponding spot user is marked as a temporarily unprocessed user, and its fitted power is confirmed to be 0; If the operating condition is the power outage alarm abnormal condition, determining the cause of the power outage alarm abnormal condition; If the cause of the abnormal power outage alarm condition is that a power outage condition actually occurred at the missing time corresponding to the power outage alarm mark, then a power outage event is recorded in the metering automation system to confirm that the fitted power quantity is 0; If the cause of the abnormal power outage alarm is a false power outage alarm, the operation and maintenance personnel are notified to make up for the data corresponding to the spot user at the time of missing data; If the operating status is an abnormal terminal offline status, the operation and maintenance personnel are notified to handle the terminal offline fault; If the operating condition is an abnormal condition of the electric meter clock, a clock abnormality list is exported to notify the operation and maintenance personnel to handle the abnormal fault of the electric meter clock; If the operating status is a background data call status, the operation and maintenance personnel are notified to call and save the data; If the operating status is an online make-up call failure status, the operation and maintenance personnel are notified to handle the make-up call failure fault.
7. A computer device, characterized in that: The computer device comprises: one or more processors; a memory for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the power spot transaction data monitoring and analysis method as described in any one of claims 1-5.
Citation Information
Patent Citations
Line-loss anomaly detection method for electric power measurement automation system
CN105588995A
Electric power measurement automation system terminal device abnormity monitoring method and device
CN106772205A
Intelligent diagnosis and analysis method and system for line loss of low-voltage transformer area
CN113267692A
