CN107248027A - A kind of statistical calculation method of the upper bore commercial power of rule - Google Patents
A kind of statistical calculation method of the upper bore commercial power of rule Download PDFInfo
- Publication number
- CN107248027A CN107248027A CN201710371989.0A CN201710371989A CN107248027A CN 107248027 A CN107248027 A CN 107248027A CN 201710371989 A CN201710371989 A CN 201710371989A CN 107248027 A CN107248027 A CN 107248027A
- Authority
- CN
- China
- Prior art keywords
- enterprise
- rule
- matching
- statistical calculation
- utilities electric
- 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.)
- Pending
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 28
- 230000005611 electricity Effects 0.000 claims abstract description 41
- 238000000034 method Methods 0.000 claims abstract description 24
- 238000004458 analytical method Methods 0.000 claims abstract description 7
- 238000012545 processing Methods 0.000 claims abstract description 7
- 238000007726 management method Methods 0.000 claims description 6
- 239000000284 extract Substances 0.000 claims description 5
- 238000007689 inspection Methods 0.000 claims description 3
- 238000000926 separation method Methods 0.000 claims description 3
- 238000012795 verification Methods 0.000 claims description 3
- 238000004904 shortening Methods 0.000 claims 1
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000009472 formulation Methods 0.000 abstract description 2
- 239000000203 mixture Substances 0.000 abstract description 2
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000003860 storage Methods 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 102220475340 DNA replication licensing factor MCM2_S41A_mutation Human genes 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000009738 saturating Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06315—Needs-based resource requirements planning or analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Development Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to a kind of statistical calculation method of the upper bore commercial power of rule, including：The Gui Shang industrial enterprises directory data provided by statistics bureau is provided；Analyze the Industry enterprise customer information counted by Utilities Electric Co.；Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched, the matching list for meeting of that month actual conditions is set up；Classification processing is carried out to a family multilist present in matching list and many family situations of a table；Statistical calculation branch trade, the upper industrial electricity of rule in analysis area, and statistical calculation result is shown by PivotTables.The present invention carries out Classifying Sum with manually verifying the method being combined using big data technology to the power consumption for saving Yu Neiguishang industrial enterprises, completes the upper bore commercial power statistical calculation of rule classified based on new edition industrial sectors of national economy.Be conducive to improving classification accounting of the power industry on power consumption, the situation that the true upper industrial economy of reflection rule is run, and help to carry out the formulation of power planning and economic policy.
Description
Technical field
The present invention relates to power industry power consumption statistical technique field, and in particular to a kind of system of the upper bore commercial power of rule
Count accounting method.
Background technology
Observe economical by commercial power, it has also become the widespread consensus of government, financial institution, public etc..But, mesh
Preceding industrial economy value added growth rate is occurred in that with industrial electricity speedup to be deviated from, by study discovery cause it is such a deviate from ripple
Dynamic mainly has two class factors：The first kind is objective factor, mainly includes industry restructuring optimization and temperature to commercial power
Amount influence.Equations of The Second Kind is subjective factor, is mainly included：(1) Statistical Criteria is inconsistent, in total amount, the industry of statistics bureau's issue
Economic indicator is state-owned and large non-state industrial enterprises' bore, and the industrial electricity of Utilities Electric Co.'s internal statistical is whole industrial enterprises mouthful
Footpath；On subitem, industrial economy indicator-specific statistics uses national 2011 professional museum, and industrial electricity statistics is used
Be national professional museum in 2002；(2) statistical calculation method is inconsistent.In industrial electricity comprising electric power production with
The loss of electricity produced, storage station is conveyed to draw water electricity, but line loss and the storage station electricity etc. that draws water are influenceed using climate
Greatly, the year-on-year and ring of this part electricity is changed greatly than speedup, industrial electricity speedup is produced fluctuation larger.Based on it is above-mentioned because
Element, it is impossible to accurately by the analysis to industrial economy value added and industrial electricity relation between the two, draw certain conclusion,
A certain degree of puzzlement is caused to Utilities Electric Co.'s internal analysis power supply and demand situation, Government Analytical macroeconomic situation with doing
Disturb.Objective factor can not artificially change, but subjective factor we can be by being adjusted.Therefore, it is necessary to pass through
A kind of statistical calculation method of the upper bore commercial power of rule is built, the upper industrial electricity of rule is combed out, so as to preferably service electricity
The power supply and demand situation analysis of power intra-company, Electric Power Network Planning, and Macro-Economical Policy of Government are formulated.
The content of the invention
It is an object of the invention to provide a kind of statistical calculation method of the upper bore commercial power of rule, by based on new edition state
The Statistical Criteria of the upper commercial power statistical calculation of rule of people economic sectors classification, unified industrial electricity and industrial added value, be
There is provided the upper commercial power data basis of solid reliable rule for the situation of the upper industrial economy operation of true reflection province domain rule.
To achieve the above object, present invention employs following technical scheme：
A kind of statistical calculation method of the upper bore commercial power of rule, comprises the following steps：
(1) the Gui Shang industrial enterprises directory data provided by statistics bureau is provided；
(2) the Industry enterprise customer information counted by Utilities Electric Co. is analyzed；
(3) Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched, foundation meets of that month real
The matching list of border situation；
(4) classification processing is carried out to a family multilist present in matching list and many family situations of a table；
(5) statistical calculation branch trade, the upper industrial electricity of rule in analysis area, and statistical calculation result is saturating by data
It is shown depending on table.
It is basic to Gui Shang industrial enterprises register and Utilities Electric Co. user using big data matching technique in the step (3)
Information table is matched, and is set up the matching list for meeting of that month actual conditions, is specifically included following steps：
(31) the Gui Shang industrial enterprises register provided using word participle techniques Statistics Bureau of Shanxi Province and enterprise of provincial electric power company
User message table is pre-processed, and extracts the keyword in enterprise name；
(32) full text rope is set up to the enterprise name in Utilities Electric Co.'s user message table using Oracle Text indexes documents
Draw；
(33) matched, entered in enterprise's row in Utilities Electric Co.'s user message table with keyword with oracle softwares
Row searches matching, verifies out 100% consistent enterprise.
In the step (3), Gui Shang industrial enterprises register and Utilities Electric Co. user are believed substantially using artificial check method
Breath table is matched, and is set up the matching list for meeting of that month actual conditions, is specifically included following steps：
(3A) is extracted trading company therein and scanned for as keyword based on computer search keyword；
(3B) if failing to search correspondence enterprise, separation computer search keyword contiguous field, shorten main title,
Selection region adds main title, selection main title plus management functions mode to expand hunting zone；
(3C) is used if on the basis of first two steps, searching many enterprises by contrasting enterprise of statistics bureau with Utilities Electric Co.
The title of enterprise, address, management functions, trade information are confirmed whether it is same enterprise in the information table of family；
(3D) be not if on the basis of step (3A) and step (3B), any enterprise being searched out, then passes through national business standing
Public notification of information system, search enterprise whether rename, whether relevant enterprise, whether be group company；
(3E) filters out these Gui Shang enterprises lists if not matching the enterprise also by above step step, respectively
Statistics Bureau of Shanxi Province and provincial electric power company are given, office and Utilities Electric Co. to be counted examine company information, enterprise's electricity charge and pay mode respectively
Carry out the matching of a new round again afterwards.
It is basic to Gui Shang industrial enterprises register and Utilities Electric Co. user using big data matching technique in the step (3)
Information table is matched, and sets up the matching list for meeting of that month actual conditions, further comprising the steps of：
(34) the consistent or neighbouring enterprise in region is set as consistent enterprise；
(35) matched with similarity of character string algorithm, verify out enterprise of the similarity 90%；
(36) enterprise name in the statistics bureau and Utilities Electric Co. that hand inspection goes out with similarity of character string algorithmic match,
Whether verification matching is effective, confirms to utilize computer big data matching technique achievement matching Number of Firms and the match is successful rate.
In the step (4), classification processing is carried out to a family multilist present in matching list and many family situations of a table, specifically
Comprise the following steps：
(41) judge whether the industrial enterprise in matching list belongs to while producing according to Gui Shang industrial enterprises major product code
In the product of different big/middle class industries, trade classification is carried out according to following two different situations respectively：
(41A) first confirms that whether the enterprise is a family multilist enterprise, if so, the industry code then provided according to Utilities Electric Co.
Classified, it is included into different industries respectively；
It is individually taken out, entered if the upper Industry enterprise customer of multiple rule shares one piece of ammeter by (41B) from database
The full name of row is accurately matched and artificial treatment, verifies authenticity and secondary determination Utilities Electric Co. Customs Assigned Number is corresponding with business code
Relation.
(42) other information obtained according to power plant's title, address and internet hunt, manually with Gui Shang industrial enterprises
Register is matched, and Gui Shang industrial enterprises and power plant's numbering matching list is formed, it is determined that the industry attribute for the power plant that generates power for their own use；
(43) according to the administrative division in Gui Shang industrial enterprises of statistics bureau register, to the industrial enterprise in matching list by area
Classified.
In the step (5), the upper industrial electricity of rule of statistical calculation branch trade region-by-region specifically includes following steps：
(51) the query statistic office unique business electrical amount of three bit codes, according to secondly bit code statistic of classification electricity；
(52) the not unique enterprise of three bit codes of query statistic office, statistic of classification electricity is carried out according to the industry code of power network；
(53) inquiry enterprise generates power for their own use electricity, according to secondly bit code or three bit code statistic of classification electricity.
It is as shown from the above technical solution, of the invention based on the newest Gui Shang industrial enterprises checklist of Statistics Bureau of Shanxi Province,
Classifying Sum is carried out to the power consumption for saving Yu Neiguishang industrial enterprises with manually verifying the method being combined using big data technology,
Complete the upper bore commercial power statistical calculation of rule classified based on new edition industrial sectors of national economy.Be conducive to improving power industry on
The classification of power consumption is adjusted, the situation of the true upper industrial economy operation of reflection rule, and helps to carry out power planning and economic political affairs
The formulation of plan.
Brief description of the drawings
Fig. 1 is flow chart of the method for the present invention；
Fig. 2 is the upper industrial electricity PivotTables of rule of Anhui Province's branch trade of the present invention, region-by-region.
Embodiment
The present invention will be further described below in conjunction with the accompanying drawings：
By taking Anhui Province as an example, industrial enterprise's information first to Anhui Statistics Bureau of Shanxi Province and Anhui Electric Power Corporation is investigated
Analysis, the problem of discovery is wherein present；Secondly, using big data matching technique and artificial two methods of verifying on Anhui Province's rule
Industrial enterprise's register and Utilities Electric Co.'s user basic information table are matched, and set up the matching list for meeting of that month actual conditions；
Then, classification processing is carried out for " a family multilist " present in matching list and " many families of a table " situation；Finally, Anhui Province is calculated
The upper industrial electricity of rule of branch trade, region-by-region, as shown in figure 1, a kind of statistical calculation method of the upper bore commercial power of rule, bag
Include following steps：
S1：The Gui Shang industrial enterprises directory data provided by statistics bureau is provided, the upper work of the rule provided Statistics Bureau of Shanxi Province is provided
Industry business directory is investigated, and finds the problem of data message that statistics bureau provides there may be；
S2：The Industry enterprise customer information counted by Utilities Electric Co. is analyzed, is looked forward to by the industry counted to provincial electric power company
Industry user profile is investigated, and whether comprehensive, and do not meet specification with the presence or absence of some if analyzing its Power Consumption of Industrial Enterprises information
The problem of property is required；
S3：Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched, foundation meets of that month real
The matching list of border situation：
The Gui Shang industrial enterprises register registered on the books due to Anhui Statistics Bureau of Shanxi Province and sales service system of Anhui Electric Power Corporation
The Statistical Criteria of user basic information table is differed in system, and the unique word of statistics bureau's register table and power grid user Basic Information Table
Section is differed, and therefore, the enterprise in statistics bureau's register and power grid user Basic Information Table is carried out to full name matching by name first
(because full name matching result is reliable, it is not necessary to verify), and matching result is added in matching list.On this basis, for
Failed the enterprise of pairing as stated above, and secondary is carried out using big data matching technique and artificial two methods of verifying
Match somebody with somebody, matching result is added in matching list, it is final to set up the matching list for meeting of that month actual conditions.
Big data matching technique verifies process：
S31：The Gui Shang industrial enterprises register provided using word participle techniques Statistics Bureau of Shanxi Province and enterprise of provincial electric power company
User message table is pre-processed, and extracts the keyword in enterprise name；
S32：Full text rope is set up to the enterprise name in Utilities Electric Co.'s user message table using Oracle Text indexes documents
Draw；
S33：Matched, entered in enterprise's row in Utilities Electric Co.'s user message table with keyword with oracle softwares
Row searches matching, verifies out 100% consistent enterprise.
Because above-mentioned steps can't accurately match whole enterprises, so using similarity of character string algorithm again, specifically
Step is as follows：
S34：The consistent or neighbouring enterprise in region is set as consistent enterprise；
S35：Matched with similarity of character string algorithm, verify out enterprise of the similarity 90%；
S36：Enterprise name in statistics bureau and Utilities Electric Co. that hand inspection goes out with similarity of character string algorithmic match,
Whether verification matching is effective, confirms to utilize computer big data matching technique achievement matching Number of Firms and the match is successful rate.
Using artificial check method, following steps are specifically included：
S3A：Based on computer search keyword, extract trading company therein and scanned for as keyword；
S3B：If failing to search correspondence enterprise, separation computer search keyword contiguous field, shorten main title,
Selection region adds main title, selection main title plus management functions mode to expand hunting zone；
S3C：If on the basis of first two steps, searching many enterprises, used by contrasting enterprise of statistics bureau with Utilities Electric Co.
The title of enterprise, address, management functions, trade information are confirmed whether it is same enterprise in the information table of family；
S3D：If on the basis of step S3A and step S3B, any enterprise is not searched out, then believed by national business standing
Cease publicity system, search enterprise whether rename, whether relevant enterprise, whether be group company；
S3E：If not matching the enterprise also by above step step, these Gui Shang enterprises lists are filtered out, respectively
Statistics Bureau of Shanxi Province and provincial electric power company are given, office and Utilities Electric Co. to be counted examine company information, enterprise's electricity charge and pay mode respectively
Carry out the matching of a new round again afterwards.
S4：Classification processing is carried out to a family multilist present in matching list and many family situations of a table, comprised the following steps that：
S41：Judge industrial enterprise in matching list whether simultaneously according to Gui Shang industrial enterprises major product code (7 bit code)
Production belongs to the product of different big/middle class industries, carries out trade classification according to following two different situations respectively：
S41A：The first two or three bit codes of the product code that Gui Shang industrial enterprises include are not unique, industry enterprise in same domestic discipline and family rules
Industry, which may include different product codes, the particularly enterprise, may produce the product for belonging to different big/middle class industries, cause production
Before product code before two or three industry codes (4 bit code) with the enterprise two or three it is inconsistent.When running into such case, first
Whether be a family multilist enterprise, if so, the industry code then provided according to Utilities Electric Co. is classified, distinguished if confirming the enterprise
It is included into different industries.
For example：The corresponding SIC code of certain enterprise is different, and statistics bureau's industry code includes 0710,4500, enterprise of Utilities Electric Co.
Industry industry code includes 0710,4410,4411, then, classifies by the SIC code of Utilities Electric Co., be classified as 0710,4410,
4411。
S41B：On many family situations of a table, i.e., the upper Industry enterprise customer of multiple rule shares one piece of ammeter, then by its individually from
Taken out in database, carry out full name accurately matching and artificial treatment, verified authenticity and secondary determination Utilities Electric Co. user compiles
Corresponding relation number with business code.
S42：On the power plant that generates power for their own use, Utilities Electric Co. provide generate power for their own use the monthly information table of power plant (comprising power plant numbering,
Power plant's title and the electricity of generating power for their own use of power plant).The other information obtained according to power plant's title, address and internet hunt,
Manually matched with Gui Shang industrial enterprises registers, Gui Shang industrial enterprises and power plant's numbering matching list are formed, it is determined that generating power for their own use
The industry attribute of power plant；
S43：According to the administrative division in Gui Shang industrial enterprises of statistics bureau register, to the industrial enterprise in matching list by area
Classified.
S5：It is industrial on the rule of statistical calculation branch trade, region-by-region in database according to step S4 classification result
Power consumption, and statistical calculation result copied to PivotTables is made in excel be shown.Wherein, commercial power on rule
Amount is the upper industrial electricity sales amount of rule and the upper industry of rule is generated power for their own use electricity sum.
In the step, the upper industrial electricity of rule of statistical calculation branch trade region-by-region specifically includes following steps：
S51：The query statistic office unique business electrical amount of three bit codes, according to secondly bit code statistic of classification electricity；
S52：The not unique enterprise of three bit codes of query statistic office, statistic of classification electricity is carried out according to the industry code of power network；
S53：Inquiry enterprise generates power for their own use electricity, according to secondly bit code or three bit code statistic of classification electricity.
According to above-mentioned steps, the upper industrial electricity number of rule of Anhui Province's branch trade as shown in Figure 2, region-by-region is finally given
According to pivot table.For example：It can be seen that front two is 30 in Anhui Province's SIC code April 99 in 2016 from the PivotTables
Electricity sales amount is 128694.81 ten thousand kilowatt hours.
Embodiment described above is only that the preferred embodiment of the present invention is described, not to the model of the present invention
Enclose and be defined, on the premise of design spirit of the present invention is not departed from, technical side of the those of ordinary skill in the art to the present invention
In various modifications and improvement that case is made, the protection domain that claims of the present invention determination all should be fallen into.
Claims (6)
1. the statistical calculation method of the upper bore commercial power of a kind of rule, it is characterised in that comprise the following steps：
（1）The Gui Shang industrial enterprises directory data provided by statistics bureau is provided；
（2）Analyze the Industry enterprise customer information counted by Utilities Electric Co.；
（3）Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched, foundation meets of that month actual feelings
The matching list of condition；
（4）Classification processing is carried out to a family multilist present in matching list and many family situations of a table；
（5）Statistical calculation branch trade, the upper industrial electricity of rule in analysis area, and statistical calculation result is passed through into PivotTables
It is shown.
2. the statistical calculation method of the upper bore commercial power of rule according to claim 1, it is characterised in that：The step
（3）In, Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched using big data matching technique, built
The vertical matching list for meeting of that month actual conditions, specifically includes following steps：
（31）The Gui Shang industrial enterprises register provided using word participle techniques Statistics Bureau of Shanxi Province and provincial electric power company enterprise customer
Information table is pre-processed, and extracts the keyword in enterprise name；
（32）Full-text index is set up to the enterprise name in Utilities Electric Co.'s user message table using Oracle Text indexes documents；
（33）Matched, looked into enterprise's row in Utilities Electric Co.'s user message table with keyword with oracle softwares
Matching is looked for, 100% consistent enterprise is verified out.
3. the statistical calculation method of the upper bore commercial power of rule according to claim 1, it is characterised in that：The step
（3）In, Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched using artificial check method, set up
Meet the matching list of of that month actual conditions, specifically include following steps：
（3A）Based on computer search keyword, extract trading company therein and scanned for as keyword；
（3B）If failing to search correspondence enterprise, separation computer search keyword contiguous field, shortening main title, selection
Region adds main title, selection main title plus management functions mode to expand hunting zone；
（3C）If on the basis of first two steps, searching many enterprises, believed by contrasting enterprise of statistics bureau with Utilities Electric Co. user
Title, address, management functions, the trade information of Xi Biaozhong enterprises are confirmed whether it is same enterprise；
（3D）If in step（3A）And step（3B）On the basis of, any enterprise is not searched out, then passes through national credit information of enterprise
Publicity system, search enterprise whether rename, whether relevant enterprise, whether be group company；
（3E）If not matching the enterprise also by above step step, these Gui Shang enterprises lists are filtered out, are given respectively
Statistics Bureau of Shanxi Province and provincial electric power company, office and Utilities Electric Co. to be counted examine company information, enterprise's electricity charge and paid after mode again respectively
Carry out the matching of a new round.
4. the statistical calculation method of the upper bore commercial power of rule according to claim 2, it is characterised in that：The step
（3）In, Gui Shang industrial enterprises register and Utilities Electric Co.'s user basic information table are matched using big data matching technique, built
The vertical matching list for meeting of that month actual conditions, it is further comprising the steps of：
（34）The consistent or neighbouring enterprise in region is set as consistent enterprise；
（35）Matched with similarity of character string algorithm, verify out enterprise of the similarity 90%；
（36）Enterprise name in statistics bureau and Utilities Electric Co. that hand inspection goes out with similarity of character string algorithmic match, verification
Whether matching is effective, confirms to utilize computer big data matching technique achievement matching Number of Firms and the match is successful rate.
5. the statistical calculation method of the upper bore commercial power of rule according to claim 1, it is characterised in that：The step
（4）In, classification processing is carried out to a family multilist present in matching list and many family situations of a table, following steps are specifically included：
（41）Judge whether the industrial enterprise in matching list belongs to not while producing according to Gui Shang industrial enterprises major product code
With the product of big/middle class industry, trade classification is carried out according to following two different situations respectively：
（41A）Whether be a family multilist enterprise, if so, the industry code then provided according to Utilities Electric Co. is divided if confirming the enterprise
Class, different industries are included into by it respectively；
（41B）If the upper Industry enterprise customer of multiple rule shares one piece of ammeter, it is individually taken out from database, carried out complete
The accurate matching of name and artificial treatment, verify authenticity and secondary determination Utilities Electric Co. Customs Assigned Number pass corresponding with business code
System；
（42）The other information obtained according to power plant's title, address and internet hunt, manually with Gui Shang industrial enterprises register
Matched, Gui Shang industrial enterprises and power plant's numbering matching list are formed, it is determined that the industry attribute for the power plant that generates power for their own use；
（43）According to the administrative division in Gui Shang industrial enterprises of statistics bureau register, the industrial enterprise in matching list is carried out by area
Classification.
6. the statistical calculation method of the upper bore commercial power of rule according to claim 1, it is characterised in that：The step
（5）In, the upper industrial electricity of rule of statistical calculation branch trade region-by-region specifically includes following steps：
（51）The query statistic office unique business electrical amount of three bit codes, according to secondly bit code statistic of classification electricity；
（52）The not unique enterprise of three bit codes of query statistic office, statistic of classification electricity is carried out according to the industry code of power network；
（53）Inquiry enterprise generates power for their own use electricity, according to secondly bit code or three bit code statistic of classification electricity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710371989.0A CN107248027A (en) | 2017-05-24 | 2017-05-24 | A kind of statistical calculation method of the upper bore commercial power of rule |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710371989.0A CN107248027A (en) | 2017-05-24 | 2017-05-24 | A kind of statistical calculation method of the upper bore commercial power of rule |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107248027A true CN107248027A (en) | 2017-10-13 |
Family
ID=60017046
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710371989.0A Pending CN107248027A (en) | 2017-05-24 | 2017-05-24 | A kind of statistical calculation method of the upper bore commercial power of rule |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107248027A (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411766A (en) * | 2011-12-29 | 2012-04-11 | 国网信息通信有限公司 | Data analysis platform and method for electric power system |
| CN104346470A (en) * | 2014-11-18 | 2015-02-11 | 云南云电同方科技有限公司 | Query and analysis method for electricity marketing data |
| CN104375992A (en) * | 2013-08-12 | 2015-02-25 | 中国移动通信集团浙江有限公司 | Address matching method and device |
| CN104504479A (en) * | 2015-01-05 | 2015-04-08 | 国家电网公司 | Temperature/ economic growth factor considered monthly total electricity consumption predication method |
| US20150154616A1 (en) * | 2012-06-21 | 2015-06-04 | Korea Institute Of Science And Technology Information | Method and system for providing service for analyzing technology market through connection network for product supply and demand |
| CN105096214A (en) * | 2015-08-15 | 2015-11-25 | 国家电网公司 | Power marketing data acquisition method |
-
2017
- 2017-05-24 CN CN201710371989.0A patent/CN107248027A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102411766A (en) * | 2011-12-29 | 2012-04-11 | 国网信息通信有限公司 | Data analysis platform and method for electric power system |
| US20150154616A1 (en) * | 2012-06-21 | 2015-06-04 | Korea Institute Of Science And Technology Information | Method and system for providing service for analyzing technology market through connection network for product supply and demand |
| CN104375992A (en) * | 2013-08-12 | 2015-02-25 | 中国移动通信集团浙江有限公司 | Address matching method and device |
| CN104346470A (en) * | 2014-11-18 | 2015-02-11 | 云南云电同方科技有限公司 | Query and analysis method for electricity marketing data |
| CN104504479A (en) * | 2015-01-05 | 2015-04-08 | 国家电网公司 | Temperature/ economic growth factor considered monthly total electricity consumption predication method |
| CN105096214A (en) * | 2015-08-15 | 2015-11-25 | 国家电网公司 | Power marketing data acquisition method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Xu et al. | Disruption risks in supply chain management: a literature review based on bibliometric analysis | |
| Ajao et al. | Evolution and development of auditing | |
| CN107239892B (en) | Regional talent supply and demand balance quantitative analysis method based on big data | |
| US7940899B2 (en) | Fraud detection, risk analysis and compliance assessment | |
| CN109242664B (en) | Tax payment risk prediction method for newly-established enterprise | |
| WO2011022499A1 (en) | Process and method for data assurance management by applying data assurance metrics | |
| JP2008515094A (en) | Systems, software, and methods for searching a database in a forensic accounting environment | |
| CN112632405B (en) | Recommendation method, recommendation device, recommendation equipment and storage medium | |
| Hamad et al. | An enhanced technique to clean data in the data warehouse | |
| CN108304990B (en) | Power failure sensitivity pre-judging method and system | |
| CN111191123A (en) | Business information pushing method and device, readable storage medium and computer equipment | |
| CN114911908A (en) | Method and device for pipe network data security management | |
| Chen et al. | Formerly assembled, but now designed in China? Assessing the domestic value-added of activities in gross exports | |
| Purnomo et al. | E-Finance Publication Mapping: A Bibliometric Constructing Networks during Four Decades | |
| CN109284978B (en) | System and method for accurately identifying poverty-stricken user | |
| Lidyah et al. | The Evolution of Accounting Information Systems Research: A Bibliometric Analysis of Key Concepts and Influential Authors | |
| Goasdoué et al. | An Evaluation Framework For Data Quality Tools. | |
| CN107248027A (en) | A kind of statistical calculation method of the upper bore commercial power of rule | |
| CN114265887A (en) | Dimension data processing method and device, storage medium and electronic equipment | |
| CN113590684A (en) | Non-tax payment big data analysis system | |
| KR100921217B1 (en) | System and method for estimating income | |
| Dahiya et al. | Enhancing consistency of conceptual data warehouse design | |
| Khansong et al. | Customer Service Improvement based on Electricity Payment Behaviors Analysis using Data Mining Approaches | |
| TWM569465U (en) | Regulatory compliance processing device for auditing | |
| CN112488572B (en) | Audit object recommendation method, device, equipment and medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171013 |