EXCEL-Based Fast Integration Method for Wind Farm Collector Lines and Wind Turbines

Abstract

A rapid integration method for the collector lines and wind turbines of a wind farm in a power system based on EXCEL, which is realized by using the logic, statistical, lookup reference, and text functions and custom formulas of EXCEL, including: collecting and preprocessing the data of the collector lines and wind turbines (transformer substations) of the wind farm; processing the collected data to generate a standardized data table of the collector lines of the wind farm; judging the positions of the nodes of each sub-line; determining the number of wind turbines at each node; determining the lengths of the sub-lines of the collector lines and the conductor parameters corresponding to different numbers of wind turbines; and finally integrating them into the data information of the collector lines with the number of aggregated wind turbines as an index. The integration efficiency of the present invention is high, and it can be directly used for the theoretical analysis of the reactive power balance of the wind farm, effectively improving the analysis efficiency. After the standardized data table of the collector lines of the wind farm generated by the present invention is imported into the DIgSILENT software, the process of building the collector line simulation module of the DIgSILENT software is significantly accelerated.

Description

Technical Field

[0001] The present invention belongs to the technical field of power systems, and particularly relates to a method for quickly integrating the collector lines and wind turbines of a wind farm based on EXCEL. Background Art

[0002] With the proposal of the "dual carbon" goal, the demand for building a new power system dominated by new energy is becoming increasingly urgent. As an important component of new energy, the development responsibility of wind power will be even more arduous. For areas with excellent wind resources, in order to pursue the sustainable economic development of the wind power industry, the trend of large-scale and base-scale development will become dominant. By then, the scale of a single wind farm will reach several hundred thousand kilowatts or even more than one million kilowatts, the number of wind turbines will be more than one hundred, and the scale of the collector lines will also be more than one hundred. The collector line system will become increasingly complex and disorderly.

[0003] At present, the theoretical analysis of reactive power balance in the design stage of wind farm access systems mainly focuses on the analysis of wind farm step-up substations and outgoing lines. The calculation of collector line and box transformer losses is relatively rough, usually based on proportional estimation or manual calculation. However, as the scale of wind farms continues to increase, the scales of collector lines and box transformers will both change significantly, and their impact on the overall reactive power configuration of wind farms will also be further enhanced. In this case, if the proportional estimation method is adopted, the deviation will increase significantly, resulting in the inconsistency between the proposed reactive power configuration scheme and the actual demand; if the manual calculation method is used, the efficiency will be significantly low, which not only increases the work difficulty of designers but also increases the error rate of data analysis. Therefore, quickly integrating the collector lines and wind turbines of a wind farm is particularly important for improving the efficiency of theoretical analysis of reactive power balance in wind farms.

[0004] DIgSILENT / PowerFactory software is a large-scale power system comprehensive simulation software developed by DIgSILENT GmbH in Germany. It includes the main simulation analysis functions for the planning and operation of existing power systems and is the main application software for current wind farm reactive power analysis. Usually, when performing reactive power simulation analysis on a wind farm, designers need to manually build the layout of the wind farm step-up substation, outgoing lines, and internal collector lines point by point and line by line. When the scale of the wind farm is large, the above building work intensity increases significantly, the work efficiency decreases significantly, and there are disadvantages of manual input such as node duplication and wiring errors, thus affecting the final reactive power analysis simulation results of the software. Entering the integrated standardized wind farm collector line data table into the DIgSILENT software can significantly accelerate the building process of the DIgSILENT software wind farm collector line simulation module and reduce the error risks such as misconnection and duplication. Summary of the Invention

[0005] The purpose of the present invention is to provide a method for rapid integration of wind farm collection lines and wind turbines based on EXCEL, so as to generate collection line data information with the number of wind farms collected as an indicator, effectively improving the efficiency of theoretical analysis of reactive balance of wind farms. The standardized wind farm collection line data generated in the middle can be used in DigSILENT software to improve the construction process of the wind farm collection line simulation module of DIgSILENT software.

[0006] To achieve the above object, the technical solution of the present invention is: a method for rapid integration of wind farm collection lines and wind turbines based on EXCEL, comprising the following steps:

[0007] S1, collect and pre-process wind farm collection line and wind turbine data;

[0008] S2, processing the collected data and generating a standardized wind farm collection line data table;

[0009] S3, determining the node position of each sub-line;

[0010] S4. Determine the number of wind turbines at each node;

[0011] S5. Determine the sub-circuit length and conductor parameters of the collector line corresponding to different numbers of wind turbines;

[0012] S6. Integrate into a collection line data information table with the number of collected wind turbines as the indicator.

[0013] Furthermore, in step S1, the IF(AND), ISTEXT, RIGHT, LEFT, FIND and LEN functions and custom formulas of EXCEL are used to read the head and terminal node data of the wind farm collector line sub-circuit, and the conditional format command is highlighted for the repeated values of the head or terminal data to pre-process the incorrect isolated or looped sub-circuit, and verify the consistency of the actual layout of the collection sub-circuit and the collector line. The FIND and LEN functions of EXCEL and custom formulas are used to determine the sub-circuit with mixed overlap of multiple conductors, and T-junctions are added to generate two or more sub-circuits with only one type of conductor overlapped.

[0014] Further, in step S2, by using the EXCEL functions of IF(AND), CODE, COUNTIF, RIGHT, LEFT, FIND, and LEN, as well as custom formulas, the start and end nodes of the sub-lines of the wind farm collector lines are processed into a standardized unified format with the same number of digits and corresponding representations. This standardized unified format should reflect the collector line loop where the node is located and the node type. When the node is represented by four characters, it is set that the first character on the left represents the loop label of the collector line where the node is located; the second character on the left represents the node type. For example, the start node is set as "S", the T-junction is set as "T", and the fan (or transformer) node is set as "F", etc.; the last two characters represent the node number. For a conventional fan (or transformer) node, by using the LEFT and RIGHT functions of EXCEL and custom formulas, the corresponding node digital code in the basic data of the wind farm collector lines provided by the owner (or design unit) is directly read; for a T-junction (including the T-junctions added in step S1), the node number is automatically generated by using the EXCEL functions of IF and COUNTIF and custom formulas. According to the sub-line description with the processed node names and the preprocessed collector line data in step S1, a standardized wind farm collector line data table including the collector line loop, sub-line serial number, sub-line description, end node, conductor type, and line length is generated.

[0015] The newly generated standardized wind farm collector line data table can be imported into the DIgSILENT software for generating the wind farm collector line simulation module.

[0016] Further, in step S3, according to the standardized wind farm collector line data table generated in step S2, by using the EXCEL functions of IF(AND) and COUNTIF, as well as custom formulas, the appearance times of each node in the collector line sub-lines, the comparison of the start and end times, and the processed node naming format of each collector line are judged to set the start node, end fan node, intermediate fan node, T-junction, etc. of the collector line. For example, the node directly connected to the low-voltage side of the step-up transformer in each collector line loop is defined as the start node and represented by "S"; the fan node that only appears at the end of the sub-line and only appears once in each collector line is defined as the terminal fan node and represented by "M"; the fan node with the total appearance times at the start and end not less than 2 times is defined as the intermediate fan node and represented by "F"; the T-junction is represented by "T". By using the EXCEL functions of IF, VLOOKUP, IFERROR, and ISBLANK, as well as custom formulas, all the non-repeated nodes appearing in each collector line loop are counted.

[0017] Further, in step S4, according to the node position judgment and the connection relationship of each sub-line of the collector line, using the COUNIF, VLOOKUP, IFERROR, MAX, SUMIF, IF(AND), IF(OR), ISBLANK, LEFT, MID, and RIGHT functions and custom formulas of EXCEL, through repeated judgments on the number of times each node appears at the start and end of the sub-line of the collector line loop and the connection relationship of subsequent nodes, the number of fan units carried by each node is finally determined, and a data table of the wind farm collector line characterized by the number of fan units per node is generated. For multiple sub-lines with a T-junction or an intermediate wind power node as the start node, using the VLOOKUP and IF(AND) functions of EXCEL, a judgment column for the number of fan units at the end node of the sub-line with a T-junction or an intermediate wind power node as the start node is set to avoid misjudgment of the number of fan units at the start node of multiple branches.

[0018] Further, in step S5, according to the end node of the sub-line, using the VLOOKUP, IFERROR functions of EXCEL and custom formulas, the collector line length and conductor parameters corresponding to the number of fan units carried by each node are determined from the data table of the wind farm collector line characterized by the number of fan units per node generated in step S4.

[0019] Further, in step S6, according to the collector line length and conductor detailed data corresponding to different numbers of fan units, using the SUMPRODUCT function of EXCEL and custom formulas, they are integrated into a data information table of the collector line with the number of aggregated fan units as the index.

[0020] The integrated data information table of the collector line with the number of aggregated fan units as the index can read in the reactive power loss and charging power analysis formula compiled by EXCEL using the SUMPRODUCT function of EXCEL to perform theoretical calculation and analysis of the reactive power balance of the wind farm.

[0021] The beneficial effect of the present invention is to provide a method for quickly integrating the collector line and fans of a wind farm based on EXCEL. This method and table are based on the logic, statistics, lookup reference, and text functions of EXCEL and custom formulas to achieve the quick integration of the collector line of the wind farm with the number of aggregated fan units as the index. The finally integrated data information table of the collector line with the number of aggregated fan units as the index can read in the reactive power loss and charging power analysis formula compiled by EXCEL to perform theoretical calculation and analysis of the reactive power balance of the wind farm; the intermediate generated standardized data table of the wind farm collector line can be input into the DIgSILENT software to speed up the construction process of the collector line simulation module of the DIgSILENT software and improve the software simulation efficiency. The application of the present invention can effectively improve the efficiency of theoretical analysis and simulation analysis of the reactive power balance of the wind farm, reduce the manual calculation workload, and reduce the risk of errors such as misconnection and duplication caused by manual input or construction. Brief Description of the Drawings

[0022] Figure 1 It is a flowchart of the method for quickly integrating the collector line and the fan of a wind farm based on EXCEL provided by an embodiment of the present invention;

[0023] Figure 2 It is a flowchart of the preprocessing of the sub-line description data of the method for quickly integrating the collector line and the fan of a wind farm based on EXCEL provided by an embodiment of the present invention;

[0024] Figure 3 It is a structural block diagram of the node fan number judgment module of the method for quickly integrating the collector line and the fan of a wind farm based on EXCEL provided by an embodiment of the present invention. Detailed Description of the Invention

[0025] The present invention will be further described in detail below with reference to the drawings and specific embodiments.

[0026] As Figure 1 、 Figure 2 shown, the present invention is a method for quickly integrating the collector line and the fan of a wind farm based on EXCEL, including the following steps:

[0027] S1. Collect and preprocess the data of the collector line and the fan (transformer substation) of the wind farm

[0028] Due to the differences in the scale of the wind farm and the understanding of the wind farm layout by the owners and design units, the data of the wind farm substation and the line provided by them vary greatly. In order to effectively improve the efficiency of subsequent integration work, a data collection list shall be established during the data collection process, and clear regulations shall be made on the required data and basic formats. For example, in the process of collecting the collector line data, the owner (or design unit) is required to provide the basic data of no less than the loop name of the collector line, the sub-line serial number, the sub-line description (head node - end node), the fan situation carried by the sub-line, the conductor model and the line length, as well as the corresponding layout diagram of the collector line, in which the step-up substation (or head node) and the T connection point of each collector line shall be reflected in text form.

[0029]

[0030]

[0031] The collector line of a wind farm consists of multiple collector line circuits, and each collector line circuit consists of multiple sub-lines. In the present invention, the two end nodes of a sub-line are defined as the head node and the tail node, where the head node is the node closer to the low-voltage side of the step-up transformer. The node directly connected to the low-voltage side of the step-up transformer in each collector line is defined as the starting node, the fan node that only appears at the end of the sub-line and only appears once in each collector line is defined as the terminal fan node, the node without a fan (or transformer substation) is defined as the T-junction, and other fan nodes that appear are defined as intermediate fan nodes.

[0032] After the data collection of the wind farm collector line is completed, for each wind farm collector line, using the LEFT, RIGHT, FIND, and LEN functions and custom formulas of EXCEL, the head node and the tail node of the sub-line are collected from the sub-line description.

[0033] After the head and tail node data are collected, using the conditional formatting command of EXCEL's highlight, it is judged whether there are isolated or looped sub-lines, and the consistency between the collected sub-lines and the actual layout of the collector line is verified.

[0034] For each wind farm collector line, using the FIND function and custom formula of EXCEL, it is judged whether the step-up substation or the starting node appears in the head data or the tail data. For the step-up substation or the starting node that appears in the head data, the head and tail node data are maintained; for the step-up substation or the starting node that appears in the tail data, using the LEFT, RIGHT, FIND, and LEN functions and custom formulas of EXCEL, the head and tail node data are replaced.

[0035] For a sub-line composed of N (N≥2) types of conductor models, N - 1 T nodes are added, and using the IF(AND), LEFT, RIGHT, FIND, and LEN functions and custom formulas of EXCEL, new sub-lines are built, and the corresponding sub-line numbers, conductor models, and line length data are improved.

[0036] Head node Tail node Conductor model Line length (m) F11 F10 JL / G1A-240 / 30 380 F12 F11 JL / G1A-240 / 30 620 F13 F12 JL / G1A-240 / 30 947 F14 F13 JL / G1A-240 / 30 423 T-junction F15 JL / G1A-240 / 30 760 T-junction F14 JL / G1A-240 / 30 360 F23 T-junction JL / G1A-240 / 30 377 Step-up substation T-junction YJY23-26 / 35 3X150 800 T-junction F23 JL / G1A-240 / 30 745

[0037] S2. Process the collected data to generate a standardized data table of the wind farm collector line

[0038] According to the wind farm collector line data collected and preprocessed in step S1, using the IF(AND), CODE, COUNTIF, RIGHT, LEFT, FIND, and LEN functions and custom formulas of EXCEL, the two end nodes of the wind farm collector line sub-line are processed into a standardized unified format with the same number of digits and corresponding representations, and this standardized unified format should reflect the collector line circuit where the node is located and the node type.

[0039] According to the scale of wind turbines in the wind farm, the standardized unified format of nodes is set to four characters. When the number of wind turbines collected by a single-circuit collector line is greater than 100, the standardized unified format of all nodes can be set to five characters as needed.

[0040] When nodes are characterized by four characters, it is set that the first character on the left represents the loop label of the collector line where the node is located; the second character on the left represents the node type. For example, the start node is set to "S", the T-junction is set to "T", the fan (or transformer) node is set to "F", etc.; the last two characters represent the node number. For conventional fan (or transformer) nodes, use the LEFT, RIGHT functions and custom formulas in EXCEL to directly read the codes in the basic data of the collector line of the wind farm; for T-junctions (including the added T-junctions in step S1), use the IF, COUNTIF functions and custom formulas in EXCEL to automatically generate node numbers.

[0041] According to the sub-line description with the processed node names and the preprocessed collector line data in step S1, generate a standardized wind farm collector line data table including the collector line loop, sub-line serial number, sub-line description, sub-line end node, conductor model, and line length.

[0042]

[0043] S3. Judge the positions of nodes in each sub-line

[0044] According to the standardized wind farm collector line data table generated in step S2, use the COUNTIF function and custom formulas in EXCEL to judge the number of times each node in a single-circuit collector line appears at both ends of the collector line sub-line, and judge the position of the node in the collector line according to the comparison relationship of the front and back times and the node naming format, and set the start node of the collector line, the end fan node, the middle fan node, the T-junction, etc. The node directly connected to the low-voltage side of the booster transformer in each collector line is defined as the start node, represented by "S"; the fan node that only appears at the end of the sub-line and only appears once in each collector line is defined as the terminal fan node, represented by "M"; the fan node whose total number of appearances at the beginning and end is not less than 2 times is defined as the middle fan node, represented by "F"; the T-junction is represented by "T".

[0045] Use the IF, VLOOKUP, IFERROR, and ISBLANK functions and custom formulas in EXCEL to generate the set of nodes in the collector line loop, that is, all non-repeating nodes that appear in the collector line loop.

[0046]

[0047] S4. As Figure 3 shown, determine the number of fan units for each node

[0048] Based on the set of collector line loop nodes generated in step S3, using the IF(AND), COUNTIF, MID functions and custom formulas in EXCEL, according to the node position judgment and the connection relationship of each sub-line of the collector line, after repeatedly judging the number of times each node appears at the head end and the tail end and the connection relationship of subsequent nodes, finally determine the number of fan units each node drives.

[0049] The judgment process mainly consists of three stages. In the first stage, using the IF(AND), COUNTIF functions and custom formulas in EXCEL, judge whether the node type is the starting node "S". If it is, the number of fan units the node drives is the total number of fan units in the collector line loop; otherwise, go to the second stage.

[0050] In the second stage, using the IF function and custom formulas in EXCEL, judge whether the node type is the terminal fan node "M". If it is, the number of fan units the node drives is 1; otherwise, go to the third stage.

[0051] In the third stage, using the IF(AND), COUNTIF, SUMPRODUCT, VLOOKUP functions and custom formulas in EXCEL to judge that if the node is a "T" node, further judge whether the node is the end node of the sub-branch with the starting node as the head node. If it is, the number of fan units the node drives is the number of fan units the starting node drives; if not, judge again whether the number of end nodes of the sub-line with this node as the head is greater than 1. If it is, the number of fan units the node drives is the sum of the number of fan units of the end nodes with this node as the head node; if not, the number of fan units the node drives is the number of fan units of the end node with this node as the head node.

[0052] In the third stage, using the IF(AND), COUNTIF, SUMPRODUCT, VLOOKUP functions and custom formulas in EXCEL to judge that if the node is not a "T" node, then the node is an intermediate fan node "F", and further judge whether the number of end nodes of the sub-line with this node as the head is greater than 1. If it is, the number of fan units the node drives is the sum of the number of fan units of the end nodes with this node as the head node + 1; if not, the number of fan units the node drives is the number of fan units of the end node with this node as the head node + 1.

[0053] After determining the number of wind turbines connected to each node in the collector line circuit, use the IF(OR), ISBLANK, LEFT, MID, RIGHT, VLOOKUP functions and custom formulas in EXCEL to organize the original sub-line conductor models. That is, determine the conductor erection method, cross-section, and splitting situation through the conductor model, and generate a data table for the wind farm collector line characterized by the number of wind turbines at the node.

[0054] Node Node type Final judgment on the number of node wind turbines Conductor erection method Splitting condition <![CDATA[Cross-section (mm 2 )]]> Length (km) CF11 F 2 Overhead 1 240 0.62 CF12 F 3 Overhead 1 240 0.947 CF13 F 4 Overhead 1 240 0.423 CF14 F 5 Overhead 1 240 0.36 CT10 T 6 Overhead 1 240 0.377 CF15 M 1 Overhead 1 240 0.76 CF23 F 7 Overhead 1 240 0.745 CS10 S 7 —— —— —— —— CT20 T 7 Cable 3 150 0.8 CF10 M 1 Overhead 1 240 0.38

[0055] S5. Determine the lengths of the collector line sub-lines and conductor parameters corresponding to different numbers of wind turbines

[0056] Based on the end nodes of the sub-lines, use the VLOOKUP, IFERROR functions and custom formulas in EXCEL to determine the lengths of the collector lines and conductor parameters corresponding to the number of wind turbines at each node from the data table of the wind farm collector line characterized by the number of wind turbines at the node generated in step S4.

[0057]

[0058]

[0059] S6. Integrate into a data information table of the collector line with the number of aggregated wind turbines as the index.

[0060] Based on the lengths of the collector lines and detailed conductor data corresponding to different numbers of wind turbines, use the SUMPRODUCT function and custom formulas in EXCEL to integrate into a data information table of the collector line with the number of aggregated wind turbines as the index.

[0061]

[0062] The data information table of the collector line with the number of aggregated wind turbines as the index integrated in step S6 can use the SUMPRODUCT function in EXCEL to read the reactive power loss and charging power analysis formulas compiled by EXCEL for theoretical calculation and analysis of the reactive power balance in the wind farm. For the theoretical analysis of the reactive power balance of large wind farms, it can greatly reduce the theoretical analysis and calculation time.

[0063] The standardized data table of the wind farm collector line generated in step S2 can be imported into the DIgSILENT software for building a simulation module of the wind farm collector line and conducting reactive power balance simulation analysis. After importing this data table, it will greatly reduce the software modeling time and effectively reduce the risk of errors such as incorrect connection and duplication caused by manual input.

Claims

1. An Excel-based method for quickly integrating the collector line and wind turbines of a wind farm, characterized in that, The following steps are involved: S1, collect and pre-process wind farm collection line and wind turbine data; S2, processing the collected data and generating a standardized wind farm collection line data table; S3, determining the node position of each sub-line; S4. Determine the number of wind turbines at each node; S5. Determine the sub-circuit length and conductor parameters of the collector line corresponding to different numbers of wind turbines; S6, integrating into a collection line data information table with the number of collected wind turbines as an indicator; The step S1 uses the IF (AND), ISTEXT, RIGHT, LEFT, FIND and LEN functions of EXCEL to read the head end and terminal node data of the wind farm collector line sub-circuit, and pre-processes incorrect isolated or loop sub-circuit by highlighting the repeated values of the head end or terminal data, and verifies the consistency of the actual layout of the collection sub-circuit and the collector line; uses the FIND and LEN functions of EXCEL to determine the sub-circuit with mixed overlap of multiple conductors, and adds T-junctions to generate two or more sub-circuits with only one type of conductor overlap; The step S2 uses the IF (AND), CODE, COUNTIF, RIGHT, LEFT, FIND and LEN functions of EXCEL to process the head end and terminal nodes of the wind farm collector line sub-circuit into a standardized unified format with the same number of digits and corresponding representations. The standardized unified format should reflect the collector line loop and node type where the node is located; wherein, when the node is represented by four characters, the first character on the left is set to represent the collector line loop number where the node is located; the second character on the left represents the node type; the last two characters represent the node number. For conventional wind turbine nodes, the LEFT and RIGHT functions of EXCEL are used to directly read the corresponding node digital code in the wind farm collector line basic data provided by the owner; for T-junctions, including the T-junctions added in step S1, the IF and COUNTIF functions of EXCEL are used to automatically generate node numbers; based on the sub-circuit description of the processed node name and the pre-processed collector line data of step S1, a standardized wind farm collector line data table containing the collector line loop, sub-circuit sequence number, sub-circuit description, terminal node, conductor model and line length is generated; Step S3: Based on the standardized wind farm collector line data table generated in step S2, using the IF (AND) and COUNTIF functions of EXCEL, determine the number of times each node of each collector line appears in the collector line sub-line, the comparison of the first and last numbers, and the node naming format after processing, and set the collector line starting node, the end wind turbine node, the middle wind turbine node and the T-junction; using the IF, VLOOKUP, IFERROR and ISBLANK functions of EXCEL, count all the non-repeated nodes that appear in each collector line loop; In step S4, based on the node position determination and the connection relationships of each sub-line of the collector line, functions such as COUNIF, VLOOKUP, IFERROR, MAX, SUMIF, IF(AND), IF(OR), ISBLANK, LEFT, MID, and RIGHT in EXCEL are used. Through repeated judgments on the number of times each node appears at the start and end of the sub-lines of the collector line loop and the connection relationships of subsequent nodes, the number of wind turbines carried by each node is finally determined, and a data table of the wind farm collector line characterized by the number of wind turbines per node is generated; for multiple sub-lines with a T-junction or an intermediate wind power node as the start node, functions VLOOKUP and IF(AND) in EXCEL are used to set up a judgment column for the number of wind turbines at the end node of the sub-line with a T-junction or an intermediate wind power node as the start node. In step S5, based on the end nodes of the sub-lines, functions VLOOKUP and IFERRO in EXCEL are used to determine the collector line length and conductor parameters corresponding to the number of wind turbines carried by each node from the data table of the wind farm collector line characterized by the number of wind turbines per node generated in step S4. In step S6, based on the collector line lengths and detailed conductor data corresponding to different numbers of wind turbines, function SUMPRODUCT in EXCEL is used to integrate them into a data information table of the collector line with the aggregated number of wind turbines as the index; the integrated data information table can be read into the reactive power loss and charging power analysis formula compiled by EXCEL using function SUMPRODUCT in EXCEL for theoretical calculation and analysis of the reactive power balance of the wind farm.

2. The method for quickly integrating the collector line and the fan of the wind farm based on EXCEL according to claim 1, wherein The description data preprocessing process for the sub-lines of the wind farm collector line is as follows: after the data collection of the wind farm collector line is completed, for each wind farm collector line, functions LEFT, RIGHT, FIND, and LEN in EXCEL are used to collect the start node and end node of the sub-line from the sub-line description. After the start and end node data are collected, the conditional formatting command for highlighting in EXCEL is used to determine whether there are isolated or looped sub-lines and verify the consistency between the collected sub-lines and the actual layout of the collector line. For each wind farm collector line, function FIND in EXCEL is used to determine whether the booster station or the start node appears in the start data or the end data. For the case where the booster station or the start node appears in the start data, the start and end node data are maintained. For the case where the booster station or the start node appears in the end data, functions LEFT, RIGHT, FIND, and LEN in EXCEL are used to replace the start and end node data. For a sub-line composed of N (N≥2) types of conductor models, N - 1 T-nodes are added, and functions IF(AND), LEFT, RIGHT, FIND, and LEN in EXCEL are used to build new sub-lines and complete the corresponding sub-line numbers, conductor models, and line length data.

3. The method for quickly integrating the collector line and the fan of the wind farm based on EXCEL according to claim 1, wherein The judgment process of the number of fan units carried by each node mainly consists of three stages. In the first stage, using the IF(AND) and COUNTIF functions in EXCEL, it is judged whether the node type is the starting node "S". If so, the number of fan units carried by the node is the total number of fan units in the collector line loop; otherwise, it proceeds to the second stage; In the second stage, using the IF function in EXCEL, it is judged whether the node type is the terminal fan node "M". If so, the number of fan units carried by the node is 1; otherwise, it proceeds to the third stage; In the third stage, using the IF(AND), COUNTIF, SUMPRODUCT, and VLOOKUP functions in EXCEL, if the node is a "T" node, it is further judged whether the node is the end node of the sub-branch with the starting node as the head node. If so, the number of fan units carried by the node is the number of fan units carried by the starting node. If not, it is again judged whether the number of end nodes of the sub-line with this node as the head is greater than 1. If so, the number of fan units carried by the node is the sum of the number of fan units carried by the end nodes with this node as the head node. If not, the number of fan units carried by the node is the number of fan units carried by the end node with this node as the head node; Using the IF(AND), COUNTIF, SUMPRODUCT, and VLOOKUP functions in EXCEL, if the node is not a "T" node, then the node is an intermediate fan node "F". It is further judged whether the number of end nodes of the sub-line with this node as the head is greater than 1. If so, the number of fan units carried by the node is the sum of the number of fan units carried by the end nodes with this node as the head node + 1. If not, the number of fan units carried by the node is the number of fan units carried by the end nodes with this node as the head node + 1.

Images