CN105718583B - A method of interface conversion between PFO data format and XLS - Google Patents

Abstract

The invention provides an interface conversion method between the PFO data format and XLS. By reading the PFO format file exported by the BPA software into the program, the BPA power flow calculation results are positioned and rearranged, and exported to the XLS file, which solves the problem of power consumption. After the system analysis software BPA is widely used in the power system, the amount of information in the power flow calculation results is relatively large, and it is difficult to intuitively obtain the required key information, which has strong engineering practicability.

Description

A method of interface conversion between PFO data format and XLS

technical field

The invention belongs to the application field of power system analysis, and in particular relates to an interface conversion method between a PFO data format and an XLS data format exported by BPA software.

Background technique

Since the PSD-BPA power flow and transient stability and man-machine interface program based on Windows operating system was launched at the end of 1997, it has been widely used in power system planning and design, operation scheduling, teaching and scientific research and other departments. With the extensive application of BPA programs abroad and at home, people continue to put forward new requirements for the continuous development and improvement of the programs, making BPA get new developments in both the United States and China.

The BPA software package is mainly composed of power flow and transient stability programs, and has the characteristics of large calculation scale, fast calculation speed, good numerical stability, and strong functions. The main functions of the power flow calculation program are: basic power flow calculation function, calculation of voltage, power, etc.; custom output function; load static characteristic simulation function; generator power characteristic control function; node P-V, P-Q, Q-V curve calculation function; node, line , Loss sensitivity analysis; N-1 breaking simulation; regional tie line power control. The transient stability program is a powerful tool for analyzing the dynamic behavior of the power system under various disturbances in the steady state. It can be used to simulate the operation and control of the power system; calculate the short-circuit current; study UHV DC transmission, wind power and FACTS devices, etc., and has a wide range of functions in the stability analysis and calculation of large power grids.

At present, the calculation scale that can be realized by BPA is already very large, and it is still growing rapidly. The number of nodes has reached 20,000, and the number of branches can reach 80,000; in terms of the accommodation of DC lines, it can contain 100 DC lines and more than 50 multi-section DC lines; it can contain more than 100 switching power areas, 300 partitions, There can be more than 500 power exchange connection lines between each sub-area.

A notable feature of the BPA software package is that the BPA network data is input in the form of a card, and the data must be entered in strict accordance with the specified format, otherwise the software cannot recognize it. The AC node data card is usually filled with B card, and the optional node types are PQ node, PV node, and Vθ node. The line data card usually adopts an L card, which needs to fill in the rated current, resistance, reactance, conductance to ground G/2, and susceptance to ground B/2 per unit. The transformer data card generally adopts T card or R card, and needs to fill in rated capacity, equivalent resistance R, leakage reactance X, equivalent conductance G, per unit value of excitation susceptance B, and transformation ratio.

PSD-BPA software has strong operability and friendly human-computer interaction interface, which makes it popular and applied in power system gradually. Many power companies and research institutes use BPA software to build power grid models in different regions for simulation research. When analyzing the power flow calculation results of these areas, it is necessary to export the power flow calculation results saved in the PFO data format from the BPA software. The power flow calculation results saved in the PFO data format include the output of each generator, the power flow on each line and the power flow flowing through each transformer.

However, power system staff are actually most concerned about the loss and weak links of each partition of the power grid, such as voltage cross-border nodes, high-load lines and transformers. If the indicators that these staff are more concerned about are extracted from the PFO file to the XLS file one by one through manual methods, it will require a large workload, which will not only take a long time and be inefficient, but also easily cause various errors, resulting in Waste of manpower and material resources. Therefore, it is very necessary to seek an intelligent interface conversion method to extract the important information in the PFO format data into a tidy, concise and clear XLS file.

Contents of the invention

The purpose of the present invention is to provide a PFO data format and XLS interface conversion method, the method aims to solve the BPA power flow calculation results PFO file redundant information is more difficult to intuitively obtain the required key information problem.

To achieve the above object, the present invention adopts the following technical solutions:

1) Read the power flow calculation result PFO file of the power system analysis platform BPA into the program;

2) After step 1), the available information of the power flow calculation result is extracted;

3) Save the extracted available information as XLS data format.

The program is selected from a compiled program capable of reading files, such as a C++ program.

Described step 2) specifically comprises the following steps:

Determine the start and end positions of the data list containing the available information in the PFO file, and then extract and store the corresponding available information into the structure array according to the structure of the data list.

The starting position of the data list is determined by matching the characteristic string (unique) at a specific position in the row where the header of the data list is located.

The method for determining the end position of the data list is: if the data list is a continuous list that does not contain blank lines, the end position of the continuous list is reached when the first blank line is read from the start position ; If the data list is a discontinuous list containing blank lines, the end position of the discontinuous list is reached when the content of the next data list is read from the start position.

The data list includes one or more of a voltage out-of-bounds list, a system loss data list, a heavy-duty line list, and a heavy-duty transformer list.

The available information includes one or more of voltage out-of-bounds information, system loss information, overloaded line information, and overloaded transformer information.

The beneficial effects of the present invention are reflected in:

The interface conversion method between the PFO data format and XLS described in the present invention can be used as an interface program, so that the BPA software can be effectively combined with a variety of software that can recognize the XLS file format, and can be applied to the fields of planning and operation of the power grid, making the calculation become It is more convenient and has engineering practical value.

Furthermore, when analyzing the weak link of the power grid or calculating the network loss, it is necessary to search in the PFO file of the BPA power flow calculation result. If artificial statistical information is used, it is not only difficult to quickly locate the required information, but also time-consuming and error-prone. The present invention skips a large number of unnecessary information parts such as the control statements in the PFO file of the BPA power flow calculation result and the power flow distribution on each line, and locates the concerns of the power system staff in the voltage out-of-bounds list, the partition loss list, and the heavy load list. The key information in the line list and heavy-duty transformer list can be quickly, accurately and effectively imported into the neatly formatted XLS file, without manual statistical information, which greatly improves the efficiency of calculation and has strong engineering practicability.

Description of drawings

Fig. 1 is a flowchart of the interface conversion method of the present invention.

Detailed ways

The present invention will be described in detail below in conjunction with the accompanying drawings and embodiments. Take power flow calculations as an example, but the invention is general.

Open the data file (DAT format) to be calculated in the power system analysis software PSD-BPA (hereinafter referred to as BPA), and set the path where the BPA program is located and the execution path of the data file. Then execute the BPA power flow program. If the power flow calculation results converge, a PFO file of the power flow calculation results will be generated at the execution path of the data file. The PFO file contains all the information of the power flow calculation results, such as the convergence of the power flow results, the power flow on each line of the grid to be requested, the voltage of each node, and the power flow on each transformer. Since the PFO file is automatically generated by BPA software, its format is fixed, but it is difficult for power system staff to intuitively find the key information needed, so it needs to be converted. The following provides the format conversion method from the PFO file exported by the BPA software to the neatly formatted XLS file. Let's explain in detail:

1. PFO file export

Exporting PFO files in BPA software is the preparation for data format conversion, and the correctness of data export is directly related to the correctness and accuracy of subsequent data format conversion. Here are the basic steps to export a PFO file:

1) Open the DAT file to be calculated in the BPA software, set the path of the BPA software and the path of the DAT file, and adjust the output control statement in the DAT file so that the information storage format in the calculation result file is the specified format. The given output control statements are shown in Table 1:

Table 1

2) After making preparations, click the "Execute BPA Power Flow Program" button in the BPA software. At this time, BPA will complete the power flow calculation of the input data DAT file, and store all the information of the power flow calculation results in the path where the DAT file is located. in a newly generated PFO file.

3) Rename the obtained PFO file to "result", and at this point, the export of the PFO file is completed.

2. PFO file format conversion

After getting the above PFO file, convert it into format. The present invention utilizes C++ program to write interface conversion program, and flow process is as shown in Figure 1, and concrete steps are as follows:

a. Complete the positioning of the voltage out-of-bounds list, which is realized by judging whether the first to fifth characters of a certain line in the PFO format data are "lowest". Under a given output control statement, the header of the voltage out-of-bounds list is "*low voltage and overvoltage node data list", and the list can be uniquely located by identifying the five characters of "*lowest" in a specific position.

In the voltage out-of-bounds list, the partition name of the voltage out-of-bounds node is in the 12-13 column, the node name is in the 18-25 column, the node rated voltage is in the 27-32 column, the node type is in the 35th column, and the node actual voltage is in the 42- 47 columns, the per unit value of node voltage is in the 50th-55th column, the voltage lower limit is in the 60th-65th column, the voltage upper limit is in the 68th-73rd column, the information indicating the high or low voltage (indicating the positive negative) in columns 78-84. Depending on the name of the partition, the number of partition voltage cross-border nodes can be realized by distinguishing the partition name, and the 78th column character (the column character is "—" or "", if it is "—" indicates If it is "", it means the voltage is high) to count the number of low voltage nodes and high voltage nodes.

b. After obtaining the number of voltage out-of-bound nodes in each zone, several structure arrays can be defined, and the size of each structure array is the number of voltage out-of-bound nodes in the zone to which it belongs. The members of the structure include partition name, node name, node rated voltage, node type, node actual voltage, node voltage per unit value, voltage lower bound, voltage upper bound, and out-of-bounds voltage value. Use the defined structure array to store the voltage out-of-bounds information of each partition one by one.

c. Complete the positioning of the system loss data list, which is realized by judging whether the 6th to 9th characters of a certain line in the PFO format data are "according to points". Under the given output control statement, the header of the system loss data list is "*system loss data list according to the partition order", and the list can be uniquely located by identifying the four characters of "photograph" in a specific position.

In the system loss data list, the partition name is in columns 4-5, the word "summary" occupies four characters in columns 12-15, the active power loss of the line is in columns 29-35, and the reactive power loss of the line is in 37-43 column, transformer active loss is in column 48-54, transformer reactive loss is in column 57-63, DC converter active loss is in column 67-73, DC converter reactive loss is in column 77-83, partition The total internal active power loss is listed in columns 86-92, and the total reactive power loss in the partition is listed in columns 96-102. According to the different partition names, different types of losses in each partition can be counted by distinguishing the partition name.

d. Define a structure array for storing system loss of each partition, and the size of the structure array represents the number of partitions. The members of the structure include partition name, "summary", line active power loss, line reactive power loss, transformer active power loss, transformer reactive power loss, DC converter active power loss, DC converter reactive power loss, and total active power in the corresponding zone losses and total reactive losses. Use this structure array to store the system loss information of each partition one by one.

e. Complete the positioning of the overloaded line list, which is realized by judging whether the 6th to 9th characters of a certain line in the PFO format data are "road negative". Under the given output control statement, the header of the overloaded line list is "*data list with line load exceeding 80.0% of the rated value", which can be uniquely located by identifying the four characters of "Line Negative" at the specific position list.

In the list of overloaded lines, the name of the first node of the line is in columns 4-11, the voltage of the first node is in columns 12-18, the name of the end nodes of the line is in columns 19-26, the voltage of the end nodes is in columns 27-33, the line The current is in column 37-44, the rated current is in column 46-53, the current ratio is in column 56-63, the apparent power is in column 64-71, the rated apparent power is in column 73-80, the apparent power Scale is in columns 87-92, power factor is in columns 94-101, and angle is in columns 102-108.

f. After the number of overloaded lines is counted, a structure array for storing the information of the overloaded lines can be defined, and the size of the structure array is the number of overloaded lines. Structure members include head node name, head node voltage, end node name, end node voltage, line current, rated current, current ratio, apparent power, rated apparent power, apparent power ratio, power factor, and angle. Use this structure array to store overloaded line information one by one.

g. Complete the positioning of the list of heavy-duty transformers, which is realized by judging whether the 8th-11th characters of a certain line in the PFO format data are "equipment negative". Under the given output control statement, the header of the list of heavy-duty transformers is "*data list of transformer load exceeding 80.0% of rated value", which can be uniquely located by identifying the four characters of "device negative" in the specific position. list.

In the list of heavy-duty transformers, the node names on side A are in columns 4-11, the node voltages on side A are in columns 12-18, the node names on side B are in columns 19-26, and the node voltages on side B are in columns 27-33. The apparent power is listed in columns 35-42, the rated apparent power is listed in columns 46-52, the power ratio is listed in columns 56-61, and the power factor is listed in columns 64-69.

h. After the number of heavy-duty transformers is counted, a structure array for storing information of heavy-duty transformers can be defined, and the size of the structure array is the number of heavy-duty transformers. The structure members include A-side node name, A-side node voltage, B-side node name, B-side node voltage, apparent power, rated apparent power, apparent power ratio, and power factor. Use this structure array to store overloaded transformer information one by one.

i. For the determination of the end of a certain data list: in the above list, if the list is a continuous list (that is, a list that does not contain blank lines), the reading of the continuous list ends when a blank line is encountered; if the list is not For a continuous list (that is, a list containing blank lines), the reading of the non-sequential list ends when the content of the next list is encountered.

Based on this, a structure array is obtained which respectively stores the voltage crossing information, system loss information, overloaded line information, and overloaded transformer information. Export the information stored in each structure array to different XLS files, that is, complete the conversion of the PFO file format to XLS.

Claims (2)

1. a kind of interface conversion method of PFO data format and XLS, it is characterized in that: comprise the following steps: in BPA software, open the DAT file of required calculation, set BPA software place path and DAT file place path, in DAT file to The output control statement is adjusted so that the information storage format in the calculation result file is the specified format; Click the "Execute BPA Power Flow Program" button in the BPA software, at this time BPA will complete the power flow calculation of the input data DAT file, and store all the information of the power flow calculation result in a newly generated PFO file under the path where the DAT file is located; After the PFO file used to record the power flow calculation results is read in the compiler with file reading capability, the characteristics of the specific position under the given output control statement are matched by matching the header of the data list containing the available information in the PFO file character string, so as to determine the starting position of the data list; determine the end position of the data list: if the data list is a continuous list that does not contain blank lines, read from the starting position to the first blank line If the data list is a discontinuous list containing blank lines, the end position of the discontinuous list will be reached when the content of the next data list is read from the start position ; The data list includes one or more of a voltage out-of-bounds list, a system loss data list, a heavy-duty line list, and a heavy-duty transformer list. According to the data list structure, the available information of the power flow calculation result is judged and extracted, and the The corresponding available information is extracted and stored in a structure array; the extracted available information is saved in XLS data format. 2. according to the interface conversion method of a kind of PFO data format and XLS described in claim 1, it is characterized in that: described usable information comprises a kind of in voltage transboundary information, system loss information, heavy-duty line information and heavy-duty transformer information or more.