CN106682383B - To the accurate statistical processing methods of acquisition tables code value in a kind of metering system - Google Patents
To the accurate statistical processing methods of acquisition tables code value in a kind of metering system Download PDFInfo
- Publication number
- CN106682383B CN106682383B CN201610473697.3A CN201610473697A CN106682383B CN 106682383 B CN106682383 B CN 106682383B CN 201610473697 A CN201610473697 A CN 201610473697A CN 106682383 B CN106682383 B CN 106682383B
- Authority
- CN
- China
- Prior art keywords
- table code
- code value
- value
- mutation
- zero
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G16—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
- G16Z—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS, NOT OTHERWISE PROVIDED FOR
- G16Z99/00—Subject matter not provided for in other main groups of this subclass
Abstract
The invention discloses in a kind of metering system to the accurate statistical processing methods of acquisition tables code value, 1, the time interval of setting acquisition；2, all original table code value sequences are obtained；3, initial value is obtained；4, table code value is compared with next table code value；5, judge whether current table code value is the last one table code value, if it is enter 9, if not enter 6；If 6, current table code value is less than next table code value, enter 4, otherwise, into 7；Step 7 carries out temporary statistics, into 8；If 8, belonging to the reversion of table code or artificial clearing, 0 is set by the corresponding table code initial value of the mutation time section, into 4；If belonging to communication failure, the numerical value of all last table code values being less than before mutation is rejected, the last table code value before mutation is set by the corresponding table code initial value of the mutation time section, into 4；9, all temporary statistics are added up as a result, along with current value subtracts this subsegment table code initial value output variable.
Description
Technical field
The present invention relates in a kind of metering system to the accurate statistical processing methods of acquisition tables code value.
Background technique
As shown in Figure 1, the data communication process of industrial energy metering system includes: industrial energy metering system software deployment
In the information centre of industrial enterprise or the computer server at energy management center, pass through the sides such as optical fiber, wireless, Ethernet
Formula is communicated with the power measurement acquisition gateway for being distributed in each scene and energy instrument room, and each power measurement acquisition gateway passes through again
Fieldbus and nearest energy meter communicate.The protocol conversion communicated in this way by two-stage, from the energy meter to energy measurement
Acquisition gateway, then Energy Consumed Statistic System software is arrived, every certain time interval, system can acquire the table code of industrial instrument meter
Be worth (numerical value of gauge table) be stored in historical data base, as basic initial data, statistics program can handle these data, according to when
Between and table code calculate certain time interval, such as the continuous data within hour, day, the moon, week, season, year.
Various industrial energy meters, such as ammeter, water meter, gas meter, hotlist (heat meter), as energy usage is constantly tired
Product, numerical characteristics of table code data that its acquisition comes up under normal circumstances either as the time constantly increases, or due to
Scene is remained unchanged without dosage.Quantitative statistics program will calculate the energy measurement dosage in interval of time, processing side
Method is: the table code value of time started and the table code value of end time in this period is obtained, then by the table code value of end time
The table code value of time started is subtracted, it is this time that this difference should be the data more than or equal to zero under normal circumstances
Energy measurement volume value, as shown in Figure 2.
But in the industrial environment of reality, the table code data come up of energy meter acquisition can mutate the feelings of zero
Condition is mainly based upon following several reasons: (1) table code has arrived at the full code value of the maximum number of digits of meter, automatically generates reversion,
Table code zero；(2) artificial the case where resetting, it may be possible to which the clearing of handing over to the next shift between teams and groups, or live meter failure are replaced；
(3) disconnection fault of communication failure or energy resource collecting gateway, during this period of time makes metering system software that can not collect table
Code data, do return-to-zero.
If the case where above-mentioned mutation zero data has occurred in statistics program within the period to be treated, according to routine
There will be two kinds of situations for processing method: the first situation as shown in figure 3, the reversion of above-mentioned table code and it is artificial reset in the case where,
The table code of end time period is to restart to increase after zero, subtracts the table code of time started, obtains a result or be negative
Several or end time table code has risen to bigger than start-up schedule code, is positive number after subtracting each other, but this is to have measured meter
Increase again after table code zero and is used with energy measurement at the time of segment table code is equal when starting to statistics this period of end time
This period at the time of segment table code is equal when measuring, and increasing with again after counting the time started to meter table code zero
But without statistical metering, the result obtained in this way is the numerical value smaller than practical energy usage for metering；Another situation such as Fig. 4 institute
Show, in the case where communication failure or energy resource collecting gateway power off, in failure, table code is zero always, if at the end of statistics
Between failure it is recovered, table code is back to normal, and normal value can be obtained by subtracting start-up schedule code with end time table code in this way, but
Still may also be zero up to the table code of statistical time range end time, subtract the table code of period start time, obtain a result for
Negative.
It can not normally handle, occur for the wrong data of above-mentioned zero mutation in existing industrial energy measuring software
The statistical data of mistake, subsequent processing method input often by manual record table code reversion record sheet in systems
Code, replacement meter record sheet code reset then system that meter record sheet code triggers the database of statistical updating again of measuring software
Evaluation or direct labor correct mistake data.But as industrial enterprise increasingly payes attention to energy management work, management is got over
It more refines, constantly reinforces the installation of energy meter and gage work, be covered with level of factory, workshop level critical point energy meter substantially
Deployment, conditional industrial enterprise also cover the deployment of the higher device level energy meter of energy consumption.Industrial energy is measured in this way
The data of system energy meter to be processed are also just more and more, are zeroed for recurrent meter and are mutated wrong data, energy
Source statistical metering personnel often can only artificial correction be used to settle accounts the accidental data of factory, workshop level critical point energy meter, and for
The accidental data of more device level energy meters, then can not modify one by one correction by artificial method, thus can not and
When obtain accurate energy usage, error can be brought to the fining energy management of industrial enterprise and Energy Efficiency Analysis.
Summary of the invention
In view of the above-mentioned problems, the present invention is provided in a kind of metering system to the accurate statistical processing methods of acquisition tables code value,
Overcoming existing metering system statistics program existing can not effectively automatically process for table code value mutation zero, it is necessary to artificial correction
The problem of and defect, provide a kind of automatic identification analytical table code value mutation zero situation, and reject the metering of processing error information
Statistical method improves the accuracy of statistics.
To realize above-mentioned technical purpose and the technique effect, the invention is realized by the following technical scheme:
To the accurate statistical processing methods of acquisition tables code value in a kind of metering system, which comprises the steps of:
Step 1, setting system call the time interval T, T≤instrument minimum statistics time interval of acquisition instrument table code data
1/10；
Step 2, the head and the tail time of input period to be counted obtain this when according to acquisition time sequence according to statistical time range
All original table code value sequences in section；
Step 3, the table code initial value for obtaining the period to be counted；
Step 4 compares current table code value with next table code value；
Step 5, judge current table code value whether be the period to be counted the last one table code value, if yes then enter step
9, if not then entering step 6；
If step 6, current table code value are less than next table code value, enabling next table code value is current table code value, is entered
Step 4, otherwise, judge the case where mutation zero occurred, enter step 7；
Step 7, by before mutation, the period that do not mutate corresponding subsegment table code carry out temporary statistics, record is corresponding should
The temporary statistics of subsegment judge the type of mutation zero as a result, enter step 8；
If step 8, the type for belonging to the reversion of table code or manually resetting, by the corresponding table code initial value of the mutation time section
It is set as 0, enters step 4；If belonging to the type of communication failure, the number of all last table code values being less than before mutation is rejected
Value sets the last table code value before mutation for the corresponding table code initial value of the mutation time section, enters step 4；
Step 9, all temporary statistics that add up export as a result, along with current value subtracts this subsegment table code initial value wait unite
The variable of timing section.
It is preferred that in step 8, judging the type of mutation zero, specific step is as follows:
A the last one table code value before) recording zero, continuation acquire subsequent table code value backward, until collecting weight
Newly start the N number of table code value continuously increased；
B) N number of table code value is averaged, and compared with the last one table code value before the zero of step A) record；
C) if the last one table code value before zero is greater than the average value of N number of table code value, it is judged as and belongs to the reversion of table code
Or otherwise the type manually reset is judged as the type for belonging to communication failure.
The beneficial effects of the present invention are:
Compared with prior art, change the method for only taking statistical time range tail head table code to subtract each other, but taken in measurement period
Multiple table code values increase statistical sample and carry out comparing two-by-two for front and back table code value, can judge automatically a large amount of three, level Four in this way and (set
Standby grade) industrial instrument metering data may all occur daily artificial clearing for several times inverted with table code, communication failure,
To take different statistical disposition strategies.On the one hand it ensure that the dosage statistical accuracy of industrial instrument metering, on the other hand
Many and diverse manual maintenance and the work for screening data are changed to automated procedures processing, improve enterprise measurement management and energy system
Working efficiency is counted, the accuracy of statistics is improved.
Detailed description of the invention
Fig. 1 is the deployment of industrial energy metering system and acquisition data flow diagram；
Fig. 2 is that statistics program meets each other according to the tail head table code of statistical time range and obtains the schematic diagram of variable under normal circumstances；
Fig. 3 is that there is a situation where the reversion of table code or the artificial schematic diagrames reset in statistical time range；
Fig. 4 is that there is a situation where the schematic diagrames of communication failure in statistical time range；
Fig. 5 is that there is a situation where the reversion of table code or the artificial judgment method schematic diagrames reset in statistical time range；
Fig. 6 is to the judgment method schematic diagram in statistical time range there is a situation where communication failure；
Fig. 7 is the flow chart in a kind of metering system of the present invention to the accurate statistical processing methods of acquisition tables code value.
Specific embodiment
Technical solution of the present invention is described in further detail with specific embodiment with reference to the accompanying drawing, so that ability
The technical staff in domain can better understand the present invention and can be practiced, but illustrated embodiment is not as to limit of the invention
It is fixed.
The accurate statistical processing methods of acquisition tables code value are included the following steps: as described in Figure 6 in a kind of metering system
Step 1, setting system call the time interval T, T≤instrument minimum statistics time interval of acquisition instrument table code data
1/10.The sample frequency of higher energy meter table code is set in industrial energy metering system, between the time of sampling
Every the 1/10 of minimum statistics time interval to be lower than, the minimum energy measurement statistical unit that such as certain meter requires is hour, then its
The sampling time interval of table code is 6 minutes or smaller, in this way in arbitrary hour statistical time section, can there is at least ten table
Code record is entered the investigation of statistical disposition program.
Step 2, the head and the tail time of input period to be counted obtain this when according to acquisition time sequence according to statistical time range
All original table code value sequences in section.According to statistical time range initial time, obtain all table code collection values in the period and
Acquisition time will be divided into the smaller statistical time range of sample period lengths according to collection value time sequencing in big statistical time range.
It is preferred that except obtaining comprising table codes records all in this statistical time range, increase to previous statistical time range and to
The acquisition of the table code record of the latter statistical time range.When obtaining previous statistical time range, this period, the latter statistics in advance in this way
Section all original table code value sequence datas in totally 3 sections of periods, when in case the statistical time range head and the tail time encountering zero accidental data
Increase data analysis to be judged.
Step 3, the table code initial value for obtaining the period to be counted.
Step 4 compares current table code value with next table code value.This step carries out front and back table code value two-by-two and compares,
When rear timetable code value (being worth after abbreviation) is greater than preceding timetable code value (referred to as before value), it is believed that preceding value currently is effective, then after
It is continuous to investigate backward；When value is less than preceding value after encountering, it is believed that encounter mutation zero.
Step 5, judge current table code value whether be the period to be counted the last one table code value, if yes then enter step
9, if not then entering step 6.
If step 6, current table code value are less than next table code value, current table code value is effective, then continues to investigate backward,
The middle current table code value for enabling current next table code value as next comparison loop, enters step 4, otherwise, judges occur
The case where mutation zero, enter step 7.
Step 7, by before mutation, the period that do not mutate corresponding subsegment table code carry out temporary statistics, record is corresponding should
The temporary statistics of subsegment judge the type of mutation zero as a result, enter step 8.
It should be noted that since the number of period to be counted mutation zero is unknowable, therefore the period to be counted is zeroed by mutation
The case where be divided into several subsegments, the period that each subsegment corresponds to the period of single mutation or do not mutate,
In period for not mutating according to conventional statistical method the table code value of end time in the period is subtracted into beginning
The table code value of time is as temporary statistics result.
If step 8, the type for belonging to the reversion of table code or manually resetting, by the corresponding table code initial value of the mutation time section
It is set as 0, enters step 4；If belonging to the type of communication failure, the number of all last table code values being less than before mutation is rejected
Value sets the last table code value before mutation for the corresponding table code initial value of the mutation time section, enters step 4；
Step 9, all temporary statistics that add up export as a result, along with current value subtracts this subsegment table code initial value wait unite
The variable of timing section.
How accurate judgement is normal artificial the case where resetting with the reversion of table code or improper communication failure, for system
Different processing paths is had in sequence of having the records of distance by the log processing, brings very big difference.Specific judgment method is:
A the last one table code value before) recording zero, continuation acquire subsequent table code value backward, until collecting weight
Newly start the N number of table code value continuously increased；
B) N number of table code value is averaged, and compared with the last one table code value before the zero of step A) record；
C) if the last one table code value before zero is greater than the average value of N number of table code value, it is judged as and belongs to the reversion of table code
Or otherwise the type manually reset is judged as the type for belonging to communication failure, accidentally acquisition is zero to table code, by these communication failures
Data reject after be zeroed before data merge, then uniformly handled.
As it can be seen in figures 5 and 6, it is preferred that, N=3 takes the judgment method of the average value of continuous 3 table codes, is to prevent communication event
After barrier restores, when continuous data just starts to upload, the data of generation change shake up and down, allow program erroneous judgement the case where.
There is mutation zero close to the table code near starting and end time when this statistical time range, then expands examination
Range, therefore, it can be obtained according to acquisition time sequence:
Occurs mutation zero at the beginning of this period, then according to the original table code value of the previous statistical time range of acquisition
To judge the type of mutation zero；
There is mutation zero when the end time of this period, then according to the original table code value of the latter statistical time range of acquisition
To judge the type of mutation zero.
Program has handled the last one table code value in statistical time range, will be measured by each subsegment divided in the case of mutation zero
Intermediate result added up (if the case where not being mutated zero entire statistical time range be 1 whole period), finally obtain
Metered amount value in this statistical time range.
Compared with prior art, change the method for only taking statistical time range tail head table code to subtract each other, but taken in measurement period
Multiple table code values increase statistical sample and carry out comparing two-by-two for front and back table code value, can judge automatically a large amount of three, level Four in this way and (set
Standby grade) industrial instrument metering data may all occur daily artificial clearing for several times inverted with table code, communication failure,
To take different statistical disposition strategies.On the one hand it ensure that the dosage statistical accuracy of industrial instrument metering, on the other hand
Many and diverse manual maintenance and the work for screening data are changed to automated procedures processing, improve enterprise measurement management and energy system
Working efficiency is counted, the accuracy of statistics is improved.
The above is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all to utilize this hair
Equivalent structure made by bright specification and accompanying drawing content perhaps equivalent process transformation or be directly or indirectly used in other correlation
Technical field, be included within the scope of the present invention.
Claims (2)
1. to the accurate statistical processing methods of acquisition tables code value in a kind of metering system, which comprises the steps of:
Step 1, setting system call the time interval T of acquisition instrument table code data, T≤instrument minimum statistics time interval 1/
10；
Step 2, the head and the tail time of input period to be counted obtain in this period according to statistical time range according to acquisition time sequence
All original table code value sequences；
Step 3, the table code initial value for obtaining the period to be counted；
Step 4 compares current table code value with next table code value；
Step 5, judge current table code value whether be the period to be counted the last one table code value, if yes then enter step 9, such as
Fruit is not to enter step 6；
If step 6, current table code value are less than next table code value, enabling next table code value is current table code value, is entered step
4, otherwise, judges the case where mutation zero occurred, enter step 7；
Step 7, by before mutation, the period that do not mutate corresponding subsegment table code carry out temporary statistics, record the corresponding subsegment
Temporary statistics as a result, enter step 8, judge the type of mutation zero；
If step 8, the type for belonging to the reversion of table code or manually resetting, the corresponding table code initial value of the mutation time section is arranged
It is 0, enters step 4；If belonging to the type of communication failure, the numerical value of all last table code values being less than before mutation is rejected, it will
The corresponding table code initial value of the mutation time section is set as the last table code value before mutation, enters step 4；
Step 9, all temporary statistics that add up are as a result, along with current value subtracts this subsegment table code initial value, when exporting to be counted
The variable of section；
In step 8, judge mutation zero type specific step is as follows:
A the last one table code value before) recording zero, continuation acquire subsequent table code value backward, open again until collecting
Begin the N number of table code value continuously increased；
B) N number of table code value is averaged, and compared with the last one table code value before the zero of step A) record；
C) if the last one table code value before zero is greater than the average value of N number of table code value, it is judged as and belongs to the reversion of table code or people
Otherwise the type that work is reset is judged as the type for belonging to communication failure；N=3.
2. to the accurate statistical processing methods of acquisition tables code value, feature in a kind of metering system according to claim 1
It is, obtains previous statistical time range, this period, the latter statistical time range totally 3 sections of periods according to acquisition time sequence in step 2
Interior all original table code value sequences:
Occur mutation zero at the beginning of this period, is then sentenced according to the original table code value of the previous statistical time range of acquisition
The type of disconnected mutation zero；
There is mutation zero when the end time of this period, is then sentenced according to the original table code value of the latter statistical time range of acquisition
The type of disconnected mutation zero.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610473697.3A CN106682383B (en) | 2016-06-24 | 2016-06-24 | To the accurate statistical processing methods of acquisition tables code value in a kind of metering system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610473697.3A CN106682383B (en) | 2016-06-24 | 2016-06-24 | To the accurate statistical processing methods of acquisition tables code value in a kind of metering system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106682383A CN106682383A (en) | 2017-05-17 |
| CN106682383B true CN106682383B (en) | 2019-03-08 |
Family
ID=58839893
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610473697.3A Active CN106682383B (en) | 2016-06-24 | 2016-06-24 | To the accurate statistical processing methods of acquisition tables code value in a kind of metering system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106682383B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109189791B (en) * | 2018-09-07 | 2022-07-19 | 国电南瑞科技股份有限公司 | Electric quantity data acquisition and processing method suitable for ammeter to move easily |
| CN110244096B (en) * | 2019-06-20 | 2021-06-04 | 国电南瑞科技股份有限公司 | Method for automatically discovering and processing electric meter full code in electric energy metering system |
| CN111737286B (en) * | 2020-05-25 | 2023-07-18 | 清远博依特智能科技有限公司 | Meter resetting judgment method, device and storage medium |
| CN111782178A (en) * | 2020-05-25 | 2020-10-16 | 清远博依特智能科技有限公司 | Monthly energy consumption calculation method and device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458276A (en) * | 2007-12-11 | 2009-06-17 | 深圳市科陆电子科技股份有限公司 | Electric quantity computation method and apparatus and electric meter controlling equipment |
| CN103941207A (en) * | 2014-03-03 | 2014-07-23 | 广州供电局有限公司 | Electric power measurement automation terminal detection method and system |
| CN105468662A (en) * | 2014-12-31 | 2016-04-06 | 深圳市中电电力技术股份有限公司 | Energy consumption data processing method and system based on table-code value |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8078567B1 (en) * | 2008-12-31 | 2011-12-13 | John Cadick | System and method for condition based maintenance for electrical equipment |
-
2016
- 2016-06-24 CN CN201610473697.3A patent/CN106682383B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101458276A (en) * | 2007-12-11 | 2009-06-17 | 深圳市科陆电子科技股份有限公司 | Electric quantity computation method and apparatus and electric meter controlling equipment |
| CN103941207A (en) * | 2014-03-03 | 2014-07-23 | 广州供电局有限公司 | Electric power measurement automation terminal detection method and system |
| CN105468662A (en) * | 2014-12-31 | 2016-04-06 | 深圳市中电电力技术股份有限公司 | Energy consumption data processing method and system based on table-code value |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106682383A (en) | 2017-05-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106682383B (en) | To the accurate statistical processing methods of acquisition tables code value in a kind of metering system | |
| CN110471024B (en) | Intelligent electric meter online remote calibration method based on measurement data analysis | |
| CN102692615B (en) | System capable of automatically acquiring electric quantity data | |
| CN106154209B (en) | Electrical energy meter fault prediction technique based on decision Tree algorithms | |
| CN101213421B (en) | Automated integration of data in public utility monitoring systems | |
| CN111191878A (en) | Abnormal analysis based station area and electric energy meter state evaluation method and system | |
| CN104200314B (en) | Electricity and line loss same period statistical method based on data remote synchronization acquisition technique | |
| CN110927654B (en) | Batch running state evaluation method for intelligent electric energy meters | |
| CN113032454A (en) | Interactive user power consumption abnormity monitoring and early warning management cloud platform based on cloud computing | |
| CN102521080B (en) | Computer data recovery method for electricity-consumption information collecting system for power consumers | |
| CN110311709B (en) | Fault judgment method for electricity consumption information acquisition system | |
| CN108445435A (en) | A kind of electric energy meter calibrating apparatus error online evaluation method | |
| CN114354783A (en) | Health degree evaluation method of extra-high voltage oil chromatography monitoring device based on-operation data | |
| CN112305492A (en) | Intelligent electric energy meter online error check accurate control system and method thereof | |
| CN112684397B (en) | Electric energy meter operation error monitoring method and system based on high-frequency HPLC (high Performance liquid chromatography) data | |
| CN115685050B (en) | Electric energy meter fault detection method and system | |
| CN109542742A (en) | Database server hardware health evaluating method based on expert model | |
| CN111027026A (en) | Meter reading data abnormity intelligent diagnosis system | |
| CN113591393A (en) | Fault diagnosis method, device, equipment and storage medium of intelligent substation | |
| CN112560214A (en) | Transformer substation bus balance fault diagnosis method, system, equipment and storage medium | |
| CN113256175A (en) | Automatic analysis method and system for data collection of distribution substation meter data | |
| CN114328625A (en) | Electric charge data rescreening method and system | |
| Scherrer et al. | Operational quality control of daily precipitation using spatio-climatological plausibility testing | |
| CN109035062A (en) | A kind of client's electricity charge anomaly analysis and tactful application system | |
| CN113608975A (en) | Method and system for online evaluation of running state of electric energy metering system in electric power spot market |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |