CN104281727A - Method for designing tire die on basis of Excel and CAD (computer aided design) platform - Google Patents
Method for designing tire die on basis of Excel and CAD (computer aided design) platform Download PDFInfo
- Publication number
- CN104281727A CN104281727A CN201410243804.4A CN201410243804A CN104281727A CN 104281727 A CN104281727 A CN 104281727A CN 201410243804 A CN201410243804 A CN 201410243804A CN 104281727 A CN104281727 A CN 104281727A
- Authority
- CN
- China
- Prior art keywords
- excel
- data
- platform
- die
- general assembly
- 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.)
- Pending
Links
Abstract
The invention discloses a method for designing a tire die on the basis of Excel and CAD (computer aided design) platforms. The method comprises the following four steps of generating a die standard drawing, creating an Excel platform data processing base, inputting data and creating a function relationship, and storing the data. The method can also be widely applied to design work for a plurality of dies, the defect that each die is required to be independently calculated and designed in the traditional die design is effectively avoided, and the working efficiency of die design is greatly improved; meanwhile, on one hand, the calculation intensity of related parameters in the traditional die design is reduced, the traditional requirement on drawing precision of the die is weakened, the workload of drawing is reduced, and the die designing efficiency is greatly improved, on the other hand, while the die is designed, making work, such as making a part production technical table can also be finished, the workload of designing traditional die machine processing working procedures and making a working procedure sheet is avoided, the workload of mechanical processing is reduced, and the working efficiency is improved.
Description
Technical field
The present invention relates to a kind of tire-mold method for designing based on Excel and CAD platform, belong to tire meter molds computer-aided design technology field.
Background technology
At present in the design of the moulds such as such as tire-mold is produced, its real process is mainly adjusted by parameter, standard map is drawn, several steps such as manufacture order establishment and production process establishment are formed, wherein adjust in parameter, in standard map drawing process, designer needs to carry out a large amount of data operations and drawing protract work, workload is very heavy, thus result also in computation process and drawing protract process and often occur mistake, and work efficiency also very under, meanwhile, after standard map is completed, also need designer and producers to combine, compile and edit detailed manufacture order and production process table, and the most core work of this process all needs to rely on designer manually to complete, workload is also relatively large, and easily there is the drawback occurring mismate between designer and producers, work efficiency and work quality are comparatively difficult to ensure card, thus cause under Design of Dies work efficiency, easily make mistakes and the great drawback of labour intensity, seriously limit sending out of Design of Dies production to open, simultaneously, in Design of Dies, the part platforms such as such as CAD are also used although current, can reduction workload to a certain degree, and facilitate multiple types to see that data are used mutually like mould, but the technical merit that must still be in very, to inhomogeneity Design of Dies, still need to carry out independent design calculating and drawing course, thus to a large amount of duplication of labour be carried out, also further limit the development of Design of Dies and production, therefore high in the urgent need to developing a kind of automaticity, highly versatile and the novel die of simple operation design and production method.
Summary of the invention
The object of the invention is just to overcome above-mentioned deficiency, provides a kind of tire-mold method for designing based on Excel and CAD platform.
For achieving the above object, the present invention is achieved through the following technical solutions:
Based on a tire-mold method for designing for Excel and CAD platform, comprise the following steps:
The first step: generate mould standard drawing, utilize CAD electronic drafting software platform, according to need of production, draw constitutional detail figure and the general assembly drawing of related die, line parameter of going forward side by side marks, and the parameter marked is the standard value symbol of this parameter name;
Second step: set up Excel platform data process storehouse, create an excel spreadsheet lattice document, then set up successively in the document datamation table, produce under material list worksheet, general assembly drawing worksheet and the part manufacturing procedure worksheet corresponding with part drawing, and in datamation table, set up data correction workspace and general assembly drawing viewing area, need to design according to real work in material list worksheet under production and set up at least one lower material list.
3rd step: data inputting and set up funtcional relationship, first will the drawn general assembly drawing of CAD electronic drafting software platform be utilized to copy in the general assembly drawing viewing area in the datamation table in Excel platform data process storehouse, then according to the related data parameter name standard value symbol that general assembly drawing marks, correlation parameter single data typing form is set up successively in data correction workspace, then will the drawn part drawing of CAD electronic drafting software platform be utilized to copy in Excel platform data process storehouse in corresponding part manufacturing procedure worksheet successively, then the first subdata typing form is set up in the correlation parameter name code corresponding position of part drawing mark, then according to the constitutional detail figure of mould and general assembly drawing quantity and the parameter that corresponds thereof, the second subdata typing form is set up in material list worksheet successively under production, last according to related data parameter name standard value symbol by single data typing form corresponding data, number sequence operating function relational expression is set up according to the logical operation relation between die parameters, then according to related data parameter name standard value symbol, single data typing form corresponding data is set up data directory with same data in the first subdata typing form and the second subdata typing form respectively.
4th step: data are preserved, the Excel platform data process storehouse of setting up funtcional relationship set up is preserved, and when preserving, the encryption function utilizing excel spreadsheet lattice to carry is carried out reading encryption to Excel platform data process storehouse and is revised read-only encryption.
Constitutional detail figure and the general assembly drawing of the mould utilizing CAD electronic drafting software platform to draw are planimetric map three-view diagram.
The constitutional detail figure of the mould utilizing CAD electronic drafting software platform to draw and general assembly drawing are when copying to Excel platform data process storehouse correspondence worksheet, and part drawing and general assembly drawing are all converted into JPG, TIF or PDF.
The Excel platform release form that Excel platform data process storehouse relies on is not higher than Excel2003.
The present invention also can in widespread use and multiple kinds of molds design effort, effectively avoid in traditional moulds design and there is the drawback that often kind of mould all needs to carry out independent calculating design, substantially increase Design of Dies work efficiency, one aspect of the present invention alleviates the calculating strength of correlation parameter in traditional moulds design simultaneously, weaken the requirement of mould tradition cartographic accuracy, decrease drawing workload, thus greatly improve Design of Dies efficiency, on the other hand at Design of Dies simultaneously, also can complete the authorized strength work of part production technology table etc., avoid traditional molding machine manufacturing procedure design and planning sheet authorized strength work amount, decrease machine work workload, improve work efficiency.
Accompanying drawing explanation
Fig. 1 is schematic flow sheet of the present invention;
Fig. 2 is the datamation surface and interface figure schematic diagram carrying out Design of Dies based on the present invention;
Fig. 3 carries out material list worksheet interface schematic diagram under the production of Design of Dies based on the present invention;
Fig. 4 is the general assembly drawing worksheet interface schematic diagram carrying out Design of Dies based on the present invention;
Fig. 5 is any secondary part manufacturing procedure worksheet interface schematic diagram carrying out Design of Dies based on the present invention.
Fig. 6 is the preservation encrypted interface schematic diagram carrying out Design of Dies based on the present invention.
Embodiment
In conjunction with specific design example and description of drawings 1 to Fig. 6, concrete processing technology of the present invention is described in further detail:
The first step: generate mould standard drawing, utilize CAD electronic drafting software platform, according to need of production, draw the constitutional detail figure of related die and the plane three-view diagram of general assembly drawing, line parameter of going forward side by side marks, and the parameter marked is the standard value symbol of this parameter name;
Second step: set up Excel platform data process storehouse, create one based on Excel2000 electronic form document, then set up successively in the document datamation table, produce under material list worksheet, general assembly drawing worksheet and the part manufacturing procedure worksheet corresponding with part drawing, and in datamation table, set up data correction workspace and general assembly drawing viewing area, need to design according to real work in material list worksheet under production and set up at least one lower material list.
3rd step: data inputting and set up funtcional relationship, first will the drawn general assembly drawing format conversion of CAD electronic drafting software platform be utilized to be PDF, then copy in the general assembly drawing viewing area in the datamation table in Excel platform data process storehouse, then according to the related data parameter name standard value symbol that general assembly drawing marks, correlation parameter single data typing form is set up successively in data correction workspace, then will the drawn part drawing of CAD electronic drafting software platform be utilized to copy in Excel platform data process storehouse in corresponding part manufacturing procedure worksheet successively, then the first subdata typing form is set up in the correlation parameter name code corresponding position of part drawing mark, then according to the constitutional detail figure of mould and general assembly drawing quantity and the parameter that corresponds thereof, the second subdata typing form is set up in material list worksheet successively under production, last according to related data parameter name standard value symbol by single data typing form corresponding data, number sequence operating function relational expression is set up according to the logical operation relation between die parameters, then according to related data parameter name standard value symbol, single data typing form corresponding data is set up data directory with same data in the first subdata typing form and the second subdata typing form respectively.
4th step: data are preserved, the Excel platform data process storehouse of setting up funtcional relationship set up is preserved, and when preserving, the encryption function utilizing excel spreadsheet lattice to carry is carried out reading encryption to Excel platform data process storehouse and is revised read-only encryption.
Claims (4)
1. based on a tire-mold method for designing for Excel and CAD platform, it is characterized in that: described method for designing comprises the following steps:
The first step: generate mould standard drawing, utilize CAD electronic drafting software platform, according to need of production, draw constitutional detail figure and the general assembly drawing of related die, line parameter of going forward side by side marks, and the parameter marked is the standard value symbol of this parameter name;
Second step: set up Excel platform data process storehouse, create an excel spreadsheet lattice document, then set up successively in the document datamation table, produce under material list worksheet, general assembly drawing worksheet and the part manufacturing procedure worksheet corresponding with part drawing, and in datamation table, set up data correction workspace and general assembly drawing viewing area, need to design according to real work in material list worksheet under production and set up at least one lower material list.
3rd step: data inputting and set up funtcional relationship, first will the drawn general assembly drawing of CAD electronic drafting software platform be utilized to copy in the general assembly drawing viewing area in the datamation table in Excel platform data process storehouse, then according to the related data parameter name standard value symbol that general assembly drawing marks, correlation parameter single data typing form is set up successively in data correction workspace, then will the drawn part drawing of CAD electronic drafting software platform be utilized to copy in Excel platform data process storehouse in corresponding part manufacturing procedure worksheet successively, then the first subdata typing form is set up in the correlation parameter name code corresponding position of part drawing mark, then according to the constitutional detail figure of mould and general assembly drawing quantity and the parameter that corresponds thereof, the second subdata typing form is set up in material list worksheet successively under production, last according to related data parameter name standard value symbol by single data typing form corresponding data, number sequence operating function relational expression is set up according to the logical operation relation between die parameters, then according to related data parameter name standard value symbol, single data typing form corresponding data is set up data directory with same data in the first subdata typing form and the second subdata typing form respectively.
4th step: data are preserved, the Excel platform data process storehouse of setting up funtcional relationship set up is preserved, and when preserving, the encryption function utilizing excel spreadsheet lattice to carry is carried out reading encryption to Excel platform data process storehouse and is revised read-only encryption.
2. a kind of tire-mold method for designing based on Excel and CAD platform according to claim 1, is characterized in that: constitutional detail figure and the general assembly drawing of the described mould utilizing CAD electronic drafting software platform to draw are planimetric map three-view diagram.
3. a kind of tire-mold method for designing based on Excel and CAD platform according to claim 1, it is characterized in that: the constitutional detail figure of the described mould utilizing CAD electronic drafting software platform to draw and general assembly drawing are when copying to Excel platform data process storehouse correspondence worksheet, and part drawing and general assembly drawing are all converted into JPG, TIF or PDF.
4. a kind of tire-mold method for designing based on Excel and CAD platform according to claim 1, is characterized in that: the Excel platform release form that described Excel platform data process storehouse relies on is not higher than Excel2003.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410243804.4A CN104281727A (en) | 2014-06-04 | 2014-06-04 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410243804.4A CN104281727A (en) | 2014-06-04 | 2014-06-04 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104281727A true CN104281727A (en) | 2015-01-14 |
Family
ID=52256600
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410243804.4A Pending CN104281727A (en) | 2014-06-04 | 2014-06-04 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104281727A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109014720A (en) * | 2018-08-17 | 2018-12-18 | 广州市虹利自动化科技有限公司 | A kind of auto welding jig design method |
| CN109308131A (en) * | 2018-08-24 | 2019-02-05 | 无锡加简软件开发有限公司 | A kind of groover input method |
| CN110083881A (en) * | 2019-04-02 | 2019-08-02 | 河北万达轮胎有限公司 | A kind of tire tread based on Excel and CAD platform goes out type die panel method for drafting |
| EP3761256A4 (en) * | 2018-04-11 | 2021-04-21 | National University Corporation Chiba University | Component management database, component management system, and component management method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002230052A (en) * | 2001-01-29 | 2002-08-16 | Sanei Plot:Kk | Method for preparing cad data file and method for distributing the same |
| CN102314540A (en) * | 2011-10-24 | 2012-01-11 | 河北省电力勘测设计研究院 | Method for automatically generating thermal-control power supply cabinet wiring diagram for electric power plant |
| CN102495753A (en) * | 2011-10-21 | 2012-06-13 | 江苏省交通科学研究院股份有限公司 | Interactive computer-aided design (CAD) engineering drawing batch processing method |
| CN102855359A (en) * | 2012-09-11 | 2013-01-02 | 北京航空航天大学 | Optimized design method for variable-thickness rims of automobile wheels |
| CN103324681A (en) * | 2013-05-31 | 2013-09-25 | 重庆瑜煌电力设备制造有限公司 | Process card data generation method based on computed-aided design (CAD) |
| CN103473216A (en) * | 2013-06-28 | 2013-12-25 | 湖南天雁机械有限责任公司 | Excel-based product process planning method |
-
2014
- 2014-06-04 CN CN201410243804.4A patent/CN104281727A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002230052A (en) * | 2001-01-29 | 2002-08-16 | Sanei Plot:Kk | Method for preparing cad data file and method for distributing the same |
| CN102495753A (en) * | 2011-10-21 | 2012-06-13 | 江苏省交通科学研究院股份有限公司 | Interactive computer-aided design (CAD) engineering drawing batch processing method |
| CN102314540A (en) * | 2011-10-24 | 2012-01-11 | 河北省电力勘测设计研究院 | Method for automatically generating thermal-control power supply cabinet wiring diagram for electric power plant |
| CN102855359A (en) * | 2012-09-11 | 2013-01-02 | 北京航空航天大学 | Optimized design method for variable-thickness rims of automobile wheels |
| CN103324681A (en) * | 2013-05-31 | 2013-09-25 | 重庆瑜煌电力设备制造有限公司 | Process card data generation method based on computed-aided design (CAD) |
| CN103473216A (en) * | 2013-06-28 | 2013-12-25 | 湖南天雁机械有限责任公司 | Excel-based product process planning method |
Non-Patent Citations (2)
| Title |
|---|
| 吴新波等: "基于三维CAD实体模型的模具BOM表自动生成方法研究", 《模具工业》 * |
| 贾继斌: "建立轮胎模具设计库 实现模具设计参数化", 《橡胶科技市场》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP3761256A4 (en) * | 2018-04-11 | 2021-04-21 | National University Corporation Chiba University | Component management database, component management system, and component management method |
| CN109014720A (en) * | 2018-08-17 | 2018-12-18 | 广州市虹利自动化科技有限公司 | A kind of auto welding jig design method |
| CN109308131A (en) * | 2018-08-24 | 2019-02-05 | 无锡加简软件开发有限公司 | A kind of groover input method |
| CN110083881A (en) * | 2019-04-02 | 2019-08-02 | 河北万达轮胎有限公司 | A kind of tire tread based on Excel and CAD platform goes out type die panel method for drafting |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109367014B (en) | 3D printing method for axially printing bent pipe based on five-axis printing platform | |
| JP6645681B2 (en) | 3D data management device | |
| CN107145686B (en) | Method for creating support ANSYS finite element analysis model by using AutoCAD | |
| CN110750840B (en) | Method and device for automatically generating two-dimensional part view based on three-dimensional model | |
| CN104281727A (en) | Method for designing tire die on basis of Excel and CAD (computer aided design) platform | |
| CN104408240A (en) | Data conversion and extraction method for model based definition (MBD) | |
| CN106994483A (en) | A kind of method of the accurate type face processing of Automobile Cover Drawing Die | |
| CN103544343A (en) | Serialized and parameterized modeling method of power chuck | |
| CN103631996A (en) | Product structure and process parallel design method based on model maturity | |
| CN102968539A (en) | Method for massively and quickly generating format drawing | |
| CN106295032A (en) | A kind of ceramic tile Design of Dies software system and method for designing thereof | |
| CN105426590A (en) | Machining process feature tree and construction method thereof | |
| CN104375463A (en) | Part machining method for automatically obtaining dimensional tolerance | |
| CN107066644B (en) | Automatic modeling method for special-shaped suspended ceiling | |
| CN105447284A (en) | Technical allowance adding method | |
| TWI514180B (en) | System and method for processing information of measurement numbers | |
| CN111723441B (en) | Plastic part pre-deformation part modeling method, system, device and storage medium | |
| CN105589867A (en) | Rapid generation method for three-dimensional machined technological document | |
| CN108734782A (en) | A kind of expression of CATIA three-dimensional geological models attribute information | |
| CN113642079A (en) | Factory design method based on three-dimensional technology | |
| CN103729516A (en) | Three-dimensional technology inverted sequence modeling method and device | |
| CN103902750A (en) | Design method for achieving parameterized three-dimensional modeling and two-dimensional diagram conversion of parts similar to main part | |
| Liu et al. | A convenient part library based on SolidWorks platform | |
| CN112001047B (en) | Radar key part process design method based on PMI information | |
| CN109509234B (en) | Urban building group high-definition grid map vectorization-based method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150114 |
|
| RJ01 | Rejection of invention patent application after publication |