CN103324681A - Process card data generation method based on computed-aided design (CAD) - Google Patents
Process card data generation method based on computed-aided design (CAD) Download PDFInfo
- Publication number
- CN103324681A CN103324681A CN2013102130984A CN201310213098A CN103324681A CN 103324681 A CN103324681 A CN 103324681A CN 2013102130984 A CN2013102130984 A CN 2013102130984A CN 201310213098 A CN201310213098 A CN 201310213098A CN 103324681 A CN103324681 A CN 103324681A
- Authority
- CN
- China
- Prior art keywords
- data
- link table
- data link
- cad
- part data
- 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.)
- Granted
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a process card data generation method based on computer-aided design (CAD) and relates to a process card manufacturing method. By means of the CAD and EXCEL communication, part data in a CAD part drawing and part data set in an EXCEL sheet are matched in turns, the accuracy of the part data in the CAD part drawing can be effectively checked and ensured, process data can be directly filled in the CAD, a process card made of paper is no longer required, the cost is reduced, and the efficiency is greatly improved.
Description
Technical field
The present invention relates to a kind of method for making of process chart, particularly relate to a kind of writing process sheet method based on CAD.
Background technology
The steel tower industry is a special industry, the parts of steel tower are very many, few person's hundreds of spare, many persons are thousands of, adding man-hour will be to each parts manufacture craft card, according to the difference of quantity on order, the radix of each tower is different, and the quantity when causing producing on the process chart, weight are ceaselessly changing.
According to the processing process regulation, add indispensable two kinds of data in man-hour; The one, material list is convenient to blanking, clear part and typewriting usefulness for data such as the dash number that shows this batch converted products, material, specification, length, quantity, and the 2nd, part drawing and attached superincumbent process chart are used for product and process and do the operation record.Traditional process chart method for making is loaded down with trivial details, the process chart of filling in process data is sticked to above the part drawing with glue, and its shortcoming is: error rate is high, cost is high, and speed is slow, efficient is low, can not satisfy the demand of production, so that imbalance between supply and demand constantly increases.
Summary of the invention
Because the defects of prior art, technical matters to be solved by this invention provides a kind of so that CAD(Auto Computer Aided Design, the robot brain aided design system) the process chart generation method that can accurately fill in fast process data.
For achieving the above object, the invention provides a kind of process chart data creation method based on CAD, carry out according to the following steps:
Step 1, open CAD part drawing and Microsoft Excel;
Step 2, extract part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data that extracts in the Microsoft Excel forms the second data link table;
Step 3, described the first data link table and the second data link table are mated;
Set described the first data link table and the second data link table and include n part data, n is positive integer, first part data in first part data in the first data link table and described the second data link table is mated, second part data in second part data and described the second data link table in the second data link table mated, until in the first data link table in all part datas and described the second data link table corresponding part data coupling finish; When corresponding part data mates in n part data in described the first data link table and described the second data link table, execution in step four; When corresponding part data does not mate in n part data in described the first data link table and described the second data link table, execution in step five;
Step 4, fill in process data at the CAD part drawing, then finish;
Step 5, in the CAD command bar, carry out miscue, then finish.
Owing to adopting CAD to communicate by letter with EXCEL, the part data of setting in the part data of poll coupling CAD part drawing and the Microsoft Excel, can effectively check and guarantee the accuracy of part data in the CAD part drawing, and can directly in CAD, fill in process data, make it no longer need the process chart of papery, reduce cost, improved greatly efficient.
Better, described the first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is comprised of engineering name, processing radix, processing total quantity, general assembly (TW) and Product Status, adopts above technical scheme can satisfy conventional steel tower manufacture craft demand.
The invention has the beneficial effects as follows: the present invention can effectively check and guarantee the accuracy of part data in the CAD part drawing, and can directly in CAD, fill in process data, make it no longer need the process chart of papery, reduced cost, improved greatly efficient.
Description of drawings
Fig. 1 is the schematic flow sheet of the embodiment of the invention.
Embodiment
The invention will be further described below in conjunction with drawings and Examples:
As shown in Figure 1, a kind of process chart data creation method based on CAD, carry out according to the following steps:
Step 1, open CAD part drawing and Microsoft Excel;
Step 2, extract part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data that extracts in the Microsoft Excel forms the second data link table;
Step 3, judge whether described the first data link table and the second data link table mate;
Set described the first data link table and the second data link table and include n part data, n is positive integer, first part data in first part data in the first data link table and described the second data link table is mated, second part data in second part data and described the second data link table in the second data link table mated ... until in the first data link table in all part datas and described the second data link table corresponding part data coupling finish;
When corresponding part data mates in n part data in described the first data link table and described the second data link table, execution in step four; When corresponding part data does not mate in n part data in described the first data link table and described the second data link table, execution in step five;
Step 4, fill in process data at the CAD part drawing, then finish;
Step 5, carry out miscue in the CAD command bar, then finish, wherein miscue comprises the parameter type of mistake and the sample bar coordinate of misdata.
Described the first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is comprised of engineering name, processing radix, processing total quantity, general assembly (TW) and Product Status.
More than describe preferred embodiment of the present invention in detail.Should be appreciated that those of ordinary skill in the art need not creative work and just can design according to the present invention make many modifications and variations.Therefore, all in the art technician all should be in the determined protection domain by claims under this invention's idea on the basis of existing technology by the available technical scheme of logical analysis, reasoning, or a limited experiment.
Claims (2)
1. process chart data creation method based on CAD is characterized in that carrying out according to the following steps:
Step 1, open CAD part drawing and Microsoft Excel;
Step 2, extract part data according to the picture frame coordinate of CAD part drawing and form the first data link table, the part data that extracts in the Microsoft Excel forms the second data link table;
Step 3, described the first data link table and the second data link table are mated;
Set described the first data link table and the second data link table and include n part data, n is positive integer, first part data in first part data in the first data link table and described the second data link table is mated, second part data in second part data and described the second data link table in the second data link table mated, until in the first data link table in all part datas and described the second data link table corresponding part data coupling finish; When corresponding part data mates in n part data in described the first data link table and described the second data link table, execution in step four; When corresponding part data does not mate in n part data in described the first data link table and described the second data link table, execution in step five;
Step 4, fill in process data at the CAD part drawing, then finish;
Step 5, in the CAD command bar, carry out miscue, then finish.
2. the process chart data creation method based on CAD as claimed in claim 1 is characterized in that: described the first data link table and the second data link table form by Part No., material, specification, length and number of packages; Described process data is comprised of engineering name, processing radix, processing total quantity, general assembly (TW) and Product Status.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213098.4A CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310213098.4A CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103324681A true CN103324681A (en) | 2013-09-25 |
| CN103324681B CN103324681B (en) | 2016-06-08 |
Family
ID=49193424
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310213098.4A Active CN103324681B (en) | 2013-05-31 | 2013-05-31 | Process chart data creation method based on CAD |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103324681B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281727A (en) * | 2014-06-04 | 2015-01-14 | 河南金牌山模具有限公司 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
| CN104460523A (en) * | 2014-10-31 | 2015-03-25 | 沈阳黎明航空发动机(集团)有限责任公司 | Part machining method based on excel software |
| CN107273417A (en) * | 2017-05-11 | 2017-10-20 | 广东卓信环境科技股份有限公司 | The generation method and device of a kind of pipeline rout figure BOM |
| CN108228866A (en) * | 2018-01-15 | 2018-06-29 | 苏州索及信息技术有限公司 | A kind of method and system for matching parts to be processed and processing producer's manufacturing process |
| CN109408999A (en) * | 2018-11-08 | 2019-03-01 | 中铁山桥集团有限公司 | A method of intelligence generates steel construction part manufacturing process card |
| CN112182684A (en) * | 2020-08-31 | 2021-01-05 | 大明重工有限公司 | Batch head parameterized process card generation method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020008719A1 (en) * | 2000-06-28 | 2002-01-24 | Dai Miyawaki | Internet database |
| CN101068635A (en) * | 2004-04-08 | 2007-11-07 | 工业纸折品有限公司 | Method of designing fold lines in sheet material |
-
2013
- 2013-05-31 CN CN201310213098.4A patent/CN103324681B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20020008719A1 (en) * | 2000-06-28 | 2002-01-24 | Dai Miyawaki | Internet database |
| CN101068635A (en) * | 2004-04-08 | 2007-11-07 | 工业纸折品有限公司 | Method of designing fold lines in sheet material |
Non-Patent Citations (3)
| Title |
|---|
| 严正江: "工艺卡片中AutoCAD的应用", 《工艺》, 30 April 1996 (1996-04-30), pages 47 - 48 * |
| 杜春涛等: "CAPP系统中工艺卡片生成过程的研究", 《现代制造工程》, no. 06, 18 June 2003 (2003-06-18), pages 41 - 43 * |
| 董加强等: "基于XML的CAPP数据库设计", 《矿山机械》, no. 04, 20 April 2006 (2006-04-20), pages 119 - 121 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281727A (en) * | 2014-06-04 | 2015-01-14 | 河南金牌山模具有限公司 | Method for designing tire die on basis of Excel and CAD (computer aided design) platform |
| CN104460523A (en) * | 2014-10-31 | 2015-03-25 | 沈阳黎明航空发动机(集团)有限责任公司 | Part machining method based on excel software |
| CN107273417A (en) * | 2017-05-11 | 2017-10-20 | 广东卓信环境科技股份有限公司 | The generation method and device of a kind of pipeline rout figure BOM |
| CN108228866A (en) * | 2018-01-15 | 2018-06-29 | 苏州索及信息技术有限公司 | A kind of method and system for matching parts to be processed and processing producer's manufacturing process |
| CN109408999A (en) * | 2018-11-08 | 2019-03-01 | 中铁山桥集团有限公司 | A method of intelligence generates steel construction part manufacturing process card |
| CN112182684A (en) * | 2020-08-31 | 2021-01-05 | 大明重工有限公司 | Batch head parameterized process card generation method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103324681B (en) | 2016-06-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103324681A (en) | Process card data generation method based on computed-aided design (CAD) | |
| CN103235996A (en) | Material coding management method and material coding management system | |
| CN101178750A (en) | PCB emulation system have error detection function and realization method thereof | |
| CN105718653A (en) | Automatic checking method of annotated information completeness for MBD (Model Based Definition) process model | |
| CN107688332B (en) | A kind of forged product line configuration method and system based on customer demand | |
| CN103677763A (en) | Graphical programming source file storage and analytic method | |
| CN113096147B (en) | MATLAB-based automatic laser marking shadow generation method | |
| CN103678737A (en) | Lever system virtual assembly method | |
| CN101930482B (en) | Hydraulic machine parameterization rapid design modeling system and modeling method thereof | |
| CN111581726A (en) | Online integrated aircraft aerodynamic modeling system | |
| CN104133802A (en) | Data exchange method between Vxworks embedded operating system and motion control card of double-workpiece-platform scanning mask aligner | |
| CN104657554A (en) | Rapid rocket three-dimensional model design information extraction system | |
| CN104504227A (en) | Hydraulic forging press multi-dimensional virtual prototype collaborative simulation method and system | |
| CN103279628A (en) | Method for manufacturing parameterized engineering drawings | |
| CN102521427A (en) | ProE-based simple hole table array automatic modeling method | |
| CN103870540A (en) | Database based on structural design and analysis integration | |
| CN105589867B (en) | A kind of three-dimensional mechanical processing technique file rapid generation | |
| CN102142047A (en) | Method capable for being implemented in computer, readable computer media and system thereof | |
| CN101706837A (en) | Mathematical model based method for establishing database of fixture components | |
| CN105881918A (en) | 3D printing method for building model | |
| CN106273470B (en) | Three-dimensional printing device and its print data storage method | |
| CN103400411A (en) | Method and system for modeling three-dimensional entity | |
| CN105630506A (en) | Bill generation method, bill template generation method and related devices | |
| CN106085255B (en) | A kind of glue and preparation method thereof for 3D printer | |
| CN103440550A (en) | Two-dimensional drawing baseline management method in PDM system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |