CN113159630B - Method for maintaining calculation formula in laboratory information management system - Google Patents
Method for maintaining calculation formula in laboratory information management system Download PDFInfo
- Publication number
- CN113159630B CN113159630B CN202110523865.6A CN202110523865A CN113159630B CN 113159630 B CN113159630 B CN 113159630B CN 202110523865 A CN202110523865 A CN 202110523865A CN 113159630 B CN113159630 B CN 113159630B
- Authority
- CN
- China
- Prior art keywords
- calculation formula
- maintenance
- calculation
- test
- preset
- 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.)
- Active
Links
Images
Classifications
-
- 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/06311—Scheduling, planning or task assignment for a person or group
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
- G06F16/90335—Query processing
- G06F16/90344—Query processing by using string matching techniques
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
- G06F8/44—Encoding
Abstract
The invention provides a method for maintaining a calculation formula in a laboratory information management system, which comprises the following steps: determining analysis item and repetition number data on which a calculation formula depends based on an analysis item selector or a test selector; adding a calculation formula operator based on an operator icon in a calculation formula input interface; matching corresponding built-in functions from a preset function library according to the requirement of a calculation formula; determining other analysis items and repeated data on which the calculation formula depends, determining other operators and a function library according to the requirements of the calculation formula, and completing the input of the calculation formula; and inputting related test values of the calculation formula based on the input calculation formula, testing the calculation formula, and finishing the maintenance of the calculation formula after the test is passed. By providing the maintenance function of the calculation formula, heavy formula calculation work after detection data are input by detection personnel is reduced, the accuracy of the detection data is improved, the detection efficiency is improved, and the detection data are automatically calculated according to the calculation formula after being input.
Description
Technical Field
The invention relates to the technical field of inspection and detection, in particular to a method for maintaining a calculation formula in a laboratory information management system.
Background
At present, a Laboratory Information Management System (LIMS) is based on an all-round Laboratory Information Management System that takes a Laboratory or a detection mechanism as a core and conforms to international specifications, organically combines modern Management ideas with a network technology, a data storage technology, a rapid data processing technology and an automated instrument analysis technology, integrates a plurality of functions such as task Management, sample Management, resource Management, data Management, report Management and transaction Management into a whole by establishing a distributed Information Management System taking the Laboratory as a center, and implements all-round Management and control on the Laboratory, so that a final product of the Laboratory, namely all detection or Management data and Information conform to related quality standards or specifications.
In a laboratory information management system, a system user generally maintains a calculation formula by directly compiling a calculation formula script, the requirement on maintenance personnel is high, errors are easy to occur in the compiling process, and the maintenance efficiency is low.
Disclosure of Invention
The invention provides a method for maintaining a calculation formula in a laboratory information management system, which is used for providing a maintenance function of the calculation formula, reducing the heavy formula calculation work after detection data are input by detection personnel, improving the accuracy of the detection data and improving the detection efficiency, so that the calculation is automatically carried out according to the calculation formula after the detection data are input.
The invention provides a method for maintaining a calculation formula in a laboratory information management system, which comprises the following steps:
step 1: determining a first analysis item and first repeated number data on which the calculation formula depends based on the analysis item selector or the test selector;
step 2: adding a first operator of the calculation formula based on an operator icon in a calculation formula input interface;
and step 3: matching corresponding built-in functions from a preset function library according to the requirement of a calculation formula;
and 4, step 4: determining a second analysis item and second repeated data which are depended by the calculation formula, determining a second operator and a function library according to the requirement of the calculation formula, and completing the input of the calculation formula based on the guiding operation of the input interface of the calculation formula;
and 5: and based on the input calculation formula, inputting the relevant test values to test the input calculation formula, and after the test is passed, realizing the maintenance of the input calculation formula.
Preferably, a method for maintaining a calculation formula in a laboratory information management system, after performing step 1 and before performing step 2, further comprises:
acquiring a calculation formula input interface in a laboratory information management system and a function library, a data source and an operator which are required to be used in the maintenance process of the calculation formula;
labeling the function library, the data source and the operator to obtain labels corresponding to the function library, the data source and the operator;
performing hyperlink processing on the labels corresponding to the function library, the data source and the operator and the data in the function library, the data source and the operator, and placing the labels corresponding to the function library, the data source and the operator after hyperlink processing on the calculation formula entry interface;
a user clicks a corresponding label in a calculation formula input interface according to an analysis item, repetition number data, an operator and a built-in function on which a calculation formula depends to enter a target database corresponding to each label, wherein the target database stores a plurality of analysis items, repetition number data, operators and built-in function data;
and selecting a first analysis item, first repeated data, a first operator and a built-in function on which the calculation formula depends based on the target database to complete visualization and guide operation in the maintenance process of the calculation formula.
Preferably, the method for maintaining the calculation formula in the laboratory information management system, in step 1, determining the first analysis item and the first repetition number data on which the calculation formula depends, includes:
receiving a target selector determined by a user based on a laboratory information management system, and logging in a calculation formula entry interface after the target selector is determined;
wherein the target selector comprises an analysis item selector and a test selector;
if the analysis item selector is determined, determining different analysis items under the same test based on the calculation formula input interface, and simultaneously determining first repeated data corresponding to the analysis items;
if the test selector is determined, inputting the test name based on the calculation formula input interface,
meanwhile, after the test name is input, selecting a test option and switching to a corresponding first analysis item;
automatically filling test analysis items in the preset selection items based on preset selection items in the first analysis items, and determining corresponding first repetition number data according to the test analysis items;
wherein the repetition number data includes the same repetition number, all repetition numbers, and a specified repetition number.
Preferably, in step 2, based on an operator icon in a calculation formula entry interface, adding a first operator of the calculation formula, including:
acquiring a first analysis item and first repetition number data which are depended by the calculation formula, and displaying the first analysis item and the first repetition number data in a preset calculation formula display frame;
selecting a preset operator option from an operation formula input interface based on a first analysis item and first repeated data in a display frame, and determining a first operator from a preset operator database based on the operator option;
and adding the determined first operator to the preset calculation formula display frame to finish the addition and maintenance of the calculation formula operator.
Preferably, the method for maintaining the calculation formula in the laboratory information management system, in step 3, matching the corresponding built-in function from the preset function library according to the calculation formula requirement includes:
acquiring analysis items and repeated data which are depended by the calculation formula and operators added in the calculation formula;
selecting a preset data source option from a calculation formula input interface based on the analysis item and the repetition data depended on by the calculation formula and the operator added in the calculation formula;
the preset data source is displayed in a combined mode of brackets, vertical bars and commas, and a plurality of function libraries are arranged in the preset data source;
matching a target built-in function from the plurality of function libraries based on the requirement of a calculation formula on the built-in function;
if the target built-in function is matched from the function libraries, adding the target built-in function to a preset calculation formula display frame to finish the addition of the calculation formula built-in function;
otherwise, updating the preset data source in real time based on the requirement of the user on the built-in function of the calculation formula, expanding the function libraries, and matching the target built-in function from the function libraries again until the requirement of the user on the built-in function of the calculation formula is met.
Preferably, in step 5, based on the entered calculation formula, the method of inputting the relevant test value to test the entered calculation formula, and after the test is passed, implementing the maintenance of the entered calculation formula, includes:
acquiring a calculation formula which is recorded in a preset calculation formula display frame, and determining a target conversion parameter of the recorded calculation formula during format conversion;
determining a format table name corresponding to the input calculation formula based on the target conversion parameter, determining a format table corresponding to the format table name, and determining a mapping relation between the input calculation formula and a corresponding output target format in the format table;
determining character strings to be coded corresponding to the input calculation formula based on the mapping relation, and dividing the character strings to be coded through a preset dividing rule to obtain M character strings;
acquiring a probability state value of each character string and a length value of a coding interval of each character string before coding, and determining a coding coefficient corresponding to the length value of the coding interval of each character string before coding according to the probability state value and the length value of the coding interval;
coding each character string based on the coding coefficient, adding the coded character strings to a preset cyclic redundancy check sequence to carry out error correction coding on each coded character string, and fusing the character strings subjected to error correction processing to obtain a target coded character string corresponding to the calculation formula;
acquiring a relevant test value used for testing the input calculation formula by a user, performing format conversion on the relevant test value, and performing training test on a target code character string corresponding to the input calculation formula after conversion;
inputting training test results into a parameter input calculation file, and calculating target calculation results by using the parameter input calculation file;
determining a verification mode based on the target calculation result, and determining attribute information of the target calculation result based on the verification mode;
generating a check code corresponding to the target calculation result based on the attribute information of the target calculation result, and comparing the target calculation result with a first preset calculation result based on the check code;
if the target calculation result is not consistent with the preset calculation result, readjusting and maintaining the input calculation formula and testing and checking again until the target calculation result is consistent with the preset calculation result;
otherwise, completing the test maintenance of the entered calculation formula.
Preferably, a method for maintaining a calculation formula in a laboratory information management system, which completes test maintenance of the entered calculation formula, further includes:
obtaining a calculation formula after maintenance;
converting the expression of the maintained calculation formula into an executable program code based on a preset calculation formula engine, and replacing the maintained calculation formula to calculate the value depended on to obtain a final operation result;
obtaining a comparison result of the final operation result and a second preset calculation result;
if the final operation result does not accord with a second preset calculation result, recording an interface based on a calculation formula, and popping up a test maintenance failure reminding interface;
and the test maintenance failure reminding interface can be closed only after the user agrees to test and maintain the calculation formula again.
Preferably, in step 5, based on the entered calculation formula, the user inputs a test value related to the calculation formula, performs a test on the calculation formula, and completes the maintenance of the calculation formula after the test is passed, further including:
obtaining a calculation formula after maintenance and a relevant test value input by a user;
based on a calculation formula after maintenance, calculating the accuracy of the calculation formula after maintenance for calculating the related test values input by a user, and calculating the maintenance degree value of the input calculation formula according to the accuracy, wherein the specific steps comprise;
and calculating the accuracy of the maintained calculation formula in calculating the related test values input by the user according to the following formula:
wherein, α represents the accuracy of the maintained calculation formula in calculating the relevant test value input by the user, and the value range is (0, 1); delta represents the number of times that the maintained calculation formula accurately calculates the relevant test value; mu represents the total times of calculating the related test values by the calculation formula after maintenance; epsilon1The first error factor is represented, and the value range is (0.00005, 0.0001); epsilon2(ii) a The second error factor is represented, and the value range is (0.00005, 0.0001); p represents the number of times of the relevant test value of the calculation formula after maintenance is calculated in error;
calculating a maintenance degree value for the entered calculation formula according to the following formula:
wherein β represents a maintenance degree value for the entered calculation formula; alpha represents the accuracy of the maintained calculation formula in calculating the relevant test value input by the user, and the value range is (0, 1); theta represents a maintenance coefficient of the input calculation formula, and the value range is (0.8, 1.25); n represents the total number of times the entered calculation formula is maintained; omega represents the accuracy of the calculation formula before maintenance on the related test values, and the value range is (0, 1); i represents the current maintenance times; alpha is alphaiThe accuracy of the calculation formula after the ith maintenance is expressed; t is tiThe time length value used for carrying out the ith maintenance on the input calculation formula is represented; t represents the time length value used by the maintained calculation formula to accurately calculate the related test value;
comparing the maintenance degree value obtained by calculation with a preset maintenance degree value;
if the maintenance degree value obtained by calculation is smaller than the preset maintenance degree value, judging that the maintenance of the calculation formula is unqualified, re-obtaining an analysis item, a repetition number data, a built-in function and an operator which are depended by the calculation formula, and performing combination test on the analysis item, the repetition number data, the built-in function and the operator again until the maintenance degree value obtained by calculation is larger than or equal to the preset maintenance degree value;
and if the maintenance degree value obtained by calculation is greater than or equal to the preset maintenance degree value, judging that the calculation formula is qualified to be maintained, and putting the calculation formula after maintenance into a laboratory information management system for use to finish the maintenance of the calculation formula.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.
The technical solution of the present invention is further described in detail by the accompanying drawings and embodiments.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is a flowchart of a method for maintaining calculation formulas in a laboratory information management system according to an embodiment of the present invention.
Detailed Description
The preferred embodiments of the present invention will be described in conjunction with the accompanying drawings, and it will be understood that they are described herein for the purpose of illustration and explanation and not limitation.
Example 1:
the embodiment provides a method for maintaining a calculation formula in a laboratory information management system, which is shown in fig. 1 and comprises the following steps:
step 1: determining a first analysis item and first repeated number data on which the calculation formula depends based on the analysis item selector or the test selector;
step 2: adding a first operator of the calculation formula based on an operator icon in a calculation formula input interface;
and step 3: matching corresponding built-in functions from a preset function library according to the requirement of a calculation formula;
and 4, step 4: determining a second analysis item and second repeated data which are depended by the calculation formula, determining a second operator and a function library according to the requirement of the calculation formula, and completing the input of the calculation formula based on the guiding operation of the input interface of the calculation formula;
and 5: and based on the input calculation formula, inputting the relevant test values to test the input calculation formula, and after the test is passed, realizing the maintenance of the input calculation formula.
In this embodiment, the analysis term refers to a term that is determined by the calculation formula for performing calculation analysis when the calculation formula is recorded, and this term is defined as an analysis term, and there are a plurality of analysis terms.
In this embodiment, the repetition number data includes the Same repetition number (Same), ALL repetition numbers (ALL), and a specified repetition number (custom), which are parameters for describing different analysis items.
In this embodiment, the first analysis item, the first repeated data, and the first operator refer to how an analysis item, repeated data, and an operator are entered.
In this embodiment, the second analysis item, the second repetition number data, and the second operator refer to other data items involved in the addition of the first calculation formula, respectively, where the second analysis item, the second repetition number data, and the second operator may be plural.
In the embodiment, the preset function library is set in advance, various operators are stored in the preset function library, convenience is provided for inputting the calculation formula, and the required function can be selected from the preset function library when the calculation formula is input.
In this embodiment, the other analysis items and the repetition number data refer to that a plurality of different analysis items may be entered when the formula is entered, so that the other analysis items and the repetition number data refer to other analysis items and repetition number data that need to be entered into the laboratory information management system in the same batch.
In this embodiment, the relevant test value is an analysis term that the user selects a corresponding test value according to the calculation formula, and is set in advance.
The beneficial effects of the above technical scheme are: by providing the maintenance function of the calculation formula, heavy formula calculation work after detection data are input by detection personnel is reduced, the accuracy of the detection data is improved, the detection efficiency is improved, and the automatic calculation is carried out according to the calculation formula after the detection data are input.
Example 2:
on the basis of the foregoing embodiment 1, the present embodiment provides a method for maintaining a calculation formula in a laboratory information management system, where in step 1, determining analysis item and repetition number data on which the calculation formula depends based on an analysis item selector or a test selector includes:
acquiring a preset calculation formula input interface in a laboratory information management system and a function library, a data source and an operator which are required to be used in the maintenance process of the calculation formula;
labeling the function library, the data source and the operator to obtain labels corresponding to the function library, the data source and the operator;
performing hyperlink processing on the labels corresponding to the function library, the data source and the operator and the data in the function library, the data source and the operator, and placing the labels corresponding to the function library, the data source and the operator after hyperlink processing on the calculation formula entry interface;
a user clicks a corresponding label in a calculation formula input interface according to an analysis item, repetition number data, an operator and a built-in function on which a calculation formula depends to enter a target database corresponding to each label, wherein the target database stores a plurality of analysis items, repetition number data, operators and built-in function data;
and selecting a first analysis item, first repeated data, a first operator and a target built-in function on which the calculation formula depends based on the target database to complete visualization and guide operation in the maintenance process of the calculation formula.
In this embodiment, the preset calculation formula maintenance interface is set in advance in the laboratory information management system, and is used for providing visualization and guidance for the user to enter the calculation formula.
In this embodiment, the tagging is to generate corresponding cases from the function library, the data source, and the operator and place the cases in a preset calculation formula maintenance interface, so that a user can click a corresponding button to enter a corresponding database as needed.
In this embodiment, the hyperlink processing is to connect the tags of the function library, the data source and the operator with the internal specific data, and the corresponding database can be directly accessed by clicking the tags.
In this embodiment, the first analysis item, the first repetition number data, the first operator, and the target built-in function refer to analysis items, repetition number data, operators, and built-in function data that are selected from the corresponding target databases and are required by a suitable calculation formula.
The beneficial effects of the above technical scheme are: according to the invention, a user does not need to manually write a calculation formula, and can directly perform click operation in the system page according to the guiding step, so that the requirement of maintenance of the calculation formula on the capability of personnel is greatly reduced, and the user can simply complete the maintenance work of the calculation formula.
Example 3:
on the basis of the foregoing embodiment 1, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, where in step 1, determining a first analysis term and first repetition number data on which the calculation formula depends includes:
receiving a target selector determined by a user based on a laboratory information management system, and logging in a calculation formula entry interface after the target selector is determined;
wherein the target selector comprises an analysis item selector and a test selector;
if the analysis item selector is determined, determining different analysis items under the same test based on the calculation formula input interface, and simultaneously determining first repeated data corresponding to the analysis items;
if the test selector is determined, inputting the test name based on the calculation formula input interface,
meanwhile, after the test name is input, selecting a test option and switching to a corresponding first analysis item;
automatically filling test analysis items in the preset selection items based on preset selection items in the first analysis items, and determining corresponding first repetition number data according to the test analysis items;
wherein the repetition number data includes the same repetition number, all repetition numbers, and a specified repetition number.
In this embodiment, the target selector refers to a selector selected by the user as needed, and the target selector is one of an analysis item selector or a test selector.
In this embodiment, the preset selection item refers to an analysis item that can be directly selected by a user, and is set in advance, so that the user can conveniently enter a corresponding calculation formula.
In this embodiment, the preset display frame is a display interface designed in advance, and is used for displaying the entry condition of the forward calculation formula.
The beneficial effects of the above technical scheme are: the scheme provides visual and guided operation for the user by determining the selector required by the user to perform formula entry, performing corresponding formula entry according to the selector selected by the user, and displaying the entered formula, so that the user does not need to manually write the calculation formula, the requirement of maintenance of the calculation formula on the personnel capacity is greatly reduced, and the user can simply complete the maintenance work of the calculation formula.
Example 4:
on the basis of the foregoing embodiment 1, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, and in step 2, adding a first operator of the calculation formula based on an operator icon in a calculation formula entry interface includes:
acquiring a first analysis item and first repetition number data which are depended by the calculation formula, and displaying the first analysis item and the first repetition number data in a preset calculation formula display frame;
selecting a preset operator option from a calculation formula entry interface based on a first analysis item and first repeated data in a display frame, and determining a first operator from a preset operator database based on the operator option;
and adding the determined first operator to the preset calculation formula display frame to finish the addition and maintenance of the calculation formula operator.
In this embodiment, the preset operator option is set in advance on a calculation formula maintenance interface preset in the laboratory information management system, and a user can directly click the preset operator option to enter an operator database and select a corresponding operator for entry.
In this embodiment, the target operator can be selected by the user or automatically selected by the system.
The beneficial effects of the above technical scheme are: by determining the analysis item and the repeated data which are depended by the calculation formula, the operator required by the current calculation formula can be conveniently and accurately determined, and the user can directly click the operator option to enter the corresponding operator, so that convenience is provided for the user to enter the calculation formula, the heavy formula calculation work after detection personnel enter the detection data is reduced, the accuracy of the detection data is improved, and the detection efficiency is improved.
Example 5:
on the basis of the foregoing embodiment 1, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, and in step 3, according to a requirement of the calculation formula, matching a corresponding built-in function from a preset function library includes:
acquiring analysis items and repeated data which are depended by the calculation formula and operators added in the calculation formula;
selecting a preset data source option from a calculation formula input interface based on the analysis item and the repetition data depended on by the calculation formula and the operator added in the calculation formula;
the preset data source is displayed in a combined mode of brackets, vertical bars and commas, and a plurality of function libraries are arranged in the preset data source;
matching a target built-in function from the plurality of function libraries based on the requirement of a calculation formula on the built-in function;
if the target built-in function is matched from the function libraries, adding the target built-in function to a preset calculation formula display frame to finish the addition of the calculation formula built-in function;
otherwise, updating the preset data source in real time based on the requirement of the user on the built-in function of the calculation formula, expanding the function libraries, and matching the target built-in function from the function libraries again until the requirement of the user on the built-in function of the calculation formula is met.
In this embodiment, the preset data source option is set in advance, and includes a plurality of function libraries therein for storing functions that may be used in the calculation formula entry process.
In this embodiment, the target built-in function refers to a function that a user selects a desired function from a plurality of functions included in a function library, and this function is defined as the target built-in function.
The beneficial effects of the above technical scheme are: the invention expresses the calculation formula, displays the data source depended by the calculation formula in the form of combination of brackets, vertical bars and commas, embeds a plurality of function libraries, can quickly expand the function libraries according to the user requirements, has popular and easy-to-understand expression of the calculation formula, and is convenient for users to understand and use.
Example 6:
on the basis of the foregoing embodiment 1, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, in step 5, based on a entered calculation formula, testing the entered calculation formula by inputting a relevant test value, and after the test is passed, implementing maintenance on the entered calculation formula, including:
acquiring a calculation formula which is recorded in a preset calculation formula display frame, and determining a target conversion parameter of the recorded calculation formula during format conversion;
determining a format table name corresponding to the input calculation formula based on the target conversion parameter, determining a format table corresponding to the format table name, and determining a mapping relation between the input calculation formula and a corresponding output target format in the format table;
determining character strings to be coded corresponding to the input calculation formula based on the mapping relation, and dividing the character strings to be coded through a preset dividing rule to obtain M character strings;
acquiring a probability state value of each character string and a length value of a coding interval of each character string before coding, and determining a coding coefficient corresponding to the length value of the coding interval of each character string before coding according to the probability state value and the length value of the coding interval;
coding each character string based on the coding coefficient, adding the coded character strings to a preset cyclic redundancy check sequence to carry out error correction coding on each coded character string, and fusing the character strings subjected to error correction processing to obtain a target coded character string corresponding to the calculation formula;
acquiring a relevant test value used for testing the input calculation formula by a user, performing format conversion on the relevant test value, and performing training test on a target code character string corresponding to the input calculation formula after conversion;
inputting training test results into a parameter input calculation file, and calculating target calculation results by using the parameter input calculation file;
determining a verification mode based on the target calculation result, and determining attribute information of the target calculation result based on the verification mode;
generating a check code corresponding to the target calculation result based on the attribute information of the target calculation result, and comparing the target calculation result with a first preset calculation result based on the check code;
if the target calculation result is not consistent with the preset calculation result, readjusting and maintaining the input calculation formula and testing and checking again until the target calculation result is consistent with the preset calculation result;
otherwise, completing the test maintenance of the entered calculation formula.
In this embodiment, the target conversion parameter refers to some parameters that are needed to perform format conversion on the calculation formula, and this parameter is defined as the target conversion parameter, for example, a binary parameter may be used during conversion.
In this embodiment, the format table name refers to a table name of a format table in which a final format is located when the calculation formula performs format conversion according to a conversion parameter of the calculation formula, where the format table includes multiple data formats.
In this embodiment, the mapping relationship refers to a corresponding relationship between the calculation formula and a plurality of formats included in the format table, and may be a calculation formula corresponding to a plurality of formats, or may be a calculation formula corresponding to only one format.
In this embodiment, the character string to be encoded refers to data corresponding to a calculation formula, and this data is defined as a code character string.
In this embodiment, the preset division rule is set in advance, and for example, the division may be performed with a node between adjacent characters 1 and 0.
In this embodiment, the probability state value refers to the probability that a string can be successfully encoded.
In this embodiment, the encoding interval length value refers to an interval length between data before encoding, and a corresponding encoding mode may be determined according to the data interval length.
In this embodiment, the encoding coefficient refers to a parameter that affects the encoding result when the calculation formula is encoded, and the calculation formula may be correspondingly encoded according to the effect of the parameter on data.
In this embodiment, the predetermined cyclic redundancy check sequence is preset, and is used to determine whether an error code exists in the encoded data, so as to check the encoded data.
In this embodiment, the target encoding character string refers to the encoded data corresponding to the calculation formula that is obtained by removing the erroneous codes in the encoded data and can be directly used for calculation and testing.
In this embodiment, the first predetermined calculation result is set in advance, and is a measurement parameter for determining whether the calculation result is qualified.
The beneficial effects of the above technical scheme are: the calculation formula engine designed by the invention converts the calculation formula expression with well maintained page into executable program codes, and replaces the value depended by calculation formula calculation to calculate so as to obtain the final operation result, the operation speed is high, the efficiency is high, the accuracy is high, in the calculation formula maintenance process, a user can check the calculation result in real time by using the correction function of the calculation formula, the calculation result is compared with the expected result, if the calculation result is not consistent with the expected result, the formula is readjusted to correct again, so that the accuracy of the calculation formula is ensured, and the calculation formula maintenance efficiency is improved.
Example 7:
on the basis of the foregoing embodiment 6, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, where the method completes test maintenance on the entered calculation formula, and further includes:
obtaining a calculation formula after maintenance;
converting the expression of the maintained calculation formula into an executable program code based on a preset calculation formula engine, and replacing the maintained calculation formula to calculate the value depended on to obtain a final operation result;
obtaining a comparison result of the final operation result and a second preset calculation result;
if the final operation result does not accord with a second preset calculation result, recording an interface based on a calculation formula, and popping up a test maintenance failure reminding interface;
and the test maintenance failure reminding interface can be closed only after the user agrees to test and maintain the calculation formula again.
In this embodiment, the second preset calculation result is set in advance, and is a maintenance standard for determining a calculation result of the dependency value after the calculation formula expression is converted by the calculation formula engine, and when the calculation result is greater than or equal to the second preset calculation result, it is determined that the maintenance is qualified, otherwise, it is not qualified.
The beneficial effects of the above technical scheme are: by comparing the test result with the preset test result, the alarm operation is carried out when the test result does not meet the requirement, so that a user can find the problems in the current calculation formula in time and make corresponding modification, and the maintenance efficiency of the calculation formula is improved.
Example 8:
on the basis of the foregoing embodiment 1, this embodiment provides a method for maintaining a calculation formula in a laboratory information management system, in step 5, based on a entered calculation formula, testing the entered calculation formula by inputting a relevant test value, and after the test is passed, implementing maintenance on the entered calculation formula, further including:
obtaining a calculation formula after maintenance and a relevant test value input by a user;
based on a calculation formula after maintenance, calculating the accuracy of the calculation formula after maintenance for calculating the related test values input by a user, and calculating the maintenance degree value of the input calculation formula according to the accuracy, wherein the specific steps comprise;
and calculating the accuracy of the maintained calculation formula in calculating the related test values input by the user according to the following formula:
wherein, α represents the accuracy of the maintained calculation formula in calculating the relevant test value input by the user, and the value range is (0, 1); delta represents the number of times that the maintained calculation formula accurately calculates the relevant test value; mu represents the total times of calculating the related test values by the calculation formula after maintenance; epsilon1The first error factor is represented, and the value range is (0.00005, 0.0001); epsilon2(ii) a The second error factor is represented, and the value range is (0.00005, 0.0001); p represents the number of times of the relevant test value of the calculation formula after maintenance is calculated in error;
calculating a maintenance degree value for the entered calculation formula according to the following formula:
wherein β represents a maintenance degree value for the entered calculation formula; alpha represents the calculation formula after maintenance to the userThe accuracy rate of the input related test values in calculation is high, and the value range is (0, 1); theta represents a maintenance coefficient of the input calculation formula, and the value range is (0.8, 1.25); n represents the total number of times the entered calculation formula is maintained; omega represents the accuracy of the calculation formula before maintenance on the related test values, and the value range is (0, 1); i represents the current maintenance times; alpha is alphaiThe accuracy of the calculation formula after the ith maintenance is expressed; t is tiThe time length value used for carrying out the ith maintenance on the input calculation formula is represented; t represents the time length value used by the maintained calculation formula to accurately calculate the related test value;
comparing the maintenance degree value obtained by calculation with a preset maintenance degree value;
if the maintenance degree value obtained by calculation is smaller than the preset maintenance degree value, judging that the maintenance of the calculation formula is unqualified, re-obtaining an analysis item, a repetition number data, a built-in function and an operator which are depended by the calculation formula, and performing combination test on the analysis item, the repetition number data, the built-in function and the operator again until the maintenance degree value obtained by calculation is larger than or equal to the preset maintenance degree value;
and if the maintenance degree value obtained by calculation is greater than or equal to the preset maintenance degree value, judging that the calculation formula is qualified to be maintained, and putting the calculation formula after maintenance into a laboratory information management system for use to finish the maintenance of the calculation formula.
In this embodiment, the first error factor refers to a parameter that affects the number of times of an accurate calculation result when the calculation formula calculates the related test value, the second error factor refers to a parameter that affects the number of times of an erroneous calculation result when the calculation formula calculates the related test value, and the number of times of an obtained calculation result can be made more objective by considering the first error factor and the second error factor in the formula.
In this embodiment, the maintenance degree value is used to represent the maintenance degree of the calculation formula, for example, the calculation accuracy of the calculation formula before maintenance on the relevant test value is 50%, the calculation accuracy of the calculation formula after maintenance on the relevant test value is 90%, which indicates that the maintenance degree of the calculation formula is 55, and when the calculation formula is maintained, the maintenance time directly affects the accuracy of the calculation formula, and the maintenance degree of the calculation formula is represented by a specific numerical value.
In this embodiment of the present invention,
the method is characterized in that after the calculation formula is maintained for many times, the average value of the accuracy rate of the calculation formula is obtained, so that the calculation result is more scientific and accurate.
In this embodiment, the maintenance coefficient refers to a type of parameter that affects the maintenance degree of the calculation formula during the maintenance process of the calculation formula.
In this embodiment of the present invention,
the time is used to represent the total time divided by the maintenance calculation formula, i.e. how much time can be used as one of the parameters for representing the influence on the maintenance degree of the calculation formula.
In this embodiment, the preset maintenance degree value is set in advance, and is a standard parameter for measuring the maintenance degree value of the calculation formula.
The beneficial effects of the above technical scheme are: and calculating the accuracy of the calculation formula after maintenance on the related test values, and calculating the maintenance degree value of the calculation formula according to the test accuracy. The method has the advantages that when the accuracy is calculated, the ratio of an actual calculated value to an ideal calculated value is related, a foundation is laid for calculating the accuracy, meanwhile, error factors and the like are related, the accuracy and reliability of the calculated result are guaranteed, the maintenance degree value is calculated, the maintenance intensity value of a laboratory information management system on the calculation formula is related, the calculation formula reaches the accuracy after maintenance, the calculation result is more accurate, the scheme guarantees effective maintenance of the calculation formula, heavy formula calculation work after detection data are input by detection personnel is reduced, the accuracy of the detection data is improved, the detection efficiency is improved, and the detection data are automatically calculated according to the calculation formula after the detection data are input.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (7)
1. A method for maintaining a calculation formula in a laboratory information management system, comprising:
step 1: determining a first analysis item and first repeated number data on which the calculation formula depends based on the analysis item selector or the test selector;
step 2: adding a first operator of the calculation formula based on an operator icon in a calculation formula input interface;
and step 3: matching corresponding built-in functions from a preset function library according to the requirement of a calculation formula;
and 4, step 4: determining a second analysis item and second repeated data which are depended by the calculation formula, determining a second operator and a function library according to the requirement of the calculation formula, and completing the input of the calculation formula based on the guiding operation of the input interface of the calculation formula;
and 5: based on the input calculation formula, inputting a relevant test value to test the input calculation formula, and after the test is passed, realizing the maintenance of the input calculation formula;
obtaining a calculation formula after maintenance and a relevant test value input by a user;
based on a calculation formula after maintenance, calculating the accuracy of the calculation formula after maintenance for calculating the related test values input by a user, and calculating the maintenance degree value of the input calculation formula according to the accuracy, wherein the specific steps comprise;
and calculating the accuracy of the maintained calculation formula in calculating the related test values input by the user according to the following formula:
wherein, α represents the accuracy of the maintained calculation formula in calculating the relevant test value input by the user, and the value range is (0, 1); delta represents the number of times that the maintained calculation formula accurately calculates the relevant test value; mu represents the total times of calculating the related test values by the calculation formula after maintenance; epsilon1The first error factor is represented, and the value range is (0.00005, 0.0001); epsilon2(ii) a The second error factor is represented, and the value range is (0.00005, 0.0001); p represents the number of times of the relevant test value of the calculation formula after maintenance is calculated in error;
calculating a maintenance degree value for the entered calculation formula according to the following formula:
wherein β represents a maintenance degree value for the entered calculation formula; alpha represents the accuracy of the maintained calculation formula in calculating the relevant test value input by the user, and the value range is (0, 1); theta represents a maintenance coefficient of the input calculation formula, and the value range is (0.8, 1.25); n represents the total number of times the entered calculation formula is maintained; omega represents the accuracy of the calculation formula before maintenance on the related test values, and the value range is (0, 1); i represents the current maintenance times; alpha is alphaiThe accuracy of the calculation formula after the ith maintenance is expressed; t is tiThe time length value used for carrying out the ith maintenance on the input calculation formula is represented; t represents the time length value used by the maintained calculation formula to accurately calculate the related test value;
comparing the maintenance degree value obtained by calculation with a preset maintenance degree value;
if the maintenance degree value obtained by calculation is smaller than the preset maintenance degree value, judging that the maintenance of the calculation formula is unqualified, re-obtaining an analysis item, a repetition number data, a built-in function and an operator which are depended by the calculation formula, and performing combination test on the analysis item, the repetition number data, the built-in function and the operator again until the maintenance degree value obtained by calculation is larger than or equal to the preset maintenance degree value;
and if the maintenance degree value obtained by calculation is greater than or equal to the preset maintenance degree value, judging that the calculation formula is qualified to be maintained, and putting the calculation formula after maintenance into a laboratory information management system for use to finish the maintenance of the calculation formula.
2. The method for maintaining calculation formulas in laboratory information management system according to claim 1, characterized by, after performing step 1 and before performing step 2, further comprising:
acquiring a calculation formula input interface in a laboratory information management system and a function library, a data source and an operator which are required to be used in the maintenance process of the calculation formula;
labeling the function library, the data source and the operator to obtain labels corresponding to the function library, the data source and the operator;
performing hyperlink processing on the labels corresponding to the function library, the data source and the operator and the data in the function library, the data source and the operator, and placing the labels corresponding to the function library, the data source and the operator after hyperlink processing on the calculation formula entry interface;
a user clicks a corresponding label in a calculation formula input interface according to an analysis item, repetition number data, an operator and a built-in function on which a calculation formula depends to enter a target database corresponding to each label, wherein the target database stores a plurality of analysis items, repetition number data, operators and built-in function data;
and selecting a first analysis item, first repeated data, a first operator and a built-in function on which the calculation formula depends based on the target database to complete visualization and guide operation in the maintenance process of the calculation formula.
3. The method of claim 1, wherein the step 1 of determining the first analysis term and the first repetition number data on which the calculation formula depends comprises:
receiving a target selector determined by a user based on a laboratory information management system, and logging in a calculation formula entry interface after the target selector is determined;
wherein the target selector comprises an analysis item selector and a test selector;
if the analysis item selector is determined, determining different analysis items under the same test based on the calculation formula input interface, and simultaneously determining first repeated data corresponding to the analysis items;
if the test selector is determined, inputting the test name based on the calculation formula input interface,
meanwhile, after the test name is input, selecting a test option and switching to a corresponding first analysis item;
automatically filling test analysis items in the preset selection items based on preset selection items in the first analysis items, and determining corresponding first repetition number data according to the test analysis items;
wherein the repetition number data includes the same repetition number, all repetition numbers, and a specified repetition number.
4. The method for maintaining the calculation formula in the laboratory information management system according to the claim 1, wherein in the step 2, based on the operator icon in the calculation formula entry interface, adding the first operator of the calculation formula comprises:
acquiring a first analysis item and first repetition number data which are depended by the calculation formula, and displaying the first analysis item and the first repetition number data in a preset calculation formula display frame;
selecting an operator option from a calculation formula entry interface based on a first analysis item and first repeated data in a display frame, and determining a first operator from a preset operator database based on the operator option;
and adding the determined first operator to the preset calculation formula display frame to finish the addition and maintenance of the calculation formula operator.
5. The method according to claim 1, wherein the step 3 of matching the corresponding built-in function from the preset function library according to the requirement of the calculation formula comprises:
acquiring analysis items and repeated data which are depended by the calculation formula and operators added in the calculation formula;
selecting a preset data source option from a calculation formula input interface based on the analysis item and the repetition data depended on by the calculation formula and the operator added in the calculation formula;
the preset data source is displayed in a combined mode of brackets, vertical bars and commas, and a plurality of function libraries are arranged in the preset data source;
matching a target built-in function from the plurality of function libraries based on the requirement of a calculation formula on the built-in function;
if the target built-in function is matched from the function libraries, adding the target built-in function to a preset calculation formula display frame to finish the addition of the calculation formula built-in function;
otherwise, updating the preset data source in real time based on the requirement of the user on the built-in function of the calculation formula, expanding the function libraries, and matching the target built-in function from the function libraries again until the requirement of the user on the built-in function of the calculation formula is met.
6. The method for maintaining the calculation formula in the laboratory information management system according to claim 1, wherein in step 5, the entered calculation formula is tested by inputting relevant test values based on the entered calculation formula, and after the test is passed, the entered calculation formula is maintained, including:
acquiring a calculation formula which is recorded in a preset calculation formula display frame, and determining a target conversion parameter of the recorded calculation formula during format conversion;
determining a format table name corresponding to the input calculation formula based on the target conversion parameter, determining a format table corresponding to the format table name, and determining a mapping relation between the input calculation formula and a corresponding output target format in the format table;
determining character strings to be coded corresponding to the input calculation formula based on the mapping relation, and dividing the character strings to be coded through a preset dividing rule to obtain M character strings;
acquiring a probability state value of each character string and a length value of a coding interval of each character string before coding, and determining a coding coefficient corresponding to the length value of the coding interval of each character string before coding according to the probability state value and the length value of the coding interval;
coding each character string based on the coding coefficient, adding the coded character strings to a preset cyclic redundancy check sequence to carry out error correction coding on each coded character string, and fusing the character strings subjected to error correction processing to obtain a target coded character string corresponding to the calculation formula;
acquiring a relevant test value used for testing the input calculation formula by a user, performing format conversion on the relevant test value, and performing training test on a target code character string corresponding to the input calculation formula after conversion;
inputting training test results into a parameter input calculation file, and calculating target calculation results by using the parameter input calculation file;
determining a verification mode based on the target calculation result, and determining attribute information of the target calculation result based on the verification mode;
generating a check code corresponding to the target calculation result based on the attribute information of the target calculation result, and comparing the target calculation result with a first preset calculation result based on the check code;
if the target calculation result is not consistent with the preset calculation result, readjusting and maintaining the input calculation formula and testing and checking again until the target calculation result is consistent with the preset calculation result;
otherwise, completing the test maintenance of the entered calculation formula.
7. The method for maintaining a calculation formula in a laboratory information management system according to claim 6, wherein completing the test maintenance of the entered calculation formula further comprises:
obtaining a calculation formula after maintenance;
converting the expression of the maintained calculation formula into an executable program code based on a preset calculation formula engine, and replacing the maintained calculation formula to calculate the value depended on to obtain a final operation result;
obtaining a comparison result of the final operation result and a second preset calculation result;
if the final operation result does not accord with a second preset calculation result, recording an interface based on a calculation formula, and popping up a test maintenance failure reminding interface;
and the test maintenance failure reminding interface can be closed only after the user agrees to test and maintain the calculation formula again.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110523865.6A CN113159630B (en) | 2021-05-13 | 2021-05-13 | Method for maintaining calculation formula in laboratory information management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110523865.6A CN113159630B (en) | 2021-05-13 | 2021-05-13 | Method for maintaining calculation formula in laboratory information management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113159630A CN113159630A (en) | 2021-07-23 |
| CN113159630B true CN113159630B (en) | 2021-11-23 |
Family
ID=76874915
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110523865.6A Active CN113159630B (en) | 2021-05-13 | 2021-05-13 | Method for maintaining calculation formula in laboratory information management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113159630B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115376144B (en) * | 2022-07-07 | 2023-04-07 | 北京三维天地科技股份有限公司 | Special character input method and system |
| CN115935698A (en) * | 2022-12-30 | 2023-04-07 | 南京维拓科技股份有限公司 | Calculation method for design parameters in industrial design process |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810152A (en) * | 2013-11-11 | 2014-05-21 | 远光软件股份有限公司 | Visualized formula editor |
| CN106020818A (en) * | 2016-05-16 | 2016-10-12 | 珠海格力电器股份有限公司 | Computing logic generation method and apparatus |
| CN109145254A (en) * | 2018-08-10 | 2019-01-04 | 深圳市智物联网络有限公司 | A kind of calculation method and calculating equipment of accuracy rate |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP6252106B2 (en) * | 2013-10-31 | 2017-12-27 | 日本電産リード株式会社 | Contact maintenance method and inspection device |
| CN109471540A (en) * | 2018-10-29 | 2019-03-15 | 北京轩宇信息技术有限公司 | A kind of formula typing analysis method and device based on browser |
| CN112328951B (en) * | 2020-03-17 | 2021-07-20 | 北京三维天地科技股份有限公司 | Processing method of experimental data of analysis sample |
| CN111708788A (en) * | 2020-05-08 | 2020-09-25 | 深圳市金蝶天燕云计算股份有限公司 | Method for calculating business document data and related equipment |
| CN111966431A (en) * | 2020-06-24 | 2020-11-20 | 浙江中控技术股份有限公司 | Calculation formula self-defining method applied to laboratory management system |
-
2021
- 2021-05-13 CN CN202110523865.6A patent/CN113159630B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810152A (en) * | 2013-11-11 | 2014-05-21 | 远光软件股份有限公司 | Visualized formula editor |
| CN106020818A (en) * | 2016-05-16 | 2016-10-12 | 珠海格力电器股份有限公司 | Computing logic generation method and apparatus |
| CN109145254A (en) * | 2018-08-10 | 2019-01-04 | 深圳市智物联网络有限公司 | A kind of calculation method and calculating equipment of accuracy rate |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113159630A (en) | 2021-07-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113159630B (en) | Method for maintaining calculation formula in laboratory information management system | |
| EP2960799A1 (en) | Defect localization in software integration tests | |
| JPH08241193A (en) | Method for analysis of code segment | |
| CN111027294A (en) | Table summarizing method, device and system | |
| Gelman et al. | Package ‘arm’ | |
| CN114022005A (en) | BIM technology-based engineering cost management system and method | |
| CN111522741A (en) | Interface test code generation method and device, electronic equipment and readable storage medium | |
| Nagwani et al. | Predicting expert developers for newly reported bugs using frequent terms similarities of bug attributes | |
| CN108733712A (en) | A kind of question answering system evaluation method and device | |
| CN113591093A (en) | Industrial software vulnerability detection method based on self-attention mechanism | |
| CN114490404A (en) | Test case determination method and device, electronic equipment and storage medium | |
| CN111782538A (en) | Equipment testability demonstration analysis and simulation evaluation system | |
| CN114610608A (en) | Test case processing method and device, electronic equipment and storage medium | |
| CN113177644A (en) | Automatic modeling system based on word embedding and depth time sequence model | |
| CN116467219A (en) | Test processing method and device | |
| CN115587333A (en) | Failure analysis fault point prediction method and system based on multi-classification model | |
| US20160027123A1 (en) | Automatic tagging of trial balance | |
| CN115562979A (en) | Method for automatically generating test report based on artificial intelligence | |
| CN112925874B (en) | Similar code searching method and system based on case marks | |
| CN112328951B (en) | Processing method of experimental data of analysis sample | |
| CN113505283A (en) | Test data screening method and system | |
| CN110569199B (en) | Automatic bill testing method and device | |
| CN115810137B (en) | Construction method of interactive artificial intelligence technical evaluation scheme | |
| CN115359841A (en) | Quality inspection method and device for DNA detection kit | |
| CN116089396A (en) | Simulation test data management method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |