Method for calculating safe distance during explosion and disintegration of solid engine

By setting the number of iterations and editing macros in the Excel workbook, the safe distance when the solid rocket engine explodes and disintegrates is automatically calculated, which solves the problems of complex calculations and insufficient accuracy in the prior art, and achieves a fast and accurate safety distance assessment.

CN119066293APending Publication Date: 2024-12-03CHINESE PEOPLES LIBERATION ARMY UNIT 63620 +1
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411044815.X
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-08-01
Publication Date
2024-12-03

AI Technical Summary

Technical Problem

In the prior art, the safety distance calculation process of solid rocket engines when they explode and disintegrate is complicated and cumbersome, the labor investment cost is high, and the accuracy of the calculation results cannot be guaranteed, and there is a lack of automated solutions.

Method used

By setting the number of iterations in the Excel workbook, editing the macro and binding the trigger button, automatic calculation of safe distances under different hazard determination standards can be achieved, simplifying the process and improving calculation accuracy and speed.

Benefits of technology

It realizes accurate calculation of the safety distance of shock wave and thermal radiation when the solid engine explodes and disintegrates, automates the calculation process, saves human resources, and improves the adaptability of calculation speed and results.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119066293A_ABST
    Figure CN119066293A_ABST
Patent Text Reader

Abstract

The invention provides a method for calculating a safe distance during explosion and disintegration of a solid engine. The method comprises the following steps: setting the number of iterations of an Excel workbook according to the precision and convergence of a calculation result; setting cell positions, default values and relationships of the input quantity, the intermediate quantity and the output quantity based on a calculation formula of the safe distance; setting cell positions for recording safety distances under different hazard judgment standard values; the editing macro is used for calculating and recording safety distances under different hazard judgment standard values; and binding a trigger button and the edited macro, setting a test value of the input quantity, and clicking the trigger button for calculation to obtain safety distances corresponding to the test value under different hazard judgment standards. The invention provides a method for calculating a safe distance during explosion and disintegration of a solid engine. The method is used for solving the problems that in the prior art, the process is complex and tedious, and the human input cost is high.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention relates to the technical field of solid rocket engines, and in particular to a method for calculating a safe distance when a solid engine explodes and disintegrates. Background Art

[0002] Solid rocket engines have the characteristics of simple structure, reliable operation, simple maintenance, and rapid response, and are widely used in the field of space launch vehicles and missiles. During the production, development, ground test or flight test of solid engines, some factors may cause the engine to explode and disintegrate. The harmful accidents that occur are mainly manifested in specific forms such as explosions, high-temperature jets and fireballs. The air shock waves, high-speed fragments, and high-temperature flames generated will cause great harm to the environment, equipment, and personnel. Therefore, before the engine ground test and the launch of the carrier, it is necessary to evaluate and formulate the safe distance in the event of an accidental explosion of the solid engine.

[0003] Some research has been conducted at home and abroad on the two hazards of engine explosion, shock wave and thermal radiation. However, there is an extreme lack of calculation modules and tools for the safe distance of the two under different hazard judgment standards. The existing calculation methods have the following shortcomings:

[0004] In the calculation process, the safety distance and the hazard determination standard value (i.e., overpressure value and heat flux value) are both uncertain variables. Therefore, the existing mainstream calculation method is the enumeration method, that is, by continuously assigning safety distances to obtain different hazard determination standard values, and then manually finding the safety distance value corresponding to the hazard determination standard value that meets the standard. The process is complicated and the manpower investment cost is high.

[0005] The accuracy of the hazard judgment standard value and safety distance value obtained by the enumeration method cannot be guaranteed, so interpolation and other methods are required to ensure the precision and accuracy of the calculation results, making the calculation process more cumbersome. Summary of the invention

[0006] The invention provides a method for calculating a safe distance when a solid motor explodes and disintegrates, so as to solve the problems existing in the prior art such as complicated and cumbersome process and high manpower input cost.

[0007] The present invention provides a method for calculating a safe distance when a solid motor explodes and disintegrates, comprising:

[0008] Set the number of iterations of the Excel workbook according to the accuracy and convergence of the calculation results;

[0009] Set the cell positions, default values ​​and relationships of input quantities, intermediate quantities and output quantities based on the calculation formula of the safety distance;

[0010] Set the cell location for recording the safety distance under different hazard judgment standard values;

[0011] The editing macro is used to calculate and record the safety distance under the different hazard determination standard values;

[0012] Bind the trigger button and the edited macro, set the test value of the input quantity, click the trigger button to calculate, and obtain the safety distance under different hazard judgment standards corresponding to the test value.

[0013] In the above scheme, by editing the macro, the shock wave safety distance and thermal radiation safety distance of solid motors of different specifications during explosion and disintegration can be accurately calculated, and the safety distance under different hazard judgment standard values ​​can be recorded, thereby realizing process automation and saving a lot of human resources. At the same time, the scheme also has the advantages of stable operation, fast calculation speed, strong adaptability of results and low computing power requirements.

[0014] Optionally, the calculation formula of the safety distance is:

[0015]

[0016] Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula of the equivalent distance is:

[0017]

[0018] Where: R is the safety distance, the unit is m, W is the TNT equivalent, the unit is kg, and the calculation formula of the TNT equivalent is:

[0019]

[0020] Where: p is the gas pressure in the container, in MPa, V is the volume of the container, in m 3 , k is the gas adiabatic index, Q is the equivalent energy, the unit is kJ.

[0021] Optionally, the calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including:

[0022] The input quantities are the gas pressure in the container, the volume of the container, the gas adiabatic index and the equivalent energy, and the cell positions and default values ​​of the input quantities are set;

[0023] The intermediate amount is the TNT equivalent, a cell position of the intermediate amount is set, and a relationship between the intermediate amount and the input amount is set based on a calculation formula of the TNT equivalent;

[0024] The output is the overpressure, the equivalent distance and the safety distance. The cell position of the output and the default value of the safety distance are set. The relationship between the overpressure and the equivalent distance is set based on the calculation formula of the safety distance. The relationship between the equivalent distance, the TNT equivalent and the safety distance is set based on the calculation formula of the equivalent distance.

[0025] Optionally, the calculation formula of the safety distance is:

[0026]

[0027] Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula of the equivalent distance is:

[0028]

[0029] Where: R is the safety distance, the unit is m, W is the TNT equivalent, the unit is kg, and the calculation formula of the TNT equivalent is:

[0030] W=m*l

[0031] Where: m is the mass of the propellant in kg, and l is the equivalence coefficient.

[0032] Optionally, the calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including:

[0033] The input quantity is the propellant mass and the equivalence coefficient, and the cell position and default value of the input quantity are set;

[0034] The intermediate amount is the TNT equivalent, a cell position of the intermediate amount is set, and a relationship between the intermediate amount and the input amount is set based on a calculation formula of the TNT equivalent;

[0035] The output is the overpressure, the equivalent distance and the safety distance. The cell position of the output and the default value of the safety distance are set. The relationship between the overpressure and the equivalent distance is set based on the calculation formula of the safety distance. The relationship between the equivalent distance, the TNT equivalent and the safety distance is set based on the calculation formula of the equivalent distance.

[0036] Optionally, the calculation formula of the safety distance is:

[0037]

[0038] Where: q is the heat flux, in W / cm 2, m is the mass of the propellant, in kg, T is the combustion temperature, D is the diameter of the fireball, in m, R is the safety distance, in m, and the calculation formula for the fireball diameter is:

[0039] D=3.86m 0.320 .

[0040] Optionally, the calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including:

[0041] The input quantity is the propellant mass and the combustion temperature, and the cell position and default value of the input quantity are set;

[0042] The intermediate quantity is the fireball diameter, a cell position of the intermediate quantity is set, and a relationship between the intermediate quantity and the propellant mass is set based on a calculation formula for the fireball diameter;

[0043] The output is the heat flux and the safety distance, the cell position of the output and the default value of the safety distance are set, and the relationship between the heat flux and the input, the intermediate amount and the safety distance is set based on the calculation formula of the safety distance.

[0044] Optionally, the hazard determination standard values ​​include overpressure values ​​that have destructive effects on buildings, overpressure values ​​that have harmful effects on human bodies, and overpressure values ​​of space launch site construction standards.

[0045] Optionally, the hazard determination standard value includes a heat flux value that has a harmful effect on the human body.

[0046] Optionally, the editing macro is used to calculate and record the safety distance under different hazard determination standard values, including:

[0047] Based on the recorded macro or VBA programming language, the single variable solution function is used in turn to calculate the safety distance under each hazard judgment standard value, and the safety distance under each hazard judgment standard value is copied and pasted into the corresponding cell position for recording. BRIEF DESCRIPTION OF THE DRAWINGS

[0048] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0049] Figure 1 A schematic flow chart of a method for calculating a safe distance when a solid rocket engine explodes and disintegrates according to an embodiment of the present invention;

[0050] Figure 2 A schematic diagram of a shock wave calculation module Sheet provided in an embodiment of the present invention;

[0051] Figure 3 A schematic diagram of a thermal radiation calculation module Sheet provided in an embodiment of the present invention;

[0052] Figure 4 A schematic diagram of a result query (shock wave calculation) Sheet provided in an embodiment of the present invention;

[0053] Figure 5 A schematic diagram of a result query (thermal radiation calculation) Sheet provided in an embodiment of the present invention;

[0054] Figure 6 A schematic diagram of part of the code in a macro for calculating and recording the shock wave safety distance provided by an embodiment of the present invention;

[0055] Figure 7 A schematic diagram of part of the codes in a macro for calculating and recording the thermal radiation safety distance provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0056] In order to make the purpose, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. Obviously, the described embodiments are only part of the embodiments of the present invention, rather than all 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.

[0057] Figure 1 A flow chart of a method for calculating a safe distance when a solid motor explodes and disintegrates provided by an embodiment of the present invention is shown in detail, including:

[0058] Step 101, setting the number of iterations of the Excel workbook based on the accuracy and convergence of the calculation results.

[0059] The appropriate number of iterations can ensure both the precision and convergence of the calculation results, so as to solve the problem of insufficient precision and accuracy of the calculation results. Convergence means that the results can be calculated within this number of iterations.

[0060] In one example, when the number of iterations is 100, the accuracy of the calculation results can reach 1×10 -11 .

[0061] Step 102, setting the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity based on the calculation formula of the safety distance.

[0062] In one example, for shock waves, the calculation formula for the safety distance is:

[0063]

[0064] Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula for the equivalent distance is:

[0065]

[0066] Where: R is the safe distance, that is, the distance from the explosion center, in meters, W is the TNT equivalent, in kg. In the pressure vessel blasting mode, the calculation formula for TNT equivalent is:

[0067]

[0068] Where: p is the gas pressure in the container, in MPa, V is the volume of the container, in m 3 , k is the gas adiabatic index, which can be 1.16, and Q is the equivalent energy, in kJ.

[0069] Furthermore, the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity are set based on the calculation formula of the safety distance, including:

[0070] The input quantities are the gas pressure in the container, the container volume, the gas adiabatic index and the equivalent energy. The cell positions and default values ​​of the input quantities are set.

[0071] The intermediate quantity is TNT equivalent, the cell position of the intermediate quantity is set, and the relationship between the intermediate quantity and the input quantity is set based on the calculation formula of TNT equivalent;

[0072] The output quantities are overpressure, equivalent distance and safety distance. The cell position of the output quantity and the default value of the safety distance are set. The relationship between overpressure and equivalent distance is set based on the calculation formula of the safety distance. The relationship between equivalent distance and TNT equivalent and safety distance is set based on the calculation formula of the equivalent distance.

[0073] In one example, for shock waves, the calculation formula for the safety distance is:

[0074]

[0075] Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula for the equivalent distance is:

[0076]

[0077] Where: R is the safety distance, in meters, W is the TNT equivalent, in kg. In the propellant detonation mode, the calculation formula for TNT equivalent is:

[0078] W=m*l

[0079] Where: m is the mass of the propellant in kg, and l is the equivalence coefficient.

[0080] Furthermore, the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity are set based on the calculation formula of the safety distance, including:

[0081] The input quantities are the propellant mass and equivalence coefficient, and the cell locations and default values ​​of the input quantities are set;

[0082] The intermediate quantity is TNT equivalent, the cell position of the intermediate quantity is set, and the relationship between the intermediate quantity and the input quantity is set based on the calculation formula of TNT equivalent;

[0083] The output quantities are overpressure, equivalent distance and safety distance. The cell position of the output quantity and the default value of the safety distance are set. The relationship between overpressure and equivalent distance is set based on the calculation formula of the safety distance. The relationship between equivalent distance and TNT equivalent and safety distance is set based on the calculation formula of the equivalent distance.

[0084] In one example, for thermal radiation, the calculation formula for the safety distance is:

[0085]

[0086] Where: q is the heat flux, in W / cm 2 , m is the mass of the propellant, in kg, T is the combustion temperature, in K, D is the diameter of the fireball, in m, R is the safety distance, in m, and the calculation formula for the fireball diameter is:

[0087] D=3.86m 0.320 .

[0088] Furthermore, the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity are set based on the calculation formula of the safety distance, including:

[0089] The input quantities are propellant mass and combustion temperature, and the cell locations and default values ​​of the input quantities are set;

[0090] The intermediate quantity is the fireball diameter, the cell position of the intermediate quantity is set, and the relationship between the intermediate quantity and the propellant mass is set based on the calculation formula of the fireball diameter;

[0091] The output quantities are heat flux and safety distance. The cell position of the output quantity and the default value of the safety distance are set. The relationship between the heat flux and the input quantity, intermediate quantity and safety distance is set based on the calculation formula of the safety distance.

[0092] It should be noted that the cell position can be set arbitrarily, and the default value can be any value except null and 0. For easy understanding, the cells are arranged as neatly as possible, the default value is set to a positive number as much as possible, and prompt text is set.

[0093] Figure 2 This is a schematic diagram of the shock wave calculation module Sheet, which includes shock wave safety distance calculations in both pressure vessel explosion mode and propellant detonation mode, where:

[0094] In the pressure vessel explosion mode, the cell position of the gas pressure in the container in the input quantity is A4 and the default value is 9.2, the cell position of the container volume is B4 and the default value is 248, the cell position of the gas adiabatic index is C4 and the default value is 1.16, and the cell position of the equivalent energy is D4 and the default value is 4200;

[0095] The cell location of the intermediate quantity (i.e. TNT equivalent) is F4, and the relationship between the intermediate quantity and the input quantity is:

[0096] F4=((A4*B4) / (C4-1))*(1-(0.1013 / A4)^((C4-1) / C4))*1000 / D4;

[0097] The cell position of overpressure in the output is H4, the cell position of equivalent distance is I4, the cell position of safety distance is J4 and the default value is 449.4257004. The relationship between overpressure and equivalent distance is:

[0098] H4=(1.061 / I4+4.31 / I4^2+14.1 / I4^3)*0.0981,

[0099] The relationship between the equivalent distance, TNT equivalent and safety distance is:

[0100] I4=J4 / (F4)^(1 / 3);

[0101] In the propellant detonation mode, the cell position of the propellant weight in the input quantity is A8 and the default value is 10000, and the cell position of the equivalence coefficient is B8 and the default value is 0.4;

[0102] The cell location of the intermediate quantity (i.e. TNT equivalent) is F8, and the relationship between the intermediate quantity and the input quantity is:

[0103] F8=A8*B8;

[0104] The cell position of overpressure in the output is H8, the cell position of equivalent distance is I8, the cell position of safety distance is J8 and the default value is 613.528295. The relationship between overpressure and equivalent distance is:

[0105] H8=(1.061 / I8+4.31 / I8^2+14.1 / I8^3)*0.0981,

[0106] The relationship between the equivalent distance, TNT equivalent and safety distance is:

[0107] I8=J8 / (F8)^(1 / 3).

[0108] Figure 3 This is a schematic diagram of the thermal radiation calculation module Sheet, where:

[0109] The cell location of the propellant mass in the input quantity is A3 and the default value is 483000, and the cell location of the combustion temperature is B3 and the default value is 3550;

[0110] The cell position of the intermediate quantity (i.e., the fireball diameter) is D3, and the relationship between the intermediate quantity and the propellant mass is:

[0111] D3=3.86*A3^0.32;

[0112] The cell position of heat flux in the output is F3, the cell position of safety distance is G3 and the default value is 3743.829358. The relationship between heat flux and input, intermediate and safety distance is:

[0113] F3=((D3 / G3)^2 / (161.7+(D3 / G3)^2)*A3^(1 / 3)*B3^(2 / 3)*20400) / (1000*66.4545).

[0114] It should be noted that although Figure 2 The calculation of the safety distance of the medium shock wave in the pressure vessel explosion mode and the propellant detonation mode is implemented in the same sheet, and Figure 3 The calculation of the safety distance for thermal radiation is implemented in another Sheet, but this is not the only way to implement it. The calculation of the safety distance for shock waves in pressure vessel blasting mode and propellant detonation mode and the calculation of the safety distance for thermal radiation can be implemented in different Sheets respectively, or they can be arbitrarily combined in the same Sheet.

[0115] Step 103, setting a cell position for recording safety distances under different hazard determination standard values.

[0116] In one example, for shock waves, the hazard determination standard values ​​include overpressure values ​​that have destructive effects on buildings, overpressure values ​​that have harmful effects on human bodies, and overpressure values ​​of space launch site construction standards.

[0117] The overpressure values ​​that have a destructive effect on buildings are as follows:

[0118] >0.076, indicating complete destruction, including collapse of most of the brick exterior walls, collapse of most of the reinforced concrete roof and brick walls, collapse of most of the brick interior walls, and serious damage to the reinforced concrete columns;

[0119] 0.055-0.076, indicating severe damage, including partial collapse of the brick exterior wall, cracks larger than 2 mm in the reinforced concrete roof, severe cracks or partial collapse of the brick interior wall, and tilting of the reinforced concrete column;

[0120] 0.040-0.055, representing minor serious damage, including destruction of wooden doors and windows, falling window frames, severe cracks of more than 50mm in width on brick exterior walls or severe tilting, larger cracks on brick stacks, obvious cracks of 1-2mm in width on reinforced concrete roofs that can continue to be used after repair, large cracks on brick interior walls, and no damage to reinforced concrete columns;

[0121] 0.025-0.040, indicating moderate damage, including glass shattering, large cracks with a width of 5-50 mm on the brick exterior wall or obvious tilting, small cracks on the brick stack, and tiny cracks with a maximum width of more than 1 mm on the steel concrete roof;

[0122] 0.009-0.025, representing mild damage, including most of the glass being broken into small pieces or shattered, a large number of wooden doors and windows being damaged, small cracks with a maximum width of less than 5mm on the brick exterior wall or a slight tilt, no damage to the steel concrete roof, and a large amount of ceiling plaster falling off;

[0123] 0.002-0.009, representing minor damage, including most of the glass being damaged in large strips or small pieces, a small amount of damage to wooden doors and windows, no damage to brick exterior walls, no damage to steel concrete roof or columns, and a small amount of ceiling plaster falling off;

[0124] <0.002, indicating that there is basically no damage, including accidental damage to the glass.

[0125] The overpressure values ​​that have harmful effects on the human body are as follows:

[0126] >0.1, indicating death;

[0127] 0.044 to 0.1, representing serious injury;

[0128] 0.01~0.044 means minor injuries.

[0129] The overpressure values ​​of GJB9300-2018 "Space Launch Site Construction Standards" are as follows:

[0130] <0.0062, representing the boundary of the danger control zone;

[0131] <0.003, representing the boundary of the safety control zone.

[0132] In one example, for thermal radiation, the hazard determination standard value includes a heat flux value that has a harmful effect on a human body.

[0133] The heat flux values ​​that have harmful effects on the human body are as follows:

[0134] ≥3.75, representing 100% mortality within 1 minute and 1% mortality within 10 seconds;

[0135] 2.5, representing 100% mortality in 1 minute, severe burns within 10 seconds;

[0136] 1.6, indicating severe burns after 5 seconds of exposure;

[0137] 1.25, representing 1% mortality rate within 1 minute, first-degree burn within 10 seconds;

[0138] 0.64, representing the pain threshold after 8 seconds of exposure and second-degree burn after 20 seconds;

[0139] 0.5, representing the pain threshold after 15 s of exposure;

[0140] 0.45, representing the pain threshold after 20 s of exposure, first-degree burn;

[0141] 0.4, meaning that exposure for 20 seconds causes pain but no blisters;

[0142] 0.175, representing the pain threshold after 1 min of exposure;

[0143] ≤0.16, indicating no discomfort after long-term exposure.

[0144] It should be noted that the cell position can be set arbitrarily. For ease of understanding, try to set it to neatly arranged cells, and you can set prompt text.

[0145] Figure 4 This is a schematic diagram of the result query (shock wave calculation) Sheet, which records the safe distances of shock waves at different overpressure values ​​under the pressure vessel explosion mode and the propellant detonation mode.

[0146] Figure 5 This is a schematic diagram of the result query (thermal radiation calculation) Sheet. In the figure, the calculation result records the safe distance of thermal radiation at different heat flux values.

[0147] It should be noted that although Figure 4 The safe distances of shock waves at different overpressure values ​​in the pressure vessel explosion mode and the propellant detonation mode are recorded in the same sheet, and Figure 5 The safe distance for recording thermal radiation at different heat flux values ​​is implemented in another Sheet, but this is not the only way to implement it. The safe distance for recording shock waves at different overpressure values ​​in pressure vessel explosion mode and propellant detonation mode and the safe distance for recording thermal radiation at different heat flux values ​​can be implemented in different Sheets respectively, or they can be arbitrarily combined in the same Sheet. Figure 2 and Figure 4 (or Figure 2 and Figure 5 ), the calculation and recording of the safety distance under different hazard determination standard values ​​are implemented in different Sheets, but this is not the only way to implement it. The calculation and recording of the safety distance under different hazard determination standard values ​​can be implemented in different Sheets or in the same Sheet.

[0148] Step 104 , editing a macro for calculating and recording safety distances under different hazard determination standard values.

[0149] In one example, editing a macro for calculating and recording safety distances under different hazard determination criteria values ​​includes:

[0150] Based on macro recording or VBA (Visual Basic for Applications) programming language, use the Goal Seek function to calculate the safety distance under each hazard judgment standard value in turn, and copy and paste the safety distance under each hazard judgment standard value to the corresponding cell position for recording.

[0151] Figure 6 The following is a schematic diagram of part of the code in the macro used to calculate and record the shock wave safety distance, where:

[0152] For each overpressure value (such as 0.076, 0.055, etc.);

[0153] Use the single variable calculation (Goal Seek) function, specifically use the Range.Goal Seek function to set the overpressure (i.e. H4 and H8) in the pressure vessel explosion mode and the propellant detonation mode in the shock wave calculation module Sheet to the overpressure value, so as to calculate the safety distance (i.e. J4 and J8) in the pressure vessel explosion mode and the propellant detonation mode;

[0154] And use the Selection.copy and Seletion.PasteSpecial functions to copy and paste the safety distances (i.e. J4 and J8) in the pressure vessel explosion mode and propellant detonation mode in the shock wave calculation module Sheet to the corresponding cell positions for recording in the result query (shock wave calculation) Sheet.

[0155] because Figure 2 The calculation result of the last overpressure value is finally displayed. In order to know the safe distance of the shock wave at the most concerned overpressure value as soon as possible, the most concerned overpressure value can be calculated last. Figure 2 The final calculation result shows that 0.03 is Figure 2 The overpressure value of greatest concern.

[0156] Figure 7 The following is a schematic diagram of part of the code in the macro used to calculate and record the thermal radiation safety distance, where:

[0157] For each heat flux value (such as 3.75, 2.5, 1.6, 1.25, 0.64, etc.);

[0158] Use the single variable calculation (Goal Seek) function, specifically use the Range.Goal Seek function to set the heat flux in the thermal radiation calculation module Sheet (i.e. F3) to the heat flux value to calculate the safety distance;

[0159] And use the Selection.copy and Selection.PasteSpecial functions to copy and paste the safety distance (ie G3) in the thermal radiation calculation module Sheet to the corresponding cell position for recording in the result query (thermal radiation calculation) Sheet.

[0160] because Figure 3 The final result displayed on the chart is the calculation result of the last heat flux value. In order to quickly know the safe distance of thermal radiation at the most concerned heat flux value, the most concerned heat flux value can be calculated last. Figure 3 The final calculation result shows that 0.16 is Figure 3 The heat flux value is of most concern.

[0161] Step 105, bind the trigger button and the edited macro, set the test value of the input quantity, click the trigger button to perform calculation, and obtain the safety distance under different hazard judgment standards corresponding to the test value.

[0162] Trigger button like Figure 2 and Figure 3 The box with the words "Start Calculation" shown.

[0163] By setting different test values ​​for the input quantity, solid rocket engines of different specifications can be obtained.

[0164] In the above scheme, by editing the macro, the shock wave safety distance and thermal radiation safety distance of solid motors of different specifications during explosion and disintegration can be accurately calculated, and the safety distance under different hazard judgment standard values ​​can be recorded, thereby realizing process automation and saving a lot of human resources. At the same time, the scheme also has the advantages of stable operation, fast calculation speed, strong adaptability of results and low computing power requirements.

[0165] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0166] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0167] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0168] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0169] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0170] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A method for calculating the safe distance when a solid rocket engine explodes and disintegrates, characterized in that: The following steps are involved: Set the number of iterations of the Excel workbook according to the accuracy and convergence of the calculation results; Set the cell positions, default values ​​and relationships of input quantities, intermediate quantities and output quantities based on the calculation formula of the safety distance; Set the cell location for recording the safety distance under different hazard judgment standard values; The editing macro is used to calculate and record the safety distance under the different hazard determination standard values; Bind the trigger button and the edited macro, set the test value of the input quantity, click the trigger button to calculate, and obtain the safety distance under different hazard judgment standards corresponding to the test value.

2. The method according to claim 1, characterized in that: The calculation formula of the safety distance is: Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula of the equivalent distance is: Where: R is the safety distance, the unit is m, W is the TNT equivalent, the unit is kg, and the calculation formula of the TNT equivalent is: Where: p is the gas pressure in the container, in MPa, V is the volume of the container, in m 3 , k is the gas adiabatic index, Q is the equivalent energy, the unit is kJ.

3. The method according to claim 2, characterized in that: The calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including: The input quantities are the gas pressure in the container, the volume of the container, the gas adiabatic index and the equivalent energy, and the cell positions and default values ​​of the input quantities are set; The intermediate amount is the TNT equivalent, a cell position of the intermediate amount is set, and a relationship between the intermediate amount and the input amount is set based on a calculation formula of the TNT equivalent; The output is the overpressure, the equivalent distance and the safety distance. The cell position of the output and the default value of the safety distance are set. The relationship between the overpressure and the equivalent distance is set based on the calculation formula of the safety distance. The relationship between the equivalent distance, the TNT equivalent and the safety distance is set based on the calculation formula of the equivalent distance.

4. The method according to claim 1, characterized in that: The calculation formula of the safety distance is: Where: Δp is the overpressure, in MPa, is the equivalent distance, in m, and the calculation formula of the equivalent distance is: Where: R is the safety distance, the unit is m, W is the TNT equivalent, the unit is kg, and the calculation formula of the TNT equivalent is: W=m*l Where: m is the mass of the propellant in kg, and l is the equivalence coefficient.

5. The method according to claim 4, characterized in that: The calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including: The input quantity is the propellant mass and the equivalence coefficient, and the cell position and default value of the input quantity are set; The intermediate amount is the TNT equivalent, a cell position of the intermediate amount is set, and a relationship between the intermediate amount and the input amount is set based on a calculation formula of the TNT equivalent; The output is the overpressure, the equivalent distance and the safety distance. The cell position of the output and the default value of the safety distance are set. The relationship between the overpressure and the equivalent distance is set based on the calculation formula of the safety distance. The relationship between the equivalent distance, the TNT equivalent and the safety distance is set based on the calculation formula of the equivalent distance.

6. The method according to claim 1, characterized in that: The calculation formula of the safety distance is: Where: q is the heat flux, in W / cm 2 , m is the mass of the propellant, in kg, T is the combustion temperature, D is the diameter of the fireball, in m, R is the safety distance, in m, and the calculation formula for the fireball diameter is: D: 3.86m 0.320 .

7. The method according to claim 6, characterized in that: The calculation formula based on the safety distance is used to set the cell positions, default values ​​and relationships of the input quantity, intermediate quantity and output quantity, including: The input quantity is the propellant mass and the combustion temperature, and the cell position and default value of the input quantity are set; The intermediate quantity is the fireball diameter, a cell position of the intermediate quantity is set, and a relationship between the intermediate quantity and the propellant mass is set based on a calculation formula for the fireball diameter; The output is the heat flux and the safety distance, the cell position of the output and the default value of the safety distance are set, and the relationship between the heat flux and the input, the intermediate amount and the safety distance is set based on the calculation formula of the safety distance.

8. The method according to claim 2 or 4, characterized in that: The hazard determination standard values ​​include overpressure values ​​that have destructive effects on buildings, overpressure values ​​that have harmful effects on human bodies, and overpressure values ​​that meet the construction standards of space launch sites.

9. The method according to claim 6, characterized in that: The hazard determination standard value includes a heat flux value that has a harmful effect on the human body.

10. The method according to claim 1, characterized in that: The editing macro is used to calculate and record the safety distance under the different hazard determination standard values, including: Based on the recorded macro or VBA programming language, the single variable solution function is used in turn to calculate the safety distance under each hazard judgment standard value, and the safety distance under each hazard judgment standard value is copied and pasted into the corresponding cell position for recording.