EXCEL-based rapid design method for station power utilization system in transformer substation

Abstract

The invention relates to the field of power utilization of transformer substations, and discloses an EXCEL-based rapid design method for a station power utilization system in a transformer substation, and the method comprises the steps: building a worksheet in the EXCEL, and inputting project data and preset data into the worksheet; outputting result data in the worksheet; parameters, same as the preset data, in the result data are equal to parameter values of the same parameters in the preset data through a table formula, and parameters, different from the preset data, in the result data are obtained through calculation of the parameter values of the project data and the preset data through the table formula; the project data is manually modified according to project requirements, the result data is calculated and modified according to project expectation, the cells of the modified project data and the result data display different colors, and the different colors are used for prompting whether the data in the cells meet regulations or not. And efficient and errorless design of the station power utilization system in the transformer substation is realized.

Description

Technical Field

[0001] The invention belongs to the field of power supply in substations, and in particular relates to a rapid design method for a power supply system in a substation based on EXCEL. Background Art

[0002] With the continuous development of society, the power industry has also been developing rapidly. The overall scale and number of substation projects have increased significantly, and higher requirements have been placed on the speed of substation construction. The current construction model of prefabricated substations is constantly being promoted, especially in the construction process of new energy power generation and energy storage industries, where prefabricated substations are mostly used. In the ever-shrinking construction cycle of prefabricated substations, more stringent challenges have been posed to the speed and quality of design.

[0003] In the entire substation system design process, the station power system responsible for powering the entire station is very important. Especially in the early stage of design, the calculation and verification of station transformer capacity, number of low-voltage cabinets, cable length and other issues, this important and complicated process has always troubled designers. At present, the traditional manual calculation method has problems of low efficiency and poor quality. Especially when the load and master plan change, a large amount of data modification is prone to errors.

[0004] In view of this, how to design an efficient and accurate station power system design technology is the technical problem to be solved by the present invention. Summary of the invention

[0005] The invention provides a rapid design method for a substation power system based on EXCEL, which can realize efficient and accurate design of the substation power system and improve production efficiency.

[0006] In order to achieve the above technical objectives, the present invention adopts the following technical solutions:

[0007] The present invention provides a method for quickly designing a substation power system based on EXCEL, comprising:

[0008] S1, creating a worksheet in EXCEL, inputting project data and preset data into the worksheet, wherein the project data is data input according to project requirements, and the preset data is station power system data obtained according to previous actual production;

[0009] S2, outputting result data in the worksheet, the result data being data used for rapid design of the power system in the substation; the parameters in the result data that are the same as the preset data are equal to the parameter values ​​of the same parameters in the preset data through a table formula, and the parameters in the result data that are different from the preset data are calculated through the project data and the parameter values ​​of the preset data through a table formula;

[0010] S3, manually modifying the project data according to project requirements, calculating and modifying the result data according to project expectations, and displaying different colors in the cells of the modified project data and result data, and the different colors are used to indicate whether the data in the cells complies with regulations.

[0011] As described above, in the EXCEL-based rapid design method for the substation power system, the project data includes the load name, load voltage, load power, number of load operating circuits, number of load installations, number of phases and information on the area where the load is located; the preset data includes circuit breaker preset specifications, area preset distances, and cable preset specifications; the result data includes circuit breaker specifications, cable specifications, cable length, station transformer capacity and number of cabinets.

[0012] The above-mentioned rapid design method of the substation power system based on EXCEL is specifically calculated according to the project expectations as follows:

[0013] Calculating the load current according to the load voltage and load power, and then selecting the circuit breaker specification according to the load current;

[0014] Select cable specifications according to the circuit breaker specifications;

[0015] Select the cable length according to the preset distance of the area;

[0016] Calculate the number of panels according to the circuit breaker specifications;

[0017] According to the load name and load power, the station transformer capacity is calculated.

[0018] As described above, the EXCEL-based rapid design method for the substation power system, the circuit breaker specifications are selected according to the load current as follows: traverse the cells of the circuit breaker preset rated current, select the value of the minimum circuit breaker preset rated current greater than the load current as the circuit breaker rated current, and then select the circuit breaker module according to the circuit breaker rated current.

[0019] The above-mentioned rapid design method of the substation power system based on EXCEL is used to calculate the number of cabinets according to the circuit breaker specifications:

[0020]

[0021] Among them, N represents the number of cabinets used; Q represents the sum of the circuit breaker modules used by all circuits; F represents the total number of drawers of the cabinet manually entered.

[0022] As described above, the rapid design method for the substation power system based on EXCEL calculates the station transformer capacity according to the load name and load power, specifically, the sum of the load powers of loads with different names is calculated respectively, and then the station transformer capacity is calculated by the following formula:

[0023] S=0.85·S p1 +S p2 +S p3

[0024] Where S represents the station variable capacity; S p1 Indicates the sum of the power loads; S p2 Represents the sum of the electric and heating load powers; S p3 Represents the sum of lighting load powers.

[0025] According to the above-mentioned rapid design method for the substation power system based on EXCEL, the cells of the modified project data and the result data are displayed in different colors as follows:

[0026] If it complies with the regulations after modification, the cell will display the original color;

[0027] If it does not meet the regulations after modification, the cell will be displayed in red;

[0028] If the cost increases after the modification but complies with the regulations, the cell will be displayed in green.

[0029] As described above, in the rapid design method for the substation power system based on EXCEL, the original colors of the cells include:

[0030] White cells indicate that changing the value in the cell is not recommended;

[0031] Yellow cells indicate that the value in the cell needs to be changed;

[0032] A blue cell means that the value in the cell can be modified but it is not recommended.

[0033] In the above-mentioned EXCEL-based rapid design method for the substation power system, the table formulas and the cells displaying different colors are implemented through VBA language.

[0034] Compared with the prior art, the advantages and positive effects of the present invention are: a rapid design method for the station power system in a substation is designed based on an EXCLE table, which provides a reliable way and solution for realizing efficient design of the substation; the result data required for the design of the station power system can be quickly obtained through the EXCEL table formula according to the preset data, and the data can be manually modified according to project requirements and project expectations, and the modified data cells can be changed to different colors to prompt whether they comply with the regulations, thereby reducing design errors, improving design efficiency, and being able to further shorten the design cycle, thereby advancing procurement time, saving project time, optimizing warehouse inventory, and saving money. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative labor.

[0036] Figure 1 It is a flowchart of an embodiment of a method for rapid design of a substation power system based on EXCEL of the present invention;

[0037] Figure 2 It is a schematic diagram of worksheet item data in an embodiment of a method for rapid design of a substation power system based on EXCEL according to the present invention;

[0038] Figure 3 It is a schematic diagram of preset data in a worksheet in an embodiment of a method for rapid design of a substation power system based on EXCEL according to the present invention;

[0039] Figure 4 It is a schematic diagram of worksheet result data in an embodiment of a method for rapid design of a substation power system based on EXCEL according to the present invention. DETAILED DESCRIPTION

[0040] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0041] It should be noted that in the description of the present invention, the terms "upper", "lower", "left", "right", "vertical", "horizontal", "inner", "outer" and the like indicating directions or positional relationships are based on the directions or positional relationships shown in the drawings, which are only for the convenience of description, and do not indicate or imply that the device or element must have a specific orientation, be constructed and operated in a specific orientation, and therefore cannot be understood as limiting the present invention. In addition, the terms "first" and "second" are used for descriptive purposes only, and cannot be understood as indicating or implying relative importance.

[0042] In the present invention, unless otherwise clearly specified and limited, the terms "installed", "connected", "connected" and the like should be understood in a broad sense, for example, it can be a fixed connection, a detachable connection, or an integral connection; it can be a mechanical connection or an electrical connection; it can be a direct connection, or it can be an indirect connection through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0043] In the present invention, unless otherwise clearly specified and limited, a first feature being "above" or "below" a second feature may include that the first and second features are in direct contact, or may include that the first and second features are not in direct contact but are in contact through another feature between them. Moreover, a first feature being "above", "above" and "above" a second feature includes that the first feature is directly above and obliquely above the second feature, or simply indicates that the first feature is higher in level than the second feature. A first feature being "below", "below" and "below" a second feature includes that the first feature is directly below and obliquely below the second feature, or simply indicates that the first feature is lower in level than the second feature.

[0044] The disclosure below provides many different embodiments or examples to realize different structures of the present invention. In order to simplify the disclosure of the present invention, the parts and settings of specific examples are described below. Of course, they are only examples, and the purpose is not to limit the present invention. In addition, the present invention can repeat reference numbers and / or reference letters in different examples, and this repetition is for the purpose of simplicity and clarity, which itself does not indicate the relationship between the various embodiments and / or settings discussed. In addition, the present invention provides various specific examples of processes and materials, but those of ordinary skill in the art can be aware of the application of other processes and / or the use of other materials.

[0045] like Figures 1 to 4 As shown, the present application provides a method for rapid design of a substation power system based on EXCEL, comprising the following specific steps:

[0046] S1. Create a worksheet in EXCEL, enter project data and preset data in the worksheet. Project data is data entered according to project requirements, and preset data is station power system data obtained based on previous actual production. The preset data is the optimal value that can ensure the smooth operation of the station power system and is economical. Specifically:

[0047] In this application, multiple sheets are created in the worksheet, one of which is used to enter various parameters of project data and corresponding parameter values; one or more sheets are used to enter various parameters of preset data and corresponding parameter values.

[0048] The parameters of the project data include the load name, load voltage, load power, number of load operating circuits, number of load installations, number of phases, and information about the area where the load is located; the preset data includes the preset specifications of the circuit breaker, the preset distance of the area, and the preset specifications of the cable. The preset specifications of the circuit breaker include the preset rated current of the circuit breaker and the module of the circuit breaker. The preset specifications of the cable include the number of cable cores and the cross-sectional area of ​​the cable; the result data includes the specifications of the circuit breaker, the area distance, the cable specifications, the cable length, the station transformer capacity, and the number of cabinets. The parameter content of the project data, preset data, and result data can be entered according to actual needs. Figures 2 to 4 For reference only, not all parameters are listed in detail.

[0049] S2, output the result data in the worksheet. The result data is used for the rapid design of the power system in the substation. The parameters in the result data that are the same as the preset data are equal to the parameter values ​​of the same parameters in the preset data through the table formula. The parameters in the result data that are different from the preset data are calculated through the table formula using the parameter values ​​of the project data and the preset data. Specifically:

[0050] In one of the worksheets, the parameters of the result data are entered separately. The parameter values ​​of the result data are obtained through table formulas. For example, the preset data is in cell I2 of the sheet named "preset data", and the result data is in cell K2 of the sheet named "result data". The formula of cell K2 is "=preset data! I2". The project data, preset data, and result data can also be respectively reflected by multiple sheets. This application only provides the case where they are respectively reflected by a single sheet, such as Figures 2 to 4 shown.

[0051] S3, manually modify project data according to project requirements, calculate and modify result data according to project expectations, and the cells of modified project data and result data are displayed in different colors. Different colors are used to indicate whether the data in the cells comply with regulations. The regulations refer to the set value ranges of various parameters set for the safe operation of the substation power system. Project expectations refer to expectations based on the later planning of the project. Therefore, the result data cannot directly use preset data, but needs to be calculated.

[0052] The calculation results according to the project expectations are as follows:

[0053] Calculate the load current based on the load voltage and load power, and then select the circuit breaker specifications based on the load current. Specifically,

[0054] First, set the load current column and calculate the load current according to the values ​​of the cells in the column where the phase number information, load power and load voltage are located. The calculation formula is as follows:

[0055] If it is a single-phase load, the calculation formula is:

[0056]

[0057] If it is a three-phase load, the calculation formula is:

[0058]

[0059] Among them, I represents the value of the cell where the load current is located; P represents the value of the cell where the load power is located; and U represents the value of the cell where the load voltage is located. Then, traverse the cells of the circuit breaker preset rated current and select the value of the minimum circuit breaker preset rated current that is greater than the load current as the circuit breaker rated current. For example, if α, β, and γ are the values ​​of the circuit breaker preset rated current, and α<β<γ,

[0060] When (margin factor × load current) < α, the rated current of the circuit breaker is α;

[0061] When α<(margin factor × load current)<β, the rated current of the circuit breaker is β;

[0062] And so on.

[0063] Selecting the rated current of the circuit breaker by comparing the load current multiplied by the margin coefficient with the preset rated current value of the circuit breaker can improve the reliability of circuit operation. The margin coefficient is generally selected as 1.2 based on production experience.

[0064] Then, the corresponding circuit breaker modulus is automatically selected according to the value of the circuit breaker rated current. The selection logic is as follows:

[0065] When the rated current of the circuit breaker is below 100A, the module of the circuit breaker is 8 / 2E;

[0066] When the rated current of the circuit breaker is above 100A and below 250A, the module of the circuit breaker is 8E;

[0067] When the rated current of the circuit breaker is above 250A and below 400A, the module of the circuit breaker is 16E;

[0068] When the rated current of the circuit breaker is above 400A and below 630A, the module of the circuit breaker is 24E;

[0069] When the rated current of the circuit breaker is above 603A and below 1250A, the module of the circuit breaker is 32E.

[0070] Automatically select the cable specification according to the circuit breaker specification. The selection logic is: compare the value of the cell where the circuit breaker rated current is located with the preset cable specification and select the corresponding cable specification. For example: if α1, β1, and γ1 are the values ​​of the preset cable specifications, the rated current corresponding to α1 is α, the rated current corresponding to β1 is β, and the rated current corresponding to γ1 is γ, and α<β<γ,

[0071] When (margin factor × load current) < α, the cable specification is α1;

[0072] When α<(margin coefficient×load current)<β, the cable specification is β1;

[0073] And so on.

[0074] Select the cable length according to the preset distance of the area, specifically:

[0075] According to the master plan, manually input the load area information and the preset distance of the area, and adjust the length of the relevant cable specifications based on the corresponding relationship between the two.

[0076] For example: load 1 is located in area A, and the cable specification is X; load 2 is located in area B, and the cable specification is Y; load 3 is located in area C, and the cable specification is X; the preset distance in area A is a, the preset distance in area B is b, and the preset distance in area C is c.

[0077] The total length of cable specification X is a+c; the total length of cable specification Y is b.

[0078] Calculate the number of panels according to the circuit breaker specifications, specifically:

[0079]

[0080] Among them, N represents the number of cabinets used; Q represents the sum of the circuit breaker modules used by all circuits; F represents the total number of drawers of the cabinet manually entered.

[0081] The loads are classified according to their names, including power loads, electric heating loads and lighting loads. Then the station transformer capacity is calculated according to the load power of different categories. The calculation formula is as follows:

[0082] S=0.85·S p1 +S p2 +S p3

[0083] Where S represents the station variable capacity; S p1 Indicates the sum of the power loads; S p2 Represents the sum of the electric and heating load powers; S p3 Represents the sum of lighting load powers.

[0084] The logic of displaying different colors for cells is as follows: the cell whose color needs to be modified is the target cell; the cell that will affect the modification of the color of the target cell is the related cell, and there may be multiple related cells. The color of the target cell is improved according to the data attribute relationship between the related cells and the target cell.

[0085] For example, if the target cell is I3, the data stored is the rated current of the circuit breaker, and the related cell is C3, the data stored is the load power. When the value of cell I3 is manually modified, it is determined whether the value input to cell I3 exceeds the set value X; if it exceeds, the background color of cell I3 is adjusted to red, and if it does not exceed, the background color of cell I3 remains green; the set value X is obtained by calculation from the value in cell C3, and the formulas used to solve the target cell through the related cells are all existing technologies in the field, so they are not listed here one by one.

[0086] The color descriptions of the cell change colors are as follows:

[0087] If it complies with the regulations after modification, the cell will display the original color;

[0088] If it does not meet the regulations after modification, the cell will be displayed in red;

[0089] If the cost increases after the modification but complies with the regulations, the cell will be displayed in green.

[0090] The original cell colors include:

[0091] White cells indicate that changing the value in the cell is not recommended;

[0092] Yellow cells indicate that the value in the cell needs to be changed;

[0093] A blue cell means that the value in the cell can be modified but it is not recommended.

[0094] Table formulas and cells display different colors through VBA language. VBA language is easy to use and has complete functions, which is convenient for improving design efficiency.

[0095] The EXCEL-based rapid design method for the substation power system provided in the present application can quickly obtain the required result data according to the preset data obtained in actual production after the project data is input. The project data and result data can also be manually modified according to the project expectations, and after the modification, the table will automatically display different colors to prompt whether the modification complies with the regulations, which greatly shortens the design cycle, reduces design errors, and improves production efficiency.

[0096] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "illustrative embodiments", "examples", "specific examples", or "some examples" means that the specific features, structures, materials, or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present invention. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials, or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0097] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit the same. Although the present invention has been described in detail with reference to the aforementioned embodiments, it is still possible for a person skilled in the art to modify the technical solutions described in the aforementioned embodiments, or to replace some of the technical features therein by equivalents. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions claimed to be protected by the present invention.

Claims

1. A rapid design method for substation power system based on EXCEL, characterized in that: The following steps are involved: S1, creating a worksheet in EXCEL, inputting project data and preset data into the worksheet, wherein the project data is data input according to project requirements, and the preset data is station power system data obtained according to previous actual production; S2, outputting result data in the worksheet, the result data being data used for rapid design of the power system in the substation; the parameters in the result data that are the same as the preset data are equal to the parameter values ​​of the same parameters in the preset data through a table formula, and the parameters in the result data that are different from the preset data are calculated through the project data and the parameter values ​​of the preset data through a table formula; S3, manually modifying the project data according to project requirements, calculating and modifying the result data according to project expectations, and displaying different colors in the cells of the modified project data and result data, and the different colors are used to indicate whether the data in the cells complies with regulations.

2. The rapid design method of substation power system based on EXCEL according to claim 1 is characterized in that: The project data includes load name, load voltage, load power, number of load operating circuits, number of load installations, number of phases and information about the area where the load is located; the preset data includes circuit breaker preset specifications, area preset distances and cable preset specifications; the result data includes circuit breaker specifications, cable specifications, cable length, station transformer capacity and number of cabinets.

3. The rapid design method of substation power system based on EXCEL according to claim 2 is characterized in that: The result data calculated according to project expectations are as follows: Calculating the load current according to the load voltage and load power, and then selecting the circuit breaker specification according to the load current; Select cable specifications according to the circuit breaker specifications; Select the cable length according to the preset distance of the area; Calculate the number of panels according to the circuit breaker specifications; According to the load name and load power, the station transformer capacity is calculated.

4. The rapid design method of substation power system based on EXCEL according to claim 3 is characterized in that: The specific method of selecting the circuit breaker specification according to the load current is as follows: traverse the cells of the circuit breaker preset rated current, select the value of the minimum circuit breaker preset rated current greater than the load current as the circuit breaker rated current, and then select the circuit breaker module according to the circuit breaker rated current.

5. The rapid design method of substation power system based on EXCEL according to claim 4 is characterized in that: The specific calculation of the number of cabinets according to the circuit breaker specifications is: Among them, N represents the number of cabinets used; Q represents the sum of the circuit breaker modules used by all circuits; F represents the total number of drawers of the cabinet manually entered.

6. The rapid design method of substation power system based on EXCEL according to claim 3 is characterized in that: The specific method of calculating the station transformer capacity according to the load name and load power is to calculate the sum of the load powers of loads with different names respectively, and then calculate the station transformer capacity by the following formula: S=0.85·S p1 +S p2 +S p3 Where S represents the station variable capacity; S p1 Indicates the sum of the power loads; S p2 Represents the sum of the electric and heating load powers; S p3 Represents the sum of lighting load powers.

7. The method for rapid design of substation power system based on EXCEL according to any one of claims 1 to 6, characterized in that: The cells of the modified project data and result data are displayed in different colors as follows: If it complies with the regulations after modification, the cell will display the original color; If it does not meet the regulations after modification, the cell will be displayed in red; If the cost increases after the modification but complies with the regulations, the cell will be displayed in green.

8. The rapid design method of substation power system based on EXCEL according to claim 7 is characterized in that: The original cell colors include: White cells indicate that changing the value in the cell is not recommended; Yellow cells indicate that the value in the cell needs to be changed; A blue cell means that the value in the cell can be modified but it is not recommended.

9. The rapid design method of substation power system based on EXCEL according to claim 1 is characterized in that: The table formula and the cells displaying different colors are implemented through VBA language.

Images