Automatic data processing method based on enzyme-linked immunosorbent assay and related products

Abstract

The invention provides an automatic data processing method and device based on enzyme-linked immunosorbent assay, a medium and electronic equipment. The automatic data processing method comprises the following steps: obtaining type data, subordinate set number and test sequence of each to-be-tested sample in a plurality of sets of to-be-tested samples corresponding to a plurality of worktables of a source file; acquiring absorbance values in a plurality of worktables of the source file; filling a calculation template with the type data, the test sequence numbers and the absorbance values of the to-be-tested samples, and performing logarithmic linear regression analysis calculation to obtain calculation result data corresponding to each to-be-tested sample; and inputting the calculation result data into a summary template to generate a summary table, and identifying the calculation result data in the summary table according to the data state. By adopting the automatic data processing method provided by the invention, the test data can be efficiently, automatically and accurately processed, and meanwhile, the risk of errors in the data processing process by workers is avoided.

Description

Technical Field

[0001] The present application belongs to the field of enzyme-linked immunosorbent assay technology, and in particular relates to an automated data processing method, device, medium and electronic equipment based on enzyme-linked immunosorbent assay analysis. Background Art

[0002] A common method for enzyme-linked immunosorbent assay (ELISA) analysis is the enzyme-linked immunosorbent assay (ELISA). The basic principle of ELISA is to utilize the specific binding of antigen and antibody, develop the color of the substrate through an enzymatic reaction, and detect the antigen or antibody by the degree of color change. ELISA assays typically use laboratory instruments such as microplate readers to measure the absorbance (also known as OD) of the colored product. The absorbance value is used to calculate the antigen or antibody content in the test sample. The antigen or antibody content in the test sample is usually expressed as the antibody concentration value of the test sample.

[0003] In actual work, after the microplate reader performs a measurement, it generates a source file containing the original results. This source file includes multiple worksheets, each corresponding to a type of data in one set of microplates. Different worksheets correspond to different types of data, and different worksheets contain absorbance values ​​associated with the corresponding type of data. Workers need to find the worksheet corresponding to the type of data, copy the absorbance values ​​contained in the worksheet, and paste them into the calculation template for calculation. Due to the large amount of data to be processed, manual copying and pasting is inefficient, and it is easy to paste the wrong data.

[0004] The calculated results also need to be manually copied and pasted into the summary table, which is prone to pasting the wrong data. The summary table is used to summarize and count the antibody concentration values ​​of the samples to be tested. Summary of the Invention

[0005] One of the purposes of this application is to provide an automated data processing method, device, medium, and electronic device based on enzyme-linked immunosorbent assay analysis, which can efficiently solve the difficulties of manually processing large amounts of test data, save manpower and material resources, and avoid the risk of manual errors in data processing. To achieve the above purpose and other related purposes, the first aspect of this application provides an automated data processing method based on enzyme-linked immunosorbent assay analysis, comprising the following steps:

[0006] Obtain the type data, set number and test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file;

[0007] Obtaining absorbance values ​​in multiple worksheets of a source file, including: obtaining an arrangement order of the multiple worksheets of the source file; obtaining a correspondence between the arrangement order of the multiple worksheets of the source file and a test order of samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the set number of the samples to be tested, wherein the modified table names include the test sequence number, type data and set number of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values;

[0008] Fill the type data, test sequence number and absorbance value of the sample to be tested into the calculation template to perform logarithmic linear regression analysis and calculation to obtain the calculation result data corresponding to each sample to be tested;

[0009] The calculation result data is input into a summary template to generate a summary table, and the calculation result data is marked in the summary table according to the data status.

[0010] A second aspect of the present application provides a data processing device, comprising:

[0011] An acquisition module is used to obtain the type data, the number of sets, and the test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file; obtaining the absorbance values ​​in the multiple worksheets of the source file, including: obtaining the arrangement order of the multiple worksheets of the source file; obtaining the correspondence between the arrangement order of the multiple worksheets of the source file and the test sequence of the samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the number of sets of the samples to be tested, the modified table names including the test sequence number, type data, and the number of sets of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values;

[0012] A calculation module is used to fill the type data, test sequence number and absorbance value of the sample to be tested into a calculation template to perform logarithmic linear regression analysis and calculation to obtain calculation result data corresponding to each sample to be tested;

[0013] The summary and statistics module is used to input the calculation result data into the summary template to generate a summary table, and mark the calculation result data in the summary table according to the data status.

[0014] A third aspect of the present application provides a computer-readable storage medium storing a computer program. When the computer program runs on a processor, the processor executes the above-mentioned automated data processing method.

[0015] A fourth aspect of the present application provides an electronic device, comprising: at least one memory for storing a program;

[0016] At least one processor is used to execute the program stored in the memory. When the program stored in the memory is executed, the processor is used to execute the above-mentioned automatic data processing method.

[0017] This application has at least the following beneficial effects:

[0018] The automated data processing method, device, medium, and electronic equipment based on enzyme-linked immunosorbent assay analysis of the present application can process test data efficiently, automatically, and accurately. The processing efficiency is more than 100 times that of manual processing, while avoiding the risk of errors made by staff during data processing. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the following is a brief introduction to the drawings required for use in the embodiments. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other relevant drawings can be obtained based on these drawings without creative work.

[0020] Figure 1 Schematic diagram of a process for automated data processing based on enzyme-linked immunosorbent assay analysis according to an embodiment of the present application;

[0021] Figure 2 This is a schematic diagram of the input location of type data in the calculation template shown in Example 1, where the input location is marked with a red box;

[0022] Figure 3 Schematic diagram of the location of absorbance values ​​in one of the worksheets of the source file shown in Example 1;

[0023] Figure 4 A schematic diagram of the operation interface for performing calculations using the calculation template shown in Example 1;

[0024] Figure 5 Schematic diagram of the input position of the test sequence number in the calculation template shown in Example 1;

[0025] Figure 6 This is a schematic diagram of an operation interface for inputting multiple calculation result data into a summary template as shown in Example 1;

[0026] Figure 7 This is a schematic diagram of the summary table shown in Example 1. DETAILED DESCRIPTION

[0027] The following describes the embodiments of the present application through specific embodiments. Those skilled in the art can easily understand other advantages and effects of the present application from the contents disclosed in this specification. The present application can also be implemented or applied through other different specific embodiments. The details in the present application can also be modified or changed based on different viewpoints and applications without departing from the spirit of the present application. It should be noted that the following embodiments and features in the embodiments can be combined with each other unless they conflict.

[0028] In the embodiments of this application, words such as "exemplary" or "for example" are used to indicate examples, illustrations, or descriptions. Any embodiment or design described as "exemplary" or "for example" in the embodiments of this application should not be considered to be preferred or advantageous over other embodiments or designs. Rather, the use of words such as "exemplary" or "for example" is intended to present the relevant concepts in a concrete manner.

[0029] In the description of the embodiments of the present application, unless otherwise specified, "multiple" means two or more, for example, multiple processing units means two or more processing units, etc., multiple elements means two or more elements, etc.

[0030] In order to solve the problem mentioned in the background art that manual processing of a large amount of test data is inefficient and prone to errors in the data processing process, see Figure 1 The present application provides an automated data processing method based on enzyme-linked immunosorbent assay analysis, comprising the following steps:

[0031] Obtain the type data, set number and test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file;

[0032] Obtaining absorbance values ​​in multiple worksheets of a source file, including: obtaining an arrangement order of the multiple worksheets of the source file; obtaining a correspondence between the arrangement order of the multiple worksheets of the source file and a test order of samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the set number of the samples to be tested, wherein the modified table names include the test sequence number, type data and set number of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values;

[0033] Fill the type data, test sequence number and absorbance value of the sample to be tested into the calculation template to perform logarithmic linear regression analysis and calculation to obtain the calculation result data corresponding to each sample to be tested;

[0034] The calculation result data is input into a summary template to generate a summary table, and the calculation result data is marked in the summary table according to the data status.

[0035] In some embodiments, the correspondence between the arrangement order of the multiple worksheets in the source file and the test order of the samples to be tested is that the arrangement order of the multiple worksheets in the source file is the same as the test order of the samples to be tested, or the arrangement order of the multiple worksheets in the source file is opposite to the test order of the samples to be tested. If the arrangement order of the multiple worksheets in the source file is opposite to the test order of the samples to be tested, a VBA macro file can be used to reorder the multiple worksheets in the source file so that the arrangement order of the multiple worksheets in the source file is the same as the test order of the samples to be tested.

[0036] In some embodiments, the type data, number of sets, and test sequence of the sample to be tested are obtained by copying from a collection record sheet, which is a spreadsheet that records the type data, number of sets, and test sequence of the sample to be tested. The type data, number of sets, and test sequence of the sample to be tested can be obtained by copying from the collection record sheet using a VBA macro file. A VBA macro file is a macro file created using a VBA editor that can perform operations such as copying, pasting, and data comparison.

[0037] Furthermore, the table names of multiple worksheets in the source file can be modified using a VBA macro file. The modified table names include the test sequence number, type data, and set number of the corresponding sample to be tested, making it easier to find, locate, and simultaneously copy the test sequence number, type data, and set number of the sample to be tested corresponding to multiple worksheets, as well as the absorbance values ​​included in the multiple worksheets. The table names of multiple worksheets in the source file can be modified using either of the following two modification methods.

[0038] The first modification method is to copy the type data and the number of sets of one of the samples to be tested in the receipt record table according to the test sequence of the samples to be tested, and find the worksheet name corresponding to the type data and the number of sets of the sample to be tested for modification. Repeat the above operations so that all worksheet names of the source file contain the test sequence number, type data and the number of sets of the corresponding sample to be tested.

[0039] The second modification method is to copy the type data, number of sets and test sequence of the samples to be tested in the receipt record table, and find the worksheet names corresponding to the type data and number of sets of the samples to be tested according to the correspondence between the arrangement order of multiple worksheets in the source file and the test sequence of the samples to be tested, and modify them. After the modification, all worksheet names of the source file contain the test sequence number, type data and number of sets corresponding to the samples to be tested.

[0040] In some embodiments, a VBA macro file can be used to traverse and obtain the positions of absorbance values ​​in multiple worksheets of the source file after the table name is modified, and according to the positions of the absorbance values, the absorbance values ​​in multiple worksheets of the source file after the table name is modified are obtained.

[0041] The sample type data, test sequence number, and absorbance value are entered into a calculation template and a log-linear regression analysis is performed. This analysis is used to analyze the log-linear relationship between absorbance and concentration within a preset concentration range. For pneumococcal vaccines, log-linear regression analysis can also be used to determine the absorbance values ​​corresponding to different concentrations of standard serum, allowing the creation of a standard curve.

[0042] In some embodiments, a VBA macro file can be used to fill in the type data of the sample to be tested and the test sequence number into the calculation template through any one of the following two filling methods.

[0043] The first filling method is to copy the type data and test sequence number of the corresponding sample to be tested contained in one of the worksheet table names of the source file after the table name is modified according to the test order of the sample to be tested, and paste it into the input position of the corresponding type data and test sequence number of the sample to be tested in the calculation template. Repeat the above operation so that the type data and test sequence number of the corresponding sample to be tested contained in multiple worksheet table names of the source file after the table name is modified are filled in the calculation template.

[0044] The second filling method is to copy the type data of the samples to be tested and the test sequence numbers contained in the multiple worksheet names of the source file after the table names are modified, and fill the type data of the samples to be tested and the test sequence numbers contained in the multiple worksheet names of the source file after the table names are modified into the calculation template according to the correspondence between the arrangement order of the multiple worksheets of the source file and the input positions of the type data of the samples to be tested and the test sequence numbers in the calculation template.

[0045] In some embodiments, the calculated result data includes the antibody concentration value of the sample to be tested.

[0046] The specific method for calculating the antibody concentration value of the test sample includes: drawing a standard curve, which can be obtained by performing log-linear regression analysis on the test samples of different concentrations and the corresponding absorbance values; determining the concentration range of the test sample, and comparing the absorbance value of the test sample with the standard curve according to the range of the standard curve to determine the range of the antibody concentration value of the test sample; diluting the test sample, if the concentration of the test sample is too high, it needs to be diluted, and the dilution factor (Pre-Dilution value) can be obtained by calculation, generally selected within the log-linear range of the standard curve; calculating the antibody concentration value of the test sample, and calculating the antibody concentration value of the test sample by a log-linear regression equation based on the absorbance value of the test sample, the dilution factor, and the slope and intercept of the standard curve.

[0047] In some embodiments, a VBA macro file may be used to input the calculation result data into a summary template to generate a summary table through any one of the following two copying methods.

[0048] The first copying method is to copy the calculation result data corresponding to one of the samples to be tested according to the test order of the samples to be tested, and paste it into the input position of the calculation result data corresponding to the sample to be tested in the summary template, and repeat the above operation so that the calculation result data corresponding to each sample to be tested obtained by the calculation template is filled in the corresponding input position.

[0049] The second copying method is to copy the calculation result data corresponding to each sample to be tested obtained by the calculation template, and according to the test order of the samples to be tested, find the input position of the calculation result data corresponding to each sample to be tested in the summary template and fill it in. The filled summary template contains the calculation result data corresponding to each sample to be tested.

[0050] In some embodiments, labeling the calculation result data according to the data status includes comparing the calculation result data in the summary table with a preset standard, and color-coding the position of the calculation result data of the corresponding test sample in the summary table based on the comparison result. The color coding can intuitively indicate whether the antibody concentration value of the test sample meets the concentration range of the preset standard, facilitating subsequent retesting, screening, and judgment. The preset standard can be a clinical trial standard operating procedure.

[0051] The following example 1 is used to illustrate the automated data processing method based on enzyme-linked immunosorbent assay analysis of the present application.

[0052] Example 1

[0053] The application scenario of Example 1 is to use ELISA to determine whether specific antibodies are present in human serum after vaccination with a pneumococcal vaccine. The test sample is vaccine serum, and the type data is the type data corresponding to the pneumococcal serotype. For example, the 13 serotypes of the 13-valent pneumococcal polysaccharide conjugate vaccine serum are: 1, 3, 4, 5, 6A, 6B, 7F, 9V, 14, 18C, 19A, 19F, and 23F. The type data of the vaccine serum is also 1, 3, 4, 5, 6A, 6B, 7F, 9V, 14, 18C, 19A, 19F, and 23F, for a total of 13 types of type data.

[0054] The automated data processing method based on enzyme-linked immunosorbent assay analysis includes at least the following steps:

[0055] Obtain the type data, set number and test sequence of each vaccine serum in the multiple sets of vaccine serum corresponding to the multiple worksheets of the source file;

[0056] Obtaining absorbance values ​​in multiple worksheets of a source file includes: obtaining an arrangement order of the multiple worksheets of the source file; obtaining a correspondence between the arrangement order of the multiple worksheets of the source file and a test order of vaccine serum; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the set number of the vaccine serum, wherein the modified table names include the test sequence number, type data and set number of the corresponding vaccine serum; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values. Figure 3 The boxed portion shown shows the location of the absorbance values ​​in one of the worksheets of the source file.

[0057] Specifically, there are 13 types of vaccine serum type data, and each microplate reader can simultaneously test four sets of 52 microplates. The modified table name contains the test sequence number, type data, and set number of the corresponding vaccine serum. For example, the modified table name is "001 1-1," where 001 represents the test sequence number, the 1 on the left of 1-1 represents the type data (i.e., type 1), and the 1 on the right represents the set number (i.e., set 1); the modified table name is "052 23F-4," where 052 represents the test sequence number, 23F represents the type data, and 4 represents the set number (i.e., set 4).

[0058] The type data, test sequence number and absorbance value of the vaccine serum are filled into the calculation template for logarithmic linear regression analysis and calculation to obtain the calculation result data corresponding to each vaccine serum; wherein, Figure 2 Shows the input location of the type data in the calculation template. Specifically, fill in the type data of the vaccine serum Figure 2 The B14 position of the calculation template. Figure 4Shows the operation interface for performing calculations in the calculation template. Figure 5 Shows the input position of the test sequence number in the calculation template. Fill in the test sequence number of the vaccine serum into the I12 position of the calculation template.

[0059] The calculation template and the source file can be placed in the same target folder, which makes it easier for the calculation template to find and copy the type data, set number and absorbance values ​​in multiple worksheets of the source file through the VBA macro file.

[0060] Specifically, before placing the calculation template and the source file in the same target folder, it is necessary to find the initial storage location of the source file. Usually the source file is stored in the data folder "AA-X-originaldata" under the device folder "AA-X", where AA is the test date, for example 20240101, X is the device number of the microplate reader, and Orgininal Data is the type data, the number of sets and the test sequence. The source file is usually named "AA-X-book1.xlsx". The collection record sheet is also usually recorded as a serum dilution sheet. The type data, the number of sets and the test sequence of the vaccine serum can be obtained according to the collection record sheet, and the table names of the multiple worksheets of the source file can be modified, for example, the source file named "AA-X-book1.xlsx" is named "AA-X-Orgininal Data.xlsx".

[0061] After the calculation template is calculated, a result folder "AA-X-Result" is created under the device folder "AA-X". Then, a set folder "AA-XY" is created under the result folder "AA-X-Result". A table named "AA-XYZ" is created under the set folder "AA-XY" to store the calculation result data.

[0062] The calculation result data is input into a summary template to generate a summary table, and the calculation result data is marked in the summary table according to the data status. Figure 6 This is a schematic diagram of the operation interface for inputting calculation result data into the summary template. Figure 7 This is a schematic diagram of a summary table, in which the concentration of quality control serum (also known as quality control QC) that exceeds the standard range specified in the clinical trial standard operating procedure is marked with color and is explained in text with a box with an arrow next to it. The above-mentioned quality control serum is a type of serum sample.

[0063] The present invention realizes the function of automated batch test data processing, effectively solves the difficulty of manually processing large amounts of test data, saves manpower and material resources, reduces the probability of errors caused by manual data processing, and avoids the risk of data screening by data processing test personnel. It has the advantage of "one-click" high-efficiency and automated processing of batch test data.

[0064] A second aspect of the present application provides a data processing device, comprising:

[0065] An acquisition module is used to obtain the type data, the number of sets, and the test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file; obtaining the absorbance values ​​in the multiple worksheets of the source file, including: obtaining the arrangement order of the multiple worksheets of the source file; obtaining the correspondence between the arrangement order of the multiple worksheets of the source file and the test sequence of the samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the number of sets of the samples to be tested, the modified table names including the test sequence number, type data, and the number of sets of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values;

[0066] A calculation module is used to fill the type data, test sequence number and absorbance value of the sample to be tested into a calculation template to perform logarithmic linear regression analysis and calculation to obtain calculation result data corresponding to each sample to be tested;

[0067] The summary and statistics module is used to input the calculation result data into the summary template to generate a summary table, and mark the calculation result data in the summary table according to the data status.

[0068] The third aspect of the present application provides a computer-readable storage medium, on which a program of an automated data processing method based on enzyme-linked immunosorbent assay analysis is stored, so that the automated data processing method based on enzyme-linked immunosorbent assay analysis provided in the first aspect of the present application is executed. As for the aforementioned computer-readable storage medium, those skilled in the art will understand that the embodiments for realizing the functions of the aforementioned system and each unit can be accomplished by hardware related to the computer program. The aforementioned computer program can be stored in a computer-readable storage medium. When the program is executed, it executes an embodiment including the functions of the aforementioned system and each unit. The aforementioned storage medium includes various media that can store program codes, such as ROM, RAM or optical disk.

[0069] In a fourth aspect, the present application provides an electronic device comprising: at least one memory for storing programs; and at least one processor for executing the programs stored in the memory. The electronic device may be a server. The electronic device comprises a processor, a memory, a network interface, and a database connected via a system bus. The processor of the electronic device is used to provide computing and control capabilities. The memory of the electronic device comprises a non-volatile and / or volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the electronic device is used to communicate with an external client via a network connection. When the computer program is executed by the processor, the functions or steps of the automated data processing method based on enzyme-linked immunosorbent assay analysis are realized.

[0070] The above is only a preferred embodiment of the present application. It should be pointed out that for technicians in this technical field, several improvements and replacements can be made without departing from the technical principles of the present application. These improvements and replacements should also be regarded as the scope of protection of the present application.

Claims

1. An automated data processing method based on enzyme-linked immunosorbent assay analysis, characterized in that: The following steps are involved: Obtain the type data, set number and test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file; Obtaining absorbance values ​​in multiple worksheets of a source file, including: obtaining an arrangement order of the multiple worksheets of the source file; obtaining a correspondence between the arrangement order of the multiple worksheets of the source file and a test order of samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the set number of the samples to be tested, wherein the modified table names include the test sequence number, type data and set number of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values; Fill the type data, test sequence number and absorbance value of the sample to be tested into the calculation template to perform logarithmic linear regression analysis and calculation to obtain the calculation result data corresponding to each sample to be tested; The calculation result data is input into a summary template to generate a summary table, and the calculation result data is marked in the summary table according to the data status.

2. The automated data processing method according to claim 1, characterized in that: The type data, the number of sets and the test sequence of the sample to be tested are obtained by copying from the collection record sheet, which is an electronic form recording the type data, the number of sets and the test sequence of the sample to be tested.

3. The automated data processing method according to claim 1, characterized in that: The calculation result data includes the antibody concentration value of the sample to be tested.

4. The automated data processing method according to claim 1, wherein: The correspondence between the arrangement order of the multiple worksheets in the source file and the test order of the samples to be tested is that the arrangement order of the multiple worksheets in the source file is the same as the test order of the samples to be tested, or the arrangement order of the multiple worksheets in the source file is opposite to the test order of the samples to be tested.

5. The automated data processing method according to claim 1, characterized in that: The marking of the calculation result data according to the data status includes: comparing the calculation result data in the summary table with a preset standard, and marking the position of the calculation result data of the corresponding sample to be tested in the summary table with a color according to the comparison result.

6. A data processing device, characterized in that: include: An acquisition module is used to obtain the type data, the number of sets and the test sequence of each sample to be tested in the multiple sets of samples to be tested corresponding to the multiple worksheets of the source file; Obtaining absorbance values ​​in multiple worksheets of a source file, including: obtaining an arrangement order of the multiple worksheets of the source file; obtaining a correspondence between the arrangement order of the multiple worksheets of the source file and a test order of samples to be tested; modifying the table names of the multiple worksheets of the source file according to the correspondence and the type data and the set number of the samples to be tested, wherein the modified table names include the test sequence number, type data and set number of the corresponding samples to be tested; obtaining the position of the absorbance values ​​in the multiple worksheets of the source file after the table names are modified; and obtaining the absorbance values ​​in the multiple worksheets of the source file after the table names are modified according to the position of the absorbance values; A calculation module is used to fill the type data, test sequence number and absorbance value of the sample to be tested into a calculation template to perform logarithmic linear regression analysis and calculation to obtain calculation result data corresponding to each sample to be tested; The summary and statistics module is used to input the calculation result data into the summary template to generate a summary table, and mark the calculation result data in the summary table according to the data status.

7. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, which, when executed on a processor, enables the processor to execute the automated data processing method according to any one of claims 1 to 5.

8. An electronic device, characterized in that: include: at least one memory for storing a program; At least one processor is configured to execute the program stored in the memory. When the program stored in the memory is executed, the processor is configured to execute the automated data processing method according to any one of claims 1 to 5.

Images