Method for calculating mechanical ventilation and heat dissipation design parameters of power transformation and distribution room based on Excel-VBA

Abstract

The invention discloses a method for calculating mechanical ventilation and heat dissipation design parameters of a power transformation and distribution room based on Excel-VBA. The method comprises the following steps: (1) designing a basic input interface required for calculating the design parameters of a mechanical ventilation and heat dissipation system of the power transformation and distribution room; and (2) designing a calculation area interface for calculating design parameters of the mechanical ventilation and heat dissipation system of the power transformation and distribution room and corresponding codes. According to the method, a calculation model of the mechanical ventilation and heat dissipation design parameters of the power transformation and distribution room is designed by utilizing Excel-VBA, automation of calculation of the mechanical ventilation and heat dissipation design parameters of the power transformation and distribution room is realized, and the working efficiency of calculation of the mechanical ventilation and heat dissipation design parameters of the power transformation and distribution room is improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of building ventilation system design, and particularly relates to a method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA. Background Technique

[0002] During the operation of a substation, electrical equipment (such as transformers, etc.) generates a large amount of heat. If the heat dissipation is not timely, it may cause equipment overheating, insulation aging, or even failure, seriously affecting the power supply reliability. Therefore, the mechanical ventilation system is a key link in the design of substations, and its parameter calculation needs to comprehensively consider factors such as heat generation, ventilation volume, and ambient temperature.

[0003] Currently, the mechanical ventilation design of substations mainly relies on HVAC designers to carry out approximate design through the air change rate method, without comprehensively considering the influence of electrical equipment, ambient temperature, etc. on the mechanical ventilation design. Although CFD simulation software can achieve high-precision simulation, it is complex to operate, has a high learning cost, and requires high computing resources, making it inconvenient for engineering personnel to apply quickly. In addition, existing methods usually rely on manual calculation or step-by-step tools, with low efficiency and prone to human errors, especially lacking flexibility and automation support in scheme comparison or parameter optimization.

[0004] Microsoft Excel is often used by engineers for auxiliary calculation due to its popularity and ease of use, but its built-in functions are difficult to directly handle the complex logic of substation mechanical ventilation design. VBA (Visual Basic for Applications), as a programming extension of Excel, can combine engineering algorithms to achieve automated calculation. However, in the currently public technologies, there is no integrated solution for substation mechanical ventilation parameters based on Excel-VBA. Therefore, developing a calculation method combining Excel-VBA, which can not only retain the convenience of Excel but also achieve accurate and efficient automated calculation of substation mechanical ventilation design parameters, has significant engineering practical value. Summary of the Invention

[0005] The technical problem to be solved by the present invention is: aiming at the problems existing in the background technique, to provide a method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA.

[0006] The technical solution adopted by the present invention is as follows:

[0007] A method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA, characterized by including:

[0008] (1) Design a basic input interface required for calculating the design parameters of the mechanical ventilation and heat dissipation system of the substation;

[0009] (2) Design the calculation area interface and corresponding codes for the design parameters of the mechanical ventilation and heat dissipation system in the substation and distribution room.

[0010] Furthermore, the basic parameter input interface, calculation area interface, and corresponding calculation formulas required for calculating the design parameters of the ventilation and heat dissipation system in the substation and distribution room are independently designed using a single sheet in Excel.

[0011] Furthermore, design the basic parameter input interface required for the design parameters of the ventilation and heat dissipation system in the substation and distribution room in cells A4 - F4 of sheet l; among them,

[0012] Cell A4 represents the floor area of the substation and distribution room, m 2 ;

[0013] Cell B4 represents the net height of the building in the substation and distribution room, m;

[0014] Cell C4 represents the calculated outdoor temperature for summer ventilation, °C;

[0015] Cell D4 represents whether there is a transformer device in the substation and distribution room, including yes / no;

[0016] Cell E4 represents the apparent power of a single transformer, including 30 kVA, 50 kVA, 80 kVA, 100 kVA, 125 kVA, 160 kVA, 200 kVA, 250 kVA, 315 kVA, 400 kVA, 500 kVA, 630 kVA, 800 kVA, 1000 kVA, 1250 kVA, 1600 kVA, 2000 kVA, 2500 kVA;

[0017] Cell F4 represents the number of transformers, units.

[0018] Furthermore, design the indoor exhaust set temperature of the ventilation and heat dissipation system in the substation and distribution room in cell J4 of sheet l, and the set value of J4 satisfies the code:.Range("J4").Value = 45.

[0019] Furthermore, design the calculation area interface and corresponding codes for the design parameters of the ventilation and heat dissipation system in the substation and distribution room in cells G4 - I4 and cells K4 - O4 of sheet l; among them,

[0020] Cell G4 represents the load loss of the transformer, and the code is:

[0021]

[0022]

[0023] Cell H4 represents the outdoor air density, and the code is:.Range("H4").Formula = "=IF(ISBLANK(C4),\"-\",353.05 / (C4+273.15))";

[0024] Cell I4 represents the mechanical ventilation air change rate of the substation and distribution room, and the code is:

[0025]

[0026]

[0027] Cell K4 represents the calculated temperature difference between the inlet and exhaust air of the mechanical ventilation in the substation and distribution room, and the code is:

[0028]

[0029]

[0030] Cell L4 represents the ventilation and heat dissipation method of the substation and distribution room, and the code is:

[0031]

[0032]

[0033] Cell M4 represents the calculated ventilation volume of the mechanical ventilation in the substation and distribution room, and the code is:

[0034]

[0035]

[0036]

[0037] Cell N4 represents the selection of the air-conditioning load in the substation and distribution room, and the code is:

[0038]

[0039]

[0040]

[0041] Cell O4 represents the calculation of the area of the natural air supply opening for the mechanical ventilation in the substation and distribution room, and the code is:

[0042]

[0043]

[0044] Further, for the transformers selected in cells D4 to G4 of Sheet 1 worksheet, their apparent power and transformer load losses, refer to Table 2 of "Minimum Allowable Values of Energy Efficiency and Energy Efficiency Grades for Power Transformers" GB20052-2024, the energy efficiency grade of 10kV dry-type three-phase double-winding non-excitation voltage regulating distribution transformers is Grade 1 amorphous alloy F class.

[0045] Further, the indoor exhaust air set temperature in cells J4 and K4 of Sheet 1 worksheet is 45°C and the calculated temperature difference between inlet and exhaust air. Refer to the requirements for heating, ventilation, and water supply and drainage of substations in Section 3.4.2 of "Electrical Design Handbook for Civil Buildings" (Second Edition) (China Architecture & Building Press).

[0046] Further, for the number of air changes per hour of the mechanical ventilation system in the substation in cell I4 of Sheet 1 worksheet, when there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the number of air changes per hour of the mechanical ventilation system in the substation is 6 times / h; otherwise, the number of air changes per hour of the mechanical ventilation system in the substation is 10 times / h.

[0047] Further, for the ventilation and heat dissipation method in the substation in cell L4 of Sheet 1 worksheet, when there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the ventilation and heat dissipation method in the substation is "split air conditioner + mechanical ventilation"; otherwise, the ventilation and heat dissipation method in the substation is "only mechanical ventilation".

[0048] Further, for the calculated ventilation volume in the substation in cell M4 of Sheet 1 worksheet, when there is a transformer and the outdoor calculated temperature for summer ventilation is less than 28°C, the calculated ventilation volume in the substation = max{floor area of the substation × building height of the substation × number of air changes per hour, 3600 × transformer load loss / [specific heat capacity of air × (indoor exhaust air set temperature - outdoor calculated temperature for summer ventilation)]}; otherwise, the calculated ventilation volume in the substation = floor area of the substation × building height of the substation × number of air changes per hour.

[0049] Further, for the selection of air conditioning load in the substation in cell N4 of Sheet 1 worksheet, when there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the air conditioning load selection is matched according to the transformer load loss; otherwise, the air conditioning is not designed for the ventilation and heat dissipation system in the substation.

[0050] Further, for the calculation of the area of the natural air supply opening for the mechanical ventilation in the substation in cell O4 of Sheet 1 worksheet, the supply air volume is 1 / 2 of the mechanical ventilation volume, and the wind speed of the natural air supply opening is not greater than 3m / s. Description of the Drawings

[0051] Figure 1Flow chart of the method for calculating the mechanical ventilation and heat dissipation design parameters of the substation of the present invention;

[0052] Figure 2 Logic block diagram of the method for calculating the mechanical ventilation and heat dissipation design parameters of the substation of the present invention;

[0053] Figure 3 Initial interface display diagram of the method for the mechanical ventilation and heat dissipation design parameters of the substation in the sheet1 worksheet of the present invention;

[0054] Figure 4 Embodiment interface display diagram of the method for the mechanical ventilation and heat dissipation design parameters of the substation in the sheet1 worksheet of the present invention. Detailed implementation manners

[0055] The following further illustrates the detailed implementation manners of the present invention in conjunction with embodiments and drawings. It should be emphasized that the following description is merely exemplary and not intended to limit the scope and application of the present invention.

[0056] A method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA, the logic block diagram is as Figure 2 shown:

[0057] Step 1: Input corresponding parameters in the parameter input area

[0058] The basic input interface, calculation area interface, and corresponding calculation formulas required for calculating the design parameters of the ventilation and heat dissipation system of the substation are independently designed using a sheet worksheet in Excel; in cells A4 to F4 of the sheet1 worksheet, the basic parameter input interface required for calculating the design parameters of the ventilation and heat dissipation system of the substation is designed; among them,

[0059] Cell A4 represents the building area of the substation, m 2 ;

[0060] Cell B4 represents the net height of the substation building, m;

[0061] Cell C4 represents the outdoor calculated temperature for summer ventilation, °C;

[0062] Cell D4 represents whether there is a transformer device in the substation, including yes / no;

[0063] Cell E4 represents the apparent power of a single transformer, including 30 kVA, 50 kVA, 80 kVA, 100 kVA, 125 kVA, 160 kVA, 200 kVA, 250 kVA, 315 kVA, 400 kVA, 500 kVA, 630 kVA, 800 kVA, 1000 kVA, 1250 kVA, 1600 kVA, 2000 kVA, 2500 kVA;

[0064] Cell F4 represents the number of transformers, in units of sets.

[0065] Step 2: In the calculation area, complete the calculation of the design parameters of the mechanical ventilation and heat dissipation system for the substation according to the corresponding formula codes.

[0066] Design the indoor exhaust set temperature of the ventilation and heat dissipation system for the substation in cell J4 of Sheet 1 worksheet, and the set value of J4 satisfies the code:.Range("J4").Value = 45.

[0067] Design the calculation area interface of the design parameters of the ventilation and heat dissipation system for the substation and the corresponding codes in cells G4 - I4 and cells K4 - O4 of Sheet 1 worksheet; among them,

[0068] Cell G4 represents the load loss of the transformer, and the code is:

[0069]

[0070]

[0071]

[0072] Cell H4 represents the density of outdoor air, and the code is:.Range("H4").Formula = "=IF(ISBLANK(C4),\"-\",353.05 / (C4 + 273.15))";

[0073] Cell I4 represents the mechanical ventilation air change rate of the substation, and the code is:

[0074]

[0075]

[0076] Cell K4 represents the calculated temperature difference between the inlet and exhaust of the mechanical ventilation of the substation, and the code is:

[0077]

[0078]

[0079] Cell L4 represents the ventilation and heat dissipation method of the substation, and the code is:

[0080]

[0081] Cell M4 represents the calculated ventilation volume of the mechanical ventilation of the substation, and the code is:

[0082]

[0083]

[0084]

[0085] Cell N4 represents the selection of the air-conditioning load of the substation, and the code is:

[0086]

[0087]

[0088]

[0089]

[0090] Cell O4 represents the calculation of the natural air supply opening area of the mechanical ventilation of the substation, and the code is:

[0091]

[0092] Furthermore, for the transformer selected in cells D4 - G4 of sheet l worksheet, its apparent power and transformer load loss, refer to Table 2 of "Minimum Allowable Values of Energy Efficiency and Energy Efficiency Grades for Power Transformers" GB20052 - 2024 for the energy efficiency grade of 10kV dry-type three-phase double-winding non-excitation regulating distribution transformers, Grade 1 amorphous alloy F.

[0093] Furthermore, for the indoor exhaust set temperature of 45°C and the calculated temperature difference between inlet and exhaust in cells J4 and K4 of sheet l worksheet, refer to the requirements for heating, ventilation, and water supply and drainage of substations in Section 3.4.2 of "Electrical Design Handbook for Civil Buildings" (Second Edition) (China Architecture & Building Press).

[0094] Furthermore, for the air change rate of the mechanical ventilation system of the substation in cell I4 of sheet l worksheet, when there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the air change rate of the mechanical ventilation system of the substation is 6 times / h; otherwise, the air change rate of the mechanical ventilation system of the substation is 10 times / h.

[0095] Further, in cell L4 of worksheet Sheet1, for the ventilation and heat dissipation method of the substation and distribution room, when there is a transformer and the calculated outdoor ventilation temperature in summer is greater than or equal to 28°C, the ventilation and heat dissipation method of the substation and distribution room is "split air conditioner + mechanical ventilation"; otherwise, the ventilation and heat dissipation method of the substation and distribution room is "only mechanical ventilation".

[0096] Further, in cell M4 of worksheet Sheet1, for the calculated ventilation volume of the substation and distribution room, when there is a transformer and the calculated outdoor ventilation temperature in summer is less than 28°C, the calculated ventilation volume of the substation and distribution room = max{floor area of the substation and distribution room × building height of the substation and distribution room × air change rate, 3600 × load loss of the transformer / [specific heat capacity of air × (set indoor exhaust temperature - calculated outdoor ventilation temperature in summer)]}; otherwise, the calculated ventilation volume of the substation and distribution room = floor area of the substation and distribution room × building height of the substation and distribution room × air change rate.

[0097] Further, in cell N4 of worksheet Sheet1, for the selection of air-conditioning load of the substation and distribution room, when there is a transformer and the calculated outdoor ventilation temperature in summer is greater than or equal to 28°C, the air-conditioning load selection is matched according to the load loss of the transformer; otherwise, the air-conditioning is not designed for the ventilation and heat dissipation system of the substation and distribution room.

[0098] Further, in cell O4 of worksheet Sheet1, for the calculation of the area of the natural air supply opening for mechanical ventilation of the substation and distribution room, the air supply volume is 1 / 2 of the mechanical ventilation volume, and the wind speed of the natural air supply opening is not greater than 3 m / s.

[0099] Example:

[0100] A residential project is located in Changzhou City, Jiangsu Province, and the calculated outdoor ventilation temperature in summer is 31.3°C. The floor area of the substation and distribution room is 409.16 m 2 ; the building height is 5.65 m. Two 630 kVA dry-type three-phase double-winding non-excitation regulating distribution transformers are installed in the substation and distribution room.

[0101] Figure 3 This is the initial interface display diagram of the design parameter method for the mechanical ventilation and heat dissipation of the substation and distribution room in worksheet Sheet1 of the present invention. The steps of a method for calculating the design parameters of the mechanical ventilation and heat dissipation of the substation and distribution room based on Excel-VBA in this example are briefly described as follows:

[0102] Step 1: Input the corresponding parameters in the parameter input area. Input the floor area of the substation and distribution room, building height, calculated outdoor temperature in summer, and transformer status into the basic parameter input interface of Sheet1.

[0103] Step 2: Complete the calculation of the design parameters of the mechanical ventilation and heat dissipation system of the substation and distribution room according to the corresponding formula codes in the calculation area. The specific calculation results are as Figure 4Example interface display diagram of the method for calculating the mechanical ventilation and heat dissipation design parameters of the sheet1 worksheet of the present invention.

[0104] From the steps and results of the method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA described in the present invention, it can be seen that the present invention realizes the rapid calculation of the mechanical ventilation and heat dissipation design parameters of the substation by simply inputting the building, environment and equipment information of the substation through the establishment of a calculation table for the mechanical ventilation and heat dissipation design parameters of the substation based on Excel-VBA, thus providing convenience for the ventilation design of the substation, which is the purpose that the present invention hopes to achieve.

[0105] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit them; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for calculating the design parameters of mechanical ventilation and heat dissipation in a substation and distribution room based on Excel-VBA, characterized in that, Including: (1) The basic input interface for designing and calculating the design parameters of the mechanical ventilation and heat dissipation system of the substation; (2) The calculation area interface for designing and calculating the design parameters of the mechanical ventilation and heat dissipation system of the substation and the corresponding code.

2. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 1, wherein, The basic parameter input interface, calculation area interface and corresponding calculation formula for calculating the design parameters of the ventilation and heat dissipation system of the substation are independently designed using a sheet worksheet in Excel.

3. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 2, characterized in that, Design the basic parameter input interface for the design parameters of the ventilation and heat dissipation system of the substation in cells A4 - F4 of the sheet l worksheet; among them, Cell A4 represents the floor area of the substation, m 2 ; Cell B4 represents the net height of the substation building, m; Cell C4 represents the calculated outdoor temperature for summer ventilation, °C; Cell D4 represents whether there is a transformer equipment in the substation, including yes / no; Cell E4 represents the apparent power of a single transformer, including 30kVA, 50kVA, 80kVA, 100kVA, 125kVA, 160kVA, 200kVA, 250kVA, 315kVA, 400kVA, 500kVA, 630kVA, 800kVA, 1000kVA, 1250kVA, 1600kVA, 2000kVA, 2500kVA; Cell F4 represents the number of transformers, units.

4. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 2, wherein Design the indoor exhaust set temperature of the ventilation and heat dissipation system of the substation in cell J4 of the sheet l worksheet, and the set value of J4 satisfies the code:.Range("J4").Value = 45.

5. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 2, wherein Design the calculation area interface for the design parameters of the ventilation and heat dissipation system of the substation and the corresponding code in cells G4 - I4 and cells K4 - O4 of the sheet l worksheet; among them, Cell G4 represents the load loss of the transformer, and the code is: Cell H4 represents the outdoor air density, and the code is:.Range("H4").Formula = "=IF(ISBLANK(C4),\"-\",353.05 / (C4 + 273.15))"; Cell I4 represents the mechanical ventilation air change rate of the substation, and the code is: Cell K4 represents the calculated temperature difference between the inlet and exhaust of the mechanical ventilation of the substation, and the code is: Cell L4 represents the ventilation and heat dissipation method of the substation, and the code is: Cell M4 represents the calculated ventilation volume of the mechanical ventilation of the substation, and the code is: Cell N4 represents the selection of the air conditioning load of the substation, and the code is: Cell O4 represents the calculation of the area of the natural air supply opening of the mechanical ventilation of the substation, and the code is:

6. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claims 3 and 5, characterized in that, The selected transformer, its apparent power, and the load loss of the transformer in cells D4 - G4 of the sheet l worksheet refer to Table 2 of "Minimum Allowable Values of Energy Efficiency and Energy Efficiency Grades for Power Transformers" GB20052 - 2024 for 10kV dry - type three - phase double - winding non - exciting voltage regulating distribution transformers, energy efficiency grade 1, amorphous alloy F - class.

7. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claims 4 and 5, characterized in that, In cells J4 and K4 of Sheet 1 worksheet, the indoor exhaust air set temperature is 45°C and the calculated temperature difference between inlet and exhaust air. Refer to the requirements for heating, ventilation, and water supply and drainage in the substation in Section 3.4.2 of the "Electrical Design Manual for Civil Buildings" (Second Edition) (China Architecture & Building Press).

8. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 5, wherein In cell I4 of Sheet 1 worksheet, the air change rate of the mechanical ventilation system in the substation. When there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the air change rate of the mechanical ventilation system in the substation is 6 times / h; otherwise, the air change rate of the mechanical ventilation system in the substation is 10 times / h.

9. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 5, characterized in that, In cell L4 of Sheet 1 worksheet, the ventilation and heat dissipation method in the substation. When there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the ventilation and heat dissipation method in the substation is "split air conditioner + mechanical ventilation"; otherwise, the ventilation and heat dissipation method in the substation is "only mechanical ventilation".

10. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 5, wherein In cell M4 of Sheet 1 worksheet, the calculated ventilation volume of the substation. When there is a transformer and the outdoor calculated temperature for summer ventilation is less than 28°C, the calculated ventilation volume of the substation = max{floor area of the substation × building height of the substation × air change rate, 3600 × transformer load loss / [specific heat capacity of air × (indoor exhaust air set temperature - outdoor calculated temperature for summer ventilation)]}; Otherwise, the calculated ventilation volume of the substation = floor area of the substation × building height of the substation × air change rate.

11. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 5, characterized in that, In cell N4 of Sheet 1 worksheet, the selection of air conditioning load in the substation. When there is a transformer and the outdoor calculated temperature for summer ventilation is greater than or equal to 28°C, the air conditioning load selection is matched according to the transformer load loss; otherwise, the air conditioning is not designed for the ventilation and heat dissipation system in the substation.

12. The method for calculating the mechanical ventilation and heat dissipation design parameters of a substation based on Excel-VBA according to claim 5, wherein In cell O4 of Sheet 1 worksheet, the calculation of the area of the natural air supply opening for the mechanical ventilation in the substation. The air supply volume is 1 / 2 of the mechanical ventilation volume, and the wind speed of the natural air supply opening is not greater than 3 m / s.

Images