Aging monitoring data statistical method and device

Abstract

The invention provides an aging monitoring data statistical method and device. The aging monitoring data statistical method comprises the steps of inputting aging monitoring data of products in the same batch into a form file in a specified arrangement mode; naming the table file according to the product nominal frequency, the product batch number and the product model, and putting the named table file into a specified folder; judging whether the first choice is a single-batch product or a multi-batch product; when the first selection is a single batch of products, extracting aging monitoring data of at least one specified product from the first specified table file to draw a first broken line graph and a second broken line graph; and when the first choice is a plurality of batches of products, extracting the time and the product frequency of all the products from all the second specified form files to draw a first broken line graph, and extracting the product numbers and the aging rates of all the products from the second choice to draw a second broken line graph. The invention provides an aging monitoring data statistical method and device, and is used for solving the problem that aging monitoring data analysis in the prior art is firm.

Description

Technical Field

[0001] The present invention relates to the field of data processing, and in particular to a statistical method and device for aging monitoring data. Background Art

[0002] We are currently in an era of data explosion, with huge and complex data volumes. In traditional manufacturing, digitalization has not yet been fully popularized or the digital application rate is low, and with the accumulation of routine tests, the amount of test data is still growing. Long-term data can reflect the level of the product, especially for crystal components. The analysis of aging monitoring data after aging tests can reflect performance changes, but traditional manufacturing is currently struggling to analyze data patterns. Summary of the invention

[0003] The present invention provides a statistical method and device for aging monitoring data, which are used to solve the problems in the prior art such as the difficulty in analyzing aging monitoring data.

[0004] In a first aspect, the present invention provides a statistical method for aging monitoring data, comprising:

[0005] Inputting the aging monitoring data of the same batch of products into a table file in a specified arrangement, the same batch of products are all products with the same product nominal frequency, product batch number and product model, the aging monitoring data include time, product number, product frequency and aging rate, the product number and product have a one-to-one correspondence, and the product frequency is the frequency of the product changing with the time during the aging period;

[0006] Name the table file according to the product nominal frequency, the product batch number and the product model, and put the named table file into a designated folder;

[0007] Determine whether the first selection is a single batch of products or multiple batches of products, the single batch of products is the products in the first designated table file, the first designated table file is a table file whose file name is called from the designated folder and contains the first designated product nominal frequency, the first designated product batch number and the first designated product model at the same time, the multiple batches of products are all the products in the second designated table file, the second designated table file is a table file whose file name is called from the designated folder and contains designated information, the designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model;

[0008] When the first selection is the single batch of products, the aging monitoring data of at least one designated product is extracted from the first designated table file to draw a first line graph and a second line graph, the designated product is determined by a designated product number, the abscissa of the first line graph is the time, and the ordinate is the product frequency, and the abscissa of the second line graph is the product number, and the ordinate is the aging rate;

[0009] When the first selection is the multiple batches of products, the time and product frequency of all products are extracted from all the second designated table files to draw the first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw the second line graph, and the second selection is any one second designated table file selected from all the second designated table files.

[0010] Optionally, the table file is an Excel file.

[0011] Optionally, the aging rate=(maximum product frequency-minimum product frequency) / nominal product frequency.

[0012] Optionally, the naming of the table file according to the product nominal frequency, the product batch number and the product model includes:

[0013] The table file is named after separating the product nominal frequency, the product batch number and the product model with a separator.

[0014] Optionally, the designated folder is a pre-set folder for storing all named table files.

[0015] Optionally, also include:

[0016] Raw data is provided according to the first specified table file.

[0017] Optionally, also include:

[0018] According to the second option raw data is provided.

[0019] In a second aspect, the present invention provides an aging monitoring data statistics device, including an acquisition module, a sorting module and a statistics module, wherein:

[0020] The acquisition module is used to input the aging monitoring data of the same batch of products into a table file in a specified arrangement mode, the same batch of products are all products with the same product nominal frequency, product batch number and product model, the aging monitoring data includes time, product number, product frequency and aging rate, the product number and product have a one-to-one correspondence, and the product frequency is the frequency of the product changing with the time during the aging period;

[0021] The sorting module is used to name the table file according to the product nominal frequency, the product batch number and the product model, and put the named table file into a designated folder;

[0022] The statistical module is used to determine whether the first selection is a single batch of products or multiple batches of products, the single batch of products is the products in the first designated table file, the first designated table file is a table file in which the file name called from the designated folder contains the first designated product nominal frequency, the first designated product batch number and the first designated product model at the same time, the multiple batches of products are all the products in the second designated table file, the second designated table file is a table file in which the file name called from the designated folder contains designated information, and the designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model;

[0023] When the first selection is the single batch of products, the aging monitoring data of at least one designated product is extracted from the first designated table file to draw a first line graph and a second line graph, the designated product is determined by a designated product number, the abscissa of the first line graph is the time, and the ordinate is the product frequency, and the abscissa of the second line graph is the product number, and the ordinate is the aging rate;

[0024] When the first selection is the multiple batches of products, the time and product frequency of all products are extracted from all the second designated table files to draw the first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw the second line graph, and the second selection is any one second designated table file selected from all the second designated table files.

[0025] In a third aspect, the present invention provides a computing device, comprising:

[0026] A memory for storing program instructions;

[0027] The processor is used to call the program instructions stored in the memory and execute any of the above methods according to the obtained program.

[0028] In a fourth aspect, the present invention provides a computer-readable non-volatile storage medium, comprising computer-readable instructions, which enable a computer to execute any of the above methods when the computer reads and executes the computer-readable instructions.

[0029] The present invention inputs a large amount of aging monitoring data into a table file in batches according to a specified arrangement method so as to quickly perform aging monitoring data statistics; uses a unified and intuitive naming method so as to quickly locate a required table file in a specified folder; and draws a line graph to quickly and intuitively obtain the aging conditions of at least one specified product in a single batch of products or multiple batches of products, thereby improving the analysis efficiency and accuracy of the aging monitoring data. BRIEF DESCRIPTION OF THE DRAWINGS

[0030] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0031] Figure 1 A schematic diagram of a flow chart of an aging monitoring data statistics method provided by an embodiment of the present invention;

[0032] Figure 2 A schematic diagram of the structure of an aging monitoring data statistics device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0033] In order to make the purpose, technical scheme and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the accompanying drawings. Obviously, the described embodiments are only 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 ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0034] It should be noted that the terms "first", "second" etc. involved in the documents of the present application are used to distinguish similar objects, and need not be used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchangeable in appropriate circumstances, so that the embodiments of the present application described herein can be implemented in a sequence other than the content illustrated or described herein. In addition, the terms "including" and "having" and any of their variations are intended to cover non-exclusive inclusions, for example, the process, method, system, product or equipment comprising a series of steps or units need not be limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment.

[0035] Figure 1 The process of a statistical method for aging monitoring data provided by an embodiment of the present invention is shown in detail, including:

[0036] S101. Input the aging monitoring data of the same batch of products into a table file in a specified arrangement.

[0037] Specifically, products in the same batch refer to all products with the same nominal frequency, product batch number and product model. The aging monitoring data includes time, product number, product frequency and aging rate. The product number and product correspond one to one. The product frequency is the frequency of the product changing over time during the aging period.

[0038] It should be noted that specifying the arrangement method allows the aging monitoring data of all products to be input into the spreadsheet file in a unified arrangement method, so as to quickly perform aging monitoring data statistics.

[0039] Table 1 shows a specific arrangement of aging monitoring data in a table file.

[0040] Table 1

[0041]

[0042]

[0043] In one example, the table file is an Excel file.

[0044] In one example, aging rate=(maximum value of product frequency−minimum value of product frequency) / nominal frequency of product.

[0045] The aging rate reflects the degree of change in the product frequency over a period of time in a high temperature environment. The high temperature can be 70℃ or 105℃, etc.

[0046] S102. Name the table file according to the product nominal frequency, product batch number and product model, and put the named table file into a designated folder.

[0047] In one example, naming the table file according to the product nominal frequency, product batch number, and product model number includes:

[0048] Use a separator to separate the product nominal frequency, product batch number and product model and then name the table file.

[0049] For example, when the separator is "-", the table file is named "product nominal frequency-product batch number-product model".

[0050] The unified and intuitive naming method makes it easy to quickly locate the required table file in the specified folder.

[0051] In one example, the designated folder is a preset folder for storing all named table files.

[0052] S103, determining whether the first selection is a single batch of products or multiple batches of products.

[0053] Specifically, a single batch of products is a product in a first designated table file, and the first designated table file is a table file called from a designated folder and includes the first designated product nominal frequency, the first designated product batch number and the first designated product model in the file name.

[0054] It should be noted that the first designated product nominal frequency, the first designated product batch number and the first designated product model are determined according to actual needs, and there is only one first designated table file.

[0055] Specifically, multiple batches of products are all products in the second designated table file, and the second designated table file is a table file containing designated information in the file name called from the designated folder, and the designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model.

[0056] It should be noted that the second designated product nominal frequency or the second designated product batch number or the second designated product model is determined according to actual needs. Multiple second designated table files can be determined based on the second designated product nominal frequency alone, multiple second designated table files can be determined based on the second designated product batch number alone, and multiple second designated table files can also be determined based on the second designated product model alone.

[0057] It should be noted that the first choice is determined according to actual needs.

[0058] S104: When the first selection is a single batch of products, extract aging monitoring data of at least one designated product from the first designated table file to draw a first line graph and a second line graph.

[0059] Specifically, the designated product is determined by the designated product number, the horizontal axis of the first line graph is time and the vertical axis is product frequency, and the horizontal axis of the second line graph is product number and the vertical axis is aging rate.

[0060] It should be noted that the quantity of the designated products and the designated product numbers corresponding to the designated products are determined according to actual needs.

[0061] The first line graph is intended to observe how product frequency changes over time, and to further analyze whether there is a sudden change in frequency and whether the product consistency is good.

[0062] It should be noted that when there is only one designated product, there is only one aging rate of the designated product on the second line graph, and when there are multiple designated products, there are multiple aging rates of the designated products on the second line graph.

[0063] In one example, it also includes:

[0064] The raw data is provided according to a first specified table file.

[0065] It should be noted that the original data refers to the aging monitoring data of all products in the table file.

[0066] S105. When the first selection is multiple batches of products, the time and product frequency of all products are extracted from all second specified table files to draw a first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw a second line graph.

[0067] Specifically, the second selection is any second designated table file selected from all second designated table files.

[0068] It should be noted that the second option is selected according to actual needs.

[0069] In one example, it also includes:

[0070] Provides raw data according to the second option.

[0071] The above scheme inputs a large amount of aging monitoring data into a table file in batches according to a specified arrangement method so as to quickly perform aging monitoring data statistics; uses a unified and intuitive naming method so as to quickly locate the required table file in a specified folder; and draws a line graph to quickly and intuitively obtain the aging status of at least one specified product in a single batch of products or multiple batches of products, thereby improving the analysis efficiency and accuracy of the aging monitoring data.

[0072] Based on the same inventive concept, Figure 2 The structure of an aging monitoring data statistics device provided by an embodiment of the present invention is shown, including an acquisition module, a sorting module and a statistics module, wherein:

[0073] The acquisition module is used to input the aging monitoring data of the same batch of products into a table file in a specified arrangement. The same batch of products refers to all products with the same product nominal frequency, product batch number and product model. The aging monitoring data includes time, product number, product frequency and aging rate. The product number and the product have a one-to-one correspondence. The product frequency is the frequency of the product changing over time during the aging period.

[0074] The sorting module is used to name the table file according to the product nominal frequency, product batch number and product model, and put the named table file into a designated folder;

[0075] The statistics module is used to determine whether the first selection is a single batch of products or multiple batches of products. The single batch of products refers to the products in the first designated table file. The first designated table file is a table file whose file name is called from the designated folder and contains the first designated product nominal frequency, the first designated product batch number and the first designated product model at the same time. The multiple batches of products refer to the products in all the second designated table files. The second designated table file is a table file whose file name is called from the designated folder and contains designated information. The designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model.

[0076] When the first selection is a single batch of products, the aging monitoring data of at least one designated product is extracted from the first designated table file to draw a first line graph and a second line graph, the designated product is determined by the designated product number, the abscissa of the first line graph is time, the ordinate is product frequency, the abscissa of the second line graph is product number, and the ordinate is aging rate;

[0077] When the first selection is multiple batches of products, the time and product frequency of all products are extracted from all the second designated table files to draw a first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw a second line graph. The second selection is any one of the second designated table files selected from all the second designated table files.

[0078] Based on the same inventive concept, an embodiment of the present invention provides a computing device, including:

[0079] A memory for storing program instructions;

[0080] The processor is used to call the program instructions stored in the memory and execute the above method according to the obtained program.

[0081] Based on the same inventive concept, an embodiment of the present invention provides a computer-readable non-volatile storage medium, including computer-readable instructions. When a computer reads and executes the computer-readable instructions, the computer executes the above method.

[0082] It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as methods or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0083] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0084] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0085] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0086] Although the preferred embodiments of the present invention have been described, those skilled in the art may make additional changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications that fall within the scope of the present invention.

[0087] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A statistical method for aging monitoring data, characterized in that: include: Inputting the aging monitoring data of the same batch of products into a table file in a specified arrangement, the same batch of products are all products with the same product nominal frequency, product batch number and product model, the aging monitoring data include time, product number, product frequency and aging rate, the product number and product have a one-to-one correspondence, and the product frequency is the frequency of the product changing with the time during the aging period; Name the table file according to the product nominal frequency, the product batch number and the product model, and put the named table file into a designated folder; Determine whether the first selection is a single batch of products or multiple batches of products, the single batch of products is the products in the first designated table file, the first designated table file is a table file whose file name is called from the designated folder and contains the first designated product nominal frequency, the first designated product batch number and the first designated product model at the same time, the multiple batches of products are all the products in the second designated table file, the second designated table file is a table file whose file name is called from the designated folder and contains designated information, the designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model; When the first selection is the single batch of products, the aging monitoring data of at least one designated product is extracted from the first designated table file to draw a first line graph and a second line graph, the designated product is determined by a designated product number, the abscissa of the first line graph is the time, and the ordinate is the product frequency, and the abscissa of the second line graph is the product number, and the ordinate is the aging rate; When the first selection is the multiple batches of products, the time and product frequency of all products are extracted from all the second designated table files to draw the first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw the second line graph, and the second selection is any one second designated table file selected from all the second designated table files.

2. The method according to claim 1, characterized in that: The table file is an Excel file.

3. The method according to claim 1, characterized in that: The aging rate=(maximum value of product frequency-minimum value of product frequency) / nominal frequency of the product.

4. The method according to claim 1, characterized in that: The naming of the table file according to the product nominal frequency, the product batch number and the product model comprises: The table file is named after separating the product nominal frequency, the product batch number and the product model with a separator.

5. The method according to claim 1, characterized in that: The designated folder is a pre-set folder for storing all named table files.

6. The method according to claim 1, characterized in that: Also includes: Raw data is provided according to the first specified table file.

7. The method according to claim 1, characterized in that: Also includes: According to the second option raw data is provided.

8. An aging monitoring data statistics device, characterized in that: It includes acquisition module, sorting module and statistics module, among which: The acquisition module is used to input the aging monitoring data of the same batch of products into a table file in a specified arrangement mode, the same batch of products are all products with the same product nominal frequency, product batch number and product model, the aging monitoring data includes time, product number, product frequency and aging rate, the product number and product have a one-to-one correspondence, and the product frequency is the frequency of the product changing with the time during the aging period; The sorting module is used to name the table file according to the product nominal frequency, the product batch number and the product model, and put the named table file into a designated folder; The statistical module is used to determine whether the first selection is a single batch of products or multiple batches of products, the single batch of products is the products in the first designated table file, the first designated table file is a table file in which the file name called from the designated folder contains the first designated product nominal frequency, the first designated product batch number and the first designated product model at the same time, the multiple batches of products are all the products in the second designated table file, the second designated table file is a table file in which the file name called from the designated folder contains designated information, and the designated information is the second designated product nominal frequency or the second designated product batch number or the second designated product model; When the first selection is the single batch of products, the aging monitoring data of at least one designated product is extracted from the first designated table file to draw a first line graph and a second line graph, the designated product is determined by a designated product number, the abscissa of the first line graph is the time, and the ordinate is the product frequency, and the abscissa of the second line graph is the product number, and the ordinate is the aging rate; When the first selection is the multiple batches of products, the time and product frequency of all products are extracted from all the second designated table files to draw the first line graph, and the product numbers and aging rates of all products are extracted from the second selection to draw the second line graph, and the second selection is any one second designated table file selected from all the second designated table files.

9. A computing device, characterized in that include: A memory for storing program instructions; A processor is used to call the program instructions stored in the memory and execute the method according to any one of claims 1 to 7 according to the obtained program.

10. A computer-readable non-volatile storage medium, characterized in that: The method comprises computer-readable instructions, and when a computer reads and executes the computer-readable instructions, the computer executes the method according to any one of claims 1 to 7.

Images