阅读说明：本技术 数据校验处理方法、装置、计算机设备和存储介质 (Data verification processing method and device, computer equipment and storage medium ) 是由 柳美 李晓阳 高伟 张文兵 于 2021-08-20 设计创作，主要内容包括：本发明提供一种数据校验处理方法、装置、计算机设备和存储介质,该方法包括对数据报表中的各数据指标进行编码,获得多个指标编码；对数据报表中的各数据指标的时间维度进行编码,获得多个维值编码；响应于编制报表指令,生成合并报表,对合并报表内的各指定单元格关联一指标编码和一维值编码；响应公式编辑指令,基于指标编码和维值编码,生成合并报表的校验公式；基于指标编码和维值编码,计算合并报表的校验公式,基于校验公式的计算结果获得合并报表的校验结果。通过对合并报表内的单元格分别关联指标编码和维值编码,校验公式不受合并报表中数据指标所在单元格的位置调整的影响,节省合并报表的运维成本,提升财务合并报表的数据质量。(The invention provides a data verification processing method, a device, computer equipment and a storage medium, wherein the method comprises the steps of coding each data index in a data report to obtain a plurality of index codes; coding the time dimension of each data index in the data report to obtain a plurality of dimensional value codes; generating a combined report in response to the report compiling instruction, and associating an index code and a one-dimensional value code with each appointed cell in the combined report; responding to a formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code; and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula. By respectively associating the index code and the dimension value code with the cells in the combined report, the check formula is not influenced by the position adjustment of the cells where the data indexes are located in the combined report, the operation and maintenance cost of the combined report is saved, and the data quality of the financial combined report is improved.)

1. A data verification processing method is characterized by comprising the following steps:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

2. The method according to claim 1, wherein the step of obtaining a formula editing instruction, in response to the formula editing instruction, and generating the check formula of the merged report based on the index code and the dimension code comprises:

acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table check formula of the combined report based on the index code and the dimension value code;

and acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table check formula of the combined report based on the index code and the dimension value code.

3. The method according to claim 1, wherein the step of calculating the check formula of the consolidated report based on the index code and the dimension code, and the step of obtaining the check result of the consolidated report based on the calculation result of the check formula comprises:

calculating a check formula of the combined report based on the index code and the dimension value code;

detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and when the calculation result of the check formula of the combined report is matched with the preset result, outputting error information.

4. The method of claim 3, wherein the step of outputting the error information is further followed by:

and acquiring a click instruction of the error information, responding to the error instruction, and displaying the data in the data report corresponding to the error information.

5. The method according to any one of claims 1 to 4, wherein the step of obtaining a formula editing instruction, in response to the formula editing instruction, and generating the check formula of the consolidated report based on the index code and the dimension code further comprises:

and acquiring an executable program compiling instruction, and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

6. A data verification processing apparatus, comprising:

the index code obtaining module is used for coding each data index based on a first preset rule to obtain a plurality of index codes;

the dimension value code obtaining module is used for coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimension value codes;

the cell code association module is used for acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

the check formula generation module is used for acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and the verification calculation module is used for calculating a verification formula of the combined report based on the index code and the dimension value code and obtaining a verification result of the combined report based on a calculation result of the verification formula.

7. The apparatus of claim 6, wherein the check formula generation module comprises:

the in-table check formula generation submodule is used for acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating the in-table check formula of the combined report based on the index code and the dimension value code;

and the inter-table check formula generation sub-module is used for acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating the inter-table check formula of the combined report based on the index code and the dimension value code.

8. The apparatus of claim 6, wherein the verification calculation module comprises:

the check formula calculation submodule is used for calculating a check formula of the combined report based on the index code and the dimension value code;

the matching detection submodule is used for detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and the error information output sub-module is used for outputting error information when the calculation result of the check formula of the combined report is matched with the preset result.

9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 5 when executing the computer program.

10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 5.

Technical Field

The present invention relates to the field of data processing technologies, and in particular, to a data verification processing method and apparatus, a computer device, and a storage medium.

Background

The report can help the user to process a large amount of data, and is a good means for processing data by enterprises and users at present. However, it is not easy to compile the required report information timely and accurately and to ensure the integrity, correctness and consistency of the data after merging the reports, and especially the difficulty of merging reports is multiplied when the number of the reports to be merged is large and the types of the reports are complex.

Disclosure of Invention

In view of the foregoing, it is desirable to provide a data verification processing method, apparatus, computer device and storage medium for solving the above technical problems.

A data verification processing method comprises the following steps:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

In one embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating the check formula of the merged report based on the index code and the dimension code includes:

acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table check formula of the combined report based on the index code and the dimension value code;

and acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table check formula of the combined report based on the index code and the dimension value code.

In one embodiment, the step of calculating a check formula of the consolidated report based on the index code and the dimension code, and obtaining a check result of the consolidated report based on a calculation result of the check formula includes:

calculating a check formula of the combined report based on the index code and the dimension value code;

detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and when the calculation result of the check formula of the combined report is matched with the preset result, outputting error information.

In one embodiment, the step of outputting the error information further comprises:

and acquiring a click instruction of the error information, responding to the error instruction, and displaying the data in the data report corresponding to the error information.

In an embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the merged report based on the index code and the dimension code further includes:

and acquiring an executable program compiling instruction, and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

A data verification processing apparatus, comprising:

the index code obtaining module is used for coding each data index based on a first preset rule to obtain a plurality of index codes;

the dimension value code obtaining module is used for coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimension value codes;

the cell code association module is used for acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

the check formula generation module is used for acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and the verification calculation module is used for calculating a verification formula of the combined report based on the index code and the dimension value code and obtaining a verification result of the combined report based on a calculation result of the verification formula.

In one embodiment, the check formula generation module includes:

the in-table check formula generation submodule is used for acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating the in-table check formula of the combined report based on the index code and the dimension value code;

and the inter-table check formula generation sub-module is used for acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating the inter-table check formula of the combined report based on the index code and the dimension value code.

In one embodiment, the check computation module comprises:

the check formula calculation submodule is used for calculating a check formula of the combined report based on the index code and the dimension value code;

the matching detection submodule is used for detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and the error information output sub-module is used for outputting error information when the calculation result of the check formula of the combined report is matched with the preset result.

A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor when executing the computer program implements the steps of:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

According to the data verification processing method, the data verification processing device, the computer equipment and the storage medium, the index codes and the dimension value codes are respectively associated with the cells in the combined report, the verification formula is not influenced by the position adjustment of the cells where the data indexes are located in the combined report, the operation and maintenance cost of the combined report is effectively saved, the data quality of the financial combined report is improved, and the difficulty degree of the combined report is reduced.

Drawings

FIG. 1 is a schematic flow chart diagram illustrating a data verification processing method according to an embodiment;

FIG. 2 is a block diagram showing the structure of a data verification processing apparatus according to an embodiment;

FIG. 3 is a diagram illustrating an internal structure of a computer device according to an embodiment.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.

Example one

In this embodiment, as shown in fig. 1, a data verification processing method is provided, which includes:

and step 110, coding each data index based on a first preset rule to obtain a plurality of index codes.

Specifically, the data index is an index of data in the data report, which is a generic name of the same type of data, and it can also be said that a data index corresponds to a type of data. The data report can be a financial report, a material report, or other types of reports, and in this embodiment, the data report is used as a financial report, each data index is a financial data index, and a consolidated report is a financial consolidated report for further explanation.

In this embodiment, the first preset rule may be defined by a user, or may be preset in the system, and is used for encoding the data index, where the first preset rule is an encoding rule. In this embodiment, various types of data indexes contained in the combined report are encoded, and thus each type of data index has a corresponding index code. And coding the data index, namely endowing the data index with the code.

For example, taking a financial report as an example, the financial report includes data indexes such as monetary funds, accounts receivable, business revenue of main business, total business cost, and the like, and the data indexes are respectively encoded to obtain a plurality of index codes such as Z01 to Z08, and the corresponding relationship between each index code and the data index is as follows: z01: monetary fund, Z02: receivables, Z03: electric charge receivable, Z04: chargeable heat fee, Z05: coal charge to be collected, Z06: total revenue of business, Z07: total cost of business, Z08: no profit is allocated.

And 120, coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes.

Specifically, the time dimension is a time corresponding to the data index. The second preset rule may be user defined, or may be preset in the system, and is used to encode the time stamp of the data finger, where the second preset rule is an encoding rule. And coding the time dimension of the data index, namely giving codes to the time dimension of the data index.

For example, the time dimensions included in the financial report include end-of-term balance, last-year same-term number, and beginning-of-year balance, and the time dimensions are encoded respectively to obtain a plurality of dimensional value codes such as T01 to T05, and the corresponding relationship between the time dimension of each data index and the dimensional value code is as follows: t01: end balance, T02: date of year, T03: balance at the beginning of the year, T04: month number, T05: the number of the plants is counted in the year.

Step 130, obtaining a report formulation instruction, responding to the report formulation instruction, generating a combined report, and associating one index code and one-dimensional value code with each appointed cell in the combined report.

In this embodiment, the report formulation instruction is input by a user, the report formulation instruction may be multiple, a financial merged report is generated by multiple report formulation instructions, the financial merged report is formed by merging multiple financial data reports, multiple cells are provided in the merged report, data is recorded in each cell, and the specified cell is a cell selected by the user.

In this embodiment, the designated cell is associated with the index code and the one-dimensional value code, the index code and the dimensional value code are designated in the designated cell, and the index code and the dimensional value code are designated in the data in the designated cell.

Step 140, obtaining a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code.

In this embodiment, the formula editing instruction is input by a user and used for editing the check formula, and in this embodiment, the generated check formula is associated with the index code and the dimension value code, so that the check formula is only associated with the index code and the dimension value code during checking, and is not associated with the position of the cell. The generated check formula is used for checking the combined report and the data of the combined report so as to check whether the data in the combined report is wrong or not.

And 150, calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

In this embodiment, the check formula is calculated based on the index code and the dimension code of the data index, and according to the calculation result of the check formula, the calculation result of the check formula is the check result of the consolidated report, and whether the data of the consolidated report is erroneous can be determined according to the calculation result.

In the above embodiment, the index code and the dimension value code are respectively associated with the cells in the consolidated report, so that the check formula is not affected by the position adjustment of the cells where the data indexes are located in the consolidated report, the operation and maintenance cost of the consolidated report is effectively saved, the data quality of the financial consolidated report is improved, and the difficulty level of consolidating the report is reduced.

In one embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating the check formula of the merged report based on the index code and the dimension code includes: acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table check formula of the combined report based on the index code and the dimension value code; and acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table check formula of the combined report based on the index code and the dimension value code.

Specifically, the check formula includes an intra-table check formula for checking data in the same worksheet in the merged report and an inter-table check formula for checking data in different worksheets in the merged report, and therefore in this embodiment, the intra-table check formula is generated according to the first formula editing instruction, and the inter-table check formula is generated according to the second formula editing instruction, so that the data in the worksheets and the data between the worksheets can be checked respectively.

In an embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating the check formula of the merged report based on the index code and the dimension code further includes: and acquiring a third formula editing instruction, responding to the third formula editing instruction, and generating the complex check formula of the combined report based on the index code and the dimension value code. Specifically, the check formula includes a complex check formula, and the complex check formula is used for checking complex data in the combined report, so in this embodiment, the complex check formula is generated according to the third formula editing instruction, so that the complex data in the table can be checked.

In one embodiment, the step of calculating a check formula of the consolidated report based on the index code and the dimension code, and obtaining a check result of the consolidated report based on a calculation result of the check formula includes: calculating a check formula of the combined report based on the index code and the dimension value code; detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not; and when the calculation result of the check formula of the combined report is matched with the preset result, outputting error information.

Specifically, a calculation result is obtained by calculating the check formula, and the calculation result is compared with a preset result, specifically, the matching detection of the calculation result and the preset result may be to determine whether the calculation result is smaller than the preset result, or whether the calculation result is larger than the preset result, or whether the calculation result is equal to the preset result. And when the calculation result accords with the preset result and is matched with the preset result, the error of the verified data is indicated, error information is output, and the error information is displayed, so that a user can timely know the data with the error in verification. The output information is used for displaying the wrong data and the position of the wrong data in the worksheet, and is convenient for a user to view.

In one embodiment, the step of outputting the error information further comprises: and acquiring a click instruction of the error information, responding to the error instruction, and displaying the data in the data report corresponding to the error information.

In this embodiment, when the calculation result of the check formula matches the preset result, a display frame or a display interface carrying error information is popped up, and the error instruction is an instruction for clicking the display frame or the display interface and is used to open and display data in the data report corresponding to the error information, so that a user can quickly find the error data.

In an embodiment, the step of obtaining a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the merged report based on the index code and the dimension code further includes: and acquiring an executable program compiling instruction, and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

Specifically, the executable program is used to execute the check formula, in this embodiment, the check formula is analyzed, and the compiled check formula is compiled into the executable program through system dynamic compilation. Through dynamic compiling, the difficulty of a user in configuring a formula is reduced, the report can obtain recalculation capacity without the help of codes, the separation of the front end and the back end is realized, and compiling optimization can be realized under the condition that the front end script is not influenced.

Example two

In this embodiment, the consolidated report is a financial consolidated report, and each data index is a financial data index, and the following process is adopted in this embodiment to implement data processing of the consolidated report:

1. coding the financial indexes of the financial consolidated statement, and respectively giving different index codes to the monetary funds, accounts receivable, business income of main operation, total business cost and the like;

2. coding the financial index time dimension of the financial combined report, and respectively endowing different dimensional value codes to the end-of-term balance, the same-term number of the last year and the balance of the beginning of the year;

3. compiling a check formula according to the financial index code and the time dimension value by using an in-table check formula of the financial combination report;

4. compiling a check formula of the inter-table check formula of the financial combination report according to the report code, the financial index code and the time dimension value;

5. the complex check formula of the financial combination report is compiled according to the report code, the financial index code and the time dimension, and the AND, OR logic and nested combination of a plurality of complex conditions are supported;

6. the financial combination report form check formula supports dynamic compiling, the compiled report form check formula is compiled into an executable program, and the difficulty of configuring the formula by a user is reduced through the dynamic compiling, so that the report form obtains recalculation capacity without the help of codes, the separation of the front end and the back end is realized, and compiling optimization can be realized under the condition that the front end is not influenced.

7. And combining the financial statement merging service, comprehensively distributing the relations such as limits, equations, balances and the like dispersed in the statements and the checking relation between the statements, and summarizing, refining and integrating to form a financial statement merging checking model.

The concrete implementation steps are as follows:

s11, the financial indexes of the financial consolidated statement are coded, and different index codes are respectively given to the monetary fund, the receivable account, the business income of the main business, the total business cost and the like; for example, Z01: monetary fund, Z02: receivables, Z03: electric charge receivable, Z04: chargeable heat fee, Z05: coal charge to be collected, Z06: total revenue of business, Z07: total cost of business, Z08: no profit is allocated.

S12: coding the financial index time dimension of the financial combined report, and respectively endowing different dimensional value codes to the end-of-term balance, the same-term number of the last year and the balance of the beginning of the year; for example, T01: end balance, T02: date of year, T03: balance at the beginning of the year, T04: month number, T05: the number of the plants is counted in the year.

S13: compiling a financial combination report, and designating index codes and time dimensions of each cell in the report; for example, the index of the unit cell of the receivable payment-end balance of the balance sheet is encoded as Z03 and the dimension is T01, and the index of the unit cell of the unallocated profit-early balance is encoded as Z08 and the dimension is T03; the index of the unit cell of the profit sheet with no profit allocated in the beginning of the year is encoded as Z08 and dimension T03.

S14: compiling a check formula according to the financial index code and the time dimension value by using an in-table check formula of the financial combination report; for example, if the accounts receivable of the balance sheet should be greater than or equal to the sum of 3 indexes of the electric charge receivable, the heat charge receivable and the coal charge receivable, the calibration formula is compiled as follows:

a $ Z03$ T01< a $ Z04$ T01+ a $ Z05$ T01+ a $ Z06$ T01, which prompts an error message if the data of the balance sheet is verified to match the formula: receivable > -electricity charge + heat charge + coal charge. Where a $ Z03$ T01, a denotes the balance sheet, $ Z03$ T01 denotes the receivables-end balances.

S15: compiling a check formula of the inter-table check formula of the financial combination report according to the report code, the financial index code and the time dimension value; for example, if the unallocated profit-early balance of the profit sheet should be equal to the unallocated profit-early balance of the balance sheet, the calibration formula is formulated as follows:

round (Math.abs (a $ Z08$ T03-b $ Z08$ T03) × 100) >1, if the data of the balance sheet and profit sheet are verified to conform to the formula, an error message is prompted: [ balance table ] unallocated profit | early year balance [ profit table ] unallocated profit | early year balance. Wherein, a in a $ Z08$ T03 represents an asset liability table, b in b $ Z08$ T03 represents a profit table, Z08$ T03 represents unallocated profit-early balance, and Math.abs and Math.round are mathematical operation formulas respectively representing absolute value and round.

S16: the complex check formula of the financial combination report is compiled according to the report code, the financial index code and the time dimension, and the AND, OR logic and nested combination of a plurality of complex conditions are supported; for example, if the number of months in the profit list should be equal to the cumulative number of months minus the cumulative number of months, the check formula is formulated as:

Math.round(Math.abs(b$T04-(b$T05-c$Z02))*100)>1&&b$_rid＝＝c$_rid

where b in b $ T04 denotes a profit table, c in c $ Z02 denotes a profit table of the previous month, "&" denotes an and relation between two conditions before and after, _ rid denotes a code of all indexes in the profit table, and math.abs and math.round are mathematical operation formulas respectively representing absolute value and rounding.

If the data of the profit list is verified to be in accordance with the formula, prompting error information as follows: this month is the cumulative number of this month-the cumulative number of previous months.

And S17, issuing the financial merged report verification formula, dynamically compiling the system, and compiling the compiled report verification formula into an executable program. Through dynamic compiling, the difficulty of a user in configuring a formula is reduced, the report can obtain recalculation capacity without the help of codes, the separation of the front end and the back end is realized, and compiling optimization can be realized under the condition that the front end script is not influenced.

S18: and (4) brushing reports on the system page to generate financial merged report data such as an asset and debt table, a profit table and the like.

S19: and checking statement data such as an asset liability statement, a profit statement and the like on a system page, and prompting error information. Clicking the error information can check specific error data.

S20: and combining the financial statement merging service, comprehensively distributing the relations such as limits, equations, balances and the like dispersed in the statements and the checking relation between the statements, and summarizing, refining and integrating to form a financial statement merging checking model.

It should be understood that, although the steps in the flowchart of fig. 1 are shown in sequence as indicated by the arrows, the steps are not necessarily performed in sequence as indicated by the arrows, for example, the steps 110 and 120 may be performed simultaneously, or the step 120 may be performed before the step 110. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in fig. 1 may include multiple sub-steps or multiple stages that are not necessarily performed at the same time, but may be performed at different times, and the order of performance of the sub-steps or stages is not necessarily sequential, but may be performed in turn or alternately with other steps or at least a portion of the sub-steps or stages of other steps.

EXAMPLE III

In this embodiment, as shown in fig. 2, a data verification processing apparatus is provided, which includes:

an index code obtaining module 210, configured to code each data index based on a first preset rule, so as to obtain a plurality of index codes;

a dimension value code obtaining module 220, configured to code a time dimension of each data indicator based on a second preset rule, so as to obtain multiple dimension value codes;

the cell code association module 230 is configured to obtain a report compiling instruction, generate a consolidated report in response to the report compiling instruction, and associate one index code and one-dimensional value code with each specified cell in the consolidated report;

the check formula generating module 240 is configured to obtain a formula editing instruction, respond to the formula editing instruction, and generate a check formula of the merged report based on the index code and the dimension code;

and the verification calculation module 250 is configured to calculate a verification formula of the merged report based on the index code and the dimension value code, and obtain a verification result of the merged report based on a calculation result of the verification formula.

In one embodiment, the check formula generation module includes:

the in-table check formula generation submodule is used for acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating the in-table check formula of the combined report based on the index code and the dimension value code;

and the inter-table check formula generation sub-module is used for acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating the inter-table check formula of the combined report based on the index code and the dimension value code.

In one embodiment, the check computation module comprises:

the check formula calculation submodule is used for calculating a check formula of the combined report based on the index code and the dimension value code;

the matching detection submodule is used for detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and the error information output sub-module is used for outputting error information when the calculation result of the check formula of the combined report is matched with the preset result.

In one embodiment, the check computation module further comprises:

and the data display sub-module is used for acquiring a click instruction of the error information and responding to the error instruction to display the data in the data report corresponding to the error information.

In one embodiment, the data verification processing apparatus further includes:

and the executable program production module is used for obtaining an executable program compiling instruction and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

For specific limitations of the data verification processing apparatus, reference may be made to the above limitations of the data verification processing method, which is not described herein again. All or part of each unit in the data verification processing device can be realized by software, hardware and a combination thereof. The units can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the units.

Example four

In this embodiment, a computer device is provided. The internal structure thereof may be as shown in fig. 3. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The nonvolatile storage medium stores an operating system and a computer program, and is deployed with a database for storing data reports. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used to communicate with other computer devices that deploy application software. The computer program is executed by a processor to implement a data verification processing method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.

Those skilled in the art will appreciate that the architecture shown in fig. 3 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.

In one embodiment, there is provided a computer device comprising a memory storing a computer program and a processor implementing the following steps when the processor executes the computer program:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

In one embodiment, the processor, when executing the computer program, further performs the steps of:

acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table check formula of the combined report based on the index code and the dimension value code;

and acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table check formula of the combined report based on the index code and the dimension value code.

In one embodiment, the processor, when executing the computer program, further performs the steps of:

calculating a check formula of the combined report based on the index code and the dimension value code;

detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and when the calculation result of the check formula of the combined report is matched with the preset result, outputting error information.

In one embodiment, the processor, when executing the computer program, further performs the steps of:

and acquiring a click instruction of the error information, responding to the error instruction, and displaying the data in the data report corresponding to the error information.

In one embodiment, the processor, when executing the computer program, further performs the steps of:

and acquiring an executable program compiling instruction, and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

EXAMPLE five

In this embodiment, a computer-readable storage medium is provided, on which a computer program is stored, the computer program realizing the following steps when executed by a processor:

coding each data index based on a first preset rule to obtain a plurality of index codes;

coding the time dimension of each data index based on a second preset rule to obtain a plurality of dimensional value codes;

acquiring a report compiling instruction, generating a combined report in response to the report compiling instruction, and associating the index code and the one-dimensional value code with each appointed cell in the combined report;

acquiring a formula editing instruction, responding to the formula editing instruction, and generating a check formula of the combined report based on the index code and the dimension value code;

and calculating a check formula of the combined report based on the index code and the dimension value code, and obtaining a check result of the combined report based on a calculation result of the check formula.

In one embodiment, the computer program when executed by the processor further performs the steps of:

acquiring a first formula editing instruction, responding to the first formula editing instruction, and generating an in-table check formula of the combined report based on the index code and the dimension value code;

and acquiring a second formula editing instruction, responding to the second formula editing instruction, and generating an inter-table check formula of the combined report based on the index code and the dimension value code.

In one embodiment, the computer program when executed by the processor further performs the steps of:

calculating a check formula of the combined report based on the index code and the dimension value code;

detecting whether the calculation result of the check formula of the combined report is matched with a preset result or not;

and when the calculation result of the check formula of the combined report is matched with the preset result, outputting error information.

In one embodiment, the computer program when executed by the processor further performs the steps of:

and acquiring a click instruction of the error information, responding to the error instruction, and displaying the data in the data report corresponding to the error information.

In one embodiment, the computer program when executed by the processor further performs the steps of:

and acquiring an executable program compiling instruction, and generating an executable program according to the check formula of the combined report in response to the executable program compiling instruction.

It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. 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. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.

The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.