CN111966431A - Calculation formula self-defining method applied to laboratory management system - Google Patents

Abstract

The invention relates to the field of computers, in particular to a calculation formula self-defining method applied to a laboratory management system, comprising: establishing a function library including commonly used function models in the laboratory management system; , parameter name and data type; establish a calculation formula based on the function library and according to the parameter type, parameter name and data type of each parameter. The invention reduces the time required for the calculation process and improves the accuracy of the calculation result.

Description

A self-defining method of calculation formula applied to laboratory management system

technical field

The invention relates to the field of computers, in particular to a calculation formula self-defining method applied to a laboratory management system.

Background technique

In the laboratory management system, there are many test items that need to be calculated to obtain results, such as the calculation of some content, the calculation of the mass fraction of components, etc. Most of the previous laboratory management systems often dealt with this part of the calculation process offline when faced with the detection sub-item that requires complex calculation formulas to obtain results. For example, it is calculated by calculation formulas in Excel or manually. With the above method, the calculation efficiency is low and the error rate is high for a relatively complex calculation formula.

SUMMARY OF THE INVENTION

In order to solve the above problems, the present invention proposes a calculation formula self-defining method applied to a laboratory management system.

A calculation formula customization method applied to a laboratory management system, comprising:

Build a function library including common function models in the laboratory management system;

Define the parameter type, parameter name and data type of each parameter according to the detection sub-item;

Based on the function library, the calculation formula is established according to the parameter type, parameter name and data type of each parameter.

Preferably, the establishment of a function library including commonly used function models in the laboratory management system includes:

When the web application of the laboratory management system is started, the commonly used function models are inserted into the function library.

Preferably, after defining the parameter type, parameter name and data type of each parameter according to the detection sub-item, it includes:

A data record of the detection sub-item is generated in the function library, and the data record includes the parameter type, parameter name and data type associated with each parameter.

Preferably, the calculation formula established based on the function library and according to the parameter type, parameter name and data type of each parameter includes:

According to the calculation formula to be established, select the corresponding common function model from the function library to form the preliminary calculation formula;

The final calculation formula is obtained by replacing the original parameters in the preliminary calculation formula according to the parameter type, parameter name and data type of the parameter.

Preferably, it is characterized in that, also comprises:

Verify the correctness of the established calculation formula, and re-establish it if it is not correct.

Preferably, the verification of the correctness of the established calculation formula includes:

Manually assign the detection items and parameters, and test according to the established calculation formula. If the calculated execution result is the same as the assigned result, it is judged that the calculation formula is set correctly; if the calculated execution result is the same as the assigned value. If the results are different, it is judged that the calculation formula is set incorrectly.

By using the present invention, the following effects can be achieved:

1. In the aspect of calculation formula editing, the present invention can provide a comprehensive function library to help the calculator quickly and accurately write the synthetic formula.

2. When calculating, you only need to enter the parameter values required for the calculation, and the system will automatically calculate all the results and assign the results automatically. Compared with manual calculation and reassignment, the time required for the calculation process is greatly reduced, the accuracy of the calculation result is improved, and the entire calculation process can be completed efficiently.

Description of drawings

The present invention will be described in further detail below with reference to the accompanying drawings and specific embodiments.

1 is a schematic flowchart of an embodiment of the present invention;

FIG. 2 is a schematic flowchart of step S105 in the embodiment of the present invention;

FIG. 3 is a schematic flowchart of step S108 in the embodiment of the present invention.

Detailed ways

The technical solutions of the present invention will be further described below with reference to the accompanying drawings, but the present invention is not limited to these embodiments.

Laboratory management system: It is an information management tool that combines information technology with database as the core and laboratory management requirements. The objects of laboratory management are people, things, things, information, funds, etc. related to the laboratory. Therefore, laboratory management mainly includes: laboratory human resources management, quality management, instrument equipment and reagent management, environmental management, safety management, Information management, laboratory setting mode and management system, management organization and functions, construction and planning, etc.

The basic idea of the invention is to establish a function library including common function models in the laboratory management system; to define the parameter type, parameter name and data type of each parameter according to the detection sub-item; based on the function library and according to the parameter type, parameter of each parameter Name and data type to establish a calculation formula, and can be automatically calculated for some detection items that need to be calculated.

Based on the above inventive concept, the present embodiment proposes a method for customizing a calculation formula applied to a laboratory management system, which includes the following steps as shown in FIG. 1 :

S102: establish a function library including commonly used function models in the laboratory management system;

When the web application of the laboratory management system is started, the commonly used function models are inserted into the function library. The commonly used function modules include basic mathematical operation functions (addition, subtraction, multiplication, division), aggregation functions (average, summation, etc.) and some more complex functions, such as relative deviation, pi function and trigonometric function.

A Web application is an application that can be accessed through the Web. The biggest advantage of the program is that the user can easily access the application. The user only needs a browser and does not need to install other software. The web application provides a visual interface for configuring calculation formulas, which is convenient for users to configure calculation formulas. In addition, there is no need to develop and build services and rely on third-party software, saving costs.

S104: Define the parameter type, parameter name and data type of each parameter according to the detection sub-item;

The detection sub-item is the technical performance index specified for detecting a certain object (gas, liquid, solid) by a specified method.

The parameter type can be selected according to the needs of the business. Different parameter types represent the parameter values obtained from different data source models. The data source model refers to the specific object or entity that the parameter data comes from during calculation.

When configuring parameters, first define the parameter variable names, such as paramA and paramB, you can refer to the variable definition rules of javascript.

At the same time, the data type of the parameter can be configured. The data type is an abstraction of the data processed by the program, which determines the meaning, expression, storage format and operation of the data. It can be a number type, a string type or an array type.

In this embodiment, the parameters of the detection sub-item can be configured, and other detection sub-items whose value types are numeric values can be selected as parameters.

S106: Establish a calculation formula based on the function library and according to the parameter type, parameter name and data type of each parameter.

First select the corresponding common function model from the function library according to the calculation formula to be established to form the preliminary calculation formula; then replace the original parameters in the preliminary calculation formula according to the parameter type, parameter name and data type of the parameters to obtain the final calculation formula.

After defining the calculation formula, when the inspector enters the inspection data, some inspection items that need to be calculated can be automatically calculated, which saves the inspector's time for manual calculation and manual input of results, and greatly improves the efficiency and accuracy. .

In some embodiments, as shown in FIG. 2 , after the parameter type, parameter name and data type of each parameter are defined according to the detection sub-item, the following includes:

S105: Generate a data record of the detection items in the function library, where the data records include parameter types, parameter names, and data types associated with each detection item.

After the parameter configuration is completed, a data record of the detection sub-item will be saved in the function library to facilitate the modification or verification of the parameter type, parameter name and data type.

In some embodiments, as shown in Figure 3, the method further includes:

S108: Verify the correctness of the established calculation formula, and re-establish if it is not correct.

Manually assign the detection items and parameters, and test according to the established calculation formula. If the calculated execution result is the same as the assigned result, it is judged that the calculation formula is set correctly; if the calculated execution result is the same as the assigned value. If the results are different, it is judged that the calculation formula is set incorrectly. Verify the calculation formula to ensure the correctness of the calculation formula.

The following are specific examples, and the chlorine content is calculated:

As shown in the table above: select the detection sub-item, define the parameter name of the concentration of the silver nitrate standard solution as C, define the parameter name of the volume of the standard solution consumed by the titration water sample as A, and define the parameter name of the volume of the standard solution consumed by the titration blank The name is defined as B, the parameter name of the volume of the water sample is defined as V, the parameter name of the dilution factor is defined as N, and the data types of the detection items are all numbers.

Based on the function library and according to the parameter type, parameter name and data type of the parameter, a calculation formula is established as ave(A,B)*C*35.45/V*1000*N, the calculation formula is tested, the parameter values are entered respectively, and the test results are obtained. .

Those skilled in the art to which the present invention pertains can make various modifications or additions to the described specific embodiments or substitute in similar manners, but will not deviate from the spirit of the present invention or go beyond the definitions of the appended claims range.

Claims (6)

1. A calculation formula self-defining method applied to a laboratory management system is characterized by comprising the following steps:

establishing a function library comprising a common function model in a laboratory management system;

defining the parameter type, the parameter name and the data type of each parameter according to the detection items;

and establishing a calculation formula based on the function library according to the parameter type, the parameter name and the data type of each parameter.

2. The method of claim 1, wherein the creating a function library including common function models in the laboratory management system comprises:

when a web application of the laboratory management system is started, a commonly used function model is inserted into the function library.

3. The method of claim 1, wherein the defining of the calculation formula for the lab management system comprises, after the defining of the parameter type, the parameter name and the data type of each parameter according to the test items, the defining of the parameter type, the parameter name and the data type according to the test items comprises:

and generating a data record of the detection items in a function library, wherein the data record comprises a parameter type, a parameter name and a data type which are associated with each parameter.

4. The method of claim 1, wherein the step of creating a calculation formula based on the function library and according to the parameter type, the parameter name and the data type of each parameter comprises:

selecting a corresponding common function model from a function library according to a calculation formula to be established to form a preliminary calculation formula;

and replacing the original parameters in the preliminary calculation formula according to the parameter types, the parameter names and the data types of the parameters to obtain a final calculation formula.

5. The method for defining the calculation formula applied to the laboratory management system according to any one of claims 1 to 4, further comprising:

and verifying the correctness of the established calculation formula, and if the calculation formula is incorrect, reestablishing the calculation formula.

6. The method of claim 5, wherein the verifying the correctness of the established calculation formula comprises:

manually assigning values to the detection items and the parameters, testing according to the established calculation formula, and judging that the calculation formula is set without errors if the execution result obtained by calculation is the same as the assigned result; and if the execution result obtained by calculation is different from the assigned result, judging that the calculation formula is set wrongly.

Images