CN111966431A - Calculation formula self-defining method applied to laboratory management system - Google Patents
Calculation formula self-defining method applied to laboratory management system Download PDFInfo
- Publication number
- CN111966431A CN111966431A CN202010587924.1A CN202010587924A CN111966431A CN 111966431 A CN111966431 A CN 111966431A CN 202010587924 A CN202010587924 A CN 202010587924A CN 111966431 A CN111966431 A CN 111966431A
- Authority
- CN
- China
- Prior art keywords
- parameter
- calculation formula
- management system
- type
- defining
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/11—Complex mathematical operations for solving equations, e.g. nonlinear equations, general mathematical optimization problems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06313—Resource planning in a project environment
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Mathematical Physics (AREA)
- Operations Research (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Entrepreneurship & Innovation (AREA)
- Pure & Applied Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Mathematical Optimization (AREA)
- Mathematical Analysis (AREA)
- Economics (AREA)
- Computational Mathematics (AREA)
- Algebra (AREA)
- Development Economics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Educational Administration (AREA)
- Databases & Information Systems (AREA)
- Game Theory and Decision Science (AREA)
- Biodiversity & Conservation Biology (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Human Computer Interaction (AREA)
- Automatic Analysis And Handling Materials Therefor (AREA)
Abstract
The invention relates to the field of computers, in particular to a calculation formula self-defining method applied to a laboratory management system, which comprises 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. The invention reduces the time required by the calculation process and improves the accuracy of the calculation result.
Description
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
In a laboratory management system, there are many detection components which need to be calculated to obtain a result, such as calculation of some content, calculation of mass fraction of a component, and the like. Most of the prior laboratory management systems usually put the process of the calculation under line when facing the detection items which need to obtain the result through a complex calculation formula. Such as by a calculation formula in Excel or manually. The method has low calculation efficiency and high error rate for a more complex calculation formula.
Disclosure of Invention
In order to solve the problems, the invention provides a calculation formula self-defining method applied to a laboratory management system.
A calculation formula self-defining method applied to a laboratory management system comprises 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.
Preferably, the establishing a function library including a common function model in the laboratory management system includes:
when a web application of the laboratory management system is started, a commonly used function model is inserted into the function library.
Preferably, after the defining the parameter type, the parameter name and the data type of each parameter according to the detection items, the method includes:
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.
Preferably, the establishing a calculation formula based on the function library and according to the parameter type, the parameter name and the data type of each parameter includes:
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.
Preferably, the method further comprises the following steps:
and verifying the correctness of the established calculation formula, and if the calculation formula is incorrect, reestablishing the calculation formula.
Preferably, 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.
By using the present invention, the following effects can be achieved:
1. in the aspect of editing the calculation formula, the invention can provide a comprehensive function library to help a calculator to quickly and accurately write the synthesis formula.
2. During calculation, only parameter values required by calculation need to be input, and the system can automatically calculate all results and automatically assign values to the results. Compared with manual calculation and re-assignment, the time required by the calculation process is greatly reduced, the accuracy of the calculation result is improved, and the whole calculation process can be efficiently completed.
Drawings
The present invention will be described in further detail with reference to the accompanying drawings and specific embodiments.
FIG. 1 is a schematic flow diagram of an embodiment of the present invention;
FIG. 2 is a schematic flow chart 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 Description
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.
The laboratory management system is an information management tool which combines the information technology taking a database as a core and the laboratory management requirement. The objects of laboratory management are people, matters, things, information, expenses, etc. related to the laboratory, and therefore, the laboratory management mainly includes: the system comprises the following components of laboratory human resource management, quality management, instrument and reagent management, environment management, safety management, information management, laboratory setting mode and management system, management institution and function, construction and planning and the like.
The basic idea of the invention is to establish 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, and automatically calculating some detection items needing to be calculated.
Based on the above inventive concept, this embodiment provides a calculation formula customization method applied to a laboratory management system, which includes the following steps as shown in fig. 1:
s102: establishing a function library comprising a common function model in a laboratory management system;
when a web application of the laboratory management system is started, a commonly used function model is 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, circumferential rate function, trigonometric function, etc.
The Web application is an application program which can be accessed through Web, and the greatest benefit of the program is that a user can easily access the application program, and the user only needs to have a browser and does not need to install other software. The Web application provides a visual interface for configuring the calculation formula, and is convenient for a user to configure the calculation formula. In addition, additional development and construction of services and dependence on third-party software are not needed, and cost is saved.
S104: defining the parameter type, the parameter name and the data type of each parameter according to the detection items;
the detection items are technical performance indexes appointed by detecting a certain object (gas, liquid and solid) by an appointed method.
The parameter types can be selected according to the requirements of services, different parameter types represent the values of parameters and are obtained from different data source models, and the data source models refer to specific objects or entities from which the parameter data are derived during calculation.
When configuring parameters, firstly, parameter variable names, such as paramA and paramB, need to be defined, and the variable definition rules of javascript can be referred to.
Meanwhile, the data type of the parameter can be configured, the data type is abstract of data processed by a program, the meaning, the expression mode, the storage format and the operation of the data are determined, and the data type can be selected from a number type, a character string type or an array type.
In this embodiment, the parameters of the detection items may be configured, and other detection items with numerical values may be selected as the parameters.
S106: 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.
Firstly, 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 then 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.
After the calculation formula is defined, when an inspector inputs inspection data, automatic calculation can be carried out on some detection items needing to be calculated, the time for the inspector to manually calculate and manually input results is saved, and the efficiency and the accuracy are greatly improved.
In some embodiments, as shown in fig. 2, after the defining the parameter type, the parameter name, and the data type of each parameter according to the detection clause includes:
s105: 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 detection item.
After the parameter configuration is completed, a data record of the detection items is stored in the function library so as to facilitate the modification or verification of the parameter types, the parameter names and the data types.
In some embodiments, as shown in fig. 3, the method further comprises:
s108: and verifying the correctness of the established calculation formula, and if the calculation formula is incorrect, reestablishing the calculation formula.
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. The correctness of the calculation formula is ensured through the verification of the calculation formula.
The following are specific examples, calculating the chlorine content:
as shown in the above table: selecting detection items, defining the parameter name of the concentration of the silver nitrate standard solution as C, defining the parameter name of the volume of the standard solution consumed by titrating a water sample as A, defining the parameter name of the volume of the standard solution consumed by titrating a blank as B, defining the parameter name of the volume of the water sample as V, and defining the parameter name of the dilution multiple as N, wherein the data types of the detection items are numbers.
And establishing a calculation formula, namely ave (A, B) C35.45/V1000N, based on the function library and according to the parameter types, the parameter names and the data types of the parameters, testing the calculation formula, and respectively inputting the parameter values to obtain a test result.
Various modifications or additions may be made to the described embodiments or alternatives may be employed by those skilled in the art without departing from the spirit or ambit of the invention as defined in the appended claims.
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.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010587924.1A CN111966431A (en) | 2020-06-24 | 2020-06-24 | Calculation formula self-defining method applied to laboratory management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010587924.1A CN111966431A (en) | 2020-06-24 | 2020-06-24 | Calculation formula self-defining method applied to laboratory management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111966431A true CN111966431A (en) | 2020-11-20 |
Family
ID=73360691
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010587924.1A Pending CN111966431A (en) | 2020-06-24 | 2020-06-24 | Calculation formula self-defining method applied to laboratory management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111966431A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113159630A (en) * | 2021-05-13 | 2021-07-23 | 北京三维天地科技股份有限公司 | Method for maintaining calculation formula in laboratory information management system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6167565A (en) * | 1998-01-08 | 2000-12-26 | Microsoft Corporation | Method and system of custom marshaling of inter-language parameters |
| CN106126907A (en) * | 2016-06-22 | 2016-11-16 | 中国空气动力研究与发展中心高速空气动力研究所 | A kind of method and apparatus realizing self-defining formula calculating in wind tunnel test |
| CN110851344A (en) * | 2019-09-17 | 2020-02-28 | 恒生电子股份有限公司 | Big data testing method and device based on computational formula complexity and electronic equipment |
-
2020
- 2020-06-24 CN CN202010587924.1A patent/CN111966431A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6167565A (en) * | 1998-01-08 | 2000-12-26 | Microsoft Corporation | Method and system of custom marshaling of inter-language parameters |
| CN106126907A (en) * | 2016-06-22 | 2016-11-16 | 中国空气动力研究与发展中心高速空气动力研究所 | A kind of method and apparatus realizing self-defining formula calculating in wind tunnel test |
| CN110851344A (en) * | 2019-09-17 | 2020-02-28 | 恒生电子股份有限公司 | Big data testing method and device based on computational formula complexity and electronic equipment |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113159630A (en) * | 2021-05-13 | 2021-07-23 | 北京三维天地科技股份有限公司 | Method for maintaining calculation formula in laboratory information management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Heijungs | On the number of Monte Carlo runs in comparative probabilistic LCA | |
| CN111061833B (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| US9535821B1 (en) | Displaying violated coding rules in source code | |
| CN111722839B (en) | Code generation method and device, electronic equipment and storage medium | |
| EP3023876A1 (en) | Quality assurance tools for use with source code and a semantic model | |
| CN109710528B (en) | Test script generation method, device, equipment and medium | |
| CN108710571B (en) | Method and device for generating automatic test code | |
| CN107451112B (en) | Form tool data checking method, device, terminal equipment and storage medium | |
| Bahar et al. | An interactive website for analytical method comparison and bias estimation | |
| CN110990274A (en) | Data processing method, device and system for generating test case | |
| CN116089258A (en) | Data migration test method, device, equipment, storage medium and program product | |
| CN114168565B (en) | Backtracking test method, device and system of business rule model and decision engine | |
| CN115114146A (en) | Interface test method, device, equipment and storage medium | |
| CN111966431A (en) | Calculation formula self-defining method applied to laboratory management system | |
| CN117632710A (en) | Method, device, equipment and storage medium for generating test code | |
| CN112416782A (en) | Test result verification method and device and electronic equipment | |
| CN112416333A (en) | Software model training method, device, system, equipment and storage medium | |
| CN111858377A (en) | Quality evaluation method and device for test script, electronic device and storage medium | |
| CN115809228A (en) | Data comparison method and device, storage medium and electronic equipment | |
| CN115983191A (en) | Test point verification method and related device | |
| Fatima et al. | Towards a sustainability-aware software architecture evaluation for cloud-based software services | |
| CN116755684B (en) | OAS Schema generation method, device, equipment and medium | |
| Dimech et al. | Comprehensive quality control programme for serology and nucleic acid testing using an internet-based application | |
| CN113742225B (en) | Test data generation method, device, equipment and storage medium | |
| Goraya | RStudioDataLab |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |