Automatic processing method and system for test data of optical fiber gyroscope and medium

Abstract

The invention relates to an optical fiber gyroscope, in particular to an automatic processing method and system for test data of the optical fiber gyroscope and a medium, and the method comprises the following steps: S1, opening a test data file and obtaining original test data; s2, performing data cleaning on the original test data; s3, detecting personnel information, detecting equipment information and detecting sample model information are obtained through an MES system, and all the information and data obtained after data cleaning are filled into a detection record form template; s4, calling a corresponding data statistical method based on the model information of the detection sample to perform data statistical calculation, and filling the data into the detection record form template; and S5, generating a detection record form and outputting a detection report containing the detection record form. Compared with the prior art, the problems that in the prior art, manual processing is low in efficiency and prone to errors are solved, and automatic processing of the test data is achieved.

Description

Technical Field

[0001] The invention relates to a fiber optic gyroscope, and in particular to a method, system and medium for automatically processing test data of a fiber optic gyroscope. Background Art

[0002] With the development of my country's modernization, the demand for inertial guidance systems and positioning and orientation systems in the fields of national defense, aviation, aerospace, shipbuilding, and automobile manufacturing has continued to increase. Since the working environment of fiber optic gyroscopes is very harsh, in order to simulate the actual working environment of fiber optic gyroscopes, each fiber optic gyroscope product must be tested in a harsh test environment. The test takes a long time, the machine mounting rate is low, and the test automation level is not high. Therefore, it is very urgent and necessary to build an application of a gyroscope test data automatic processing technology platform to meet the development and production testing needs of fiber optic gyroscopes.

[0003] At present, fiber optic gyroscopes need to go through a long screening and performance testing process during the manufacturing process, so the testing process activities have become one of the main bottlenecks of current engineering. In the field of testing, traditional test platforms (systems) collect and record original records in txt text format, and the processing of test data has always been an important link in the production process. The traditional method relies on manually exporting the test data from the test equipment into txt text format, and then manually importing the data through spreadsheet software such as Excel, and setting complex calculation formulas for result analysis. This process is not only time-consuming and labor-intensive, but also prone to data deviations due to human errors, affecting the accuracy and efficiency of product quality assessment. In addition, with the expansion of production scale, the amount of data generated by each test machine has increased sharply, and traditional methods can no longer meet the needs of rapid response and efficient management. Specific defects include:

[0004] 1) Inefficient data import: Manually importing txt data is time-consuming and error-prone.

[0005] 2) The calculation process is cumbersome: formulas and ranges need to be adjusted repeatedly, increasing the workload.

[0006] 3) It is necessary to manually select the data range and sample length (output data corresponding to temperature and output data corresponding to different rates).

[0007] 4) It is necessary to manually copy or reference data to the data report template.

[0008] 5) It is necessary to manually enter the test information, such as test equipment, personnel, environmental conditions, etc.

[0009] 6) Lack of flexibility: It is difficult to quickly adapt to changes in testing requirements for different batches of products.

[0010] 7) Data processing using tools such as MATLAB and Origin has poor resource sharing: Data processing is limited to single-machine operation, and data sharing and collaboration among multiple machines in the workshop cannot be achieved. Summary of the invention

[0011] The purpose of the present invention is to provide a method, system and medium for automatically processing fiber optic gyroscope test data in order to solve at least one of the above problems, so as to solve the problems of low efficiency and easy errors in manual processing in the prior art. This scheme realizes the automatic processing of test data.

[0012] The purpose of the present invention is achieved through the following technical solutions:

[0013] The first aspect of the present invention discloses a method for automatically processing test data of a fiber optic gyroscope, comprising the following steps:

[0014] S1: Open the test data file and obtain the original test data;

[0015] S2: Clean the original test data;

[0016] S3: Obtain the testing personnel information, testing equipment information and testing sample model information through the MES system, and fill in the testing record form template with the information and the data after data cleaning;

[0017] S4: Based on the detection sample model information, call the corresponding data statistical method to perform data statistical calculation and fill in the detection record form template;

[0018] S5: Generate a test record form and output a test report including the test record form.

[0019] Preferably, the automatic processing method is performed based on VBA in Excel.

[0020] Preferably, the test data files include files in txt format and xsl format, and the test data files are stored in a designated folder with a determined path on the detection equipment, the workshop network computer or the data server.

[0021] Preferably, the data cleaning includes data difference determination, data transposition and data crossover.

[0022] Preferably, the information obtained through the MES system and the data after data cleaning are stored in the cells of the specified path to form an array and construct a dictionary.

[0023] Preferably, the data statistics method is compiled according to technical standards and technical requirements to construct a non-standard library for statistical calculation of fiber optic gyroscope test data.

[0024] Preferably, the data statistics method includes calculation of a scaling factor, and the development trend of the test results is predicted by the scaling factor to determine the test progress.

[0025] Preferably, the automatic processing method further comprises verifying the integrity and compliance of the original test data; when the original test data passes the verification, step S1 is executed; when the original test data fails the verification, an alarm is issued and the process of the automatic processing method is exited.

[0026] The second aspect of the present invention discloses an automatic processing system for fiber optic gyroscope test data, including a host computer, an original test data server and a test computer;

[0027] The test computer is loaded with a program for implementing any of the automatic processing methods described above;

[0028] The host computer is loaded with an MES system, and the MES system stores information on testing personnel, testing equipment, and testing sample model information;

[0029] The original test data server is used to store the original test data obtained by the test equipment;

[0030] The host computer, the original test data server and the test computer are connected via a local area network.

[0031] A third aspect of the present invention discloses a computer-readable storage medium storing computer-executable instructions, wherein the computer-executable instructions are used to execute any of the automatic processing methods described above.

[0032] Compared with the prior art, the present invention has the following beneficial effects:

[0033] This technical solution is convenient and efficient, highly practical, has a low operating threshold, and can improve work quickly. It significantly reduces manual intervention and improves the automation level and production efficiency of data processing. The details are as follows:

[0034] (1) Improve efficiency: Automated processing significantly reduces manual operation time and speeds up data processing.

[0035] (2) Reduce errors: Automated processes reduce data errors caused by human factors and improve data accuracy.

[0036] (3) Enhanced flexibility: Customizable calculation formulas and range settings enable the system to adapt to a variety of test scenarios.

[0037] (4) Promote collaboration: The network sharing function promotes the flow of information within the workshop and the threshold for team collaboration is low. Operators do not need to master the use of software such as MATLAB and complex programming.

[0038] (5) Reduce costs: In the long run, it reduces labor costs and may reduce overall operating costs by improving production efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0039] Figure 1 A schematic diagram of the process of the automatic processing method;

[0040] Figure 2 It is a structural diagram of the automatic processing system. DETAILED DESCRIPTION

[0041] The present invention is described in detail below with reference to the accompanying drawings and specific embodiments.

[0042] Example 1

[0043] A method for automatically processing fiber optic gyroscope test data, such as Figure 1 As shown, the following steps are included:

[0044] S1: Open the test data file and obtain the original test data;

[0045] S2: Clean the original test data;

[0046] S3: Obtain the testing personnel information, testing equipment information and testing sample model information through the MES system, and fill in the testing record form template with the information and the data after data cleaning;

[0047] S4: Based on the detection sample model information, call the corresponding data statistical method to perform data statistical calculation and fill in the detection record form template;

[0048] S5: Generate a test record form and output a test report including the test record form.

[0049] An automatic processing system for fiber optic gyroscope test data, such as Figure 2 As shown, it includes a host computer, an original test data server and a test computer;

[0050] The test computer is loaded with a program for implementing any of the automatic processing methods described above;

[0051] The host computer is loaded with an MES system, and the MES system stores information on testing personnel, testing equipment, and testing sample model information;

[0052] The original test data server is used to store the original test data obtained by the test equipment;

[0053] The host computer, the original test data server and the test computer are connected via a local area network.

[0054] More specifically, in this embodiment:

[0055] Referring to the main (step) flow chart of the method of the present invention, see Figure 1 , describe in detail the steps of the method of the present invention, and the characteristics of each step;

[0056] The present invention proposes a gyro test data automatic processing method based on an Excel macro development module. The scheme is based on the gyro test process requirements, and the code is compiled by the Visual Basic for Applications (VBA) environment of Excel to form a special data automatic processing method that can automatically read the original data recorded by the host computer in the gyro test system through data acquisition, so that the host computer in the gyro test system can realize the program automation of data processing during the test process, and then can realize the solution of automatic identification, grabbing, intelligent judgment, one-key output of test reports, batch analysis reports, etc. by creating a customized automatic processing process. The automatic processing method specifically realizes the automatic grabbing of test data and writes it into a specified area, and also compiles and encodes the test data statistical method stipulated by the test outline and technical conditions of the optical fiber gyroscope through the VBA development module to form a non-standard library function formula list, and can be stored in the test template of EXCEL for calling at any time, so as to realize the simple and efficient data processing of specific non-standard calculation formulas. In addition, the one-key output, rapid calling and automatic processing of test data of the test process results can be realized by internally compiling the test report template and the batch quality analysis report template.

[0057] The practical engineering application of the technology of the present invention has greatly improved the data processing efficiency and accuracy. To facilitate the understanding of the solution, the automatic processing method of this solution is referred to as the gyro test data automatic processing template in the following description. The specific technical implementation is as follows:

[0058] (1) The gyro test data automatic processing template compiles the code and develops a special macro script based on the Visual Basic for Applications environment of Excel, which can automatically read the test data files in txt format or xsl format directly from the test machine or workshop network computer, data server device interface or specified folder and obtain the original test data therein, avoiding the tediousness and errors of manual import.

[0059] (2) The gyro test data automatic processing template automatically retrieves the storage path of the test data file corresponding to the test sample number (archived uniformly and named according to specific rules for files and paths), opens the ".txt" format text record or the ".xsl" format original record and imports it into the test template.

[0060] (3) After the gyro test data automatic processing template automatically opens the original data record in ".txt" or ".xsl" format, it automatically performs horizontal and vertical transposition according to the data sample format recorded by the host computer to keep it consistent with the format in the processing process of the detection data processing template.

[0061] (4) After data cleaning and selection of the test data, the processed data is imported into cells that can be traced by the specified path to achieve automatic writing of test data.

[0062] (5) The gyro test data automatic processing template also has the function of automatically linking to the data server, retrieving the inspection personnel information uploaded in the MES system, and automatically writing the inspection template after obtaining the inspection personnel information corresponding to the test sample.

[0063] (6) The gyro test data automatic processing template also automatically matches and selects the test sample model information according to the test sample, and automatically calls the built-in compiled data statistical method code to realize automatic calculation of the test data and automatically write the calculation results into the specified cell of the traceable path, and fill in the information into the test record form.

[0064] (7) The gyro test data automatic processing template is based on the technical requirements of the gyro test process. The EXCEL gyro test data automatic processing template is remotely controlled by compiling code to standardize the operations of all test personnel and realize automatic retrieval of the test process. At the same time, the upper computer in the gyro test system implements compliance and integrity verification operations on the data recorded during the test process.

[0065] (8) The gyro test data automatic processing template can be customized according to the gyro test items, technical requirements and technical standards, so as to realize the rapid review and analysis of the test data during the development or production process.

[0066] (9) Automatic processing of gyro test data eliminates the need for tedious and repetitive manual operations. By executing VBA compiled script codes, data processing and report output can be performed automatically and efficiently.

[0067] like Figure 2 As shown, the automatic processing method is applied in an automatic processing system. The automatic processing system includes a host computer, an original test data server and a test computer; wherein the test computer is loaded with a program for implementing the above-mentioned automatic processing method, the host computer is loaded with an MES system and the MES system stores information about test personnel, test equipment and test sample model information for calling; the original test data server is used to store the original test data obtained by the test equipment test; the three are connected through a local area network communication.

[0068] When used specifically:

[0069] 1) Environmental preparation:

[0070] (1) The testing workshop prepares a dedicated data storage server (i.e., the original test data server) for real-time writing and storage of gyro test data.

[0071] (2) Design and develop the "Gyro Test System Host Computer Data Acquisition" (i.e., host computer), specify that data be saved in ".txt" format or ".xls" format, and generate data with data labels in real time through the "Gyro Test System Host Computer Data Acquisition" and write them into the data storage server in real time.

[0072] (3) The testing workshop also has a testing equipment and key tooling data scanning system to enable real-time uploading of test samples and test equipment related information through the system before testing.

[0073] (4) The testing workshop establishes a personnel scanning system to quickly upload relevant information of testing personnel and to conduct systematic quality correlation analysis between original records and test reports.

[0074] (5) Gyro test system and deploy the Excel macro module given by the above automated processing method.

[0075] 2) Data reading:

[0076] (1) Compile the "Gyro Test Data Automatic Processing Template", write the gyro test data processing logic and recording requirements, report template and other related code information, set the data source path (test device or folder), and automatically import the test data in "txt" format or "xsl" format from the specified location.

[0077] (2) Compile the "Gyro Test Data Automatic Processing Template", generate an operation dialog window, assign relevant automatic processing code instructions, and realize one-click generation of data processing results and report output.

[0078] (3) The "Gyro Test Data Automatic Processing Template" implements data discrimination and data transposition and crossover functions by pre-writing codes to form an array. The array mode can realize efficient data transmission and provide a compiled "dictionary" to assign values ​​to the code, so that the "Gyro Test Data Automatic Processing Template" can quickly find and match relevant test machines, personnel, detection process locations, speeds and other information, and provide for the selection, writing, recording and output of report results.

[0079] (4) Key data and calculation methods of the test process, such as the scaling factor (K value coefficient), are pre-set and written into the code information to realize the selection of reference values ​​for the test process and estimate the development trend of the test process results, judge the progress of the test steps, and automatically update the K value coefficient, realizing the prediction and correction of the result trend of the data detection process and the real-time update of the final reported value of the final result.

[0080] 3) Statistical method settings:

[0081] (1) The coding process of the “gyro test data automatic processing template” is to compile the data calculation method and associated test conditions of the non-standard library formula according to the specific requirements of the gyro test, and select the test raw data recorded by the calculation range and associated conditions.

[0082] (2) The "Gyro Test Data Automatic Processing Template" pre-sets the relevant information of the report content and data analysis, realizes the rapid transmission of data through the built-in "data transposition" and "array function", and realizes the automatic processing of gyro test data and the result recording, report output, and report output of quality-related information through the "dictionary" function and other modules.

[0083] 4) Result calculation: The compiled macro script automatically executes the formula calculation and generates the test results.

[0084] 5) Result display and report generation: After the calculation is completed, the results are displayed in Excel, and you can choose to generate a formatted report file and save it to a specified location.

[0085] 6) Data sharing: Through the workshop LAN, each machine can access the test results and reports stored in the shared folder to achieve data sharing and collaborative analysis.

[0086] In summary,

[0087] (1) The script code is compiled during the whole process to realize the fully automated process from data acquisition to result output.

[0088] (2) According to technical specifications or test standard statistical methods, a management system with built-in non-standard formulas for calculation and processing modules is compiled to support rapid adaptation to different test requirements. It has built-in multiple predefined and customizable calculation formulas, which can automatically select and apply the corresponding formulas for calculation according to the different requirements of gyroscope testing, and support dynamic adjustment of formulas, formula ranges and associated conditions to ensure the accuracy and flexibility of the results.

[0089] (3) A workshop-level data sharing mechanism was established to improve team collaboration efficiency. Through the workshop LAN, all machine test data can be shared and synchronized, supporting multi-user simultaneous access and operation, thus improving team collaboration efficiency.

[0090] (4) Automatic result summary and reporting: After the calculation is completed, the test results are automatically summarized and a formatted report file is generated to facilitate subsequent analysis and archiving.

[0091] The above description of the embodiments is to facilitate the understanding and use of the invention by those skilled in the art. It is obvious that those skilled in the art can easily make various modifications to these embodiments and apply the general principles described herein to other embodiments without creative work. Therefore, the present invention is not limited to the above embodiments, and improvements and modifications made by those skilled in the art based on the disclosure of the present invention without departing from the scope of the present invention should be within the scope of protection of the present invention.

Claims

1. A method for automatically processing fiber optic gyroscope test data, characterized in that: The steps include: S1: Open the test data file and obtain the original test data; S2: Clean the original test data; S3: Obtain the testing personnel information, testing equipment information and testing sample model information through the MES system, and fill in the testing record form template with the information and the cleaned data; S4: Based on the detection sample model information, call the corresponding data statistical method to perform data statistical calculation and fill in the detection record form template; S5: Generate a test record form and output a test report including the test record form.

2. The method for automatically processing fiber optic gyroscope test data according to claim 1, characterized in that: The automatic processing method is performed based on VBA in Excel.

3. The automatic processing method for fiber optic gyroscope test data according to claim 2, characterized in that: The test data files include files in txt format and xsl format, and the test data files are stored in a designated folder with a determined path on the detection equipment, the workshop network computer or the data server.

4. The method for automatically processing fiber optic gyroscope test data according to claim 2, characterized in that: The data cleaning includes data difference determination, data transposition and data crossover.

5. The method for automatically processing test data of a fiber optic gyroscope according to claim 2, characterized in that: The information obtained through the MES system and the cleaned data are stored in the cells of the specified path to form an array and construct a dictionary.

6. The method for automatically processing test data of a fiber optic gyroscope according to claim 2, characterized in that: The data statistics method is compiled according to technical standards and technical requirements to construct a non-standard library for statistical calculation of fiber optic gyroscope test data.

7. The method for automatically processing test data of a fiber optic gyroscope according to claim 6, characterized in that: The data statistics method includes the calculation of a scaling factor, and the development trend of the test results is predicted by the scaling factor to judge the test progress.

8. The method for automatically processing test data of a fiber optic gyroscope according to claim 2, characterized in that: The automatic processing method further comprises verifying the integrity and conformity of the original test data; when the original test data passes the verification, step S1 is executed; when the original test data fails the verification, an alarm is issued and the process of the automatic processing method is exited.

9. An automatic processing system for fiber optic gyroscope test data, characterized in that: Including host computer, original test data server and test computer; The test computer is loaded with a program for implementing the automatic processing method as described in any one of claims 1 to 8; The host computer is loaded with an MES system, and the MES system stores information on testing personnel, testing equipment, and testing sample model information; The original test data server is used to store the original test data obtained by the test equipment; The host computer, the original test data server and the test computer are connected via a local area network.

10. A computer-readable storage medium, characterized in that: Computer executable instructions are stored, and the computer executable instructions are used to execute the automatic processing method according to any one of claims 1-8.

Images