CN113239676B - PSD-BPA software calculation auxiliary method - Google Patents

Abstract

The invention discloses a PSD-BPA software calculation auxiliary method, which comprises the following steps: step S100: establishing a standardized spreadsheet, wherein the spreadsheet comprises 6 sub-tables which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table; step S200: optimizing internal structures of the DAT file and the SWI file; step S300: the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates the DAT file or SWI file with the sub-table data therein. According to the invention, on the basis of carrying out modeling and maintenance methods of the PSD-BPA database by means of the standardized electronic table, the standardized table structure is further optimized, and a PSD electric power simulation calculation auxiliary system is developed, so that the operation flows of data packet construction, maintenance and engineering calculation are reduced, and the calculation steps are standardized, thereby effectively improving the simulation calculation efficiency of the electric power system.

Description

PSD-BPA software calculation auxiliary method

Technical Field

The invention relates to the technical field of simulation calculation of power systems, in particular to a PSD-BPA software calculation auxiliary method.

Background

The BPA power system simulation calculation software originates from the United states, is introduced by the Chinese Power science research institute, forms a Chinese version BPA program (hereinafter referred to as PSD-BPA program) suitable for analysis and calculation of a power system in China on the basis of a new version (1990 version) BPA program after further development and improvement, and is widely applied to power system planning design, scheduling operation and teaching and scientific research departments. PSD, Power System Department, BPA, Bonneville Power Administration, Banner Wigner.

The PSD-BPA software has modules of load flow calculation, electromechanical transient stability calculation, short circuit calculation, small interference stability calculation and the like, and is strong in function and high in precision. The PSD-BPA calculation software mainly comprises two basic input data files, namely a power flow data file (the file suffix is DAT and is called DAT file for short) and a stable data file (the file suffix is called SWI and is called SWI file for short). The DAT file mainly comprises load flow calculation control statements, network data (node and branch data) and the like, and the SWI file mainly comprises stable calculation control statements, various element simulation models, a network zero sequence model and the like. The two types of data files both adopt a data card form, and a user can adjust the database by directly modifying the bottom layer text, so that the simulation calculation efficiency can be effectively improved. However, since the computing program adopts the input format of the FORTRAN language, the requirement on the data format is very strict, and the user should input data in the designated column according to the format designated in the data card, so that the data input can be accurately completed. At present, a power system in China is an ultra-large power grid formed by combining a large unit, a large power grid, high-voltage, long-distance, large-capacity power transmission and the like, the scale of the power grid is very large, and the power grid is mainly characterized by wide networking range, multiple voltage levels and complex component types. When a user builds and maintains a simulation calculation database, the user faces more complicated work; in actual simulation calculation, the workload of database adjustment is increased due to the requirement of multi-mode calculation in consideration of the structural development of a power grid and various operation conditions of the power grid.

Based on the existing research, the following problems also exist:

1) the statistics of key indexes are lacked in the standardized table, and the formed new database has weak convergence after the content is adjusted in a large range. In general engineering calculation, the power grid structure, the power output and the load level need to be corrected and adjusted on the original basis, after the data are adjusted in a large range, the macro indexes such as the power output, the load and the like of each area cannot be counted in a table, and a user cannot obtain the real-time state of the adjusted database. When a data packet is imported for load flow calculation, the convergence of a newly formed data packet is reduced because the original balance of active power and reactive power in a research area is broken and an external interface network of the area is not correspondingly adjusted.

2) Along with the rapid development of a power grid, the diversity of system elements is richer, the modeling is continuously carried out by using element typical parameters, and the accuracy of a simulation model is difficult to ensure. For example, in recent years, the main rack of the receiving-end system is continuously strengthened, the electrical distance between elements is further reduced, and the control of the short-circuit current level of the bus in the substation has become a key problem in the development of the power grid nowadays. In order to control the level of the short-circuit current, measures such as a high-impedance parameter transformer, a transformer neutral point plus a small reactance and the like are adopted, a database transformer is only modeled by typical parameters, and the risk of distortion of simulation calculation exists.

3) Switching of multiple software windows, frequently copy and paste operations. In the practical calculation and use process, when data is adjusted in a large range, an Excel table is often adjusted to generate a new data card statement, and then the new data card is copied to DAT and SWI files class by class. Due to the increase of calculation schemes, the Excel table interface and the PSD-BPA editing interface are frequently switched, repeated copying and pasting operations are carried out, and the error rate is high.

4) The calculation operation is difficult to normalize, and the data in the standardized table is difficult to keep consistent with the data in the DAT (SWI) file. Because the PSD-BPA software can directly modify the DAT and SWI files of the bottom layer to complete the adjustment of the data packet, in the actual calculation process, due to the lack of constraint of operation standardization, a user directly modifies the DAT or SWI files to complete the calculation during data fine adjustment, and does not correspondingly adjust the related data of the Excel table. After many times of such operations, the data contained in the standardized table file, the DAT file, and the SWI file are independent of each other, and are difficult to synchronize. The DAT and SWI files contain data inconsistencies that will affect subsequent stable and short circuit calculations. Excel table data and database data cannot be synchronized in real time, source tracing traces are difficult to leave after history is modified, and readability and inheritance of the database are greatly reduced.

Therefore, how to effectively improve the simulation calculation efficiency of the power system by optimizing the spreadsheet structure becomes a technical problem that needs to be solved urgently by those skilled in the art.

Disclosure of Invention

The invention aims to provide a PSD-BPA software calculation auxiliary method which can optimize a standardized structure of an electronic form, thereby reducing the operation processes of PSD-BPA software data packet construction, maintenance and engineering calculation, standardizing the calculation steps and effectively improving the simulation calculation efficiency of a power system.

The invention provides a PSD-BPA software calculation auxiliary method, which comprises the following steps:

step S100: establishing a standardized spreadsheet, wherein the spreadsheet comprises 6 sub-tables which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table;

the step S100 is specifically:

step S110: the data in the electronic form is standardized, the electronic form comprises 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table, and the method specifically comprises the following steps:

the power supply meter comprises a power generating set module and a booster station module; the generating set module comprises a set name, a zone name of the set, installed capacity, station power consumption and a force output mode, and the booster station module comprises a booster variable parameter and an electric main wiring parameter;

the unit parameter table comprises motor parameters, speed regulator parameters, excitation system parameters and stabilizer parameters;

the load meter comprises a site name, a site affiliated partition name, a load mode, main transformer capacity, main transformer number, low-voltage reactance, low-voltage capacitance and a reactive switching mode;

the transformer table comprises a transformer name, equivalent parameters, a transformation ratio and a tap position;

the line basic parameter table comprises line type, reactance, resistance, susceptance and limit transmission power;

the line table comprises a line starting point, a line ending point, a line type, a length and a high impedance;

step S120: based on the original data in the standardized spreadsheet, according to the power and electric quantity balance and the active and reactive power balance relation, performing partition calculation and obtaining the power shortage and surplus condition of each area;

step S200: optimizing internal structures of a DAT file and a SWI file in PSD-BPA software;

the DAT file and the SWI file in step S200 are specifically:

the DAT file and the SWI file respectively comprise a power source data card, a load data card, a transformer substation data card and a line data card; the power source data card comprises a power source table and a unit parameter table; the transformer substation data card comprises a transformer meter; the line data card comprises a line basic parameter table and a line table;

sorting the data cards in the DAT file and the SWI file according to the PSD-BPA software requirement; setting a start row and an end row of a data card to set identifiers for retrieving corresponding row positions when the PSD electric power simulation calculation auxiliary system is written;

step S300: the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates the DAT file or the SWI file with the sub-table data thereof.

Preferably, the step S300 specifically includes:

step S310: selecting a standardized spreadsheet as a source file;

step S320: detecting whether the type of the selected source file meets the requirement, if so, entering the step S330, otherwise, returning to the step S310;

step S330: acquiring a selected spreadsheet file path, and assigning a value to a variable for standby;

step S340: selecting a DAT file or an SWI file as a target file;

step S350: detecting whether the type of the selected target file meets the requirement, if so, entering the step S360, otherwise, returning to the step S340;

step S360: respectively acquiring the selected DAT file path and the SWI file path, and assigning values to variables for standby;

step S370: and selecting parameters needing to be updated, reading sub-table data in the standardized spreadsheet by the auxiliary power simulation calculation system according to the selected parameters PSD, retrieving the corresponding row position of the DAT file or the SWI file, and updating the DAT file or the SWI file.

Preferably, the step S300 further includes, after the step S370:

step S380: returning to step S370, after obtaining the latest DAT file or SWI file, proceeding to step S390;

step S390: and carrying out load flow calculation, stability calculation or short circuit calculation by PSD-BPA software.

Preferably, the updating the DAT file in step S370 specifically includes:

step S3701: reading a DAT file by a PSD electric power simulation calculation auxiliary system, and storing the DAT file in DAT data frames line by line in a character string mode;

step S3702: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, and if so, entering a step S3703, and if not, entering a step S3704;

step S3703: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the spreadsheet, and stores all parameters in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original power source data cards in the DAT data frames, and the updating of the power source related data cards in the DAT data frames is realized;

step S3704: the PSD electric power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3705 is carried out, and if not, the step S3706 is carried out;

step S3705: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the DAT data frames, and the updating of the load related data cards in the DAT data frames is realized;

step S3706: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3707 is carried out, and if not, the step S3708 is carried out;

step S3707: the PSD electric power simulation calculation auxiliary system reads a substation table in the electronic table, and stores all corresponding data cards in the substation table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original substation data cards of the DAT data frames, and updating of the related data cards of the substation in the DAT data frames is achieved;

step S3708: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a line data card, if yes, the step S3709 is carried out, and if not, the step S3710 is carried out;

step S3709: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original line data cards of the DAT data frames, and updating of line related data cards in the DAT data frames is achieved;

step S3710: and writing the data card statements in the updated DAT data frames into the DAT file line by the PSD electric power simulation calculation auxiliary system so as to complete the updating of the DAT file.

Preferably, the updating the SWI file in step S370 specifically includes:

step S3721: the PSD electric power simulation calculation auxiliary system reads the SWI file and stores the SWI file in SWI data frames line by line in a character string mode;

step S3722: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, if yes, entering a step S3723, and if not, entering a step S3724;

step S3723: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the electronic form, and stores all corresponding data cards in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original unit parameter data cards of the SWI data frames, so that the updating of the unit parameter related data cards in the SWI data frames is realized;

step S3724: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3725 is carried out, and if not, the step S3726 is carried out;

step S3725: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the SWI data frames, so that the load-related data cards in the SWI data frames are updated;

step S3726: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3727 is carried out, and if not, the step S3728 is carried out;

step S3727: the PSD electric power simulation calculation auxiliary system reads a transformer table in the electronic table and stores all corresponding data cards in the transformer table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original transformer data cards of the SWI data frames, so that the updating of the related data cards of the transformer in the SWI data frames is realized;

step S3728: the PSD power simulation calculation auxiliary system detects whether the parameter to be updated includes a line data card, if so, proceeds to step S3729, and if not, proceeds to step S3730;

step S3729: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original line data cards of the SWI data frames, so that the line-related data cards in the SWI data frames are updated;

step S3730: and the PSD electric power simulation calculation auxiliary system writes the updated SWI data frame data into the SWI file line by line to complete the updating of the SWI file.

The invention can optimize the standardized structure of the electronic forms, thereby reducing the operation processes of PSD-BPA software data packet construction, maintenance and engineering calculation, standardizing the calculation steps and effectively improving the simulation calculation efficiency of the power system.

Drawings

FIG. 1 is a flow chart of a PSD-BPA software calculation assistance method provided in a first embodiment;

FIG. 2 is a flow chart of a PSD-BPA software calculation assisting method provided by the second embodiment;

FIG. 3 is a flow chart of a PSD-BPA software calculation assistance method provided by a third embodiment;

FIG. 4 is a flowchart of the present invention providing a PSD-BPA software calculation assistance method for updating DAT files in step S370;

FIG. 5 is a flowchart of the method for assisting PSD-BPA software calculation according to the present invention for updating SWI files in step S370.

Detailed Description

In order to make the technical solutions of the present invention better understood, the present invention is further described in detail below with reference to the accompanying drawings.

Referring to fig. 1, fig. 1 is a flowchart of a PSD-BPA software calculation assisting method provided in the first embodiment.

The invention provides a PSD-BPA software calculation auxiliary method, which comprises the following steps:

step S100: establishing a standardized spreadsheet, wherein the spreadsheet comprises 6 sub-tables which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table;

step S200: optimizing internal structures of a DAT file and a SWI file in PSD-BPA software;

step S300: the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates the DAT file or the SWI file with the sub-table data thereof.

Establishing standardized electronic forms such as EXCEL and WPS, wherein the electronic forms comprise 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table; optimizing internal structures of a DAT file and a SWI file in PSD-BPA software; the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates the DAT file or the SWI file with the sub-table data thereof.

When the power grid structure, the power output and the load level need to be corrected and adjusted in a large range on the original basis, a user reads the standardized spreadsheet through the PSD power simulation calculation auxiliary system and updates the DAT file or the SWI file by using sub-table data, so that the real-time state of the adjusted database can be obtained. By optimizing the standardized structure of the electronic forms, the PSD-BPA database data package building, maintenance and engineering calculation operation flows are reduced, the standardized calculation steps are performed, the PSD power simulation calculation auxiliary system reads the standardized electronic forms, and the DAT files or the SWI files are updated by using the sub-form data, so that subsequent processing such as stable calculation and short circuit calculation is performed, and the simulation calculation efficiency of the power system is effectively improved.

Referring to fig. 2, fig. 2 is a flowchart of a PSD-BPA software calculation assisting method according to a second embodiment.

The invention provides a PSD-BPA software calculation auxiliary method, which comprises the following steps:

step S110: the data in the electronic form is standardized, the electronic form comprises 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table, and the method specifically comprises the following steps:

the power supply meter comprises a power generating set module and a booster station module; the generating set module comprises a set name, a zone name of the set, installed capacity, station power consumption and a force output mode, and the booster station module comprises a booster variable parameter and an electric main wiring parameter; the output mode comprises a plurality of operation modes, such as big summer, small summer and the like;

the unit parameter table comprises motor parameters, speed regulator parameters, excitation system parameters and stabilizer parameters;

the load meter comprises a site name, a site affiliated partition name, a load mode, main transformer capacity, main transformer number, low-voltage reactance, low-voltage capacitance and a reactive switching mode;

the transformer table comprises a transformer name, equivalent parameters, a transformation ratio and a tap position;

the line basic parameter table comprises line type, reactance, resistance, susceptance and limit transmission power;

the line table comprises a line starting point, a line ending point, a line type, a length and a high impedance;

in the spreadsheet, the power supply table, the unit parameter table, the load table, the transformer table, the line basic parameter table and the line table carry out statistical classification on important parts and parameter conditions involved in the simulation calculation of the power system, so that the precision and the accuracy of the simulation calculation of the power system are improved.

Step S120: based on the original data in the standardized spreadsheet, according to the power and electric quantity balance and the active and reactive power balance relation, the subarea calculation is carried out, the power shortage and surplus condition of each area is obtained, and the research area is preliminarily calculated

、

And effective reference is provided for subsequent adjustment of power supply starting modes and cross-region power exchange.

The electric quantity balance refers to the balance between the electric quantity required by the electric power system and the electric quantity generated by each power plant in a specified time (year, month and day); the power balance refers to the balance between active power and load generated by a power supply in a power system. The active balance refers to the situation that the power shortage between the regions is judged by calculating the difference value between the active power (or electric quantity) sent by the power supply side and the active power (or electric quantity) needed by the load side. The reactive power balance is mainly embodied in the voltage of each transformer substation, and the voltage is kept in a reasonable range allowed by a power grid by switching capacitors and reactors.

………………………………………（1）

…………………………………（2）

………………………………………………（3）

………………………………………（4）

Wherein:

、

the active power and reactive power output (including capacitance and reactance) of the j node in the i region is obtained;

、

the active power and reactive power loads of the j node in the i area are calculated;

、

loss of active power and reactive power in the ith area;

、

calculating the balance of the active power and the reactive power in the ith area (the positive value is surplus, and the negative value is deficiency);

、

the active power and the reactive power (positive value is input power, and negative value is output power) are exchanged for the power of the whole region and an external power grid.

、

The closer the calculated value is to 0, the closer the reactive power and the active power in the research area are to balance, and the better the calculation convergence of the formed database is. Step S200: internal structures of a DAT file and a SWI file in PSD-BPA software are optimized, wherein the DAT file and the SWI file are specifically as follows:

the DAT file and the SWI file respectively comprise a power source data card, a load data card, a transformer substation data card and a line data card; the power source data card comprises a power source table and a unit parameter table; the transformer substation data card comprises a transformer meter; the line data card comprises a line basic parameter table and a line table.

Further, sorting the data cards in the DAT file and the SWI file according to the PSD-BPA software requirement; and setting identification words for the starting row and the ending row of the data card, and retrieving the corresponding row position when the PSD electric power simulation calculation auxiliary system is written.

The power source data card as DAT file sets "'… … > > power source & booster station-START < < … …'", "'… … > > power source & booster station-END < < … …'" as its START and END row set flags.

The power source data card as SWI file sets "'… … > > power unit parameter-START < < … …'", "'… … > > power unit parameter-END < < … …'" as its START and END line setting flags.

Step S310: selecting a standardized spreadsheet as a source file;

step S320: detecting whether the type of the selected source file meets the requirement, if so, entering the step S330, otherwise, returning to the step S310;

preferably, when the standardized EXCEL spreadsheet is adopted, whether a check file suffix is xls or xlsx is judged by extracting a source file path, namely whether a source file is an EXCEL form file type meeting requirements is judged; if the file type meets the requirement, the step S330 is executed to determine that the source file is a standardized spreadsheet.

Step S330: acquiring a selected spreadsheet file path, assigning to a preset intermediate variable, and requiring to refer to the file path when the PSD electric power simulation calculation auxiliary system reads an access file;

step S340: selecting a DAT file or an SWI file as a target file;

step S350: detecting whether the type of the selected target file meets the requirement, if so, entering the step S360, otherwise, returning to the step S340;

judging whether a suffix of the target file is DAT or SWI by extracting a path of the target file, namely judging whether the target file is a DAT file or an SWI file type meeting the requirement; if the file type satisfies the requirement, the target file is determined to be a DAT file or a SWI file, and the process proceeds to step S360.

Step S360: respectively acquiring paths of the selected DAT file and the SWI file, assigning the paths to preset intermediate variables, and referring to the paths when a subsequent PSD power simulation calculation auxiliary system reads access files;

step S370: and selecting parameters needing to be updated, reading sub-table data in the standardized spreadsheet by the auxiliary power simulation calculation system according to the selected parameters PSD, retrieving the corresponding row position of the DAT file or the SWI file, and updating the DAT file or the SWI file.

Data in the electronic forms are subjected to standardized processing, internal structures of a DAT file and an SWI file in PSD-BPA software are optimized, each parameter table is refined, and the requirements of element diversity on model specificity after power grid development are met; the calculation process is optimized, the operation procedures are greatly reduced, and after the electronic forms are modeled or the data are adjusted in a large scale, the time consumed by forming new DAT and SWI database files by means of the PSD power simulation calculation auxiliary system is increased to be within 10 seconds from 5-10 minutes of the original method, so that the working efficiency is further improved. Through the PSD electric power simulation calculation auxiliary system, the calculation process of PSD-BPA software can be systematically standardized, the working standardization can be realized, the readability and the inheritance of a database can be improved, and the team cooperation efficiency can be improved.

Referring to fig. 3, fig. 3 is a flowchart of a PSD-BPA software calculation assisting method according to a third embodiment.

The invention provides a PSD-BPA software calculation auxiliary method, which comprises the following steps:

step S110: the data in the electronic form is standardized, the electronic form comprises 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table, and the method specifically comprises the following steps:

the power supply meter comprises a power generating set module and a booster station module; the generating set module comprises a set name, a zone name of the set, installed capacity, station power consumption and a force output mode, and the booster station module comprises a booster variable parameter and an electric main wiring parameter;

the unit parameter table comprises motor parameters, speed regulator parameters, excitation system parameters and stabilizer parameters;

the load meter comprises a site name, a site affiliated partition name, a load mode, main transformer capacity, main transformer number, low-voltage reactance, low-voltage capacitance and a reactive switching mode;

the transformer table comprises a transformer name, equivalent parameters, a transformation ratio and a tap position;

the line basic parameter table comprises line type, reactance, resistance, susceptance and limit transmission power;

the line table comprises a line starting point, a line ending point, a line type, a length and a high impedance;

step S120: and based on the original data in the standardized spreadsheet, performing partition calculation and acquiring the power shortage and shortage condition of each area according to the power and electric quantity balance and active and reactive power balance relation.

Step S200: optimizing internal structures of a DAT file and a SWI file, wherein the DAT file and the SWI file are specifically as follows:

the DAT file and the SWI file respectively comprise a power source data card, a load data card, a transformer substation data card and a line data card; the power source data card comprises a power source table and a unit parameter table; the transformer substation data card comprises a transformer meter; the line data card comprises a line basic parameter table and a line table.

Sorting the data cards in the DAT file and the SWI file according to the PSD-BPA software requirement; and setting identification words for the starting row and the ending row of the data card, and retrieving the corresponding row position when the PSD electric power simulation calculation auxiliary system is written.

Step S310: selecting a standardized spreadsheet as a source file;

step S320: detecting whether the selected file type meets the requirement, if so, entering the step S330, otherwise, returning to the step S310;

step S330: acquiring a selected spreadsheet file path, and assigning a value to a preset variable for later use;

step S340: selecting a DAT file or an SWI file as a target file;

step S350: detecting whether the selected file type meets the requirement, if so, entering the step S360, otherwise, returning to the step S340;

step S360: respectively acquiring the selected DAT file path and the SWI file path, and assigning values to preset variables for standby;

step S370: and selecting parameters needing to be updated, reading sub-table data in the standardized spreadsheet by the auxiliary power simulation calculation system according to the selected parameters PSD, retrieving the corresponding row position of the DAT file or the SWI file, and updating the DAT file or the SWI file.

Step S380: returning to step S370, after obtaining the latest DAT file or SWI file, proceeding to step S390;

step S390: and carrying out load flow calculation, stability calculation or short circuit calculation by PSD-BPA software.

The third implementation mode is different from the second implementation mode in that the DAT file or the SWI file is refreshed before the PSD-BPA software performs load flow calculation, stability calculation or short circuit calculation to obtain real-time data, so that a user can analyze the active and reactive power profit and loss conditions of each partition power system in real time, adjust the load and power output level in real time according to the ground, and improve the convergence of newly formed database calculation. The operation process of simulation calculation is simplified, and the efficiency of the simulation calculation of the power system is improved.

Referring to FIG. 4, FIG. 4 is a flowchart of the method for updating DAT file in step S370 according to the invention.

The step S370 of updating the DAT file specifically includes:

step S3701: reading a DAT file by a PSD electric power simulation calculation auxiliary system, and storing the DAT file in DAT data frames line by line in a character string mode;

step S3702: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, and if so, entering a step S3703, and if not, entering a step S3704;

step S3703: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the spreadsheet, and stores all parameters in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original power source data cards in the DAT data frames, so that the updating of the power source related data cards in the DAT data frames is realized;

step S3704: the PSD electric power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3705 is carried out, and if not, the step S3706 is carried out;

step S3705: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the DAT data frames, and the updating of the load related data cards in the DAT data frames is realized;

step S3706: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3707 is carried out, and if not, the step S3708 is carried out;

step S3707: the PSD electric power simulation calculation auxiliary system reads a substation table in the electronic table, and stores all corresponding data cards in the substation table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original substation data cards of the DAT data frames, so that updating of the related data cards of the substation in the DAT data frames is achieved;

step S3708: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a line data card, if yes, the step S3709 is carried out, and if not, the step S3710 is carried out;

step S3709: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original line data cards of the DAT data frames, so that updating of line related data cards in the DAT data frames is achieved;

step S3710: and writing the data card statements in the updated DAT data frames into the DAT file line by the PSD electric power simulation calculation auxiliary system so as to complete the updating of the DAT file.

The data card in the electronic form is read and written into the DAT file, so that the data card in the electronic form and the DAT file are synchronized, frequent manual copying-pasting work is avoided, strict unification of the table and the library is realized, simulation calculation operation is normalized, and the PSD-BPA simulation calculation work efficiency is improved.

Referring to fig. 5, fig. 5 is a flowchart of the method for assisting PSD-BPA software calculation according to the present invention to update the SWI file in step S370.

Preferably, the updating the SWI file in step S370 specifically includes:

step S3721: the PSD electric power simulation calculation auxiliary system reads the SWI file and stores the SWI file in SWI data frames line by line in a character string mode;

step S3722: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, if yes, entering a step S3723, and if not, entering a step S3724;

step S3723: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the electronic form, and stores all corresponding data cards in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original unit parameter data cards of the SWI data frames, so that the updating of the unit parameter related data cards in the SWI data frames is realized;

step S3724: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3725 is carried out, and if not, the step S3726 is carried out;

step S3725: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the SWI data frames, so that the load-related data cards in the SWI data frames are updated;

step S3726: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3727 is carried out, and if not, the step S3728 is carried out;

step S3727: the PSD electric power simulation calculation auxiliary system reads a transformer table in the electronic table and stores all corresponding data cards in the transformer table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original transformer data cards of the SWI data frames, so that the updating of the related data cards of the transformer in the SWI data frames is realized;

step S3728: the PSD power simulation calculation auxiliary system detects whether the parameter to be updated includes a line data card, if so, proceeds to step S3729, and if not, proceeds to step S3730;

step S3729: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original line data cards of the SWI data frames, so that the line-related data cards in the SWI data frames are updated;

step S3730: and the PSD electric power simulation calculation auxiliary system writes the updated SWI data frame data into the SWI file line by line to complete the updating of the SWI file.

The data card in the electronic form is read and written into the SWI file, so that the data card in the electronic form and the SWI file are synchronized, frequent manual copying-pasting work is avoided, strict unification of the table and the library is realized, simulation calculation operation is normalized, and the working efficiency of PSD-BPA simulation calculation is improved.

Furthermore, the PSD power simulation calculation auxiliary system is an application program arranged on a user terminal, reads the standardized spreadsheet and updates a DAT file or a SWI file of PSD-BPA software by using sub-table data.

The PSD electric power simulation calculation auxiliary system comprises a man-machine interaction interface, wherein the man-machine interaction interface comprises three operation options of selecting a file, updating content and updating operation. Selecting a file operation option, wherein the file operation option is used for specifying a data source file (electronic form) and a target file (SWI and DAT file) through a dialog window form, updating a content operation option, selecting and setting a DAT file of PSD-BPA software or a data card (power supply, load, transformer substation, line and the like) to be updated in the SWI file through a Boolean type control form, and updating the operation option, and the file operation option is used for starting reading of a standardized electronic form through a button mode and updating the data card in the DAT file or the SWI file of the PSD-BPA software.

The user terminal may be a computer terminal or other mobile device terminal.

And setting the update content personalized selection, reducing program reading and writing tasks according to the actual requirements of engineering calculation, improving the program running speed and fluency, and improving the user experience.

The PSD-BPA software calculation auxiliary method provided by the invention is described in detail above. The principles and embodiments of the present invention are explained herein using specific examples, which are presented only to assist in understanding the core concepts of the present invention. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.

Claims (2)

1. A PSD-BPA software calculation auxiliary method is characterized by comprising the following steps:

step S100: establishing a standardized spreadsheet, wherein the spreadsheet comprises 6 sub-tables which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table;

the step S100 is specifically:

step S110: the data in the electronic form is standardized, the electronic form comprises 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table, and the method specifically comprises the following steps:

the power supply meter comprises a power generating set module and a booster station module; the generating set module comprises a set name, a zone name of the set, installed capacity, station power consumption and a force output mode, and the booster station module comprises a booster variable parameter and an electric main wiring parameter;

the unit parameter table comprises motor parameters, speed regulator parameters, excitation system parameters and stabilizer parameters;

the load meter comprises a site name, a site affiliated partition name, a load mode, main transformer capacity, main transformer number, low-voltage reactance, low-voltage capacitance and a reactive switching mode;

the transformer table comprises a transformer name, equivalent parameters, a transformation ratio and a tap position;

the line basic parameter table comprises line type, reactance, resistance, susceptance and limit transmission power;

the line table comprises a line starting point, a line ending point, a line type, a length and a high impedance;

step S120: based on the original data in the standardized spreadsheet, according to the power and electric quantity balance and the active and reactive power balance relation, performing partition calculation and obtaining the power shortage and surplus condition of each area;

step S200: optimizing internal structures of a DAT file and a SWI file in PSD-BPA software;

the DAT file and the SWI file are specifically:

the DAT file and the SWI file respectively comprise a power source data card, a load data card, a transformer substation data card and a line data card; the power source data card comprises a power source table and a unit parameter table; the transformer substation data card comprises a transformer meter; the line data card comprises a line basic parameter table and a line table;

sorting the data cards in the DAT file and the SWI file according to the PSD-BPA software requirement; setting a start row and an end row of a data card to set identifiers for retrieving corresponding row positions when the PSD electric power simulation calculation auxiliary system is written;

step S300: the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates a DAT file or an SWI file by using sub-table data of the standardized spreadsheet;

the step S300 specifically includes:

step S310: selecting a standardized spreadsheet as a source file;

step S320: detecting whether the type of the selected source file meets the requirement, if so, entering the step S330, otherwise, returning to the step S310;

step S330: acquiring a selected spreadsheet file path, and assigning a value to a variable for standby;

step S340: selecting a DAT file or an SWI file as a target file;

step S350: detecting whether the type of the selected target file meets the requirement, if so, entering the step S360, otherwise, returning to the step S340;

step S360: respectively acquiring the selected DAT file path and the SWI file path, and assigning values to variables for standby;

step S370: selecting parameters needing to be updated, reading sub-table data in the standardized spreadsheet by the PSD power simulation calculation auxiliary system according to the selected parameters, retrieving corresponding row positions of the DAT file or the SWI file, and updating the DAT file or the SWI file;

step S380: returning to step S370, after obtaining the latest DAT file or SWI file, proceeding to step S390;

step S390: carrying out load flow calculation, stability calculation or short circuit calculation by PSD-BPA software;

the step S370 of updating the DAT file specifically includes:

step S3701: reading a DAT file by a PSD electric power simulation calculation auxiliary system, and storing the DAT file in DAT data frames line by line in a character string mode;

step S3702: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, and if so, entering a step S3703, and if not, entering a step S3704;

step S3703: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the spreadsheet, and stores all parameters in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original power source data cards in the DAT data frames, and the updating of the power source related data cards in the DAT data frames is realized;

step S3704: the PSD electric power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3705 is carried out, and if not, the step S3706 is carried out;

step S3705: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the DAT data frames and the temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the DAT data frames, and the updating of the load related data cards in the DAT data frames is realized;

step S3706: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3707 is carried out, and if not, the step S3708 is carried out;

step S3707: the PSD electric power simulation calculation auxiliary system reads a substation table in the electronic table, and stores all corresponding data cards in the substation table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original substation data cards of the DAT data frames, and updating of the related data cards of the substation in the DAT data frames is achieved;

step S3708: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a line data card, if yes, the step S3709 is carried out, and if not, the step S3710 is carried out;

step S3709: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices data cards of the DAT data frames and temporary intermediate data frames, namely, the data cards in the intermediate data frames replace original line data cards of the DAT data frames, and updating of line related data cards in the DAT data frames is achieved;

step S3710: and writing the data card statements in the updated DAT data frames into the DAT file line by the PSD electric power simulation calculation auxiliary system so as to complete the updating of the DAT file.

2. A PSD-BPA software calculation auxiliary method is characterized by comprising the following steps:

step S100: establishing a standardized spreadsheet, wherein the spreadsheet comprises 6 sub-tables which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table;

the step S100 is specifically:

step S110: the data in the electronic form is standardized, the electronic form comprises 6 sub-forms which are respectively a power supply table, a unit parameter table, a load table, a transformer table, a line basic parameter table and a line table, and the method specifically comprises the following steps:

the power supply meter comprises a power generating set module and a booster station module; the generating set module comprises a set name, a zone name of the set, installed capacity, station power consumption and a force output mode, and the booster station module comprises a booster variable parameter and an electric main wiring parameter;

the unit parameter table comprises motor parameters, speed regulator parameters, excitation system parameters and stabilizer parameters;

the load meter comprises a site name, a site affiliated partition name, a load mode, main transformer capacity, main transformer number, low-voltage reactance, low-voltage capacitance and a reactive switching mode;

the transformer table comprises a transformer name, equivalent parameters, a transformation ratio and a tap position;

the line basic parameter table comprises line type, reactance, resistance, susceptance and limit transmission power;

the line table comprises a line starting point, a line ending point, a line type, a length and a high impedance;

step S120: based on the original data in the standardized spreadsheet, according to the power and electric quantity balance and the active and reactive power balance relation, performing partition calculation and obtaining the power shortage and surplus condition of each area;

step S200: optimizing internal structures of a DAT file and a SWI file in PSD-BPA software;

the DAT file and the SWI file are specifically:

the DAT file and the SWI file respectively comprise a power source data card, a load data card, a transformer substation data card and a line data card; the power source data card comprises a power source table and a unit parameter table; the transformer substation data card comprises a transformer meter; the line data card comprises a line basic parameter table and a line table;

sorting the data cards in the DAT file and the SWI file according to the PSD-BPA software requirement; setting a start row and an end row of a data card to set identifiers for retrieving corresponding row positions when the PSD electric power simulation calculation auxiliary system is written;

step S300: the PSD power simulation calculation auxiliary system reads the standardized spreadsheet and updates a DAT file or an SWI file by using sub-table data of the standardized spreadsheet;

the step S300 specifically includes:

step S310: selecting a standardized spreadsheet as a source file;

step S320: detecting whether the type of the selected source file meets the requirement, if so, entering the step S330, otherwise, returning to the step S310;

step S330: acquiring a selected spreadsheet file path, and assigning a value to a variable for standby;

step S340: selecting a DAT file or an SWI file as a target file;

step S350: detecting whether the type of the selected target file meets the requirement, if so, entering the step S360, otherwise, returning to the step S340;

step S360: respectively acquiring the selected DAT file path and the SWI file path, and assigning values to variables for standby;

step S370: selecting parameters needing to be updated, reading sub-table data in the standardized spreadsheet by the PSD power simulation calculation auxiliary system according to the selected parameters, retrieving corresponding row positions of the DAT file or the SWI file, and updating the DAT file or the SWI file;

step S380: returning to step S370, after obtaining the latest DAT file or SWI file, proceeding to step S390;

step S390: carrying out load flow calculation, stability calculation or short circuit calculation by PSD-BPA software;

the updating the SWI file in step S370 specifically includes:

step S3721: the PSD electric power simulation calculation auxiliary system reads the SWI file and stores the SWI file in SWI data frames line by line in a character string mode;

step S3722: selecting parameters needing to be updated, detecting whether the parameters needing to be updated comprise a power source data card by the aid of the PSD power simulation calculation auxiliary system, if yes, entering a step S3723, and if not, entering a step S3724;

step S3723: the PSD electric power simulation calculation auxiliary system reads a power supply table and a unit parameter table in the electronic form, and stores all corresponding data cards in the power supply table and the unit parameter table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original unit parameter data cards of the SWI data frames, so that the updating of the unit parameter related data cards in the SWI data frames is realized;

step S3724: the PSD power simulation calculation auxiliary system detects whether the parameters needing to be updated contain a load data card, if so, the step S3725 is carried out, and if not, the step S3726 is carried out;

step S3725: the PSD electric power simulation calculation auxiliary system reads a load table in the electronic form and stores all corresponding data cards in the load table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the SWI data frames and the data cards of temporary intermediate data frames, namely, the data cards in the intermediate data frames replace the original load data cards of the SWI data frames, so that the load-related data cards in the SWI data frames are updated;

step S3726: the PSD power simulation calculation auxiliary system detects whether parameters needing to be updated contain a substation data card, if yes, the step S3727 is carried out, and if not, the step S3728 is carried out;

step S3727: the PSD electric power simulation calculation auxiliary system reads a transformer table in the electronic table and stores all corresponding data cards in the transformer table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original transformer data cards of the SWI data frames, so that the updating of the related data cards of the transformer in the SWI data frames is realized;

step S3728: the PSD power simulation calculation auxiliary system detects whether the parameter to be updated includes a line data card, if so, proceeds to step S3729, and if not, proceeds to step S3730;

step S3729: the PSD electric power simulation calculation auxiliary system reads a line table in the spreadsheet and stores all corresponding data cards in the line table in a temporary intermediate data frame variable line by line in a character string mode; the PSD electric power simulation calculation auxiliary system splices the data cards of the SWI data frames and the intermediate data frames, namely, the data cards in the intermediate data frames replace the original line data cards of the SWI data frames, so that the line-related data cards in the SWI data frames are updated;

step S3730: and the PSD electric power simulation calculation auxiliary system writes the updated SWI data frame data into the SWI file line by line to complete the updating of the SWI file.

Images