Hard alloy drill bit design system and method

Abstract

The invention belongs to the technical field of computer aided design, and particularly relates to a hard alloy drill bit design system and method. According to the high-quality alloy drill bit design system and method, CAD secondary development and an ACCESS database are combined, firstly, rich design experience of technicians is integrated into the background ACCESS database, when a user uses the high-quality alloy drill bit, information such as the diameter of a drill bit needing to be designed and a machined material is input through a user interface, and then the designed high-quality alloy drill bit is obtained. The system recommends the most appropriate drill tip type and calculates appropriate geometric parameters; through a program embedded in a CAD background, drawing geometric parameters of historical products are captured, and database contents are continuously expanded and perfected, so that the output contents are more accurate; through the system, the requirements of factories for designers are reduced, the efficiency of drawing CAD design drawings is improved, and the error rate of drawing parameters is reduced; and the one-time success rate of product design by designers is improved.

Description

Technical Field

[0001] The invention belongs to the technical field of computer-aided design, and in particular relates to a carbide drill bit design system and method. Background Art

[0002] Carbide drills are widely used in the field of metal processing, but their design process is complex and depends on the experience of designers. In the traditional design method, designers manually calculate the appropriate design parameters based on parameters such as workpiece material, drill diameter and length, and perform CAD drawing. This manual design process is not only time-consuming and labor-intensive, but also prone to design errors due to lack of experience. With the increasing demand for efficient and high-precision drill design in modern manufacturing, how to use advanced technical means to improve design efficiency and accuracy has become a research hotspot.

[0003] The development of big data technology has made automated design possible. By accumulating and analyzing previous design data, a model that can automatically generate design parameters can be formed, thereby greatly improving the automation level of drill bit design. Secondary development based on VBA can be seamlessly integrated with the CAD system to achieve a fully automated design process from data input to design output. Summary of the invention

[0004] The object of the present invention is to provide a carbide drill design system and method.

[0005] In order to solve the above technical problems, the present invention provides a cemented carbide drill design system, comprising:

[0006] Data acquisition and sorting module, used to collect and sort carbide drill design data;

[0007] Data analysis and model building module, which is used to build a model based on carbide drill design data that can automatically match and recommend the most appropriate design parameters according to drill diameter, length, working conditions and processed materials;

[0008] VBA development and integration module, which is used to automatically call the database model to calculate the most suitable design parameters and recommend them to the user based on the user's input of the drill diameter, basic working conditions and processed materials in Haochen CAD;

[0009] The automatic drawing module is used to automatically input the calculated design parameters into CAD and generate the corresponding drill design drawings.

[0010] In one embodiment of the present application, the method for collecting and arranging cemented carbide drill bit design data includes:

[0011] Design experience input: According to the fixed input method, the design experience is manually input into the background database; the input data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill bit, as well as the corresponding processed materials, tool forms, and diameter range; this item accounts for 60%;

[0012] The data is collected by the system embedded in the CAD background: the drawings use fixed CAD template files, and each product has a corresponding drawing number. This unique drawing number is connected to the company's order system. When the drawing is completed, the CAD background system will automatically upload all drawing parameters to the database in 2.1 above; the data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill bit, as well as the corresponding processed materials, tool forms, and diameter range; this item accounts for 20%;

[0013] The design is based on the geometric parameters of standard drills from major carbide tool manufacturers: the data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill, as well as the corresponding processed materials, tool types, and diameter ranges; this item accounts for 20%.

[0014] In one embodiment of the present application, the automatic matching and recommendation method includes:

[0015] After the user inputs the corresponding tool specifications, diameter and processed material information in the interactive interface, the system will recommend one or several drill types with the highest matching degree based on the input information and after querying the database;

[0016] The CAD database is set up with a unique drawing number linked to the company's order information. After the user enters the product specifications and processed material information, the system will recommend appropriate geometric parameters and structural designs to the user based on the product's order situation.

[0017] In one embodiment of the present application, the carbide drill bit design system further includes a database self-optimization module;

[0018] The method for database self-optimization comprises:

[0019] Automatic system optimization: When the order quantity of a certain product from the client is larger, the corresponding drill tip parameters and structural designs used in this order will be ranked higher and will appear in the top rankings. Users only need to select the top recommendations.

[0020] Manual intervention optimization: When a type of geometric parameters changes multiple times with the use of the product, the administrator can manually intervene in the data in the background database to adjust the corresponding parameter ratios, materials, and coating usage.

[0021] Accordingly, the present invention provides a design method using the cemented carbide drill bit design system as described above, comprising:

[0022] Input the diameter and length of the drill bit and the material to be processed in the human-computer interaction interface;

[0023] The system integrates and analyzes the collected information;

[0024] Query the most suitable drill bit parameters and structure through the database;

[0025] Output the calculated geometric parameters to the CAD human-machine interface;

[0026] After confirmation by the designer, the design drawing of the drill bit is automatically generated and the parameters are written into the CAD drawing.

[0027] The beneficial effect of the present invention is that the alloy drill bit design system and method of the present invention are combined with CAD secondary development and ACCESS database. First, the rich design experience of the technicians is integrated into the background ACCESS database. When the user uses it, the system will input the information such as the drill diameter and the processed material to be designed through the user interface, and the system will recommend the most suitable drill tip type and calculate the appropriate geometric parameters; through the program embedded in the CAD background, the drawing geometric parameters of historical products are captured, and the database content is continuously expanded and improved to make the output content more accurate; through this system, the factory's requirements for designers are reduced, the efficiency of drawing CAD design drawings is improved, and the error rate of drawing parameters is reduced; the one-time success rate of designers in designing products is improved.

[0028] Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention are realized and obtained by the structures particularly pointed out in the description, claims and drawings.

[0029] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0031] Figure 1 Design a flow chart for the system of the present invention;

[0032] Figure 2 is a flow chart of the system operation of the present invention;

[0033] Figure 3 It is a schematic diagram of the user interaction interface of the system part of the present invention. DETAILED DESCRIPTION

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

[0035] At present, the design of the structure and geometric parameters of carbide drills basically relies on manual calculations and the experience of designers. On the one hand, if the success rate of the designed product is to be high, the experience requirements of the designers are very high (more than two years of design experience); on the other hand, frequent calculations can easily lead to parameter errors, resulting in product scrapping, etc.; and the efficiency is low, requiring multiple levels of review and proofreading, which invisibly increases management costs.

[0036] The purpose of the present invention is to provide a CAD carbide drill design system and method based on VBA secondary development, which automatically calculates and generates the most suitable drill design parameters and geometric structure by utilizing big data technology, and then completes automatic drawing in CAD to solve the problems of low efficiency and large errors existing in traditional design methods.

[0037] In one embodiment, a carbide drill bit design system includes: a data acquisition and organization module for collecting and organizing carbide drill bit design data; a data analysis and model building module for building a model based on the carbide drill bit design data that can automatically match and recommend the most suitable design parameters according to the drill bit diameter, length, working conditions and processed materials; a VBA development and integration module for automatically calling the database model to calculate the most suitable design parameters and recommend them to the user after the user inputs the drill bit diameter, basic working conditions and processed materials in Haochen CAD; an automatic drawing module for automatically inputting the calculated design parameters into CAD and generating corresponding drill bit design drawings.

[0038] In this embodiment, the data collection and organization module is used to draw on the design experience of experienced designers on drill bits under different working conditions and different processed materials, collect and organize the design data of carbide drill bits; by collecting the geometric parameters of standard carbide drill bits of major brands; collecting the product geometric parameters of historical successful cases; summarizing them into a database to form a database of geometric parameters and drill bit structures that can be analyzed; data collection includes automatic collection by CAD background and manual entry by technical personnel; recommended data includes geometric parameter design, post-processing methods, material selection, coating selection, etc.

[0039] Specifically, the method for collecting and arranging carbide drill bit design data includes:

[0040] 1) Data entry by experienced technicians: The technicians manually enter their experience into the background database according to a fixed input method. The data includes the structural characteristics, geometric parameters, post-processing methods, material / coating selection of the drill bit; the corresponding processed materials, tool form, diameter range, etc. This accounted for 60%;

[0041] 2) Data is collected by the system embedded in the CAD background: Drawings use fixed CAD template files, and each product has a corresponding drawing number. This unique drawing number is connected to the company's order system. When the drawing is completed, the CAD background system will automatically upload all drawing parameters to the database in 2.1 above; the data includes the structural characteristics, geometric parameters, post-processing methods, material / coating selection of the drill bit; the corresponding processed materials, tool form, diameter range, etc.; this item accounts for 20%; as the system is used for a longer time, the proportion of this part of the data will increase;

[0042] 3) Design by absorbing the standard drill geometry parameters of major mainstream carbide tool manufacturers; the data includes the structural characteristics, geometric parameters, post-processing methods of the drill; the corresponding processed materials, tool types, diameter range, etc.; this item accounts for 20%.

[0043] In this embodiment, the data analysis and model building module is used to process the collected data through data analysis technology to establish a model that can automatically match and recommend the most appropriate design parameters based on the drill diameter, length, working conditions and processed materials; the model is optimized using a regression analysis algorithm.

[0044] Specifically, the automatic matching and recommendation method includes:

[0045] 4) After the user inputs the corresponding tool specifications, diameter and processed material information in the interactive interface, the system will recommend one or several drill types with the highest matching degree based on the input information and after querying the database;

[0046] 5) Since the CAD database has a unique drawing number linked to the company's order information, after the user enters the product specifications and processed material information, the system will recommend appropriate geometric parameters and structural designs to the user based on the product's order situation (number of orders and order quantity, based on the principle that the more orders and order quantities, the more suitable the structure and parameters are for the current working conditions);

[0047] Furthermore, the carbide drill bit design system also includes a database self-optimization module;

[0048] The method for database self-optimization comprises:

[0049] 6) Automatic system optimization: When the order quantity of a certain product from the client is larger, the ranking of the corresponding drill tip parameters and structural design used in this order will be higher, and the more it will appear in the top rankings. Users only need to select the top ranking recommendations;

[0050] 7) Manual intervention optimization: When a type of geometric parameters changes multiple times during product use, the administrator can manually intervene in the data in the background database to adjust the corresponding parameter ratios, materials, coating usage, etc.

[0051] Correspondingly, such as Figure 2 As shown, in one embodiment of the present application, a design method using the cemented carbide drill bit design system as described above may include:

[0052] Input the diameter and length of the drill bit and the material to be processed in the human-computer interaction interface;

[0053] The system integrates and analyzes the collected information;

[0054] Query the most suitable drill bit parameters and structure through the database;

[0055] Output the calculated geometric parameters to the CAD human-machine interface;

[0056] After confirmation by the designer, the design drawing of the drill bit is automatically generated and the parameters are written into the CAD drawing.

[0057] In summary, the alloy drill bit design system and method of the present invention are combined with CAD secondary development and ACCESS database. First, the rich design experience of the technicians is integrated into the background ACCESS database. When the user uses it, the system will input the drill diameter, processed material and other information to be designed through the user interface, and the system will recommend the most suitable drill tip type and calculate the appropriate geometric parameters; through the program embedded in the CAD background, the drawing geometric parameters of historical products are captured, and the database content is continuously expanded and improved to make the output content more accurate; through this system, the factory's requirements for designers are reduced, the efficiency of drawing CAD design drawings is improved, and the error rate of drawing parameters is reduced; the one-time success rate of designers in designing products is improved.

[0058] Before using this system, the average time to draw a drill CAD design drawing was between 20 and 30 minutes. With the support of the system, the current drawing time is 2-3 minutes, which is 10 times faster.

[0059] In several embodiments provided in the present application, it should be understood that the disclosed devices and methods can also be implemented in other ways. The device embodiments described above are merely schematic. For example, the flowcharts and block diagrams in the accompanying drawings show the possible architecture, functions and operations of the devices, methods and computer program products according to multiple embodiments of the present invention. In this regard, each box in the flowchart or block diagram can represent a module, a program segment or a part of a code, and the module, a program segment or a part of a code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two consecutive boxes can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or flowchart, and the combination of boxes in the block diagram and / or flowchart can be implemented with a dedicated hardware-based system that performs a specified function or action, or can be implemented with a combination of dedicated hardware and computer instructions.

[0060] In addition, the functional modules in the various embodiments of the present invention may be integrated together to form an independent part, or each module may exist independently, or two or more modules may be integrated to form an independent part.

[0061] If the functions are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for enabling a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0062] Based on the above ideal embodiments of the present invention, the relevant staff can make various changes and modifications without departing from the technical concept of the present invention through the above description. The technical scope of the present invention is not limited to the contents of the specification, and its technical scope must be determined according to the scope of the claims.

Claims

1. A carbide drill bit design system, characterized in that: include: Data acquisition and sorting module, used to collect and sort carbide drill design data; Data analysis and model building module, which is used to build a model based on carbide drill design data that can automatically match and recommend the most appropriate design parameters according to drill diameter, length, working conditions and processed materials; VBA development and integration module, which is used to automatically call the database model to calculate the most suitable design parameters and recommend them to the user based on the user's input of the drill diameter, basic working conditions and processed materials in Haochen CAD; The automatic drawing module is used to automatically input the calculated design parameters into CAD and generate the corresponding drill design drawings.

2. The carbide drill design system according to claim 1, characterized in that: The method for collecting and arranging carbide drill design data comprises: Design experience input: According to the fixed input method, the design experience is manually input into the background database; the input data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill bit, as well as the corresponding processed materials, tool forms, and diameter range; this item accounts for 60%; The data is collected by the system embedded in the CAD background: the drawings use fixed CAD template files, and each product has a corresponding drawing number. This unique drawing number is connected to the company's order system. When the drawing is completed, the CAD background system will automatically upload all drawing parameters to the database in 2.1 above; the data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill bit, as well as the corresponding processed materials, tool forms, and diameter range; this item accounts for 20%; The design is based on the geometric parameters of standard drills from major carbide tool manufacturers: the data includes the structural characteristics, geometric parameters, post-processing methods, material and coating selection of the drill, as well as the corresponding processed materials, tool types, and diameter ranges; this item accounts for 20%.

3. The carbide drill design system according to claim 1, characterized in that: The automatic matching and recommendation method comprises: After the user inputs the corresponding tool specifications, diameter and processed material information in the interactive interface, the system will recommend one or several drill types with the highest matching degree based on the input information and after querying the database; The CAD database is set up with a unique drawing number linked to the company's order information. After the user enters the product specifications and processed material information, the system will recommend appropriate geometric parameters and structural designs to the user based on the product's order situation.

4. The carbide drill design system according to claim 1, characterized in that The carbide drill bit design system also includes a database self-optimization module; The method for database self-optimization comprises: Automatic system optimization: When the order quantity of a certain product from the client is larger, the corresponding drill tip parameters and structural designs used in this order will be ranked higher and will appear in the top rankings. Users only need to select the top recommendations. Manual intervention optimization: When a type of geometric parameters changes multiple times with the use of the product, the administrator can manually intervene in the data in the background database to adjust the corresponding parameter ratios, materials, and coating usage.

5. A design method using the cemented carbide drill bit design system according to any one of claims 1 to 4, characterized in that: include: Input the diameter and length of the drill bit and the material to be processed in the human-computer interaction interface; The system integrates and analyzes the collected information; Query the most suitable drill bit parameters and structure through the database; Output the calculated geometric parameters to the CAD human-machine interface; After confirmation by the designer, the design drawing of the drill bit is automatically generated and the parameters are written into the CAD drawing.

Images