CN104182915A - Power distribution visualization system based on EXCEL - Google Patents
Power distribution visualization system based on EXCEL Download PDFInfo
- Publication number
- CN104182915A CN104182915A CN201410450827.2A CN201410450827A CN104182915A CN 104182915 A CN104182915 A CN 104182915A CN 201410450827 A CN201410450827 A CN 201410450827A CN 104182915 A CN104182915 A CN 104182915A
- Authority
- CN
- China
- Prior art keywords
- node
- distribution network
- excel
- tree structure
- visualization 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
-
- 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Abstract
The invention provides a power distribution visualization system based on the EXCEL. Firstly, the relationship among all nodes of a power distribution network diagram is observed, and then information of the nodes is stored in an EXCEL file corresponding to the power distribution network diagram according to the relationship among father nodes and child nodes; then the EXCEL file is connected with software, a tree structure of all the nodes of the power distribution network diagram can be displayed by pressing a feature button, fault node names and a fault module are input, the fault module can display the tree structure diagram of the power failure area and information of all nodes of the power failure area and can store the information in a specified EXCEL file, and when the fault history of a certain node needs to be looked up, only the node name needs to be input, and the past fault situation of the node can be displayed; by means of the visualization system, the fault maintenance personnel can be informed to conduct fault removal and power recover effectively and timely, the outage time is shortened, and economical benefits are greatly improved while requirements of users are met.
Description
Technical field
The invention belongs to power distribution network management domain, specifically a kind of distribution visualization system based on EXCEL.
Background technology
Along with socioeconomic development, growth in the living standard, people require more and more higher to power supply quality, and meanwhile, the scale of power distribution network and complexity are also in cumulative year after year.These have all proposed larger challenge to solve the requirement of the aspect such as ageing for electrical stability, fault.When the distribution network under conventional situation breaks down, first operations staff can go the telephone number of searching this fault present position maintainer to go to contact this maintainer according to the place of fault again, thereby this need to spend the regular hour, power off time is increased, want to notify user's power-off condition also will at distribution figure, get on to observe power supply interrupted district according to the electric knowledge of oneself simultaneously; Secondly, when need to patrol and examine the region that some often break down, need to remove the failure logging before consulting, compare like this trouble.Processing mode based on above-mentioned, time that need to be longer could be notified trouble hunting personnel, thereby makes power off time longer; The power supply interrupted district situation occurring when breaking down is not so very clear, thereby can not notify timely user power-off condition; When patrolling and examining the region of often breaking down, need to consult failure logging in the past, lose time and manpower.Therefore, need badly distribution system fault solution is improved.
Summary of the invention
The object of this invention is to provide a kind of distribution visualization system based on EXCEL, make operations staff need not consult handbook and just can directly demonstrate trouble spot maintainer's information, and can demonstrate fast power supply interrupted district.The personnel that can also inquire about the failure logging of distribution node and be responsible for originally maintenance.
The present invention is using the status information of distribution node major equipment in distribution network figure as the key message of preparing typing EXCEL, the tree structure figure of foundation based on these nodes, by calling the distribution network figure answering in contrast, the tree structure set membership that can comparatively clearly check distribution network figure.When the line failure in distribution system between a certain equipment and equipment causes power outage, in system, after the device name of input fault point, tree structure figure can show upstream device and the user that equipment has a power failure and affects thus, and marks by redness.
The concrete technical scheme that the present invention adopts is that the distribution visualization system based on EXCEL, comprising:
The memory module of each nodal information of distribution network figure, according to the tree structure in distribution network, deposits the information of each node in the EXCEL document corresponding with this distribution network in.
The display module of distribution network tree structure, by EXCEL document and the foundation of described visualization system are contacted, the form by canned data in EXCEL document with tree structure shows in described visualization system.
Malfunctioning module, for showing the tree structure figure of power supply interrupted district, the information of each node of power supply interrupted district, and deposits failure message in specific EXCEL document.
Failure logging enquiry module, the failure condition occurring in the past for inquiring about specific node.
Because this system will show twice tree structure (open the tree structure of distribution network, and the tree structure of power supply interrupted district), therefore the demonstration of tree structure adopts the mode of call function to determine the father node of child node.
More specifically, in described EXCEL document, go back history maintenance situation and the on-line operation state that autostore has the major equipment of each node in power distribution network.
Adopt visualization system of the present invention can bring following useful technique effect, 1. shorten power off time, thereby reduced economic loss; 2. reduced operations staff's workload, increased work efficiency; 3. can make user understand rapidly power failure reason and probably restore electricity the time.
Accompanying drawing explanation
Fig. 1 is the process flow diagram that the present invention creates tree structure figure;
Fig. 2 is operational flowchart of the present invention;
Fig. 3 is the process flow diagram that the present invention creates the tree function that calls in tree structure flow chart processes.
Embodiment
The distribution network figure of Yi Mou company is that example is analyzed.First, according to the distribution node determination father node in distribution network figure and the relation of child node, the key message of the electric tree structure figure the inside based on XPS form is excavated out.Secondly in the relevant EXCEL document of these key message typings; Finally set up the distribution visualization system based on EXCEL document, it can show failure message and status information of equipment.The concrete implementation detail of each several part below.
1) storage mode of each nodal information of distribution network figure.Obtain the tree structure figure of a distribution network, first need by the information excavating of each node in distribution network figure out, by these information be placed on this distribution network figure EXCEL document of the same name in, wherein first classify sequence number as, second classifies the title of each node as, the 3rd classifies father node sequence number (being about to the node ID that electric energy imports this node into) as, the 4th classifies this node as while breaking down responsible official and contact method thereof.For example: in certain distribution network figure, Ping Yuan is the electric energy input point of this distribution network, so its sequence number is set to 1, and because it does not have father node, so his father's node ID is 0.After electric energy enters this distribution network by garden, level ground node, send respectively electric energy to garden allusion quotation, garden friendship, garden generation, Yuan Jia, these five places, sky, garden, so their father node sequence number is all 1, its sequence number is 2,3,4,5,6 in order successively.Garden is handed over and is continued again electric energy to pass to JiaoTong Building power distribution room, so the father node sequence number of JiaoTong Building power distribution room is exactly the sequence number that hand in garden, its sequence number should be 7 in order.Like this like go down just to obtain the information of whole distribution network, its information is as shown in the table:
| sequence number | title | father node sequence number | responsible official and contact method |
| 1 | ping Yuan | 0 | responsible official: Xiao Ming's contact method: 123 |
| 2 | garden allusion quotation | 1 | responsible official: little strong contact method: 123 |
| 3 | hand in garden | 1 | responsible official: little Yang contact method: 123 |
| 4 | garden generation | 1 | responsible official: Xiao Li's contact method: 123 |
| 5 | yuan Jia | 1 | responsible official: little red contact method: 123 |
| 6 | yuan Tian | 1 | responsible official: Xiao Zhang's contact method: 123 |
| 7 | jiaoTong Building power distribution room | 3 | responsible official: Xiao Wang's contact method: 123 |
| 8 | good north is public | 5 | responsible official: little beautiful contact method: 123 |
| 9 | jia Bei is special | 5 | responsible official: Zhang San's contact method: 123 |
| 10 | jia Nan | 5 | responsible official: Li Si's contact method: 123 |
| 11 | the public power distribution room in Beiyuan | 8 | responsible official: king's five contact methods: 123 |
| .。。 | 。。。 | 。。。 | 。。。 |
| 50 | city six institutes | 49 | responsible official: Zhao's six contact methods: 123 |
2) demonstration of distribution network tree structure.After being deposited in to EXCEL document, nodal information also needs the information in EXCEL document to take out, its form with tree structure in system of the present invention is shown, this just need to couple together EXCEL document and native system, in the present invention, adopt the API structure that Microsoft provides that EXCEL document is connected with native system, finally, by the TreeView functional module in Microsoft Visual Studio 2010 softwares, the form by the information of EXCEL document with tree structure shows.Wherein set up the flow process of tree structure figure referring to Fig. 1 and Fig. 3.
3) demonstration of power supply interrupted district and malfunctioning node information generates.First input known fault nodename and fault-time and estimate repair time, click confirming button and will demonstrate with red font tree structure and the specifying information of each node of power supply interrupted district, what show power supply interrupted district tree structure does not need to do too much programming, only need to call tree function.He calls tree function when showing distribution network tree structure and also distinguishes to some extent, and whether it is whether 0 to become nodename identical with trouble spot title by the Rule of judgment in function from father node.When showing tree structure and power supply interrupted district, system can deposit the information of malfunctioning node in the EXCEL document of " fault " by name automatically.
4) inquiry of failure logging, only needs input to want the name of query node to find a great convenience and can from " fault " EXCEL, retrieve the failure condition that this node occurred.
The operating process of native system as shown in Figure 2.
This system is simplified to one group of corresponding tree structure figure numerous and diverse distribution network, history maintenance situation and the on-line operation state of the major equipment of distribution node in power distribution network are carried out to the backup of EXCEL document simultaneously, when distribution system breaks down, by this visualization system, can notify effectively, in time breakdown maintenance personnel to fix a breakdown, restore electricity, shorten power off time, when reaching user's requirement, improved widely economic benefit.
Claims (3)
1. the distribution visualization system based on EXCEL, is characterized in that, comprising:
The memory module of each nodal information of distribution network figure, according to the tree structure in distribution network, deposits the information of each node in the EXCEL document corresponding with this distribution network in;
The display module of distribution network tree structure, by EXCEL document and the foundation of described visualization system are contacted, the form by canned data in EXCEL document with tree structure shows in described visualization system;
Malfunctioning module, for showing the tree structure figure of power supply interrupted district, the information of each node of power supply interrupted district, and deposits failure message in specific EXCEL document;
Failure logging enquiry module, the failure condition occurring in the past for inquiring about specific node.
2. the distribution visualization system based on EXCEL according to claim 1, is characterized in that: the demonstration of described tree structure adopts the mode of call function to determine the father node of child node.
3. the distribution visualization system based on EXCEL according to claim 1, is characterized in that: in described EXCEL document, go back history maintenance situation and on-line operation state that autostore has the major equipment of each node in power distribution network.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410450827.2A CN104182915A (en) | 2014-09-05 | 2014-09-05 | Power distribution visualization system based on EXCEL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410450827.2A CN104182915A (en) | 2014-09-05 | 2014-09-05 | Power distribution visualization system based on EXCEL |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104182915A true CN104182915A (en) | 2014-12-03 |
Family
ID=51963935
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410450827.2A Pending CN104182915A (en) | 2014-09-05 | 2014-09-05 | Power distribution visualization system based on EXCEL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104182915A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105490265A (en) * | 2015-12-24 | 2016-04-13 | 海南电网有限责任公司三亚供电局 | Rapid detection method for power-off range overlapping of power distribution network |
| CN106604313A (en) * | 2016-12-07 | 2017-04-26 | 北京市天元网络技术股份有限公司 | Network fault display method and apparatus |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103679554A (en) * | 2013-12-10 | 2014-03-26 | 国家电网公司 | Power grid accident opening auxiliary analysis method |
-
2014
- 2014-09-05 CN CN201410450827.2A patent/CN104182915A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103679554A (en) * | 2013-12-10 | 2014-03-26 | 国家电网公司 | Power grid accident opening auxiliary analysis method |
Non-Patent Citations (2)
| Title |
|---|
| 严亚勤 等: ""一种基于组件接口规范的电网图示化浏览器的设计与实现"", 《电力系统保护与控制》 * |
| 王琦 等: "《水利学与水利信息学进展》", 31 October 2009 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105490265A (en) * | 2015-12-24 | 2016-04-13 | 海南电网有限责任公司三亚供电局 | Rapid detection method for power-off range overlapping of power distribution network |
| CN105490265B (en) * | 2015-12-24 | 2017-11-24 | 海南电网有限责任公司三亚供电局 | A kind of overlapping quick determination method of power distribution network power failure range |
| CN106604313A (en) * | 2016-12-07 | 2017-04-26 | 北京市天元网络技术股份有限公司 | Network fault display method and apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108536770B (en) | Distribution network ring net automatic generation method based on distribution GIS model | |
| CN107832854A (en) | A kind of method and system of distribution network failure repairing progress msg management | |
| WO2018082364A1 (en) | Method and device for analyzing power-off range of power distribution network, and computer storage medium | |
| CN103840975B (en) | The management method and device of a kind of fibre system | |
| CN104766173A (en) | Digital water supply management system and method | |
| CN104102790B (en) | Power supply figure automatic mapping system and method based on GIS | |
| CN103761625A (en) | Outage management system based on information exchange bus and data processing method thereof | |
| CN103473639A (en) | Method and system for intelligent supervision of coal mine safety production | |
| CN112114230A (en) | Distribution network monitoring system for low-voltage distribution area and distribution area topology identification method | |
| CN108199907A (en) | A kind of modeling and analysis methods based on geography target | |
| CN109933634B (en) | Power system graph drawing method based on power radiation range | |
| CN103546541A (en) | Intelligent telecontrol communication machine based remote data subscribing and releasing method | |
| CN111638422A (en) | Rapid positioning method based on electric power big data power distribution network fault | |
| CN104599068A (en) | Method for positioning user fault through comprehensive analysis of repair request information | |
| CN104463488A (en) | Power failure message notifying method and device | |
| CN109262653A (en) | Failed machines people automatic recovery method and device | |
| CN104182915A (en) | Power distribution visualization system based on EXCEL | |
| CN103366245A (en) | OSB (operation sevice bus)-based power grid fault information distribution method and system | |
| CN109711572A (en) | A kind of mobile O&M task processing system of photovoltaic plant | |
| CN111476547A (en) | Method for analyzing assets of distribution network line ring-out point arrangement in user | |
| CN105527920A (en) | B/S-based numerical control machine tool fault diagnosis system | |
| CN103065267B (en) | Based on user collection marketing, production data share and integrated services method | |
| CN112286884B (en) | Method, system and medium for automatically generating topology of ring main unit of power distribution network | |
| CN104243218A (en) | Power system communication mode bill compilation method based on multi-scheduling constraints | |
| CN105607594A (en) | Method for searching equipment by server memory based on smart home appliance |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20141203 |
|
| RJ01 | Rejection of invention patent application after publication |