Automatic report generating method capable of meeting power distribution network management specific data standards

A specific data and report generation technology, applied in data processing applications, instruments, program control devices, etc., can solve problems such as error-prone, reduce workload, consume a lot of time and human resources, etc., achieve strong guiding significance and reduce workload , strong practicality and versatility

Inactive Publication Date: 2014-04-09
GUANGXI POWER GRID ELECTRIC POWER RES INST +1
View PDF4 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This process is very labor-intensive and error-prone. Some users need to recreate Word reports based on weekly or monthly updated data. The workload is self-evident.
It can be seen that the traditional operation of making reports often takes a lot of time

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Automatic report generating method capable of meeting power distribution network management specific data standards

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0023] Combine the following figure 1 , Detailed description of the implementation steps of the present invention:

[0024] The automatic report generation method is based on C#, Excel, Word under Windows system, and Microsoft Office software must be installed on the computer.

[0025] (1) Create a Word report template that contains specific content (power supply, failure time, failure times, equipment operation, etc.) that can reflect the production and operation status of the distribution network within a certain period of time, and insert specific data when needed Insert bookmarks with different names in place of, value or chart:

[0026] Open the above Word report template, position the cursor where you want to insert the data or chart, click "Insert"-"Bookmark", and give different names to the bookmarks in different locations.

[0027] (2) Summarize Excel table data

[0028] ① First, store multiple Excel tables containing the amount of information needed for summary information i...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The invention discloses an automatic report generating method capable of meeting power distribution network management specific data standards. The automatic report generating method comprises the steps that firstly, a specific Word report template required by an electric power company is made and bookmarks with different names are inserted into the places where data or figures need to be inserted; then, Excel data needing to be summarized are read and summarized to form an Excel table; the summarized Excel table is read, needed data are selected and stored into an array, the data in the array are taken form statistical charts (a bar chart and a pie chart) through drawing, different names are given to the drawn statistical charts, and the statistical charts are stored in a certain user-defined file folder of a computer; next, the Word report template which is made in advance is imported, tables are drawn at the positions of the named bookmarks and the corresponding data in the array are written into the tables or generated images are inserted into the tables; at last, a generated Word report is stored automatically. The automatic report generating method capable of meeting the power distribution network management specific data standards meets the daily work requirements of the electric power company, also saves a lot of time and manpower resources, and improves the working efficiency.

Description

technical field [0001] The invention belongs to the analysis field of distribution network daily work processing, and in particular relates to an automatic report generation method conforming to specific data standards for distribution network management. Background technique [0002] In the daily work process of power distribution network operation and management, power companies often need to extract Excel tables containing a lot of information from various software systems, and summarize them into a fixed-mode report on a monthly, quarterly or annual basis. Finally, a report containing specific content (such as statistical tables, column charts, and pie charts) that can reflect the production and operation status of the distribution network during this period is produced and reported. For example, both Excel and Word are commonly used office software. The distribution network management departments of power companies often need to summarize the data in many Excel tables i...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06Q50/06G06F9/44
Inventor 高立克陈碧云俞小勇叶仁欢吴智丁韦杏秋李克文柳辉吴丽芳祝文姬李珊吴剑豪梁朔周杨珺欧世锋
Owner GUANGXI POWER GRID ELECTRIC POWER RES INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap