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 o

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

Example Embodiment

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

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

[0023] S1. Quickly parse and format BPA grid data based on EXCEL string bit manipulation functions.

[0024] Because the BPA data format of the power grid is based on the number position of the data column as the division of the data card field position (from how many columns to how many columns in the data card to define a field), at the same time, fortran's floating-point number data format is used as the data format ( For a given length of string, F*.* is specified as the format of floating-point numbers, the first * indicates the data length, and the second * indicates the precision. If there is no decimal point in the data, it will be forced to be filled in. Divide the data by 10 to the power of pr...

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 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