Creation method of process file template

Abstract

The invention relates to the technical field of process file templates, and provides a process file template creation method, which comprises the following steps of: 1, creating three blank basic worksheets; step 2, creating nine blank process file worktables; the blank process file worksheet comprises an unfilled envelope, a catalog, a product and process special characteristic list, a process flow chart, a control plan, a machining card, a special inspection record, a self-inspection record and a tool list blank worksheet; 3, creating five user-defined windows for quickly inputting information and outputting process files; 4, creating a process file in the custom tab and a custom tool of the process file; and 5, checking the template. According to the method, the input time for filling tedious files can be shortened for process engineers, the repeated input process is saved, the information in the basic worksheet is automatically extracted and filled into the process file worksheet, simple errors caused by wrong writing of the process engineers are avoided, and the efficiency and accuracy of process design are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of process file templates, and in particular to a method for creating a process file template. Background Art

[0002] In manufacturing enterprises, process engineers prepare process documents to guide the processing and manufacturing of parts on site. Such process documents generally include feature lists, process flow charts, control plans, machining cards, inspection records, tooling lists, etc. The format requirements and expressions are very different in different enterprises, but the content expressed is basically the same.

[0003] The process files of many enterprises are filled out manually in tables. For complex parts, the product characteristics can reach hundreds. The processing procedures are complex, with many steps and many tool gauges. Moreover, many data in the above process files are repeated many times. The merge of cells in the process file format varies. Copying and pasting will cause the contents of other columns to be overwritten. Even if there is no content in other columns, it is necessary to split and merge columns and other processing operations, which brings a lot of trouble to the data reference between files. If you want to keep the format in the file unchanged, you can only copy and paste the content of a single cell. The compilation of the whole set of files is huge, time-consuming and labor-intensive, and prone to errors. If a professional software platform is used, it generally integrates management platform software with other functions, which requires customized development and high costs, and requires a large investment for small and medium-sized enterprises. For enterprises that do not use professional software platforms and want to get rid of manually filling out process files, an efficient method is needed to realize the automatic generation of process files. Summary of the invention

[0004] The present invention mainly solves the technical problems of the prior art process document preparation that the amount of data is large, time-consuming and labor-intensive, and prone to errors. A method for creating a process document template is proposed, which can shorten the input time for process engineers to fill out cumbersome documents, save repeated input processes, avoid simple errors caused by process engineers' mistakes, and improve the efficiency and accuracy of process design.

[0005] The present invention provides a method for creating a process file template, comprising:

[0006] Step 1, create three blank basic worksheets; the basic worksheets include: basic information worksheet, product characteristics worksheet, process step tool inspection tool worksheet;

[0007] Step 2, create nine blank process document worksheets; the blank process document worksheets include: unfilled cover, catalog, product and process special characteristics list, process flow chart, control plan, machining card, special inspection record, self-inspection record, tooling list blank worksheet;

[0008] Step 3, creating five custom windows for quickly inputting information and outputting process files; the custom windows include: a reference window, a process flow window, a product feature information window, a tool inspection window, and a process file generation window;

[0009] Step 4, create the process file and its custom tools in the custom tab;

[0010] Step 5: Check and improve the template.

[0011] Furthermore, the step 1 includes the following steps 101 to 103:

[0012] Step 101, creating a blank basic information worksheet; the basic information worksheet includes: basic information, review information, change information, and process flow;

[0013] Step 102, creating a blank product characteristics worksheet; the product characteristics worksheet includes: serial number, product characteristics, completion steps, process characteristics, characteristic level, product process specification, evaluation measurement technology, capacity, control method, reaction plan, and process;

[0014] Step 103, creating a blank process step tool gauge worksheet; the process step tool gauge worksheet includes: process, process step, process step content, characteristic level, spindle speed, feed rate, cutting depth, feed times, tool name, model, quantity and quota, and name, model, range, accuracy and quantity of the gauge corresponding to the process step.

[0015] Furthermore, the step 2 includes the following steps 201 to 208:

[0016] Step 201, creating an unfilled cover according to demand;

[0017] Step 202, creating an unpopulated directory according to the requirements;

[0018] Step 203, create a blank product and process special characteristics list according to the requirements;

[0019] Step 204, creating a blank process flow chart according to the requirements;

[0020] Step 205, create a blank control plan according to the requirements;

[0021] Step 206, creating a blank machining card according to the requirements;

[0022] Step 207, create blank special inspection records and self-inspection records according to requirements;

[0023] Step 208, create a blank tooling list according to requirements.

[0024] Furthermore, the step 3 includes the following steps 301 to 305:

[0025] Step 301, creating a reference window;

[0026] The reference window displays the source file directory, starting cell, ending cell, and target starting cell of the reference data; the window includes function buttons such as browse source file, select worksheet, starting cell, ending cell, target starting cell, and copy reference information. The button function can copy a large amount or part of the copy reference information from the source file to the current template workbook by compiling a Click event subroutine segment, which is especially suitable for copying multiple rows of content with merged columns;

[0027] Step 302, creating a process flow window;

[0028] The process flow process window is used to input the corresponding process flow data in the basic information table. The window displays process content, equipment, tooling and beat information. The function buttons in the window include insert process information and modify process information. The buttons can realize the function of inputting and modifying the process flow related data in the basic information worksheet by compiling the Click event subroutine segment. There is also a process adjustment button SpinButton1, which can realize the function of displaying the corresponding process information in the window by compiling the Change event subroutine segment.

[0029] Step 303, creating a product characteristic information window;

[0030] The product characteristic information window is used to input the corresponding data in the product characteristic basic table. The window displays the product characteristics, measurement and control methods, and measuring tool information. The function buttons in the window include extracting characteristics, inputting measurement methods and tools, and measuring tool library. The buttons can extract existing information, input new information, and call information from the measuring tool library by compiling the Click event subroutine segment. There are also serial number adjustment buttons SpinButton1 and row scrolling buttons ScrollBar1. The function of displaying information by bubble number or row is realized by compiling the Change event subroutine segment.

[0031] Step 304, creating a work step tool inspection tool window;

[0032] The step tool gauge window is used to input the corresponding data in the process step tool gauge basic table. The window displays the step information, processing parameters, and tool information. The window function buttons include input step information, modify step information, add list, modify list, and tool library. The button functions realize the functions of inputting and modifying step information, adding and modifying tool information, and calling tool information and processing parameters from the tool library through the Click event handler. There is also a step adjustment button SpinButton1, which realizes the function of displaying the corresponding existing information in the window through the Change event subroutine segment, including calling the size or tolerance characteristics and gauge information formed by the corresponding step in the product characteristics worksheet;

[0033] Step 305, creating a process file generation window;

[0034] The process file generation window is divided into two parts: file generation and print settings. Each part includes multiple function buttons, and the function of each button is implemented by the Click event subroutine segment; the file generation is used to extract data from the basic table to form a process file in a standard format except for the cover. After checking that there are no problems with the process file, print settings are performed. The print settings mainly complete paging, insert headers and footers, and set the headers and footers to distinguish page numbers, and finally output in PDF format.

[0035] Furthermore, the step 5 includes the following steps 501 to 508:

[0036] Step 501, open the template, and enter basic information, review information, and change information in the basic information worksheet;

[0037] Step 502, calling the process flow window to fill in the process flow information in the basic information worksheet;

[0038] Step 503, calling the product characteristic information window to fill in the product characteristic worksheet and inputting the product characteristics, measurement and control methods, and measuring tools;

[0039] Step 504, calling the work step tool inspection tool window to fill in the process step tool inspection tool work table and input the work step information, tool information, and processing parameters;

[0040] Step 505, calling the process file window, clicking the function button of the file to be generated, generating a list of characteristics, generating a process flow chart, generating a control plan, generating a machining card, generating a special inspection record, generating a self-inspection record, generating a tooling list, and generating a catalog;

[0041] Step 506, check the generated process file table and supplement the separate setting content;

[0042] Step 507, calling the process file window, clicking the print setting function button corresponding to the file to be printed, the characteristic list print setting, process flow chart print setting, control plan print setting, machining card print setting, special inspection record print setting, self-inspection record print setting, tooling list print setting, and outputting the print file in PDF format;

[0043] Step 508, check whether the generated PDF file meets the requirements. If not, it needs to be adjusted and modified and then reprinted into a PDF file.

[0044] The invention provides a method for creating a process file template, which establishes an information input and file output template required by a process file format standard. The template is based on an EXCEL software platform, a macro-enabled .xlsm file blank template, and VBA software development technology is used to create a custom window and a program segment, and the custom window is called by a custom tool in a custom tab. The initial state of the template includes three basic worksheets, nine process file blank worksheets, and five custom windows. The data in the nine process file tables have corresponding contents in the three basic tables, and are referenced according to the needs of the process files. The custom window is used to efficiently input the data in the basic table and quickly and automatically generate the process file. In the custom window, it is realized to select a fill-in item from a drop-down menu, realize the direct call of reference data from a tool library and a gauge library, and realize the automatic generation of nine standard process files based on the basic worksheet. The invention can shorten the input time of filling in cumbersome files for process engineers, save repeated input processes, break through the barrier that duplicate data between different files can only be copied by a single cell because of different merged rows or columns, avoid simple errors caused by process engineers' mistakes, and improve the efficiency and accuracy of process design. Although this template cannot be directly widely used due to different formats, the basic method can be extended to the input, organization and output of similar files, and the template platform can be customized according to company needs. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] Figure 1 It is a flow chart of the implementation of the method for creating a process file template provided by the present invention;

[0046] Figure 2 is a schematic diagram of the reference window;

[0047] Figure 3 It is a schematic diagram of the process window;

[0048] Figure 4 is a schematic diagram of a product feature information window;

[0049] Figure 5 It is a schematic diagram of the measuring and checking tool information table in the measuring and checking tool library;

[0050] Figure 6 It is a schematic diagram of the tool inspection window of the work step;

[0051] Figure 7 It is a schematic diagram of the tool information table in the tool library;

[0052] Figure 8 It is a schematic diagram of the process file generation window;

[0053] Fig. 9 is a schematic diagram of the process file custom tab. DETAILED DESCRIPTION

[0054] In order to make the technical problems solved by the present invention, the technical solutions adopted and the technical effects achieved clearer, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are only used to explain the present invention, rather than to limit the present invention. It should also be noted that, for the convenience of description, only the parts related to the present invention are shown in the accompanying drawings, rather than all the contents.

[0055] like Figure 1 As shown, a method for creating a process file template provided by an embodiment of the present invention includes:

[0056] Step 1, create three blank base worksheets.

[0057] The three basic worksheets are basic information worksheet, product characteristics worksheet, and process step tool inspection tool worksheet. Create basic worksheets on the EXCEL software platform. Step 1 includes the following steps 101 to 103:

[0058] Step 101, create a blank basic information worksheet.

[0059] The basic information worksheet includes: basic information, audit information, change information, and process flow. Among them, the basic information is filled in B2 to B14 of the EXCEL table, the audit information is filled in B16 to B24, and the change information is filled in A26 to E29, and the filled cells are fixed. Among them, the process flow includes the process flow program number, expression symbol, responsible unit, process content, processing equipment name and model, clamping tool name and model, process basic time (seconds), operation time (seconds). The process flow content must be filled between "Process Flow-Start" and "Process Flow-End"; when multiple processes share equipment, the processes are merged and represented, such as OP30 / 40 / 50, and the merged state is used in the subsequent process identification.

[0060] Step 102, create a blank product characteristics worksheet.

[0061] The product characteristics worksheet includes: serial number (bubble number), product characteristics, completed steps, process characteristics, characteristic level, product process specifications / tolerances, evaluation measurement technology, capacity / frequency, control method, reaction plan, process, and the name, model / number, range, accuracy and quantity of the measuring tool corresponding to each characteristic, and each item corresponds to a column. The bubble number, product characteristics, and product process specifications / tolerances can be imported from the tabular data output by the bubble chart software; the C column steps and the M column processes are identification columns. After importing the data, they need to be manually sorted in ascending order according to the M column. "End" is used in the worksheet to distinguish between machining processes and other processes (such as cleaning and inspection). In the worksheet, process characteristics are generally added for S / C items or other key characteristics, and up to 3 process characteristics can be added for one product characteristic.

[0062] Step 103, creating a blank process step tool inspection fixture worksheet.

[0063] The process step tool inspection tool worksheet includes: process, step, step content, characteristic level, spindle speed, feed rate, cutting depth, feed number, tool name, model, quantity and quota, and the name, model, range, accuracy and quantity of the measuring tool corresponding to the step, and each item corresponds to a column. The process in column A of the worksheet is the identification column, and the line containing "end" is the identification row. There is generally a description of the process before the start of each process in the worksheet, which is filled in manually according to different products. The information of the measuring tool in the worksheet corresponds one by one to the dimensions or tolerances (i.e. product characteristics and product process specifications / tolerances) formed under the corresponding process step in the "Product Characteristics" worksheet.

[0064] Step 2, create nine blank process file worksheets.

[0065] Blank process document worksheets, including: unfilled covers, catalogs, product and process special characteristics lists, process flow charts, control plans, machining cards, special inspection records, self-inspection records, and tooling list blank worksheets. Step 2 includes the following steps 201 to 208:

[0066] Step 201, creating an unfilled cover according to requirements.

[0067] The cover includes basic information about the product and document, such as product model, name, version number, editor and reviewer, etc.

[0068] Step 202: Create an unpopulated directory based on demand.

[0069] In addition to the basic information of the product and document in the header and footer of each document, the directory also lists the process document number, document name and document page number.

[0070] Step 203, create a blank product and process special characteristics list based on requirements.

[0071] The list of special characteristics of products and processes is to extract product and process characteristics with special characteristics, generally including bubble number, product characteristics, process characteristics, customer characteristic identification, company characteristic identification, etc.

[0072] Step 204: Create a blank process flow chart according to requirements.

[0073] The process flow chart expresses the product processing flow according to the process, generally including process steps, processing flow line, responsible unit, process content, processing equipment, product characteristic identification, product and process characteristics, basic and operation time, etc.

[0074] Step 205: Create a blank control plan based on demand.

[0075] The control plan is a summary and detection control method for all product and process characteristics. It generally includes part / process number, process name / operation description, production equipment, product characteristic number, product and process characteristics, characteristic level, product process specifications / tolerances, evaluation and measurement technology, sample size and frequency, control method and response plan, etc.

[0076] Step 206, create a blank machining card according to the requirements.

[0077] Machining cards are used to directly guide the processing sequence in production, the tool measuring tools and processing parameters used, generally including process steps, process step content, characteristic level, spindle speed, feed rate, cutting depth, number of feeds, tool name, model / number, measuring tool name, model / number, range, accuracy, etc.

[0078] Step 207, create blank special inspection records and self-inspection records according to requirements.

[0079] Special inspection records and self-inspection records are used to fill in the product characteristic inspection results of the inspected parts, generally including serial number, inspected product characteristics, product process specifications / tolerances, actual measurement results and inspection frequency, etc. All information has appeared before.

[0080] Step 208, create a blank tooling list according to requirements.

[0081] The tooling list summarizes all the information of fixtures, tools and gauges, generally including serial number, tooling name, model / number / specification, quantity, process, quota, etc. All the information has appeared before. These are enterprise standard process documents expressed in the form of EXCEL tables, which are used to guide the processing and manufacturing of products. The cover information and product information (except the number of pages) in the header and footer of other documents in the process document worksheet correspond to the basic information, review information and change information in the basic information worksheet, and reference is achieved by setting cell formulas and statements. For example, the assignment formula in the "product model" cell is "=basic information! $B$2"; for example, the conditional statement in the production status identification cell is "production", and the cell is set to "=IF(basic information! $B$9="sample","□",IF(basic information! $B$9="trial production","□",IF(basic information! $B$9="production","■","")))". In addition, the total number of pages in the header is filled in according to the paging situation in the print settings.

[0082] The data and information of the nine process file worksheets are derived from the three basic tables. There are many ways to input the content in the basic table, which can be filled in manually or copied and pasted from other files. Filling through the custom window developed in the template is an efficient method. The custom window sets the combo box drop-down list selection, sets the function button for calling the tool library and the gauge library, sets the function button for inputting and modifying information, etc., so that all information can be filled through the window.

[0083] Step 3, create five custom windows for quickly inputting information and outputting process files.

[0084] Five custom windows, including: reference window, process flow window, product feature information window, tool inspection window, and process file generation window. The first four are used for information input, and the process file generation window is used for outputting the process file. Step 3 includes the following steps 301 to 305:

[0085] Step 301, creating a reference window.

[0086] References window (see Figure 2 ), suitable for completing the content copying in multiple rows with merged columns, and for batch importing the reference data in the existing old process files into the corresponding basic table, solving the problem that different reference data in the merged columns in the old files can only be copied in a single cell. If there is a file generated for a deformed product, it can be used to borrow a large amount or part of the content in the basic process file.

[0087] The reference window displays the source file directory, starting cell, ending cell, and target starting cell of the reference data. The window includes six function buttons: browse source file, select worksheet, start cell, end cell, target starting cell, and copy reference information. The button functions are realized by programming the Click event subroutine segment.

[0088] Browse source files is used to select source files from a folder. The file selection dialog box is set through FileDialog, and files are selected layer by layer. The file type is set to *.xlsx; *.xls; *.xlsm files generated by Excel. The address of the selected file is displayed in the text box on the right, and all worksheet names of the selected file are displayed in the text box below.

[0089] Selecting a worksheet is used to display the name of a selected worksheet in the text box on the left below the button. The implementation method is that when there is a selected worksheet name in the text box on the right, the text box.Value = list box.Value.

[0090] The starting cell and the ending cell are selected from the above selected worksheet, and the source file address and worksheet name are extracted from the above text box. Open the worksheet, and the display bar "Please select a cell" appears. Manually select a cell from the worksheet, and the selected cell is displayed in the display bar, such as "Please select a cell $A$6", and is displayed in the text box on the right. Note that the starting and ending cells are selected in the same column, such as: starting cell A10, ending cell A45.

[0091] The target start cell is the target location to be copied. The target file defaults to the current template workbook. The target file end cell is automatically calculated from the reference start and end cell positions. When you open the default worksheet, a display bar "Please select a cell" appears. Manually select a cell from the worksheet. The selected cell is displayed in the display bar and in the text box on the right.

[0092] Copy reference information to complete copying the cells in the selected worksheet of the source file to the current template workbook, extract the source file address, worksheet name, starting and ending cell positions and target cell positions from the above text boxes, copy the source data, paste it to the target location, and complete the data reference.

[0093] Step 302, creating a process flow procedure window.

[0094] Process flow window (see Figure 3): Used to input and modify the process flow data in "Basic Information". You can select the responsible unit, equipment, tooling, etc. from the drop-down options in the combo box. If the process has been built from other software platforms, you can read the file content output in .xls or .xlsx here and complete the data and enter it into the "Basic Information" table.

[0095] The process window displays information such as process content, equipment, tooling, and rhythm. The process content includes process number, expression symbol, responsible unit, process content, equipment includes equipment name and equipment model, tooling includes tooling name and tooling model, and rhythm includes basic time and operation time. The function buttons in the window include: insert process information, modify process information, and the button functions are realized by programming the Click event subroutine segment. There is also a process adjustment button SpinButton1, which is realized by programming the Change event subroutine segment.

[0096] Inserting process information is to insert new process information. First, get the row positions of "Process Flow-Start" and "Process Flow-End" and assign them to E0 and E1, traverse the rows between E0 and E1, if the corresponding process number is found, first use the Insert statement to insert a blank row, and then use the assignment statement to assign the window information to the corresponding cell, and the subsequent processes move down, and the subsequent process numbers need to be modified. If the corresponding process number is not found, use the Insert statement to insert a blank row in the row where "Process Flow-End" is located, and then assign the window information to the corresponding cell, and the "Process Flow-End" row moves down.

[0097] Modifying process information is to modify existing process information. The modified process information is called into the window through the process adjustment button SpinButton1_Change event handler next to the process. At this time, SpinButton1.Value is the row number where this process is located. Modify the content displayed in the text box in the window, click the "Modify process information" button, the specific operation of the program first obtains the row position of "Process Flow-Start" and assigns SpinButton1.Value to E0 and S1, writes the corresponding process information in the window to the corresponding column in the S1+SpinButton1.Value row, and the write statement is the same as the method in "Insert process information", except that the behavior is set to S1+SpinButton1.Value.

[0098] The process adjustment button SpinButton1 calls out the corresponding row process information according to the SpinButton1.Value value. Click the up and down arrows of the numerical adjustment button next to the process, and the window will display the information of the corresponding row of the numerical adjustment button values ​​from "Process Flow-Start" to "Process Flow-End". The specific operation is to first obtain the row positions of "Process Flow-Start" and "Process Flow-End" and assign them to E0 and E1, set P1=E1-E0, and the value range of SpinButton1 is 1 to P1. The information of the corresponding S1+SpinButton1.Value row is displayed in the corresponding text box of the window, which is the same as the assignment method in "Insert process information".

[0099] The process content, basic time, and operation time in the window are filled in manually. The expression symbol, responsible unit, equipment name, equipment model, tool name, and tool model in the window have fixed limited items or commonly used options, which are set to be selected from the drop-down list of the combo box. The equipment model and tool model generally have more items, which can be divided into several categories. The serial number in the model can be manually modified, which effectively improves the filling speed. The initial method is to use the .AddItem statement in the UserForm_Initialize() initial subroutine segment to add the initial drop-down list item to the combo box.

[0100] Step 303: Create a product feature information window.

[0101] Product Features Information Window (see Figure 4 ) is used to input the corresponding data in the basic table of product characteristics. Some data can be imported from the .xlsx file output by the bubble chart software, and then the corresponding measurement and control methods and gauge data are added and input into the product characteristics table.

[0102] The product characteristics information window displays product characteristics, measurement and control methods, and gauge information. Product characteristics include: (bubble) serial number, product characteristics, process specifications / tolerances; measurement and control methods include measurement technology, inspection capacity, inspection frequency, control methods, and reaction plans; gauge information includes gauge name, model / number, range, accuracy, and quantity. The "Product Characteristics Information" window does not contain process characteristics-related content and needs to be filled in manually based on actual conditions. The function buttons in the window include: extract characteristics, input measurement methods and tools, and gauge library. The button functions are implemented by programming the Click event subroutine segment. There are also serial number adjustment buttons SpinButton1 and row scroll buttons ScrollBar1, which are implemented by programming the Change event subroutine segment.

[0103] The operation of the window is based on the data related to "Product Characteristics" that has been imported from the file output by the bubble chart software (the table is unified, just copy and paste).

[0104] Extracting characteristics is used to directly input any serial number (bubble number) and then obtain the product characteristic information of the corresponding bubble number. The specific operation is to first find the row number where "end" is located and assign it to S, then traverse the "Product Characteristics" worksheet from the 3rd row to the Sth row, and when the same serial number (bubble number) as that in the window is found in column A, obtain the product characteristic information of the same row into the window, and make the value adjustment button and scroll bar move synchronously, and use the ScrollRow statement to scroll the worksheet to display this row of product characteristic information.

[0105] Inputting measurement methods and tools is used to import the completed "Measurement and Control Methods" and "Gauges" information into the corresponding serial number (bubble number) row of the "Product Characteristics" worksheet. The specific operation is to first obtain ScrollBar1.Value, and write the measurement and control methods and gauge information in the window into the ScrollBar1.Value row of the "Product Characteristics" worksheet.

[0106] The Gauge and Gauge Library function button is used to call the gauge and gauge information from the gauge and gauge library. The specific method is to first set the file selection dialog box through FileDialog, set the default gauge and gauge library folder, select the file from the default folder, and set the file type to *.xlsx; *.xls; *.xlsm files generated by Excel. The gauge information in the file is placed in fixed cells as required, and the gauge information is read into the text box corresponding to the gauge in the window in the form of assignment.

[0107] The folder of the measuring and checking tool library is divided into special measuring tools, thread plug gauges, thread ring gauges, smooth plug gauges, calibration ring gauges, rulers, three-pin gauges, templates, etc. according to actual usage. Special measuring tools generally include: three-coordinate, roughness tester, profile tester, tool setting instrument, two-dimensional height gauge, etc. At present, one measuring and checking tool corresponds to one .xlsx file, and one specific specification measuring and checking tool corresponds to a worksheet with a corresponding name in the .xlsx file. The worksheet uses fixed cells to store the measuring and checking tool information (such as Figure 5 ), select the .xlsx file and then select the corresponding worksheet in the window to directly reference it; or one specification of the gauge corresponds to a unique worksheet in the .xlsx file, and reference it by selecting the gauge specification corresponding to the .xlsx file name; or store multiple specifications of gauges in one worksheet, and reference it by retrieving the row or column of the corresponding gauge name according to the naming rules. Determine according to the company's gauge specification series characteristics and warehousing method.

[0108] The process adjustment button SpinButton1 assigns the corresponding serial number (bubble number) to SpinButton1.Value, obtains the product characteristics of the corresponding serial number (bubble number), clicks the up and down arrows of the adjustment button next to the "serial number" in the window, and the serial number (bubble number) increases or decreases with the adjustment button value, and displays the product characteristics and product process specifications / tolerances of the corresponding serial number. The specific operation is to first find the row number where "end" is located and assign it to S, then find the maximum value MaxValue in the bubble number, set the range of SpinButton1.Value from 1 to MaxValue, and then traverse the "Product Characteristics" worksheet from the 3rd row to the Sth row. When the serial number (bubble number) value of the A column of the "Product Characteristics" worksheet is equal to SpinButton1.Value, the information of the row corresponding to SpinButton1.Value is displayed in the corresponding text box in the window, and the scroll bar ScrollBar1 moves synchronously, and the worksheet is also scrolled to the appropriate position to display this row.

[0109] The row scroll button ScrollBar1 calls out product features according to the row number corresponding to ScrollBar1.Value. The specific operation is to first find the row number where "end" is located and assign it to S, set the range of ScrollBar1.Value from 1 to S-1, display the information of the row corresponding to ScrollBar1.Value in the corresponding text box in the window, and make the adjustment button SpinButton1 move synchronously, and the worksheet also scrolls to the appropriate position to display this row.

[0110] The window has fixed limited items or commonly used options for measurement technology, inspection capacity, inspection frequency, control method, reaction plan, gauge name, gauge model / number, gauge range, and gauge accuracy. Set them to be selected from the drop-down list of the combo box. The initial method is to use the .AddItem statement in the UserForm_Initialize() initial subroutine segment to add an initial drop-down list item to the combo box.

[0111] Step 304, creating a work step tool inspection window.

[0112] Tool inspection window (such as Figure 6 ) is used to input the corresponding data in the "Process Step Tool Gauge". Call the dimensions or tolerances formed by the process step, reference the gauge information from the "Product Characteristics" worksheet, and call the reference tool information and processing parameters from the tool library. You can modify them and enter them into the "Process Step Tool Gauge" table.

[0113] The work step tool inspection window displays work step information, processing parameters, and tool information. Work step information includes process, work step, work step content, and formed dimensions / tolerances. Processing parameters include spindle speed, feed rate, cutting depth, and feed times. Tool information includes tool name, composition, model / number, quantity, and quota. The window function buttons include: input work step information, modify work step information, add to list, modify list, and tool library. The button functions are implemented through the Click event handler. There is also a work step adjustment button SpinButton1, which is implemented through the Change event subroutine segment.

[0114] Inputting work step information is the input of new work step information. When there is already this work step content, insert this work step information in front of the corresponding work step, and the subsequent work step number needs to be modified; when there is no such work step content, insert the work step information filled in the window before the "end" line, and the subsequent work step moves down. Specific operation First, use the .Cells.Find() function to obtain the row position of "end" in the "Product Characteristics" and "Process Step Tool Gauge" worksheets, and assign it to E0 and E1. Traverse the "Process Step Tool Gauge" worksheet from row 3 to row S, and when the row corresponding to the process number and work step number is found, insert the work step content and tool information displayed in the window in this row. If the corresponding process number and work step number are not found, insert the work step content and tool name displayed in the window in the row where "end" is located in the "Process Step Tool Gauge" worksheet. Get the number of product characteristics and the number of tool components generated by the work step, take the larger value and assign it to E2, and insert a blank row of E2 in the next row of the current row. Write the tool composition, model / number, quantity and quota into the corresponding columns of the blank row; and extract the corresponding process number and step number from the "Product Characteristics" worksheet to complete the product characteristics and assign them to the corresponding columns of the blank row without having to enter them again in the window.

[0115] Modifying the work step information means rewriting the existing work step information, tool information and processing parameters after modifying them. The specific operation is to first obtain the row position of "end" in the "Product Characteristics" and "Process Step Tool Gauge" worksheets, and assign them to E0 and E1; obtain the number of product characteristics and tool components of this work step, and assign them to numItems1 and numItems2. Traverse the "Process Step Tool Gauge" worksheet from row 3 to row E1, and when you find the row corresponding to the process number and work step number, write the work step content, tool name and processing parameters displayed in the window in this row, overwriting the original data. After obtaining this row, assign the number of empty cells in column B to NonBlankRow, and clear the contents of these rows. When one of numItems1 and numItems2 is NonBlankRow, insert the row Max(numItems1,numItems2)–NonBlankRow after the current row, write the tool composition, model / number, quantity and quota into the corresponding column of the blank row; and extract the product characteristics with corresponding process number and step number from the "Product Characteristics" worksheet and assign them to the corresponding column of the blank row without re-entering them in the window.

[0116] Adding to the list means adding a set of tool composition, model / number, quantity and quota information filled in the upper combo box and text box to the list box below using the AddItem statement.

[0117] Modifying the list is to modify the tool information that is already in the list box. The premise is to extract the existing tool information into the upper combo box, set it through the UserForm_Initialize() program segment, extract and modify one or more information in the tool composition, model / number, quantity and quota, and then write it back to the list box. The specific operation is first when there is a selected item in the tool composition list item, get the index number of the selected tool composition, and assign it to selectedIndex, then rewrite the tool composition, model / number, quantity and quota information into the column item of the corresponding index number, replacing the original content. The statement is the same as "Add to List".

[0118] The tool library is to call the information and processing parameters of the reference tool from the tool library. There are many types of tools, which are suitable for calling the information and processing parameters of the reference tool from the tool library. If the actual data changes, modify it and then import it into the "Process Step Tool Gauge" worksheet. The specific method is the same as importing the gauge library. First, set the file selection dialog box through FileDialog, set the default tool library folder, select the file from the default folder, and set the file type to *.xlsx; *.xls; *.xlsm files generated by Excel. The tool information in the file is placed in a fixed cell as required, and the tool information is read into the text box corresponding to the tool information and processing parameters in the window by assignment.

[0119] The tool library folder is divided into drills, turning tools, reamers, countersinks, milling cutters, boring tools, taps, chamfering tools, etc. according to actual usage. Each tool currently used corresponds to a .xlsx file, and a specific tool corresponds to a worksheet with a corresponding name in the .xlsx file. The worksheet uses fixed cells to store tool information (such as Figure 7 ), select the .xlsx file and then select the corresponding worksheet in the window to directly reference it; or one tool can correspond to a unique worksheet in a .xlsx file and reference it by selecting the tool corresponding to the .xlsx file name; or store multiple tools of the same type in a worksheet and reference them by retrieving the row or column of the corresponding tool name according to the naming rules. Determine according to the company's tool specification series characteristics and warehousing method.

[0120] The step adjustment button SpinButton1 assigns SpinButton1.Value to the step number, and calls out the dimensions or tolerances (i.e., product characteristics and product process specifications / tolerances) formed under the step. If the step content, tool information, and processing parameters have been added, they will also be displayed. Click the up and down arrows of the numerical adjustment button next to "Step" in the window, and the step number will increase or decrease with the adjustment button value, and the corresponding step information will be displayed. The specific operation is to first find the row number where "end" is located and assign it to S, find the maximum value MaxValue in the bubble number, set the range of SpinButton1.Value from 1 to MaxValue, and then traverse the "Product Characteristics" worksheet from the 3rd row to the Sth row. When the value of the serial number (bubble number) in the A column of the "Product Characteristics" worksheet is equal to SpinButton1.Value, the information of the row corresponding to SpinButton1.Value is displayed in the corresponding text box in the window, and the scroll bar ScrollBar1 moves synchronously, and the worksheet is also scrolled to the appropriate position to display this row.

[0121] In the tool information of the tool inspection window of the work step, although the tool name, tool composition, and tool model / number can be obtained from the tool library, common items are also set for them, which can be selected from the drop-down list items in the combo box. The initial method is to use the .AddItem statement in the UserForm_Initialize() initial subroutine segment to add the initial drop-down list items to the combo box. In the initial program segment, it is also set that when an item in the tool composition list box is selected, the content will be displayed in the corresponding combo box in the upper row. The specific operation first defines the index number. When no item is selected in the tool composition list box, a selection prompt pops up. When an item is selected, the index number is obtained, and the tool composition, model / number, quantity and quota information corresponding to the selected index number in the multiple list boxes in the lower row are assigned to the corresponding combo box in the upper row.

[0122] Step 305, creating a process file generation window.

[0123] The process file generation window (such as Figure 8 ) is used to extract data from the basic table to form a process file in a standard format except for the cover, including single or full generation of process files and process file printing settings. Except for the follow-up "cover", other process files need to be completed through the function button program to complete file generation and printing settings. Generate the process file first, check it for problems, and then set it for printing. The printing settings mainly complete paging, insert headers and footers, and set the headers and footers to distinguish page numbers, etc., and finally output it in PDF format.

[0124] The process file generation window is divided into two parts: file generation and print settings. Each part consists of multiple function buttons. The function buttons in the file generation include: generate feature list, generate process flow chart, generate control plan, generate machining card, generate special inspection record, generate self-inspection record, generate tooling list, and generate directory function buttons. The function buttons in the print settings include: feature list print settings, process flow chart print settings, control plan print settings, machining card print settings, special inspection record print settings, self-inspection record print settings, and tooling list print settings. Each button function is implemented by the Click event subroutine segment.

[0125] Before formal writing, common worksheets and parameter variables are defined. For example, the "Basic Information" worksheet is defined as ws1, and its total number of rows is lastRow1; the "Product Characteristics" worksheet is defined as ws2, and its total number of rows is lastRow2; the "Process Step Tool Inspection Fixture" worksheet is defined as ws3, and its total number of rows is lastRow3; the "Process Special Characteristics List" worksheet is defined as ws1QingDan, the "Process Flow Chart" worksheet is defined as LiuChengTu, the "Control Plan" worksheet is defined as Kongzhijihua, the "Machining Card" worksheet is defined as Gongxukapian, the "Special Inspection Record" worksheet is defined as ZhuanJ, the "Self-Inspection Record" worksheet is defined as ZiJ, and the "Tooling List" worksheet is defined as GZyilanbiao.

[0126] Generate a feature list subroutine: traverse all rows of the "Product Features" worksheet. When there is "S / C" in the E column of the current row, if it is a repeated bubble number, go to the next row; if it is a non-repeating bubble number, reference the bubble number, product feature name + product process specification / tolerance and other information of the current row to the product and process special features list, and set the determination basis to "customer specified". Determine whether there are process characteristics in the next row, the next two rows, and the next three rows of the current row (currently, only the last three rows of the current row are judged, which can be adjusted as needed). If there are process characteristics, reference them to the product and process special features list, set the company feature mark to "▲", and the determination basis is "self-specified".

[0127] Generate process flow chart subroutine: traverse all rows between "Process Flow-Start" and "Process Flow-End" in the "Basic Information" worksheet, reference the process number, responsible unit, process content, processing equipment name and model, tooling name and model, basic time, operation time to the process flow chart, and define the flow symbol "◇○△□" according to the responsible department of the process. Then, traverse the third row to the last row of "Product Characteristics", according to the process number in the Mth column of the identification column, extract the "S / C" product characteristics formed under each process to the Wth column of the process flow chart, and judge whether there are process characteristic items in the last three rows of "S / C" product characteristics. If there are process characteristic items, merge them and place them in the AAth column.

[0128] Generate control plan subroutine: traverse all rows from 3 to "end" in "Product Characteristics", and reference bubble number, product characteristics, process characteristics, characteristic level, product process specification / tolerance, evaluation measurement technology, capacity / frequency, control method, and reaction plan to the control plan. When the process number in the Mth column of the identification column changes, insert the process name / operation description (process content) and the corresponding production equipment.

[0129] Generate machining card subroutine: traverse all lines from line 3 to S-1 of "process step tool gauge", and quote the step number, step content, characteristic level, spindle speed, feed rate, cutting depth, number of feeds, tool name and model, gauge name and model, range accuracy and quantity to the machining card. When the process number changes during the cycle, insert a page break in the previous line; and when the cumulative total line height exceeds the preset value, insert a page break in the previous line.

[0130] Generate special inspection records and self-inspection records: traverse all rows from 3 to "end" in "Product Characteristics". When the Kth column is "Special Inspection Record" ("Self-Inspection Record"), reference the bubble number, product characteristics, product process specifications / tolerances, and capacity / frequency to the special inspection record (self-inspection record).

[0131] Subroutine for generating a tooling list: traverse all rows from the third row to the last row of "Process and Step Tooling Gauges", summarize the tool name, model / number, quantity, and quota into the tooling list, display them in left and right columns, set the line break variable Pd = True, display them on the left first, and when the cumulative total line height exceeds the preset value, insert a page break in the previous row, and change the state of the line break variable Pd = False, and display them in summary on the right. After the tool is summarized, insert a page break, and then summarize the measuring and measuring tools, traverse all rows from the third row to the last row of "Process and Step Tooling Gauges", when the Mth column is a non-empty cell, exclude the special inspection and measuring tools, exclude the repeated self-inspection and measuring tools in the same process, summarize the name, model, range, accuracy, and quantity of the measuring and measuring tools into the tooling list, display them in left and right columns, set the line break variable Pd = True, display them on the left first, and when the cumulative total line height exceeds the preset value, insert a page break in the previous row, and change the state of the line break variable Pd = False, and display them in summary on the right. After the gauges are summarized, insert a page break, and then summarize the clamping fixtures. Traverse all the rows between "Process Flow-Start" and "Process Flow-End" in the "Basic Information" worksheet, and reference the fixture name, model / number and quantity, and process number to the fixture list. Other equipment and tools need to be filled in manually.

[0132] Generate Catalog" procedure: Use .PageSetup.Pages.Count to obtain the number of print pages set for the product and process special characteristics list, process flow chart, control plan, machining card, special inspection record, self-inspection record, and tooling list worksheet, and then assign the value to the corresponding cell.

[0133] Check the generated process file and proceed to "Print Settings" after checking that there are no problems.

[0134] The process document requires that each printed page must have a header and footer to express the basic information of the product, approval information, etc. The data in the above-generated process document is displayed continuously, and there is no header and footer set on each page, so it is necessary to process it through print settings to achieve print paging, insert headers and footers, add "total pages / page number", set the print area and output it as a PDF file. Table 1 analyzes the standard format of process documents and summarizes it into the following three situations:

[0135] Table 1 Process document standard format analysis table

[0136]

[0137]

[0138] The first method is applicable to the printing setting of product and process special characteristics list, process flow chart and control plan. The common point is that they all have headers, and the number of pages is placed in the header, without paging by process. The paging is controlled by the total line height. The total line height is the total line height of a single page minus the line height occupied by the header and footer. The specific value is different for different files.

[0139] The specific operation is to first obtain the total number of pages in the worksheet and the default number of pages to be printed, calculate the total number of pages after inserting the header and footer, and set the total row height. Then traverse all rows in the worksheet, obtain the current row height, and calculate the cumulative total row height. When the total row height is greater than the set value, set the number of pages in the current header, insert the header before the current row, and insert a page break HPageBreaks.Add Before:=QingDan.Rows(i) before the header (for product and process special characteristics lists: insert the footer and header before the current row, and insert a page break QingDan.HPageBreaks.Add Before:=QingDan.Rows(i+2) between the footer and header), the cumulative total row height is reset to zero, the current page number is increased by one page, and the cycle continues until the last row. Finally, through the statement ExportAsFixedFormat Type:=xlTypePDF,fileName:=pdfPath,Quality:=xlQualityStandard,IncludeDocProperties:=True,IgnorePrintAreas:=False, set the print to PDF file and save it in the specified directory with the specified name.

[0140] The second printing setting method is applicable to machining cards and tooling lists. The common point is that they have a header and a footer. The number of pages is placed in the header, and the pages are divided by process or tooling type. Machining cards are divided by process, and the pages are divided by the total line height within the process; the tooling list is divided by tools, measuring tools, and fixtures, and is displayed in two columns. The pages are divided by the total line height within the same category. The pages are already divided when the file is generated.

[0141] The specific operation is to first obtain the total number of rows, pages and page breaks in the worksheet, define page breaks, obtain the page breaks in the worksheet, then traverse all page breaks in the worksheet from the back to the front, obtain the row number of the current page break, set the number of pages in the current header, insert Rows(hPageBreaks4(i).Location.Row) into the footer before the current page break, and insert Rows(hPageBreaks4(i).Location.Row+1) into the header after the current page break. Finally, set the area except the top footer row as the print area, and use the statement ExportAsFixedFormat Type:=xlTypePDF,fileName:

[0142] =pdfPath,Quality:=xlQualityStandard,IncludeDocProperties:=True,IgnorePrintAreas:

[0143] =False sets the print to a PDF file and saves it in the specified directory with the specified name.

[0144] The third printing setting method is applicable to special inspection records and self-inspection records. The common point is that they all have headers and footers. When the file is generated, the pages are divided according to the process. When setting up printing, it is necessary to divide the pages according to the total row height within the process. The header is set according to the print title bar, and then the footer is inserted before the page break. The total number of pages and the page number are set in the footer.

[0145] The specific operation is to first obtain the total number of rows, pages and page breaks in the worksheet, define page breaks, traverse all page breaks in the worksheet, obtain the number of rows between the current page break and the next page break in the worksheet, traverse all rows between two page breaks, obtain the current row height, and calculate the cumulative total row height. When the total row height is greater than the set value, insert a page break before the current row, and loop until all page breaks are paginated according to the total row height. Then define page breaks, obtain all current page breaks in the worksheet, and then traverse all page breaks in the worksheet from back to front, obtain the number of rows where the current page break is located, set the number of pages in the current header, and insert Rows(hPageBreaks4(i).Location.Row) into the footer before the current page break. Finally, set the header to the print title row, set the area except the top footer row to the print area, and use the statement ExportAsFixedFormat Type:=xlTypePDF,fileName:=pdfPath,Quality:=

[0146] xlQualityStandard,IncludeDocProperties:=True,IgnorePrintAreas:=False sets the print to a PDF file and saves it in the specified directory with the specified name.

[0147] Step 4: Create the process file and its custom tools in the custom tab.

[0148] The five custom windows of the process file generation template are customized by customizing the "Process File" tab (see Fig. 9 ) in the custom tool association macro statement call, the custom tools set are: reference, generate process file, process step tool fixture, process flow process, product feature information, which correspond to the above five custom windows one by one, and use the Show statement to call the custom window. Reference, product feature information, process flow process, and process step tool fixture are used for data input, and generate process file for data output.

[0149] Step 5, check the template and improve the template. Step 5 includes the following steps 501 to 508:

[0150] Step 501, open the template, and enter basic information, review information, and change information in the basic information worksheet.

[0151] Step 502, call the "Process Flow Procedure" window to fill in the process flow information in the basic information worksheet.

[0152] Step 503, calling the product characteristic information window to fill in the product characteristic worksheet and inputting information such as product characteristics, measurement and control methods, and measuring tools.

[0153] Step 504, calling the process step tool inspection and fixture window to fill in the process step tool inspection and fixture worksheet and input the process step information, tool information, processing parameters, etc.

[0154] Step 505, call the process file window, click the function button of the file to be generated: generate feature list, generate process flow chart, generate control plan, generate machining card, generate special inspection record, generate self-inspection record, generate tooling list, generate catalog.

[0155] Step 506, check the generated process file table and supplement the individual setting content.

[0156] Step 507, call the process file window, click the print setting function button corresponding to the file to be printed: characteristic list print setting, process flow chart print setting, control plan print setting, machining card print setting, special inspection record print setting, self-inspection record print setting, tooling list print setting, and output the print file in PDF format.

[0157] Step 508, check whether the generated PDF file meets the requirements, mainly check whether the content extraction is correct, check whether the paging is reasonable and compliant, check whether the last blank line occupies extra pages, check whether the number of pages is displayed normally, etc. If it does not meet the requirements, it needs to be adjusted and modified and then reprinted into a PDF file.

[0158] Through the operation process from step 501 to step 508, it is checked whether the template can meet normal use, whether it can input information efficiently and accurately, whether it can accurately and automatically output process files and print them into PDF files, and the template is continuously improved to meet the needs.

[0159] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that modifying the technical solutions described in the aforementioned embodiments, or replacing some or all of the technical features therein by equivalents, does not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.

Claims

1. A method for creating a process file template, characterized in that: include: Step 1, create three blank basic worksheets; The basic worksheets include: basic information worksheet, product characteristics worksheet, process step tool inspection tool worksheet; Step 2, create nine blank process document worksheets; the blank process document worksheets include: unfilled cover, catalog, product and process special characteristics list, process flow chart, control plan, machining card, special inspection record, self-inspection record, tooling list blank worksheet; Step 3, creating five custom windows for quickly inputting information and outputting process files; the custom windows include: a reference window, a process flow window, a product feature information window, a tool inspection window, and a process file generation window; Step 4, create the process file and its custom tools in the custom tab; Step 5: Check and improve the template.

2. The method for creating a process document template according to claim 1, characterized in that: The step 1 includes the following steps 101 to 103: Step 101, creating a blank basic information worksheet; the basic information worksheet includes: basic information, review information, change information, and process flow; Step 102, creating a blank product characteristics worksheet; the product characteristics worksheet includes: serial number, product characteristics, completion steps, process characteristics, characteristic level, product process specification, evaluation measurement technology, capacity, control method, reaction plan, and process; Step 103, creating a blank process step tool gauge worksheet; the process step tool gauge worksheet includes: process, process step, process step content, characteristic level, spindle speed, feed rate, cutting depth, feed times, tool name, model, quantity and quota, and name, model, range, accuracy and quantity of the gauge corresponding to the process step.

3. The method for creating a process document template according to claim 1, characterized in that: The step 2 includes the following steps 201 to 208: Step 201, creating an unfilled cover according to demand; Step 202, creating an unpopulated directory according to the requirements; Step 203, create a blank product and process special characteristics list according to the requirements; Step 204, creating a blank process flow chart according to the requirements; Step 205, create a blank control plan according to the requirements; Step 206, creating a blank machining card according to the requirements; Step 207, create blank special inspection records and self-inspection records according to requirements; Step 208, create a blank tooling list according to requirements.

4. The method for creating a process document template according to claim 1, characterized in that: The step 3 includes the following steps 301 to 305: Step 301, creating a reference window; The reference window displays the source file directory, starting cell, ending cell, and target starting cell of the reference data; the window includes function buttons such as browse source file, select worksheet, starting cell, ending cell, target starting cell, and copy reference information. The button function can copy a large amount or part of the copy reference information from the source file to the current template workbook by compiling a Click event subroutine segment, which is especially suitable for copying multiple rows of content with merged columns; Step 302, creating a process flow window; The process window is used to input the process data in the basic information table. The window displays the process content, equipment, tooling and beat information. The function buttons in the window include inserting process information and modifying process information. The buttons can realize the function of inputting and modifying the process flow related data in the basic information worksheet by compiling the Click event subroutine segment. There is also a process adjustment button SpinButton1, which can realize the function of displaying the corresponding process information in the window by compiling the Change event subroutine segment. Step 303, creating a product characteristic information window; The product characteristic information window is used to input the corresponding data in the product characteristic basic table. The window displays the product characteristics, measurement and control methods, and measuring and measuring tool information. The function buttons in the window include extracting characteristics, inputting measurement methods and tools, and measuring and measuring tool library. The buttons can extract existing information, input new information, and call information from the measuring and measuring tool library by compiling the Click event subroutine segment. There are also the sequence number adjustment button SpinButton1 and the row scroll button ScrollBar1. The function of displaying information by bubble number or row is realized by compiling the Change event subroutine segment. Step 304, creating a work step tool inspection window; The step tool gauge window is used to input the corresponding data in the process step tool gauge basic table. The window displays the step information, processing parameters, and tool information. The window function buttons include input step information, modify step information, add list, modify list, and tool library. The button functions realize the functions of inputting and modifying step information, adding and modifying tool information, and calling tool information and processing parameters from the tool library through the Click event handler. There is also a step adjustment button SpinButton1, which realizes the function of displaying the corresponding existing information in the window through the Change event subroutine segment, including calling the size or tolerance characteristics and gauge information formed by the corresponding step in the product characteristics worksheet; Step 305, creating a process file generation window; The process file generation window is divided into two parts: file generation and print settings. Each part consists of multiple function buttons, and the function of each button is realized by the Click event subroutine segment. Generate a file to extract data from the basic table to form a process file in a standard format except for the cover. After checking that there are no problems with the process file, perform print settings. The print settings mainly complete paging, insert headers and footers, and set the headers and footers to distinguish page numbers and content, and finally output in PDF format.

5. The method for creating a process document template according to claim 1, characterized in that: The step 5 includes the following steps 501 to 508: Step 501, open the template, and enter basic information, review information, and change information in the basic information worksheet; Step 502, calling the process flow window to fill in the process flow information in the basic information worksheet; Step 503, calling the product characteristic information window to fill in the product characteristic worksheet and inputting the product characteristics, measurement and control methods, and measuring tools; Step 504, calling the work step tool inspection tool window to fill in the process step tool inspection tool work table and input the work step information, tool information, and processing parameters; Step 505, calling the process file window, clicking the function button of the file to be generated, generating a list of characteristics, generating a process flow chart, generating a control plan, generating a machining card, generating a special inspection record, generating a self-inspection record, generating a tooling list, and generating a catalog; Step 506, check the generated process file table and supplement the separate setting content; Step 507, calling the process file window, clicking the print setting function button corresponding to the file to be printed, the characteristic list print setting, process flow chart print setting, control plan print setting, machining card print setting, special inspection record print setting, self-inspection record print setting, tooling list print setting, and outputting the print file in PDF format; Step 508, check whether the generated PDF file meets the requirements. If not, it needs to be adjusted and modified and then reprinted into a PDF file.

Images