Evaluation method and device of test report table and electronic equipment
By analyzing and updating the test report form, the problem of inefficient analysis of new energy vehicle test report is solved, dynamic evaluation and update of the table is realized, evaluation efficiency and accuracy are improved, and manpower and cost consumption is reduced.
Patent Information
- Application Number
- CN202411202018.X
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-29
- Publication Date
- 2024-12-06
AI Technical Summary
The existing technology is inefficient in the analysis and sorting of new energy vehicle test reports, has a large workload, and is unable to effectively update the topological structure of the table, resulting in increased manpower and material expenditure and cost.
By obtaining basic template tables and test report tables, analyzing table header data, filling and updating tables, generating detailed pages, and performing weight estimation, dynamic evaluation and update of tables are realized, and dependence on databases and manual operations is reduced.
It improves the availability and evaluation efficiency of test reports, improves the accuracy of evaluation, reduces the burden of manpower and material resources, and reduces costs.
Smart Images

Figure CN119089877A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a method, device, electronic device and storage medium for evaluating a test report form. Background Art
[0002] During the testing process of new energy vehicles, a large number of test items and test cases will be generated. It is essential to generate test reports based on these test items and test cases, and analyze and summarize the test reports. In the existing technology, when analyzing and collating test reports, testers usually spend a lot of time and energy to organize, analyze, extract key items and evaluate them. The workload is large, the work is repetitive, and it is relatively cumbersome, which greatly affects work efficiency.
[0003] The Excel spreadsheet automatic generation method in the prior art cannot be directly used for the solution of new energy vehicle test result report analysis, and the Excel spreadsheet automatic generation method in the prior art cannot make a detailed description of the topology structure update method in the spreadsheet. Summary of the invention
[0004] The purpose of this application is to provide a test report form evaluation method, device, electronic device and storage medium, which can more effectively process and analyze test reports, improve the availability of test reports, enhance the evaluation efficiency and accuracy of test reports, increase the analysis of the form topology structure, and realize dynamic evaluation and update of the form without relying on databases and manual operations, thereby reducing the consumption of manpower and material resources and reducing costs.
[0005] In a first aspect, an embodiment of the present application provides a method for evaluating a test report form, the method comprising:
[0006] Get the basic template form and test report form;
[0007] Parsing the information source in the test report form to obtain header data;
[0008] Fill the header data into the basic template table;
[0009] Update the filled basic template table to generate a detailed page;
[0010] The detailed page is weighted and an evaluation result is obtained.
[0011] In the above implementation process, the information in the test report table is parsed and filled into the basic template table, and updated in real time. This can more effectively process and analyze the test report, improve the availability of the test report, and improve the evaluation efficiency and accuracy of the test report. It also adds parsing of the table topology structure, realizes dynamic evaluation and updating of the table, and does not rely on databases and manual operations, which can reduce the consumption of manpower and material resources and reduce costs.
[0012] Furthermore, the step of parsing the information source in the test report form to obtain header data includes:
[0013] Extracting cell information from the information source;
[0014] Mapping is performed according to the topological relationship between each cell information to obtain dictionary information with topological relationship;
[0015] The dictionary information having the topological relationship is determined as the header data.
[0016] In the above implementation process, by parsing the topological relationship between each cell information, the link relationship and dependency relationship between cells can be obtained more clearly and explicitly, which facilitates the dynamic adjustment of the table.
[0017] Furthermore, the step of updating the filled basic template table to generate a detailed page includes:
[0018] Traverse the cells of the filled basic template table to obtain the value of each cell of the filled basic template table;
[0019] Merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table;
[0020] The detailed page is generated according to the updated basic template table.
[0021] In the above implementation process, traversing the cells of the filled basic template table and then merging the cells can realize rapid updating of the basic template table, improve dynamic adjustment of data, and facilitate real-time interaction of detailed pages.
[0022] Furthermore, the step of merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table includes:
[0023] Determine whether the value of the cell is the threshold;
[0024] If yes, mark the merge start position of the cell, and merge each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table;
[0025] If not, save the value of the current cell as the value of the previous cell.
[0026] In the above implementation process, the cells are marked at their merging starting positions before merging, so that each cell that needs to be merged can be obtained quickly and accurately, ensuring that the cells are merged accurately and reducing errors in the merging process.
[0027] Furthermore, the step of merging each cell of the filled basic template table according to the marked merging starting position to obtain an updated basic template table includes:
[0028] Determine whether there are cells that need to be merged continuously based on the marked merge start position;
[0029] If so, the first function is called to merge each cell of the filled basic template table to obtain merge information, and the updated basic template table is obtained according to the merge information.
[0030] In the above implementation process, when there are cells that need to be merged continuously, the first function is called to fill them, so that the cells can be adjusted in real time as needed during the merging process, the wrong cells can be avoided, and the accuracy can be improved.
[0031] Furthermore, the step of estimating the weight of the detailed page to obtain an evaluation result includes:
[0032] Read the file name in the detail page;
[0033] Obtain test results of the file name in different table files;
[0034] Marking the test results with different colors according to the file names to obtain test results with different color marks;
[0035] Obtaining an average value of the test results including the different color marks;
[0036] The evaluation result is obtained according to the average value.
[0037] In the above implementation process, by color-marking the test results according to the file name in the detail page, the location of the test item corresponding to each file name can be quickly and accurately obtained, thereby achieving efficient evaluation and improving evaluation efficiency and accuracy.
[0038] Furthermore, the step of obtaining the evaluation result according to the average value comprises:
[0039] Determine whether the average value can generate an evaluation result according to the user indicator;
[0040] If yes, obtain an evaluation index value according to the average value, perform evaluation index analysis on the evaluation index value, and obtain the evaluation result.
[0041] In the above implementation process, whether the average value can generate an evaluation result is determined based on the user indicators. The average value can be used to improve the accuracy of the evaluation result, avoid secondary evaluation caused by the evaluation result not meeting the requirements, and realize real-time interaction.
[0042] In a second aspect, an embodiment of the present application further provides a test report form evaluation device, the device comprising:
[0043] The acquisition module is used to obtain the basic template form and the test report form;
[0044] A parsing module, used for parsing the information source in the test report form to obtain header data;
[0045] A filling module, used to fill the header data into the basic template table;
[0046] The update module is used to update the filled basic template table and generate a detailed page;
[0047] The estimation module is used to estimate the weight of the detailed page to obtain an evaluation result.
[0048] In the above implementation process, the information in the test report table is parsed and filled into the basic template table, and updated in real time. This can more effectively process and analyze the test report, improve the availability of the test report, and improve the evaluation efficiency and accuracy of the test report. It also adds parsing of the table topology structure, realizes dynamic evaluation and updating of the table, and does not rely on databases and manual operations, which can reduce the consumption of manpower and material resources and reduce costs.
[0049] In a third aspect, an embodiment of the present application provides an electronic device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the method described in any one of the first aspects when executing the computer program.
[0050] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, on which instructions are stored. When the instructions are executed on a computer, the computer executes the method as described in any one of the first aspects.
[0051] In a fifth aspect, an embodiment of the present application provides a computer program product, which, when running on a computer, enables the computer to execute the method as described in any one of the first aspects.
[0052] Other features and advantages of the present disclosure will be set forth in the following description, or some features and advantages may be inferred or unambiguously determined from the description, or may be learned by implementing the above-mentioned technology of the present disclosure.
[0053] And it can be implemented according to the contents of the specification. The following is a detailed description of the preferred embodiments of the present application with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS
[0054] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for use in the embodiments of the present application will be briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present application and therefore should not be regarded as limiting the range values. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying any creative work.
[0055] Figure 1 A flow chart of a method for evaluating a test report form provided in an embodiment of the present application;
[0056] Figure 2 A schematic diagram of the structural composition of an evaluation device for a test report form provided in an embodiment of the present application;
[0057] Figure 3 A schematic diagram of the structural composition of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0058] The technical solutions in the embodiments of the present application will be described below in conjunction with the drawings in the embodiments of the present application.
[0059] It should be noted that similar reference numerals and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in subsequent drawings. At the same time, in the description of this application, the terms "first", "second", etc. are only used to distinguish the description and cannot be understood as indicating or implying relative importance.
[0060] The specific implementation methods of the present application are further described in detail below in conjunction with the accompanying drawings and examples. The following examples are used to illustrate the present application, but are not used to limit the scope of the present application.
[0061] Embodiment 1
[0062] Figure 1 is a flow chart of the evaluation method of the test report form provided in the embodiment of the present application, such as Figure 1 As shown, the method includes:
[0063] S1, obtain the basic template form and test report form;
[0064] S2, parsing the information source in the test report table to obtain the header data;
[0065] S3, fill the header data into the basic template table;
[0066] S4, updating the filled basic template table to generate a detailed page;
[0067] S5, weight estimation is performed on the detailed page to obtain an evaluation result.
[0068] In the above implementation process, the information in the test report table is parsed and filled into the basic template table, and updated in real time. This can more effectively process and analyze the test report, improve the availability of the test report, and improve the evaluation efficiency and accuracy of the test report. It also adds parsing of the table topology structure, realizes dynamic evaluation and updating of the table, and does not rely on databases and manual operations, which can reduce the consumption of manpower and material resources and reduce costs.
[0069] The user needs to enter the basic template form, which includes type, test item, report name (test indicator), result calculation method, test case name, score, user-defined scoring criteria, weight and other information.
[0070] Furthermore, S2 includes:
[0071] Extract cell information from the information source;
[0072] Mapping is performed according to the topological relationship between each cell information to obtain dictionary information with topological relationship;
[0073] The dictionary information having a topological relationship is determined as the header data.
[0074] In the above implementation process, by parsing the topological relationship between each cell information, the link relationship and dependency relationship between cells can be obtained more clearly and explicitly, which facilitates the dynamic adjustment of the table.
[0075] According to the information of the basic template table, that is, the information source, an excel file containing specific test results. The information and structure of various tables are different. This application uses the cell information read by OpenPyXL to determine the topological relationship between each cell and map it to the cell information.
[0076] The embodiment of the present application can obtain dictionary information with topological relationships by inputting header information, and fill it into the basic template table. Since the number of use cases in the test results is uncertain, the table and its topological structure will be updated in the basic template table according to the number of use cases.
[0077] Furthermore, S4 includes:
[0078] Traverse the cells of the filled basic template table to obtain the value of each cell of the filled basic template table;
[0079] Merge each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table;
[0080] Generate a detailed page based on the updated basic template table.
[0081] In the above implementation process, traversing the cells of the filled basic template table and then merging the cells can realize rapid updating of the basic template table, improve dynamic adjustment of data, and facilitate real-time interaction of detailed pages.
[0082] The embodiment of the present application merges cells by column (vertical direction), traverses the cells in the specified column, and decides whether to perform the merge operation based on the value of the cell.
[0083] Before traversing, you need to initialize the starting row, the ending row, and the last processed row.
[0084] Further, the step of merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table includes:
[0085] Determine whether the value of the cell is the threshold;
[0086] If yes, mark the merge start position of the cell, and merge each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table;
[0087] If not, save the value of the current cell as the value of the previous cell.
[0088] In the above implementation process, the cells are marked at their merging starting positions before merging, so that each cell that needs to be merged can be obtained quickly and accurately, ensuring that the cells are merged accurately and reducing errors in the merging process.
[0089] Traverse each cell in the column. If the cell value is 'merge' (threshold), mark the merge start position. If it is not 'merge', save the current value as the previous value for subsequent fill operations.
[0090] Further, the step of merging each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table includes:
[0091] Determine whether there are cells that need to be merged continuously based on the marked merge start position;
[0092] If so, call the first function to merge each cell of the filled basic template table to obtain merge information, and obtain the updated basic template table according to the merge information.
[0093] In the above implementation process, when there are cells that need to be merged continuously, the first function is called to fill them, so that the cells can be adjusted in real time as needed during the merging process, the wrong cells can be avoided, and the accuracy can be improved.
[0094] When continuous cells that need to be merged are found, the sheet.merge_cells() method (the first function) is called to perform the actual merge and record the merge information. When processing to the bottom of the table, it is necessary to ensure that the last possible merge operation is also completed. A list containing the merge information is returned, and each element is a dictionary that records the start row, end row, start column, and end column of the merge.
[0095] Optionally, when merging is required based on the merged results of other columns, the dependency relationship between cells is configured based on the key-value pair, each column in the table is traversed, and it is determined based on the dependency relationship whether the current column needs to be merged based on the merged results of other columns. If necessary, the merge is performed according to the above merging process.
[0096] This application needs to generate a new page in the basic template table to display the detailed information of the test report (detailed page), and generate a new detailed page for each test item. The test item contains test function items, and the test function items contain test cases.
[0097] Furthermore, S5 includes:
[0098] Read the file name in the detail page;
[0099] Get the test results of file names in different table files;
[0100] Mark the test results with different colors according to the file names;
[0101] Get the average value of the test results with different color markings;
[0102] The evaluation results are obtained based on the average value.
[0103] In the above implementation process, by color-marking the test results according to the file name in the detail page, the location of the test item corresponding to each file name can be quickly and accurately obtained, thereby achieving efficient evaluation and improving evaluation efficiency and accuracy.
[0104] Furthermore, the step of obtaining the evaluation result according to the average value includes:
[0105] Determine whether the average value can generate an evaluation result based on the user indicators;
[0106] If yes, obtain the evaluation index value according to the average value, perform evaluation index analysis on the evaluation index value, and obtain the evaluation result.
[0107] In the above implementation process, whether the average value can generate an evaluation result is determined based on the user indicators. The average value can be used to improve the accuracy of the evaluation result, avoid secondary evaluation caused by the evaluation result not meeting the requirements, and realize real-time interaction.
[0108] Different files may be generated for the same test item. You need to distinguish the results in different files by color and calculate the average. For example, if there are 4 test results in the first file and 3 test results in the second file, the 7 results will be displayed in the detail page, and the 4th result and 3rd result will be distinguished by color. Calculate the average of the 7 results.
[0109] This application supports users to manually modify the evaluation results. Users choose whether to modify the evaluation results generated at this stage. If no modification is required, the result values of the test cases are averaged to obtain the value of the test indicator (evaluation indicator value).
[0110] Parse the scoring criteria, calculate the corresponding score according to the numerical range represented by the pre-set symbols, and then calculate the total score according to the weight of each test item. For example, first remove special symbols such as "ms" and "%", and then split into an array according to the line break "\n". The data in the array is a range value or a single value. If it is a single value, when the result is equal to the value, the corresponding score is returned directly. If it is a range value. Then determine whether it contains a combination of two of the four symbols "<", ">", "<=", ">=", or a combination of two of the four symbols "(", "[", "]", ")". If the value is within its range, return the corresponding score.
[0111] This application can automatically generate a scoring report based on the data by automatically deleting and adding columns. At the same time, all detailed results in the report can be displayed, making it convenient for users to observe data changes. This saves a lot of manpower and time costs. In conjunction with the upstream test report generation process, integrated testing can be further achieved.
[0112] Embodiment 2
[0113] In order to execute the method corresponding to the above embodiment 1 to achieve the corresponding functions and technical effects, a test report form evaluation device is provided below, such as Figure 2 As shown, the device comprises:
[0114] Acquisition module 1, used to obtain the basic template form and the test report form;
[0115] Parsing module 2, used to parse the information source in the test report table to obtain the header data;
[0116] Filling module 3, used to fill the header data into the basic template table;
[0117] Update module 4, used to update the filled basic template table and generate a detailed page;
[0118] The estimation module 5 is used to estimate the weight of the detailed page and obtain the evaluation result.
[0119] In the above implementation process, the information in the test report table is parsed and filled into the basic template table, and updated in real time. This can more effectively process and analyze the test report, improve the availability of the test report, and improve the evaluation efficiency and accuracy of the test report. It also adds parsing of the table topology structure, realizes dynamic evaluation and updating of the table, and does not rely on databases and manual operations, which can reduce the consumption of manpower and material resources and reduce costs.
[0120] Furthermore, S2 includes:
[0121] Extract cell information from the information source;
[0122] Mapping is performed according to the topological relationship between each cell information to obtain dictionary information with topological relationship;
[0123] The dictionary information having a topological relationship is determined as the header data.
[0124] In the above implementation process, by parsing the topological relationship between each cell information, the link relationship and dependency relationship between cells can be obtained more clearly and explicitly, which facilitates the dynamic adjustment of the table.
[0125] Furthermore, S4 includes:
[0126] Traverse the cells of the filled basic template table to obtain the value of each cell of the filled basic template table;
[0127] Merge each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table;
[0128] Generate a detailed page based on the updated basic template table.
[0129] In the above implementation process, traversing the cells of the filled basic template table and then merging the cells can realize rapid updating of the basic template table, improve dynamic adjustment of data, and facilitate real-time interaction of detailed pages.
[0130] Further, the step of merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table includes:
[0131] Determine whether the value of the cell is the threshold;
[0132] If yes, mark the merge start position of the cell, and merge each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table;
[0133] If not, save the value of the current cell as the value of the previous cell.
[0134] In the above implementation process, the cells are marked at their merging starting positions before merging, so that each cell that needs to be merged can be obtained quickly and accurately, ensuring that the cells are merged accurately and reducing errors in the merging process.
[0135] Further, the step of merging each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table includes:
[0136] Determine whether there are cells that need to be merged continuously based on the marked merge start position;
[0137] If so, call the first function to merge each cell of the filled basic template table to obtain merge information, and obtain the updated basic template table according to the merge information.
[0138] In the above implementation process, when there are cells that need to be merged continuously, the first function is called to fill them, so that the cells can be adjusted in real time as needed during the merging process, the wrong cells can be avoided, and the accuracy can be improved.
[0139] Furthermore, S5 includes:
[0140] Read the file name in the detail page;
[0141] Get the test results of file names in different table files;
[0142] Mark the test results with different colors according to the file names;
[0143] Get the average value of the test results with different color markings;
[0144] The evaluation results are obtained based on the average value.
[0145] In the above implementation process, by color-marking the test results according to the file name in the detail page, the location of the test item corresponding to each file name can be quickly and accurately obtained, thereby achieving efficient evaluation and improving evaluation efficiency and accuracy.
[0146] Furthermore, the step of obtaining the evaluation result according to the average value includes:
[0147] Determine whether the average value can generate an evaluation result based on the user indicators;
[0148] If yes, obtain the evaluation index value according to the average value, perform evaluation index analysis on the evaluation index value, and obtain the evaluation result.
[0149] In the above implementation process, whether the average value can generate an evaluation result is determined based on the user indicators. The average value can be used to improve the accuracy of the evaluation result, avoid secondary evaluation caused by the evaluation result not meeting the requirements, and realize real-time interaction.
[0150] The evaluation device of the test report form described above can implement the method of the above embodiment 1. The options in the above embodiment 1 are also applicable to this embodiment and will not be described in detail here.
[0151] The rest of the contents of the embodiments of the present application can refer to the contents of the above-mentioned embodiment 1, and will not be repeated in this embodiment.
[0152] Embodiment 3
[0153] An embodiment of the present application provides an electronic device, including a memory and a processor, wherein the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the test report form evaluation method of the first embodiment.
[0154] Optionally, the above-mentioned electronic device may be a server.
[0155] See also Figure 3 , Figure 3A schematic diagram of the structure of an electronic device provided in an embodiment of the present application. The electronic device may include a processor 31, a communication interface 32, a memory 33 and at least one communication bus 34. The communication bus 34 is used to realize direct connection and communication between these components. The communication interface 32 of the device in the embodiment of the present application is used to communicate signaling or data with other node devices. The processor 31 may be an integrated circuit chip with signal processing capabilities.
[0156] The processor 31 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The methods, steps and logic block diagrams disclosed in the embodiments of the present application can be implemented or executed. The general-purpose processor can be a microprocessor or the processor 31 can also be any conventional processor, etc.
[0157] The memory 33 may be, but is not limited to, a random access memory (RAM), a read only memory (ROM), a programmable read-only memory (PROM), an erasable programmable read-only memory (EPROM), an electric erasable programmable read-only memory (EEPROM), etc. The memory 33 stores computer readable instructions. When the computer readable instructions are executed by the processor 31, the device can execute the above-mentioned Figure 1 The method embodiment involves various steps.
[0158] Optionally, the electronic device may further include a storage controller and an input / output unit. The memory 33, the storage controller, the processor 31, the peripheral interface, and the input / output unit are electrically connected to each other directly or indirectly to achieve data transmission or interaction. For example, these components may be electrically connected to each other via a communication bus 34. The processor 31 is used to execute executable modules stored in the memory 33, such as software function modules or computer programs included in the device.
[0159] The input and output unit is used to provide users with the task creation and to create an optional time period or preset execution time for the task to enable interaction between the user and the server. The input and output unit can be, but is not limited to, a mouse and a keyboard.
[0160] Understandably, Figure 3 The structure shown is for illustration only. The electronic device may also include Figure 3 More or fewer components as shown, or with Figure 3 Different configurations shown. Figure 3 Each component shown in the figure can be implemented by hardware, software or a combination thereof.
[0161] In addition, an embodiment of the present application further provides a computer-readable storage medium storing a computer program, which implements the evaluation method of the test report form of the first embodiment when the computer program is executed by a processor.
[0162] The embodiment of the present application also provides a computer program product, which, when running on a computer, enables the computer to execute the method described in the method embodiment.
[0163] In several embodiments provided in the present application, it should be understood that the disclosed devices and methods can also be implemented in other ways. The device embodiments described above are merely schematic. For example, the flowcharts and block diagrams in the accompanying drawings show the possible architecture, functions and operations of the devices, methods and computer program products according to multiple embodiments of the present application. In this regard, each box in the flowchart or block diagram can represent a module, a program segment or a part of a code, and the module, a program segment or a part of a code contains one or more executable instructions for implementing the specified logical function. It should also be noted that in some alternative implementations, the functions marked in the box can also occur in a different order from the order marked in the accompanying drawings. For example, two consecutive boxes can actually be executed substantially in parallel, and they can sometimes be executed in the opposite order, depending on the functions involved. It should also be noted that each box in the block diagram and / or the flowchart, and the combination of boxes in the block diagram and / or the flowchart, can be implemented with a dedicated hardware-based device that performs a specified function or action, or can be implemented with a combination of dedicated hardware and computer instructions.
[0164] In addition, the functional modules in the various embodiments of the present application may be integrated together to form an independent part, or each module may exist separately, or two or more modules may be integrated to form an independent part.
[0165] If the functions are implemented in the form of software function modules and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application can be essentially or partly embodied in the form of a software product that contributes to the prior art. The computer software product is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present application. The aforementioned storage medium includes: various media that can store program codes, such as USB flash drives, mobile hard drives, ROM, RAM, magnetic disks, or optical disks.
[0166] The above description is only an embodiment of the present application and is not intended to limit the protection scope of the present application. For those skilled in the art, the present application may have various changes and variations. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present application should be included in the protection scope of the present application. It should be noted that similar numbers and letters represent similar items in the following drawings, so once an item is defined in one drawing, it does not need to be further defined and explained in the subsequent drawings.
[0167] The above is only a specific implementation of the present application, but the protection range of the present application is not limited thereto. Any technician familiar with the technical field can easily think of changes or substitutions within the technical range disclosed in the present application, which should be included in the protection range of the present application. Therefore, the protection range of the present application should be based on the protection range of the claims.
[0168] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.
Claims
1. A method for evaluating a test report form, characterized in that: The method comprises: Get the basic template form and test report form; Parsing the information source in the test report form to obtain header data; Fill the header data into the basic template table; Update the filled basic template table to generate a detailed page; The detailed page is weighted and an evaluation result is obtained.
2. The test report form evaluation method according to claim 1, characterized in that: The step of parsing the information source in the test report form to obtain header data includes: Extracting cell information from the information source; Mapping is performed according to the topological relationship between each cell information to obtain dictionary information with topological relationship; The dictionary information having the topological relationship is determined as the header data.
3. The test report form evaluation method according to claim 1, characterized in that: The step of updating the filled basic template table to generate a detailed page includes: Traverse the cells of the filled basic template table to obtain the value of each cell of the filled basic template table; Merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table; The detailed page is generated according to the updated basic template table.
4. The test report form evaluation method according to claim 3, characterized in that: The step of merging each cell of the filled basic template table according to the value of each cell to obtain an updated basic template table includes: Determine whether the value of the cell is the threshold; If yes, mark the merge start position of the cell, and merge each cell of the filled basic template table according to the marked merge start position to obtain an updated basic template table; If not, save the value of the current cell as the value of the previous cell.
5. The test report form evaluation method according to claim 4, characterized in that: The step of merging each cell of the filled basic template table according to the marked merging starting position to obtain an updated basic template table includes: Determine whether there are cells that need to be merged continuously based on the marked merge start position; If so, the first function is called to merge each cell of the filled basic template table to obtain merge information, and the updated basic template table is obtained according to the merge information.
6. The test report form evaluation method according to claim 1, characterized in that: The step of performing weight estimation on the detailed page to obtain an evaluation result includes: Read the file name in the detail page; Obtain test results of the file name in different table files; Marking the test results with different colors according to the file names to obtain test results with different color marks; Obtaining an average value of the test results including the different color marks; The evaluation result is obtained according to the average value.
7. The test report form evaluation method according to claim 6, characterized in that: The step of obtaining the evaluation result according to the average value comprises: Determine whether the average value can generate an evaluation result according to the user indicator; If yes, obtain an evaluation index value according to the average value, perform evaluation index analysis on the evaluation index value, and obtain the evaluation result.
8. An evaluation device for a test report form, characterized in that: The device comprises: The acquisition module is used to obtain the basic template form and the test report form; A parsing module, used for parsing the information source in the test report form to obtain header data; A filling module, used to fill the header data into the basic template table; The update module is used to update the filled basic template table and generate a detailed page; The estimation module is used to perform weight estimation on the detailed page to obtain an evaluation result.
9. An electronic device, characterized in that: The electronic device comprises a memory and a processor, wherein the memory is used to store a computer program, and the processor runs the computer program to enable the electronic device to execute the evaluation method of the test report form according to any one of claims 1 to 7.
10. A storage medium, characterized in that: A computer program is stored therein, and when the computer program is executed by a processor, the evaluation method of the test report form according to any one of claims 1 to 7 is implemented.
Citation Information
Cited By
Intelligent generation method for enterprise final settlement report
CN119862867A
