Resource consumption data processing device and method

Abstract

The invention discloses a resource consumption data processing device and method. The device periodically acquires public resource consumption data and user resource consumption data through a data acquisition module; judging whether the two types of resource consumption data are abnormal or not through an abnormality judgment module; classifying each user table into a non-apportioned user table and an apportioned user table through an apportioned sharing screening module; calculating public resource allocation data of each allocation user table in a first period through a public sharing calculation module according to the public resource consumption data and the user resource consumption data of the allocation user tables; summarizing the shared data of the public resources through a visual summarizing module, and performing zero setting on the data to which the non-shared user table belongs to generate a resource consumption table; and in response to a user request, returning the target data from the resource consumption table to the user side for display. The calculation efficiency and accuracy are effectively improved, the shared power consumption is adaptively adjusted according to the power consumption conditions of various users, and the user experience is improved.

Description

Technical Field

[0001] The present invention relates to the technical field of data statistics, and in particular to a device and method for processing resource consumption data. Background Art

[0002] With the development of big data and cloud technologies, data from departments and enterprises are no longer independent of each other, but can be interconnected and shared. The World Bank's latest B-Ready assessment system has also changed the original BD system of obtaining electricity to municipal public basic services (electricity, water, and the Internet), emphasizing the importance of the integration and improvement of public facilities. The calculation and allocation of water pump electricity charges based on the water consumption data returned by the water supply company is more in line with the development requirements of society.

[0003] According to the existing public electricity bill settlement rules, the public electricity bill for water pumps, elevators and staircase lights is usually shared by public transformer users who use one meter per household. For example, if the monthly public electricity consumption exceeds 6 kWh, the user must participate in the full monthly sharing of the building. However, since some users live in the building for a short period of time each month and use very little electricity and water, they need to share the same public electricity bill with users who use more electricity. The sharing plan does not fit the actual electricity and water consumption.

[0004] In the prior art, the problem of uneven allocation can usually only be solved through manual review and calculation. After obtaining monthly or annual data, unified calculations are performed and returns are made in response to user requests. The calculation efficiency is low and errors are prone to occur. Summary of the invention

[0005] The present invention provides a device and method for processing resource consumption data, which solves the technical problem that the existing imbalanced allocation can only be calculated by manual audit calculation, which has low calculation efficiency and is prone to errors.

[0006] The present invention provides a resource consumption data processing device, comprising a data acquisition module, an abnormality identification module, a common pool screening module, a common pool calculation module and a visualization summary module which are sequentially connected in communication;

[0007] The data acquisition module is used to acquire the public resource consumption data collected by the common pool table and the user resource consumption data collected by each user table according to the first period;

[0008] The abnormality determination module is used to determine whether there are abnormalities in the user resource consumption data and the public resource consumption data;

[0009] The common allocation screening module is used to classify each user table into a non-allocation user table and an allocation user table according to the comparison result of each user resource consumption data and a preset allocation threshold value if there is no abnormality;

[0010] The shared resource calculation module is used to calculate the shared resource sharing data of each shared user table in the first period according to the shared resource consumption data and the user resource consumption data corresponding to the shared user table;

[0011] The visualization summary module is used to summarize the public resource allocation data according to the second period, and reset the public resource allocation data belonging to the non-allocated user table to zero to generate a resource consumption table; respond to user requests sent by the user terminal, and return corresponding target data from the resource consumption table to the user terminal for display.

[0012] Optionally, the user table includes a user electricity meter and a user water meter, and the user resource consumption data includes user electricity consumption and user water consumption;

[0013] The public resource consumption data includes the total power consumption of public equipment, the total power consumption of elevators and the total power consumption of water pumps.

[0014] Optionally, the abnormality identification module is specifically used to:

[0015] Calculating a first difference percentage between user resource consumption data of two adjacent first cycles, and a second difference percentage between public resource consumption data of two adjacent first cycles;

[0016] If the first difference percentage or the second difference percentage exceeds a preset abnormal threshold, the data acquisition module is called again to collect new user resource consumption data or new public resource consumption data;

[0017] If the first difference percentage and the second difference percentage do not exceed the preset abnormal threshold, it is determined that there is no abnormality in the user resource consumption data and the public resource consumption data of the current period.

[0018] Optionally, the apportionment threshold includes an electricity apportionment threshold and a water apportionment threshold; and the public apportionment screening module is specifically used to:

[0019] Comparing the user's power consumption with the power consumption sharing threshold;

[0020] If the user's electricity consumption exceeds the electricity consumption sharing threshold, the user's electricity meter is classified as a sharing user meter;

[0021] If the user's electricity consumption does not exceed the electricity consumption sharing threshold, the user's electricity meter is classified as a non-shared user meter;

[0022] Comparing the user's water consumption with the water consumption apportionment threshold;

[0023] If the user's water consumption is not equal to the water consumption apportionment threshold, classifying the user's water meter into an apportionment user table;

[0024] If the user's water consumption is equal to the water consumption apportionment threshold, the user's water meter is classified as a non-apportionment user meter.

[0025] Optionally, the public resource sharing data includes the public equipment shared electricity, the elevator shared electricity and the water pump shared electricity; the shared electricity calculation module includes a public equipment shared electricity calculation submodule, an elevator shared electricity calculation submodule and a water pump shared electricity calculation submodule;

[0026] The public equipment shared calculation submodule is used to calculate the ratio between the total power consumption of the public equipment and the number of the shared user tables, and obtain the public equipment shared power consumption of each of the shared user tables in the first period;

[0027] The elevator shared electricity calculation submodule is used to construct weights according to the floors to which each shared user table belongs, and use the weights to calculate the weighted sum of the number of shared user tables on each floor; after calculating the ratio between the total elevator electricity consumption and the weighted sum, calculate the multiplication value between each weight to obtain the elevator shared electricity of each shared user table in the first period;

[0028] The water pump shared electricity calculation submodule is used to respectively calculate the multiplication value between the water proportion occupied by each user's water consumption and the total electricity consumption of the water pump, so as to obtain the water pump shared electricity of each shared user table in the first period.

[0029] Optionally, the visualization summary module includes a data summary submodule and a visualization display submodule;

[0030] The data aggregation submodule is used to aggregate the public resource allocation data according to a second period, and reset the public resource allocation data belonging to the non-allocation user table to zero, to generate a resource consumption table; the second period is greater than the first period;

[0031] The visualization display submodule is used to locate the target data corresponding to the user request from the resource consumption table when receiving the user request, and return it to the user end for display.

[0032] Optionally, the data aggregation submodule is specifically used to:

[0033] Creating an initial consumption table corresponding to the first period;

[0034] Summarizing the corresponding public resource allocation data based on the allocation user table;

[0035] According to the shared electricity consumption and the shared water consumption, the public resource sharing data belonging to the non-shared user table is set to zero, so as to obtain an intermediate consumption table corresponding to the first period;

[0036] Taking the apportionment user table as a unit, calculating the user apportionment and value of the public resource apportionment data in the second period;

[0037] All the intermediate consumption tables are summarized according to the second period and the preset timing and the user allocation and value are loaded to generate a resource consumption table.

[0038] Optionally, the visual display submodule is specifically used to:

[0039] Monitor in real time whether a user request sent by the user end is received;

[0040] When receiving the user request, retrieving the resource consumption table according to the user request;

[0041] Extracting the target data corresponding to the user request from the resource consumption table and returning it to the user terminal for display;

[0042] The target data includes the user allocation and value and the public resource allocation data.

[0043] Optionally, the user terminal is a website, an APP or a mini program;

[0044] The user terminal is used to load the user identification corresponding to the user terminal, the user allocation and value, and the public resource allocation data into the target container respectively, and generate a target page for display.

[0045] The present invention also provides a method for processing resource consumption data, comprising:

[0046] Obtain the public resource consumption data collected by the common pool meter and the user resource consumption data collected by each user meter according to the first cycle;

[0047] Determining whether the user resource consumption data and the public resource consumption data are abnormal;

[0048] If there are no abnormalities, then classify each user table into a non-allocation user table and an allocation user table according to the comparison result of each user resource consumption data and the preset allocation threshold;

[0049] Calculating the public resource allocation data of each of the shared user tables in the first period according to the public resource consumption data and the user resource consumption data corresponding to the shared user table;

[0050] Summarizing the public resource allocation data according to the second cycle, and setting the public resource allocation data belonging to the non-allocation user table to zero, to generate a resource consumption table;

[0051] In response to a user request sent by the user terminal, corresponding target data is returned from the resource consumption table to the user terminal for display.

[0052] It can be seen from the above technical solutions that the present invention has the following advantages:

[0053] The embodiment of the present application provides a device and method for processing resource consumption data, the device includes a data acquisition module, an abnormality identification module, a common pool screening module, a common pool calculation module and a visualization summary module which are communicatively connected in sequence; the data acquisition module acquires the public resource consumption data collected by the common pool table and the user resource consumption data collected by each user table according to the first cycle; the abnormality identification module determines whether there are abnormalities in the user resource consumption data and the public resource consumption data; if there are no abnormalities, the common pool screening module classifies each user table into a non-shared user table and a shared user table according to the comparison result of each user resource consumption data and a preset sharing threshold; the common pool calculation module calculates the public resource sharing data of each shared user table in the first cycle according to the public resource consumption data and the user resource consumption data corresponding to the shared user table; the visualization summary module summarizes the public resource sharing data according to the second cycle, and sets the public resource sharing data belonging to the non-shared user table to zero, so as to generate a resource consumption table; in response to a user request sent by a user terminal, the corresponding target data is returned from the resource consumption table to the user terminal for display. Therefore, through automatic data collection and calculation, the calculation efficiency and accuracy can be effectively improved. At the same time, the shared electricity consumption can be adaptively adjusted according to the electricity consumption of various users to improve the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0055] Figure 1 A structural block diagram of a device for processing resource consumption data provided by an embodiment of the present invention;

[0056] Figure 2 A detailed structural block diagram of a device for processing resource consumption data provided by an embodiment of the present invention;

[0057] Figure 3A flowchart of a method for processing resource consumption data provided by an embodiment of the present invention.

[0058] Figure numerals: 101, data acquisition module; 102, abnormality identification module; 103, common area screening module; 104, common area calculation module; 105, visualization summary module; 11, user table; 12, common area table; 111, user electricity meter; 112, user water meter; 1041, public equipment common area calculation submodule; 1042, elevator common area calculation submodule; 1043, water pump common area calculation submodule; 1051, data summary submodule; 1052, visualization display submodule. DETAILED DESCRIPTION

[0059] At present, the only judgment standard is that the monthly electricity consumption exceeds 6 kWh. The simple average apportionment of monthly public electricity consumption cannot meet the needs of each household with one meter for accurate metering and joint processing of big data of various public services. It is necessary to study and propose a public electricity sharing plan that is more in line with the actual water and electricity consumption to provide better electricity supply and use services.

[0060] To this end, an embodiment of the present invention provides a device and method for processing resource consumption data, which is used to solve the technical problem that the existing imbalanced allocation can only be calculated through manual review and calculation, which has low calculation efficiency and is prone to errors.

[0061] In order to make the purpose, features and advantages of the present invention more obvious and easy to understand, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the embodiments described below are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0062] See also Figure 1-2 , Figure 1 A structural block diagram of a device for processing resource consumption data provided by an embodiment of the present invention, Figure 2 A detailed structural block diagram of a device for processing resource consumption data provided by an embodiment of the present invention.

[0063] The present invention provides a resource consumption data processing device, comprising a data acquisition module 101, an abnormality identification module 102, a common pool screening module 103, a common pool calculation module 104 and a visualization summary module 105, which are sequentially connected in communication;

[0064] The data acquisition module 101 is used to acquire the public resource consumption data collected by the common table 12 and the user resource consumption data collected by each user table 11 according to the first cycle;

[0065] Anomaly determination module 102, used to determine whether there are anomalies in user resource consumption data and public resource consumption data;

[0066] The shared-pool screening module 103 is used to classify each user table 11 into a non-shared user table and a shared user table according to the comparison result of each user's resource consumption data and a preset shared threshold value if there is no abnormality;

[0067] A common resource calculation module 104 is used to calculate common resource allocation data of each shared user table in the first period according to the common resource consumption data and the user resource consumption data corresponding to the shared user table;

[0068] The visualization summary module 105 is used to summarize the public resource allocation data according to the second period, and set the public allocation to zero for the non-allocated user table to generate a resource consumption table; respond to the user request sent by the user end, and return the corresponding target data from the resource consumption table to the user end for display.

[0069] The public meter 12 refers to the electricity meter used by all users in a certain area, which is used to measure the power consumption of various public resource equipment in the public area, including but not limited to elevators, corridor lighting, public corridors, regional street lights, monitoring centers, water pumps and fire control rooms, etc. The user meter 11 includes an electricity meter that measures the power consumption of a single user and a water meter that measures the water consumption of a single user.

[0070] Public resource consumption data refers to the power consumption of various public resource equipment, such as elevators, corridor lighting or water pumps.

[0071] User resource consumption data mainly includes the electricity and water consumption used by each user within a certain period.

[0072] In this embodiment, the device is respectively connected to the common meter 12 and multiple user meters 11 in communication, so as to simultaneously obtain the resource consumption data collected by the common meter 12 and the user meter 11, as the data basis for subsequent calculations. Specifically, taking the first cycle as one day as an example, in daily use, the electricity meter reading and water meter reading at zero o'clock every day are obtained through the common meter 12 and the user meter 11, respectively, and the electricity meter reading and water meter reading at zero o'clock of the previous day are combined to calculate the public resource consumption data such as public electricity consumption, and the user resource consumption data such as user water consumption and user electricity consumption. Among them, the public electricity consumption may include the total electricity consumption of public equipment, the total electricity consumption of elevators, and the total electricity consumption of water pumps.

[0073] After the data acquisition module 101 obtains the public electricity consumption, user water consumption and user electricity consumption collected by the common meter 12 and the user meter 11, in order to avoid errors in the common calculation caused by data anomalies, the above data can be further sent to the abnormality judgment module 102 for abnormality judgment to determine whether there are abnormalities in the user resource consumption data and the public resource consumption data. Specifically, the user resource consumption data and public resource consumption data of two consecutive days are used to calculate the corresponding difference percentages respectively, and compared with the preset abnormal threshold value, and whether the difference percentage exceeds the abnormal threshold value is used to determine whether there is an abnormality in the user resource consumption data or the public resource consumption data. The public resource consumption data may increase or decrease suddenly due to special circumstances, such as when a user moves, the number of times the elevator and corridor lighting are used increases; when a user goes out, the water pump electricity consumption decreases, etc. When setting the abnormal threshold, it can be set according to a longer historical time period, such as public resource consumption data for half a year or a year.

[0074] After the user resource consumption data and the public resource consumption data pass the abnormal judgment of the abnormal judgment module 102, the user resource consumption data is transmitted to the common screening module 103 for further screening and processing. Specifically, the common screening module 103 uses the user table 11 as a unit, and uses each group of user resource consumption data to compare with the preset apportionment threshold, so as to classify each user table 11 into a non-apportioned user table and an apportioned user table, so as to screen the user resource data that needs to be processed by the common calculation module 104. Among them, the apportioned user table refers to the user table 11 that needs to participate in the apportionment of the public resource consumption data. The non-apportioned user table refers to the user table 11 that does not need to participate in the public resource consumption data apportionment when the daily electricity consumption is less than the apportionment threshold, and / or the daily water consumption is zero.

[0075] After the shared screening module 103 completes the screening of the user table 11, the shared calculation module 104 uses the public resource consumption data and the user resource consumption data corresponding to the shared user table to perform the next shared calculation. For example, since the power consumption of an elevator is usually related to the floor height, it can be weighted according to the floor to which the shared user table belongs and the number of users on the floor, so as to calculate the shared power of the elevator. For public equipment such as elevator lights that are not related to the floor, the calculation scheme for shared power can directly obtain the public resource sharing data of each shared user table in the first cycle according to the ratio of the public resource consumption data to the total number of shared user tables. For the shared power consumption of the water pump, it can be calculated according to the ratio of the water consumption obtained by each shared user table to the total water consumption. After the public resource sharing data is calculated, it is transmitted to the visualization summary module 105.

[0076] The visualization summary module 105 summarizes the public resource allocation data according to the second cycle. At the same time, since the public allocation of the user represented by the non-allocation user table in the first cycle is zero, the public resource allocation data is set to zero at this time, thereby generating a resource consumption table. The visualization summary module 105 responds to the user request sent by the user terminal and returns the corresponding target data from the resource consumption table to the user terminal for display.

[0077] The first cycle may be one day, and the second cycle may be one month.

[0078] It should be noted that the user meter 11 includes a user electricity meter 111 and a user water meter 112 , and the user resource consumption data includes the user electricity consumption and the user water consumption;

[0079] Public resource consumption data includes total electricity consumption of public equipment, total electricity consumption of elevators and total electricity consumption of water pumps.

[0080] Optionally, the abnormality identification module 102 is specifically configured to:

[0081] Calculating a first difference percentage between user resource consumption data of two adjacent first cycles, and a second difference percentage between public resource consumption data of two adjacent first cycles;

[0082] If the first difference percentage or the second difference percentage exceeds the preset abnormal threshold, the data acquisition module 101 is called again to collect new user resource consumption data or new public resource consumption data;

[0083] If the first difference percentage and the second difference percentage do not exceed the preset abnormal threshold, it is determined that there is no abnormality in the user resource consumption data and the public resource consumption data of the current period.

[0084] In a specific implementation, for the user's electricity consumption in the first cycle of one day, it is first determined whether the difference between the user's electricity consumption on that day and the user's electricity consumption on previous days / the first difference percentage of the total user electricity consumption on that day exceeds the abnormal threshold N1. If exceeded, it is sent back to the data acquisition module 101 to re-acquire data or alarm manual processing, and after processing, it is determined again whether there is an abnormality; if not exceeded, it is determined that no abnormality has occurred, and the user's electricity consumption is sent to the shared screening module 103 for further processing.

[0085] For the user's water consumption in the first cycle of one day, first determine whether the difference between the user's water consumption on that day and the user's water consumption in previous days / the first difference percentage of the total user water consumption exceeds the abnormal threshold N2. If exceeded, it is sent back to the data acquisition module 101 or the user's water meter 112 to re-read the data or manually process the alarm. After processing, it is determined again whether there is an abnormality; if not exceeded, it is determined that no abnormality has occurred, and the user's water consumption is sent to the shared screening module 103 for further processing.

[0086] The abnormal judgment of the total power consumption of public equipment, the total power consumption of elevators and the total power consumption of water pumps in the public resource consumption data is similar to the above-mentioned user resource consumption data, and will not be repeated here. When it is determined at the same time that the first difference percentage and the second difference percentage do not exceed the preset abnormal threshold, it indicates that there is no abnormality in the user resource consumption data and the public resource consumption data in the first cycle, and the data can continue to be sent to the common screening module for further data processing.

[0087] In addition, if the number of calls to the data acquisition module 101 reaches a certain threshold, or the number of daily collections of the user table 11 and the shared table 12 reaches a certain threshold, an alarm message is directly output to notify the technician to continue processing.

[0088] Optionally, the sharing threshold includes an electricity sharing threshold and a water sharing threshold; the shared sharing screening module 103 is specifically used to:

[0089] Compare the user's electricity consumption with the electricity sharing threshold;

[0090] If the user's electricity consumption exceeds the electricity sharing threshold, the user's electricity meter 111 is classified as a shared user meter;

[0091] If the user's electricity consumption does not exceed the electricity consumption sharing threshold, the user's electricity meter 111 is classified as a non-shared user meter;

[0092] Compare user water consumption with water allocation thresholds;

[0093] If the user's water consumption is not equal to the water consumption apportionment threshold, the user water meter 112 is classified as an apportionment user table;

[0094] If the user's water consumption is equal to the water consumption apportionment threshold, the user water meter 112 is classified as a non-apportionment user meter.

[0095] Among them, the electricity sharing threshold includes the elevator sharing threshold and the elevator light sharing threshold, and the above thresholds can be equal.

[0096] In this embodiment, the user table 11 is used as a unit by the shared screening module 103 to compare the power consumption and water consumption of users without abnormalities one by one, so as to select the shared user table and its corresponding user water consumption and user power consumption. Specifically, for the power consumption of users that has been processed correctly, it is determined whether the user power consumption exceeds the threshold F1 for participating in the elevator and staircase light sharing. If it exceeds, the user table 11 is classified as the shared user table, and the user power consumption is sent to the shared calculation module 104; if it does not exceed, the user table 11 is classified as the non-shared user table, and the shared power of the elevator and staircase light on that day is set to zero, and it is sent to the visualization summary module 105 for summary and display.

[0097] For the user water consumption that has been processed correctly, it is determined whether the user water consumption is 0. If not, the user table 11 is classified as the shared user table, and the user water consumption is sent to the shared calculation module 104. If it is 0, the user table 11 is classified as the non-shared user table, and the shared power of the water pump on that day is set to zero, and it is sent to the visualization summary module 105 for summary and display.

[0098] In addition, the data in the non-allocated user table may be directly set to zero in the visualization summary module 105 to reduce data transmission costs.

[0099] Optionally, the public resource sharing data includes the public equipment shared electricity, the elevator shared electricity and the water pump shared electricity; the shared electricity calculation module 104 includes a public equipment shared electricity calculation submodule 1041, an elevator shared electricity calculation submodule 1042 and a water pump shared electricity calculation submodule 1043;

[0100] The public equipment shared calculation submodule 1041 is used to calculate the ratio between the total power consumption of the public equipment and the number of shared user tables, and obtain the public equipment shared power consumption of each shared user table in the first cycle;

[0101] The elevator shared electricity calculation submodule 1042 is used to construct weights according to the floors to which each shared user table belongs, and use the weights to calculate the weighted sum of the number of shared user tables on each floor; after calculating the ratio between the total elevator electricity consumption and the weighted sum, calculate the multiplication value between each weight to obtain the elevator shared electricity of each shared user table in the first cycle;

[0102] The water pump shared electricity calculation submodule 1043 is used to calculate the multiplication value between the water proportion occupied by each user's water consumption and the total power consumption of the water pump, and obtain the water pump shared electricity of each shared user table in the first cycle.

[0103] In the embodiment of the present application, for the calculation of the shared use of public equipment such as stair lamps and elevators, the shared use calculation module 104 can summarize the total power consumption of public equipment, the total power consumption of elevators, the power consumption of users and the profile information of power users provided by the shared use table 12. First, the number of users participating in the shared use of elevators and stair lamps on that day is counted based on the user power consumption data, and the profile floor information of the users participating in the shared use is matched. After the matching is completed, the daily shared power consumption of elevators and stair lamps for each household is calculated according to the formula.

[0104] For the daily shared electricity consumption of public equipment, the shared electricity consumption calculation submodule 1041 performs calculations in the following manner, for example, the shared electricity consumption of the ladder lamp of each shared user meter = the total electricity consumption of public equipment / the number of shared user meters.

[0105] As for the elevator shared electricity, the elevator shared electricity calculation submodule 1042 can be calculated in the following way: the user's daily shared electricity = {total elevator electricity consumption on that day / [the number of users participating in the first floor sharing x1 + the number of users participating in the second floor sharing x1.05 + ... + the number of users participating in the M-th floor sharing] .

[0106] As for the allocation of water pump electricity consumption, the water pump shared calculation submodule 1043 can summarize the total water pump electricity consumption and user water consumption collected by the shared table 12, first count the total number of users and total water consumption participating in the shared user table on that day, and then calculate the ratio of user water consumption to total water consumption, and then calculate the multiplication value between the ratio and the total water pump electricity consumption, to obtain the shared electricity consumption of the water pump in each shared user table in the first cycle.

[0107] Optionally, the visualization summary module 105 includes a data summary submodule 1051 and a visualization display submodule 1052;

[0108] The data aggregation submodule 1051 is used to aggregate the public resource allocation data according to the second period, and generate a resource consumption table for the public resource allocation data belonging to the non-allocated user table; the second period is greater than the first period;

[0109] The visualization display submodule 1052 is used to locate the target data corresponding to the user request from the resource consumption table when receiving the user request, and return it to the user end for display.

[0110] Furthermore, the data aggregation submodule 1051 is specifically used for:

[0111] Create an initial consumption table corresponding to the first cycle;

[0112] Summarize the corresponding public resource allocation data based on the allocation user table;

[0113] According to the shared electricity consumption and shared water consumption, the public resource sharing data belonging to the non-shared user table is set to zero, and the intermediate consumption table corresponding to the first period is obtained;

[0114] Taking the apportionment user table as the unit, calculate the user apportionment and value of the public resource apportionment data in the second period;

[0115] According to the second cycle and preset timing, all intermediate consumption tables are summarized and user allocations and values ​​are loaded to generate a resource consumption table.

[0116] In a specific implementation, the data aggregation submodule 1051 can be connected to the above-mentioned common screening module 103, the common equipment common calculation submodule 1041, the elevator common calculation submodule 1042 and the water pump common calculation submodule 1043 to receive the public resource apportionment data sent by them. Taking the second cycle as one month as an example, the data aggregation submodule 1051 creates an initial consumption table according to the date of the day, and creates a list with the name as the first column or the first row in the unit of the apportionment user table, and loads the corresponding public resource apportionment data in the corresponding column or row. After all the apportionment user tables are summarized, create a column or row with the name of the non-apportionment user table, set the public resource apportionment data of the row or column to zero, and obtain the intermediate consumption table corresponding to the first cycle.

[0117] At the same time, taking the apportioned user table as the unit, calculate the user apportioned sum value of various types of public resource apportionment data in the second period, such as the public equipment shared electricity, elevator shared electricity and water pump shared electricity, so as to obtain the shared electricity of each apportioned user table in each type of sharing in the current month. In addition, the sum of the apportioned sum values ​​of each user can also be calculated to obtain the shared electricity of each apportioned user table in the current month. Summarize all intermediate consumption tables according to the preset time sequence of date and load the user apportioned sum value to generate a monthly resource consumption table.

[0118] Furthermore, the visual display submodule 1052 is specifically used for:

[0119] Monitor in real time whether a user request sent by the user end is received;

[0120] When receiving a user request, retrieving the resource consumption table according to the user request;

[0121] Extract the target data corresponding to the user request from the resource consumption table and return it to the user end for display;

[0122] Among them, the target data includes user allocation and value and public resource allocation data.

[0123] In the embodiment of the present application, after the user's shared electricity consumption for the whole month is summarized and calculated on the 1st of the next month, the user sends a user request to the visualization display sub-module 1052 through the user terminal (including but not limited to the website, APP, official account applet, etc.) to query the daily electricity consumption distribution of the month and the electricity consumption of the three types of shared meters 12 (public equipment shared calculation sub-module 1041, elevator shared calculation sub-module 1042 and water pump shared calculation sub-module 1043).

[0124] Optionally, the user terminal is a website, an APP or a mini program.

[0125] The user side is used to load the user ID, user allocation and value and public resource allocation data corresponding to the user side into the target container respectively, and generate a target page for display.

[0126] In addition, after the public resource sharing data of each sharing user table is calculated, the corresponding shared expenses can be calculated according to the data combined with the electricity price to determine the public resource sharing expenses in the area.

[0127] The embodiment of the present application provides a device and method for processing resource consumption data, the device includes a data acquisition module, an abnormality identification module, a common pool screening module, a common pool calculation module and a visualization summary module which are communicatively connected in sequence; the data acquisition module acquires the public resource consumption data collected by the common pool table and the user resource consumption data collected by each user table according to the first cycle; the abnormality identification module determines whether there are abnormalities in the user resource consumption data and the public resource consumption data; if there are no abnormalities, the common pool screening module classifies each user table into a non-shared user table and a shared user table according to the comparison result of each user resource consumption data and a preset sharing threshold; the common pool calculation module calculates the public resource sharing data of each shared user table in the first cycle according to the public resource consumption data and the user resource consumption data corresponding to the shared user table; the visualization summary module summarizes the public resource sharing data according to the second cycle, and sets the public resource sharing data belonging to the non-shared user table to zero, so as to generate a resource consumption table; in response to a user request sent by a user terminal, the corresponding target data is returned from the resource consumption table to the user terminal for display. Therefore, through automatic data collection and calculation, the calculation efficiency and accuracy can be effectively improved. At the same time, the shared electricity consumption can be adaptively adjusted according to the electricity consumption of various users to improve the user experience.

[0128] See also Figure 3 , Figure 3 A flowchart showing the steps of a method for processing resource consumption data according to an embodiment of the present application is shown.

[0129] The present invention provides a method for processing resource consumption data, the method comprising:

[0130] Step 301, obtaining the public resource consumption data collected by the common table and the user resource consumption data collected by each user table according to the first cycle;

[0131] Step 302, determining whether there is an abnormality in the user resource consumption data and the public resource consumption data;

[0132] Step 303: if there is no abnormality, then classify each user table into a non-allocation user table and an allocation user table according to the comparison result of each user's resource consumption data and the preset allocation threshold;

[0133] Step 304, calculating the public resource allocation data of each shared user table in the first period according to the public resource consumption data and the user resource consumption data corresponding to the shared user table;

[0134] Step 305, summarizing the public resource allocation data according to the second cycle, and setting the public resource allocation data of the non-allocated user table to zero, to generate a resource consumption table;

[0135] Step 306, in response to the user request sent by the user terminal, the corresponding target data is returned from the resource consumption table to the user terminal for display.

[0136] In the embodiment of the present application, the public resource consumption data collected by the shared table and the user resource consumption data collected by each user table are obtained according to the first cycle; it is determined whether there are abnormalities in the user resource consumption data and the public resource consumption data; if there are no abnormalities in both types of data, each user table is classified into a non-shared user table and a shared user table according to the comparison result of each user's resource consumption data and the preset sharing threshold; the public resource sharing data of each shared user table in the first cycle is calculated according to the public resource consumption data and the user resource consumption data corresponding to the shared user table; the public resource sharing data of each shared user table is summarized according to the second cycle, and the public resource sharing data belonging to the non-shared user table is reset to zero to generate a resource consumption table; in response to the user request sent by the user end, the corresponding target data is returned from the resource consumption table to the user end for display. Thus, through the method of automatic data collection and calculation, the calculation efficiency and accuracy are effectively improved, and the shared electricity consumption is adaptively adjusted according to the electricity consumption of each type of user, thereby improving the user experience.

[0137] In the several embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of the modules is only a logical function division. There may be other division methods in actual implementation, such as multiple modules or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or modules, which can be electrical, mechanical or other forms.

[0138] The modules described as separate components may or may not be physically separated, and the components shown as modules may or may not be physical modules, that is, they may be located in one place or distributed on multiple network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0139] In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of software functional modules.

[0140] As described above, the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features thereof may be replaced by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A device for processing resource consumption data, characterized in that: It includes a data acquisition module, an abnormality identification module, a common pool screening module, a common pool calculation module and a visualization summary module which are sequentially connected in communication; The data acquisition module is used to acquire the public resource consumption data collected by the common pool table and the user resource consumption data collected by each user table according to the first period; The abnormality determination module is used to determine whether there are abnormalities in the user resource consumption data and the public resource consumption data; The common allocation screening module is used to classify each user table into a non-allocation user table and an allocation user table according to the comparison result of each user resource consumption data and a preset allocation threshold value if there is no abnormality; The shared resource calculation module is used to calculate the shared resource sharing data of each shared user table in the first period according to the shared resource consumption data and the user resource consumption data corresponding to the shared user table; The visualization summary module is used to summarize the public resource allocation data according to the second period, and reset the public resource allocation data belonging to the non-allocated user table to zero to generate a resource consumption table; respond to user requests sent by the user terminal, and return corresponding target data from the resource consumption table to the user terminal for display.

2. The device according to claim 1, characterized in that The user meter includes a user electricity meter and a user water meter, and the user resource consumption data includes user electricity consumption and user water consumption; The public resource consumption data includes the total power consumption of public equipment, the total power consumption of elevators and the total power consumption of water pumps.

3. The device according to claim 1, characterized in that The abnormality identification module is specifically used for: Calculating a first difference percentage between user resource consumption data of two adjacent first cycles, and a second difference percentage between public resource consumption data of two adjacent first cycles; If the first difference percentage or the second difference percentage exceeds a preset abnormal threshold, the data acquisition module is called again to collect new user resource consumption data or new public resource consumption data; If the first difference percentage and the second difference percentage do not exceed the preset abnormal threshold, it is determined that there is no abnormality in the user resource consumption data and the public resource consumption data of the current period.

4. The device according to claim 2, characterized in that The apportionment threshold includes an electricity apportionment threshold and a water apportionment threshold; the common apportionment screening module is specifically used to: Comparing the user's power consumption with the power consumption sharing threshold; If the user's electricity consumption exceeds the electricity consumption sharing threshold, the user's electricity meter is classified as a sharing user meter; If the user's electricity consumption does not exceed the electricity consumption sharing threshold, the user's electricity meter is classified as a non-shared user meter; Comparing the user's water consumption with the water consumption apportionment threshold; If the user's water consumption is not equal to the water consumption apportionment threshold, classifying the user's water meter into an apportionment user table; If the user's water consumption is equal to the water consumption apportionment threshold, the user's water meter is classified as a non-apportionment user meter.

5. The device according to claim 2, characterized in that The public resource sharing data includes the public equipment shared electricity, the elevator shared electricity and the water pump shared electricity; the shared electricity calculation module includes a public equipment shared electricity calculation submodule, an elevator shared electricity calculation submodule and a water pump shared electricity calculation submodule; The public equipment shared calculation submodule is used to calculate the ratio between the total power consumption of the public equipment and the number of the shared user tables, and obtain the public equipment shared power consumption of each of the shared user tables in the first period; The elevator shared user calculation submodule is used to construct weights according to the floors to which the shared user tables belong, and use the weights to calculate the weighted sum of the number of shared user tables on each floor; After calculating the ratio between the total power consumption of the elevator and the weighted sum, the multiplication value between the weights is calculated to obtain the shared power consumption of the elevators of each shared user table in the first period; The water pump shared electricity calculation submodule is used to respectively calculate the multiplication value between the water proportion occupied by each user's water consumption and the total electricity consumption of the water pump, so as to obtain the water pump shared electricity of each shared user table in the first period.

6. The device according to claim 4, characterized in that The visualization summary module includes a data summary submodule and a visualization display submodule; The data aggregation submodule is used to aggregate the public resource allocation data according to a second period, and reset the public resource allocation data belonging to the non-allocation user table to zero, to generate a resource consumption table; the second period is greater than the first period; The visualization display submodule is used to locate the target data corresponding to the user request from the resource consumption table when receiving the user request, and return it to the user end for display.

7. The device according to claim 6, characterized in that The data aggregation submodule is specifically used for: Creating an initial consumption table corresponding to the first period; Summarizing the corresponding public resource allocation data based on the allocation user table; According to the shared electricity consumption and the shared water consumption, the public resource sharing data belonging to the non-shared user table is set to zero, so as to obtain an intermediate consumption table corresponding to the first period; Taking the apportionment user table as a unit, calculating the user apportionment and value of the public resource apportionment data in the second period; All the intermediate consumption tables are summarized according to the second period and the preset timing and the user allocation and value are loaded to generate a resource consumption table.

8. The device according to claim 7, characterized in that The visual display submodule is specifically used for: Monitor in real time whether a user request sent by the user end is received; When receiving the user request, retrieving the resource consumption table according to the user request; Extracting the target data corresponding to the user request from the resource consumption table and returning it to the user terminal for display; The target data includes the user allocation and value and the public resource allocation data.

9. The device according to claim 8, characterized in that The user terminal is a website, an APP or a mini program; The user terminal is used to load the user identification corresponding to the user terminal, the user allocation and value, and the public resource allocation data into the target container respectively, and generate a target page for display.

10. A method for processing resource consumption data, characterized in that: include: Obtain the public resource consumption data collected by the common pool meter and the user resource consumption data collected by each user meter according to the first cycle; Determining whether the user resource consumption data and the public resource consumption data are abnormal; If there are no abnormalities, then classify each user table into a non-allocation user table and an allocation user table according to the comparison result of each user resource consumption data and the preset allocation threshold; Calculating the public resource allocation data of each of the shared user tables in the first period according to the public resource consumption data and the user resource consumption data corresponding to the shared user table; Summarizing the public resource allocation data according to the second cycle, and setting the public resource allocation data belonging to the non-allocation user table to zero, to generate a resource consumption table; In response to a user request sent by the user terminal, corresponding target data is returned from the resource consumption table to the user terminal for display.

Images