Data processing method and device, computer equipment, storage medium and program product

By using data processing methods for LNG module weight control information and leveraging Excel's pivot table function to preprocess and categorize the active worksheet, the problems of long data aggregation time and high error rate were solved, achieving efficient and accurate data merging and display.

CN119046370APending Publication Date: 2024-11-29SHANGHAI WISON OFFSHORE & MARINE CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202411234788.2
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-09-04
Publication Date
2024-11-29

AI Technical Summary

Technical Problem

Existing technologies are time-consuming and prone to errors in the process of summarizing LNG module weight control information data, resulting in low efficiency.

Method used

By preprocessing the activity worksheet, determining the search scope and filtering conditions, finding data tables that meet the conditions, and copying their contents to the summary table according to preset rules, Excel's pivot table function is used for classification, summarization, and display.

Benefits of technology

It enables the rapid and accurate merging of multiple data tables into one table, reducing the data error rate, improving processing efficiency, and intuitively displaying the weight distribution information of various professional components of the LNG module, facilitating monitoring and management.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119046370A_ABST
    Figure CN119046370A_ABST
Patent Text Reader

Abstract

The invention relates to a data processing method and device, computer equipment, a storage medium and a program product. The method comprises the following steps: preprocessing an activity worksheet to obtain a to-be-summarized table; wherein the activity worksheet refers to the worksheet of the current operation; determining a retrieval range and a screening condition corresponding to the to-be-summarized data; searching a plurality of data tables meeting screening conditions according to the retrieval range; copying contents in the data table into the to-be-summarized table according to a preset rule to obtain a target table; reading the content in the target table, and performing classification and summarization according to each professional weight of the liquefied natural gas module to obtain a classification and summarization result; and the data perspective table is called, and a classified summarizing result is displayed, and the classified summarizing result comprises the distribution information of the weight of each specialty of the liquefied natural gas module. Therefore, the distribution information of each professional weight of the liquefied natural gas module can be visually displayed, the data processing efficiency is high, and the error rate is low.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a data processing method, apparatus, computer equipment, computer-readable storage medium, and computer program product. Background Art

[0002] With the rapid growth of global LNG (Liquid Natural Gas) trade and the shipping industry's attention to carbon emission reduction technologies, the demand for LNG modular projects for LNG processing is also growing. Among them, weight control has an important impact on the cost control, transportation safety and economic benefits of LNG module projects. The collection and summary of weight control information is usually done by engineers manually copying and pasting.

[0003] In order to improve efficiency, some people have proposed the use of multiple Excel workbook interactive use technology, which is to aggregate the contents of various Excel tables into a single Excel table, and then classify and filter the data in the Excel table to quickly find the content that users are concerned about.

[0004] However, there is a lot of information data on the weight control of the LNG module. If the existing technology is used, there are problems such as long data aggregation time and data errors. Summary of the invention

[0005] Based on this, it is necessary to provide a data processing method, device, computer equipment, computer-readable storage medium and computer program product that can effectively improve processing efficiency and reduce data error rate in response to the above technical problems.

[0006] In a first aspect, the present application provides a data processing method, comprising:

[0007] Preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0008] Determine the search scope and screening conditions corresponding to the data to be summarized;

[0009] According to the search scope, a number of data tables meeting the screening conditions are found;

[0010] Copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0011] Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0012] The pivot table is retrieved to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

[0013] In one embodiment, the preprocessing of the active worksheet to obtain the table to be summarized includes:

[0014] Determine whether the active worksheet is a blank sheet;

[0015] If it is not a blank table, clear the original data, format and comments in the active worksheet to obtain the table to be summarized;

[0016] If it is a blank table, the blank table is used as the table to be summarized.

[0017] In one embodiment, determining the search scope and screening conditions corresponding to the data to be aggregated includes:

[0018] Determine at least one workbook and use the workbook as a search range; wherein each table in the workbook pre-stores weight control information of the liquefied natural gas module;

[0019] According to the naming rules of the liquefied natural gas module for each professional weight, the names of all tables containing the data to be summarized are determined, and the table names are used as screening conditions; wherein the data to be summarized include: each professional weight of the liquefied natural gas module.

[0020] In one embodiment, the searching according to the search scope to find several data tables that meet the screening condition includes:

[0021] A loop statement is used to traverse the table name of each table in the workbook, and to determine whether the table name of each table is consistent with the table name indicated by the i-th filtering condition, where i=1,2,3,…,N; N represents the total number of filtering conditions, and N is a natural number greater than 1;

[0022] If the table name is consistent with the table name indicated by the i-th filtering condition, the corresponding table is used as the data table that meets the filtering condition.

[0023] In one embodiment, the content in the data table is copied to the table to be summarized according to a preset rule to obtain a target table, including:

[0024] Assume that there are M data tables, where M is a natural number greater than 1.

[0025] Copying the contents of the M data tables to the table to be summarized in sequence, wherein after copying the contents of each data table, moving the cursor to the next row to copy the contents of the next data table;

[0026] Determine whether all M data tables have been copied;

[0027] If all the data have been copied, a dialog box will pop up to prompt that the data merge is complete;

[0028] If not all data tables have been copied, continue to obtain the next uncopied data table until all data tables have been copied.

[0029] In one embodiment, calling a pivot table to display the results of classification and aggregation includes:

[0030] Based on the PivotTable function in Excel, the results of the classification summary are specified as the table area;

[0031] Insert a weight control data table in the table area, and set row filter items, column filter items, and value filter items of the weight control data table; wherein the row filter items include: version number, module name, professional name; the column filter items include: value; the value filter items include: weight information;

[0032] Set the field type of the value filter item to sum;

[0033] Select a data display chart to display the weight control data table, and the display chart includes: any one of a pie chart, a histogram, and a line chart.

[0034] In a second aspect, the present application further provides a data processing device, comprising:

[0035] A preprocessing module, used for preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0036] A determination module is used to determine the search scope and screening conditions corresponding to the data to be summarized;

[0037] A search module, used to search for a number of data tables that meet the screening conditions according to the search scope;

[0038] A merging module, used for copying the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0039] A summary module is used to read the content in the target table and classify and summarize it according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0040] The display module is used to call the pivot table to display the results of classification and summary, wherein the results of classification and summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

[0041] In a third aspect, the present application further provides a computer device, including a memory and a processor, wherein the memory stores a computer program, and when the processor executes the computer program, the following steps are implemented:

[0042] Preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0043] Determine the search scope and screening conditions corresponding to the data to be summarized;

[0044] According to the search scope, a number of data tables meeting the screening conditions are found;

[0045] Copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0046] Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0047] The pivot table is retrieved to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

[0048] In a fourth aspect, the present application further provides a computer-readable storage medium having a computer program stored thereon, wherein when the computer program is executed by a processor, the following steps are implemented:

[0049] Preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0050] Determine the search scope and screening conditions corresponding to the data to be summarized;

[0051] According to the search scope, a number of data tables meeting the screening conditions are found;

[0052] Copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0053] Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0054] The pivot table is retrieved to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

[0055] In a fifth aspect, the present application further provides a computer program product, including a computer program, which implements the following steps when executed by a processor:

[0056] Preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0057] Determine the search scope and screening conditions corresponding to the data to be summarized;

[0058] According to the search scope, a number of data tables meeting the screening conditions are found;

[0059] Copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0060] Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0061] The pivot table is retrieved to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

[0062] The above-mentioned data processing method, device, computer equipment, computer-readable storage medium and computer program product obtain the table to be summarized by preprocessing the active worksheet; wherein the active worksheet refers to the worksheet currently being operated; thereby the active worksheet can be reused and the final data can be summarized into the active worksheet. Determine the search range and screening conditions corresponding to the data to be summarized; thereby the data to be summarized can be found accurately and quickly. According to the search range, find several data tables that meet the screening conditions; copy the contents in the data table to the table to be summarized according to the preset rules to obtain the target table; thereby multiple different data tables can be merged and summarized into one table to achieve one-key update without tedious search. Read the contents in the target table, and classify and summarize them according to the various professional weights of the liquefied natural gas module to obtain the results of the classification summary; implement the classification and summary processing of the data in the merged table to obtain the results of the classification summary of the various professional weights of the liquefied natural gas module. Retrieve the pivot table to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the various professional weights of the liquefied natural gas module. This can intuitively display the distribution information of each professional weight of the LNG module, making it easy for staff to check the key indicators in the LNG module weight control report (refers to the strict monitoring and management of module information during module production and construction to ensure that the quality and safety of the module meet the design and use requirements.) with high processing efficiency and low error rate. BRIEF DESCRIPTION OF THE DRAWINGS

[0063] In order to more clearly illustrate the technical solutions in the embodiments of the present application or related technologies, the drawings required for use in the embodiments of the present application or related technical descriptions will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without paying creative work.

[0064] FIG1 is an application environment diagram of a data processing method in one embodiment;

[0065] FIG2 is a schematic flow chart of a data processing method in one embodiment;

[0066] FIG3 is a flow chart of a method for looping through workbooks in one embodiment;

[0067] FIG4 is a schematic flow chart of a data processing method in another embodiment;

[0068] FIG5 is a block diagram of a data processing device in one embodiment;

[0069] FIG6 is a block diagram of a data processing device in another embodiment;

[0070] FIG. 7 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0071] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0072] The data processing method provided in the embodiment of the present application can be applied to the application environment shown in Figure 1. Among them, the terminal 102 communicates with the server 104 through the network. The data storage system can store the data that the server 104 needs to process. The data storage system can be integrated on the server 104, or it can be placed on the cloud or other network servers. The terminal 102 side inputs the user's operation instructions through various input devices, starts the data processing process, and mobilizes the program to pre-process the active worksheet to obtain the table to be summarized; wherein the active worksheet refers to the worksheet of the current operation; determine the search range and screening conditions corresponding to the data to be summarized; according to the search range, find several data tables that meet the screening conditions from the local database or the data storage system of the server 104; copy the content in the data table to the table to be summarized according to the preset rules to obtain the target table; read the content in the target table, and classify and summarize according to the professional weights of the liquefied natural gas module to obtain the results of the classification summary; call the pivot table to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the professional weights of the liquefied natural gas module. The terminal 102 may be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, etc. The server 104 may be an independent physical server, a server cluster or a distributed system composed of multiple physical servers, or a cloud server providing cloud computing services.

[0073] In an exemplary embodiment, as shown in FIG2 , a data processing method is provided, which is described by taking the method applied to the terminal in FIG1 as an example, and includes the following steps 201 to 206. Among them:

[0074] Step 201, pre-process the active worksheet to obtain a table to be summarized.

[0075] The active worksheet refers to the worksheet currently being operated. Taking Microsoft Office Excel as an example, a worksheet is also called a sheet in Excel, that is, when multiple sheets are opened at the same time in the same Excel, the sheet currently being operated is the active worksheet.

[0076] Exemplarily, it is determined whether the active worksheet is a blank sheet; if it is not a blank sheet, the original data, format and comments in the active worksheet are cleared to obtain the sheet to be summarized; if it is a blank sheet, the blank sheet is used as the sheet to be summarized.

[0077] In this embodiment, the active worksheet is not necessarily a blank worksheet. If it is a blank worksheet, it can be used directly. If it is not a blank worksheet, the active worksheet needs to be preprocessed first, that is, the original data, format and comments in the active worksheet are cleared to facilitate copying the contents of other tables to the active worksheet, thereby realizing the reuse of the active worksheet without turning pages or creating a new table, thereby simplifying the operation steps on the user terminal side.

[0078] Step 202, determining the search scope and screening conditions corresponding to the data to be summarized.

[0079] In this embodiment, in order to search for the data to be summarized more quickly, the search range and screening conditions corresponding to the data to be summarized need to be determined in advance. Especially when applied to the summary of LNG module weight control information, it is necessary to determine a suitable search range as much as possible.

[0080] Exemplarily, at least one workbook is determined, and the workbook is used as the search scope; wherein each table in the workbook pre-stores weight control information of the liquefied natural gas module; according to the naming rules of the liquefied natural gas module for each professional weight, the names of all tables containing the data to be summarized are determined, and the table names are used as the filtering conditions; wherein the data to be summarized include: each professional weight of the liquefied natural gas module.

[0081] It should be noted that the present embodiment is not limited to searching for each table in one workbook, and it can be for multiple open workbooks to implement cross-workbook data retrieval.

[0082] In this embodiment, because the LNG module weight control information will be standardized when the table name is stored, when the table name is known, it can be determined whether the corresponding table contains the data to be summarized. Based on this premise, the table name can be used as a screening condition to traverse and search each table in the determined workbook to find all tables that meet the screening conditions.

[0083] Step 203: Find several data tables that meet the screening conditions according to the search scope.

[0084] In this embodiment, after determining the search scope and filtering conditions, the table names are traversed and compared within the search scope (determined workbook scope) according to the set filtering conditions, and all tables whose table names are consistent with the table names indicated by the filtering conditions are found, and these tables are used as data tables to be merged.

[0085] Exemplarily, a loop statement is used to traverse the table name of each table in the workbook, and determine whether the table name of each table is consistent with the table name indicated by the i-th filtering condition, where i=1,2,3,…,N; N represents the total number of filtering conditions, and N is a natural number greater than 1; if it is consistent with the table name indicated by the i-th filtering condition, the corresponding table will be used as a data table that meets the filtering condition.

[0086] Step 204, copy the content in the data table to the table to be summarized according to the preset rules to obtain the target table.

[0087] In this embodiment, it is assumed that there are M data tables; wherein M is a natural number greater than 1; the contents of the M data tables are copied to the table to be summarized in turn, wherein after the contents of each data table are copied, the cursor is moved to the next row to copy the contents of the next data table; it is determined whether all the M data tables have been copied; if all have been copied, a dialog box is popped up to prompt that the data merge is completed; if not all have been copied, the next uncopied data table is obtained until the copying of all the data tables is completed.

[0088] Exemplarily, integrating steps 201 to 204, FIG3 provides a flow chart of a method for looping through a workbook, which method can be applied in Excel of Microsoft Office. Specifically, first call the active worksheet, clear the original data, format and comments in the active worksheet, use the For loop statement to retrieve the name of each sheet in Excel in turn; then determine whether the sheet name is consistent with the name of the required condition 1 (that is, the filter condition mentioned above). If so, copy the content of this sheet to the active workbook (that is, the active worksheet mentioned above. The difference is that the data here can be copied to different tables in the workbook), and move the cursor to the next row, and return to determine the next sheet; if not (No, that is, the sheet name is inconsistent with the required condition 1), continue to determine whether the sheet name is consistent with the name of the required condition 2. If so, copy the content of this sheet to the active workbook, and move the cursor to the next row, and return to determine the next sheet; if not (that is, the sheet name is inconsistent with the required condition 2), continue to determine whether the sheet name is consistent with the name of the required condition 3. The specific process is consistent with the above process until all conditions N are traversed. If the sheet name that meets the required conditions is still not found, it is determined that this sheet does not need to be pasted. When the For loop statement ends, the content of the conditions has been copied to the active workbook in turn. Excel pops up a dialog box, saying "Merge completed."

[0089] In this embodiment, secondary development based on VBA (Visual Basic Application) of EXCEL can be performed to automatically complete the relevant method steps in the above steps 201 to 205.

[0090] Step 205, read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results.

[0091] In this embodiment, because all the data to be summarized are in one table (or one workbook), the contents in the table can be directly classified and summarized.

[0092] For example, the classification and summary can be performed according to the version number, module name, professional name, and weight value of each professional weight. Since the update speed of the LNG module weight control information is very fast, the data can also be timestamped and classified and summarized according to the time range, so as to achieve one-click update of the LNG module weight control information and quickly output the classification and summary results.

[0093] Step 206, retrieve the pivot table and display the results of the classification summary.

[0094] The classification and summary results include: distribution information of each professional weight of LNG modules, such as: MEC (Modular Equipment Controller)-dynamic equipment, MEC-static equipment, Piping, Safety, Heating, Ventilation, and Air Conditioning (HVAC), Installation aids, Live Load, etc.

[0095] In this embodiment, taking Excel as an example, its pivot table function can be called to import the results of the classification summary into the table area according to the pre-set filter items, and then displayed according to the type of chart confirmed by the user, such as various forms of proportional charts, so that the user can intuitively check the results of the classification summary.

[0096] Exemplarily, based on the pivot table function in Excel, the results of classification summary can be designated as a table area; a weight control data table is inserted in the table area, and row filter items, column filter items, and value filter items of the weight control data table are set; wherein the row filter items include: version number, module name, professional name; the column filter items include: numerical values; the value filter items include: weight information; the field type of the value filter items is set to sum; a data display chart is selected to display the weight control data table, and the display chart includes: any one of a pie chart, a histogram, and a line chart.

[0097] In the above data processing method, the table to be summarized is obtained by preprocessing the active worksheet; wherein, the active worksheet refers to the worksheet currently being operated; thus, the active worksheet can be reused and the final data can be summarized into the active worksheet. Determine the search range and screening conditions corresponding to the data to be summarized; thus, the data to be summarized can be found accurately and quickly. According to the search range, several data tables that meet the screening conditions are found; the contents in the data table are copied to the table to be summarized according to the preset rules to obtain the target table; thus, multiple different data tables can be merged and summarized into one table to achieve one-key update without tedious search. Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas module to obtain the results of the classification summary; implement the classification and summary processing of the data in the merged table to obtain the results of the classification summary of the professional weights of the liquefied natural gas module. Retrieve the pivot table to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the professional weights of the liquefied natural gas module. This can intuitively display the distribution information of each professional weight of the LNG module, making it convenient for staff to check the key indicators in the LNG module weight control report, with high processing efficiency and low error rate.

[0098] In another exemplary embodiment, as shown in FIG4 , a data processing method is provided, which is described by taking the method applied to the terminal in FIG1 as an example, and includes the following steps 401 to 407. Among them:

[0099] Step 401, pre-process the active worksheet to obtain a table to be summarized.

[0100] Step 402, determining the search scope and screening conditions corresponding to the data to be summarized.

[0101] Step 403: Find several data tables that meet the screening conditions according to the search scope.

[0102] Step 404, copy the content in the data table to the table to be summarized according to the preset rules to obtain the target table.

[0103] Step 405, read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results.

[0104] Step 406, call the pivot table to display the results of the classification summary.

[0105] In this embodiment, for the specific implementation process and technical effects of steps 401 to 406, please refer to the relevant description of steps 201 to 206 shown in Figure 2, which will not be repeated here.

[0106] Step 407, receiving a verification instruction, and verifying the classification and summary results according to the verification instruction.

[0107] In this embodiment, after obtaining the results of the classification summary and displaying them on the user's terminal. If the user doubts the correctness of the results of the classification summary, or finds that there are data errors, he can start error correction with one click, generate a verification instruction, and re-execute steps 401 to 406 through the verification instruction, so as to obtain the results of the classification summary again. In addition, the results of the classification summary generated last time can also be retrieved, and the classification summary results generated this time can be verified according to the results of the classification summary generated last time. For example, extract a part of the data and compare the results of the two classification summaries. In this way, errors in the data can be discovered in time, and the staff can be reminded to correct them.

[0108] It should be understood that, although the various steps in the flowcharts involved in the above-mentioned embodiments are displayed in sequence according to the indication of the arrows, these steps are not necessarily executed in sequence according to the order indicated by the arrows. Unless there is a clear explanation in this article, the execution of these steps does not have a strict order restriction, and these steps can be executed in other orders. Moreover, at least a part of the steps in the flowcharts involved in the above-mentioned embodiments can include multiple steps or multiple stages, and these steps or stages are not necessarily executed at the same time, but can be executed at different times, and the execution order of these steps or stages is not necessarily to be carried out in sequence, but can be executed in turn or alternately with other steps or at least a part of the steps or stages in other steps.

[0109] Based on the same inventive concept, the embodiment of the present application also provides a data processing device for implementing the data processing method involved above. The implementation scheme for solving the problem provided by the device is similar to the implementation scheme recorded in the above method, so the specific limitations in the one or more data processing device embodiments provided below can refer to the limitations on the data processing method above, and will not be repeated here.

[0110] In an exemplary embodiment, as shown in FIG5 , a data processing device is provided, including: a preprocessing module 501, a determination module 502, a search module 503, a merging module 504, a summary module 505 and a display module 506, wherein:

[0111] A preprocessing module 501 is used to preprocess the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated;

[0112] Determination module 502, used to determine the search scope and screening conditions corresponding to the data to be summarized;

[0113] A search module 503 is used to search for a number of data tables that meet the screening condition according to the search scope;

[0114] A merging module 504 is used to copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table;

[0115] A summary module 505 is used to read the content in the target table and classify and summarize it according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results;

[0116] The display module 506 is used to retrieve the pivot table and display the classification summary results, wherein the classification summary results include: the distribution information of each professional weight of the liquefied natural gas module.

[0117] Exemplarily, the preprocessing module 501 is specifically used for:

[0118] Determine whether the active worksheet is a blank sheet; if it is not a blank sheet, clear the original data, format and comments in the active worksheet to obtain the sheet to be summarized; if it is a blank sheet, use the blank sheet as the sheet to be summarized.

[0119] Exemplarily, the determining module 502 is specifically configured to:

[0120] Determine at least one workbook and use the workbook as the search scope; wherein each table in the workbook pre-stores weight control information of the liquefied natural gas module; according to the naming rules of the liquefied natural gas module for each professional weight, determine the names of all tables containing the data to be summarized, and use the table names as the screening conditions; wherein the data to be summarized includes: each professional weight of the liquefied natural gas module.

[0121] Exemplarily, the search module 503 is specifically used for:

[0122] A loop statement is used to traverse the table name of each table in the workbook, and whether the table name of each table is consistent with the table name indicated by the i-th filtering condition is determined respectively, where i=1,2,3,…,N; N represents the total number of filtering conditions, and N is a natural number greater than 1; if it is consistent with the table name indicated by the i-th filtering condition, the corresponding table is used as a data table that meets the filtering condition.

[0123] Exemplarily, the merging module 504 is specifically configured to:

[0124] Assume that there are M data tables, where M is a natural number greater than 1.

[0125] Copy the contents of the M data tables to the table to be summarized in sequence, wherein after copying the contents of each data table, move the cursor to the next row to copy the contents of the next data table; determine whether all the M data tables have been copied; if all have been copied, pop up a dialog box to prompt that the data merge is completed; if not all have been copied, continue to obtain the next uncopied data table until all data tables are copied.

[0126] Exemplarily, the display module 506 is specifically used for:

[0127] Based on the pivot table function in Excel, the results of classification summary are designated as a table area; a weight control data table is inserted into the table area, and row filter items, column filter items, and value filter items of the weight control data table are set; wherein the row filter items include: version number, module name, professional name; the column filter items include: numerical value; the value filter items include: weight information; the field type of the value filter items is set to sum; a data display chart is selected to display the weight control data table, and the display chart includes: any one of a pie chart, a histogram, and a line chart.

[0128] In this embodiment, the table to be summarized is obtained by preprocessing the active worksheet; wherein the active worksheet refers to the worksheet currently being operated; thus, the active worksheet can be reused and the final data can be summarized into the active worksheet. Determine the search range and filtering conditions corresponding to the data to be summarized; thus, the data to be summarized can be found accurately and quickly. According to the search range, several data tables that meet the filtering conditions are found; the contents in the data table are copied to the table to be summarized according to the preset rules to obtain the target table; thus, multiple different data tables can be merged and summarized into one table to achieve one-key update without tedious search. Read the contents in the target table, and classify and summarize them according to the various professional weights of the liquefied natural gas module to obtain the results of the classification summary; implement the classification and summary processing of the data in the merged table to obtain the results of the classification summary of the various professional weights of the liquefied natural gas module. Retrieve the pivot table to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the various professional weights of the liquefied natural gas module. This can intuitively display the distribution information of each professional weight of the LNG module, making it convenient for staff to check the key indicators in the LNG module weight control report, with high processing efficiency and low error rate.

[0129] In another exemplary embodiment, as shown in FIG. 6 , a data processing device is provided. Based on the device shown in FIG. 5 , the device may further include: a verification module 507,

[0130] The verification module is used to receive the verification instruction and verify the classification and summary results according to the verification instruction.

[0131] In this embodiment, after obtaining the results of the classification summary and displaying them on the user's terminal. If the user doubts the correctness of the results of the classification summary, or finds that there are data errors, he can start error correction with one click, generate a verification instruction, and regenerate the results of the classification summary through the verification instruction. In addition, the results of the classification summary generated last time can also be retrieved, and the classification summary results generated this time can be verified according to the results of the classification summary generated last time. For example, extract a part of the data and compare the results of the two classification summaries. In this way, errors in the data can be discovered in time, and the staff can be reminded to correct them.

[0132] Each module in the above data processing device can be implemented in whole or in part by software, hardware or a combination thereof. Each module can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute operations corresponding to each module.

[0133] In an exemplary embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be shown in FIG7. The computer device includes a processor, a memory, an input / output interface, a communication interface, a display unit, and an input device. The processor, the memory, and the input / output interface are connected via a system bus, and the communication interface, the display unit, and the input device are connected to the system bus via the input / output interface. The processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The input / output interface of the computer device is used to exchange information between the processor and an external device. The communication interface of the computer device is used to communicate with an external terminal in a wired or wireless manner, and the wireless manner may be implemented through WIFI, a mobile cellular network, near field communication (NFC) or other technologies. When the computer program is executed by the processor, a data processing method is implemented. The display unit of the computer device is used to form a visually visible picture, which may be a display screen, a projection device, or a virtual reality imaging device. The display screen can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer device can be a touch layer covering the display screen, or a button, trackball or touchpad set on the computer device shell, or an external keyboard, touchpad or mouse.

[0134] Those skilled in the art will understand that the structure shown in FIG. 7 is merely a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer device to which the solution of the present application is applied. The specific computer device may include more or fewer components than shown in the figure, or combine certain components, or have a different arrangement of components.

[0135] In an exemplary embodiment, a computer device is provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above-mentioned method embodiments when executing the computer program.

[0136] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above method embodiments are implemented.

[0137] In one embodiment, a computer program product is provided, including a computer program, which implements the steps in the above method embodiments when executed by a processor.

[0138] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant regulations.

[0139] A person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment method can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to the memory, database or other medium used in the embodiments provided in the present application can include at least one of non-volatile memory and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory, optical memory, high-density embedded non-volatile memory, resistive random access memory (ReRAM), magnetic random access memory (MRAM), ferroelectric random access memory (FRAM), phase change memory (PCM), graphene memory, etc. Volatile memory can include random access memory (RAM) or external cache memory, etc. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM). The database involved in each embodiment provided in this application may include at least one of a relational database and a non-relational database. Non-relational databases may include distributed databases based on blockchains, etc., but are not limited to this. The processor involved in each embodiment provided in this application may be a general-purpose processor, a central processing unit, a graphics processor, a digital signal processor, a programmable logic device, a data processing logic device based on quantum computing, an artificial intelligence (AI) processor, etc., but are not limited to this.

[0140] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this application.

[0141] The above-described embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the present application. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application shall be subject to the attached claims.

Claims

1. A data processing method, characterized in that: The method comprises: Preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated; Determine the search scope and screening conditions corresponding to the data to be summarized; According to the search scope, a number of data tables meeting the screening conditions are found; Copy the content in the data table to the table to be summarized according to a preset rule to obtain a target table; Read the contents in the target table, and classify and summarize them according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results; The pivot table is retrieved to display the results of the classification summary, wherein the results of the classification summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

2. The method according to claim 1, characterized in that The preprocessing of the active worksheet to obtain the table to be summarized includes: Determine whether the active worksheet is a blank sheet; If it is not a blank table, clear the original data, format and comments in the active worksheet to obtain the table to be summarized; If it is a blank table, the blank table is used as the table to be summarized.

3. The method according to claim 2, characterized in that The step of determining the search scope and screening conditions corresponding to the data to be aggregated includes: Determine at least one workbook and use the workbook as a search range; wherein each table in the workbook pre-stores weight control information of the liquefied natural gas module; According to the naming rules of the liquefied natural gas module for each professional weight, the names of all tables containing the data to be summarized are determined, and the table names are used as screening conditions; wherein the data to be summarized include: each professional weight of the liquefied natural gas module.

4. The method according to claim 3, characterized in that According to the search scope, several data tables meeting the screening conditions are found, including: A loop statement is used to traverse the table name of each table in the workbook, and to determine whether the table name of each table is consistent with the table name indicated by the i-th filtering condition, where i=1,2,3,…,N; N represents the total number of filtering conditions, and N is a natural number greater than 1; If the table name is consistent with the table name indicated by the i-th filtering condition, the corresponding table is used as the data table that meets the filtering condition.

5. The method according to any one of claims 1 to 4, characterized in that: The content in the data table is copied to the table to be summarized according to the preset rules to obtain the target table, including: Assume that there are M data tables, where M is a natural number greater than 1. Copying the contents of the M data tables to the table to be summarized in sequence, wherein after copying the contents of each data table, moving the cursor to the next row to copy the contents of the next data table; Determine whether all M data tables have been copied; If all the data have been copied, a dialog box will pop up to prompt that the data merge is complete; If not all data tables have been copied, continue to obtain the next uncopied data table until all data tables have been copied.

6. The method according to claim 1, characterized in that The calling of the pivot table to display the results of the classification summary includes: Based on the PivotTable function in Excel, the results of the classification summary are specified as the table area; Insert a weight control data table in the table area, and set row filter items, column filter items, and value filter items of the weight control data table; wherein the row filter items include: version number, module name, professional name; the column filter items include: value; the value filter items include: weight information; Set the field type of the value filter item to sum; Select a data display chart to display the weight control data table, and the display chart includes: any one of a pie chart, a histogram, and a line chart.

7. A data processing device, characterized in that: The device comprises: A preprocessing module, used for preprocessing the active worksheet to obtain a table to be summarized; wherein the active worksheet refers to the worksheet currently being operated; A determination module is used to determine the search scope and screening conditions corresponding to the data to be summarized; A search module, used to search for a number of data tables that meet the screening conditions according to the search scope; A merging module, used for copying the content in the data table to the table to be summarized according to a preset rule to obtain a target table; A summary module is used to read the content in the target table and classify and summarize it according to the professional weights of the liquefied natural gas modules to obtain the classification and summary results; The display module is used to call the pivot table to display the results of classification and summary, wherein the results of classification and summary include: the distribution information of the weight of each specialty of the liquefied natural gas module.

8. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

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

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.