Method and medium for automatically allocating reporting tasks to multi-responsible personnel based on LIMS system

Abstract

A method and medium for automatically assigning report tasks to multi-responsibility personnel based on a LIMS system, the method comprising: obtaining experimental project information, generating a plurality of reports to be assigned, each report having a single or multiple experimental projects, and each experimental project representing a task; classifying and sorting the plurality of reports to be assigned, generating a task priority list, wherein reports having a single experimental project and reports having multiple experimental projects are respectively classified into two categories in the task priority list; obtaining personnel responsibility information and task volume information, generating a personnel priority list, the personnel priority list including employee name, primary responsibility, secondary responsibility, current task volume and corresponding parameter values; matching personnel for each report in the task priority list according to a predetermined matching rule based on the personnel priority list. The present invention can automatically assign report tasks to multi-responsibility personnel, and improve the efficiency and accuracy of laboratory report task assignment.

Description

Technical Field

[0001] The invention relates to data processing technology, and in particular to a method for automatically allocating tasks to multi-responsible personnel based on a LIMS system. Background Art

[0002] In the existing LIMS system (Laboratory Information Management System), a single sample commission can be filled with multiple sets of experimental project requirements. After submission, the system will split it into several test report templates based on the experimental project and wait for the allocation of experimental personnel.

[0003] The existing LIMS system lacks the function of assigning reporting tasks to multi-responsible personnel. The assignment of reporting tasks can only rely on manual operations, which is not only inefficient but also prone to assignment errors, affecting the accuracy and efficiency of laboratory work. Summary of the invention

[0004] The technical problem to be solved by the present invention is to provide a method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system, which can automatically assign reporting tasks to multi-responsible personnel, improve the efficiency and accuracy of laboratory report task allocation, and ensure the orderly progress of laboratory work.

[0005] According to a first aspect of the present invention, a method for automatically assigning reporting tasks to multi-responsible personnel based on a LIMS system is provided, comprising the following steps:

[0006] Obtain experimental project information and generate several reports to be assigned, each report has a single or multiple experimental projects, and each experimental project represents a task;

[0007] Classify and sort several reports to be assigned to generate a task priority list, where reports with a single experimental project and reports with multiple experimental projects are classified into two categories in the task priority list, and each category is sorted according to the planned completion time of the report;

[0008] Obtaining personnel responsibility information and task volume information, and generating a personnel priority list, wherein the personnel priority list includes employee name, primary responsibility, secondary responsibility, current task volume, and corresponding parameter values;

[0009] Based on the personnel priority list, personnel are matched for each report in the task priority list according to a predetermined matching rule.

[0010] According to a second aspect of the present invention, there is provided a computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, the steps of the aforementioned method are implemented.

[0011] The present invention has at least the following advantages and features:

[0012] 1. The embodiment of the present invention automatically allocates tasks according to factors such as the priority of personnel responsibilities, workload, and report completion date, thereby improving the efficiency of laboratory report task allocation;

[0013] 2. The embodiment of the present invention can select urgent and time-consuming experimental tasks multiple times through the configuration of the priority list, and match them with experimental personnel with more suitable professionalism and task volume. The matching strategy achieves a balance between task efficiency and personnel professionalism, and ensures the accuracy of report task allocation. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] Figure 1 The flowchart of the method for automatically allocating reporting tasks to multi-responsible personnel based on the LIMS system according to the first embodiment of the present invention is shown.

[0015] Figure 2 The flowchart of generating a task priority list, creating a personnel priority list, and matching personnel for each report of the task priority list based on the personnel priority list according to the second embodiment of the present invention is shown.

[0016] Figure 3 The figure shows the field design included in the task priority list according to the second embodiment of the present invention.

[0017] Figure 4 The diagram shows the nested block structure within the task priority list and the personnel priority list according to the second embodiment of the present invention.

[0018] Figure 5 The figure shows the field design included in the personnel responsibility table and the personnel priority list according to the second embodiment of the present invention.

[0019] Figure 6 Two types of operation modules preset in the list template according to the second embodiment of the present invention are shown.

[0020] Figure 7 The figure shows a personnel responsibility table given by a user in a specific application example according to the present invention.

[0021] Figure 8 The figure shows a report to be distributed created according to a specific application example of the present invention.

[0022] Fig. 9 The figure shows a task priority list generated according to a specific application example of the present invention.

[0023] Fig.10 The figure shows a personnel priority list generated according to a specific application example of the present invention.

[0024] Fig.11 The figure shows the matching progress of the task priority list according to a specific application example of the present invention.

[0025] Fig.12 The figure shows an adjusted personnel priority list according to a specific application example of the present invention. DETAILED DESCRIPTION

[0026] See also Figure 1 According to an embodiment of the present invention, a method for automatically assigning reporting tasks to multi-responsible personnel based on a LIMS system comprises the following steps:

[0027] Acquire experimental project information and generate several reports to be assigned, each report having one or more experimental projects, each experimental project representing a task; the aforementioned experimental project information includes the experimental project name and the planned completion time of the experimental project; the aforementioned "several" means one or more;

[0028] Classifying and sorting the plurality of reports to be assigned to generate a task priority list, wherein reports with a single experimental project and reports with multiple experimental projects are respectively classified into two categories in the task priority list, and each category is sorted according to the order of the planned completion time of the reports;

[0029] Obtain personnel responsibility information and task volume information, and generate a personnel priority list, which includes employee name, primary responsibility, secondary responsibility, current task volume, and corresponding parameter values;

[0030] Based on the personnel priority list, personnel are matched for each report in the task priority list according to a predetermined matching rule.

[0031] Furthermore, after the matching is completed, if the experimental project in any report is not matched successfully, the above steps are repeated (from obtaining the experimental project information, generating the report to be assigned to matching personnel for each report in the task priority list) until all experimental projects in all reports are matched successfully.

[0032] In this embodiment, the above-mentioned predetermined matching rule is:

[0033] For a report with only a single experimental project, select the personnel whose main duties match the experimental project in the personnel priority list to match the report. If the main duties of multiple personnel match the experimental project, select the personnel with the highest ranking according to the current ranking of the employee names in the personnel priority list. For example, if the main duties of two personnel match the experimental project of the report, and one of the personnel's name is in the first row of the personnel priority list, and the other's name is in the second row of the personnel priority list, then the personnel in the first row will be matched to the report.

[0034] For reports with multiple experimental projects, select the person whose main and secondary responsibilities overlap most with multiple experimental projects in the personnel priority list to match the report. If there are multiple people with the most overlap, select the person with the highest ranking according to the current ranking of the employee names in the personnel priority list. For example, if a report has 3 experimental projects, one of the people has one main responsibility and two secondary responsibilities, and the three responsibilities match the three experimental projects respectively, so the overlap is 3. Another person also has one main responsibility and two secondary responsibilities, but only two of the secondary responsibilities match two of the experimental projects respectively, so the overlap is 2. Therefore, the person with an overlap of 3 is selected to match the report.

[0035] The aforementioned report to be assigned is generated based on the existing functions of the LIMS system. After the user fills in the experimental project information in the form, the LIMS system will automatically generate the report to be assigned. The experimental project information in the assigned report can be extracted in subsequent operations, and then several reports can be classified and sorted.

[0036] Figure 2 The flowchart of generating a task priority list, creating a personnel priority list, and matching personnel for each report of the task priority list based on the personnel priority list according to the second embodiment of the present invention is shown.

[0037] Please refer to Figure 4 . In the second embodiment, the task priority list is divided into a single-project block (block 1) and a multi-project block (block 2), and the single-project block and the multi-project block are respectively provided with an inner block. When matching, the report of the single-project block is matched first, and the matching of the report of the multi-project block is performed after the matching of the single-project block is completed; when matching the reports of each project block, the reports in the inner block are matched first, and the reports outside the inner block are matched after the matching of the inner block is completed. If the matching process is interrupted, the task priority list is refreshed and the remaining matches are performed. In addition, the task priority list contains a "remaining number of matches" field that is used to determine whether the currently executed task is moved into the single-project block range for execution. The task selector based on the experimental project and the personnel selector based on the experimental personnel serve as the execution focus for looping or sorting their respective lists; such as Figure 6 As shown, the priority list has a classification module and a sorting module. Classification and sorting are achieved by the matching program adding content under specific fields of the list according to the experimental project information and the running process information, and then identifying the list items to which the content of each identical field belongs.

[0038] Since generating reports to be assigned is an existing function of the LIMS system, this step of the second embodiment is exactly the same as that of the first embodiment and will not be repeated here. The second embodiment generates a task priority list, creates a personnel priority list, and automatically selects matching personnel for each report in the task priority list based on the personnel priority list, including the following steps:

[0039] Step S101, import the associated field data (field data related to screening matching, such as report number, experimental project name, planned completion time of the experimental project, etc.) in the report to be assigned into the task priority list according to the original sorting;

[0040] Step S102: Call the classification module in the task priority list to traverse all the data in the task priority list and perform the following conditional judgment:

[0041] (1) When the maximum value of the experimental item number of a data item (one data item represents one report) is 1, it is moved to the end of the single item block;

[0042] (2) The unsatisfied data items are placed at the end of the multi-item block;

[0043] Step S103, calling the classification module to traverse the single project block and the multi-project block in the task priority list, and performing the following conditional judgment: the reports in the single project block whose planned completion date is consistent with the system date are moved into the inner block of the single project block, and the remaining reports are placed outside the inner block of the single project block, and are sorted according to the order of the planned completion dates of the reports; the reports in the multi-project block whose planned completion date is consistent with the system date are moved into the inner block of the multi-project block, and the remaining reports are placed outside the inner block of the multi-project block, and are sorted according to the order of the planned completion dates of the reports;

[0044] Step S104: Receive field data of the personnel responsibility table and create a personnel priority list; the personnel responsibility table is pre-given by the user, and the fields contained in the personnel responsibility table and the personnel priority list are as follows: Figure 5 In this embodiment, the personnel priority list is divided into three blocks and includes a "current task volume" field, which is used to determine the block number to which the content indicated by the personnel selector will be sorted; the above three blocks are respectively a no-task block, a few-task block and a multi-task block, as shown in FIG. Figure 4 As shown;

[0045] Step S105, traverse the data of all blocks in the task priority list, and perform matching operations on all data in the personnel priority list in turn. First, traverse each report in the single project block of the task priority list, and for each report in the task priority list, traverse the personnel priority list, and match the report with the first person whose main responsibility and experimental project are consistent with the person encountered during the traversal process; then traverse each report in the multi-project block of the task priority list, and for each report in the task priority list, traverse the personnel priority list, and match the report with the first person whose main responsibility and secondary responsibility overlap most with multiple experimental projects encountered during the traversal process. The following is the specific matching process of a single data item in the task priority list to the personnel priority list, and the matching process of all single task priority list data items is the same:

[0046] (1) If the data item to be matched comes from a single project block, indicating that there is only one experimental project field data in the data item, then all data in the personnel priority list are traversed until the data is consistent with the personnel main responsibility field data. At this point, the current employee name field data is returned and the value of its task amount field is increased by 1, and this matching cycle ends;

[0047] (2) If the data item to be matched comes from a multi-project block, indicating that there are more than one experimental project-related field data in the data item, then all data in the personnel priority list are traversed and the consistency of all experimental project field data of the data item with all primary and secondary position field data of the personnel is compared. The number of matching consistency is recorded as a value in the matching degree field of the personnel data item. After the traversal is completed, the traversal operation is performed again until the first data item with the largest matching degree field value (the largest number of matching consistency means the largest overlap), returns its employee name field data and increases the value of its current task volume field according to the number of consistent experimental project times, and this matching cycle ends;

[0048] Step S106: traverse the personnel priority list according to the current task volume field to refresh the sorting status of the table data:

[0049] (1) If the value of the current task amount field is 0, the data item is moved to the no-task block;

[0050] (2) If the current task amount field value is less than or equal to 3, it is placed in the less-task block;

[0051] (3) Data items that do not meet the above conditions are placed in the multi-task block.

[0052] If there are multiple personnel in the no-task block, few-task block, and many-task block, they will be sorted in order from the smallest to the largest value in the current task volume field;

[0053] Step S107, continue the matching cycle of the next report item until all the to-be-matched data items in the task priority list are matched.

[0054] The second embodiment of the present invention constructs a list-block structure, the construction principle of which is to define several sub-lists belonging to a unified list class, and the head and tail of the sub-lists are linked to each other according to a preset serial number, so that the sorting module can only operate the data in the sub-list, and the data operation between blocks needs to rely on the classification module. The behavioral characteristics defined by the sub-list are packaged as blocks, and the data sorting function of the list is realized through the collection of blocks. The list-block structure serves the influencing factors of content matching between lists, establishes a subordinate relationship between factors, distinguishes the execution priority of each factor, and realizes the sorting of list content based on multiple factors in a single execution process, reducing the time complexity of code execution.

[0055] Below we apply the above solution steps in a specific scenario to further explain the solution.

[0056] The scenario is as follows: Assume that the laboratory has three experimenters: Sun Ling, Wu Jun and Zhou Qi. Each experimenter is responsible for a main responsibility project and has learned one or two secondary responsibilities. There are three experimental tasks waiting to be assigned to experimenters. The Laboratory Information Management System (LIMS) is based on Figure 7 The personnel responsibility table shown lists the specific information of the experimental personnel and work tasks to intelligently allocate reporting tasks.

[0057] According to the content selected by the user on the computer interface, the LIMS system will automatically generate the following Figure 8 Afterwards, the relevant field information of the report to be assigned is imported into the task priority list, and is classified and sorted according to the number of experimental projects and the planned completion time. The generated task priority list is as follows: Fig. 9 Import the personnel responsibility information into the personnel priority list, and the generated personnel priority list is as follows: Fig.10 shown.

[0058] Next, the matching work is officially carried out. The contents of the task priority list are extracted in order and the personnel priority list is traversed for matching. The matching process is as follows:

[0059] (1) For the report L-4 in the first row, since it only contains a single experimental project, only personnel within the scope of primary responsibility are selected. Here, the personnel Wu Jun is selected and the remaining matching quantity value of the corresponding data item in the task priority list is deducted;

[0060] (2) For report L-2, select person Zhou Qi for the same reason and deduct a remaining matching quantity value;

[0061] (3) For report L-3, which contains multiple experimental projects, the responsibilities of Wu Jun are the most matched with it. Here, he is selected and the three remaining matching quantity values ​​are deducted;

[0062] (4) For reports L-1 and L-5, the two people with the highest project matching degree, Sun Ling and Zhou Qi, were selected for the same reason and their two remaining matching quantity values ​​were deducted respectively;

[0063] The first round of matching is now over. Fig.11 Displays the current matching progress.

[0064] After this round of matching is over, the order in the personnel priority list is adjusted according to the current order. If there are tasks with the same amount, they will be sorted according to the original order. The adjusted personnel priority list is as follows: Fig.12 Next, repeat the above matching behavior until the remaining matching quantity field values ​​in the task priority list are all 0, which means that this matching task is completed.

Claims

1. A method for automatically assigning reporting tasks to multi-responsible personnel based on a LIMS system, characterized in that: The following steps are involved: Obtain experimental project information and generate several reports to be assigned, each report has a single or multiple experimental projects, and each experimental project represents a task; Classifying and sorting the plurality of reports to be assigned to generate a task priority list, wherein reports with a single experimental project and reports with multiple experimental projects are respectively classified into two categories in the task priority list, and each category is sorted according to the order of the planned completion time of the reports; Obtaining personnel responsibility information and task volume information, and generating a personnel priority list, wherein the personnel priority list includes employee name, primary responsibility, secondary responsibility, current task volume, and corresponding parameter values; Based on the personnel priority list, personnel are matched for each report in the task priority list according to a predetermined matching rule.

2. The method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 1, characterized in that: The predetermined matching rule is: For a report with only a single experimental project, select a person whose main duties match the experimental project in the personnel priority list to match the report. If there are multiple people whose main duties match the experimental project, select the person with the highest ranking according to the current ranking of the employee names in the personnel priority list. For reports with multiple experimental projects, the person whose main and secondary responsibilities have the most overlap with multiple experimental projects is selected from the personnel priority list to match the report. If there are multiple people with the most overlap, the person with the highest ranking is selected according to the current ranking of the employee names in the personnel priority list.

3. The method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 1, characterized in that: The task priority list includes a single-project block and a multi-project block, and the single-project block and the multi-project block are respectively provided with inner blocks; The classification includes: moving reports with a single experimental project into a single-project block, and moving reports with multiple experimental projects into a multiple-project block; The sorting includes: moving the reports whose planned completion date is consistent with the system date in the single project block into the inner block of the single project block, placing the remaining reports outside the inner block of the single project block, and sorting them according to the order of the planned completion dates of the reports; moving the reports whose planned completion date is consistent with the system date in the multi-project block into the inner block of the multi-project block, placing the remaining reports outside the inner block of the multi-project block, and sorting them according to the order of the planned completion dates of the reports.

4. The method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 3, characterized in that: When matching, the report of the single project block is matched first, and then the report of the multi-project block is matched after the matching of the single project block is completed; When matching the reports of each project block, the reports in the inner block are matched first, and after the matching of the inner block is completed, the reports outside the inner block are matched.

5. The method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 1, characterized in that: The following steps are also included: After the matching is completed, the value of the current task volume in the personnel priority list is refreshed, and the personnel in the personnel priority list are reordered in the order of the current task volume value from small to large.

6. The method for automatically allocating reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 1 or 5, characterized in that: The personnel priority list includes no-task blocks, few-task blocks and many-task blocks. Personnel whose current task volume value is 0 are placed in the no-task block, personnel whose current task volume value is greater than 0 and less than or equal to 3 are placed in the few-task block, and personnel whose current task volume value is greater than 3 are placed in the many-task block. If there are multiple personnel in the no-task block, few-task block and many-task block, they are sorted in order from small to large according to their current task volume values.

7. The method for automatically assigning reporting tasks to multi-responsible personnel based on the LIMS system as claimed in claim 1, characterized in that: After the matching is completed, if there is a situation where the experimental items in any report are not matched successfully, the above steps are repeated until all the experimental items in all reports are matched successfully.

8. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images