CN112163834A - Detection report generation method, device, electronic equipment and medium - Google Patents
Detection report generation method, device, electronic equipment and medium Download PDFInfo
- Publication number
- CN112163834A CN112163834A CN202011051894.9A CN202011051894A CN112163834A CN 112163834 A CN112163834 A CN 112163834A CN 202011051894 A CN202011051894 A CN 202011051894A CN 112163834 A CN112163834 A CN 112163834A
- Authority
- CN
- China
- Prior art keywords
- data
- worksheet
- detection report
- column
- acquiring
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000001514 detection method Methods 0.000 title claims abstract description 100
- 238000000034 method Methods 0.000 title claims abstract description 61
- 230000006870 function Effects 0.000 claims description 77
- 238000012545 processing Methods 0.000 claims description 13
- 238000004590 computer program Methods 0.000 claims description 9
- 238000007689 inspection Methods 0.000 claims description 6
- 230000004044 response Effects 0.000 claims description 6
- 238000012360 testing method Methods 0.000 claims description 6
- 238000012905 input function Methods 0.000 claims description 2
- 210000004027 cell Anatomy 0.000 description 40
- 238000010586 diagram Methods 0.000 description 15
- 230000008569 process Effects 0.000 description 12
- 239000000523 sample Substances 0.000 description 11
- 230000037431 insertion Effects 0.000 description 6
- 238000003780 insertion Methods 0.000 description 5
- 239000000463 material Substances 0.000 description 4
- 238000012546 transfer Methods 0.000 description 4
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- 238000002474 experimental method Methods 0.000 description 3
- 238000003908 quality control method Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000012937 correction Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- BASFCYQUMIYNBI-UHFFFAOYSA-N platinum Chemical compound [Pt] BASFCYQUMIYNBI-UHFFFAOYSA-N 0.000 description 2
- 230000003252 repetitive effect Effects 0.000 description 2
- 108700028369 Alleles Proteins 0.000 description 1
- 238000009004 PCR Kit Methods 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 210000000349 chromosome Anatomy 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 239000013642 negative control Substances 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 229910052697 platinum Inorganic materials 0.000 description 1
- 239000013641 positive control Substances 0.000 description 1
- 238000007781 pre-processing Methods 0.000 description 1
- 230000000717 retained effect Effects 0.000 description 1
- 239000004065 semiconductor Substances 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
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/10—Office automation; Time management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a detection report generation method, a detection report generation device, electronic equipment and a medium. The method comprises the following steps: acquiring a detection report template; receiving a mail merging instruction, wherein the mail merging instruction carries a data source address, a worksheet identifier, a position to be filled and a project name to be filled; responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data; inserting a merging domain into the position to be filled of the detection report template to generate a target detection report file, wherein the merging domain is data corresponding to the name of the project to be filled in the worksheet, the target detection report file comprises a document corresponding to the merging domain, and the detection report can be automatically generated according to the data in the worksheet simply and conveniently.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method and an apparatus for generating a detection report, an electronic device, and a medium.
Background
At present, detection reports need to be generated based on a large amount of statistical data in many scenes, such as compiling the detection reports in STR detection projects in the forensic physical evidence field.
In order to reduce the error rate, reduce the repetitive labor and improve the working efficiency, conditional users can purchase customized commercial software, but the cost is higher, otherwise, the users can only use manual compiling, the data volume is large and complex, the labor and the time are wasted, and the error rate of the compiling of the detection report is higher.
Disclosure of Invention
In view of the above, it is desirable to provide a detection report generation method, apparatus, electronic device, and medium.
In a first aspect, a detection report generation method is provided, including:
acquiring a detection report template;
receiving a mail merging instruction, wherein the mail merging instruction carries a data source address, a worksheet identifier, a position to be filled and a project name to be filled;
responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data;
inserting a merging domain into the position to be filled of the detection report template to generate a target detection report file, wherein the merging domain is data corresponding to the name of the project to be filled in the worksheet, and the target detection report file comprises a document corresponding to the merging domain.
In a second aspect, a detection report generation apparatus is provided, including:
the acquisition module is used for acquiring a detection report template;
the system comprises a setting module, a sending module and a processing module, wherein the setting module is used for receiving a mail merging instruction, and the mail merging instruction carries a data source address, a worksheet identifier, a position to be filled and a project name to be filled;
the processing module is used for responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data;
the processing module is further configured to insert a merge domain in the position to be filled of the detection report template, and generate a target detection report file, where the merge domain is data corresponding to the name of the project to be filled in the worksheet, and the target detection report file includes a document corresponding to the merge domain.
In a third aspect, an electronic device is provided, comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps as in the first aspect and any one of its possible implementations.
In a fourth aspect, there is provided a computer storage medium storing one or more instructions adapted to be loaded by a processor and to perform the steps of the first aspect and any possible implementation thereof.
The method comprises the steps of receiving a mail merging instruction by acquiring a detection report template, wherein the mail merging instruction comprises a data source address, a work table identifier, a position to be filled and a project name to be filled, responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, wherein the merged data table comprises integrated data derived by software, acquiring the work table corresponding to the work table identifier in the merged data table, inserting a merging field into the position to be filled of the detection report template, wherein the merging field is data corresponding to the project name to be filled in the work table, acquiring merged data, merging the merged data into a new document for exporting, and acquiring a target detection report file, wherein the integrated data derived by the software can generate a merged data table, and adding the data into the detection report based on simple office software by the method, compared with a manual operation mode, the method can eliminate errors in the data transfer process, and greatly improves the working efficiency.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments or the background art of the present application, the drawings required to be used in the embodiments or the background art of the present application will be described below.
Fig. 1 is a schematic flowchart of a detection report generation method according to an embodiment of the present application;
FIG. 2 is a partial screenshot of a document to be processed opened using a worksheet format according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a clear space interface according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a comma deletion interface according to an embodiment of the present application;
FIG. 5 is a diagram illustrating a client information representation according to an embodiment of the present disclosure;
fig. 6 is a schematic diagram of an insertion function setting interface according to an embodiment of the present disclosure;
FIG. 7 is a schematic diagram of a detection report template provided by an embodiment of the present application;
FIG. 8 is a schematic view of a window interface for inserting a field according to an embodiment of the present disclosure;
FIG. 9 is a schematic illustration of a processed detection report template provided by an embodiment of the present application;
FIG. 10 is a diagram illustrating a dialog box according to an embodiment of the present application;
fig. 11 is a schematic diagram of a file export result according to an embodiment of the present application;
FIG. 12 is a table data comparison diagram according to an embodiment of the present disclosure;
fig. 13 is a schematic structural diagram of a detection report generation apparatus according to an embodiment of the present application;
fig. 14 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
Detailed Description
In order to make the technical solutions of the present application better understood, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The terms "first," "second," and the like in the description and claims of the present application and in the above-described drawings are used for distinguishing between different objects and not for describing a particular order. Furthermore, the terms "include" and "have," as well as any variations thereof, are intended to cover non-exclusive inclusions. For example, a process, method, system, article, or apparatus that comprises a list of steps or elements is not limited to only those steps or elements listed, but may alternatively include other steps or elements not listed, or inherent to such process, method, article, or apparatus.
Reference in the specification to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment can be included in at least one embodiment of the specification. The appearances of the phrase in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. It is explicitly and implicitly understood by one skilled in the art that the embodiments described herein can be combined with other embodiments.
The embodiments of the present application will be described below with reference to the drawings.
Referring to fig. 1, fig. 1 is a schematic flowchart illustrating a method for generating a detection report according to an embodiment of the present disclosure. The method can comprise the following steps:
101. and acquiring a detection report template.
The execution subject of the embodiment of the present application may be a detection report generation apparatus, and may be an electronic device, and in a specific implementation, the electronic device may be a terminal, which may also be referred to as a terminal device, including but not limited to a desktop computer, and may have a touch-sensitive surface (e.g., a touch screen display and/or a touch pad). It should also be understood that in some embodiments, the device described above may also be other portable devices such as a mobile phone, laptop computer, or tablet computer having a touch sensitive surface (e.g., a touch screen display and/or a touchpad).
The detection report template can be any preset detection report template, and other data can be referred based on the detection report template to generate the detection report.
102. And receiving a mail merging instruction, wherein the mail merging instruction carries a data source address, a worksheet identifier, a to-be-filled position and a to-be-filled project name.
The mail merging instruction may be triggered by a user, and the user may select, by using a mouse or inputting a keyboard, information for setting reference data, including the data source address, the work list identifier, the to-be-filled position, the to-be-filled project name, and the like, and trigger generation of a corresponding mail merging instruction.
For example, the user may select a "quote" function tab in the prepared template, merge the function tab through "mail", click "open data source", pop up a dialog box, select a previously saved data table in the opened "select data source", and select a worksheet therein, where the specific operation manner is not limited herein.
103. And responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data.
The mail merging in the embodiment of the application can be realized by depending on the mail merging function in Office Word software, and is a function capable of processing data in batches. Specifically, in Office, two documents may be established first: a WORD comprises a main document (such as an unfilled envelope and the like) with the content shared by all files and a data source EXCEL (filled receiver, sender, zip code and the like) with change information, then the change information is inserted into the main document by using a mail merging function, and a user of the synthesized file can save the file as a WORD document, print the file out and send the file out in a mail form.
Specifically, according to the mail merge instruction, the merged data table corresponding to the data source address may be obtained, and then the work table corresponding to the work table identifier in the merged data table may be obtained, where the information is selected according to the previous operation of the user.
The merged data table is generated by integrating data, and may be a data table required for generating the content of the detection report this time. The generation process of the merged data table is described in detail below:
in an embodiment, the to-be-processed file may be obtained first, and then the merged data table may be generated based on the to-be-processed file and the data merging function formula. The data merging function formula can be preset according to needs and used for searching and merging specific data, and the file to be processed can be a CSV format file obtained by batch export of detection data. The steps may specifically include:
converting the file to be processed into a worksheet format, and acquiring a first worksheet corresponding to the file to be processed; establishing a second worksheet, wherein the head row and the head column in the second worksheet are respectively the same as the head row and the head column of the first worksheet;
acquiring an information table to be processed; inserting a new added column into the second worksheet, wherein the new added column is used for filling target data in the information table to be processed;
acquiring the data merging function formula, and searching the same data in the information table to be processed and the preset column of the first worksheet according to the data merging function formula to determine a corresponding filling position;
and adding the target data in the corresponding cells according to the filling positions in the second worksheet to obtain the merged data sheet.
Specifically, the file to be processed of the exported data can be converted into a table form, the table where the source data is located is defined as a first worksheet, and then a second worksheet is newly built in the same workbook for data preprocessing. The first column and first row (typically the project name) in the first sheet may be copied to the second sheet first.
The information table to be processed may be an information table of any pre-established data, and in the embodiment of the present application, data in the information table to be processed needs to be merged with data in the original first worksheet. In tabular software such as Excel, tabular data statistics can be realized through a function. Specifically, the user can set and execute the data merging function formula according to the area and the operation rule which need to be searched, and the logical meaning of the data merging function formula comprises that the information of the second item in the information table to be processed is returned in the selected cell in the second working table by searching the common first item in the two tables.
In an optional implementation manner, after inserting a new add column into the second worksheet, the method further includes:
acquiring input function parameters, wherein the function parameters comprise a search value, a data table and a column number, the search value is a numerical value which needs to be searched in a preset column of the first working table, the data table comprises the information table to be processed and the first working table, and the column number is the newly-added column number;
and executing an insert function corresponding to the function parameter, searching the search value in the preset column, and returning the numerical value at the appointed column in the current row corresponding to the search value to the corresponding cell of the second worksheet.
Similar effects can also be achieved by using software insertion function functions in the table, such as using "VLOOKUP" functions. The user can input the function parameters, including the lookup value, the data table and the column number, so as to execute the corresponding function insertion function in the table, lookup the lookup value in the preset column of the first worksheet, and return the numerical value at the designated column in the current row corresponding to the lookup value to the corresponding cell of the second worksheet, so as to call the information of the second item in the information table to be processed to the corresponding position in the second worksheet.
After the function operation on the cell in the embodiment of the application, the automatic filling function may be used to obtain the calculation results of the same logic of other selected cells, for example, dragging a "+" sign at the lower right corner of a cell in which a function has been set, and performing automatic filling downwards to obtain the return values of other cells.
The serial number identification information such as numbers in the information table to be processed is generally continuous, but the first derived worksheet may not be derived due to partial data being poor, so that the serial number identification information is discontinuous, and therefore, the two tables must be searched and called through the insertion function and the like, and the merging of the two tables cannot be completed through the copying and pasting operation of the two tables.
Optionally, after obtaining the first worksheet corresponding to the to-be-processed file, the method further includes:
receiving a symbol removal instruction, wherein the symbol removal instruction comprises a symbol removal function;
executing the logic operation of the symbol removal function in response to the symbol removal instruction, the logic operation of the symbol removal function including:
if the last character of the original data in the first cell of the first worksheet is a preset symbol, returning and clearing the reference data of the last character in a second cell corresponding to the first cell in a second worksheet; if not, returning the original data in the second cell.
Specifically, the data in the first worksheet can be cleaned through the symbol clearing instruction, the preset symbol in the specific position is deleted, and the data is returned to the new second worksheet. The preset symbol can be set as required. For example, in the data obtained from STR detection items in the forensic physical evidence field, commas behind homozygotes in the data can be eliminated in this way, so that the data can be standardized.
Optionally, after obtaining the first worksheet corresponding to the to-be-processed file, the method further includes:
receiving selection operation of a user to determine a target cell;
and responding to the error checking instruction, and emptying the empty character strings before and after the data in the target cell.
The user may select a target cell in the first worksheet by dragging and selecting, etc., and trigger an error checking instruction by the error correction function of the sheet to clear an empty string (extra space) preceding and following the data in the data of the selected target cell.
In the embodiment of the present application, various table function functions may be used to modify the derived data table, which is not limited herein.
104. Inserting a merge domain into the position to be filled of the detection report template to generate a target detection report file, wherein the merge domain is data corresponding to the name of the project to be filled in the worksheet, and the target detection report file comprises a document corresponding to the merge domain.
The target detection report file may include a CSV format file and/or an XLS format file.
The position to be filled in the detection report template is selected by a user according to needs, and data corresponding to the name of the selected item to be filled can be inserted into the detection report template in a form of a merging domain according to the operation. The detection report generated in this way comprises the names of the items to be filled, and can be selectively merged into a new document to output the information into one document, and for the case of setting a plurality of merging fields, can be selectively merged into different new documents to obtain a plurality of target detection report files exported in batches.
In an optional embodiment, the method further comprises:
inserting a new adding column into the second worksheet;
acquiring a preset comparison function, executing the logic operation of the preset comparison function to obtain the comparison result of two cells in different rows in the new row, wherein the logic operation of the preset comparison function comprises the following steps:
when the cell data of the first column and the cell data of the second column in the two cells of different columns are matched, the comparison result is a consistent identifier; and when the cell data of the first column and the cell data of the second column do not match, the comparison result is an alarm mark.
In the processing of batch data, data quality control needs to be done. In the embodiment of the application, certain information before and after processing can be automatically compared to perform data inspection.
The newly added columns inserted above can be used to save the alignment results. By presetting a comparison function, the data of two cells in different columns can be compared, and the result is returned to the corresponding cell in the newly added column, and the representation method of the result can also be set in the function as required.
The embodiment of the application receives a mail merging instruction by acquiring a detection report template, wherein the mail merging instruction comprises a data source address, a work table identifier, a position to be filled and a project name to be filled, and in response to the mail merging instruction, a merged data table corresponding to the data source address is acquired, the merged data table comprises integrated data derived by software, the work table corresponding to the work table identifier in the merged data table is acquired, a merging field is inserted into the position to be filled of the detection report template, the merging field is data corresponding to the project name to be filled in the work table, merged data are acquired, the merged data are merged into a new document to be exported, and a target detection report file is acquired, wherein the integrated data derived by the software can generate the merged data table, and the data are added into the detection report based on simple office software by the method, compared with a manual operation mode, the method can eliminate errors in the data transfer process, and greatly improves the working efficiency.
In order to show the detection report generation method more clearly in the present application, the corresponding detection report generation operation steps are described below by way of example with reference to experimental data.
The file to be processed in the embodiment of the present application may be a data file exported by any analysis software. For example, electrophoretic data analysis software may be used
ID-X1.3 edition, taking sample amplified by Huaxia (TM) platinum PCR kit (Thermo Fisher, USA) as example, and exporting STR data after detection in batchesIs a CSV format file.
In the embodiment of the present application, the derived STR data table may be modified by using a table function of WPS, including the symbol removal and error check described above.
Specifically, spaces in the data may be cleared: for example, after the data table derived by inspection has a blank phenomenon before or after the data in partial cells from the second column, the second column to the last column can be selected, and the blank is cleared by using the automatic error correction function of the WPS table. Specifically, the user can select the cells to be corrected, such as the second column to the last column, with the mouse, click the "error check mark" in the software, and then click the "empty before and after empty string" in the software.
Optionally, certain symbols, such as commas following homozygotes, may also be cleared. Homozygotes mentioned in the examples of the present application are also referred to as homozygotes and homozygotes. Refers to genotypic individuals in diploids with identical alleles at homologous chromosomes. Generally, a comma is arranged behind homozygotes in an exported data table, and the commas are required to be deleted in batches when the detection report requirements are not met. The specific method comprises the following steps:
the first column of data "Sample File" does not work for the application of the mail merge function, and can be deleted in advance. Defining a form in which source data is located as 'sheet 1', newly building a worksheet 'sheet 2' in the same workbook, copying a first column and a first row in the 'sheet 1' into the 'sheet 2', selecting a cell 'B2' in the 'sheet 2', and inputting the following function formula into an edit bar:
＝IF(RIGHT(Sheet1！B2)＝"，"，LEFT(Sheet1！B2，LEN(Sheet1！B2)-1)，Sheet1！B2)
pressing enter key to return. The logical meaning of the function formula is that if the right end of the data in the cell is a comma, the reference data of the last character is removed; if not, the original data is retained, the obtained table is shown in FIG. 3, and the selected cell is the data returned by the function formula, and the tail comma is cleared.
Wherein "Sheet 1! B2 "indicates the cell where the source data that needs to be referenced is located. Optionally, on the basis shown in fig. 3, the small "+" sign at the lower right corner of the cell "B2" may be dragged down and to the right for automatic filling, i.e., the comma in the target data may be cleared. The effect of bulk deletion of commas following homozygotes is achieved as shown in fig. 4.
Further, data in other information tables to be processed may be merged in the modified STR data table, and in this embodiment, a client information table is taken as an example.
The established to-be-processed information table is opened, which may be specifically a client information table as shown in fig. 5. The information table can be properly adjusted according to actual needs. The forms such as the data and the client information table provided by the application are only used for functional demonstration and do not represent specific practical detection application.
The present application will be described by taking an example in which the two columns of data, i.e., the barcode and the gender, in the "customer information table" are incorporated into the STR data table.
In the first step, the worksheet "sheet 2" is selected and inserted into two columns before the second column, and the bar code and the gender are respectively input.
In a second step, cell "B2" is selected, and the following functional formula is entered in the edit bar:
VLOOKUP (A2, [ customer info Table. xls ] Sheet 1! $ B: $ F, 2, FALSE)
The logical meaning is that "B2" in "sheet 2" returns "barcode" information in "customer information table" by looking up the "number" common to both tables.
The same effect can be achieved by inserting functions without directly inputting the function formula. As shown in fig. 6, a schematic diagram of an insertion function setting interface may be obtained by selecting a target cell, clicking a menu "insertion function", selecting a "VLOOKUP" function, popping up a dialog box as in fig. 6, and filling corresponding data according to a prompt, where parameters and function functions are described in the dialog box, and are not described herein again.
In the third step, the small "+" sign at the lower right corner of the cell "B2" can still be dragged to automatically fill the cell downwards, that is, the "barcode" information in the "customer information table" can be called to the corresponding position in the "Sheet 2".
Optionally, the information call of the "gender" column is similar to the information call of the "barcode", and only the column ordinal number in fig. 6 is changed from "2" to "5", that is, the column ordinal number of the "gender" column in the "customer information table".
The number information in the customer information table is generally continuous, but the derived STR information table is not derived due to poor experimental data, so that the number is discontinuous, and therefore, the STR information table must be searched and called by the VLOOKUP function, and the merging of the two tables cannot be completed by copying and pasting operations of the two tables.
Further, the STR data table after merging the client information may be saved. The format of the worksheet saved during export is CSV, and in order to avoid the problem of data loss caused by potential incompatibility, the file is preferably saved in an XLS format. This example file is stored as "mail merge STR data Table xls".
Fig. 7 is a schematic diagram of a detection report template provided in the present application, and as shown in fig. 7, the template is a detection report template corresponding to the STR data, which may include sample information, detection result, and other information. The template is used only for functional demonstration and does not represent a specific practical detection application. Mail merging can be performed based on the detection report template:
specifically, a ' quote ' function tab can be selected from a manufactured detection report template, a ' mail ' is clicked to enter a ' mail merging ' function tab, a ' data source opening ' is clicked, a dialog box is popped up, a ' mail merging STR data table ' stored before is selected from the ' selected data source ' opened, xls ' is clicked, then ' Sheet 2$ ' is clicked, and a second worksheet is selected. Fig. 8 is a schematic diagram of a window interface of an inserted field, for example, a user may determine data to be inserted into a merged field by selecting a space below a "bar code" in a template, clicking a "insert merged field" menu, and selecting a "bar code".
According to the method, all the blanks needing to call data are inserted into the merged domain, whether the positions of the inserted merged domain are correct or not is carefully checked, after the completion, as shown in fig. 9, specific data domain names are arranged under each project Name, such as bar codes, sexes and Sample names in fig. 9, which respectively correspond to specific batch Sample data, and the data content from the merged domain can be displayed in a detection result column according to the preset setting of the template.
Further, the detection reports may be exported automatically in batches. In one embodiment, the user may click on the "view merge data" button to preview the derived test report, and after no problems are found, click "merge into a different new document" to pop up the dialog diagram shown in FIG. 10. The corresponding option can be selected as shown in the dialog box, and after clicking and determining, the batch export detection report is performed, which domain name is used as the file name of the new document, the storage format, the storage position and the like can be set according to requirements. Taking the selection of the domain Name as Sample Name in fig. 10 as an example, refer to a file export result diagram as shown in fig. 11, where the file Name of each file after batch export is the corresponding Sample Name, and information such as file generation time, file type, file size, and the like is correspondingly displayed.
The most worried about the STR item batch detection is the identification accidents such as wrong sample adding and pollution, unlike the paternity test item, even if the test material is mixed, the test material with paternity can be corrected by comparing with the test material with paternity, so that the STR item batch detection needs to be well controlled in quality. The quality control functions in the present application mentioned above are further explained herein.
Except for the conventional laboratory anti-pollution measures, a negative and positive control sample can be added in each batch of experiments,
STR information of all experimenters is recorded in the ID-X analysis software. In addition, the detected gender can be compared, and whether the gender information provided by the client is consistent with the detected gender can be verified. Because the sex information is inevitably checked manually and careless, the sex information can be continuously passed through the WPS formThe function of (2) is automatically checked. A gender check column is added to the last column of the "Sheet 2" in the previously saved "mail merge STR data table" to display the comparison results.
The preset comparison function in the embodiment of the present application specifically includes:
IF (OR (AND (C2 ═ male ", J2 ═ X, Y"), AND (C2 ═ female ", J2 ═ X")), "N \ a", "warning")
Specifically, the preset comparison function may be input to the next row of the "gender checking" cell in the table shown in fig. 12 for operation, where "C2" is the cell in which the gender information provided by the customer is located, and "J2" is the corresponding cell in which the detected gender is located. The logical meaning of the function formula is that when the gender provided by the client is male, the detected STR data is X, Y, or the gender provided by the client is female, and the detected STR data is X, the function formula is displayed as N/a; otherwise, it is displayed as "warning".
Similarly, the small "+" sign in the lower right corner of the cell may be dragged downward to automatically fill the cell, and when the display is "warning", which indicates that there is inconsistency in the gender of the material being tested in the row, and it is necessary to cause caution, the experiment should be repeated to verify whether the sample exchange has occurred during the experiment.
In the embodiment of the application, the demonstration of the function of "mail merge" is based on the office software WPS 2019 of the jinshan corporation, and other versions (such as WPS 2013) may be different and are only illustrated here.
When a detection report is compiled in an STR detection project in the field of forensic physical evidence at present, conditional laboratory purchasing customized commercial software is high in cost for reducing the error rate, reducing the repetitive labor and improving the working efficiency; many small laboratories with insufficient economic strength can only use manual mode to compile documents, which is time-consuming and labor-consuming, and has high error rate of document compilation. The detection report generation method provided by the application can utilize free office software to link data derived by the STR data analysis software GeneMapper ID-X in the forensic physical evidence field with the mail merging function of the office software, so that the STR detection reports can be automatically generated in batches.
The mail merging function of office software such as WPS software can completely realize that the data exported by the analysis software is automatically added into the detection report, completely eliminates errors in the data transfer process, and greatly improves the working efficiency compared with a manual operation mode. Quality control measures such as automatic gender checking can be added into the derived data table in the processing process to identify whether the sample is exchanged or polluted in the experimental process.
Based on the description of the embodiment of the detection report generation method, the embodiment of the application also discloses a detection report generation device. Referring to fig. 13, the detection report generation apparatus 1300 includes:
an obtaining module 131, configured to obtain a detection report template;
a setting module 132, configured to receive a mail merge instruction, where the mail merge instruction carries a data source address, a worksheet identifier, a to-be-filled location, and a to-be-filled project name;
a processing module 133, configured to, in response to the mail merge instruction, obtain a merged data table corresponding to the data source address, and obtain a work table corresponding to the work table identifier in the merged data table, where the merged data table is generated by integrating data;
the processing module 133 is further configured to insert a merge domain into the to-be-filled position of the detection report template, so as to generate a target detection report file, where the merge domain is data corresponding to the to-be-filled project name in the worksheet, and the target detection report file includes a document corresponding to the merge domain.
According to an embodiment of the present application, the steps involved in the method shown in fig. 1 and the steps involved in fig. 2 to fig. 13 may be executed by each module in the detection report generating apparatus 1300 shown in fig. 13, and are not described herein again.
The detection report generation apparatus 1300 in this embodiment of the application may obtain a detection report template, receive a mail merge instruction, where the mail merge instruction includes a data source address, a work table identifier, a to-be-filled location, and a to-be-filled project name, obtain a merged data table corresponding to the data source address in response to the mail merge instruction, where the merged data table includes integrated data derived by software, obtain a work table corresponding to the work table identifier in the merged data table, insert a merge field in the to-be-filled location of the detection report template, where the merge field is data corresponding to the to-be-filled project name in the work table, obtain merged data, merge the merged data into a new document to be exported, obtain a target detection report file, where the integrated data derived by software may generate a merged data table, add data to the detection report based on simple office software implementation by the method, compared with a manual operation mode, the method can eliminate errors in the data transfer process, and greatly improves the working efficiency.
Based on the description of the method embodiment and the device embodiment, the embodiment of the application further provides an electronic device. Referring to fig. 14, the electronic device 1400 includes at least a processor 1401, an input device 1402, an output device 1403, and a computer storage medium 1404. Wherein the processor 1401, input device 1402, output device 1403, and computer storage medium 1404 within the electronic device may be connected by a bus or other means.
A computer storage medium 1404 may be stored in a memory of the electronic device, the computer storage medium 1404 being configured to store a computer program, the computer program comprising program instructions, and the processor 1401 being configured to execute the program instructions stored by the computer storage medium 1404. A processor 1401 (or CPU) is a computing core and a control core of the electronic device, and is adapted to implement one or more instructions, and in particular, is adapted to load and execute the one or more instructions so as to implement a corresponding method flow or a corresponding function; in one embodiment, the processor 1401 described above in the embodiments of the present application may be configured to perform a series of processes, including the steps involved in the method shown in fig. 1 and the various steps involved in fig. 2-13, and so on.
An embodiment of the present application further provides a computer storage medium (Memory), which is a Memory device in an electronic device and is used to store programs and data. It is understood that the computer storage medium herein may include both a built-in storage medium in the electronic device and, of course, an extended storage medium supported by the electronic device. Computer storage media provide storage space that stores an operating system for an electronic device. Also stored in this memory space are one or more instructions, which may be one or more computer programs (including program code), suitable for loading and execution by processor 1401. The computer storage medium may be a high-speed RAM memory, or may be a non-volatile memory (non-volatile memory), such as at least one disk memory; and optionally at least one computer storage medium located remotely from the processor.
In one embodiment, one or more instructions stored in a computer storage medium may be loaded and executed by processor 1401 to perform the corresponding steps in the above embodiments; in particular implementations, one or more instructions in the computer storage medium may be loaded by processor 1401 and executed to perform any step involved in the method shown in fig. 1 or any step involved in fig. 2-13, and thus, will not be described herein again.
It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and modules may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other ways. For example, the division of the module is only one logical division, and other divisions may be possible in actual implementation, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted, or not performed. The shown or discussed mutual coupling, direct coupling or communication connection may be an indirect coupling or communication connection of devices or modules through some interfaces, and may be in an electrical, mechanical or other form.
Modules described as separate parts may or may not be physically separate, and parts displayed as modules may or may not be physical modules, may be located in one place, or may be distributed on a plurality of network modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the present embodiment.
In the above embodiments, the implementation may be wholly or partially realized by software, hardware, firmware, or any combination thereof. When implemented in software, may be implemented in whole or in part in the form of a computer program product. The computer program product includes one or more computer instructions. The procedures or functions according to the embodiments of the present application are wholly or partially generated when the computer program instructions are loaded and executed on a computer. The computer may be a general purpose computer, a special purpose computer, a network of computers, or other programmable device. The computer instructions may be stored on or transmitted over a computer-readable storage medium. The computer instructions may be transmitted from one website, computer, server, or data center to another website, computer, server, or data center by wire (e.g., coaxial cable, fiber optic, Digital Subscriber Line (DSL)), or wirelessly (e.g., infrared, wireless, microwave, etc.). The computer-readable storage medium can be any available medium that can be accessed by a computer or a data storage device, such as a server, a data center, etc., that includes one or more of the available media. The usable medium may be a read-only memory (ROM), or a Random Access Memory (RAM), or a magnetic medium, such as a floppy disk, a hard disk, a magnetic tape, a magnetic disk, or an optical medium, such as a Digital Versatile Disk (DVD), or a semiconductor medium, such as a Solid State Disk (SSD).
Claims (10)
1. A method for generating a detection report, comprising:
acquiring a detection report template;
receiving a mail merging instruction, wherein the mail merging instruction carries a data source address, a worksheet identifier, a position to be filled and a project name to be filled;
responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data;
inserting a merging domain into the position to be filled of the detection report template to generate a target detection report file, wherein the merging domain is data corresponding to the name of the project to be filled in the worksheet, and the target detection report file comprises a document corresponding to the merging domain.
2. The method of claim 1, wherein the step of generating the consolidated data table comprises:
acquiring a file to be processed;
and generating the merged data table based on the file to be processed and the data merging function formula.
3. The method of claim 2, wherein generating the merged data table based on the pending file and data merge function formula comprises:
converting the file to be processed into a worksheet format, and acquiring a first worksheet corresponding to the file to be processed; establishing a second worksheet, wherein the head row and the head column in the second worksheet are respectively the same as the head row and the head column of the first worksheet;
acquiring an information table to be processed; inserting a new column into the second worksheet, wherein the new column is used for filling target data in the information table to be processed;
acquiring the data merging function formula, and searching the same data in the information table to be processed and the preset column of the first worksheet according to the data merging function formula to determine the corresponding filling position;
and adding the target data in the corresponding cells according to the filling positions in the second worksheet to obtain the merged data sheet.
4. The inspection report generation method according to claim 3, wherein after the obtaining of the first worksheet corresponding to the document to be processed, the method further comprises:
receiving a symbol removal instruction, the symbol removal instruction comprising a symbol removal function;
performing logic operations of the symbol clear function in response to the symbol clear instruction, the logic operations of the symbol clear function including:
if the last character of the original data in the first cell of the first worksheet is a preset symbol, returning and removing the reference data of the last character in a second cell corresponding to the first cell in a second worksheet; if not, returning the original data in the second cell.
5. The inspection report generation method according to claim 4, wherein after the obtaining of the first worksheet corresponding to the document to be processed, the method further comprises:
receiving selection operation of a user to determine a target cell;
and in response to an error checking instruction, emptying the empty character strings before and after the data in the target cell.
6. The inspection report generation method according to any one of claims 3 to 5, wherein after inserting a new column in the second worksheet, the method further comprises:
acquiring input function parameters, wherein the function parameters comprise a search value, a data table and a column ordinal number, the search value is a numerical value which needs to be searched in a preset column of the first worksheet, the data table comprises the information table to be processed and the first worksheet, and the column ordinal number is the number of the newly added columns;
and executing an insert function corresponding to the function parameter, searching the search value in the preset column, and returning the numerical value at the appointed column in the current row corresponding to the search value to the corresponding cell of the second worksheet.
7. The method of generating a test report according to claim 6, further comprising:
inserting a new add column into the second worksheet;
acquiring a preset comparison function, executing the logic operation of the preset comparison function to obtain the comparison result of two cells in different rows in the new added row, wherein the logic operation of the preset comparison function comprises the following steps:
when the cell data of the first column and the cell data of the second column in the two cells of different columns are matched, the comparison result is a consistent identifier; and when the cell data of the first column and the cell data of the second column are not matched, the comparison result is an alarm identifier.
8. An inspection report generation device, comprising:
the acquisition module is used for acquiring a detection report template;
the system comprises a setting module, a sending module and a processing module, wherein the setting module is used for receiving a mail merging instruction, and the mail merging instruction carries a data source address, a worksheet identifier, a position to be filled and a project name to be filled;
the processing module is used for responding to the mail merging instruction, acquiring a merged data table corresponding to the data source address, and acquiring a work table corresponding to the work table identifier in the merged data table, wherein the merged data table is generated by integrating data;
the processing module is further configured to insert a merge domain in the position to be filled of the detection report template, and generate a target detection report file, where the merge domain is data corresponding to the name of the project to be filled in the worksheet, and the target detection report file includes a document corresponding to the merge domain.
9. An electronic device, comprising a memory and a processor, the memory storing a computer program that, when executed by the processor, causes the processor to perform the steps of the detection report generation method according to any one of claims 1 to 7.
10. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, causes the processor to carry out the steps of the detection report generation method according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011051894.9A CN112163834A (en) | 2020-09-29 | 2020-09-29 | Detection report generation method, device, electronic equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011051894.9A CN112163834A (en) | 2020-09-29 | 2020-09-29 | Detection report generation method, device, electronic equipment and medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112163834A true CN112163834A (en) | 2021-01-01 |
Family
ID=73862196
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011051894.9A Pending CN112163834A (en) | 2020-09-29 | 2020-09-29 | Detection report generation method, device, electronic equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112163834A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268957A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Citation method for realizing intelligent generation of bidding document |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109948134A (en) * | 2019-03-21 | 2019-06-28 | 润电能源科学技术有限公司 | A kind of report automatic generation method, system and electronic equipment and storage medium |
-
2020
- 2020-09-29 CN CN202011051894.9A patent/CN112163834A/en active Pending
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109948134A (en) * | 2019-03-21 | 2019-06-28 | 润电能源科学技术有限公司 | A kind of report automatic generation method, system and electronic equipment and storage medium |
Non-Patent Citations (5)
| Title |
|---|
| EXCEL函数编程可视化: ""Excel四大文本清洗类函数，数据清洗轻松搞定"", Retrieved from the Internet <URL:《https://baijiahao.baidu.com/s?id=1636775654360422607&wfr=spider&for=pc》> * |
| 剩矿空钱: ""office软件干货！邮件合并的使用技巧"", Retrieved from the Internet <URL:《http://www.360doc.com/content/18/0601/13/28740943_758738266.shtml》> * |
| 吾茶道: ""干货|如何自动生成银行调查报告模板，建议收藏"", Retrieved from the Internet <URL:《https://baijiahao.baidu.com/s?id=1663354623701245245&wfr=spider&for=pc》> * |
| 此账号已注销: ""如何将excel中的多个sheet表进行数据合并"", Retrieved from the Internet <URL:《https://jingyan.baidu.com/article/03b2f78cba73771ea237ae8a.html》> * |
| 繁花似锦0755: ""如何利用EXCEL函数核对单元格中的数据是否一致"", Retrieved from the Internet <URL:《https://jingyan.baidu.com/article/c35dbcb01b43f2c917fcbc79.html》> * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113268957A (en) * | 2021-03-19 | 2021-08-17 | 广州天越电子科技有限公司 | Citation method for realizing intelligent generation of bidding document |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112035667B (en) | Knowledge graph display method and device and terminal equipment | |
| CN109669933B (en) | Transaction data intelligent processing method and device and computer readable storage medium | |
| CN110738037B (en) | Method, apparatus, device and storage medium for automatically generating electronic form | |
| CN107229750B (en) | Table data processing method, device, storage medium and processor | |
| US20070255512A1 (en) | Methods and systems for facilitating analysis of feature extraction outputs | |
| CN110489481B (en) | Data analysis method and device for industry data and data analysis server | |
| KR102038092B1 (en) | Apparatus and Method for automatic generation of Electric Design Drawings | |
| WO2006075667A1 (en) | Information processing device, file data merging method, file naming method, and file data output method | |
| CN109801677B (en) | Sequencing data automatic analysis method and device and electronic equipment | |
| US20080189639A1 (en) | Dynamically detecting exceptions based on data changes | |
| CN102067117B (en) | Method for displaying and operating table | |
| CN110059121B (en) | Method, system, device and storage medium for rapidly exporting bill of materials | |
| CN112818937B (en) | Excel file identification method and device, electronic equipment and readable storage medium | |
| WO2021219066A1 (en) | Document processing method and apparatus, and electronic device | |
| CN110728124A (en) | Method, apparatus, device and storage medium for visualizing electronic forms | |
| CN110795464A (en) | Method, device, terminal and storage medium for checking field of object marker data | |
| CN112163834A (en) | Detection report generation method, device, electronic equipment and medium | |
| CN114207598A (en) | Electronic form conversion | |
| US20140033079A1 (en) | Quick filter pattern | |
| CN108133048A (en) | file ordering method, device and mobile terminal | |
| CN107644102B (en) | Data feature construction method and device, storage medium and electronic equipment | |
| CN109493918B (en) | Biological data management and phylogenetic analysis process method | |
| CN110780970A (en) | Data screening method, device, equipment and computer readable storage medium | |
| Setiyanto et al. | Data science with excel | |
| KR102099362B1 (en) | Device and method for a data preparation using a micro service |
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 |