CN104063519A - BPA power grid data analyzing and managing method and system based on EXCEL - Google Patents
BPA power grid data analyzing and managing method and system based on EXCEL Download PDFInfo
- Publication number
- CN104063519A CN104063519A CN201410337609.8A CN201410337609A CN104063519A CN 104063519 A CN104063519 A CN 104063519A CN 201410337609 A CN201410337609 A CN 201410337609A CN 104063519 A CN104063519 A CN 104063519A
- Authority
- CN
- China
- Prior art keywords
- data
- bpa
- excel
- electric network
- network data
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000007726 management method Methods 0.000 claims abstract description 15
- 238000013523 data management Methods 0.000 claims abstract description 9
- 238000012545 processing Methods 0.000 claims description 9
- 238000007405 data analysis Methods 0.000 claims description 8
- 238000012986 modification Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 238000004458 analytical method Methods 0.000 claims description 3
- 238000005429 filling process Methods 0.000 claims description 3
- 238000005516 engineering process Methods 0.000 abstract description 7
- 230000008569 process Effects 0.000 abstract description 6
- 230000009286 beneficial effect Effects 0.000 abstract 1
- 230000006870 function Effects 0.000 description 23
- 238000011161 development Methods 0.000 description 4
- 238000003012 network analysis Methods 0.000 description 3
- 238000012216 screening Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000010205 computational analysis Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Supply And Distribution Of Alternating Current (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
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
The present invention relates to electric network data administrative skill field, particularly a kind of parsing of BPA electric network data and management method and system based on EXCEL.
Background technology
Large electric network data management is requisite link in the computational analysis of electrical network mode, is the basic work that ensures power system safety and stability operation.In existing technology, dispatcher otherwise be with the text edit tool line by line, put by turn data confirmed and revised; Rely on some curing data administrator to manage electric network data.Wherein workload is large, and be easy to occur the mistake of some data dislocation, and be difficult to timely discovery, manage often to electrical network mode and bring hidden danger, the second situation need to rely on the completeness of data management too development, due to the development of power technology and the development of electrical network, and the electrical network analysis demand that new power equipment puts into operation and improves constantly, the curing data management system adaptation new demand that is difficult to upgrade in time, this has brought very large inconvenience to work of mode personnel.Therefore the technical scheme that, objectively needs the large electric network data of realization that can provide flexible and efficient in to resolve and manage.
Summary of the invention
The object of the present invention is to provide a kind of parsing of BPA electric network data and management method and system based on EXCEL, the method and system are conducive to improve the efficiency of data management in electrical network analysis process.
For achieving the above object, technical scheme of the present invention is: a kind of BPA electric network data based on EXCEL is resolved and management method, comprises the following steps:
S1, based on EXCEL character string bit manipulation function fast resolving format BPA electric network data;
S2, the Automatic Function generation method of employing based on secondary row column information, realize the automatic filling of data card and automatically calculate;
S3, carry out the Classification Management of BPA electric network data based on method for fast searching;
S4, BPA data card generation technique based on Formatting Output, be converted into BPA data layout automatically by the data after resolving, and output format BPA data.
Further, in step S1, adopt the MIDB function of application EXCEL to extract the data of character string given position, and in conjunction with the conditional function such as IF, AND, SUBSTITUTE character replacement function and LEN string length discriminant function judge whether respective field has and fill in radix point and carry out the parsing of data, realize the structuring of BPA data card is resolved.
Further, in step S2, EXCEL supports the relative position pattern of formula, based on this feature, adopt table name definitely to apply and carry out charging formula with the mode of the corresponding use of ranks for the position of data, be combined in the extension position and the accuracy requirement that in secondary row, mark corresponding field simultaneously, realize the Data Analysis of realizing a kind of card with a formula, and utilize the principle of the relative position automatic filling in the automatic filling process of EXCEL, the parsing that has realized a kind of data card only needs line code, the function of remaining element lattice is automatically produced and calculates by automatic filling and secondary row column information.
Further, in step S3, data card classification based on supplementary column realizes the large electric network data automatic classification based on EXCEL and gathers, first according to data card type analysis result, all data cards are numbered to processing, generate a group index according to each data card type, finally apply INDIRECT, ADDRESS, tri-functions of VLOOKUP retrieve corresponding grouped data card and extract from overall file according to order; Adopt quick binary search method, realize fast large-scale data automatic classification and gather.
Further, in step S4, the Formatting Output method of data after the parsing specifying according to data layout, has realized the rear data of parsing and has automatically been converted into data card and gathers output, the BPA file that generation can directly be calculated.
The present invention also provides a kind of BPA electric network data based on EXCEL to resolve administrating system, at least comprises:
Data input cell, for importing and the classification of BPA electric network data;
Data Analysis unit, resolves corresponding data card for classifying;
Formatting Output unit, for carrying out Formatting Output to the electric network data after adjusting.
Further, said system also comprises: Data Management Unit, and for electric network data is carried out to retrieval and inquisition and batch modification.
A kind of parsing of BPA electric network data and management method and system based on EXCEL that provide is provided, the method and system realize the fast resolving processing of large scale electric network data based on EXCEL function, rapid adjustment is resolved content and batch data adjustment according to demand, and derivation can be directly used in the BPA formatted data of calculating, realize the high efficient and flexible of BPA electric network data and resolved and process, effectively raised the efficiency of data management in electrical network analysis process.
Brief description of the drawings
Fig. 1 is the realization flow figure of the inventive method.
Fig. 2 is the structure principle chart of system of the present invention.
Embodiment
Below in conjunction with drawings and the specific embodiments, the present invention is described in further detail.
The BPA electric network data that the present invention is based on EXCEL is resolved and management method, as shown in Figure 1, comprises the following steps:
S1, based on EXCEL character string bit manipulation function fast resolving format BPA electric network data.
Because the BPA data layout of electrical network is division using the numbered positions of data rows as data card field location (uses number from data card to be listed as how many row and define a field), use the floating number data layout of fortran (in the character string for a given length, to specify the form of F*.* as floating number as data layout simultaneously, first * represents data length, second * represents precision, in data, do not add radix point if filled in, forced to think need to be by the data of being filled in divided by 10 precision power to obtain last data), in addition because Chinese takies 2 eight bit character width, and because different names is accustomed to Chinese length and number of words be can not determine.The parsing that solves data card by the technology of tradition programming has two difficult points, one, because the string processing function of main flow programming language (as C series) is more loaded down with trivial details in processing Chinese character string step-by-step parsing, amendment trouble (need to consider the processing of Chinese word length); Two, due to power system technology progress, the new model of new forms of energy and direct current continues to bring out, and the development data card of BPA software is in continuous upgrading, occurs that new data card just need to again write and compile program, easily makes mistakes, and actual effect is also poor.The MIDB function that for this reason the present invention proposes a kind of EXCEL of application (is realized the extraction of character string given position data, press eight bit character length), and in conjunction with IF, the conditional functions such as AND, SUBSTITUTE character replacement function (being used for replacing radix point) and LEN(string length discriminant function) judge whether respective field has and fill in radix point and carry out the parsing of data, realize the structuring of BPA data card is resolved to (the parameter that related function adopts, can apply the parameter relatively and when absolute reference is related to that automatic filling does not need to consider to programme of EXCEL for data, only need to formulate position length and the precision information of character string, therefore resolve different field or more only need the descriptive information of adjusting respective field just can reuse all codes when change card).
S2, the Automatic Function generation method of employing based on secondary row column information, realize the automatic filling of data card and automatically calculate.
EXCEL supports the relative position pattern of formula, based on this feature, adopt table name definitely to apply and carry out charging formula with the mode of the corresponding use of ranks for the position of data, be combined in the extension position and the accuracy requirement that in secondary row, mark corresponding field simultaneously, realize the Data Analysis of realizing a kind of card with a formula, and utilize the principle of the relative position automatic filling in the automatic filling process of EXCEL, the parsing that has realized a kind of data card only needs line code, the function of remaining element lattice is automatically produced and calculates by automatic filling and secondary row column information, improve greatly the efficiency of programming efficiency and test and debugging.
S3, carry out the Classification Management of BPA electric network data based on method for fast searching.
Because electric network data scale data card line number may reach 100,000 row ranks, dissimilar data card is staggered filling in often, in the time resolving, need to classify to data card.For traditional programming technique, what conventionally adopt is all data card of traversal, and then dynamic statistics and grouped data Card Type carry out Data Analysis.This method deal with data most effective, but need again again related content to be write and compiled when newly-increased data card, can not adapt to the flexible processing of data, the efficiency of program response changes in demand is low.And if the employing automatic screening of EXCEL or the function of sequence are classified, need a large amount of manual operations, execution efficiency is very low, also easily introduces mistake.The present invention proposes a kind of classification of the data card based on supplementary column and realizes the large electric network data automatic classification based on EXCEL and gather, first according to data card type analysis result, all data cards are numbered to processing, generate a group index (for the numbering round numbers that meets corresponding data card according to each data card type, for incongruent intermediate value of getting upper and lower two load data cards numbering, one side of index is the numbering of such data card of correspondence, one side is this card line number at place hereof), finally apply INDIRECT(and utilize address search data), ADDRESS(utilizes table name, OK, row calculated address), VLOOKUP(searches for qualified record range position) three functions retrieve corresponding grouped data card and extract from overall file according to order.Because EXCEL retrieval functions is built-in, cannot carry out embedded amendment, searching of each corresponding record all needs all data to retrieve, for large-scale data, accurate recall precision is very low, therefore the present invention has adopted corresponding quick binary search method, and in data number process, introduce a little data deviation to have avoided the problem of the retrieve position deviation in EXCEL fuzzy search process, finally realize fast large-scale data automatic classification and gathered.The method of this patent has effectively been utilized the principle of changing the time with space, pass through cumulative index, with sequential index technology and two points of quick-searchings, effectively realize the quick-searching of mass data, utilize again the reliability of built-in function and the feature of the improved dirigibility of program simultaneously.
S4, BPA data card generation technique based on Formatting Output, be converted into BPA data layout automatically by the data after resolving, and output format BPA data.
The Formatting Output method of data after the parsing specifying according to data layout, has realized the rear data of parsing and has automatically been converted into data card and gathers output, the BPA file that generation can directly be calculated.
The present invention also provides a kind of BPA electric network data based on EXCEL to resolve administrating system, as shown in Figure 2, comprising:
Data input cell 1, for importing and the classification of BPA electric network data.
Data Analysis unit 2, resolves corresponding data card for classifying.
Formatting Output unit 3, for carrying out Formatting Output to the electric network data after adjusting.Be formatted as BPA data card and concentrate output, the file that generation can directly be calculated by the electric network data after amendment is adjusted; The mode that adopts string formatization output is by revising data after adjustment through practical personnel and be converted into BPA data card form and gather and be output as the BPA file that can directly calculate after resolving.
Data Management Unit 4, for carrying out retrieval and inquisition and batch modification to electric network data.For data card is classified, field is item by item resolved, and realize retrieval and inquisition and the batch modification of electric network data, the bookkeepings such as screening, system is resolved related data card according to the data card type classification of BPA, the analysis program of each data card is by the function that realization is set only writes a cell of supplementary, and other cells are realized by the mode of automatic filling, can realize the parallel high-speed processing of Data Analysis based on EXCEL platform.
Be more than preferred embodiment of the present invention, all changes of doing according to technical solution of the present invention, when the function producing does not exceed the scope of technical solution of the present invention, all belong to protection scope of the present invention.
Claims (7)
1. the BPA electric network data based on EXCEL is resolved and a management method, it is characterized in that, comprises the following steps:
S1, based on EXCEL character string bit manipulation function fast resolving format BPA electric network data;
S2, the Automatic Function generation method of employing based on secondary row column information, realize the automatic filling of data card and automatically calculate;
S3, carry out the Classification Management of BPA electric network data based on method for fast searching;
S4, BPA data card generation technique based on Formatting Output, be converted into BPA data layout automatically by the data after resolving, and output format BPA data.
2. the BPA electric network data based on EXCEL according to claim 1 is resolved and management method, it is characterized in that, in step S1, adopt the MIDB function of application EXCEL to extract the data of character string given position, and in conjunction with the conditional function such as IF, AND, SUBSTITUTE character replacement function and LEN string length discriminant function judge whether respective field has and fill in radix point and carry out the parsing of data, realize the structuring of BPA data card is resolved.
3. the BPA electric network data based on EXCEL according to claim 1 is resolved and management method, it is characterized in that, in step S2, EXCEL supports the relative position pattern of formula, based on this feature, adopt table name definitely to apply and carry out charging formula with the mode of the corresponding use of ranks for the position of data, be combined in the extension position and the accuracy requirement that in secondary row, mark corresponding field simultaneously, realize the Data Analysis of realizing a kind of card with a formula, and utilize the principle of the relative position automatic filling in the automatic filling process of EXCEL, the parsing that has realized a kind of data card only needs line code, the function of remaining element lattice is automatically produced and calculates by automatic filling and secondary row column information.
4. the BPA electric network data based on EXCEL according to claim 1 is resolved and management method, it is characterized in that, in step S3, data card classification based on supplementary column realizes the large electric network data automatic classification based on EXCEL and gathers, first according to data card type analysis result, all data cards are numbered to processing, generate a group index according to each data card type, finally apply INDIRECT, ADDRESS, tri-functions of VLOOKUP retrieve corresponding grouped data card and extract from overall file according to order; Adopt quick binary search method, realize fast large-scale data automatic classification and gather.
5. the BPA electric network data based on EXCEL according to claim 1 is resolved and management method, it is characterized in that, in step S4, the Formatting Output method of data after the parsing specifying according to data layout, after having realized parsing, data are automatically converted into data card and gather output, the BPA file that generation can directly be calculated.
6. the BPA electric network data based on EXCEL is resolved an administrating system, it is characterized in that, at least comprises:
Data input cell, for importing and the classification of BPA electric network data;
Data Analysis unit, resolves corresponding data card for classifying;
Formatting Output unit, for carrying out Formatting Output to the electric network data after adjusting.
7. the BPA electric network data based on EXCEL according to claim 6 is resolved administrating system, it is characterized in that, said system also comprises: Data Management Unit, and for electric network data is carried out to retrieval and inquisition and batch modification.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410337609.8A CN104063519B (en) | 2014-07-16 | 2014-07-16 | BPA power grid data analyzing and managing method and system based on EXCEL |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410337609.8A CN104063519B (en) | 2014-07-16 | 2014-07-16 | BPA power grid data analyzing and managing method and system based on EXCEL |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104063519A true CN104063519A (en) | 2014-09-24 |
| CN104063519B CN104063519B (en) | 2017-04-26 |
Family
ID=51551233
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410337609.8A Active CN104063519B (en) | 2014-07-16 | 2014-07-16 | BPA power grid data analyzing and managing method and system based on EXCEL |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104063519B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933513A (en) * | 2015-05-22 | 2015-09-23 | 广西电网有限责任公司电力科学研究院 | PSD (Power System Department) tide data and stable data editing and correction method based on object orientation |
| CN106777508A (en) * | 2016-11-23 | 2017-05-31 | 广西电网有限责任公司电力科学研究院 | A kind of electric system simulation assistance application system of PSD BPA |
| CN106934538A (en) * | 2017-03-03 | 2017-07-07 | 国网湖北省电力公司 | A kind of electric network data fusion method compared based on data blood relationship and gene |
| CN106970999A (en) * | 2017-04-12 | 2017-07-21 | 中国能源建设集团湖南省电力设计院有限公司 | A kind of BPA Database Modelings and maintaining method |
| CN107328995A (en) * | 2017-07-18 | 2017-11-07 | 国网天津市电力公司 | A kind of high-voltage dc transmission electrical impedance scanning method |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarize data capture method, device and electronic equipment |
| CN109470973A (en) * | 2018-11-30 | 2019-03-15 | 广西电网有限责任公司电力科学研究院 | A kind of failure card library method for building up based on PSD-BPA |
| CN110413970A (en) * | 2019-07-17 | 2019-11-05 | 陕西千山航空电子有限责任公司 | A kind of Embedded training layout data loading method |
| CN112241399A (en) * | 2020-09-30 | 2021-01-19 | 贵州电网有限责任公司电力调度控制中心 | PSD-BPA data analysis and management method and system based on NoSQL |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2006116324A2 (en) * | 2005-04-25 | 2006-11-02 | Carbon Project, Inc. | Methods and apparatus for accessing geospatial information |
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN103500196A (en) * | 2013-09-22 | 2014-01-08 | 成都交大光芒科技股份有限公司 | EXCEL data export method and export device in multi-concurrence large data volume environment |
-
2014
- 2014-07-16 CN CN201410337609.8A patent/CN104063519B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2006116324A2 (en) * | 2005-04-25 | 2006-11-02 | Carbon Project, Inc. | Methods and apparatus for accessing geospatial information |
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN103500196A (en) * | 2013-09-22 | 2014-01-08 | 成都交大光芒科技股份有限公司 | EXCEL data export method and export device in multi-concurrence large data volume environment |
Non-Patent Citations (1)
| Title |
|---|
| 易阳 等，: ""PSD-BPA潮流计算数据卡的自动批量生成和修改"", 《电力系统自动化》 * |
Cited By (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104933513B (en) * | 2015-05-22 | 2019-01-08 | 广西电网有限责任公司电力科学研究院 | A kind of PSD flow data based on object-oriented and stablize data edition and bearing calibration |
| CN104933513A (en) * | 2015-05-22 | 2015-09-23 | 广西电网有限责任公司电力科学研究院 | PSD (Power System Department) tide data and stable data editing and correction method based on object orientation |
| CN106777508A (en) * | 2016-11-23 | 2017-05-31 | 广西电网有限责任公司电力科学研究院 | A kind of electric system simulation assistance application system of PSD BPA |
| CN106934538B (en) * | 2017-03-03 | 2020-06-16 | 国网湖北省电力公司 | Power grid data fusion method based on data blood relationship and gene comparison |
| CN106934538A (en) * | 2017-03-03 | 2017-07-07 | 国网湖北省电力公司 | A kind of electric network data fusion method compared based on data blood relationship and gene |
| CN106970999A (en) * | 2017-04-12 | 2017-07-21 | 中国能源建设集团湖南省电力设计院有限公司 | A kind of BPA Database Modelings and maintaining method |
| CN106970999B (en) * | 2017-04-12 | 2020-11-17 | 中国能源建设集团湖南省电力设计院有限公司 | BPA database modeling and maintaining method |
| CN107328995A (en) * | 2017-07-18 | 2017-11-07 | 国网天津市电力公司 | A kind of high-voltage dc transmission electrical impedance scanning method |
| CN108629004A (en) * | 2018-05-03 | 2018-10-09 | 广东电网有限责任公司 | Summarize data capture method, device and electronic equipment |
| CN109470973A (en) * | 2018-11-30 | 2019-03-15 | 广西电网有限责任公司电力科学研究院 | A kind of failure card library method for building up based on PSD-BPA |
| CN109470973B (en) * | 2018-11-30 | 2020-11-13 | 广西电网有限责任公司电力科学研究院 | Fault card library establishing method based on PSD-BPA |
| CN110413970A (en) * | 2019-07-17 | 2019-11-05 | 陕西千山航空电子有限责任公司 | A kind of Embedded training layout data loading method |
| CN112241399A (en) * | 2020-09-30 | 2021-01-19 | 贵州电网有限责任公司电力调度控制中心 | PSD-BPA data analysis and management method and system based on NoSQL |
| CN112241399B (en) * | 2020-09-30 | 2024-04-05 | 贵州电网有限责任公司电力调度控制中心 | NoSQL-based PSD-BPA data analysis and management method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104063519B (en) | 2017-04-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104063519A (en) | BPA power grid data analyzing and managing method and system based on EXCEL | |
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| CN111324647A (en) | Method and device for generating ETL code | |
| CN105512425B (en) | A kind of IO PAD layout construction method based on graphical interfaces | |
| CN104317864B (en) | A method of the information model automatic identification based on IEC61850 logical nodes | |
| CN104331446A (en) | Memory map-based mass data preprocessing method | |
| CN104866580A (en) | Method for quickly detecting impact caused by database modification to current service | |
| CN105279269B (en) | A kind of support matrix freely associated SQL generation methods and system | |
| CN108829653A (en) | A kind of generation method of report, device, equipment and medium | |
| CN101201833A (en) | System and method for filling PDF document data | |
| JP2015530050A (en) | Method for guaranteeing consistency of planning data and related apparatus | |
| CN106599064A (en) | Method for automatically classifying, obtaining and storing complex knowledge of high-end device | |
| CN101527454A (en) | Method for automatically generating annual running mode report of power grid | |
| CN107944659A (en) | A kind of substation supervisory control system auto report completing method and apparatus | |
| CN112905642B (en) | Method for storing IEC61850 report data into relational database based on CSV mapping file | |
| CN111177177A (en) | Automatic reporting system and method based on multi-source heterogeneous data fusion | |
| CN115576928A (en) | Automatic checking method and system for monitoring information point table of transformer substation | |
| CN105740997A (en) | Method and device for controlling task flow, and database management system | |
| CN113204864A (en) | Method and system suitable for transmission network simulation data version control | |
| CN108038620A (en) | The comprehensive inspection tour system of substation and inspection method based on cell phone application | |
| Berro et al. | Graph-based ETL processes for warehousing statistical open data | |
| CN113222455A (en) | Generator set parameter name matching method based on modular decomposition and matching | |
| CN110956283B (en) | Method and system for matching SCD file with soft pressing plate | |
| CN111290771A (en) | System upgrading method, device, equipment and computer readable storage medium | |
| CN104408316A (en) | Chinese and American geotechnical engineering soil classification criterion conversion device and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20171130 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Co-patentee after: State Grid Fujian Electric Power Co., Ltd. Patentee after: State Grid Corporation of China Co-patentee after: Electric Power Research Institute, State Grid Fujian Electric Power Co., Ltd. Co-patentee after: Economic technology academy of State Grid Fujian Electric Power Co., Ltd. Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Co-patentee before: State Grid Fujian Electric Power Co., Ltd. Patentee before: State Grid Corporation of China Co-patentee before: Electric Power Research Institute, State Grid Fujian Electric Power Co., Ltd. |
|
| TR01 | Transfer of patent right |