CN117195846B - Expert table management method, system, storage medium and equipment - Google Patents
Expert table management method, system, storage medium and equipment Download PDFInfo
- Publication number
- CN117195846B CN117195846B CN202311465350.0A CN202311465350A CN117195846B CN 117195846 B CN117195846 B CN 117195846B CN 202311465350 A CN202311465350 A CN 202311465350A CN 117195846 B CN117195846 B CN 117195846B
- Authority
- CN
- China
- Prior art keywords
- expert
- sub
- filled
- tables
- names
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 34
- 238000013507 mapping Methods 0.000 claims abstract description 22
- 238000000034 method Methods 0.000 claims abstract description 9
- 238000004590 computer program Methods 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000003062 neural network model Methods 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000003491 array Methods 0.000 description 2
- 239000000463 material Substances 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012552 review Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The invention provides a management method, a management system, a storage medium and a management device for expert tables, wherein the method comprises the steps of obtaining an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled; splitting the expert table to be filled into a plurality of expert sub-tables to be filled according to the expert names of the changed areas in the expert table to be filled; after printing, filling in by an expert, and finally scanning to obtain expert sub-tables of all electronic versions, identifying the name of the expert, and determining the belongings of the expert sub-tables; corresponding each expert sub-table with the expert sub-table to be filled, and establishing a mapping relation between the cells where the dividing items are located; carrying out image recognition on the cells where the dividing items are positioned, and judging whether the cells have contents or not; if yes, carrying out identification operation, and inputting an identification result into the expert sub-table to be filled to obtain a target expert sub-table; and combining all the target expert sub-tables to obtain the target expert table, so that most of manual operation can be effectively saved, and meanwhile, the reworking problem caused by errors is reduced.
Description
Technical Field
The invention belongs to the technical field of expert table management, and particularly relates to an expert table management method, an expert table management system, a storage medium and equipment.
Background
In terms of prize assessment, the scoring is usually performed by an expert, and the score is determined by the prize-winning ranking of the individual or group.
In general, a unified scoring table needs to be manufactured in advance, paper versions are printed out before reporting and answering begin, and the paper versions are provided for each expert, wherein the scoring table at least comprises units, personnel, project names, scoring items and the like except for inconsistent expert names, after reporting of participants is finished, the expert gives corresponding scores according to reporting conditions and self experience, and finally, the scores are summarized and ranked by the special personnel.
It can be appreciated that the whole operation is basically completed by manpower, and a large number of personnel, such as personnel for score entry and verification check, need to be called, so that the operation is complex, errors are easy to occur, and the working efficiency is affected.
Disclosure of Invention
Based on the above, the embodiments of the present invention provide a method, a system, a storage medium and a device for managing an expert table, so as to solve the problems that the management of the expert table is mainly performed manually, and the expert table is complex in work, easy to make mistakes, and affects the working efficiency.
A first aspect of an embodiment of the present invention provides an expert table management method, including:
acquiring an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled, wherein the fixed area at least comprises project basic conditions which are arranged in sequence, and the variable area at least comprises the names of all the experts to be reviewed;
splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled;
printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the attribute of each expert sub-table of the electronic version;
according to the belongings of the expert sub-tables of each electronic version, each expert sub-table corresponds to the expert sub-table to be filled, and a mapping relation is established for the cells where the dividing items are located;
carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table, and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not;
if yes, marking the cell, identifying the content in the cell, and inputting the identification result into the expert sub-table to be filled to obtain a target expert sub-table;
and combining the target expert sub-tables to obtain the target expert table.
Further, the step of splitting the expert table to be filled into corresponding expert sub-tables to be filled with only specific expert names according to the expert names of the changed regions in the expert table to be filled comprises:
acquiring the column number of each written expert name and the total column number with the expert name;
establishing a blank table with corresponding quantity according to the total column number;
and combining the fixed areas in the expert tables to be filled with the expert names in sequence, and filling the expert names into each blank table to form expert sub-tables to be filled with specific expert names.
Further, the step of combining the fixed area in the expert table to be filled with the expert names sequentially and filling the fixed area into each blank table to form the expert sub-table to be filled with only specific expert names includes:
acquiring a column number of a last column in a fixed area in the expert table to be filled, and determining a target column number of an adjacent column of the column number of the last column in the fixed area in the expert table to be filled according to the column number of the last column in the fixed area in the expert table to be filled and a column number arrangement rule;
extracting each column number written with the expert name and the corresponding expert name, sequentially replacing each column number written with the expert name with the target column number, and sequentially binding the target column number with the corresponding expert name to obtain a binding result;
and combining the fixed area in the expert table to be filled with each binding result, and filling the fixed area into each blank table to form expert sub-tables to be filled with specific expert names.
Further, the step of printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the belonging step of each expert sub-table of the electronic version includes:
acquiring expert sub-tables of all electronic versions, and establishing a cell coordinate system by taking a preset angle of the expert sub-tables as an origin;
according to the cell coordinate system, acquiring the coordinates of each cell in the expert sub-table of each electronic version, and determining the first coordinate where the expert name is located;
and identifying the expert names in the cells corresponding to the first coordinates, and determining the belongings of the expert sub-tables of the electronic versions.
Further, the step of mapping the expert sub-tables to the to-be-filled expert sub-tables and the cells where the dividing items are located according to the belonging of the expert sub-tables of each electronic version includes:
determining row and column numbers of a first cell where a marking item is located in an expert sub-table to be filled;
determining a second coordinate of a second cell where the scoring item is located in the expert sub-table of each electronic version according to the cell coordinate system;
and establishing a mapping relation between the second coordinate and the rank number.
Further, the step of identifying the image in the cell where the dividing item is located in each expert sub-table and judging whether the content exists in the cell where the dividing item is located in each expert sub-table includes:
identifying the boundary of a cell where a dividing item is located in an expert sub-table, acquiring the color of a pixel point in the boundary, and judging whether a non-white pixel point exists in the boundary;
if yes, acquiring the total number of pixels in the boundary and the number of non-white pixels, and calculating the proportion of the number of the non-white pixels to the total number of the pixels in the boundary;
judging whether the proportion of the number of non-white pixels to the total number of pixels in the boundary is larger than a threshold value or not;
if yes, judging that the cell in which the scoring item is positioned in the expert sub-table has content.
Further, the step of combining the target expert tables to obtain the target expert table includes:
respectively determining a fixed area and a variable area in each target expert sub-table, and numbering the variable areas in each target expert sub-table in sequence;
and sequentially attaching the variable regions in each target expert table to the fixed regions according to the numbering sequence to obtain the target expert table.
A second aspect of an embodiment of the present invention provides an expert table management system, the system including:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled, wherein the fixed area at least comprises project basic conditions which are arranged in sequence, and the variable area at least comprises the names of all the experts to be reviewed;
the splitting module is used for splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled;
the first recognition module is used for printing all the expert sub-tables to be filled, scanning to obtain all the expert sub-tables of the electronic versions after the expert is filled, recognizing the expert names in all the expert sub-tables of the electronic versions, and determining the belongings of the expert sub-tables of the electronic versions;
the mapping relation establishing module is used for corresponding each expert sub-table with the expert sub-table to be filled according to the belonging of the expert sub-tables of each electronic version, and establishing a mapping relation of the cells where the dividing items are located;
the judging module is used for carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not;
the second recognition module is used for marking the cell when judging that the cell in which the dividing item is positioned in the expert sub-table has content, recognizing the content in the cell, and inputting the recognition result into the expert sub-table to be filled to obtain a target expert sub-table;
and the combination module is used for combining the target expert sub-tables to obtain the target expert table.
A third aspect of an embodiment of the present invention provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the expert table management method provided in the first aspect.
A fourth aspect of an embodiment of the present invention provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the expert table management method provided in the first aspect when executing the program.
The expert table management method, the expert table management system, the storage medium and the expert table management equipment provided by the embodiment of the invention have the following beneficial effects:
the method comprises the steps of obtaining an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled; splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled; printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the attribute of each expert sub-table of the electronic version; corresponding each expert sub-table with the expert sub-table to be filled, and establishing a mapping relation between the cells where the dividing items are located; carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table, and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not; if yes, marking the cell, identifying the content in the cell, and inputting the identification result into the expert sub-table to be filled to obtain a target expert sub-table; and combining all the target expert sub-tables to obtain the target expert table, so that most of manual operation can be effectively saved, and meanwhile, the reworking problem caused by errors is reduced.
Drawings
FIG. 1 is a flowchart of an expert table management method according to a first embodiment of the present invention;
FIG. 2 is a block diagram showing the structure of an expert table management system according to a second embodiment of the present invention;
fig. 3 is a block diagram of an electronic device according to a third embodiment of the present invention.
Detailed Description
In order that the invention may be readily understood, a more complete description of the invention will be rendered by reference to the appended drawings. Several embodiments of the invention are presented in the figures. This invention may, however, be embodied in many different forms and should not be construed as limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete.
It will be understood that when an element is referred to as being "mounted" on another element, it can be directly on the other element or intervening elements may also be present. When an element is referred to as being "connected" to another element, it can be directly connected to the other element or intervening elements may also be present. The terms "vertical," "horizontal," "left," "right," and the like are used herein for illustrative purposes only.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. The terminology used herein in the description of the invention is for the purpose of describing particular embodiments only and is not intended to be limiting of the invention. The term "and/or" as used herein includes any and all combinations of one or more of the associated listed items.
Example 1
Referring to fig. 1, fig. 1 shows an expert table management method according to a first embodiment of the present invention, and the method specifically includes steps S01 to S07.
Step S01, acquiring an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled, wherein the fixed area at least comprises basic conditions of items arranged in sequence, and the variable area at least comprises names of all the experts to be reviewed.
Specifically, an electronic version expert table to be filled is obtained, and it can be understood that the electronic version expert table to be filled is a table made of excel software, wherein part of cells are blank for filling by an expert, and after the content of the electronic version expert table to be filled is completely filled, namely, the final summary table, all information can be queried in the table.
It should be noted that, the to-be-filled expert table includes a fixed area and a variable area, the information in the fixed area can be understood as basic information, that is, the public information that can be seen by each expert, and the information in the variable area needs to be filled according to the experience of the expert, in this embodiment, for the value of the score to be filled out, specifically, the fixed area includes at least the basic condition of the items set in sequence, for example, the school name, the competitor, the project profile, etc., the variable area includes at least the names of the respective experts of the review, the names of the experts and the scoring items are located in the same column, where the variable area is equivalent to a macro area, that is, according to the written name of the expert, the trigger area for the subsequent splitting and printing is automatically performed, it can be understood that, when the variable area is filled with n expert names, the to be subsequently divide the to be filled out into n copies, and print, and after each expert takes the form to be filled out, the introduction of the project by the competitor.
Therefore, the printing operation of the user according to the number of specialists can be omitted, and meanwhile, the standard fonts can be rapidly identified and the form filled by the corresponding specialists can be determined due to the fact that the corresponding specialist names are arranged in the form.
And step S02, splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled.
Specifically, after the expert names are written, the fixed area and the variable area can be divided, it can be understood that the area where the expert names exist is the variable area, wherein the column numbers of the written expert names and the total column numbers with the expert names are obtained, for example, the expert is written with the F1 in three, the expert is written with the G1 in four in order, the expert is written with the H1 in five in order, and the like, the column numbers of the expert names can be determined, namely, the F1, the G1 and the H1, the total column numbers with the expert names are 3 columns, then, according to the total column numbers, a corresponding number of blank tables are established, namely, 3 blank tables are established, the fixed area in the to-be-filled expert tables is sequentially combined with the expert names, and the blank tables are filled to form to-be-filled expert sub tables with specific expert names, namely, three separate one evaluation table with the expert is formed.
In order to realize the above functions, firstly, the column number of the last column in the fixed area in the expert table to be filled is obtained, and according to the column number of the last column in the fixed area in the expert table to be filled and the column number arrangement rule, the target column number of the adjacent column of the column number of the last column in the fixed area in the expert table to be filled is determined, according to the above example, the column number of the last column in the fixed area in the expert table to be filled is E, according to the column number arrangement rule of excel, the column number of the column after E is F, and then the target column number is F.
Further, extracting each column number written with the expert name and the corresponding expert name, sequentially replacing each column number written with the expert name with a target column number, sequentially binding with the corresponding expert name to obtain a binding result, namely, sequentially replacing the column numbers of the column F, the column G and the column H with the column F, sequentially binding the original expert name with the column F, wherein the column F is the original expert name, so that the column F is not changed after replacement, the column G and the column H are respectively moved to the column F, finally combining the fixed area in the expert table to be filled with each binding result, and filling the binding result into each blank table to form the expert table to be filled with specific expert names.
And S03, printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the belonging of each expert sub-table of the electronic version.
Specifically, an expert sub-table of each electronic version is obtained, and a cell coordinate system is established by taking a preset angle of the expert sub-table as an origin, for example, taking the upper left corner of the table as the origin, taking the right as the positive x-axis direction, and taking the lower part of the origin as the positive y-axis direction, then the coordinates of the A1 cell are (1, 1), the coordinates of the B1 cell are (2, 1), and the coordinates of the A2 cell are (1, 2); according to the cell coordinate system, acquiring the coordinates of each cell in the expert sub-table of each electronic version, and determining the first coordinate where the expert name is located; the expert names in the cells corresponding to the first coordinates are identified, the belonging of the expert sub-tables of each electronic version is determined, and it is required to be noted that, because the first coordinates where the expert names are located are marked in advance, the expert names of standard fonts in the electronic version can be rapidly identified by adopting an image identification technology, so that the belonging of the expert sub-tables of each electronic version is determined, and the content of the expert sub-tables is conveniently imported into the corresponding expert sub-tables to be filled.
And step S04, according to the attribute of the expert sub-table of each electronic version, each expert sub-table is corresponding to the expert sub-table to be filled, and the mapping relation is built for the cells where the dividing items are located.
Specifically, determining row and column numbers of a first cell where a dividing item is located in an expert sub-table to be filled; determining a second coordinate of a second cell where a scoring item in the expert sub-table of each electronic version is located according to a cell coordinate system established before; and establishing a mapping relation between the second coordinates and the line numbers, wherein the mapping relation is used for writing the numbers in the second cells corresponding to the second coordinates into the first cells where the dividing items in the expert sub-table to be filled are located according to the line numbers after identifying the numbers in the second cells.
And step S05, carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table, judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not, and if so, executing the step S06.
Specifically, the boundary of the cell where the dividing item is located in the expert sub-table is identified, wherein the cell where the dividing item is located at a fixed position, so that the boundary identification can be performed in a specified manner, for example, a preset boundary coordinate position is specified in a calibration manner, so that the area in the boundary is positioned in an express way, and it is required to be noted that the color of the pixel point in the boundary is acquired, and whether the non-white pixel point exists in the boundary can be determined according to the RGB value; if non-white pixels exist, acquiring the total number of pixels in the boundary and the number of the non-white pixels, and calculating the proportion of the number of the non-white pixels to the total number of the pixels in the boundary, wherein the purpose of calculating the proportion of the number of the non-white pixels to the total number of the pixels in the boundary is to prevent misjudgment so as to avoid unnecessary identification operation; judging whether the proportion of the number of non-white pixels to the total number of pixels in the boundary is larger than a threshold value or not; if yes, judging that the cell in which the scoring item is positioned in the expert sub-table has content. The purpose of the above process is to quickly identify cells with numbers and to identify instead of traversing every cell without an object.
And step S06, marking the cell, identifying the content in the cell, and inputting the identification result into the expert sub-table to be filled to obtain the target expert sub-table.
In order to identify the numbers in the cells, the digital pictures in the cells can be intercepted by establishing a neural network model, and then the digital pictures are input into the neural network model to obtain the data in the pictures, wherein the neural network model is the current general image identification neural network model.
And S07, combining the target expert sub-tables to obtain a target expert table.
In this embodiment, the fixed area and the variable area in each target expert sub-table are determined respectively, and the variable areas in each target expert sub-table are numbered sequentially, where the fixed area in the target expert sub-table is consistent with the fixed area in the expert sub-table to be filled, and the variable area in each target expert sub-table is the corresponding expert name, specifically, the variable area in each target expert sub-table is, for example, the I column, i.e., the expert name exists in the I column, the I column number in the first target expert sub-table is the next column of the fixed area, the I column number in the second target expert sub-table is the next two columns of the fixed area, the I column number in the third target expert sub-table is the next three columns of the fixed area, and so on.
According to the numbering sequence, the variable regions in each target expert sub-table are sequentially attached to the fixed regions to obtain a target expert table, and the target expert table can be understood to contain expert names and corresponding scoring conditions.
In summary, in the expert table management method in the above embodiment of the present invention, the expert table to be filled in the electronic version is obtained, and the fixed area and the variable area in the expert table to be filled are determined; splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled; printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the attribute of each expert sub-table of the electronic version; corresponding each expert sub-table with the expert sub-table to be filled, and establishing a mapping relation between the cells where the dividing items are located; carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table, and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not; if yes, marking the cell, identifying the content in the cell, and inputting the identification result into the expert sub-table to be filled to obtain a target expert sub-table; and combining all the target expert sub-tables to obtain the target expert table, so that most of manual operation can be effectively saved, and meanwhile, the reworking problem caused by errors is reduced.
Example two
Referring to fig. 2, fig. 2 is a block diagram of an expert table management system 200 according to a second embodiment of the present invention, where the expert table management system 200 includes: the system comprises an acquisition module 21, a splitting module 22, a first identification module 23, a mapping relation establishment module 24, a judgment module 25, a second identification module 26 and a combination module 27, wherein:
the acquiring module 21 is configured to acquire an electronic version of the expert table to be filled, and determine a fixed area and a variable area in the expert table to be filled, where the fixed area includes at least a basic case of items set in sequence, and the variable area includes at least each expert name of the review;
the splitting module 22 is configured to split the expert table to be filled into corresponding expert sub-tables to be filled with only specific expert names according to the expert names of the changed regions in the expert table to be filled;
the first identifying module 23 is configured to print each expert sub-table to be filled, scan to obtain each expert sub-table of an electronic version after the expert is filled, identify the expert name in each expert sub-table of the electronic version, and determine the expert sub-table of each electronic version;
the mapping relation establishing module 24 is configured to correspond each expert sub-table to the expert sub-table to be filled according to the belonging of the expert sub-tables of each electronic version, and establish a mapping relation with the cells where the scoring items are located;
the judging module 25 is used for carrying out image recognition on the cells in which the dividing items are located in each expert sub-table, and judging whether the cells in which the dividing items are located in the expert sub-table have contents or not;
the second identifying module 26 is configured to, when it is determined that there is content in a cell in which the dividing item is located in the expert sub-table, mark the cell, identify the content in the cell, and input the identification result into the expert sub-table to be filled to obtain a target expert sub-table;
and the combination module 27 is used for combining the target expert tables to obtain the target expert table.
Further, in some alternative embodiments of the present invention, the splitting module 22 includes:
a first acquiring unit configured to acquire a column number of each written expert name and a total column number having the expert name;
the blank table establishing unit is used for establishing a blank table with corresponding quantity according to the total column number;
the first combination unit is used for sequentially combining the fixed areas in the expert names to be filled with the expert names and filling the fixed areas into each blank table to form expert sub-tables to be filled with specific expert names.
Further, in some optional embodiments of the present invention, the first combining unit includes:
the target column number determining subunit is used for acquiring the column number of the last column in the fixed area in the expert table to be filled, and determining the target column number of the adjacent column of the column number of the last column in the fixed area in the expert table to be filled according to the column number of the last column in the fixed area in the expert table to be filled and the column number arrangement rule;
the binding subunit is used for extracting each column number written with the expert name and the corresponding expert name, sequentially replacing each column number written with the expert name with the target column number, and sequentially binding the target column number with the corresponding expert name to obtain a binding result;
the first combination subunit is used for combining the fixed area in the expert table to be filled with each binding result, and filling the fixed area into each blank table to form expert sub-tables to be filled with specific expert names.
Further, in some alternative embodiments of the present invention, the first identifying module 23 includes:
the cell coordinate system unit is used for acquiring expert sub-tables of all electronic versions, and establishing a cell coordinate system by taking a preset angle of the expert sub-tables as an origin;
the first coordinate determining unit is used for acquiring the coordinates of each cell in the expert sub-table of each electronic version according to the cell coordinate system and determining the first coordinate where the expert name is located;
the first identification unit is used for identifying the expert name in the cell corresponding to the first coordinate and determining the belonging of the expert sub-table of each electronic version.
Further, in some alternative embodiments of the present invention, the mapping relationship establishing module 24 includes:
the row and column number determining unit is used for determining the row and column numbers of the first cell where the dividing item is located in the expert sub-table to be filled;
the second coordinate determining unit is used for determining the second coordinates of the second cells where the scoring items in the expert sub-tables of the electronic versions are located according to the cell coordinate system;
and the mapping relation establishing unit is used for establishing the mapping relation between the second coordinate and the rank number.
Further, in some alternative embodiments of the present invention, the determining module 25 includes:
the first judging unit is used for identifying the boundary of the cell where the dividing item is located in the expert sub-table, acquiring the color of the pixel point in the boundary and judging whether the non-white pixel point exists in the boundary or not;
the computing unit is used for acquiring the total number of the pixels in the boundary and the number of the non-white pixels when judging that the non-white pixels exist in the boundary, and computing the proportion of the number of the non-white pixels to the total number of the pixels in the boundary;
the second judging unit is used for judging whether the proportion of the number of non-white pixel points to the total number of pixel points in the boundary is larger than a threshold value or not;
if yes, judging that the cell in which the scoring item is positioned in the expert sub-table has content.
Further, in some alternative embodiments of the present invention, the combining module 27 includes:
the numbering unit is used for respectively determining a fixed area and a variable area in each target expert sub-table and numbering the variable areas in each target expert sub-table in sequence;
and the target expert table generating unit is used for sequentially attaching the variable regions in each target expert table to the fixed regions according to the numbering sequence to obtain the target expert table.
Example III
In another aspect, referring to fig. 3, an electronic device according to a third embodiment of the present invention includes a memory 20, a processor 10, and a computer program 30 stored on the memory and capable of running on the processor, where the processor 10 implements the expert table management method as described above when executing the computer program 30.
The processor 10 may be, among other things, a central processing unit (Central Processing Unit, CPU), a controller, a microcontroller, a microprocessor or other data processing chip for running program code or processing data stored in the memory 20, e.g. executing an access restriction program or the like, in some embodiments.
The memory 20 includes at least one type of readable storage medium including flash memory, a hard disk, a multimedia card, a card memory (e.g., SD or DX memory, etc.), a magnetic memory, a magnetic disk, an optical disk, etc. The memory 20 may in some embodiments be an internal storage unit of the electronic device, such as a hard disk of the electronic device. The memory 20 may also be an external storage device of the electronic device in other embodiments, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash Card (Flash Card) or the like. Further, the memory 20 may also include both internal storage units and external storage devices of the electronic device. The memory 20 may be used not only for storing application software of an electronic device and various types of data, but also for temporarily storing data that has been output or is to be output.
It should be noted that the structure shown in fig. 3 does not constitute a limitation of the electronic device, and in other embodiments the electronic device may comprise fewer or more components than shown, or may combine certain components, or may have a different arrangement of components.
The embodiment of the invention also provides a computer readable storage medium, on which a computer program is stored, which when executed by a processor implements the expert table management method as described above.
Those of skill in the art will appreciate that the logic and/or steps represented in the flow diagrams or otherwise described herein, e.g., a ordered listing of executable instructions for implementing logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). In addition, the computer readable medium may even be paper or other suitable medium on which the program is printed, as the program may be electronically captured, via, for instance, optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory.
It is to be understood that portions of the present invention may be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, may be implemented using any one or combination of the following techniques, as is well known in the art: discrete logic circuits having logic gates for implementing logic functions on data signals, application specific integrated circuits having suitable combinational logic gates, programmable Gate Arrays (PGAs), field Programmable Gate Arrays (FPGAs), and the like.
In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The foregoing examples illustrate only a few embodiments of the invention, which are described in detail and are not to be construed as limiting the scope of the invention. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the invention, which are all within the scope of the invention. Accordingly, the scope of protection of the present invention is to be determined by the appended claims.
Claims (10)
1. A method of expert table management, the method comprising:
acquiring an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled, wherein the fixed area at least comprises project basic conditions which are arranged in sequence, and the variable area at least comprises the names of all the experts to be reviewed;
splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled;
printing each expert sub-table to be filled, scanning to obtain each expert sub-table of the electronic version after the expert is filled, identifying the expert name in each expert sub-table of the electronic version, and determining the attribute of each expert sub-table of the electronic version;
according to the belongings of the expert sub-tables of each electronic version, each expert sub-table corresponds to the expert sub-table to be filled, and a mapping relation is established for the cells where the dividing items are located;
carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table, and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not;
if yes, marking the cell, identifying the content in the cell, and inputting the identification result into the expert sub-table to be filled to obtain a target expert sub-table;
and combining the target expert sub-tables to obtain the target expert table.
2. The expert table management method according to claim 1, wherein the step of splitting the expert table to be filled into corresponding expert sub-tables to be filled with only specific expert names according to expert names of a variation area in the expert table to be filled comprises:
acquiring the column number of each written expert name and the total column number with the expert name;
establishing a blank table with corresponding quantity according to the total column number;
and combining the fixed areas in the expert tables to be filled with the expert names in sequence, and filling the expert names into each blank table to form expert sub-tables to be filled with specific expert names.
3. The expert table management method as set forth in claim 2, wherein the step of sequentially combining the fixed area in the expert table to be filled with the expert names, filling each blank table, and forming each expert sub-table to be filled with only specific expert names includes:
acquiring a column number of a last column in a fixed area in the expert table to be filled, and determining a target column number of an adjacent column of the column number of the last column in the fixed area in the expert table to be filled according to the column number of the last column in the fixed area in the expert table to be filled and a column number arrangement rule;
extracting each column number written with the expert name and the corresponding expert name, sequentially replacing each column number written with the expert name with the target column number, and sequentially binding the target column number with the corresponding expert name to obtain a binding result;
and combining the fixed area in the expert table to be filled with each binding result, and filling the fixed area into each blank table to form expert sub-tables to be filled with specific expert names.
4. The expert table management method as set forth in claim 3, wherein the step of printing each expert sub-table to be filled, scanning to obtain each electronic version of the expert sub-table after the expert is filled, and identifying the expert name in each electronic version of the expert sub-table, and determining the belonging of each electronic version of the expert sub-table includes:
acquiring expert sub-tables of all electronic versions, and establishing a cell coordinate system by taking a preset angle of the expert sub-tables as an origin;
according to the cell coordinate system, acquiring the coordinates of each cell in the expert sub-table of each electronic version, and determining the first coordinate where the expert name is located;
and identifying the expert names in the cells corresponding to the first coordinates, and determining the belongings of the expert sub-tables of the electronic versions.
5. The expert table management method of claim 4, wherein the step of associating each expert sub-table with the to-be-filled expert sub-table and establishing a mapping relationship between cells in which the scoring items are located according to the belonging of the expert sub-tables of each electronic version comprises:
determining row and column numbers of a first cell where a marking item is located in an expert sub-table to be filled;
determining a second coordinate of a second cell where the scoring item is located in the expert sub-table of each electronic version according to the cell coordinate system;
and establishing a mapping relation between the second coordinate and the rank number.
6. The expert table management method of claim 5, wherein the step of identifying the image in the cell in which the scoring item is located in each expert sub-table, and determining whether there is content in the cell in which the scoring item is located in the expert sub-table comprises:
identifying the boundary of a cell where a dividing item is located in an expert sub-table, acquiring the color of a pixel point in the boundary, and judging whether a non-white pixel point exists in the boundary;
if yes, acquiring the total number of pixels in the boundary and the number of non-white pixels, and calculating the proportion of the number of the non-white pixels to the total number of the pixels in the boundary;
judging whether the proportion of the number of non-white pixels to the total number of pixels in the boundary is larger than a threshold value or not;
if yes, judging that the cell in which the scoring item is positioned in the expert sub-table has content.
7. The expert table management method of claim 6, wherein the step of combining the target expert sub-tables to obtain the target expert table comprises:
respectively determining a fixed area and a variable area in each target expert sub-table, and numbering the variable areas in each target expert sub-table in sequence;
and sequentially attaching the variable regions in each target expert table to the fixed regions according to the numbering sequence to obtain the target expert table.
8. An expert table management system, the system comprising:
the system comprises an acquisition module, a storage module and a storage module, wherein the acquisition module is used for acquiring an expert table to be filled in an electronic version, and determining a fixed area and a variable area in the expert table to be filled, wherein the fixed area at least comprises project basic conditions which are arranged in sequence, and the variable area at least comprises the names of all the experts to be reviewed;
the splitting module is used for splitting the expert table to be filled into corresponding expert sub-tables to be filled with specific expert names only according to the expert names of the changed areas in the expert table to be filled;
the first recognition module is used for printing all the expert sub-tables to be filled, scanning to obtain all the expert sub-tables of the electronic versions after the expert is filled, recognizing the expert names in all the expert sub-tables of the electronic versions, and determining the belongings of the expert sub-tables of the electronic versions;
the mapping relation establishing module is used for corresponding each expert sub-table with the expert sub-table to be filled according to the belonging of the expert sub-tables of each electronic version, and establishing a mapping relation of the cells where the dividing items are located;
the judging module is used for carrying out image recognition on the cells in which the dividing items are positioned in each expert sub-table and judging whether the cells in which the dividing items are positioned in the expert sub-table have contents or not;
the second recognition module is used for marking the cell when judging that the cell in which the dividing item is positioned in the expert sub-table has content, recognizing the content in the cell, and inputting the recognition result into the expert sub-table to be filled to obtain a target expert sub-table;
and the combination module is used for combining the target expert sub-tables to obtain the target expert table.
9. A computer readable storage medium having stored thereon a computer program, which when executed by a processor implements the expert table management method as claimed in any of claims 1-6.
10. An electronic device comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the expert table management method of any of claims 1-6 when the program is executed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311465350.0A CN117195846B (en) | 2023-11-07 | 2023-11-07 | Expert table management method, system, storage medium and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311465350.0A CN117195846B (en) | 2023-11-07 | 2023-11-07 | Expert table management method, system, storage medium and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117195846A CN117195846A (en) | 2023-12-08 |
| CN117195846B true CN117195846B (en) | 2024-03-01 |
Family
ID=88998337
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311465350.0A Active CN117195846B (en) | 2023-11-07 | 2023-11-07 | Expert table management method, system, storage medium and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117195846B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1211611A1 (en) * | 2000-11-29 | 2002-06-05 | Lafayette Software Inc. | Methods of encoding and combining integer lists |
| CN111144282A (en) * | 2019-12-25 | 2020-05-12 | 北京同邦卓益科技有限公司 | Table recognition method and device, and computer-readable storage medium |
| CN112801016A (en) * | 2021-02-08 | 2021-05-14 | 联仁健康医疗大数据科技股份有限公司 | Vote data statistical method, device, equipment and medium |
| CN113537221A (en) * | 2020-04-15 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Image recognition method, device and equipment |
| CN113642031A (en) * | 2021-10-15 | 2021-11-12 | 中国铁道科学研究院集团有限公司科学技术信息研究所 | Subject acceptance method and system |
| CN114220103A (en) * | 2022-02-22 | 2022-03-22 | 成都明途科技有限公司 | Image recognition method, device, equipment and computer readable storage medium |
| CN114492349A (en) * | 2022-01-26 | 2022-05-13 | 数字广东网络建设有限公司 | Table splitting method and device, electronic equipment and storage medium |
| CN114973282A (en) * | 2022-05-09 | 2022-08-30 | 深圳市商汤科技有限公司 | Table identification method and device, electronic equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111695553B (en) * | 2020-06-05 | 2023-09-08 | 北京百度网讯科技有限公司 | Form identification method, device, equipment and medium |
-
2023
- 2023-11-07 CN CN202311465350.0A patent/CN117195846B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1211611A1 (en) * | 2000-11-29 | 2002-06-05 | Lafayette Software Inc. | Methods of encoding and combining integer lists |
| CN111144282A (en) * | 2019-12-25 | 2020-05-12 | 北京同邦卓益科技有限公司 | Table recognition method and device, and computer-readable storage medium |
| CN113537221A (en) * | 2020-04-15 | 2021-10-22 | 阿里巴巴集团控股有限公司 | Image recognition method, device and equipment |
| CN112801016A (en) * | 2021-02-08 | 2021-05-14 | 联仁健康医疗大数据科技股份有限公司 | Vote data statistical method, device, equipment and medium |
| CN113642031A (en) * | 2021-10-15 | 2021-11-12 | 中国铁道科学研究院集团有限公司科学技术信息研究所 | Subject acceptance method and system |
| CN114492349A (en) * | 2022-01-26 | 2022-05-13 | 数字广东网络建设有限公司 | Table splitting method and device, electronic equipment and storage medium |
| CN114220103A (en) * | 2022-02-22 | 2022-03-22 | 成都明途科技有限公司 | Image recognition method, device, equipment and computer readable storage medium |
| CN114973282A (en) * | 2022-05-09 | 2022-08-30 | 深圳市商汤科技有限公司 | Table identification method and device, electronic equipment and storage medium |
Non-Patent Citations (4)
| Title |
|---|
| Split, Embed and Merge: An accurate table structure recognizer;Zhenrong Zhang et al;《Pattern Recognition》;第126卷;全文 * |
| 基于Excel VBA的职称评审专家抽取系统的设计与实现;亢娟娜 等;《自动化与仪器仪表》(01);全文 * |
| 教育部基金管理信息系统的设计与开发;刘蕴辉 等;《铁路计算机应用》;全文 * |
| 网络表格扩展技术研究;齐飞;《中国优秀硕士学位论文全文数据库电子期刊 信息科技辑》;第2017卷(第1期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117195846A (en) | 2023-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US7508998B2 (en) | Image search apparatus, image search method, program, and storage medium | |
| CN102117269B (en) | Apparatus and method for digitizing documents | |
| CN111325110A (en) | Form format recovery method and device based on OCR and storage medium | |
| CN101901338A (en) | Method and system for calculating scores of test paper | |
| CN111340037B (en) | Text layout analysis method and device, computer equipment and storage medium | |
| CN110321837B (en) | Test question score identification method, device, terminal and storage medium | |
| CN102194123A (en) | Method and device for defining table template | |
| CN113283431B (en) | Answer sheet option area identification method and system | |
| CN112861648A (en) | Character recognition method and device, electronic equipment and storage medium | |
| CN107193467B (en) | Method and equipment for displaying intelligent pen writing content | |
| CN113920117B (en) | Panel defect area detection method and device, electronic equipment and storage medium | |
| CN107025076A (en) | One kind automation printing test method and device | |
| CN117195846B (en) | Expert table management method, system, storage medium and equipment | |
| CN117371446B (en) | Medical record text typesetting method, system, storage medium and electronic equipment | |
| US20220164573A1 (en) | Business card management device and non-transitory computer readable medium storing business card management program | |
| CN113821602A (en) | Automatic answering method, device, equipment and medium based on image-text chatting record | |
| CN109726722B (en) | Character segmentation method and device | |
| CN111143412A (en) | Data comparison method and device, computer and computer readable storage medium | |
| CN112766248B (en) | Structured prescription picture identification method and device | |
| CN116012860A (en) | Teacher blackboard writing design level diagnosis method and device based on image recognition | |
| CN113223117A (en) | Image processing method and related device | |
| JP2001126010A (en) | Document processor, document definition generation method and area extraction method and storage medium | |
| CN110751140A (en) | Character batch recognition method and device and computer equipment | |
| CN113011274B (en) | Image recognition method, device, electronic equipment and storage medium | |
| CN111428770A (en) | Network model training and inductance defect identification method and device, and electronic equipment |
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 |