CN108228550B - Statistical line loss automatic calculation and report generation system applied to power supply system - Google Patents
Statistical line loss automatic calculation and report generation system applied to power supply system Download PDFInfo
- Publication number
- CN108228550B CN108228550B CN201711323234.XA CN201711323234A CN108228550B CN 108228550 B CN108228550 B CN 108228550B CN 201711323234 A CN201711323234 A CN 201711323234A CN 108228550 B CN108228550 B CN 108228550B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- data report
- information
- module
- 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
- 238000004364 calculation method Methods 0.000 title claims abstract description 100
- 238000000034 method Methods 0.000 claims abstract description 16
- 230000005611 electricity Effects 0.000 claims description 30
- 230000008676 import Effects 0.000 claims description 24
- 238000000926 separation method Methods 0.000 claims description 16
- 230000005540 biological transmission Effects 0.000 claims description 13
- 230000002441 reversible effect Effects 0.000 claims description 10
- 230000008859 change Effects 0.000 claims description 7
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 238000007726 management method Methods 0.000 claims description 5
- 238000004458 analytical method Methods 0.000 claims description 4
- 238000009795 derivation Methods 0.000 claims description 3
- 230000000694 effects Effects 0.000 abstract description 5
- 230000006870 function Effects 0.000 description 14
- 238000010586 diagram Methods 0.000 description 5
- 239000000284 extract Substances 0.000 description 5
- 238000005259 measurement Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000005070 sampling Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 2
- 230000005856 abnormality Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001360 synchronised effect Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Water Supply & Treatment (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
The invention provides a system for automatically calculating and generating a statistical line loss report applied to a power supply system, which relates to the technical field of data statistics and comprises a first data report generating module, a second data report generating module and a first data report generating module, wherein the first data report generating module is used for collecting power utilization information in a power utilization information collecting system and generating the first data report and the second data report based on the power utilization information; the second data report generation module is used for acquiring business data in the marketing business application system, generating a third data report based on the business data and generating a sub data report based on the third data report; and the third data report generating module is used for generating a fourth data report based on the third data report and the sub data report. The invention solves the technical problems of complex working procedure, low accuracy and low working efficiency when the calculation of the statistical line loss and the generation of the report are carried out in the prior art, and achieves the technical effects of simple working procedure, high accuracy and high working efficiency when the automatic calculation of the statistical line loss and the generation of the report are carried out.
Description
Technical Field
The invention relates to the technical field of data statistics, in particular to a system for automatically calculating and generating a report of statistical line loss applied to a power supply system.
Background
In the prior art, the data is collected and used basically by references in worksheets, references between workbooks, and links, for example, the storage location of a file changes, and once a link is updated by mistake, a source file cannot be found or an original calculation result is lost.
In the existing calculation mode, because the space characteristic description information quantity is small, codes are easy to confuse, a plurality of required fields are needed, and at least 7 fields can completely describe the accurate voltage grade, voltage grade category, incoming line/main transformer three-side/outgoing line, direct supply/public, belonging transformer substation and belonging power supply station. In the prior art, a VLOOKUP function is required to be used for searching and referencing, when a column is inserted/deleted in front of a target column of an area to be searched, the number of the target column is increased/reduced, and all cells adopting the formula need to be changed. In the prior art, the classification statistics mostly use the SURMODUCT function, and the function relationship is complicated and the parameters are too many.
No effective solution has been proposed to the above problems.
Disclosure of Invention
In view of the above, the present invention provides an automatic statistical line loss calculation and report generation system applied to a power supply system, so as to solve the technical problems of complex working procedures, low accuracy and low working efficiency when performing statistical line loss calculation and report generation in the prior art.
In a first aspect, an embodiment of the present invention provides an automatic statistical line loss calculation and report generation system applied to a power supply system, including: the power consumption information acquisition system comprises a first data report generation module, a second data report generation module and a power consumption information acquisition module, wherein the first data report generation module is used for acquiring power consumption information in the power consumption information acquisition system and generating a first data report and a second data report based on the power consumption information, the first data report comprises electricity sales year prediction data, and the second data report comprises first electricity calculation information of a power grid and second electricity calculation information of the power grid; the second data report generation module is used for acquiring business data in a marketing business application system, generating a third data report based on the business data, and generating a sub-data report based on the third data report, wherein the third data report comprises third electric quantity calculation information of a power grid and fourth electric quantity calculation information of the power grid, the sub-data report comprises a line loss summary report, and the line loss report and a report settlement synchronization caliber data report; a third data report generating module, configured to generate a fourth data report based on the third data report and the sub data report, where the fourth data report includes at least five of the following: the system comprises an agricultural power line loss monthly report, a partial pressure line loss condition table, a partial pressure line loss statistical table, a meeting report and a management monthly report.
Further, the first data table generating module includes: wholesale group measurement point character section separation and import module, transformer substation's terminal group measurement point character section separation and import module and first generation submodule, wherein, wholesale group measurement point character section separation and import module for obtain the character set of every measurement point in the power consumption information acquisition system, and in extract multiple field in the character set, wherein, multiple field includes following at least four kinds: the number of the metering points, the lower bottom of the forward total active power, the lower bottom of the reverse total active power and the multiplying power; the transformer substation terminal group metering point field separating and importing module is used for obtaining a metering point field of each transformer substation in the electricity utilization information acquisition system and extracting various fields from the metering point field, wherein the various fields comprise at least four of the following fields: the number of the measuring points is numbered, the lower bottom of the forward total active power is shown, the lower bottom of the reverse total active power is shown, and the multiplying power is shown; the first generation submodule is used for generating a first sub-report of the first data report and a second data report based on the wholesale group metering point field separating and importing module and the information contained in the various fields extracted by the substation terminal group metering point field separating and importing module, the first data report comprises annual prediction data of electricity sales, and the first sub-report comprises first electricity calculation information of a power grid.
Further, the first data table generating module further includes: a second generation submodule, configured to generate a second sub-report of a second data report based on the information included in the multiple fields extracted by the wholesale group metering point field separating and importing module and the substation terminal group metering point field separating and importing module, where the second sub-report includes second electric quantity calculation information of the power grid, and the second electric quantity calculation information of the power grid includes at least eight kinds of data at intervals of the substation: the transformer substation interval measuring method comprises the following steps of measuring point number, interval type, bus balance rate type, interval name, active upper and lower tables, active lower and lower tables, multiplying power and bus balance rate, wherein the transformer substation interval category comprises the following steps: incoming lines, three sides of a main transformer, 35kV outgoing lines, 10kV outgoing lines and station power utilization.
Further, the second datagram generation module includes: the marketing business application system data import module is used for importing business data collected from the marketing business application system into the third data report, wherein the business data comprises at least four of the following data: the line is detailed, the monthly report is applied, the power supply station is low-voltage, and the platform area is detailed; the third generating submodule is configured to generate a third data report based on the service data, where the third data report includes third electric quantity calculation information of the power grid and fourth electric quantity calculation information of the power grid, and the third electric quantity calculation information of the power grid includes at least four data: marketing, selling electricity, looped netowrk, distribution, the fourth electric quantity calculation information of electric wire netting includes following six kinds of data at least: the system comprises a power divider, a voltage divider, a substation, a main transformer, a bus and power transmission.
Further, the second datagram table generating module further includes: the electric quantity calculation result export module is used for exporting the electric quantity calculation result contained in the third data report; the fourth generating submodule is configured to generate the sub data report based on the electric quantity calculation result included in the third data report, where the sub data report includes a line loss summary report, a line loss reporting report, and a report settlement synchronization aperture data report, and the line loss summary report includes at least nine kinds of data: the system comprises a branch station, a voltage division, a power distribution, a branch station, a branch main transformer, a bus, a power transmission, a direct supply and a low voltage, wherein the line loss report comprises at least eight kinds of data: partial pressure assessment, foundation, monthly statement, analysis, planning, market level, management and calendar months.
Further, the system further comprises: each voltage level bus balance fine-tuning module is used for acquiring target information, calculating the target information according to a preset calculation sequence to obtain a calculation result, and storing the calculation result into the second data report, wherein the target information comprises at least one of the following: abnormal information of the upper and lower bottoms, replacement information of the meter or magnification change information of the metering point; and for the abnormal information of the upper and lower bottoms, the replacement information of the meters or the magnification change information of the metering points, calculating according to the sequence of calculating 110kV incoming lines, calculating 35kV incoming lines, calculating middle and low voltages by high voltage calculation, calculating high voltage by middle and low voltage calculation, calculating high voltage by incoming lines, calculating two coils of low voltage by incoming lines, calculating 35kV outgoing lines and calculating 10kV outgoing lines, and storing the calculation results into a second sub-report of the second data report.
Further, the system further comprises: the system comprises an account password and group number module, wherein the account password and group number module is used for storing a user account, an account password and a group number, the account password is an account and a password of an electricity consumption information acquisition system and a marketing service application system, and the group number is a number of a wholesale group and a terminal group of a transformer substation.
Further, the system further comprises: an index calculation module for calculating a plurality of indexes including at least two sets of information consisting of: power supply amount, power selling amount, line loss rate, previous period value, current period value and growth rate; wherein the power supply amount, the power selling amount and the line loss rate form a first group of information, and the future value, the present value and the growth rate form a second group of information.
Further, the system further comprises: the transformer substation positioning module is used for providing a query positioning function for a user, wherein the query positioning function is a function of querying a target transformer substation in a transformer substation list and displaying electric power information of the target transformer substation.
In a second aspect, an embodiment of the present invention further provides a power supply system model description, which includes the above system for automatically calculating and reporting the statistical line loss, and further includes a power supply system body, where the system for automatically calculating and reporting the statistical line loss is used to calculate the line loss of the power supply system body in an electric energy transmission process and generate a corresponding line loss report.
The invention provides a statistical line loss automatic calculation and report generation system applied to a power supply system, which comprises: the first data report generation module is used for acquiring the electricity utilization information in the electricity utilization information acquisition system and generating a first data report and a second data report based on the electricity utilization information; the second data report generation module is used for acquiring business data in a marketing business application system, generating a third data report based on the business data and generating a sub data report based on the third data report; and the third data report generating module is used for generating a fourth data report based on the second data report and the sub data report. The invention solves the technical problems of complex working procedure, low accuracy and low working efficiency when the calculation of the statistical line loss and the generation of the report are carried out in the prior art, and achieves the technical effects of simple working procedure, high accuracy and high working efficiency when the automatic calculation of the statistical line loss and the generation of the report are carried out.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
In order to make the aforementioned and other objects, features and advantages of the present invention comprehensible, preferred embodiments accompanied with figures are described in detail below.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
Fig. 1 is a schematic diagram of an automatic statistical line loss calculation and report generation system applied to a power supply system according to an embodiment of the present invention;
fig. 2 is a detailed schematic diagram of a first data report generation module and a second data report generation module according to an embodiment of the present invention;
fig. 3 is a detailed schematic diagram of an automatic statistical line loss calculation and report generation system applied to a power supply system according to an embodiment of the present invention;
fig. 4 is an effect diagram of the automatic statistical line loss calculation and report generation system applied to the power supply system according to the embodiment of the present invention.
Detailed Description
To make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings, and it is apparent that the described embodiments are some, but not all embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The first embodiment is as follows:
in accordance with an embodiment of the present invention, there is provided an embodiment of an automatic statistical line loss calculation and report generation system for a power supply system, it should be noted that the steps illustrated in the flowchart of the drawings may be performed in a computer system such as a set of computer executable instructions, and that while a logical order is illustrated in the flowchart, in some cases the steps illustrated or described may be performed in an order different than here.
Fig. 1 is a schematic diagram of an automatic statistical line loss calculation and report generation system applied to a power supply system according to an embodiment of the present invention, as shown in fig. 1, the automatic statistical line loss calculation and report generation system applied to the power supply system includes: a first data table generating module 10, a second data table generating module 20, and a third data table generating module 30.
Specifically, the first data report generation module 10 is configured to collect power consumption information in a power consumption information collection system, and generate a first data report and a second data report based on the power consumption information, where the first data report includes year-predicted power sale amount data, and the second data report includes first power amount calculation information of a power grid and second power amount calculation information of the power grid;
the second data report generating module 20 is configured to collect service data in a marketing service application system, generate a third data report based on the service data, and generate a sub data report based on the third data report, where the third data report includes third electric quantity calculation information of a power grid and fourth electric quantity calculation information of the power grid, the sub data report includes a line loss summary report, and the line loss report and a report settlement synchronization aperture data report;
a third data report generating module 30, configured to generate a fourth data report based on the third data report and the sub data report, where the fourth data report includes at least five of the following: the system comprises an agricultural power line loss monthly report, a partial pressure line loss condition table, a partial pressure line loss statistical table, a meeting report and a management monthly report.
The invention provides a statistical line loss automatic calculation and report generation system applied to a power supply system, wherein the system comprises a first data report generation module, a second data report generation module and a first data report generation module, wherein the first data report generation module is used for collecting power utilization information in a power utilization information collection system and generating a first data report and a second data report based on the power utilization information; the second data report generation module is used for acquiring business data in a marketing business application system, generating a third data report based on the business data and generating a sub data report based on the third data report; and the third data report generating module is used for generating a fourth data report based on the third data report and the sub data report. The invention solves the technical problems of complex working procedure, low accuracy and low working efficiency when the calculation of the statistical line loss and the generation of the report are carried out in the prior art, and achieves the technical effects of simple working procedure, high accuracy and high working efficiency when the automatic calculation of the statistical line loss and the generation of the report are carried out.
Next, the automatic statistical line loss calculation and report generation system applied to the power supply system will be described in detail with reference to fig. 2 to 4.
In this embodiment of the present invention, as shown in fig. 2, the first data table generating module includes: a wholesale group metering point character section separation and import module 101, a substation terminal group metering point character section separation and import module 102 and a first generation submodule 103.
The wholesale group metering point field separation and import module 101 is configured to obtain a character set of each metering point in the power consumption information acquisition system, and extract various fields in the character set, where the various fields include at least four of the following: the number of the metering points, the lower bottom of the forward total active power, the lower bottom of the reverse total active power and the multiplying power;
the substation terminal group metering point field separating and importing module 102 is configured to obtain a metering point field of each substation in the electricity information collection system, and extract various fields from the metering point field, where the various fields include at least four of the following fields: the number of the measuring points is numbered, the lower bottom of the forward total active power is shown, the lower bottom of the reverse total active power is shown, and the multiplying power is shown;
the first generation submodule 103 is configured to generate a first sub-report of the first data report and the second data report based on the information contained in the multiple fields extracted by the wholesale group metering point field separation and import module 101 and the substation terminal group metering point field separation and import module 102, the first data report includes annual prediction data of electricity sales, and the first sub-report includes first electricity calculation information of a power grid.
In this embodiment of the present invention, the first data report may also be referred to as an annual prediction report of electricity sales, and the first sub-report of the first data report and the second data report include information such as the number of the metering points obtained by the wholesale group metering point field splitting and importing module 101 and the substation terminal group metering point field splitting and importing module 102, the total positive active power lower table, the total reverse active power lower table, and the multiplying power.
In this embodiment of the present invention, as shown in fig. 2, the first data table generating module further includes: a second generation submodule 104.
The second generation sub-module 104 is configured to generate a second sub-report in a second data report based on the multiple fields extracted by the wholesale group metering point field separation and import module 101 and the substation terminal group metering point field separation and import module 102, where the second sub-report includes second electric quantity calculation information of the power grid, and the second electric quantity calculation information of the power grid includes at least eight kinds of following data at a substation interval: the transformer substation interval measuring method comprises the following steps of measuring point number, interval type, bus balance rate type, interval name, active upper and lower tables, active lower and lower tables, multiplying power and bus balance rate, wherein the transformer substation interval category comprises the following steps: incoming lines, three sides of a main transformer, 35kV outgoing lines, 10kV outgoing lines and station power utilization.
In this embodiment of the present invention, the second datagram table includes: the method comprises the steps of using a sampling page and a power supply page, wherein the sampling page comprises information such as a metering point number, a forward total active lower bottom, a reverse total active lower bottom, multiplying power and the like; the power supply page comprises information such as a metering point number, a space name, a space type, a bus balance rate type, an active upper surface bottom, an active lower surface bottom, a forward total active power, a reverse total active power, multiplying power, a bus balance rate and the like; the sampling page comprises the following steps: the wholesale group metering point field separation and import module 101 extracts the feeding electric quantity data information of the upper-level power grid and the substation terminal group metering point field separation and import module 102 extracts the electric quantity data information of each substation of the county-level (current-level) power grid.
In the embodiment of the invention, a part of fields are uniquely defined, wherein the interval name is used for realizing uniqueness of the interval name of the whole county area, and the short name of the substation to which the transformer substation belongs and the conventional interval name are combined into the interval name of the embodiment of the invention. For example: the Yao-Yao Meng line (obverse) and the Meng-Yao Meng line (reverse) are two completely different table codes.
The interval type is designed for summarizing power information of each type, wherein the interval types are 29 in number and comprise: external 110kV inlet wire, external 35kV inlet wire, external 110kV junctor end, external 35kV junctor end, 110kV inlet wire end, 35kV inlet wire end, 110kV junctor head end reversal, 35kV junctor head end reversal, three main transformer high-voltage sides, three main transformer medium-voltage sides, three main transformer low-voltage sides, two main transformer high-voltage sides, two main transformer low-voltage sides, affiliated power supply station, 35kV direct-supply affiliated power supply station, 10kV direct-supply affiliated power supply station, photovoltaic, bypass, condenser, 35kV station power consumption, 10kV station power consumption, station life, retreat transportation.
The bus balance rate types are designed for facilitating fine adjustment of the bus balance rate of each voltage class, wherein the bus balance rate types are 9 in total and comprise: 110kV bus, 110kV main transformer, 110kV #1 main transformer, 110kV #2 main transformer, 35kV bus, 35kV main transformer, 35kV #1 main transformer, 35kV #2 main transformer and 10kV bus.
In this embodiment of the present invention, as shown in fig. 2, the second datagram generating module 20 includes: a marketing service application system data import module 201 and a third generation sub-module 202.
The marketing business application system data import module 201 is configured to import business data collected from the marketing business application system into the third data report, where the business data includes at least four of the following: the line is detailed, the monthly report is applied, the power supply station is low-voltage, and the platform area is detailed; the third generating sub-module 202 is configured to generate a third data report based on the service data, where the third data report includes third electric quantity calculation information of the power grid and fourth electric quantity calculation information of the power grid, and the third electric quantity calculation information of the power grid includes at least four data: marketing, selling electricity, looped netowrk, distribution, the fourth electric quantity calculation information of electric wire netting includes following six kinds of data at least: the system comprises a power divider, a voltage divider, a substation, a main transformer, a bus and power transmission.
In this embodiment of the present invention, the marketing business application system data import module 201 is configured to import business data in a marketing business system into the third data report, and the third generation sub-module 202 is configured to generate the third data report based on the business data, where the third data report includes: the system comprises a marketing page, a power selling page, a ring network page, a power distribution page, a sub-page, a voltage dividing page, a substation page, a sub-main substation page, a bus page and a power transmission page.
The marketing page, the electricity selling page, the ring page and the power distribution page comprise: the interval type, the line code, the line name, the power supply amount of the low-voltage side of the public transformer, the electricity selling amount of the public transformer user, the electricity selling amount of the special transformer user, the meter reading amount of the special transformer user, the electricity loss amount of the special transformer and the like.
The branch page comprises: the information of interval type, name of power supply station, power supply quantity, power selling quantity, line loss rate, 35kV direct supply line, 10kV public line, 10kV direct supply line, public transformer area, low voltage and the like.
The partial pressure page includes: interval type, report form, settlement, synchronization, power supply quantity and electricity selling quantity of each voltage grade line, main transformer, comprehensive equal caliber and the like.
The substation page, divide the owner to become the page, the generating line page with the power transmission page includes: interval type, power supply quantity, power selling quantity, line loss rate and the like.
In this embodiment of the present invention, as shown in fig. 2, the second datagram generation module further includes: an electric quantity calculation result derivation module 211 and a fourth generation submodule 212.
The electric quantity calculation result derivation module 211 is configured to derive an electric quantity calculation result included in the third data report; the fourth generating submodule 212 is configured to generate the sub data report based on the electric quantity calculation result included in the third data report.
In an embodiment of the present invention, the third data report includes: the line loss summary report form, the line loss report form and the report form settlement synchronous aperture data report form, wherein, the line loss summary report form includes: the system comprises a page dividing page, a voltage dividing page, a power distribution page, a substation page, a main transformer page, a bus page, a power transmission page, a direct supply page and a low-voltage page; the line loss reporting report comprises the following steps: the system comprises a partial pressure assessment page, a basic page, a monthly newspaper page, an analysis page, a planning page, a market level page, an operation page and an annual calendar month page.
Specifically, the line loss summary report, the line loss reporting report and the report settlement synchronization aperture data report are reports containing current-year electric quantity data information and last-year electric quantity data information, so that comparison and analysis of two-year electric quantity data information are facilitated.
In the embodiment of the present invention, as shown in fig. 3, the system further includes: the transformer substation positioning module 40 is used for providing a query positioning function for a user, wherein the query positioning function is a function of querying a target transformer substation in a transformer substation list and displaying power information of the target transformer substation.
In the embodiment of the invention, for some metering point meters without uploading function in the transformer substation, a user can select the transformer substation in the transformer substation positioning module 40, and the transformer substation positioning module 40 positions the power information of the transformer substation as the current line, so that the user can conveniently copy the power information in the transformer substation manually.
In the embodiment of the present invention, as shown in fig. 3, the system further includes: each voltage level bus balance fine-tuning module 50 is configured to acquire target information, calculate the target information according to a preset calculation order to obtain a calculation result, and store the calculation result in a second sub-report in the second data report, where the target information includes at least one of the following: abnormal information on the upper and lower tables, replacement information of the meter, and magnification change information of the measuring point.
And for the abnormal information of the upper and lower bottoms, the replacement information of the meters or the magnification change information of the metering points, calculating according to the sequence of calculating 110kV incoming lines, calculating 35kV incoming lines, calculating middle and low voltage by high voltage calculation, calculating high voltage by middle and low voltage calculation, calculating high voltage by incoming lines, calculating two coils of low voltage by incoming lines, calculating 35kV outgoing lines and calculating 10kV outgoing lines, and storing the calculation results into the second data report.
In the embodiment of the present invention, when the conditions such as an abnormality at the bottom of the lower table, replacement of the meter, or change of the multiplying power of the metering point occur, the bus balance fine adjustment module 50 for each voltage class calculates according to the sequence of calculating 110kV incoming line, calculating 35kV incoming line, calculating high voltage of the high voltage, calculating medium and low voltage of the medium and low voltage, calculating high voltage of the incoming line, calculating two-coil low voltage of the incoming line, calculating 35kV outgoing line, and calculating 10kV outgoing line. And the calculation result is stored in the page of the second data report, the partial pressure page, the substation page, the main substation page, the bus and the power transmission page, so that the second data report is updated.
In the embodiment of the present invention, as shown in fig. 3, the system further includes: an index calculation module 60, the index calculation module 60 being configured to calculate a plurality of indexes, the plurality of indexes including at least two sets of information consisting of: power supply amount, power selling amount, line loss rate, previous period value, current period value and growth rate; wherein the power supply amount, the power selling amount and the line loss rate form a first group of information, and the future value, the present value and the growth rate form a second group of information.
In the embodiment of the present invention, given two data in any set of data, the index calculation module 60 can automatically calculate the third data, so that the user is prevented from the trouble of memorizing formulas and calculating with a calculator.
In the embodiment of the present invention, as shown in fig. 3, the system further includes: and an account password and group number module 70, where the account password and group number module 70 is configured to store a user account, an account password, and a group number, where the account password is an account and a password of the power consumption information acquisition system and the marketing service application system, and the group number is a number of metering points of a wholesale group and a terminal group of a transformer substation.
In the embodiment of the present invention, the account password and group number module 70 stores a user account, an account password and a group number, which is convenient for a user to quickly access and avoids the situations of password memory and input errors.
In the embodiment of the present invention, the system for automatically calculating and reporting a statistical line loss further includes a power supply system body, and the system for automatically calculating and reporting a statistical line loss is used for calculating a line loss of the power supply system body in an electric energy transmission process and generating a corresponding line loss report.
The system for automatically calculating the statistical line loss and generating the report can realize the specific functions through related software so as to achieve the corresponding technical effect.
Specifically, in the embodiment of the present invention, the system For automatically calculating statistical line loss and generating reports generates menus and Forms by referring to Visual Basic For Applications and MS Forms 2.0Object library, and controls the program operation flow; the system realizes functions of pure value pasting, field separation, reference, sorting, calculation, summarization, table and the like by referencing MS Excel 14.0 Object Lirary and OLE Automation; the system generates a Word file by referring to MS Word 15.0Object Lirary, and realizes the functions of writing data into the Word file, setting format and the like; in addition, the system is also designed in a humanized manner, a prompt window pops up after each step is executed, the window disappears after being displayed for 2 seconds, and meanwhile, the menu button icons of the step are changed from specific icons to 'finished' icons, so that a user can conveniently and visually know the completion condition of the work.
In the embodiment of the present invention, a unique dictionary table is further designed for the automatic statistical line loss calculation and report generation system, where the dictionary table is designed for the convenience of summarizing various types of statistical tables, and the number of the dictionary tables is 8: the number of the start and stop lines of data of each transformer substation, the total number of the transformer substations, the total number of power supply stations, the number of 35kV direct supply affiliated power supply stations, the number of 10kV direct supply affiliated power supply stations, the total number of distribution lines, the total number of bus bars of the transformer substations and the total number of external and contact power transmission lines; the dictionary table is automatically generated by the system.
In the embodiment of the invention, the system can be applied to the calculation work of the statistical line loss of the metro-level power supply company as long as the interval type and the bus balance rate type in the automatic statistical line loss calculation and report generation system are expanded.
In the embodiment of the invention, the control of the automatic statistical line loss calculation and report generation system can be transplanted to the WPS ET system by only changing the control of the automatic statistical line loss calculation and report generation system to the control of the same type in the WPS ET; in addition, the automatic statistical line loss calculation and report generation system can be modified into a system structure of a B/S (Browser/Server) by using a WWW Browser, Script language, Active X, ASP (Active Server Pages) technology and SQL language.
In addition, in the description of the embodiments of the present invention, unless otherwise explicitly specified or limited, the terms "mounted," "connected," and "connected" are to be construed broadly, e.g., as meaning either a fixed connection, a removable connection, or an integral connection; can be mechanically or electrically connected; they may be connected directly or indirectly through intervening media, or they may be interconnected between two elements. The specific meanings of the above terms in the present invention can be understood in specific cases to those skilled in the art.
In the description of the present invention, it should be noted that the terms "center", "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer", etc., indicate orientations or positional relationships based on the orientations or positional relationships shown in the drawings, and are only for convenience of description and simplicity of description, but do not indicate or imply that the device or element being referred to must have a particular orientation, be constructed and operated in a particular orientation, and thus, should not be construed as limiting the present invention. Furthermore, the terms "first," "second," and "third" are used for descriptive purposes only and are not to be construed as indicating or implying relative importance.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units is only one logical division, and there may be other divisions when actually implemented, and for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection of devices or units through some communication interfaces, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit.
The functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a non-volatile computer-readable storage medium executable by a processor. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
Finally, it should be noted that: the above-mentioned embodiments are only specific embodiments of the present invention, which are used for illustrating the technical solutions of the present invention and not for limiting the same, and the protection scope of the present invention is not limited thereto, although the present invention is described in detail with reference to the foregoing embodiments, those skilled in the art should understand that: any person skilled in the art can modify or easily conceive the technical solutions described in the foregoing embodiments or equivalent substitutes for some technical features within the technical scope of the present disclosure; such modifications, changes or substitutions do not depart from the spirit and scope of the embodiments of the present invention, and they should be construed as being included therein. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. An automatic statistical line loss calculation and report generation system applied to a power supply system is characterized by comprising:
the power consumption information acquisition system comprises a first data report generation module, a second data report generation module and a power consumption information acquisition module, wherein the first data report generation module is used for acquiring power consumption information in the power consumption information acquisition system and generating a first data report and a second data report based on the power consumption information, the first data report comprises electricity sales year prediction data, and the second data report comprises first electricity calculation information of a power grid and second electricity calculation information of the power grid;
the second data report generation module is used for acquiring business data in a marketing business application system, generating a third data report based on the business data, and generating a sub-data report based on the third data report, wherein the third data report comprises third electric quantity calculation information of a power grid and fourth electric quantity calculation information of the power grid, the sub-data report comprises a line loss summary report, a line loss report and a report settlement synchronization caliber data report;
a third data report generating module, configured to generate a fourth data report based on the third data report and the sub data report, where the fourth data report includes at least five of the following: the system comprises an agricultural power line loss monthly report, a partial pressure line loss condition table, a partial pressure line loss statistical table, a meeting report and a management monthly report;
the second electric quantity calculation information of the power grid comprises at least eight kinds of data of the following transformer substation intervals: the transformer substation interval measuring method comprises the following steps of measuring point number, interval type, bus balance rate type, interval name, active upper and lower tables, active lower and lower tables, multiplying power and bus balance rate, wherein the transformer substation interval category comprises the following steps: incoming lines, three sides of a main transformer, 35kV outgoing lines, 10kV outgoing lines and station power utilization;
the third electric quantity calculation information of the power grid comprises at least four data: marketing, electricity selling, ring network and power distribution;
the fourth electric quantity calculation information of the power grid comprises at least six kinds of data: the system comprises a power divider, a voltage divider, a substation, a main transformer, a bus and power transmission.
2. The system of claim 1, wherein the first data table generation module comprises: a wholesale group metering point character section separation and import module, a transformer substation terminal group metering point character section separation and import module and a first generation submodule, wherein,
the wholesale group metering point character section separation and import module is used for acquiring the character set of each metering point in the electricity utilization information acquisition system and extracting various fields in the character set, wherein the various fields comprise at least four of the following fields: the number of the metering points, the lower bottom of the forward total active power, the lower bottom of the reverse total active power and the multiplying power;
the transformer substation terminal group metering point field separating and importing module is used for obtaining a metering point field of each transformer substation in the electricity utilization information acquisition system and extracting various fields from the metering point field, wherein the various fields comprise at least four of the following fields: the number of the measuring points is numbered, the lower bottom of the forward total active power is shown, the lower bottom of the reverse total active power is shown, and the multiplying power is shown;
the first generation submodule is used for generating a first sub-report of the first data report and a second data report based on the wholesale group metering point field separating and importing module and the information contained in the various fields extracted by the substation terminal group metering point field separating and importing module, the first data report comprises annual prediction data of electricity sales, and the first sub-report comprises first electricity calculation information of a power grid.
3. The system of claim 2, wherein the first data table generation module further comprises: a second generation submodule, wherein,
the second generation submodule is used for generating a second sub-report of a second data report based on the information contained in the various fields extracted by the wholesale group metering point field separating and importing module and the transformer substation terminal group metering point field separating and importing module, wherein the second sub-report contains second electric quantity calculation information of the power grid.
4. The system of claim 1, wherein the second datagram generation module comprises: a marketing business application system data import module and a third generation submodule, wherein,
the marketing business application system data import module is configured to import business data collected from the marketing business application system into the third data report, where the business data includes at least four of the following: the line is detailed, the monthly report is applied, the power supply station is low-voltage, and the platform area is detailed;
and the third generation submodule is used for generating a third data report based on the service data, wherein the third data report comprises third electric quantity calculation information of the power grid and fourth electric quantity calculation information of the power grid.
5. The system of claim 1 or 4, wherein the second datagram generation module further comprises: an electric quantity calculation result derivation module and a fourth generation submodule, wherein,
the electric quantity calculation result exporting module is used for exporting the electric quantity calculation result contained in the third data report;
the fourth generating submodule is configured to generate the sub data report based on the electric quantity calculation result included in the third data report, where the sub data report includes a line loss summary report, a line loss reporting report, and a report settlement synchronization aperture data report, and the line loss summary report includes at least nine kinds of data: the system comprises a branch station, a voltage division, a power distribution, a branch station, a branch main transformer, a bus, a power transmission, a direct supply and a low voltage, wherein the line loss report comprises at least eight kinds of data: partial pressure assessment, foundation, monthly statement, analysis, planning, market level, management and calendar months.
6. The system of claim 1, further comprising:
each voltage level bus balance fine-tuning module is used for acquiring target information, calculating the target information according to a preset calculation sequence to obtain a calculation result, and storing the calculation result into the second data report, wherein the target information comprises at least one of the following: abnormal information of the upper and lower bottoms, replacement information of the meter or magnification change information of the metering point;
and for the abnormal information of the upper and lower bottoms, the replacement information of the meters or the magnification change information of the metering points, calculating according to the sequence of calculating 110kV incoming lines, calculating 35kV incoming lines, calculating middle and low voltage by high voltage calculation, calculating high voltage by middle and low voltage calculation, calculating high voltage by incoming lines, calculating two coils of low voltage by incoming lines, calculating 35kV outgoing lines and calculating 10kV outgoing lines, and storing the calculation results into the second data report.
7. The system of claim 1, further comprising:
the system comprises an account password and group number module, wherein the account password and group number module is used for storing a user account, an account password and a group number, the account password is an account and a password of an electricity consumption information acquisition system and a marketing service application system, and the group number is a number of a wholesale group and a terminal group of a transformer substation.
8. The system of claim 1, further comprising:
an index calculation module for calculating a plurality of indexes including at least two sets of information consisting of: power supply amount, power selling amount, line loss rate, previous period value, current period value and growth rate; wherein the power supply amount, the power selling amount and the line loss rate form a first group of information, and the future value, the present value and the growth rate form a second group of information.
9. The system of claim 1, further comprising:
the transformer substation positioning module is used for providing a query positioning function for a user, wherein the query positioning function is a function of querying a target transformer substation in a transformer substation list and displaying electric power information of the target transformer substation.
10. A power supply system, comprising the automatic statistical line loss calculation and report generation system applied to the power supply system according to any one of claims 1 to 9, and further comprising a power supply system body, wherein the automatic statistical line loss calculation and report generation system applied to the power supply system is configured to calculate line loss of the power supply system body in an electric energy transmission process and generate a corresponding line loss report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711323234.XA CN108228550B (en) | 2017-12-12 | 2017-12-12 | Statistical line loss automatic calculation and report generation system applied to power supply system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711323234.XA CN108228550B (en) | 2017-12-12 | 2017-12-12 | Statistical line loss automatic calculation and report generation system applied to power supply system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108228550A CN108228550A (en) | 2018-06-29 |
| CN108228550B true CN108228550B (en) | 2021-08-10 |
Family
ID=62652040
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711323234.XA Active CN108228550B (en) | 2017-12-12 | 2017-12-12 | Statistical line loss automatic calculation and report generation system applied to power supply system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108228550B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111768177B (en) * | 2020-07-01 | 2023-05-09 | 国网四川省电力公司信息通信公司 | County-level power supply company operation analysis system and county-level power supply company operation analysis method |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101714234B (en) * | 2009-10-23 | 2012-09-26 | 西北电网有限公司 | Grid line loss monitoring and analyzing system |
| CN103177341A (en) * | 2013-03-29 | 2013-06-26 | 山东电力集团公司 | Line loss lean comprehensive management system and method |
| CN106991524A (en) * | 2017-03-20 | 2017-07-28 | 国网江苏省电力公司常州供电公司 | A kind of platform area line loss per unit predictor method |
-
2017
- 2017-12-12 CN CN201711323234.XA patent/CN108228550B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN108228550A (en) | 2018-06-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101988961B (en) | Geographic location data collecting system | |
| CN108335216A (en) | A kind of insurance risk assessment method, apparatus, terminal device and storage medium | |
| US9816836B2 (en) | Correlating meter data to detect mismappings | |
| CN113283096A (en) | Method for acquiring distribution network line account data and analyzing abnormal data and related device | |
| CN112288303A (en) | Method and device for determining line loss rate | |
| CN113205431A (en) | Multi-source account data abnormity monitoring system and method for distribution network line | |
| CN115685046A (en) | Mutual inductor metering abnormity identification method, device, equipment and storage medium | |
| CN108228550B (en) | Statistical line loss automatic calculation and report generation system applied to power supply system | |
| CN108563708A (en) | Facility information search method, device and computer equipment | |
| CN104299065B (en) | A kind of method that Correctness of model is verified between dispatching automation main preparation system | |
| CN107146166B (en) | Distribution network planning auxiliary system | |
| CN109146316A (en) | Power marketing checking method, device and computer readable storage medium | |
| CN112016174A (en) | Multi-source distribution network grid diagram-based user variable relationship checking method | |
| CN105301421A (en) | Parallel period line loss measurement platform and method | |
| CN114994401B (en) | Line loss abnormity detection method and device | |
| CN111782711A (en) | Water quantity data statistical method | |
| CN104200338A (en) | Line loss statistics and decision analysis system | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method | |
| CN114860790A (en) | Marketing meter reading abnormity analysis system | |
| CN114372449A (en) | Automatic generation tool, method, equipment and medium for telecontrol information table of transformer substation | |
| Alquthami et al. | Importance of smart meters data processing–case of saudi arabia | |
| CN113592531A (en) | Method and system for calculating number of idle users in transformer area | |
| CN112445796A (en) | New energy station report generation method | |
| CN111143296A (en) | Substation SCD file classification method and device, terminal and storage medium | |
| CN104317879A (en) | Method for displaying telemetering data in real time on basis of real-time database |
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 |