System and method for calculating total loss of wind pressure of wind system based on Office

Abstract

The invention discloses an Office-based wind system total wind pressure loss calculation system and calculation method, and the system comprises an AIR SIDE PRESSURE LOSS module which is used for inputting specific information of a wind system and selecting accessories, a TEMPLATE module which is used for storing and editing a wind pressure loss calculation formula, and a REFERENCE module which comprises calculation rules and parameters based on a CIBSE GUIDE C standard. The system has the beneficial effects that various accessories included in the wind system accessory module and various numerical values in the wind system pressure loss value calculation table module are recorded and stored through the Office, and the total wind pressure loss of the wind system can be quickly compared and calculated by utilizing a calculation system and an encryption module of the Office when the system needs to be used; meanwhile, the accessories and the numerical information can be calculated, the problems that manual calculation is low in efficiency and application program development is long in period and high in cost are effectively solved, and the method has the advantages of being high in precision, short in period, low in cost and easy to master.

Description

Technical Field

[0001] This invention relates to the field of total pressure loss calculation technology for ventilation systems, specifically to an Office-based system and method for calculating total pressure loss in ventilation systems. Background Technology

[0002] Existing methods for calculating total air pressure loss in ventilation systems are mainly divided into two types: traditional manual calculation and the application of HVAC design calculator software.

[0003] The existing traditional manual calculation method involves substituting relevant data into formulas in a standardized document for calculation. This method suffers from problems such as complex calculation formulas, large amount of calculation, easy errors, and low efficiency.

[0004] Existing HVAC design calculator software refers to HVAC design calculators that integrate standard documents and formulas to form a calculator program. Calculations are performed by inputting parameters. This approach has several drawbacks: it requires program development, has a long development cycle, high costs, high technical barriers, and is not easy for designers to master. Moreover, most of these calculators are currently geared towards the mainland market and integrate mainland standards, which cannot meet the different standards and requirements of Hong Kong and Macau. Summary of the Invention

[0005] The purpose of this invention is to overcome the deficiencies of the prior art and provide an Office-based system and method for calculating the total wind pressure loss of a wind system, so as to solve the problems mentioned in the background art.

[0006] The technical solution to achieve the above objectives is: an Office-based system and method for calculating total wind pressure loss in a wind system, including an AIR SIDE PRESSURE LOSS module for inputting specific information about the wind system and selecting accessories;

[0007] The TEMPLATE module is used to store and edit wind pressure loss calculation formulas;

[0008] The REFERENCE module contains calculation rules and parameters based on the CIBSE GUIDE C standard;

[0009] The AIR SIDE PRESSURE LOSS includes modules for calculating air system accessories and air system pressure loss values.

[0010] The wind system accessories module includes various accessories needed in the wind system pressure calculation process.

[0011] Various accessories include ductwork - ductwork of different sizes and materials, including round and square ductwork.

[0012] Elbows are fittings used to change the direction of air ducts, such as right-angle elbows and 45-degree elbows. Elbows of different angles have different effects on pressure loss.

[0013] Tees and crosses are pipe fittings used for branching and merging; the pressure loss varies depending on the angle and size of the branch.

[0014] Control valves – such as air volume control valves – are used to regulate the air flow and pressure within a system;

[0015] In low-speed systems, the air flow rate is 200 m³ / s. 3 / h-2000m 3 / h, working pressure: from 50Pa to 300Pa;

[0016] Air flow rate in medium-speed system: 1500 m³ / h 3 / h-6000m 3 / h, working pressure: 300Pa to 800Pa;

[0017] Air flow rate in high-speed system: 5000m³ 3 / h-15000m 3 / h or more, working pressure: 800Pa to 2000Pa or more.

[0018] Transition components – such as reducing pipes and expanding pipes.

[0019] A silencer is a component used to reduce system noise, but it also causes some pressure loss.

[0020] Filters are devices used to remove particulate matter from the air. Pressure loss varies depending on the filtration efficiency and type.

[0021] The fan inlet and outlet – the fan itself and its connection method – also affect the pressure loss of the system.

[0022] The air system pressure loss calculation module includes input fields for actual project drawings, input fields for specific air system information used for calculation, input fields for parameter information of air system components, and output fields for calculated pressure loss values ​​of air system components and total air system pressure loss values.

[0023] Both the TEMPLATE and REFERENCE modules have table protection, which requires a password to edit. After editing, the password must be entered again to enable protection.

[0024] A rapid method for calculating the total wind pressure loss of a wind system based on Office software includes the following steps:

[0025] S1: Open the Office software system on your computer and open AIR SIDE PRESSURE LOSSCALCULATION BASE ON CIBSE GUIDE.xlsm;

[0026] S2: Enter the “AIR SIDE PRESSURE LOSS” interface. First, in the “Air System Pressure Loss Value Calculation Table” area, enter the specific information of the air system to be calculated based on the actual project drawing information in the yellow mark of the table header.

[0027] S3: In the "Wind System Accessories" area, based on the specific form of the wind system for which wind pressure needs to be calculated, click on the required accessories in sequence from the negative pressure end to the positive pressure end of the wind system. The corresponding pressure loss calculation rows will then be displayed in the "Wind System Pressure Loss Value Calculation Table" area.

[0028] S4: In the "Pressure Loss Calculation Table of Air System" area, enter the parameter information of the accessories according to the actual project drawing information in the yellow marked area of ​​the table, and the pressure loss calculation value of each accessory and the total pressure loss value of the air system will be automatically obtained;

[0029] S5: After obtaining the calculated pressure loss value of each component and the total pressure loss value of the air system, the data is automatically uploaded to the cloud for storage and backup, which is used for subsequent data comparison of the total loss range value in the air pressure system;

[0030] S6: The "Calculation Table of Pressure Loss Values ​​in Wind System" area can be exported and printed;

[0031] S7: If you need to edit the LossCoeficient marked in blue in the calculation formula of the air system components based on manufacturer data or experience values, or directly assign a new Fitting Pressure, you can enter the "TEMPLATE" interface, click "Review" in the toolbar, then "Unprotect Sheet", and enter the password "TEMPLATE" to make the changes; after making the changes, you need to click "Review" in the toolbar, then "Protect Workbook", and enter the password "TEMPLATE" to create table protection;

[0032] S8: To edit the calculation rules and parameters related to CIBSE GUIDE C in the calculation formulas for wind system components, you can enter the "REFERENCE" interface, click "Review" in the toolbar, then "Unprotect Sheet," and enter the password "REFERENCE" to make modifications. After modification, you need to click "Review" in the toolbar, then "Protect Workbook," and enter the password "REFERENCE" to create table protection.

[0033] The beneficial effects of this invention are:

[0034] This invention primarily uses Office to record and store various components included in the wind system component module and various values ​​in the wind system pressure loss value calculation table module. When needed, the calculation system and encryption module of Office can be used to quickly compare and calculate the total wind pressure loss of the wind system. At the same time, it can also perform calculations between component and numerical information, effectively solving the problems of low efficiency of manual calculation and long development cycle and high cost of application. It has the advantages of high accuracy, short cycle and low cost and easy to master.

[0035] Compared with traditional manual calculation, this invention has the advantages of being fast, flexible, easy to operate, and highly accurate. Compared with HVAC design calculator software, this invention has no technical threshold, is easy to master, does not require excessive development, has a small time cycle cost, and is based on the CIBSE GUIDE C standard, which can meet the needs of building engineering projects in Hong Kong and Macao. Attached Figure Description

[0036] Figure 1 This is a schematic diagram of the system structure of the present invention;

[0037] Figure 2 This is a schematic diagram of the wind pressure system calculation module of the present invention. Detailed Implementation

[0038] The invention will now be further described with reference to the accompanying drawings.

[0039] Example: Figure 1-2 As shown, an Office-based system and method for calculating total wind pressure loss in a wind system includes the AIR SIDE PRESSURE LOSS, TEMPLATE, and REFERENCE modules.

[0040] A system and method for calculating total wind pressure loss in a wind system based on Office, using CIBSE GUIDE C, integrating calculation rules and related parameters;

[0041] AIR SIDE PRESSURE LOSS includes modules for calculating air system accessories and air system pressure loss values.

[0042] The wind system accessories module includes various accessories needed in the wind system pressure calculation process;

[0043] Various accessories include ductwork - ductwork of different sizes and materials, including round and square ductwork.

[0044] Elbows are fittings used to change the direction of air ducts, such as right-angle elbows and 45-degree elbows. Elbows of different angles have different effects on pressure loss.

[0045] Tees and crosses are pipe fittings used for branching and merging; the pressure loss varies depending on the angle and size of the branch.

[0046] Control valves – such as air volume control valves – are used to regulate the air flow and pressure within a system;

[0047] Specifically, in low-speed systems, the airflow rate is 200 m³ / s. 3 / h-2000m 3 / h, working pressure: 50Pa to 300Pa;

[0048] Air flow rate in medium-speed system: 1500 m³ / h 3 / h-6000m 3 / h, working pressure: 300Pa to 800Pa;

[0049] Air flow rate in high-speed system: 5000m³ 3 / h-15000m 3 / h or more, working pressure: 800Pa to 2000Pa or more.

[0050] Transition components – such as reducing pipes and expanding pipes.

[0051] A silencer is a component used to reduce system noise, but it also causes some pressure loss.

[0052] Filters are devices used to remove particulate matter from the air. Pressure loss varies depending on the filtration efficiency and type.

[0053] The fan inlet and outlet – the fan itself and its connection method – also affect the pressure loss of the system.

[0054] The air system pressure loss calculation module includes input fields for actual project drawing information, input fields for specific air system information used for calculation, input fields for parameter information of air system components, and output fields for calculated pressure loss values ​​of air system components and total pressure loss values ​​of the air system.

[0055] The TEMPLATE module is used to store and edit the formulas for calculating wind pressure loss in wind system components;

[0056] Total pressure loss formula:

[0057] ΔP_total=SUM(ΔP_components+ΔP_ducts)

[0058] Here, ΔP_total is the total pressure loss of the system, and ΔP_components and ΔP_ducts are the pressure losses of each component and duct in the system, respectively.

[0059] Pressure loss of components:

[0060] ΔP_comp=ξ*(ρ*c 2 / 2)

[0061] Where ξ is the loss coefficient, which is dimensionless; ρ is the air density, kg / m³. 3 c is the flow velocity, in m / s.

[0062] Frictional losses in air ducts:

[0063] ΔP_fr ic=λ(L / D)*(ρ*c 2 / 2)

[0064] Where λ is the friction factor, which is dimensionless; L is the duct length, in meters; and D is the duct diameter, in meters.

[0065] Local resistance formula (used for bends, sudden expansions, sudden contractions, etc.):

[0066] ΔP_loca l=K*(ρ*c 2 / 2)

[0067] Where K is the local drag coefficient, which is dimensionless.

[0068] The formula for calculating wind pressure loss of wind system components can be adjusted according to actual conditions, or the Loss Coefficient can be adjusted based on manufacturer data and experience, or Fitting Pressure can be directly assigned.

[0069] The REFERENCE module is used to store some key parameters based on the calculation rules in the CIBSE GUIDE C standard.

[0070] The TEMPLATE and REFERENCE modules create table protection, which requires a password to modify. After modification, you need to click "Review" - "Protect Workbook" in the toolbar and enter the password to create table protection.

[0071] A rapid method for calculating the total wind pressure loss of a wind system based on Office software includes the following steps:

[0072] S1: Open the Office software system on your computer and open AIR SIDE PRESSURE LOSSCALCULATION BASE ON CIBSE GUIDE.xlsm;

[0073] S2: Enter the “AIR SIDE PRESSURE LOSS” interface. First, in the “Air System Pressure Loss Value Calculation Table” area, enter the specific information of the air system to be calculated based on the actual project drawing information in the yellow mark of the table header.

[0074] S3: In the "Wind System Accessories" area, based on the specific form of the wind system for which wind pressure needs to be calculated, click on the required accessories in sequence from the negative pressure end to the positive pressure end of the wind system. The corresponding pressure loss calculation rows will then be displayed in the "Wind System Pressure Loss Value Calculation Table" area.

[0075] S4: In the "Pressure Loss Calculation Table of Air System" area, enter the parameter information of the accessories according to the actual project drawing information in the yellow marked area of ​​the table, and the pressure loss calculation value of each accessory and the total pressure loss value of the air system will be automatically obtained;

[0076] S5: After obtaining the calculated pressure loss value of each component and the total pressure loss value of the air system, the data is automatically uploaded to the cloud for storage and backup, which is used for subsequent data comparison of the total loss range value in the air pressure system;

[0077] S6: The "Calculation Table of Pressure Loss Values ​​in Wind System" area can be exported and printed;

[0078] S7: If you need to edit the LossCoeficient marked in blue in the calculation formula of the air system components based on manufacturer data or experience values, or directly assign a new Fitting Pressure, you can enter the "TEMPLATE" interface, click "Review" in the toolbar, then "Unprotect Sheet", and enter the password "TEMPLATE" to make the changes; after making the changes, you need to click "Review" in the toolbar, then "Protect Workbook", and enter the password "TEMPLATE" to create table protection;

[0079] S8: To edit the calculation rules and parameters related to CIBSE GUIDE C in the calculation formulas for wind system components, you can enter the "REFERENCE" interface, click "Review" in the toolbar, then "Unprotect Sheet," and enter the password "REFERENCE" to make modifications. After modification, you need to click "Review" in the toolbar, then "Protect Workbook," and enter the password "REFERENCE" to create table protection.

[0080] The above embodiments are for illustrative purposes only and are not intended to limit the invention. Those skilled in the art can make various changes or modifications without departing from the spirit and scope of the invention. Therefore, all equivalent technical solutions should also fall within the scope of the invention and should be defined by the claims.

Claims

1. An office-based wind system wind pressure total loss calculation system and calculation method, characterized by, The AIR SIDE PRESSURE LOSS module is used for inputting the specific information of the air system and selecting the fittings. The TEMPLATE module is used for storing and editing the formula for calculating the pressure loss. The REFERENCE module contains the calculation rules and parameters based on the CIBSE GUIDE C standard. The AIR SIDE PRESSURE LOSS module contains the air system fittings and the air system pressure loss value calculation table module.

2. The system and method for calculating total pressure loss of an office-based wind system according to claim 1, wherein, The air system fittings module contains various fittings needed in the air system pressure calculation process.

3. The system and method of claim 1, wherein, The air system pressure loss value calculation table module contains the actual project drawing information input item, the air system specific information input item for calculation, the parameter information input item of the air system fittings, and the pressure loss calculation value of the air system fittings and the total pressure loss value output item of the air system.

4. The system and method of claim 1, wherein, Both the TEMPLATE and REFERENCE modules are provided with table protection, and a password must be input for editing, and after editing, the password must be input again to enable the protection.

5. The quick calculation method of total loss of wind pressure of an office-based wind system according to any one of claims 1-4, wherein, The method comprises the following steps: S1: open the Office software system in the computer and open the AIR SIDE PRESSURE LOSS CALCULATION BASE ON CIBSE GUIDE. xlsm; S2: enter the "AIR SIDE PRESSURE LOSS" interface, and first input the specific information of the air system to be calculated according to the actual project drawing information at the yellow mark in the table header of the "air system pressure loss value calculation table" area; S3: in the "air system fittings" area, according to the specific form of the air system for which the pressure needs to be calculated, from the negative pressure end to the positive pressure end, click the required fittings in turn, and the corresponding pressure loss calculation row in the "air system pressure loss value calculation table" area can be displayed in turn; S4: input the parameter information of the fittings according to the actual project drawing information at the yellow mark in the table in the "air system pressure loss value calculation table" area, and the pressure loss calculation value of each fitting and the total pressure loss value of the air system can be automatically obtained; S5: after obtaining the pressure loss calculation value of each fitting and the total pressure loss value of the air system, the data is automatically uploaded to the cloud for storage backup, which is used for subsequent data comparison of the total loss range value in the air pressure system; S6: the "air system pressure loss value calculation table" area can be exported and printed; S7: if it is necessary to edit the LossCoeficient at the blue mark in the air system fitting calculation formula according to the manufacturer's data or experience value or directly assign a new Fitting Pressure, the "TEMPLATE" interface can be entered, the "Review" in the toolbar "-- Unprotect Workbook" can be clicked, and the password "TEMPLATE" can be input to modify; after modification, the "Review" in the toolbar "-- Protect Workbook" can be clicked, and the password "TEMPLATE" can be input to form the table protection. S8: need to edit the wind system accessories calculation formula about CIBSE GUIDE C calculation rules and parameters can enter the "REFERENCE" interface, click the toolbar "review" -- "revoke worksheet protection", and enter the password "REFERENCE", can be modified; after modification, click the toolbar "review" -- "protect the workbook", and enter the password "REFERENCE", can form a table protection.

Images