Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

BPA power grid data analyzing and managing method and system based on EXCEL

A data analysis and management method technology, applied in the field of EXCEL-based BPA power grid data analysis and management, can solve problems such as heavy workload, difficult data management system, hidden dangers of power grid management, etc., to achieve improved efficiency, efficient and flexible analysis and processing Effect

Active Publication Date: 2014-09-24
STATE GRID CORP OF CHINA +3
View PDF3 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The workload is heavy, and some data misalignment errors are prone to occur, and it is difficult to find them in time, which often brings hidden dangers to the management of the power grid. The second situation needs to rely on the completeness of the development of data management tools. Due to the development of power technology and the power grid The development of new power equipment and the continuous improvement of power grid analysis requirements make it difficult for the solidified data management system to be updated in time to meet the new requirements, which brings great inconvenience to the work of moderators

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
  • BPA power grid data analyzing and managing method and system based on EXCEL
  • BPA power grid data analyzing and managing method and system based on EXCEL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0022] The present invention is based on EXCEL's BPA grid data analysis and management method, such as figure 1 shown, including the following steps:

[0023] S1. Quickly parse and format BPA grid data based on the EXCEL string bit operation function.

[0024] Since the BPA data format of the power grid uses the number position of the data column as the division of the field position of the data card (a field is defined from how many columns in the data card to how many columns), and at the same time uses the floating-point number data format of fortran as the data format ( For the format of F*.* as a floating-point number specified in a string of a given length, the first * indicates the data length, and the second * indicates the precision. If there is no decimal point in the filled data, it is forced to consider that it needs to b...

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 relates to a BPA power grid data analyzing and managing method and system based on EXCEL. The method comprises the following steps that (1) formatted BPA power grid data are rapidly analyzed based on an EXCEL character string operating function; (S2) an automatic function generating method based on auxiliary rank information is adopted for achieving the automatic filling of data cards and automatic calculating; (S3) BPA power grid data classified management is conducted based on a fast searching method; (S4) based on a formatted output BPA data card generating technology, analyzed data are automatically converted into a BPA data format, and the formatted BPA data are output. The system comprises a data input unit, a data analyzing unit and a formatting and outputting unit, wherein the data input unit is used for importing and classifying the BPA power grid data, the data analyzing unit is used for analyzing corresponding data cards in a classified mode, and the formatting and outputting unit is used for conducting formatted output on the adjusted power grid data. The method and system are beneficial to improving data management efficiency in the power grid analyzing process.

Description

technical field [0001] The invention relates to the technical field of power grid data management, in particular to an EXCEL-based BPA power grid data analysis and management method and system. Background technique [0002] Large power grid data management is an indispensable link in the calculation and analysis of power grid methods, and is the basic work to ensure the safe and stable operation of the power system. In the existing technology, dispatchers either use text editing tools to confirm and modify data line by line and position by position; or rely on certain solidified data management programs to manage grid data. The workload is heavy, and some data misalignment errors are prone to occur, and it is difficult to find them in time, which often brings hidden dangers to the management of the power grid. The second situation needs to rely on the completeness of the development of data management tools. Due to the development of power technology and the power grid The ...

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): G06F17/30G06Q10/06G06Q50/06
CPCG06F16/258G06Q50/06Y02D10/00
Inventor 李传栋项胤兴
Owner STATE GRID CORP OF CHINA
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com