CN111783217B - Automatic size obtaining method for machined part blanks based on CATIA VBA - Google Patents
Automatic size obtaining method for machined part blanks based on CATIA VBA Download PDFInfo
- Publication number
- CN111783217B CN111783217B CN202010412490.1A CN202010412490A CN111783217B CN 111783217 B CN111783217 B CN 111783217B CN 202010412490 A CN202010412490 A CN 202010412490A CN 111783217 B CN111783217 B CN 111783217B
- Authority
- CN
- China
- Prior art keywords
- catia
- vba
- machined part
- blank
- width
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F30/00—Computer-aided design [CAD]
- G06F30/10—Geometric CAD
- G06F30/15—Vehicle, aircraft or watercraft design
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01B—MEASURING LENGTH, THICKNESS OR SIMILAR LINEAR DIMENSIONS; MEASURING ANGLES; MEASURING AREAS; MEASURING IRREGULARITIES OF SURFACES OR CONTOURS
- G01B11/00—Measuring arrangements characterised by the use of optical techniques
- G01B11/02—Measuring arrangements characterised by the use of optical techniques for measuring length, width or thickness
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01B—MEASURING LENGTH, THICKNESS OR SIMILAR LINEAR DIMENSIONS; MEASURING ANGLES; MEASURING AREAS; MEASURING IRREGULARITIES OF SURFACES OR CONTOURS
- G01B11/00—Measuring arrangements characterised by the use of optical techniques
- G01B11/02—Measuring arrangements characterised by the use of optical techniques for measuring length, width or thickness
- G01B11/06—Measuring arrangements characterised by the use of optical techniques for measuring length, width or thickness for measuring thickness ; e.g. of sheet material
- G01B11/0608—Height gauges
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Geometry (AREA)
- Theoretical Computer Science (AREA)
- Mathematical Optimization (AREA)
- Computational Mathematics (AREA)
- Mathematical Analysis (AREA)
- Aviation & Aerospace Engineering (AREA)
- Pure & Applied Mathematics (AREA)
- Computer Hardware Design (AREA)
- Evolutionary Computation (AREA)
- General Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- General Factory Administration (AREA)
- A Measuring Device Byusing Mechanical Method (AREA)
Abstract
The application relates to the technical field of aerospace, and discloses a method for automatically acquiring the size of a machined part blank based on CATIA VBA, which avoids repeated operation of using a CATIA measuring tool for multiple times, has stable program and high execution speed, improves the working efficiency of structural design and proofreading personnel, and also reduces human errors when the designer and the proofreading personnel fill and count the size of the machined part blank.
Description
Technical Field
The application relates to the technical field of aerospace, in particular to a method for automatically acquiring the size of a blank of a machined part based on CATIA VBA.
Background
With the improvement of the digital design and manufacturing capability, the development method of the airplane is fundamentally transformed from the traditional serial design based on a physical prototype to the parallel design based on an electronic prototype. At present, the CATIA three-dimensional digital modeling technology is widely applied in the aerospace field. In the design of the airplane, the structural design of the airplane body plays an important role, and the proportion of the machined part in the modeling of the airplane body structure is large, so that the statistics of the size of the rough material of the machined part has important significance on the control of the manufacturing cost of the airplane.
According to the traditional wool size statistical method, a designer and a corrector need to call a CATIA measuring tool or a part enveloping body command repeatedly for multiple times to obtain the value of the minimum size box, and then the value is increased on the basis of the value of the minimum size box according to a certain machining allowance. For the large number of machined parts present in an aircraft structure, this method requires a lot of time and effort from the designers and correctors during use, while being prone to human error in repetitive operation.
Disclosure of Invention
In order to overcome the problems and the defects of low manual efficiency, complex steps, non-standard calculation process and the like of counting the sizes of the blanks of the machined parts in the prior art, the application provides a method for automatically acquiring the sizes of the blanks of the machined parts based on a CATIA VBA secondary development technology.
In order to achieve the above object, the technical solution of the present application is as follows:
a method for automatically acquiring the size of a blank of a machined part based on CATIA VBA is characterized by comprising the following steps: the method specifically comprises the following steps:
s1, creating and filling an EXCEL form;
s2, acquiring the number of all CATIA documents under the CATIA structure tree;
s3, establishing circulation, setting the working platform as a current Part document, and creating a geometric figure set of a 'measuring minimum size box';
s4, in the geometric figure set, establishing an inertia main shaft to obtain an extreme point and calculating to obtain the measured values of the length, the width and the height of the minimum size box;
s5, filling the length, width and height measurement values into an EXCEL form;
s6, deleting the geometric figure set of the 'measuring minimum size box' created in the step S3;
and S7, processing the length, width and height measurement values in the EXCEL table to finally obtain the size of the blanks of the machined parts and exiting the circulation.
Preferably, in the step S2, all documents under the assembly structure tree are acquired through the catia.
Preferably, the specific operation of step S3 is: establishing a loop, if the document type name is PartDocument, setting the document as a working platform, creating a geometric figure set of a 'measuring minimum size box', and setting the geometric figure set as the working platform; if the document type name is ProductDocument, the document is skipped.
Preferably, the step S4 is to complete the measurement in the geometry set created in step S3, and specifically includes the following steps:
s4.1, acquiring gravity center values, namely Gx, Gy and Gz, of a current part and Inertia main shaft direction matrix values, namely A1x, A1y, A1z, A2x, A2y, A2z, A3x, A3y and A3z, by a GetPricipal axes method of a CATIA Inertia object;
s4.2, creating an inertia main shaft A1 by taking the gravity center of the part as an origin through the gravity center and the inertia direction of the part, wherein the coordinates of the origin are BBOX, BBOY and BBOZ;
s4.3, creating a maximum extreme point and a minimum extreme point in the X, Y, Z direction in the A1 shafting through an extreme point command;
and S4.4, performing coordinate transformation on the 6 extreme point coordinates created in the step S4.3, transforming the coordinates to inertia shafting coordinates, and respectively solving absolute values of differences between the extreme point coordinates in all directions, namely the measured values of the length, the width and the height of the minimum size box.
Preferably, the step S7 specifically includes the following steps:
s7.1, matching the measured values of length, width and height in the EXCEL table with the minimum value of 3 persons as the standard of the thickness dimension of the wool, and judging the material stock specification closest to the minimum value of the minimum size box as the thickness dimension specification of the wool; the other two measurements were each increased by 10mm and then rounded to a factor of just greater than 5 of their value, satisfying the principle of minimizing the size of the batt, with the larger value being taken as the length and the smaller value being taken as the width.
And S7.2, filling the size of the obtained machined part blank into an EXCEL table.
Preferably, the EXCEL form created in step S1 fills in the assembly name, the path where the CATIA file is located, the date, the creator name, the part name, and the measured value.
The beneficial effect of this application:
according to the method, through the CATIA VBA secondary development technology, the mode that the loaded down with trivial details manual measuring machine adds the minimum size box numerical value of the part and manually calculates the size of the part blank is greatly simplified, the mode is changed into one-key automatic and quick measurement, human errors caused by repetitive operation are reduced, the efficiency of design and proofreading personnel is improved, meanwhile, the calculation method of the size of the blank is specified, and the size of the blank measured by different designers is facilitated to be unified.
Drawings
FIG. 1 is a flow chart of the method of the present application.
Detailed Description
The present application will be described in further detail with reference to examples, but the embodiments of the present application are not limited thereto.
Example 1
The embodiment discloses a method for automatically acquiring the size of a blank of a machined part based on CATIA VBA, which specifically comprises the following steps:
s1, creating and filling an EXCEL form:
s1.1, creating a blank table;
s1.2, changing colors and fonts of B2: F5 areas, combining partial areas, filling required information into a form, wherein the filled content comprises an assembly name, a CATIA file located path, a date, a creator name, a part name, a measured value and the like.
S2, acquiring the number of all CATIA documents under the CATIA structure tree:
and acquiring all documents under the assembly structure tree through a CATIA.
S3, establishing circulation, setting the working platform as a current Part document, and creating a geometric figure set of a 'measuring minimum size box':
establishing a loop, if the document type name is PartDocument, setting the document as a working platform, creating a geometric figure set of a 'measuring minimum size box', and setting the geometric figure set as the working platform; if the document type name is ProductDocument, the document is skipped.
S4, completing measurement work in the geometric figure set created in the step S3: obtaining extreme points by establishing an inertia main shaft and calculating to obtain BBLX, BBLY and BBLZ values of a minimum size box, namely measured values of length, width and height, and specifically operating as follows:
s4.1, acquiring gravity center values, namely Gx, Gy and Gz, of a current part and Inertia main shaft direction matrix values, namely A1x, A1y, A1z, A2x, A2y, A2z, A3x, A3y and A3z, by a GetPricipal axes method of a CATIA Inertia object;
s4.2, creating an inertia main shaft A1 by taking the gravity center of the part as an origin through the gravity center and the inertia direction of the part, wherein the coordinates of the origin are BBOX, BBOY and BBOZ;
s4.3, creating a maximum extreme point and a minimum extreme point in the X, Y, Z direction in the A1 shafting through an extreme point command;
and S4.4, performing coordinate transformation on the 6 extreme point coordinates created in the step S4.3, transforming the coordinates into inertia shafting coordinates, and respectively solving absolute values of differences among the extreme point coordinates in all directions, namely the length, width and height measured values of the minimum size box, namely BBLX, BBLY and BBLZ.
S5, filling the length, width and height measurement values in the step S4, namely BBLX, BBLY and BBLZ values into an EXCEL table respectively;
s6, deleting the geometric figure set of the 'measuring minimum size box' created in the step S3;
s7, processing the length, width and height measurement values in the EXCEL table according to a certain rule, finally obtaining the size of the blank of the machined part and exiting the cycle:
s7.1, matching the BBLX, BBLY and BBLZ values measured in the EXCEL table, namely the length, width and height measurement values with the minimum value of 3 as the thickness size standard of the wool, with the existing material stock of a material purchasing department, and judging the material stock specification closest to the minimum value of the minimum size box as the thickness size specification of the wool; the other two measured values are firstly respectively increased by 10mm and then rounded to be more than the nearest multiple of 5 of the measured values, so that the principle of minimizing the size of the wool is met, wherein the larger value is taken as the length, and the smaller value is taken as the width;
for example, if the measured dimension is 91mm, then first 10mm is added to 101mm, taking a value greater than 101mm and a nearest multiple of 5, i.e., 105 mm; if the measured size is 96mm, the value increased by 10mm is 106mm, and the value which is larger than 106mm and is a multiple of the nearest 5 is taken as 110 mm;
and S7.2, filling the blank size of the obtained machined part into the EXCEL table created in the step S1.
In the description of the present application, it is to be understood that the terms "center", "longitudinal", "lateral", "front", "back", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", and the like indicate orientations or positional relationships based on those shown in the drawings, and are used merely for convenience in describing the present application and for simplifying the description, and do not indicate or imply that the referenced device or element must have a particular orientation, be constructed in a particular orientation, and be operated, and therefore should not be construed as limiting the scope of the present application.
The foregoing is directed to embodiments of the present invention, which are not limited thereto, and any simple modifications and equivalents thereof according to the technical spirit of the present invention may be made within the scope of the present invention.
Claims (5)
1. A method for automatically acquiring the size of a blank of a machined part based on CATIA VBA is characterized by comprising the following steps: the method specifically comprises the following steps:
s1, creating and filling an EXCEL form;
s2, acquiring the number of all CATIA documents under the CATIA structure tree;
s3, establishing circulation, setting the working platform as a current Part document, and creating a geometric figure set of a 'measuring minimum size box';
s4, in the geometric figure set, establishing an inertia main shaft to obtain an extreme point and calculating to obtain the measured values of the length, the width and the height of the minimum size box;
s5, filling the length, width and height measurement values into an EXCEL form;
s6, deleting the geometric figure set of the 'measuring minimum size box' created in the step S3;
s7, processing the length, width and height measurement values in the EXCEL table to finally obtain the size of the blanks of the machined parts and quitting circulation;
the step S7 specifically includes the following steps:
s7.1, matching the measured values of length, width and height in the EXCEL table with the minimum value of 3 persons as the standard of the thickness dimension of the wool, and judging the material stock specification closest to the minimum value of the minimum size box as the thickness dimension specification of the wool; the other two measured values are respectively increased by 10mm and then rounded to be just more than the multiple of 5 of the measured values, so that the principle of minimizing the size of the wool is met, wherein the larger value is taken as the length, and the smaller value is taken as the width;
and S7.2, filling the size of the obtained machined part blank into an EXCEL table.
2. The automatic acquisition method of the dimension of the blank of the machined part based on the CATIA VBA of claim 1, which is characterized in that: in the step S2, all documents under the assembly structure tree are obtained through the catia.
3. The automatic acquisition method of the dimension of the blank of the machined part based on the CATIA VBA of claim 1, which is characterized in that: the specific operation of step S3 is: establishing a loop, if the document type name is PartDocument, setting the document as a working platform, creating a geometric figure set of a 'measuring minimum size box', and setting the geometric figure set as the working platform; if the document type name is ProductDocument, the document is skipped.
4. The automatic acquisition method of the dimension of the blank of the machined part based on the CATIA VBA of claim 1, which is characterized in that: the step S4 is to complete the measurement in the geometry set created in the step S3, and specifically includes the following steps:
s4.1, acquiring gravity center values, namely Gx, Gy and Gz, of a current part and Inertia main shaft direction matrix values, namely A1x, A1y, A1z, A2x, A2y, A2z, A3x, A3y and A3z, by a GetPricipal axes method of a CATIA Inertia object;
s4.2, creating an inertia main shaft A1 by taking the gravity center of the part as an origin through the gravity center and the inertia direction of the part, wherein the coordinates of the origin are BBOX, BBOY and BBOZ;
s4.3, creating a maximum extreme point and a minimum extreme point in the X, Y, Z direction in the A1 shafting through an extreme point command;
and S4.4, performing coordinate transformation on the 6 extreme point coordinates created in the step S4.3, transforming the coordinates to inertia shafting coordinates, and respectively solving absolute values of differences between the extreme point coordinates in all directions, namely the measured values of the length, the width and the height of the minimum size box.
5. The automatic acquisition method of the dimension of the blank of the machined part based on the CATIA VBA of claim 1, which is characterized in that: the EXCEL form created in step S1 contains the assembly name, the path of the CATIA file, the date, the creator name, the part name, and the measured value.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010412490.1A CN111783217B (en) | 2020-05-15 | 2020-05-15 | Automatic size obtaining method for machined part blanks based on CATIA VBA |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202010412490.1A CN111783217B (en) | 2020-05-15 | 2020-05-15 | Automatic size obtaining method for machined part blanks based on CATIA VBA |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111783217A CN111783217A (en) | 2020-10-16 |
CN111783217B true CN111783217B (en) | 2022-05-10 |
Family
ID=72754075
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202010412490.1A Active CN111783217B (en) | 2020-05-15 | 2020-05-15 | Automatic size obtaining method for machined part blanks based on CATIA VBA |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111783217B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN117874967B (en) * | 2024-03-12 | 2024-06-21 | 季华实验室 | Rapid estimation method for blank size, die size and die tonnage |
Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106767237A (en) * | 2016-11-23 | 2017-05-31 | 沈阳黎明航空发动机(集团)有限责任公司 | A kind of processing method for controlling moving turbine blade tenon tooth wall thickness |
Family Cites Families (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP4044958B2 (en) * | 2003-07-10 | 2008-02-06 | 株式会社森精機製作所 | Automatic programming equipment |
CN106484995A (en) * | 2016-09-30 | 2017-03-08 | 华中科技大学无锡研究院 | A kind of generation method of the GB standard BOM based on CATIA |
CN108984501A (en) * | 2018-06-20 | 2018-12-11 | 英纳法企业管理(上海)有限公司 | A kind of quotation Parts List BOM automatic generation method and system |
CN109558647B (en) * | 2018-11-07 | 2023-01-13 | 中国航空工业集团公司西安飞机设计研究所 | CATIA-based rapid modeling method for similar parts |
CN110795797B (en) * | 2019-09-26 | 2021-06-18 | 北京航空航天大学 | MBD model processing feature recognition and information extraction method |
-
2020
- 2020-05-15 CN CN202010412490.1A patent/CN111783217B/en active Active
Patent Citations (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106767237A (en) * | 2016-11-23 | 2017-05-31 | 沈阳黎明航空发动机(集团)有限责任公司 | A kind of processing method for controlling moving turbine blade tenon tooth wall thickness |
Also Published As
Publication number | Publication date |
---|---|
CN111783217A (en) | 2020-10-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
Prisco et al. | Overview of current CAT systems | |
CN102105908B (en) | Method and device for production of master pattern tool | |
CN105467927B (en) | It is a kind of that forging and casting processing positioning method of crossing is exempted from based on registration alignment | |
CN113341882B (en) | Numerical control process design and optimization method based on processing knowledge | |
CN111783217B (en) | Automatic size obtaining method for machined part blanks based on CATIA VBA | |
CN107562015B (en) | Process geometric model construction method based on numerical control machining programming | |
CN103128521B (en) | Method of ensuring part processing benchmark and special tooling ball | |
CN107322008A (en) | The three-dimensional modeling method of machined surface in a kind of turning technique | |
CN110837715A (en) | Complex curved surface machining error compensation method based on reverse engineering technology | |
CN101949680B (en) | Method for designing blade standard component for profile measurement | |
CN101750043A (en) | Method for measuring 3D profile surface by trigger measuring head on measuring machine | |
CN103065020A (en) | Method for applying CAD (computer-aided design) drawing to precision finger-type milling cutter for involute gears | |
CN106681277B (en) | Interference and collision detection method and device in a kind of bend pipe process | |
CN106447781B (en) | It is a kind of based on Minkowski and towards the collision checking method of automatic assembling | |
CN112906215A (en) | Pipe tool path generation method based on SolidWorks secondary development | |
CN102147221A (en) | Three-coordinate measuring method of blade with T-shaped root | |
CN108763693B (en) | Ship equipment weight distribution statistical method based on three-dimensional model | |
CN110238699A (en) | Mechanical processing and positioning system and method without the large-scale double-deck complex curved surface part of benchmark | |
CN111069973A (en) | Method and device for quickly aligning complex-shape casting | |
CN107977502B (en) | Cylindrical workpiece spiral machining section profile calculation method based on OpenGL | |
US20200166330A1 (en) | Component machining apparatus | |
CN115470597A (en) | Clamp automatic assembly program design method, electronic device and storage medium | |
CN106134469B (en) | A kind of numerical control program critique system and method for simulating central track of cutter | |
JP2011145876A (en) | Die production method and creation method for die machining data | |
Legge | Integration of design and inspection systems-a literature review |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |