Data verification processing method, device, computer equipment and storage medium

Abstract

The present invention provides a data verification processing method, device, computer equipment and storage medium, the method comprising encoding each data indicator in a data report to obtain multiple indicator codes; encoding the time dimension of each data indicator in the data report to obtain multiple dimension value codes; generating a consolidated report in response to a report preparation instruction, associating an indicator code and a dimension value code with each designated cell in the consolidated report; generating a verification formula for the consolidated report based on the indicator code and the dimension value code in response to a formula editing instruction; calculating the verification formula for the consolidated report based on the indicator code and the dimension value code, and obtaining the verification result of the consolidated report based on the calculation result of the verification formula. By associating the indicator code and the dimension value code with the cells in the consolidated report respectively, the verification formula is not affected by the position adjustment of the cells where the data indicators are located in the consolidated report, saving the operation and maintenance cost of the consolidated report and improving the data quality of the financial consolidated report.

Description

Technical Field

[0001] The present invention relates to the field of data processing technology, and in particular to a data verification processing method, device, computer equipment and storage medium. Background Art

[0002] Reports can help users process large amounts of data and are currently a good means for companies and users to process data. However, it is not easy to compile the required report information in a timely and accurate manner and to ensure the integrity, correctness and consistency of the data after the consolidated report is completed. In particular, when there are a large number of consolidated reports and the types of reports are complex, the difficulty of merging reports increases exponentially. Summary of the invention

[0003] Based on this, it is necessary to provide a data verification processing method, device, computer equipment and storage medium to address the above technical problems.

[0004] A data verification processing method, comprising:

[0005] Based on the first preset rule, each data indicator is encoded to obtain multiple indicator codes;

[0006] Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes;

[0007] Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0008] Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0009] Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

[0010] In one embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code includes:

[0011] Obtaining a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table verification formula for the combined report based on the indicator code and the dimension value code;

[0012] A second formula editing instruction is obtained, and in response to the second formula editing instruction, an inter-table verification formula of the combined report is generated based on the indicator code and the dimension value code.

[0013] In one embodiment, the step of calculating the verification formula of the combined report based on the indicator code and the dimension value code, and obtaining the verification result of the combined report based on the calculation result of the verification formula includes:

[0014] Calculate the verification formula of the combined report based on the indicator code and the dimension value code;

[0015] Check whether the calculation result of the verification formula of the combined report matches the preset result;

[0016] When the calculation result of the verification formula of the combined report matches the preset result, an error message is output.

[0017] In one embodiment, the step of outputting the error information further includes:

[0018] A click instruction for the error information is obtained, and in response to the error instruction, data in the data report corresponding to the error information is displayed.

[0019] In one embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code further includes:

[0020] Obtaining executable program compilation instructions, and generating an executable program according to the verification formula of the combined report in response to the executable program compilation instructions.

[0021] A data verification processing device, comprising:

[0022] An indicator code obtaining module, used to encode each data indicator based on a first preset rule to obtain a plurality of indicator codes;

[0023] A dimension value code obtaining module, used to encode the time dimension of each of the data indicators based on a second preset rule to obtain multiple dimension value codes;

[0024] A cell code associating module, used for obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0025] A verification formula generation module, used for obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0026] A verification calculation module is used to calculate the verification formula of the combined report based on the indicator code and the dimension value code, and obtain the verification result of the combined report based on the calculation result of the verification formula.

[0027] In one embodiment, the verification formula generation module includes:

[0028] An in-table verification formula generation submodule is used to obtain a first formula editing instruction, respond to the first formula editing instruction, and generate an in-table verification formula of the consolidated report based on the indicator code and the dimension value code;

[0029] The inter-table verification formula generation submodule is used to obtain a second formula editing instruction, respond to the second formula editing instruction, and generate an inter-table verification formula for the combined report based on the indicator code and the dimension value code.

[0030] In one embodiment, the verification calculation module includes:

[0031] A verification formula calculation submodule, used to calculate the verification formula of the consolidated report based on the indicator code and the dimension value code;

[0032] A matching detection submodule is used to detect whether the calculation result of the verification formula of the combined report matches the preset result;

[0033] The error information output submodule is used to output an error message when the calculation result of the verification formula of the combined report matches the preset result.

[0034] A computer device comprises a memory and a processor, wherein the memory stores a computer program, and wherein the processor implements the following steps when executing the computer program:

[0035] Based on the first preset rule, each data indicator is encoded to obtain multiple indicator codes;

[0036] Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes;

[0037] Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0038] Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0039] Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

[0040] A computer-readable storage medium stores a computer program, which, when executed by a processor, implements the following steps:

[0041] Based on the first preset rule, each data indicator is encoded to obtain multiple indicator codes;

[0042] Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes;

[0043] Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0044] Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0045] Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

[0046] The above-mentioned data verification processing method, device, computer equipment and storage medium, by respectively associating indicator codes and dimension value codes to the cells in the consolidated report, the verification formula is not affected by the position adjustment of the cells where the data indicators in the consolidated report are located, which effectively saves the operation and maintenance costs of the consolidated report, improves the data quality of the financial consolidated report, and reduces the difficulty of the consolidated report. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A schematic diagram of a flow chart of a data verification processing method in one embodiment;

[0048] Figure 2 A structural block diagram of a data verification processing device in an embodiment;

[0049] Figure 3 FIG. 4 is a diagram showing the internal structure of a computer device in one embodiment. DETAILED DESCRIPTION

[0050] 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.

[0051] Embodiment 1

[0052] In this embodiment, Figure 1 As shown, a data verification processing method is provided, which includes:

[0053] Step 110: Encode each data indicator based on a first preset rule to obtain a plurality of indicator codes.

[0054] Specifically, the data indicator is an indicator of the data in the data report, which is a general term for the same type of data. It can also be said that one data indicator corresponds to one type of data. The data report can be a financial report, a material report, or other types of reports. In this embodiment, the data report is a financial report, each data indicator is a financial data indicator, and the consolidated report is a financial consolidated report for further explanation.

[0055] In this embodiment, the first preset rule can be user-defined or pre-set in the system for encoding data indicators. The first preset rule is the encoding rule. In this embodiment, the various types of data indicators contained in the consolidated report are encoded, and each type of data indicator has a corresponding indicator code. Encoding the data indicator is to assign a code to the data indicator.

[0056] For example, taking financial statements as an example, the financial statements contain data indicators such as cash and cash equivalents, accounts receivable, main business income, and total operating costs. The above data indicators are coded separately to obtain multiple indicator codes such as Z01 to Z08. The correspondence between each indicator code and the data indicator is: Z01: cash and cash equivalents, Z02: accounts receivable, Z03: electricity charges receivable, Z04: heating charges receivable, Z05: coal charges receivable, Z06: total operating income, Z07: total operating costs, Z08: undistributed profits.

[0057] Step 120: Based on the second preset rule, encode the time dimension of each of the data indicators to obtain multiple dimension value codes.

[0058] Specifically, the time dimension is the time corresponding to the data indicator. The second preset rule can be user-defined or pre-set in the system, and is used to encode the time scale of the data indicator. The second preset rule is the encoding rule. Encoding the time dimension of the data indicator is to encode the time dimension of the data indicator.

[0059] For example, the time dimensions included in the financial statements include the balance at the end of the period, the balance at the same period of the previous year, and the balance at the beginning of the year. The above time dimensions are encoded separately to obtain multiple dimension value codes such as T01 to T05. The correspondence between the time dimension and the dimension value code of each data indicator is: T01: balance at the end of the period, T02: balance at the same period of the previous year, T03: balance at the beginning of the year, T04: balance this month, T05: cumulative balance this year.

[0060] Step 130, obtaining a report preparation instruction, generating a combined report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the combined report.

[0061] In this embodiment, the report preparation instruction is input by the user, and there may be multiple report preparation instructions. A financial consolidated report is generated through multiple report preparation instructions. The financial consolidated report is formed by merging multiple financial data reports, and the consolidated report has multiple cells, each of which records data. The designated cell is a cell selected by the user. In one embodiment, after the consolidated report is generated, a designated instruction is obtained, and in response to the designated instruction, a designated cell in the consolidated report is obtained.

[0062] The designated cell records data. In this embodiment, the designated cell is associated with an indicator code and a one-dimensional value code, and then the indicator code and the dimension value code are designated for the designated cell, and the indicator code and the dimension value code are designated for the data in the designated cell.

[0063] Step 140, obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code.

[0064] In this embodiment, the formula editing instruction is input by the user and is used to edit the verification formula. In this embodiment, the generated verification formula is associated with the indicator code and the dimension value code, so that the verification formula is only related to the indicator code and the dimension value code during verification, and has nothing to do with the location of the cell. The generated verification formula is used to verify the consolidated report and the data of the consolidated report to verify whether the data in the consolidated report is wrong.

[0065] Step 150, based on the indicator code and the dimension value code, calculate the verification formula of the combined report, and obtain the verification result of the combined report based on the calculation result of the verification formula.

[0066] In this embodiment, a verification formula is calculated based on the indicator code and dimension value code of the data indicator, and the calculation result of the verification formula is the verification result of the consolidated report. Based on the calculation result, it can be determined whether the data of the consolidated report is wrong.

[0067] In the above embodiment, by associating indicator codes and dimension value codes respectively with cells in the consolidated report, the verification formula is not affected by the position adjustment of the cells where the data indicators in the consolidated report are located, which effectively saves the operation and maintenance costs of the consolidated report, improves the data quality of the financial consolidated report, and reduces the difficulty of the consolidated report.

[0068] In one embodiment, the steps of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the consolidated report based on the indicator code and the dimension value code include: obtaining a first formula editing instruction, responding to the first formula editing instruction, and generating an intra-table verification formula for the consolidated report based on the indicator code and the dimension value code; obtaining a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table verification formula for the consolidated report based on the indicator code and the dimension value code.

[0069] Specifically, the verification formula includes an intra-table verification formula and an inter-table verification formula. The intra-table verification formula is used to verify the data in the same worksheet in the consolidated report, and the inter-table verification formula is used to verify the data in different worksheets in the consolidated report. Therefore, in this embodiment, according to the first formula editing instruction, the intra-table verification formula is generated, and according to the second formula editing instruction, the inter-table verification formula is generated, so that the data in the table and the data between the tables can be verified separately.

[0070] In one embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the consolidated report based on the indicator code and the dimension value code further includes: obtaining a third formula editing instruction, responding to the third formula editing instruction, and generating a complex verification formula for the consolidated report based on the indicator code and the dimension value code. Specifically, the verification formula includes a complex verification formula, which is used to verify complex data in the consolidated report. Therefore, in this embodiment, a complex verification formula is generated according to the third formula editing instruction, so that complex data in the table can be verified.

[0071] In one embodiment, the verification formula of the consolidated report is calculated based on the indicator code and the dimension value code, and the step of obtaining the verification result of the consolidated report based on the calculation result of the verification formula includes: calculating the verification formula of the consolidated report based on the indicator code and the dimension value code; detecting whether the calculation result of the verification formula of the consolidated report matches the preset result; when the calculation result of the verification formula of the consolidated report matches the preset result, outputting an error message.

[0072] Specifically, by calculating the verification formula, a calculation result is obtained, and the calculation result is compared with the preset result. Specifically, the matching detection of the calculation result and the preset result can be to determine whether the calculation result is less than the preset result, or to determine whether the calculation result is greater than the preset result, or to determine whether the calculation result is equal to the preset result. When the calculation result meets the preset result and matches the preset result, it indicates that there is an error in the verified data, and an error message is output and displayed so that the user can promptly know the data with errors in the verification. The output information is used to display the erroneous data and the position of the erroneous data in the worksheet, which is convenient for the user to view.

[0073] In one embodiment, the step of outputting the error information further includes: obtaining a click instruction for the error information, and displaying the data in the data report corresponding to the error information in response to the error instruction.

[0074] In this embodiment, when the calculation result of the verification formula matches the preset result, a display box or display interface carrying error information pops up. The error instruction is an instruction to click the display box or display interface, which is used to open and display the data in the data report corresponding to the error information. In this way, the user can quickly find the erroneous data.

[0075] In one embodiment, the step of obtaining formula editing instructions, responding to the formula editing instructions, and generating the verification formula of the consolidated report based on the indicator code and the dimension value code also includes: obtaining executable program compilation instructions, responding to the executable program compilation instructions, and generating an executable program according to the verification formula of the consolidated report.

[0076] Specifically, the executable program is used to execute the verification formula. In this embodiment, the verification formula is parsed and compiled into an executable program through system dynamic compilation. Dynamic compilation reduces the difficulty of formula configuration for users, enables reports to obtain recalculation capabilities without coding, realizes the separation of front-end and back-end, and can achieve compilation optimization without affecting the front-end script.

[0077] Embodiment 2

[0078] In this embodiment, the consolidated report is a financial consolidated report, and each data indicator is a financial data indicator. In this embodiment, the following process is used to implement data processing of the consolidated report:

[0079] 1. Encode the financial indicators of the consolidated financial statements, and assign different indicator codes to monetary funds, accounts receivable, main business income, total operating costs, etc.;

[0080] 2. Encode the time dimension of the financial indicators of the consolidated financial statements, and assign different dimension value codes to the ending balance, the same period of the previous year, and the beginning balance;

[0081] 3. The verification formula within the financial consolidated statement is compiled according to the financial indicator code and time dimension value;

[0082] 4. The inter-table verification formula of the financial consolidated report is compiled according to the report code, financial indicator code, and time dimension value;

[0083] 5. The complex verification formula of the financial consolidated report is compiled according to the report code, financial indicator code, and time dimension, and supports AND, OR logic, and nested combinations of multiple complex conditions;

[0084] 6. The verification formula of the financial consolidated report supports dynamic compilation, which compiles the prepared report verification formula into an executable program. Through dynamic compilation, the difficulty of user configuration of the formula is reduced, and the report is able to recalculate without the help of coding, realizing the separation of the front-end and back-end, and can achieve compilation optimization without affecting the front-end script.

[0085] 7. In combination with the financial statement consolidation business, coordinate the boundaries, equations, balances and other relationships scattered in each statement as well as the cross-checking and verification relationships between statements, summarize, refine and integrate to form a financial statement consolidation verification model.

[0086] The specific implementation steps are:

[0087] S11: Code the financial indicators of the consolidated financial statements, and assign different indicator codes to cash, accounts receivable, main business income, total operating costs, etc.; for example, Z01: cash, Z02: accounts receivable, Z03: electricity fees receivable, Z04: heating fees receivable, Z05: coal fees receivable, Z06: total operating income, Z07: total operating costs, Z08: undistributed profits.

[0088] S12: Encode the time dimension of the financial indicators of the consolidated financial statements, and assign different dimension value codes to the ending balance, the same period of the previous year, and the beginning balance; for example, T01: ending balance, T02: the same period of the previous year, T03: beginning balance, T04: this month's balance, T05: the cumulative balance of this year.

[0089] S13: Prepare financial consolidated statements, specify the indicator code and time dimension of each cell in the statement; for example, the indicator code of the cell Accounts Receivable - Ending Balance in the balance sheet is Z03, and the dimension is T01; the indicator code of the cell Retained Profit - Beginning of Year Balance is Z08, and the dimension is T03; the indicator code of the cell Retained Profit at the Beginning of Year in the income statement is Z08, and the dimension is T03.

[0090] S14: The in - table verification formula for the financial consolidated statements is prepared according to the financial indicator code and the time - dimension value. For example, for accounts receivable in the balance sheet, it should be greater than or equal to the sum of three indicators: electricity receivables, heat receivables, and coal receivables. Then the verification formula is prepared as follows:

[0091] a$Z03$T01 < a$Z04$T01 + a$Z05$T01 + a$Z06$T01. If the data in the balance sheet passes the verification and conforms to this formula, an error message will be prompted: Accounts receivable >= Electricity receivables + Heat receivables + Coal receivables. Among them, for a$Z03$T01, a represents the balance sheet, and $Z03$T01 represents the ending balance of accounts receivable.

[0092] S15: The inter - table verification formula for the financial consolidated statements is prepared according to the statement code, financial indicator code, and time - dimension value. For example, the undistributed profit - beginning balance in the income statement should be equal to the undistributed profit - beginning balance in the balance sheet. Then the verification formula is prepared as follows:

[0093] Math.round(Math.abs(a$Z08$T03 - b$Z08$T03)*100)>1. If the data in the balance sheet and the income statement pass the verification and conform to this formula, an error message will be prompted:

Balance sheet

Income statement

[0094] S16: The complex verification formula for the financial consolidated statements is prepared according to the statement code, financial indicator code, and time dimension, and supports the AND, OR logic, and nested combinations of multiple complex conditions. For example, the current - month amount in the income statement should be equal to the cumulative amount of the current month minus the cumulative amount of the previous month. Then the verification formula is prepared as follows:

[0095] Math.round(Math.abs(b$T04-(b$T05 - c$Z02))*100)>1&&b$_rid == c$_rid

[0096] Among them, b in b$T04 represents the income statement, c in c$Z02 represents the income statement of the previous month, "&&" indicates that the relationship between the two conditions before and after is an AND relationship, _rid represents the codes of all indicators in the income statement, and Math.abs and Math.round are mathematical operation formulas, representing taking the absolute value and rounding respectively.

[0097] If the data in the income statement is verified to conform to the above formula, the error message will be: This month's number = this month's cumulative number - last month's cumulative number.

[0098] S17: The verification formula of the financial consolidated report is published, and the system dynamically compiles the compiled report verification formula into an executable program. Through dynamic compilation, the difficulty of user configuration of the formula is reduced, and the report has the ability to recalculate without coding, realizing the separation of the front-end and back-end, and can achieve compilation optimization without affecting the front-end script.

[0099] S18: Refresh the report on the system page to generate financial consolidated report data such as balance sheet and income statement.

[0100] S19: When checking the balance sheet, income statement and other report data on the system page, an error message is displayed. Click the error message to view the specific error data.

[0101] S20: In combination with the financial statement consolidation business, coordinate the boundaries, equations, balances and other relationships scattered in each statement as well as the cross-checking and verification relationships between statements, summarize, refine and integrate to form a financial statement consolidation verification model.

[0102] It should be understood that although Figure 1 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. For example, step 110 and step 120 can be executed at the same time, or step 120 can be executed before step 110. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 1 At least part of the steps may include multiple sub-steps or multiple stages. These sub-steps or stages are not necessarily executed at the same time, but can be executed at different times. The execution order of these sub-steps or stages is not necessarily sequential, but can be executed in turn or alternately with other steps or at least part of the sub-steps or stages of other steps.

[0103] Embodiment 3

[0104] In this embodiment, Figure 2 As shown, a data verification processing device is provided, comprising:

[0105] The indicator code obtaining module 210 is used to encode each data indicator based on a first preset rule to obtain a plurality of indicator codes;

[0106] A dimension value code obtaining module 220 is used to encode the time dimension of each of the data indicators based on a second preset rule to obtain multiple dimension value codes;

[0107] The cell code associating module 230 is used to obtain a report preparation instruction, generate a consolidated report in response to the report preparation instruction, and associate the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0108] A verification formula generation module 240 is used to obtain a formula editing instruction, respond to the formula editing instruction, and generate a verification formula for the combined report based on the indicator code and the dimension value code;

[0109] The verification calculation module 250 is used to calculate the verification formula of the combined report based on the indicator code and the dimension value code, and obtain the verification result of the combined report based on the calculation result of the verification formula.

[0110] In one embodiment, the verification formula generation module includes:

[0111] An in-table verification formula generation submodule is used to obtain a first formula editing instruction, respond to the first formula editing instruction, and generate an in-table verification formula of the consolidated report based on the indicator code and the dimension value code;

[0112] The inter-table verification formula generation submodule is used to obtain a second formula editing instruction, respond to the second formula editing instruction, and generate an inter-table verification formula for the combined report based on the indicator code and the dimension value code.

[0113] In one embodiment, the verification calculation module includes:

[0114] A verification formula calculation submodule, used to calculate the verification formula of the consolidated report based on the indicator code and the dimension value code;

[0115] A matching detection submodule is used to detect whether the calculation result of the verification formula of the combined report matches the preset result;

[0116] The error information output submodule is used to output an error message when the calculation result of the verification formula of the combined report matches the preset result.

[0117] In one embodiment, the verification calculation module further includes:

[0118] The data display submodule is used to obtain a click instruction for the error information, and in response to the error instruction, display the data in the data report corresponding to the error information.

[0119] In one embodiment, the data verification processing device further includes:

[0120] The executable program production module is used to obtain executable program compilation instructions, and in response to the executable program compilation instructions, generate an executable program according to the verification formula of the combined report.

[0121] For the specific definition of the data verification processing device, please refer to the definition of the data verification processing method above, which will not be repeated here. Each unit in the above-mentioned data verification processing device can be implemented in whole or in part by software, hardware and a combination thereof. The above-mentioned units can be embedded in or independent of the processor in the computer device in the form of hardware, or can be stored in the memory of the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above-mentioned units.

[0122] Embodiment 4

[0123] In this embodiment, a computer device is provided. Its internal structure diagram can be shown as follows: Figure 3 As shown. The computer device includes a processor, a memory, a network interface, a display screen and an input device connected through a system bus. Among them, 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, and the non-volatile storage medium is deployed with a database, which is used to store data reports. The internal memory provides an environment for the operation of the operating system and computer program in the non-volatile storage medium. The network interface of the computer device is used to communicate with other computer devices that have deployed application software. When the computer program is executed by the processor, a data verification processing method is implemented. The display screen of the computer device 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 covered on the display screen, or a key, trackball or touchpad set on the computer device housing, or an external keyboard, touchpad or mouse, etc.

[0124] Those skilled in the art will understand that Figure 3 The structure shown in the figure is only a block diagram of a part of the 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 those shown in the figure, or combine certain components, or have a different arrangement of components.

[0125] In one embodiment, a computer device is provided, 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:

[0126] Based on the first preset rule, each data indicator is encoded to obtain multiple indicator codes;

[0127] Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes;

[0128] Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0129] Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0130] Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

[0131] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0132] Obtaining a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table verification formula for the combined report based on the indicator code and the dimension value code;

[0133] A second formula editing instruction is obtained, and in response to the second formula editing instruction, an inter-table verification formula of the combined report is generated based on the indicator code and the dimension value code.

[0134] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0135] Calculate the verification formula of the combined report based on the indicator code and the dimension value code;

[0136] Check whether the calculation result of the verification formula of the combined report matches the preset result;

[0137] When the calculation result of the verification formula of the combined report matches the preset result, an error message is output.

[0138] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0139] A click instruction for the error information is obtained, and in response to the error instruction, data in the data report corresponding to the error information is displayed.

[0140] In one embodiment, when the processor executes the computer program, the processor further implements the following steps:

[0141] Obtaining executable program compilation instructions, and generating an executable program according to the verification formula of the combined report in response to the executable program compilation instructions.

[0142] Embodiment 5

[0143] In this 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 following steps are implemented:

[0144] Based on the first preset rule, each data indicator is encoded to obtain multiple indicator codes;

[0145] Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes;

[0146] Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report;

[0147] Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code;

[0148] Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

[0149] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0150] Obtaining a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table verification formula for the combined report based on the indicator code and the dimension value code;

[0151] A second formula editing instruction is obtained, and in response to the second formula editing instruction, an inter-table verification formula of the combined report is generated based on the indicator code and the dimension value code.

[0152] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0153] Calculate the verification formula of the combined report based on the indicator code and the dimension value code;

[0154] Check whether the calculation result of the verification formula of the combined report matches the preset result;

[0155] When the calculation result of the verification formula of the combined report matches the preset result, an error message is output.

[0156] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0157] A click instruction for the error information is obtained, and in response to the error instruction, data in the data report corresponding to the error information is displayed.

[0158] In one embodiment, when the computer program is executed by a processor, the following steps are also implemented:

[0159] Obtaining executable program compilation instructions, and generating an executable program according to the verification formula of the combined report in response to the executable program compilation instructions.

[0160] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods 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 memory, storage, database or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0161] 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 specification.

[0162] The above-mentioned 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 invention patent. 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 patent of the present application shall be subject to the attached claims.

Claims

1. A data verification processing method, characterized in that: include: Based on the first preset rule, each data indicator is encoded to obtain a plurality of indicator codes, wherein the data indicator is an indicator of the data in the data report, which is a general term for the same type of data, and one data indicator corresponds to one type of data; Based on the second preset rule, the time dimension of each of the data indicators is encoded to obtain multiple dimension value codes, wherein the time dimension is the time corresponding to the data indicator; Obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report; Obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code; Based on the indicator code and the dimension value code, a verification formula of the combined report is calculated, and based on the calculation result of the verification formula, a verification result of the combined report is obtained.

2. The method according to claim 1, characterized in that The step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code comprises: Obtaining a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table verification formula for the combined report based on the indicator code and the dimension value code; A second formula editing instruction is obtained, and in response to the second formula editing instruction, an inter-table verification formula of the combined report is generated based on the indicator code and the dimension value code.

3. The method according to claim 1, characterized in that The step of calculating the verification formula of the combined report based on the indicator code and the dimension value code, and obtaining the verification result of the combined report based on the calculation result of the verification formula includes: Calculate the verification formula of the combined report based on the indicator code and the dimension value code; Check whether the calculation result of the verification formula of the combined report matches the preset result; When the calculation result of the verification formula of the combined report matches the preset result, an error message is output.

4. The method according to claim 3, characterized in that The step of outputting the error information further includes: A click instruction for the error information is obtained, and in response to the click instruction for the error information, data in the data report corresponding to the error information is displayed.

5. The method according to any one of claims 1 to 4, characterized in that: After the step of obtaining the formula editing instruction, responding to the formula editing instruction, and generating the verification formula of the combined report based on the indicator code and the dimension value code, the following steps are further included: Obtaining executable program compilation instructions, and generating an executable program according to the verification formula of the combined report in response to the executable program compilation instructions.

6. A data verification processing device, characterized in that: include: An indicator code obtaining module, used to encode each data indicator based on a first preset rule to obtain a plurality of indicator codes, wherein the data indicator is an indicator of the data in the data report, which is a general term for the same type of data, and one data indicator corresponds to one type of data; A dimension value code obtaining module, used to encode the time dimension of each of the data indicators based on a second preset rule to obtain multiple dimension value codes, wherein the time dimension is the time corresponding to the data indicator; A cell code associating module, used for obtaining a report preparation instruction, generating a consolidated report in response to the report preparation instruction, and associating the indicator code and the one-dimensional value code with each designated cell in the consolidated report; A verification formula generation module, used for obtaining a formula editing instruction, responding to the formula editing instruction, and generating a verification formula for the combined report based on the indicator code and the dimension value code; A verification calculation module is used to calculate the verification formula of the combined report based on the indicator code and the dimension value code, and obtain the verification result of the combined report based on the calculation result of the verification formula.

7. The device according to claim 6, characterized in that The verification formula generation module includes: An in-table verification formula generation submodule is used to obtain a first formula editing instruction, respond to the first formula editing instruction, and generate an in-table verification formula of the consolidated report based on the indicator code and the dimension value code; The inter-table verification formula generation submodule is used to obtain a second formula editing instruction, respond to the second formula editing instruction, and generate an inter-table verification formula for the combined report based on the indicator code and the dimension value code.

8. The device according to claim 6, characterized in that The verification calculation module comprises: A verification formula calculation submodule, used to calculate the verification formula of the consolidated report based on the indicator code and the dimension value code; A matching detection submodule is used to detect whether the calculation result of the verification formula of the combined report matches the preset result; The error information output submodule is used to output an error message when the calculation result of the verification formula of the combined report matches the preset result.

9. 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 5 are implemented.

10. 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 5 are implemented.

Images