Factory process capability index evaluation method, device, server and storage medium

Abstract

Embodiments of the present application relate to the field of data processing, and disclose a factory process capability index evaluation method and device, a server and a storage medium. In the embodiments of the present application, a to-be-downloaded file is obtained according to each download address; wherein the to-be-downloaded file in the download address is updated according to a preset time period; data cleaning is performed on the to-be-downloaded file to obtain parameters used for calculating a process capability index; the parameters are loaded to a database; the process capability index is calculated according to the parameters in the database; and the calculation result and the parameters are displayed. The implementation of the present application is not limited to the evaluation of the factory process capability index in only a certain specific format, supports multiple data formats and performs data cleaning, can realize batch processing and calculation of parameters, automatically downloads the massive test data of each factory to the local in increments, loads the increments to the database, integrates the calculation results, and displays the results by using a report.

Description

TECHNICAL FIELD

[0001] Embodiments of the present application relate to the field of data processing, in particular to a factory process capability index evaluation method and device, a server and a storage medium. BACKGROUND

[0002] In the process of product manufacturing, process capability (process) is the most basic link to ensure product quality. The so-called process capability refers to the actual processing capability under stable state, the ability to stably produce products, that is, under the standard conditions of operators, machines and equipment, raw materials, operation methods, measurement methods and environment, the process has the processing precision under stable state. Process capability analysis is an important technical foundation work of quality management. It helps to master the quality of each process, ensures the capability, and provides necessary information and basis for product design, process, tooling design, equipment maintenance, adjustment, updating and transformation.

[0003] The traditional evaluation of factory process capability index is generally based on the CPK software, but when calculating the process capability index based on the software, only excel format data import and export are supported, and it is limited by the data capacity of excel; after obtaining the calculation results, manual integration of other data sources is required for comprehensive viewing, which further increases the risk of data errors; in summary, the existing process of calculating process capability index based on software has the problems of complex operation, manual intervention, single evaluation dimension, and inability to comprehensively display. SUMMARY

[0004] The purpose of the embodiments of the present application is to provide a factory process capability index evaluation method and device, a server and a storage medium, so that the factory process capability index can be automatically calculated in batches, and multi-dimensional comprehensive evaluation and display can be performed.

[0005] To solve the above technical problems, the embodiments of the present application provide a factory process capability index evaluation method, comprising the following steps: obtaining a to-be-downloaded file according to each download address; wherein the to-be-downloaded file in the download address is updated according to a preset time period; performing data cleaning on the to-be-downloaded file to obtain parameters for calculating process capability index; loading the parameters to a database; calculating process capability index according to the parameters in the database; and displaying the calculation results and the parameters.

[0006] The embodiment of the present application further provides a factory process capability index evaluation device, which comprises a downloading module configured to acquire a to-be-downloaded file according to each downloading address; wherein the to-be-downloaded file in the downloading address is updated according to a preset time period; an acquiring module configured to perform data cleaning on the to-be-downloaded file and acquire parameters for calculating a process capability index; a loading module configured to load the parameters into a database; a calculating module configured to calculate the process capability index according to the parameters in the database; and a display module configured to display the calculation result and the parameters.

[0007] The embodiment of the present application further provides a server, which comprises at least one processor and a memory connected with the at least one processor; wherein the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the factory process capability index evaluation method.

[0008] The embodiment of the present application further provides a computer readable storage medium, which stores a computer program, and the computer program is executed by a processor to implement the factory process capability index evaluation method.

[0009] The embodiment of the present application is not limited to the evaluation of the factory process capability index in a specific format, reduces the steps of processing the data source format of the parameters, and avoids the limitation of the amount of processable data caused by the data format. In the embodiment of the present application, a plurality of data formats are supported and data cleaning is performed, the parameters can be processed and calculated in batches, the massive test data of each factory is automatically downloaded to the local in increments, the calculation result is integrated by loading the data to the database, and the result is displayed by a report. The calculation and evaluation efficiency of the factory process capability index is improved. Since a plurality of data formats are supported for input and calculation, the process of manually exporting and processing data and then merging and displaying the data can be avoided, and the labor and time cost is reduced.

[0010] In addition, the data cleaning on the to-be-downloaded file to acquire the parameters for calculating the process capability index comprises: acquiring a file conforming to a preset format in the to-be-downloaded file; acquiring a readable file in the file conforming to the preset format; and classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index. The cleaning action is performed in a predetermined order, the complexity of the data cleaning process is reduced, the speed of the data cleaning is improved under the condition that the completion degree of the data cleaning step is ensured, and the calculation resource occupation of the data cleaning process is reduced.

[0011] In addition, the classified and integrated data in the readable file to obtain the parameter for calculating the process capability index comprises: classified and integrated data in the readable file; merging the integrated data into a preset table; and obtaining the parameter for calculating the process capability index according to the preset table. The classified and integrated data in the form of a table facilitates unified and standardized management.

[0012] In addition, the classified and integrated data in the readable file comprises: splitting the data in the readable file according to content attributes, and the splitting result is in a format capable of performing calculation; and classifying the splitting result according to work orders to obtain the integrated result of the data in the readable file. Splitting and integrating the cleaned files can improve calculation efficiency, and classifying the splitting result according to work orders facilitates targeted calculation and comprehensive display of a certain work order.

[0013] In addition, before obtaining the to-be-downloaded file according to each download address, the method further comprises: obtaining a file name of each to-be-downloaded file according to each download address, and the file name is used for unified management of the file. Since the embodiment can obtain and process multiple files and the file formats are not necessarily unified, firstly obtaining the file name can facilitate batch and rapid management of the files.

[0014] In addition, the method further comprises: obtaining the to-be-downloaded file according to the file name and the download address. After obtaining the file name of the to-be-downloaded file, the file in the download address can be downloaded according to the file name of the to-be-downloaded file, so as to save download time.

[0015] In addition, the calculation of the process capability index according to the parameter comprises: if the configuration is a default mode, calculating the process capability index according to the default mode and the parameter; and if the configuration is a non-default mode, receiving a user input instruction and calculating the process capability index according to the user instruction and the parameter. The calculation mode of the process capability index is flexible, and can be adaptively adjusted according to user demand, so as to improve user experience. BRIEF DESCRIPTION OF DRAWINGS

[0016] One or more embodiments are illustrated by way of example in the figures that are part of this document, and which illustrate by way of example the principles of the embodiments. The embodiments are not limited to the examples of drawings. Elements having the same reference numerals in the figures indicate like elements unless otherwise specifically stated. The figures in the drawings are not necessarily to scale, except if specifically stated.

[0017] Figure 1 is a flowchart of a factory process capability index evaluation method according to an embodiment of the present application;

[0018] Figure 2 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure One ;

[0019] Figure 3 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Two ;

[0020] Figure 4 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Three ;

[0021] Figure 5 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Four ;

[0022] Figure 6 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure One ;

[0023] Figure 7 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Two ;

[0024] Figure 8 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Three ;

[0025] Figure 9 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Four ;

[0026] Figure 10 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application Figure Five ;

[0027] Figure 11 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application

[0028] Figure 12 is a schematic diagram of a factory process capability index evaluation method according to an embodiment of the present application DETAILED DESCRIPTION

[0029] For the purposes of making the objectives, technical solutions and advantages of the embodiments of the present application clearer, the various embodiments of the present application will be described in detail below with reference to the drawings. However, those skilled in the art can understand that, in the various embodiments of the present application, many technical details are presented in order to make the readers better understand the present application. However, the technical solutions claimed by the present application can be implemented even without these technical details and based on various changes and modifications of the following embodiments. The division of the following various embodiments is for the convenience of description, and should not constitute any limitation on the specific implementation of the present application, and the various embodiments can be combined with each other and referenced to each other without contradiction.

[0030] The terms "first", "second" in the embodiments of the present application are only used for descriptive purposes, and cannot be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features. Therefore, the features defined with "first", "second" can be explicitly or implicitly included at least one of the features. In the description of the present application, the terms "include" and "have" and any variations thereof are intended to cover non-exclusive inclusion. For example, a system, product or device including a series of components or units is not limited to the listed components or units, but optionally further includes components or units not listed or optionally further includes other components or units inherent to these products or devices. In the description of the present application, the meaning of "a plurality of" is at least two, for example, two, three, etc., unless otherwise explicitly and specifically limited.

[0031] One embodiment of the present application relates to a factory process capability index evaluation method. The specific process is as shown in Figure 1

[0032] Step 101, obtaining the to-be-downloaded file according to each download address; wherein the to-be-downloaded file in the download address is updated according to a preset time period;

[0033] Step 102, data cleaning is performed on the to-be-downloaded file to obtain parameters for calculating the process capability index;

[0034] Step 103, loading the parameters to the database;

[0035] Step 104, calculating the process capability index according to the parameters in the database;

[0036] Step 105, displaying the calculation result and the parameters.

[0037] ​In this embodiment, the evaluation of the plant process capability index is not limited to a specific format, which reduces the steps of processing the data source format of the parameters and avoids the limitation on the amount of data that can be processed caused by the data format. At the same time, in this embodiment of the application, multiple data formats are supported and data cleaning is performed, which can realize batch processing and calculation of parameters, automatically download the massive test data of each factory to the local computer, load the incremental data into the database, and display the results of the integrated calculation in a report. The efficiency of the calculation and evaluation of the plant process capability index is improved. Since it supports the input and calculation of multiple data formats, it can also avoid the steps of manual data export, processing, and merging for display, reducing labor and time costs.

[0038] The following is a detailed description of the implementation details of a plant process capability index evaluation method of this embodiment. The following content is only for the convenience of understanding the implementation details and is not necessary for the implementation of this solution.

[0039] In step 101, files to be downloaded are obtained according to each download address; wherein, the files to be downloaded in the download address are updated according to a preset time period. The update includes adding new files to be downloaded by automatically crawling, or deleting some files to be downloaded according to user instructions; the preset time period can be adaptively modified according to actual needs. The format of the files to be downloaded is not limited to a specific type. For example, unstructured data formats such as txt, CSV (Comma-Separated Values, character separated values) and excel are supported. For databases, sqlserver (Structured Query Language, Structured Query Language), mysql (relational database management system), excel, etc. are supported. Various data sources of data acquisition channels (such as within the company) can be integrated, including text and database data, to avoid data silos. In one example, the files to be downloaded are loaded into a designated directory according to each download address to facilitate subsequent centralized processing.

[0040] In one example, the download address can be obtained by receiving user input; or, when downloading is required, it can be read one by one from path data. The path data can be a set of preset download addresses, and the path data supports batch management of download addresses. When reading the download addresses one by one from the path data, a loop mode can be adopted, that is, reading one by one in a certain order and then looping back from the beginning to ensure that the downloaded addresses in the path data are changed, such as newly added download addresses, can be obtained.

[0041] In one example, before obtaining the to-be-downloaded file according to each download address, it is determined whether the download address is valid. The valid download address includes, but is not limited to, the download address of the to-be-downloaded file, the new download address after the change, and the like. For example, after performing the download operation on the file in a download address, the downloaded file is added with a download completion identifier. When it is detected that the file in the download address all has the download completion identifier, the download address is classified as an invalid address. When it is detected that the file in the download address does not carry the download completion identifier, the download address is a valid address. Only the valid download address is processed, the download resource can be effectively utilized, the efficiency of the file download is improved, and the resource occupation for processing the repeated file in the subsequent process is avoided.

[0042] In one example, before obtaining the to-be-downloaded file according to each download address, it further includes: obtaining the file name of each to-be-downloaded file according to each download address. The file name is used for uniformly managing the file. Since the embodiment can obtain and process multiple files and the file format is not necessarily uniform, in order to facilitate the management of the file, the file name of the file can be obtained before the file is downloaded. For example, the to-be-downloaded file name is arranged in a table form. It is convenient and fast to identify the data in the table, and then the management process of the file can be performed in batches and quickly. In one example, the to-be-downloaded file name can be obtained from the FTP (File Transfer Protocol) server according to the download address, and the obtained to-be-downloaded file name is combined into an xml file format. The xml file is stored in a specific directory (for example, ETL_CPK_ExcelFile). The file name of the to-be-downloaded file is read by parsing the xml file, so as to improve the speed of obtaining the file name. In addition, it can be known that the table can also include the file name of the downloaded file. For example, the table composed of the to-be-downloaded file name is merged with the table composed of the file name of the downloaded file.

[0043] In one example, the obtaining of the to-be-downloaded file according to each download address includes: obtaining the to-be-downloaded file according to the file name and the download address. After the file name of the to-be-downloaded file is obtained, the file in the download address can be downloaded according to the file name of the to-be-downloaded file, so as to save the download time, including reducing the re-detection of whether the file is valid, and improving the file download efficiency. After the file is downloaded, the download mark of the file is updated, so as to facilitate the subsequent query or determination of whether the file is downloaded. For example, the to-be-downloaded file can be quickly loaded into a specified directory according to the file name and the download address.

[0044] In addition, the factory name and other parameters that can assist in evaluating the factory process capability index or facilitate intuitive display can also be obtained. The parameters can be used to assist in classifying and comparing the calculation results, as shown in FIG. 1 15. Figure 2 In one example, the path data, factory name, and valid identifier are first obtained as initial preparation for the calculation process. The factory name is used to identify the results obtained by the calculation process, and the valid identifier can assist in determining whether the obtained path data is available. For example, if the path data is unavailable, it means that there is no new download address or no new file to be downloaded in the existing download address, or the path data is rejected in combination with the actual situation. In some examples, the input of the user can be selected, or the subsequent download process can not be performed. Secondly, the download address is read from the path data in a loop, and the file to be downloaded is obtained immediately after the download address is read, so that the file to be downloaded can be loaded in an incremental manner. Specifically, before obtaining the file to be downloaded, the file name of the file to be downloaded is first composed into an xml format file, so as to facilitate batch operation and management of the file to be downloaded. The xml can be parsed to read the file name of the file to be downloaded and then stored in a specified download directory (for example, ETL_CPK_ExcelFile). Subsequent operations are performed on the files in the directory to avoid interference of external files on the calculation process. When the file to be downloaded is obtained, the file to be downloaded can be downloaded in a loop according to the download address and the file name, and the download mark of the file is updated to downloaded after the file is downloaded.

[0045] In one example, the embodiment can be executed with reference to SSIS (Microsoft SQL Server Integration Services, which generates a high-performance data integration solution). For example, the test log file is downloaded from the FTP server, the download address of the file to be downloaded is read from the path of the configuration table as a result set, and is passed to the internal outer loop. Each download address in the result set is passed to the internal loop through the outer loop, the files under the download address are traversed and downloaded, and the download state mark corresponding to the file is updated after the file is downloaded to prevent the file from being repeatedly downloaded next time, so as to realize incremental download of the files in the same directory.

[0046] In step 102, the data of the file to be downloaded is cleaned to obtain the parameters for calculating the process capability index. That is, in the obtained file, there can be errors in the file, errors in the parameters in the file, or the parameters cannot participate in the calculation. Therefore, the source data needs to be cleaned before participating in the calculation, so as to reduce the waste of calculation resources and improve the calculation efficiency. The parameters for calculating the process capability index include, for example, the maximum value, the minimum value, the upper limit of the sample specification USL, and the lower limit of the sample specification LSL.

[0047] In one example, the data cleaning of the to-be-downloaded file and the obtaining of the parameters for calculating the process capability index include: obtaining a file in the to-be-downloaded file that conforms to a preset format; obtaining a readable file in the file that conforms to the preset format; and classifying and integrating data in the readable file to obtain the parameters for calculating the process capability index. In the process of partial data cleaning, the cleaning is sequentially performed according to the order of a file body before a parameter in a file, that is, the unopened file is first screened, and then the selection of the parameter in the screened and opened file is performed, so that the complexity of the data cleaning process is reduced, the speed of the data cleaning is improved under the condition of ensuring the completion degree of the data cleaning step, and the calculation resource occupation of the data cleaning process is reduced.

[0048] Specifically, the cleaning of the file includes but is not limited to: detecting a file name to determine whether the file name is a file that can be processed, for example, if the file name contains "pass" that is used to identify the file in the downloading process, the file is subjected to a next filtering process; and an opening operation is attempted on the file, and if the file can be opened, the file is subjected to a filtering process of a parameter in the file. The cleaning of the parameter includes: detecting the parameter in the opened file, and selecting a file in which the parameters meet the requirements; and the meeting the requirements includes, for example, according to a calculation purpose, the parameter in the file meets a sample specification upper limit or a sample specification lower limit. Optionally, for a file that cannot be processed, a file that cannot be opened, and a file that does not meet the requirements, a relevant process identifier is updated, and an archiving process is performed, so that subsequent process query can be performed.

[0049] In one example, the classifying and integrating of the data in the readable file include: splitting the data in the readable file according to content attributes, and the splitting result is in a format in which calculation can be performed; and classifying the splitting result according to a work order, a test item, and a jig to obtain an integration result of the data in the readable file. For example, the content attributes include a file title, a file body, and a custom label, in order to facilitate subsequent rapid calculation, the cleaned file is split and integrated to improve the calculation efficiency, and the split result is classified according to the work order, the test item, and the jig, so that targeted calculation and comprehensive display of a certain work order can be performed, and the test item and the jig can be calculated and displayed. Further, the split result can be classified according to a specific number of the jig. It can be understood that, in the process of detecting and calculating and displaying the process capability of a factory, the work order, the test item, and the jig are classified and calculated and displayed, which is more in line with the user demand in the actual application process and improves the user experience.

[0050] In step 103, the parameters are loaded into the database. That is, the cleaned parameters in the server are loaded into the database of the server, and the calculation process of the parameters is performed by using the high computing power of the database. If the step of obtaining the to-be-downloaded file is loaded into the specified directory, the specified directory is connected with the database, that is, the files in the specified directory can be directly sent to the database, and the database obtains the files from the specified directory, so as to avoid interference of external files on the calculation process.

[0051] In one example, the classified and integrated data in the readable file is used to obtain the parameters for calculating the process capability index, including: classifying and integrating the data in the readable file; merging the integrated data into a preset table; and obtaining the parameters for calculating the process capability index according to the preset table. In this embodiment, a plurality of formats of parameters can be processed, and the number of parameters is not limited. After the parameters are cleaned and classified, the classified and integrated data can be listed in a table form for unified and standardized management, for example, the related content is filled in the preset table, and the content in the preset table is loaded into the database. According to the content in the preset table or a self-defined label, the subsequent loading process of the new parameters or the parameters of a specific type into the database can be accurately performed.

[0052] In addition, the preset table can be divided into a temporary table and a physical table. The integrated parameters obtained in each cycle are classified into the temporary table, and the content in the completed temporary table is classified into the physical table. The data that is wrong in the process of establishing the temporary table is also deleted in the process of classifying the content in the temporary table into the physical table, so as to further ensure the efficiency of the data in the physical table. The physical table includes a work order, a file name corresponding to the work order, and a splitting result corresponding to the file name. After the content is classified into the physical table, the temporary table is deleted, and the data loaded into the database is obtained from the physical table. In this embodiment, the preset table is divided into the temporary table and the physical table, and the integrated data is classified and archived in steps, so that the cleaning and screening process of the data can be further performed, and the correctness and availability of the data obtained by the database are ensured.

[0053] When the data in the preset table is integrated into the physical table, only the data that can be obtained by identification and needs to participate in the calculation can be stored, for example, the maximum value, the minimum value, the upper limit of the sample specification USL, and the lower limit of the sample specification LSL.

[0054] Optionally, the files screened out in the cleaning process are added with corresponding labels and archived in the historical data for archiving, so that the files can be easily referred to in the future. The correct data retained in the cleaning process can also be archived and saved, and the loading situation of the files is updated after archiving, for example, the file is identified as being archived at which step and for which reason. For details, refer to Figure 3Example. First, the file name is obtained for management or batch operation. Second, the file format of the file to be downloaded is detected according to the file name to determine whether it is a file format that can be processed by the computing process. If it is incorrect, it means that the computing process cannot process it, and then the file with the incorrect format is archived and written into the history record. Optionally, the loading status of the file with the incorrect format is updated, for example, marked as file format error. If it is correct, it means that the computing process can process the file with the correct format, and then the file corresponding to the file name with the correct format is attempted to be opened. If the opening fails, the file that fails to be opened is archived. Optionally, the loading status of the file that fails to be opened is updated, for example, marked as file opening failure. Then, the file that is successfully opened is subjected to a parameter cleaning process, including: reading the file content, caching the read file content to a temporary table, merging the content in the temporary table to a physical table, archiving the content in the physical table (i.e., archiving the history record), and updating the loading status of the file corresponding to the content in the physical table, for example, updating to loading success. The process of reading the file content also includes obtaining the parameters to be cleaned, detecting the parameters in the opened file during the process of reading the file content, and selecting the file with parameters that meet the requirements. The requirements include, for example, according to the computing purpose, the parameters in the file meet the upper limit or lower limit of the sample specification, etc. The files after the archiving operation can be queried for the corresponding processing status or processing result in the subsequent processing process.

[0055] In addition, as shown in Figure 4 , the newly added test items can also be processed according to the parameters in the preset table. If the newly added test items have newly added fixtures, the newly added test items and the fixtures under the newly added test items are calculated, and the calculation results are displayed. If the newly added test items do not have newly added fixtures, only the newly added test items are calculated and displayed. Optionally, the calculation results are stored in the original preset table (or physical table), which can be archived in addition to being displayed, facilitating subsequent query and execution.

[0056] In one example, the execution process of the embodiment can refer to SSIS, load the local test log file into the database, loop through the downloaded test log file, and load and merge it into the database. The test log file that has been loaded is automatically transferred to the archive directory for storage (i.e., the file after loading is archived, facilitating subsequent query of historical information, etc.).

[0057] In step 104, the process capability index is calculated according to the parameters in the database. According to the required results or preset target results, the parameters obtained from the database are calculated, including the calculation of normal distribution value, process precision, process capability index, process accuracy, specification tolerance, etc.

[0058] In particular, the following formula can be used for the calculation: for example, the standard deviation δ, the mean value For the sample standard deviation δ: For the mean value

[0059] Further, the process capability index CPK is obtained,

[0060] For the process capability index CPK:

[0061] For the process capability index CPU with only the upper specification limit, without the lower specification limit:

[0062] For the process capability index CPL with only the lower specification limit, without the upper specification limit:

[0063] In addition, the following parameters can be calculated and subsequently displayed, providing the user with a multi-faceted reference:

[0064] For the sample variance v:

[0065] For the group interval GroupInterval:

[0066] For the group coordinate value GroupCoordinates:

[0067]

[0068] For the normal distribution value NormalDistribution:

[0069] For the frequency FrequenceCount:

[0070]

[0071] For the process precision CP:

[0072] For the specification tolerance T: T = USL - LSL;

[0073] For the process accuracy CA: TargetValue target value.

[0074] In one example, the process capability index is calculated according to the parameters, including: if the configuration is the default mode, the process capability index is calculated according to the default mode and the parameters; if the configuration is the non-default mode, the user input instruction is received, and the process capability index is calculated according to the user instruction and the parameters, as shown in Figure 5 For example, in some settings, there are default plans that set the number of groups to 30, set the sample specification upper limit USL, the sample specification lower limit LSL and the average value as the target value, and set δ to 3; in some settings, some values that need to be involved in the operation cannot be directly obtained from the parameters, that is, the user's instruction input is required to enable the calculation process to be performed.

[0075] In step 105, the calculation results and parameters are displayed. For the calculation results, the table and the table can be displayed respectively, or the display process can be performed in combination, as shown in Figure 6 Examples, and the parameters obtained in the comprehensive calculation process are displayed together, which facilitates the user to comprehensively query and understand the related indicators and improves the user experience.

[0076] In one example, the split results are classified according to the large category and the small category. The large category can include work orders, test items, jigs and the like, and the small category can include specific jig numbers and the like. The corresponding final display interface can refer to 7 to Figure 10 As shown. Among them, Figure 7 Interface 1 for displaying according to work orders, test items and jigs, as shown in Figure 7 The selection of the test item (WB8-Tx-Power-Max) can enter the more detailed CPK comprehensive display interface of the test item, Figure 8 Interface 2 for displaying according to work orders, test items and jigs, as shown in Figure 7 The selection of the specific number of jigs can enter the more detailed CPK comprehensive display interface of the jig, Figure 9 Interface 2 for displaying according to work orders, test items and jigs, as shown in Figure 9 The selection of the specific number of jigs can enter the more detailed CPK comprehensive display interface of the jig, Figure 10 Interface 2 for displaying according to work orders, test items and jigs, as shown in Figure 9 The selection of the specific number of jigs can enter the more detailed CPK comprehensive display interface of the jig,

[0077] In one example, the display step can be implemented by referring to SSRS (SQL Server Reporting Services, practical development and publishing report tool), including developing a report based on database data, displaying the merged results, and the process capability index information of the factory, work order, test item and jig number dimension statistics. The coordinate axes of the page chart can be customized or defaulted.

[0078] In one example, the database can be a SQL server database, used to obtain the result data generated by the SSIS calculation and the stored procedures needed by the SSRS report page display.

[0079] In one example, in addition to direct display through the report page, it can also be accessed as a data source by other application terminals.

[0080] In addition, for file history step caching, identifying batch changes, transferring loaded files, etc., DOS batch processing can be performed.

[0081] The step division of the above methods is only for the purpose of clear description, and in implementation, one step can be combined or some steps can be split and decomposed into multiple steps, as long as the same logical relationship is included, and all are within the protection scope of the patent; adding irrelevant modifications or introducing irrelevant designs in the algorithm or process, but not changing the core design of the algorithm and process, are within the protection scope of the patent.

[0082] In the embodiment, the evaluation of the factory process capability index is not limited to a specific format, the steps of processing the data source format of the parameters are reduced, and the limitation of the amount of processable data caused by the data format is avoided. In the embodiment, multiple data formats are supported and data cleaning is performed, batch processing and calculation of the parameters can be realized, and massive test data of each factory is automatically downloaded to the local in increments, loaded to the database in increments, and the calculation results are displayed by the report. The calculation and evaluation efficiency of the factory process capability index is improved. Since multiple data formats are supported for input and calculation, the process of manual data export and processing and then merging and display can be avoided, and the labor and time costs are reduced.

[0083] One embodiment of the present application relates to a factory process capability index evaluation device, as shown in the accompanying drawings, comprising: Figure 11

[0084] The downloading module 201 is configured to obtain a to-be-downloaded file according to a downloading address; wherein the to-be-downloaded file in the downloading address is updated according to a preset time period.

[0085] The obtaining module 202 is configured to perform data cleaning on the to-be-downloaded file, and obtain parameters used for calculating a process capability index.

[0086] The loading module 203 is configured to load the parameters into a database.

[0087] The calculation module 204 is configured to calculate the process capability index according to the parameters in the database.

[0088] ​The display module 205 is configured to display the calculation result and the parameter.

[0089] In the download module 201, in one example, before the obtaining of the to-be-downloaded file according to each download address, the method further comprises: obtaining a file name of each to-be-downloaded file according to each download address, and the file name is used for unified management of the to-be-downloaded file.

[0090] In one example, the obtaining of the to-be-downloaded file according to each download address comprises: obtaining the to-be-downloaded file according to the file name and the download address.

[0091] In the obtaining module 202, in one example, the data cleaning of the to-be-downloaded file to obtain the parameter used for calculating the process capability index comprises: obtaining a file conforming to a preset format in the to-be-downloaded file; obtaining a readable file in the file conforming to the preset format; and classifying and integrating data in the readable file to obtain the parameter used for calculating the process capability index.

[0092] In one example, the classifying and integrating of the data in the readable file to obtain the parameter used for calculating the process capability index comprises: classifying and integrating the data in the readable file; merging the integrated data into a preset table; and obtaining the parameter used for calculating the process capability index according to the preset table.

[0093] In one example, the classifying and integrating of the data in the readable file comprises: splitting the data in the readable file according to content attributes, and the splitting result is in a format capable of performing calculation; and classifying the splitting result according to a work order to obtain an integrated result of the data in the readable file.

[0094] In the calculation module 204, the calculation of the process capability index according to the parameter comprises: if the configuration is a default mode, performing the calculation of the process capability index according to the default mode and the parameter; or if the configuration is a non-default mode, receiving an instruction input by a user, and performing the calculation of the process capability index according to the user instruction and the parameter.

[0095] The embodiments of the present application are not limited to the evaluation of the process capability index of a factory in a specific format, reduce the steps of processing the data source format of the parameters, and avoid the limitation of the amount of processable data caused by the data format, while in the embodiments of the present application, multiple data formats are supported and data cleaning is performed, batch processing and calculation of the parameters can be realized, and massive test data of each factory is automatically downloaded to the local in increments, the calculation results are loaded to the database in increments, and the results are displayed in a report. The calculation and evaluation efficiency of the process capability index of the factory is improved. Since multiple data formats are supported for input and calculation, the process of manual data export, processing and merging and display can also be avoided, and the labor and time cost is reduced.

[0096] It can be found that the present embodiment is a system embodiment corresponding to the above-mentioned embodiment, and the present embodiment can be implemented in cooperation with the above-mentioned embodiment. The related technical details mentioned in the above-mentioned embodiment are still valid in the present embodiment. In order to reduce repetition, they will not be described here. Correspondingly, the related technical details mentioned in the present embodiment can also be applied in the above-mentioned embodiment.

[0097] It is worth mentioning that each module involved in the present embodiment is a logical module. In actual application, a logical unit can be a physical unit, a part of a physical unit, or a combination of multiple physical units. In addition, in order to highlight the innovative part of the present application, units not closely related to solving the technical problems proposed by the present application are not introduced in the present embodiment, but this does not mean that there are no other units in the present embodiment.

[0098] One embodiment of the present application relates to a server, as shown in Figure 12 comprising at least one processor 301; and,

[0099] a memory 302 connected in communication with the at least one processor 301; wherein,

[0100] The memory 302 stores instructions executable by the at least one processor 301, and the instructions are executed by the at least one processor 301 to enable the at least one processor 301 to perform the above-mentioned factory process capability index evaluation method.

[0101] The memory and processor are connected using a bus, which can include any number of interconnected buses and bridges. The bus connects various circuits within one or more processors and the memory. The bus can also connect various other circuits, such as peripherals, voltage regulators, and power management circuits. These are well known in the art and are therefore not described further herein. The bus interface provides an interface between the bus and the transceiver. The transceiver can be a single component or multiple components, such as multiple receivers and transmitters, providing a unit for communicating with various other devices over a transmission medium. Data processed by the processor is transmitted over a wireless medium via an antenna. Furthermore, the antenna receives data and transmits it to the processor.

[0102] The processor is responsible for managing the bus and general processing, and can also provide various functions, including timing, peripheral interfaces, voltage regulation, power management, and other control functions. Memory can be used to store data used by the processor when performing operations.

[0103] One embodiment of the present invention relates to a computer-readable storage medium storing a computer program, which implements the above method embodiment when executed by a processor.

[0104] That is, those skilled in the art will understand that all or part of the steps in the above-described method embodiments can be implemented by instructing the relevant hardware through a program, which is stored in a storage medium and includes a number of instructions for causing a device (which may be a single-chip microcomputer, chip, etc.) or a processor to execute all or part of the steps in the method embodiments of the present application. The aforementioned storage medium includes various media that can store program code, such as a USB flash drive, a mobile hard drive, a read-only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

[0105] Those skilled in the art will appreciate that the above-mentioned embodiments are specific examples for implementing the present invention, and that in actual applications, various changes may be made thereto in form and detail without departing from the spirit and scope of the present invention.

Claims

1. A method for evaluating a plant process capability index, characterized in that: include: Acquire the file to be downloaded according to each download address increment; wherein the file to be downloaded in the download address is updated according to a preset time period; Performing data cleaning on the file to be downloaded to obtain parameters for calculating a process capability index; Incrementally loading the parameters into a database; Calculating a process capability index based on parameters in the database; The calculation results and the parameters are displayed.

2. The method for evaluating the plant process capability index according to claim 1, wherein: The step of performing data cleaning on the file to be downloaded and obtaining parameters for calculating the process capability index includes: Obtain a file that complies with a preset format from the files to be downloaded; Obtaining a readable file from the files that conform to the preset format; The data in the readable file are classified and integrated to obtain the parameters for calculating the process capability index.

3. The method for evaluating the plant process capability index according to claim 2, wherein: The classifying and integrating the data in the readable file to obtain the parameters for calculating the process capability index includes: Classify and integrate the data in the readable file; Merging the integrated data into a preset table; Parameters for calculating the process capability index are obtained according to the preset table.

4. The method for evaluating the plant process capability index according to claim 2, wherein: The classifying and integrating the data in the readable file includes: Splitting the data in the readable file according to content attributes, and converting the split results into a format capable of performing calculations; The split results are classified according to the work orders to obtain an integration result of the data in the readable file.

5. The method for evaluating the plant process capability index according to claim 1, wherein: Before the step of incrementally acquiring the files to be downloaded according to the download addresses, the method further includes: The file names of the files to be downloaded are obtained according to the download addresses, and the file names are used for unified management of the files.

6. The method for evaluating the plant process capability index according to claim 5, characterized in that: The step of incrementally acquiring the files to be downloaded according to the download addresses includes: The file to be downloaded is obtained according to the file name and the download address.

7. The plant process capability index evaluation method according to any one of claims 1 to 6, characterized in that: The process capability index is calculated based on the parameters, including: If the configuration is the default mode, the process capability index is calculated according to the default mode and the parameters; If the configuration is a non-default mode, an instruction input by a user is received, and the process capability index is calculated according to the user instruction and the parameters.

8. A plant process capability index evaluation device, characterized in that: include: A download module, configured to incrementally obtain a file to be downloaded according to each download address; wherein the file to be downloaded in the download address is updated according to a preset time period; An acquisition module, configured to perform data cleaning on the file to be downloaded and obtain parameters for calculating a process capability index; A loading module, used for incrementally loading the parameters into a database; A calculation module, configured to calculate a process capability index based on parameters in the database; The display module is used to display the calculation results and the parameters.

9. A server, characterized in that: include: at least one processor; as well as, a memory communicatively connected to the at least one processor; wherein, The memory stores instructions that can be executed by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the plant process capability index evaluation method according to any one of claims 1 to 7.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the plant process capability index evaluation method according to any one of claims 1 to 7 is implemented.

Images