Excel-based product process planning method

Abstract

The invention discloses an excel-based product process planning method, which comprises the following steps of creating a worksheet of each procedure in an Excel according to a conventional process format, and standardizing a process attached drawing, a dimension and a geometric tolerance position in each procedure; creating a dimension chain parameter worksheet template, thereby automatically calculating a process dimension chain of a related procedure; creating process route worksheet templates and equipment detail worksheet templates, thereby realizing the linked association of a product process procedure directory and related contents of each procedure; performing associated edition on all required item contents by utilizing an Excel formula tool to change only contents at one position for the same contents of a product process without changing procedure contents automatically calculated through a dimension chain, and performing color identification on cell fonts which may cause changes in contents of other cells or require special attentions. Therefore, errors can be effectively avoided, and the working efficiency can be improved.

Description

technical field [0001] The invention relates to an enterprise internal affairs management method, in particular to an excel-based product process preparation method. Background technique [0002] Microsoft Office Excel is widely used for its powerful data processing function. At present, the application of excel in the market mainly stays in pure data processing, and no application for preparing product process has been found. [0003] At present, domestic machinery manufacturing enterprises generally adopt two methods for product process preparation. One method is to use general-purpose two-dimensional computer-aided design software to compile product processes, such as using AutoCAD, CAXA and other software to compile processes, but these software cannot be used. Realize product code, component name, same size inside process, automatic calculation of size and size chain between processes, and linkage of project parameters, and the efficiency of process preparation is low, ...

AI Technical Summary

Problems solved by technology

[0003] At present, domestic machinery manufacturing enterprises generally adopt two methods for product process preparation. One method is to use general-purpose two-dimensional computer-aided design software to compile product processes, such as using AutoCAD, CAXA and other software to compile processes, but these software cannot be used. Realize product code, component name, same size inside process, automatic calculation of size and size chain between processes, and linkage of project parameters, and the efficiency of process preparation is low, labor-intensive, and error-prone, because process documents need to be modified frequently Adjustment, it is easy to omit revisions, resulting in inconsistencies in process documents; another method is to purchase professional process preparation software from software companies for the company. Using this professional process preparation software to prepare processes is highly efficient, but there are comprehensive uses. Disadvantages such as high cost and troublesome secondary modification of software templates

Images