Method for converting format of three-coordinate detection report and summarizing and analyzing data

Abstract

The invention discloses a three-coordinate detection report format conversion and data summarization analysis method, which comprises the following steps of: firstly, automatically extracting bottom-layer source measurement data, circularly traversing each size of a measurement program, acquiring multiple types of key data such as theoretical values and actual measurement values, normatively storing the key data into an Excel table, processing an Excel file by a Python code, and constructing a typical data structure of a character; mapping from a source data measured value to a result file table is realized; meanwhile, automatically extracting a'drawing requirement size 'value of a template file, mapping the'drawing requirement size' value to a'drawing specified value 'value of a result file, judging the size qualification condition according to the value, and writing an out-of-tolerance value into a corresponding column; suffixes are added to report file names according to whether all sizes of the parts are qualified or not, a tolerance release function is set, and tolerance judgment standards are changed by adjusting variables; and finally, summarizing all measurement report data to a Word file, and presenting batch sequence numbers and size extreme value ranges of the parts. According to the invention, report formats are unified, batch summary analysis is realized, the quality control flexibility is considered, and the detection efficiency and the quality control level are improved.

Description

Technical Field

[0001] The invention relates to the field of mechanical manufacturing, in particular to a data measurement integration and analysis method. Background Art

[0002] In the field of modern precision manufacturing, three-coordinate measurement technology is widely used in the detection of component dimensional accuracy. However, the measurement report link closely related to it has many drawbacks. At present, the measurement reports of three-coordinate measuring machines have different formats due to the diversity of measurement software, which greatly hinders the interpretation of data. The output reports of measurement software of different brands or different versions of the same brand lack unified standards in data layout, identification symbols, numerical accuracy, etc. Users need to spend a lot of time and energy to familiarize themselves with and adapt to various formats, and are prone to errors in the process of data reading and understanding, affecting the detection efficiency and quality judgment accuracy.

[0003] For batch measurement tasks, the defects of the existing reporting model are more prominent. On the one hand, there is a lack of a summary presentation mechanism for the measurement results of the entire batch of parts. If you want to fully understand the dimensional measurement status of a batch of parts, you can only check the measurement reports of each part one by one. The operation is cumbersome, time-consuming and labor-intensive, and seriously wastes manpower costs. On the other hand, the measurement report is not intuitive enough to display the dimensional measurement status, and it is impossible for users to quickly grasp key information. For example, it is difficult to clearly know whether the part size is qualified, the overall dimensional deviation trend, and the distribution of unqualified dimensions directly from the report. In addition, the storage and management of many electronic measurement reports in mixed formats are extremely inconvenient, data integration is difficult, and retrieval and call efficiency are low, which sets up many obstacles for the company's quality control, process optimization and data traceability. It is difficult to meet the needs of efficient production and refined quality management, and innovative solutions are urgently needed to break through and improve. Summary of the invention

[0004] In order to solve the above problems, the present invention discloses a method for converting the format of a three-coordinate detection report and summarizing and analyzing data.

[0005] The specific technical solutions are as follows:

[0006] A method for converting the format of a three-coordinate detection report and summarizing and analyzing data includes the following steps:

[0007] Step 1): Automatically extract the underlying source measurement data, and loop through each dimension in the measurement program to obtain the data items of "theoretical value", "measured value", "upper tolerance", "lower tolerance", "deviation value", "exceeding value", "measuring equipment number", "batch sequence number", "part number", "process number", and "process name"; write the obtained data into an Excel table in the specified format, and the Excel table file name is saved in the "batch sequence number".XLSX format;

[0008] Step 2): Use Python code to loop through all Excel files generated in Step 1) within the specified folder. For each file, construct a dictionary-type data structure with the dimension number as the keyword to establish a one-to-one correspondence between the dimension information in the source data file and the result file, and map the measured values of the source data into the table of the result file;

[0009] Step 3): Automatically extract the values in the "Drawing Required Dimensions" column of the template file, and map these values into the "Drawing Specified Values" of the result file according to the corresponding rule of the dimension number between the template file and the result file. Compare the drawing specified values in the result file with the measured values obtained in Step 2), and judge whether the dimension is qualified according to the upper and lower tolerances.

[0010] After obtaining the result of whether the dimension is qualified in Step 3), if all dimensions of the part are qualified, the file name suffix is "-Y"; otherwise, if there are unqualified dimensions, the suffix name is "-N";

[0011] After judging whether the dimension is qualified in Step 3), write the out-of-tolerance value into the "Out-of-Tolerance Value" column of the result file.

[0012] Method for realizing the tolerance release function of the measurement report: Before comparing the drawing specified value and the measured value in the result file in Step 3), set a tolerance release adjustable variable, the initial default value of this variable is 0, and when the user checks the "Tolerance Release" option, the variable value changes to 0.01; if the user manually checks and writes a specific value, the variable value is adjusted to the user input value;

[0013] Based on all the processed measurement report data in Step 3), perform a summary operation, store the summary data in a Word file, and in this Word file, write the batch sequence numbers of all parts into the table header in order; calculate the maximum and minimum values of each dimension of all parts and represent the range of this dimension; when there is an unqualified situation for a certain dimension, highlight the relevant dimension information in red font in the Word file.

[0014] The advantages of the present invention are: The measurement result formats of different measuring machines are unified into one kind. For parts with batch measurement, the overall state of the parts can be quickly understood by viewing the automatically generated summary report. Brief Description of the Drawings

[0015] Figure 1 It is a schematic diagram of the source data table;

[0016] Figure 2 It is a schematic diagram of the processing of the source data table and the result file;

[0017] Figure 3 It is a schematic diagram of the processing of the template file and the result file;

[0018] Figure 4 It is a schematic diagram of the summary file. Specific implementation manners

[0019] Next, the technical solutions in the embodiments of the present invention will be clearly and completely described in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only a part of the embodiments of the present invention, rather than all the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

[0020] A method for converting the format of a three-coordinate inspection report and summarizing and analyzing data includes the following steps:

[0021] Step 1): Automatically extract the underlying source measurement data. By looping through each dimension in the measurement program, obtain data items such as "theoretical value", "measured value", "upper tolerance", "lower tolerance", "deviation value", "out-of-tolerance value", "measurement equipment number", "batch sequence number", "part number", "process number", and "process name"; write the obtained data into an Excel sheet according to the specified format, and save the Excel sheet file name in the format of "batch sequence number".XLSX; as Figure 1 shown;

[0022] Step 2): Use Python code to loop through all the Excel files generated in Step 1) in the specified folder. For each file, construct a dictionary-type data structure with the dimension number as the key to establish a one-to-one correspondence between the dimension information in the source data file and the result file (i.e., the inspection report in the accompanying drawings of the specification), and map the measured value of the source data into the table of the result file; as Figure 2 shown;

[0023] Step 3): Automatically extract the values in the column of "drawing requirement dimensions" in the template file, and map these values to the "drawing specified value" in the result file according to the corresponding rule of the dimension number between the template file and the result file. Compare the drawing specified value in the result file with the measured value obtained in Step 2), and judge whether the dimension is qualified according to the upper and lower tolerances, as Figure 3 shown.

[0024] After obtaining the result of whether the dimension is qualified in Step 3), if all the dimensions of the part are qualified, the suffix of the report file name is "-Y", otherwise, if there are unqualified dimensions, the suffix name is "-N";

[0025] After judging whether the dimension is qualified in Step 3, write the out-of-tolerance value into the column of "out-of-tolerance value" in the result file, as Figure 3 shown.

[0026] The implementation method of the tolerance release function of the measurement report is as follows: in step 3), before comparing the specified value of the drawing and the measured value in the result file, set the tolerance release adjustable variable. The initial default value of the variable is 0. When the user checks the "tolerance release" option, the variable value is changed to 0.01; if the user manually checks and writes a specific value, the variable value is adjusted to the user input value;

[0027] Based on all the processed measurement report data in step 3), a summary operation is performed and the summary data is stored in a Word file. In this Word file, the batch sequence numbers of all parts are sequentially written into the header; the maximum and minimum values ​​of each dimension of all parts are calculated, and the range of the dimension is represented; when a dimension is unqualified, the relevant dimension information is prominently displayed in red font in the Word file, such as Figure 4 shown.

[0028] The beneficial effects of the present invention are:

[0029] After the unified format, users no longer need to adapt to various complex formats, and can quickly and accurately read key information, such as the theoretical value, measured value, tolerance range and quality judgment results of each dimension of the part, which significantly reduces the cost of data understanding, improves the efficiency and accuracy of inspection work, and lays a solid foundation for cross-equipment and cross-department data collaboration. In the past, it was necessary to read the report one by one to view the measurement status of the entire batch of parts, which was complicated and inefficient. Now, by automatically generating summary reports, quality management personnel can intuitively understand the maximum value and range of each dimension of all parts in the same file, and quickly identify unqualified dimensions and corresponding part numbers (with red marks for eye-catching prompts). This helps to accurately grasp the overall quality of batch parts, and timely detect quality fluctuation trends and potential risk points, such as frequent over-tolerance of a certain dimension or overall deviation tendency, so as to optimize the production process, adjust equipment parameters or strengthen raw material inspection in a targeted manner, effectively enhance quality control efficiency, reduce scrap rate, and improve the overall quality stability of products. In addition, the unique tolerance release function injects flexibility into the production process. In actual manufacturing, due to factors such as raw material characteristics, processing technology fluctuations or urgent production tasks, some parts are still valuable even though they are slightly over-tolerance. The traditional mode is rigid and prone to unnecessary waste and delays. The tolerance release function of the present invention makes the tolerance judgment standard dynamically adjustable according to user needs. Users can accurately relax the judgment scale according to specific circumstances. Under the premise of ensuring the basic function and quality reliability of the product, it avoids excessive scrapping and production stagnation, effectively balances quality requirements and production efficiency, and optimizes resource allocation.

Claims

1. A method for converting the format of a three-coordinate detection report and summarizing and analyzing data, characterized in that: The steps include: Step 1): Automatically extract the underlying source measurement data, and loop through each dimension in the measurement program to obtain the data items of "theoretical value", "measured value", "upper tolerance", "lower tolerance", "deviation value", "exceeding value", "measuring equipment number", "batch sequence number", "part number", "process number", and "process name"; write the obtained data into an Excel table in the specified format, and the Excel table file name is saved in the "batch sequence number".XLSX format; Step 2): Use Python code to loop through all Excel files generated in the specified folder according to step 1), and for each file, use the size number as a keyword to construct a typical data structure, so as to establish a one-to-one correspondence between the size information in the source data file and the result file, and map the measured value of the source data to the table in the result file; Step 3): Automatically extract the value of the "Drawing Required Dimensions" column in the template file, and map the value of this column to the "Drawing Specified Values" in the result file according to the corresponding rules of the size numbers in the template file and the result file. Compare the drawing specified values ​​in the result file with the actual measured values ​​obtained in step 2), and determine whether the dimensions are qualified based on the upper and lower tolerances.

2. The software programming method for converting the three-coordinate detection report format and summarizing and analyzing data according to claim 1 is characterized in that: After obtaining the result of whether the dimensions are qualified in step 3), if all dimensions of the part are qualified, the report file name suffix is ​​"-Y", otherwise, if there are unqualified dimensions, the suffix is ​​"-N".

3. The software programming method for converting the three-coordinate detection report format and summarizing and analyzing data according to claim 1 is characterized in that: After determining whether the size is qualified in step 3, the deviation value is written into the "deviation value" column of the result file.

4. The software programming method for converting the three-coordinate detection report format and summarizing and analyzing data according to claim 1 is characterized in that: The method for implementing the tolerance release function of the measurement report is as follows: in step 3), before comparing the specified value in the drawing with the measured value in the result file, set the tolerance release adjustable variable. The initial default value of the variable is 0. When the user checks the "Tolerance Release" option, the variable value changes to 0.01; if the user manually checks and writes a specific value, the variable value is adjusted to the user input value.

5. The software programming method for converting the three-coordinate detection report format and summarizing and analyzing data according to claim 1 is characterized in that: Based on all the processed measurement report data in step 3), a summary operation is performed and the summary data is stored in a Word file. In the Word file, the batch serial numbers of all parts are written into the header in order; the maximum and minimum values ​​of each dimension of all parts are calculated, and the range of the dimension is represented; when a certain dimension is unqualified, the relevant dimension information is prominently displayed in red font in the Word file.

Images