CN109522339A - Electric power data statistical report form intelligent generating system - Google Patents
Electric power data statistical report form intelligent generating system Download PDFInfo
- Publication number
- CN109522339A CN109522339A CN201811375744.6A CN201811375744A CN109522339A CN 109522339 A CN109522339 A CN 109522339A CN 201811375744 A CN201811375744 A CN 201811375744A CN 109522339 A CN109522339 A CN 109522339A
- Authority
- CN
- China
- Prior art keywords
- data
- electric power
- report
- statistical report
- generating system
- 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
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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention discloses electric power data statistical report form intelligent generating systems, it further include that data statistic analysis unit, statement form data automatically generate unit, in which: the statement form data automatically generate unit including database, gauge outfit is added for generating report table, and for the report table；The data statistic analysis unit extracts corresponding electric power system data from database and inserts report table according to the gauge outfit of the report table.
Description
Technical field
The present invention relates to electric power data statistical report forms, and in particular to electric power data statistical report form intelligent generating system.
Background technique
Electric system has Various types of data statistics every year, monthly, weekly, daily, and main with good grounds voltage class carries out base
Plinth data statistics, operation data statistics, quota data statistics, operational data statistics.Basic data is divided primary equipment and secondary is set
It is standby, primary equipment separated time road, main transformer, switch, disconnecting link etc. again, secondary device differential, distance, zero sequence, overcurrent, over-voltage, low again
Pressure, low week etc.；Operation data counts component voltage, active and reactive etc.；Quota data statistical circuit overload statistics, main transformer overload
Statistics, section transfinite statistics, voltage transfinite statistics etc.；Operational data statistical main transformer capacity-load ratio counts, reactive compensation degree counts,
Main transformer power factor (PF) statistics etc..Above-mentioned all kinds of statistical report forms need to spend a large amount of manpowers and time, the hand in existing electric system
It is dynamic to search, analysis, calculate, it is last to make various report by oneself according to the data being collected into, be manually filling, it is time-consuming and laborious.In order to allow electricity
Power employee can have more energy for power network development construction, safe operation management, economical operation management, promote business administration water
It is flat, staff labor intensity is reduced, working efficiency is improved.Therefore exploitation electric power data statistical report form intelligent generating system is thing must
Row can not only quickly provide all data report for electric system, be convenient for safe and economical operation, while also improving electrician
Work working efficiency reduces labor intensity, and taking full advantage of electric power system is data resource.
Summary of the invention
When the present invention is in order to solve electric power system data statistical report form, statement form disunity fills in complexity manually, is time-consuming
Laborious problem provides electric power data statistical report form intelligent generating system, improves electrical employee working efficiency, reduces electrician
Work labor intensity, and taking full advantage of electric power system is data resource, researchs and analyses for power grid and quickly provides all kinds of analytical statement numbers
According to.
The present invention is achieved through the following technical solutions:
Electric power data statistical report form intelligent generating system, including database further include data statistic analysis unit, report lattice
Formula data automatically generate unit, in which: the statement form data automatically generate unit, for generating report table, and to be somebody's turn to do
Report table adds gauge outfit；The data statistic analysis unit extracts phase according to the gauge outfit of the report table from database
The electric power system data answered simultaneously inserts report table.
Design principle of the invention are as follows: the statement form of setting user needs first, and can be according to the needs of users
Format, the gauge outfit of table are changed, subregion, classification, classification progress Various types of data then can be used using electric power system data feature
It counts, analyze, comparing and select required data, will finally select data filling selected format report, and just obtain electric power data system
Count report；Wherein the data in report table are that have program Auto-writing according to the format of gauge outfit and table itself.
Further, the extracting mode of the data statistic analysis unit are as follows: according to electric power system data in database
Voltage class, basic data, operation data, quota data, operational data are completed to extract after being searched, compared, being analyzed.It is filling out
Write-in report table before lookup, compare, analyze the accuracy that can effectively improve data, filled out or failed to fill in mistake proofing.
It further, further include gauge outfit library, the gauge outfit library is used to automatically generate unit for the statement form data and mention
For the gauge outfit of report table；The report of multiple fixed formats can be provided by gauge outfit library, can also be arranged by user oneself.
Further, the database include automated data in electric system support system OP3000, IES500,
The database of D5000.
It further, further include the end PC, the statement form data automatically generate unit electric power data statistics generated
Report can export Excel table at the end PC.
It further, further include printer, the printer receives the statement form data and automatically generates unit and given birth to
At electric power data statistical report form, and print.
Further, the statement form data automatically generate unit generation report table format at least there are two types of.
Compared with prior art, the present invention having the following advantages and benefits:
1, electric power data statistical report form intelligent generating system of the present invention realizes electric power data express statistic, analysis, and automatic
Report needed for generating provides data and supports to power grid security, stabilization, economical operation；
2, manual data of searching have been become automatic lookup, analysis, and energy by electric power data statistical report form intelligent generating system
Automatic report generation reduces the labor intensity of employee, improves work efficiency, and the existing system data of electric system is utilized
Resource also saves human resources；
3, electric power data statistical report form intelligent generating system can generate the statement form that user wants according to user demand, need
Available data report is the given one or more fixed format reports of program, consolidated table format in electric system.
Detailed description of the invention
Attached drawing described herein is used to provide to further understand the embodiment of the present invention, constitutes one of the application
Point, do not constitute the restriction to the embodiment of the present invention.In the accompanying drawings:
Fig. 1 is principle schematic diagram of the present invention；
Fig. 2 is electric power data statistical report form intelligent generating system operational flow diagram of the present invention；
Fig. 3 is each department route, main transformer parametric statistics expression intention；
Fig. 4 is 17 years, 18 years rate of qualified voltage statistical representations are intended to；
Fig. 5 is typical form schematic diagram；
Fig. 6 is customized table schematic diagram.
Specific embodiment
To make the objectives, technical solutions, and advantages of the present invention clearer, below with reference to embodiment and attached drawing, to this
Invention is described in further detail, and exemplary embodiment of the invention and its explanation for explaining only the invention, are not made
For limitation of the invention.
Embodiment
As shown in Figure 1, design principle of the invention are as follows: the statement form of setting user needs first, and can basis
The format for needing to change table of user, gauge outfit, then using electric power system data feature can be used subregion, classification, classify into
Row Various types of data is counted, is analyzed, comparing and select required data, will finally be selected data filling selected format report, and just be obtained
Electric power data statistical report form；Wherein the data in report table are that have program to fill out automatically according to the format of gauge outfit and table itself
It writes.
The extracting mode of the data statistic analysis unit are as follows: according to the voltage class of electric power system data in database,
Basic data, operation data, quota data, operational data are completed to extract after being searched, compared, being analyzed.It is filling in into report
Lookup before table compares, analyzes the accuracy that can effectively improve data, is filled out or is failed to fill in mistake proofing.
It further include gauge outfit library, the gauge outfit library provides report table for automatically generating unit for the statement form data
Gauge outfit；The report of multiple fixed formats can be provided by gauge outfit library, can also be arranged by user oneself.
The database includes the data of automated data support system OP3000, IES500, D5000 in electric system
Library.
It further include the end PC, the statement form data automatically generate unit electric power data statistical report form generated can be
The end PC exports Excel table.
It further include printer, the printer receives the statement form data and automatically generates unit electric power generated
Data statistics report, and print.
The statement form data automatically generate unit generation report table format at least there are two types of.
In the present embodiment it is preferably the flow chart as shown in Fig. 2,5,6: enters selection, optional typical case's table by start button
(wherein the gauge outfit of typical form can arbitrarily increase and decrease horizontally-arranged statistical item, the gauge outfit of customized table for lattice or customized table
Horizontal, vertical gauge outfit can arbitrarily be set), select typical form then to enter typical form selection, and statistical tables and reports modification can be carried out；Selected from definition
Table then enters customized top-of-form set.Number needed for being searched according to table parameter subregion, classification to Database Management System in Electrical Power System
According to, and directly filling table is extracted, or by inserting table after screening, compare, calculating.It is finally needed according to user optional
Export table is selected to EXCEL or printout.
Typical top-of-form set has pre-seted several typical gauge outfit templates, recalls that be increased and decreased relevant item i.e. producible
Required table, and corresponding parameter item in table is automatically generated, each parameter item need to be searched or be searched into electric power data library
It screened after, compared, result is calculated.
Making view top-of-form set by oneself, user can define header entry according to the requirement of oneself, subregion that system can be first involved in,
Classification and the pre- typing of header entry can select directly in gauge outfit library when customized, also can customize header entry.
Such as wherein gauge outfit library may be configured as:
Subregion project: Sichuan, Guizhou, Yunnan etc.；
Classification item: route, main transformer, switch, disconnecting link, capacitor etc.；
Classification project: 500kV, 220kV, 110kV etc.；
Other projects: serial number, equipment percent of pass, rate of qualified voltage, circuit overload rate, main transformer load factor, is held device name
Carry ratio, main transformer power factor (PF), Substation Reactive-power Compensation degree, System Reactive Power compensativity etc..
As shown in figure 3, being system-based data statistics report: such report generally finds phase by subregion, classification
Close data are directly inserted one by one after data table or line length or main transformer capacity in simple computation class list or
Statistics shares how many routes or how many main transformers etc..
As shown in figure 4, being system operation data, quota data, operational data statistical report form: such report is generally pressed point
Data can't directly be inserted table after finding related data by area, classification, need to be to the data found into sieve
It selects, compare, calculate, through analysis result filling report lattice.
Above-described specific embodiment has carried out further the purpose of the present invention, technical scheme and beneficial effects
It is described in detail, it should be understood that being not intended to limit the present invention the foregoing is merely a specific embodiment of the invention
Protection scope, all within the spirits and principles of the present invention, any modification, equivalent substitution, improvement and etc. done should all include
Within protection scope of the present invention.
Claims (7)
1. electric power data statistical report form intelligent generating system, including database, which is characterized in that further include data statistic analysis list
Member, statement form data automatically generate unit, in which:
The statement form data automatically generate unit, add gauge outfit for generating report table, and for the report table；
The data statistic analysis unit extracts corresponding electric system according to the gauge outfit of the report table from database
Data simultaneously insert report table.
2. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that further include gauge outfit
Library, the gauge outfit library provide the gauge outfit of report table for automatically generating unit for the statement form data.
3. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that the database packet
Include the database that the automated data in electric system supports system OP3000, IES500, D5000.
4. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that it further include the end PC,
The statement form data, which automatically generate unit electric power data statistical report form generated, to export Excel table at the end PC.
5. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that further include printing
Machine, the printer receive the statement form data and automatically generate unit electric power data statistical report form generated, and print
Out.
6. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that the data statistics
The extracting mode of analytical unit are as follows: according to voltage class, basic data, operation data, the limit of electric power system data in database
Specified number evidence, operational data are completed to extract after being searched, compared, being analyzed.
7. electric power data statistical report form intelligent generating system according to claim 1, which is characterized in that the statement form
Data automatically generate unit generation report table format at least there are two types of.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811375744.6A CN109522339A (en) | 2018-11-19 | 2018-11-19 | Electric power data statistical report form intelligent generating system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811375744.6A CN109522339A (en) | 2018-11-19 | 2018-11-19 | Electric power data statistical report form intelligent generating system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109522339A true CN109522339A (en) | 2019-03-26 |
Family
ID=65778357
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811375744.6A Pending CN109522339A (en) | 2018-11-19 | 2018-11-19 | Electric power data statistical report form intelligent generating system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109522339A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112329408A (en) * | 2020-11-05 | 2021-02-05 | 国网山东省电力公司泰安供电公司 | Intelligent report reporting system of power grid regulation and control office system |
| CN112580317A (en) * | 2020-12-29 | 2021-03-30 | 江苏金财信息技术有限公司 | Method for rapidly generating dynamic cross two-dimensional table with hierarchical summary |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104408583A (en) * | 2014-12-22 | 2015-03-11 | 国家电网公司 | Intelligent decision and analysis system for electric energy |
-
2018
- 2018-11-19 CN CN201811375744.6A patent/CN109522339A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN104408583A (en) * | 2014-12-22 | 2015-03-11 | 国家电网公司 | Intelligent decision and analysis system for electric energy |
Non-Patent Citations (1)
| Title |
|---|
| 石光亮等: "电力生产信息统计报表生成器的设计与实现", 《电力系统自动化》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112329408A (en) * | 2020-11-05 | 2021-02-05 | 国网山东省电力公司泰安供电公司 | Intelligent report reporting system of power grid regulation and control office system |
| CN112580317A (en) * | 2020-12-29 | 2021-03-30 | 江苏金财信息技术有限公司 | Method for rapidly generating dynamic cross two-dimensional table with hierarchical summary |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| EP2697888B1 (en) | Method for determining the topology of a low-voltage distribution grid | |
| CN108764683B (en) | Power grid operation data analysis evaluation and report system | |
| CN110795921A (en) | Automatic generation and verification method for monitoring information of intelligent substation equipment | |
| CN110321919A (en) | It is a kind of for the single-phase clustering method with the identification of phase relation in every family of low pressure | |
| CN113283096B (en) | Method for acquiring distribution network line account data and analyzing abnormal data and related device | |
| CN109522339A (en) | Electric power data statistical report form intelligent generating system | |
| CN103792448A (en) | Digitized protective device automatic test control system and control method thereof | |
| CN105914755B (en) | Electrical power system dynamic reactive power Optimal Configuration Method and system | |
| CN106815373A (en) | Big data methods of exhibiting and system are rushed to repair in distribution based on BI analyses | |
| CN105528671B (en) | A kind of power grid Multidimensional Awareness based on big data and safety estimation system and method | |
| CN109166051A (en) | A kind of dispatching of power netwoks data programming count and multidimensional visualize application method | |
| CN107944659B (en) | Method and device for automatically generating plant station monitoring system report | |
| CN105938506A (en) | Graph visualization system for power grid power flow analysis | |
| CN116340437A (en) | Multi-clustering method for large-scale multi-source heterogeneous data | |
| CN109408960A (en) | The method and system of intelligent substation main wiring diagram is automatically generated based on SCD | |
| CN109871566B (en) | Loop construction method based on power grid topology technology and storage medium | |
| CN110705885A (en) | Intelligent statistical analysis method for photovoltaic permeability of power grid equipment | |
| CN105914732A (en) | High-voltage power grid theoretical line loss evaluation system | |
| CN104598713A (en) | Power grid theoretical line loss computation demand data synthesizing method | |
| CN112016174A (en) | Multi-source distribution network grid diagram-based user variable relationship checking method | |
| CN101615266A (en) | The analytic system and the analytical approach that are used for electric system industry demand factor | |
| CN115619291A (en) | Super capacitor hybrid energy storage management system based on data analysis | |
| CN110601240A (en) | Intelligent management and control method for power grid charging pile access | |
| CN114614509A (en) | Analysis method for influence of photovoltaic access on electric energy quality and related device |
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 |
Application publication date: 20190326 |
|
| RJ01 | Rejection of invention patent application after publication |