Dense film hole punching path drawing method based on VBA programming

Abstract

The invention provides a dense film hole punching path drawing method based on VBA programming, and the method comprises the steps: building a table in a preset VBA module of CAD software, opening a film hole design table, and extracting punching information; determining the initial and tail punching positions of each row of air film holes according to the punching information, representing the punching positions of all the air film holes in the corresponding row as equal-included-angle hole distribution, and obtaining equal-included-angle hole distribution information; the circumferential angle of each row of film holes is calculated through a VBA algorithm; and finally, obtaining punching path parameters of each row of air film holes, filling the obtained information into a table, and importing the information into CAD software to generate a punching path. According to the method, all the film holes are represented in rows, the punching positions of the film holes in each row are represented as hole sites distributed at equal included angles, and complex punching information of the film holes distributed circumferentially is rapidly and accurately expressed in a table type numerical control programming mode, so that the programming difficulty is effectively reduced, and the punching efficiency is improved. And the numerical control programming efficiency and the programming quality of the dense film holes are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of laser drilling and VBA programming, and more specifically, to a method for drawing a dense air film hole drilling path based on VBA programming. Background Art

[0002] Laser processing is widely used in aircraft engines due to its advantages of high efficiency, high precision, small heat-affected zone and low cost. For example, there are many film holes on the flame tube of an aircraft engine, the distribution is complex and there is a thermal barrier coating. Laser drilling can achieve efficient processing, thereby reducing manufacturing costs. However, the number of film holes in the engine is large and the distribution is complex. The traditional digital model programming requires both accurate models and cumbersome pre-processing and post-processing to obtain the required CNC code. The programming time is huge, resulting in increased costs. In addition, with the development of technology, the distribution of film holes is often expressed in tabular form during design, which also brings new difficulties to CNC programming and lacks accurate digital models for programming.

[0003] like Figure 1 As shown, Figure 1 This is a digital model of a flame tube. It can be seen that it does not draw the positions of all the air film holes, but simply expresses the positions of some holes. Therefore, this model cannot be used for digital model programming. In addition to digital models, engineering drawings (three views) and tables are usually used to describe the positions of each air film hole on the flame tube (including axial, radial, and circumferential distribution), apertures, number of holes and other information. If traditional digital model programming is used, it is necessary to process the table information first, draw an accurate model, and then program, which takes a lot of time and is inefficient.

[0004] Existing patent documents disclose a method for drawing a drilling trajectory diagram in AutoCAD using a VBA module. First, the completed drilling trajectory parameters are processed, and then the initial parameters and line type settings are completed through the calculation results called by the VBA module, and the drawing of the drilling trajectory diagram is automatically completed in AutoCAD. This solution can only perform CAD drawing based on the measured trajectory of the drilling, and the drawing accuracy is not high. It cannot be used to draw air film hole drilling paths with extremely high density and accuracy and complex distribution. Summary of the invention

[0005] In order to overcome the defect that the above-mentioned prior art cannot accurately and efficiently draw the dense air film hole punching path, the present invention provides a dense air film hole punching path drawing method based on VBA programming, which is based on CAD software and VBA programming functions and uses tabular CNC programming to quickly and accurately express the complex punching information on the circularly distributed air film holes, effectively reducing the programming difficulty and improving the CNC programming efficiency and dense air film hole programming quality of dense air film holes.

[0006] In order to solve the above technical problems, the technical solution of the present invention is as follows:

[0007] A method for drawing a dense air film hole punching path based on VBA programming, wherein the air film holes in the same row are distributed in a circle, and the method comprises the following steps:

[0008] S1: Establish a table in the VBA module preset in the CAD software, obtain a punching design table of dense air film holes, and extract the punching information and fill it into the first position of the table; the punching information includes: hole row information, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B, rotation angle A, and the rotation order of the punching swing angle B and the rotation angle A;

[0009] S2: Determine the starting and ending punching positions of each air film hole according to the punching information, express the punching positions of all air film holes in the corresponding row as equal-angle hole distribution, obtain the equal-angle hole distribution information and fill it into the second position of the table; the equal-angle hole distribution information includes: the starting punching angle of each air film hole, the angle between adjacent equal-angle holes, and the arrangement and combination information of the punching position and the vacant hole position equal-angle holes;

[0010] S3: Calculate the circumferential angle of each exhaust film hole using a VBA algorithm according to the equal-angle hole distribution information and fill it into the third position of the table;

[0011] S4: Obtain the punching path parameters of each exhaust film hole and fill in the fourth position of the table, obtain the final table and import it into the CAD software, generate the punching path, and complete the drawing of the dense air film hole punching path.

[0012] Preferably, in step S1, a drilling design table of dense air film holes is obtained, and the coordinate system includes an X-axis, a Y-axis and a Z-axis distributed according to the right-hand rule.

[0013] Preferably, in step S1, the axial distance of each air film hole is extracted as the Z coordinate of the hole, and half of the radial position of each air film hole is extracted as the X coordinate or Y coordinate of the hole, and the X coordinate is calculated based on the X coordinate. 2 +Y 2 =R 2 Calculate the Y coordinate or X coordinate of the punch hole, where X, Y and R are the X coordinate of the punch hole, the Y coordinate of the punch hole and the radius of the circle where the air film hole is located respectively; extract the punch hole swing angle of each air film hole rotated about the Y axis as the punch hole swing angle B, and extract the rotation angle of each air film hole rotated about the X axis as the rotation angle A.

[0014] Preferably, step S1 further includes extracting the aperture of each air film hole, clustering the air film holes with exactly the same aperture, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B and rotation angle A into the same row of air film holes, and using the number of clustered categories as the hole row information.

[0015] Preferably, in step S1, if the rotation angle A shows the punching swing angle B, the rotation angle A is rotated first, otherwise, the punching swing angle B is rotated first.

[0016] Preferably, in step S2, the equal-angle holes include actual holes and vacant holes;

[0017] The angle between the starting punching position of each exhaust film hole and the coordinate axis is taken as the starting punching angle, and the corresponding coordinate axis is taken as the 0° angle baseline;

[0018] According to the evenly distributed number of holes or a given angle of each air film hole, the angle between adjacent holes with equal angles is determined, and the punching positions of all air film holes in the corresponding row are converted into actual hole positions and vacant hole positions that are evenly spaced according to the angle;

[0019] The actual holes and vacant holes are grouped, and several two-dimensional arrays B are constructed correspondingly. k , the kth array B k Expressed as: B k (m k , n k ), where m k and n k They represent the actual number of holes and the number of vacant holes in the corresponding group. During processing, first drill holes m k actual holes, n vacancies at the end k vacant holes;

[0020] For the punching position of the i-th exhaust film hole, the array B k Perform permutations and combinations to construct the corresponding combination C i , all arrays B k and combination C i The arrangement and combination information of holes with equal angles are saved together.

[0021] Preferably, in step S3, the circumferential angle range of each exhaust film hole is 0 to 360°, and they are arranged from small to large and filled into the third position of the table.

[0022] Preferably, the step S3 further comprises: according to the circumferential angle of each air film hole, indicating the punching position of each air film hole with a 3D straight line in the view window of the CAD software;

[0023] Or display the 2D plane distribution diagram of all air film hole drilling positions in the view window of the CAD software.

[0024] Preferably, in step S4, the punching path parameters include: the aperture of each exhaust film hole, the punching method, the punching rate, the drilling time, the number of punching times, the hole retraction distance, the focal position, the retraction axis information and the retraction distance between the hole rows.

[0025] The present invention also provides a computer-readable storage medium on which a computer program is stored. When the computer program is executed by a processor, the steps in the above method are implemented.

[0026] Compared with the prior art, the technical solution of the present invention has the following beneficial effects:

[0027] The present invention provides a method for drawing a dense air film hole punching path based on VBA programming. The air film holes in the same row are distributed according to the circumference. First, a table is established in a VBA module preset in the CAD software to obtain a punching design table for dense air film holes, and the punching information is extracted and filled into the table; then, the starting and ending punching positions of each exhaust film hole are determined according to the punching information, and the punching positions of all air film holes in the corresponding row are expressed as equal-angle hole distributions, and the equal-angle hole distribution information is obtained and filled into the table; then, according to the equal-angle hole distribution information, the circumferential angle of each exhaust film hole is calculated using a VBA algorithm and filled into the table; finally, the punching path parameters of each exhaust film hole are obtained and filled into the table, and the final table is obtained and imported into the CAD software to generate a punching path, thereby completing the drawing of the dense air film hole punching path;

[0028] The present invention is based on CAD software and VBA programming functions, which represent all the air film holes in rows and represent the punching positions of the air film holes in each row as hole positions with equal angle distribution. The complex punching information on the circularly distributed air film holes is quickly and accurately expressed through a tabular CNC programming method, which effectively reduces the programming difficulty and improves the CNC programming efficiency and programming quality of dense air film holes. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 This is a schematic diagram of the flame tube digital model provided in the background technology.

[0030] Figure 2 This is a flow chart of a method for drawing a dense air film hole punching path based on VBA programming provided in Example 1.

[0031] Figure 3 This is a specific implementation flow chart of a method for drawing a dense air film hole punching path based on VBA programming provided in Example 2.

[0032] Figure 4 This is a schematic diagram of the main interface of the VBA module provided in Example 2.

[0033] Figure 5 This is an example diagram of the equal-angle hole distribution provided in Example 2.

[0034] Figure 6 This is a schematic diagram provided in Example 2, in which a 3D straight line is used in the CAD software view window to represent the punching position of each hole.

[0035] Figure 7 This is a schematic diagram of displaying the drilling positions of all air film holes using a 2D plane distribution diagram in the CAD software view window provided in Example 2.

[0036] Figure 8 This is a schematic diagram of the punching path parameter table column provided in Example 2. DETAILED DESCRIPTION

[0037] The drawings are for illustrative purposes only and should not be construed as limiting the present patent;

[0038] In order to better illustrate the present embodiment, some parts in the drawings may be omitted, enlarged or reduced, and do not represent the size of the actual product;

[0039] It is understandable to those skilled in the art that some well-known structures and their descriptions may be omitted in the drawings.

[0040] The technical solution of the present invention is further described below in conjunction with the accompanying drawings and embodiments.

[0041] Example 1

[0042] like Figure 2 As shown, this embodiment provides a method for drawing a dense air film hole punching path based on VBA programming, wherein the air film holes in the same row are distributed in a circle, and the method comprises the following steps:

[0043] S1: Establish a table in the VBA module preset in the CAD software, obtain a punching design table of dense air film holes, and extract the punching information and fill it into the first position of the table; the punching information includes: hole row information, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B, rotation angle A, and the rotation order of the punching swing angle B and the rotation angle A;

[0044] S2: Determine the starting and ending punching positions of each air film hole according to the punching information, express the punching positions of all air film holes in the corresponding row as equal-angle hole distribution, obtain the equal-angle hole distribution information and fill it into the second position of the table; the equal-angle hole distribution information includes: the starting punching angle of each air film hole, the angle between adjacent equal-angle holes, and the arrangement and combination information of the punching position and the vacant hole position equal-angle holes;

[0045] S3: Calculate the circumferential angle of each exhaust film hole using a VBA algorithm according to the equal-angle hole distribution information and fill it into the third position of the table;

[0046] S4: Obtain the punching path parameters of each exhaust film hole and fill in the fourth position of the table, obtain the final table and import it into the CAD software, generate the punching path, and complete the drawing of the dense air film hole punching path.

[0047] In the specific implementation process, this method is suitable for generating the punching path of the air film holes distributed according to the circumference. The principle is to process all the air film hole positions into equal-angle hole distribution, and then obtain the circumferential hole distribution position of each hole through certain VBA algorithm programming, and finally further generate the punching path. The specific process is as follows:

[0048] First, a table is established in the VBA module preset in the CAD software to obtain the punching design table of dense air film holes, and the punching information is extracted and filled into the table; as shown in Table 1, Table 1 is an example of the punching design table of dense air film holes. One of the main purposes of this method is to solve the numerical control programming of such table holes and improve programming efficiency;

[0049] Table 1 Example of drilling design for dense air film holes

[0050]

[0051] Then, the starting and ending punching positions of each air film hole are determined according to the punching information, and the punching positions of all air film holes in the corresponding row are expressed as equal-angle hole distribution, and the equal-angle hole distribution information is obtained and filled in the table;

[0052] Then, according to the equal-angle hole distribution information, the circumferential angle of each exhaust film hole is calculated using the VBA algorithm and filled in the table;

[0053] Finally, the punching path parameters of each exhaust film hole are obtained and filled into the table, the final table is obtained and imported into the CAD software to generate the punching path, and the drawing of the dense air film hole punching path is completed;

[0054] Based on CAD software and VBA programming functions, this method represents all the air film holes in rows, and represents the punching positions of the air film holes in each row as holes with equal angle distribution. The complex punching information on the circularly distributed air film holes is quickly and accurately expressed through tabular CNC programming, which effectively reduces the programming difficulty and improves the CNC programming efficiency and programming quality of dense air film holes.

[0055] Example 2

[0056] This embodiment provides a method for drawing a dense air film hole punching path based on VBA programming, wherein the air film holes in the same row are distributed in a circle, and the method comprises the following steps:

[0057] S1: Establish a table in the VBA module preset in the CAD software, obtain a punching design table of dense air film holes, and extract the punching information and fill it into the first position of the table; the punching information includes: hole row information, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B, rotation angle A, and the rotation order of the punching swing angle B and the rotation angle A;

[0058] S2: Determine the starting and ending punching positions of each air film hole according to the punching information, express the punching positions of all air film holes in the corresponding row as equal-angle hole distribution, obtain the equal-angle hole distribution information and fill it into the second position of the table; the equal-angle hole distribution information includes: the starting punching angle of each air film hole, the angle between adjacent equal-angle holes, and the arrangement and combination information of the actual hole position and the vacant hole position equal-angle holes;

[0059] S3: Calculate the circumferential angle of each exhaust film hole using a VBA algorithm according to the equal-angle hole distribution information and fill it into the third position of the table;

[0060] S4: Obtain the punching path parameters of each exhaust film hole and fill them into the fourth position of the table, obtain the final table and import it into the CAD software, generate the punching path, and complete the drawing of the dense air film hole punching path;

[0061] In the step S1, a drilling design table of dense air film holes is obtained, and the coordinate system includes an X-axis, a Y-axis and a Z-axis distributed according to the right-hand rule;

[0062] In step S1, the axial distance of each air film hole is extracted as the Z coordinate of the hole, and half of the radial position of each air film hole is extracted as the X coordinate or Y coordinate of the hole, and the X coordinate is calculated according to the X coordinate. 2 +Y 2 =R 2 Calculate the Y coordinate or X coordinate of the punch hole, where X, Y and R are the X coordinate of the punch hole, the Y coordinate of the punch hole and the radius of the circle where the air film hole is located respectively; extract the punch hole swing angle of each air film hole rotated about the Y axis as the punch hole swing angle B, and extract the rotation angle of each air film hole rotated about the X axis as the rotation angle A;

[0063] The step S1 further includes extracting the aperture of each air film hole, clustering the air film holes with the same aperture, perforation X coordinate, perforation Y coordinate, perforation Z coordinate, perforation swing angle B and rotation angle A into the same row of air film holes, and using the number of clustered categories as the hole row information;

[0064] In the step S1, if the rotation angle A shows the punching swing angle B, the rotation angle A is rotated first, otherwise, the punching swing angle B is rotated first;

[0065] In the step S2, the equal-angle holes include actual holes and vacant holes;

[0066] The angle between the starting punching position of each exhaust film hole and the coordinate axis is taken as the starting punching angle, and the corresponding coordinate axis is taken as the 0° angle baseline;

[0067] According to the evenly distributed number of holes or a given angle of each air film hole, the angle between adjacent holes with equal angles is determined, and the punching positions of all air film holes in the corresponding row are converted into actual hole positions and vacant hole positions that are evenly spaced according to the angle;

[0068] The actual holes and vacant holes are grouped, and several two-dimensional arrays B are constructed correspondingly. k , the kth array B k Expressed as: B k (m k , n k ), where m k and n k They represent the actual number of holes and the number of vacant holes in the corresponding group. During processing, first drill holes m k actual holes, n vacancies at the end k vacant holes;

[0069] For the punching position of the i-th exhaust film hole, the array B k Perform permutations and combinations to construct the corresponding combination C i , all arrays B k and combination C i The arrangement and combination information of holes with equal angles are saved together;

[0070] In the step S3, the circumferential angle range of each exhaust film hole is 0 to 360 degrees, and they are arranged from small to large and filled into the third position of the table;

[0071] The step S3 further includes: according to the circumferential angle of each exhaust film hole, using a 3D straight line in the view window of the CAD software to indicate the punching position of each air film hole;

[0072] Or display the 2D plane distribution diagram of all air film hole punching positions in the view window of the CAD software;

[0073] In step S4, the punching path parameters include: the aperture of each exhaust film hole, the punching method, the punching rate, the drilling time, the number of punching times, the hole retraction distance, the focus position, the retraction axis information and the retraction distance between the hole rows.

[0074] In the specific implementation process, Figure 3 The overall flow chart of this method is shown as follows:

[0075] Step 1: First, create a table in the VBA module preset in the CAD software. The created table is as follows: Figure 3 As shown in FIG. 1 , the perforation information table of the dense air film holes is obtained, and the perforation information is extracted and filled into the table; specifically, the axial distance is input as the Z coordinate into the Z column table in the VBA module table, and half of the radial position is input as the X coordinate into the X column table of the VBA module. 2 +Y 2 =R 2 Calculate the Y coordinate of the punch hole, where X, Y and R are the X coordinate of the punch hole, the Y coordinate of the punch hole and the radius of the circle where the air film hole is located. If all the holes on the circle are distributed in the XZ plane where Y=0, then the Y values ​​are all 0, otherwise the Y coordinate of the punch hole needs to be calculated according to the above formula; input the punch hole swing angle into the B column table of the VBA module; if the air film hole has an angle of rotation around X, fill it in the A column table, if not, fill the A column table with all 0;

[0076] It is worth mentioning that for the air film holes in the same row, their apertures and Z / Y / X / B / A values ​​must be the same, otherwise a new row is required; Figure 4 As shown, the hole row information is R1 to R10;

[0077] After entering the above punching information, it is necessary to determine the order of rotation of the angles of columns A and B in the VBA module table according to the design drawing, and check the selection boxes of columns B and A in the VBA module as required; in this embodiment, it is defined that: if the rotation angle A cuts out the punching swing angle B, the angle of column A is rotated first, and the selection box of column A is checked at the same time; based on the Euler angle, the order of rotation angles will be inconsistent in the angular position in space, so there needs to be a sequence relationship;

[0078] Step 2: According to Figure 4 The starting angle and hole position information in the table are used to process the air film hole punching positions of each row into holes with equal angle distribution and fill them in Figure 4 The "Equal Angle Hole Distribution" section of the table (including array B k Table, Combination C i Table, hole row combination table), the same row of holes can be realized by multiple groups of equal angle hole distribution, just keep the number of hole rows the same;

[0079] In this embodiment, the punching positions of the air film holes in each row are processed into holes with equal angle distribution. The following example is used to illustrate the principle and processing process:

[0080] like Figure 5As shown, a group of circularly distributed equal-angle holes are distributed. The starting position and the end position of the hole are determined, and then the angle with the coordinate axis is recorded as the starting angle α, and the angle between the holes is determined as θ (including the vacant hole position). The hole punching distribution is to first process m1 holes, then leave n1 holes vacant and not process them. There are two groups of holes in this state, and then continue to process m2 holes, leave n2 holes vacant, and finally process m3 holes. In this embodiment, m1=6, n1=2, m2=5, n2=4, and m3=10; it can be seen that as long as the actual hole and the vacant hole angle θ are consistent, the distribution mode of equal-angle holes (including the vacant hole position) can completely cover all air film hole positions, and based on the above process of sequentially processing equal-spaced holes in groups, a whole row of air film holes can be accurately processed;

[0081] Based on the above principles, in order to accurately express the hole processing and non-processing parts, this method designs the following expression:

[0082] Record each group as a two-dimensional array B k (m k , n k ), where m k and n k Respectively represent the actual number of holes and the number of vacant holes in the corresponding group. Figure 5 In the example, there are three different arrays: B1(m1,n1), B2(m2,n2) and B3(m3,0);

[0083] Then B k The array is arranged and combined to obtain the processing information of the entire exhaust film hole, which is recorded as combination C i ,For example, Figure 5 The example shown can be expressed as C1=B1+B1+B2+B3 or C1=2×B1+B2+B3 or C1=B1×2+B2+B3;

[0084] Then, the hole angle θ and the starting angle α are combined to calculate the hole positions of the punching parts using the VBA algorithm. The hole positions of the vacant parts are not output, and all the punching positions can be obtained.

[0085] Step 3: After confirming that the equal angle distribution information entered in step 2 is correct, you can select the drilling view mode in the VBA module, which generally includes 3D view and 2D view. The 2D view only displays the circumferential distribution of holes in the XY plane with straight lines, and the 3D actual drilling view only needs to convert the drilling coordinates when the rotation axis A is not zero;

[0086] Then the circumferential angle of each row of holes is calculated by VBA algorithm, and written into the hole circumferential angle table according to the hole arrangement. The algorithm realizes that all angle values ​​are 0-360° and are automatically arranged from small to large. At the same time, the punching position is displayed in the CAD software view window. If the 3D view is selected, the punching position of each hole will be indicated by a 3D straight line. The hole position can be checked with the aid of the model. Figure 6 If you select 2D view, the following will be displayed in the CAD software view window: Figure 7 The plane hole distribution diagram shown;

[0087] Step 4: After the hole position and other information expressed in step 3 above are correct, use the VBA module's path generation function to Figure 8 In the "Drilling Path Parameters" table column shown, fill in the corresponding parameters according to the laser drilling requirements, and click the confirmation button to automatically complete the generation of the laser drilling paths for all air film holes (generate the paths in the order in the VBA module hole circumference angle table, and generate rows of holes from small to large);

[0088] In addition, the VBA module can be further used to perform post-processing as needed, such as outputting the required NC code, thereby realizing the automatic generation of the NC code for the punching path;

[0089] Finally, the VBA module can be used to save the entire project file as needed, and all the information in the final table can be saved in CSV file format;

[0090] Based on CAD software and VBA programming functions, this method represents all the air film holes in rows, and represents the punching positions of the air film holes in each row as holes with equal angle distribution. The complex punching information on the circularly distributed air film holes is quickly and accurately expressed through tabular CNC programming, which effectively reduces the programming difficulty and improves the CNC programming efficiency and programming quality of dense air film holes.

[0091] Example 3

[0092] This embodiment provides a VBA quick programming tool suitable for CAD software, which is used to implement the method for drawing the dense air film hole punching path described in Embodiment 1 or 2.

[0093] In the specific implementation process, Figure 4 The interface shown in the figure, the VBA quick programming tool in this embodiment includes: a toolbar part (including project file saving and opening, post-processing, view direction, 2D / 3D punching view, etc.), a punching information filling column (including axis position table, equal angle hole distribution table and hole circumferential angle table, where the equal angle hole distribution table contains array B k Table, Combination C iTable and hole row table), as well as some control buttons; the functions of each part are introduced below:

[0094] 1) Save and open project files: This function can save the X / Y / Z / B position table and the equal angle hole distribution table (including array B k Table, Combination C i The information in the table and hole row table) is saved and opened in CSV files, which is convenient for saving and subsequent use of project files;

[0095] 2) POST post-processing function: you can select the post-processing file and quickly output the NC code;

[0096] 3) View function: mainly used for viewing models and punching positions, and can quickly change viewing angles;

[0097] 4) Hole 2D / 3D view function: When the 2D view function is checked, all hole circumferential positions will be displayed in the XY plane through straight lines; when the 3D view function is checked, all hole positions will be displayed through 3D stereoscopic views; when the 3D actual drilling view function is checked, for complex double-compound angle drilling, VBA will quickly switch to the actual drilling position based on the five-axis linkage of the device;

[0098] 5) Hole X / Y / Z / B axis position table: This table contains 6 pieces of information (coordinate system according to the right-hand rule), namely hole row information (already filled in), punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B (rotation about Y axis), rotation angle A (rotation about X axis), and the order of A and B axis rotation can be selected according to the design drawing (check the selected column);

[0099] 6) Distribution table of equal angle holes: Array B k The table has three columns, array B k Name B1~B k , number of holes, number of vacant holes; combination C i The table has two columns, combination C i Name C1~C i , and each combination C i Specific combination (expression); and the hole row table contains the number of rows, starting angle, hole angle, hole row combination, the table design is consistent with the principle of equal angle hole distribution described in Example 2, and the relevant information is filled in as needed by processing the design table data;

[0100] 7) Hole circumferential angle table: This table is mainly used to display the circumferential distribution angle of each hole after VBA calculation (arranged by hole);

[0101] 8) Punching path parameter table: mainly used to display the parameters that need to be set for the punching path, including hole row (automatically filled), punching method (circular cutting / drilling), hole diameter, punching rate, drilling time, number of punching times, hole retraction distance (between holes), focus position, and safe retraction information (including retraction axis selection and retraction distance between hole rows);

[0102] By pre-installing this tool in the CAD software, the punching path drawing method described in Example 1 or 2 can be conveniently and efficiently implemented, and the complex punching information on the circularly distributed air film holes can be quickly and accurately expressed, thereby improving the generation efficiency, accuracy and quality of CNC programming of the circularly distributed dense air film holes.

[0103] The same or similar reference numerals correspond to the same or similar components;

[0104] The terms used in the drawings to describe positional relationships are only used for illustrative purposes and should not be construed as limiting this patent;

[0105] Obviously, the above embodiments of the present invention are merely examples for clearly illustrating the present invention, and are not intended to limit the embodiments of the present invention. For those skilled in the art, other different forms of changes or modifications can be made based on the above description. It is not necessary and impossible to list all the embodiments here. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the claims of the present invention.

Claims

1. A method for drawing a dense air film hole punching path based on VBA programming, characterized in that: The air film holes in the same row are distributed in a circular pattern, and the method comprises the following steps: S1: Create a table in the VBA module preset in the CAD software, obtain the punching design table of dense air film holes, and extract the punching information and fill it into the first position of the table; the punching information includes: hole row information, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B, rotation angle A, and the rotation sequence of the punching swing angle B and rotation angle A; determine the starting and ending punching positions of each air film hole according to the punching information, express the punching positions of all air film holes in the corresponding row as equal-angle hole distribution, obtain the equal-angle hole distribution information and fill it into the S2: the second position of the table; the equal angle hole distribution information includes: the starting punching angle of each exhaust film hole, the angle between adjacent equal angle holes, and the arrangement and combination information of the punching position and the vacant hole position equal angle holes; S3: Calculate the circumferential angle of each exhaust film hole using a VBA algorithm according to the equal-angle hole distribution information and fill it into the third position of the table; S4: Obtain the punching path parameters of each exhaust film hole and fill in the fourth position of the table, obtain the final table and import it into the CAD software, generate the punching path, and complete the drawing of the dense air film hole punching path.

2. According to a VBA programming-based method for drawing dense air film hole punching paths according to claim 1, it is characterized in that: In the step S1, a drilling design table of dense air film holes is obtained, and the coordinate system includes an X-axis, a Y-axis and a Z-axis distributed according to the right-hand rule.

3. The method for drawing a dense air film hole punching path based on VBA programming according to claim 2 is characterized in that: In step S1, the axial distance of each air film hole is extracted as the Z coordinate of the hole, and half of the radial position of each air film hole is extracted as the X coordinate or Y coordinate of the hole, and the X coordinate is calculated according to the X coordinate. 2 +Y 2 =R 2 Calculate the Y coordinate or X coordinate of the punch hole, where X, Y and R are the X coordinate of the punch hole, the Y coordinate of the punch hole and the radius of the circle where the air film hole is located respectively; extract the punch hole swing angle of each air film hole rotated about the Y axis as the punch hole swing angle B, and extract the rotation angle of each air film hole rotated about the X axis as the rotation angle A.

4. The method for drawing a dense air film hole punching path based on VBA programming according to claim 3 is characterized in that: The step S1 also includes extracting the aperture of each air film hole, clustering the air film holes with exactly the same aperture, punching X coordinate, punching Y coordinate, punching Z coordinate, punching swing angle B and rotation angle A into the same row of air film holes, and using the number of clustered categories as the hole row information.

5. The method for drawing a dense air film hole punching path based on VBA programming according to claim 4 is characterized in that: In the step S1, if the rotation angle A shows the punching swing angle B, the rotation angle A is rotated first, otherwise, the punching swing angle B is rotated first.

6. The method for drawing dense air film hole punching paths based on VBA programming according to claim 5, characterized in that: In the step S2, the equal-angle holes include actual holes and vacant holes; The angle between the starting punching position of each exhaust film hole and the coordinate axis is taken as the starting punching angle, and the corresponding coordinate axis is taken as the 0° angle baseline; According to the evenly distributed number of holes or a given angle of each air film hole, the angle between adjacent holes with equal angles is determined, and the punching positions of all air film holes in the corresponding row are converted into actual hole positions and vacant hole positions that are evenly spaced according to the angle; The actual holes and vacant holes are grouped, and several two-dimensional arrays B are constructed correspondingly. k , the kth array B k Expressed as: B k (m k , n k ), where m k and n k They represent the actual number of holes and the number of vacant holes in the corresponding group. During processing, first drill holes m k Actual holes, n vacancies at the end k vacant holes; For the punching position of the i-th exhaust film hole, the array B k Perform permutations and combinations to construct the corresponding combination C i , all arrays B k and combination C i The arrangement and combination information of holes with equal angles are saved together.

7. The method for drawing dense air film hole punching paths based on VBA programming according to claim 6, characterized in that: In step S3, the circumferential angle range of each exhaust film hole is 0 to 360 degrees, and they are arranged from small to large and filled into the third position of the table.

8. The method for drawing dense air film hole punching paths based on VBA programming according to claim 6, characterized in that: The step S3 further includes: according to the circumferential angle of each exhaust film hole, using a 3D straight line in the view window of the CAD software to indicate the punching position of each air film hole; Or display the 2D plane distribution diagram of all air film hole drilling positions in the view window of the CAD software.

9. A method for drawing dense air film hole punching paths based on VBA programming according to any one of claims 1 to 8, characterized in that: In step S4, the punching path parameters include: the aperture of each exhaust film hole, the punching method, the punching rate, the drilling time, the number of punching times, the hole retraction distance, the focus position, the retraction axis information and the retraction distance between the hole rows.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps in the method according to any one of claims 1 to 9 are implemented.

Images