CN111966669B - Report data verification method, device and medium - Google Patents
Report data verification method, device and medium Download PDFInfo
- Publication number
- CN111966669B CN111966669B CN202010603392.6A CN202010603392A CN111966669B CN 111966669 B CN111966669 B CN 111966669B CN 202010603392 A CN202010603392 A CN 202010603392A CN 111966669 B CN111966669 B CN 111966669B
- Authority
- CN
- China
- Prior art keywords
- user
- formula
- report
- function
- custom
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000013524 data verification Methods 0.000 title claims abstract description 16
- 238000004364 calculation method Methods 0.000 claims abstract description 38
- 238000012795 verification Methods 0.000 claims abstract description 18
- 230000006870 function Effects 0.000 claims description 110
- 230000005856 abnormality Effects 0.000 claims description 5
- 230000002159 abnormal effect Effects 0.000 claims description 4
- 238000012935 Averaging Methods 0.000 claims description 3
- 230000008569 process Effects 0.000 abstract description 9
- 230000000007 visual effect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 10
- 238000004590 computer program Methods 0.000 description 7
- 230000009286 beneficial effect Effects 0.000 description 4
- 238000012545 processing Methods 0.000 description 4
- 230000000694 effects Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009471 action Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/0703—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation
- G06F11/0706—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment
- G06F11/0727—Error or fault processing not based on redundancy, i.e. by taking additional measures to deal with the error or fault not making use of redundancy in operation, in hardware, or in data representation the processing taking place on a specific hardware platform or in a specific software environment in a storage system, e.g. in a DASD or network based storage system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application discloses a report data verification method, equipment and medium, wherein the method comprises the following steps: based on a verification request of a user for a specified cell in a report, a first formula custom interface is displayed for the user, wherein the first formula custom interface comprises: a calibrator region, a value region; generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region; calculating according to a user-defined formula to obtain a calculation result; and checking the calculation result and the value input in the appointed cell according to the check symbol input by the user in the check symbol area. In the process of checking the report by the user, the corresponding interface can be displayed at the front end based on the operation of the user, and the visual custom formula is convenient. And the user can also check the custom formula through the corresponding interface at any time to check whether the data is correct or not and meets the requirements or not, and the validity and the correctness of the data can be controlled.
Description
Technical Field
The application relates to the field of data verification, in particular to a report data verification method, report data verification equipment and report data verification media.
Background
In general, staff often need to make reports during the working process to display corresponding data. In the process of making a report, report data is usually required to be displayed and modified through a report tool, and the report type functions are widely applied.
However, most report display components can only realize operations such as filling, displaying, modifying and the like of foreground data, and cannot check whether the filled and calculated data are correct or not and meet the requirements, and the validity of the data cannot be controlled.
Disclosure of Invention
In order to solve the above problems, the present application proposes a report data verification method, including: based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region; generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region; calculating according to the self-defined formula to obtain a calculation result; and verifying the calculation result and the inputted value in the designated cell according to the check character input by the user in the check character area.
In one example, the values include: a fixed value and/or an expression, the expression comprising at least one of a computational function, a macro function, an inter-table access function.
In one example, the computing function includes: at least one of SUM summation function, AVG averaging function, MAX maximum function, MIN minimum function, cell number function in REF report, PERCENT percentage function; the macro function includes: at least one of KJQJ current period, DWNM unit inner code, CURDATE current date, USERNAME user name and BBLX report type.
In one example, generating the custom formula corresponding to the specified cell according to the numerical data input by the user in the numerical region includes: based on the appointed operation of the user in the first formula custom interface, a second formula custom interface is displayed for the user, and the second formula custom interface is related to the inter-table number taking function; determining cell data in the cells to be fetched in a database according to the coordinates of the cells to be fetched, which are input by the user in the second formula custom interface; and generating a custom formula corresponding to the designated cell according to the cell data.
In one example, the second formula custom interface includes: a numerical value definition area, a numerical value display area and a numerical value description area; the numerical definition area includes: the to-be-fetched cell part is used for determining the to-be-fetched cell coordinates input by the user; the numerical display area is used for displaying the determined inter-table access function; the numerical description area is used for displaying corresponding description information.
In one example, the calculating according to the custom formula includes: determining whether the custom formula contains the macro function and/or the inter-table access function; if yes, calculating an intermediate result corresponding to the macro function and/or the inter-table access function; and replacing the macro function and/or the inter-table access function in the custom formula with the intermediate result, and calculating to obtain a calculation result.
In one example, calculating the intermediate result corresponding to the inter-table access function includes: extracting each configuration parameter corresponding to the inter-table access function, wherein the configuration parameters comprise at least one of coordinates of cells to be accessed, date, task period, task number, code of the current level, report type, report number, row number and column number; judging whether the user sets the date or the task period; if the task period is set, directly using the task period; if the task period is not set, acquiring the task period corresponding to the date; if not, acquiring the current period as the task period; judging whether the user sets the task number, the current level code, the report type and the report number; if the setting is already set, the method is directly used; if the task number is not set, the current default task number is used; if the current level code and/or the report type are not set, using the current level code and/or the report type of the unit node corresponding to the user; if the report number is not set, the current default report number is used; and determining cell data in the cells to be fetched in a database according to the used configuration parameters, and taking the cell data as an intermediate result corresponding to the inter-table access function.
In one example, the method further comprises: determining that the verification result is abnormal; and positioning the position of the abnormality in the report based on the corresponding operation of the user, and displaying the position to the user.
On the other hand, the application also provides report data verification equipment, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor to enable the at least one processor to: based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region; generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region; calculating according to the self-defined formula to obtain a calculation result; and verifying the calculation result and the inputted value in the designated cell according to the check character input by the user in the check character area.
In another aspect, the present application further provides a non-volatile computer storage medium storing computer executable instructions for report data verification, where the computer executable instructions are configured to: based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region; generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region; calculating according to the self-defined formula to obtain a calculation result; and verifying the calculation result and the inputted value in the designated cell according to the check character input by the user in the check character area.
The report data verification method provided by the application has the following beneficial effects:
in the process of checking the report by the user, the corresponding interface can be displayed at the front end based on the operation of the user, and the visual custom formula is convenient. And the user can also check the custom formula through the corresponding interface at any time to check whether the data is correct or not and meets the requirements or not, and the validity and the correctness of the data can be controlled.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute an undue limitation to the application. In the drawings:
FIG. 1 is a schematic flow chart of a method for checking report data in an embodiment of the present application;
FIG. 2 is a schematic diagram of a report data checking device in an embodiment of the present application;
FIG. 3 is a schematic diagram of a first formula custom interface according to an embodiment of the present application;
FIG. 4 is a schematic diagram of a second formula custom interface according to an embodiment of the present application;
fig. 5 is a schematic diagram of a report data checking device in an embodiment of the present application.
Detailed Description
For the purposes, technical solutions and advantages of the present application, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
The following describes in detail the technical solutions provided by the embodiments of the present application with reference to the accompanying drawings.
As shown in fig. 1, an embodiment of the present application provides a report data verification method, including:
s101, based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed for the user, and the first formula custom interface comprises: a verifier region, a numerical region.
The location where data that needs to be verified is located may first be referred to as a designated cell. The form of the designated cells may be different according to the report form, and will not be described herein. When a user wants to check for a specified cell, a corresponding check request may be initiated. The verification request may be initiated by a user action, such as double clicking on a designated cell, right clicking followed by selection, etc.
When the user initiates the verification request, the program for verifying may present the user with the first formula custom interface. The first formula custom interface may be as shown in fig. 3, and includes a verifier region, a numerical value region, and an explanation region. The check character area is a filling-in item for a user to input a check character, the numerical value area is a filling-in item for the user to input a corresponding numerical value, and the description area is a filling-in item for describing the check character and/or the numerical value. And when the user wants to add the verification for the designated cell, the user can select the adding row as in fig. 3 to add the corresponding custom formula for verification, and when the user wants to stop the verification for the designated cell, the user can select the deleting row to delete the corresponding custom formula. It should be noted that different tasks correspond to different character attributes. In the same task, different periods also correspond to different period attributes. In the same period, different reports may exist, corresponding to different report attributes.
Specifically, the check symbol may include symbols representing comparison such as >, <, =, +.gtoreq.and the like, and the numerical value may be a fixed value, an expression, or both. The expression can support various data acquisition modes, can comprise a calculation function corresponding to a basic Excel table formula, a macro function of system information such as system time and the like, an inter-table fetch function in other tasks or periods and the like, and also supports various formula mixed definition.
Further, the computing function may include: SUM summing function, AVG averaging function, MAX maximum function, MIN minimum function, cell number in REF report function, per cent percentage function, etc.
The macro function may include: KJQJ current period, DWNM unit inner code, CURDATE current date, USERNAME user name, BBLX report type, etc. And supporting a custom display format for the date in the MACRO function, wherein the default display format of the current date of CURDATE is yyyyMMdd, the formula is MACRO (@ CURDATE@), when the custom display format is needed, the date can be defined as MACRO (@ CURDATE#yyyy-MM-dd# @), and the date display format is yyyyy-MM-dd.
Different from the cell access function in the REF report, the cells extracted by the cell access function in the REF report are cells in the report, the inter-table access function does not limit the extracted report, and cell data in the corresponding report can be extracted according to the requirements of users.
S102, generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region.
When the user edits the custom formula, the user can input corresponding numerical data in the numerical region in the first custom interface, and then the program can generate the custom formula according to the numerical data. If the user inputs only a fixed value, a calculation function and a macro function, the fixed value, the calculation function and the macro function may be directly input in the first user-defined interface, or may be input in a new interface. If the user also wants to input the inter-table access function, a specified operation, such as double-clicking in a numerical region, may be performed first in the first formula custom interface. Then, the program itself can display a second formula custom interface to the user, and the user performs the operation related to the table number taking function on the second formula custom interface, namely, inputs the coordinates of the to-be-taken cell on the second formula custom interface. The program can find the corresponding to-be-fetched cell according to the to-be-fetched cell coordinates in the database, and extract cell data in the to-be-fetched cell. Finally, a custom formula corresponding to the designated cell can be generated according to the cell data and other numerical data input by the user.
Specifically, as shown in fig. 4, the second formula custom interface may include: a numerical value definition area, a numerical value display area and a numerical value description area. Wherein, the numerical definition area is the area at the lower right in fig. 4, and may include: the cell portion to be fetched, i.e., the cell dialog in fig. 4. The to-be-fetched cell part is used for determining to-be-fetched cell coordinates input by a user. The numerical display area is the upper area in fig. 4 for displaying the inter-table access function that the user has entered. The numerical description area is the area at the lower left in fig. 4, and is mainly used for displaying corresponding description information.
Further, in the numerical definition area, a date part (corresponding to the year, month, date in fig. 4), a task number part, a task period part, a code part of the present stage, a report type part, a report number part, a line number part, a column number part, and the like may be included in addition to the cell part to be fetched. The task number selectable range is the task with authority of the current user; the task period selection range is distinguished according to the selected task type; the code of the current level is the code corresponding to the organization unit to which the user belongs; the report number selection range is the report under the selected task. The format of the table access function may be set by the user, for example, the format may be BJQS (year, month, date, task period, task number, current level code, report type, report number, cell coordinates, cell row ord, cell column ord), but other formats may also be used, which will not be described herein. In actual operation, the formats are (,, 2019004004, Z201901,190326,1, Z201901026, 2, 5), which represent the Z201901 task, 2019004004 task period, the code of this stage is 190326 and the report type is 1 node, and the row orde of the report with the number Z201901026 is 2 columns of data of the to-be-fetched unit cell with the orde of 5. Of course, in the actual working process, when the user inputs the coordinates of the cells to be fetched, the row number and the column number are determined, and the related data of the coordinates of the cells to be fetched can not be displayed in the format.
In addition, in the second public custom interface, for each configuration parameter of the inter-table access function, the coordinates of the cells to be accessed are necessary entries, and the formats can be, for example, B2 and C35, the row number and the column number cannot be manually input, and can be automatically generated according to the coordinates of the cells to be accessed. And other configuration parameters are selected and filled, if not set, the configuration parameters are default to be empty strings in the formula or are automatically generated according to a preset rule. The year, month, and date represent the difference between the target date and the current date, and the task period represents the target task period, and only one of them can be set.
After each configuration parameter is configured, for example, the corresponding button in fig. 4 may be clicked, and the corresponding table access function is generated in the upper numerical display area. After the inter-table access function is configured, the corresponding button can be continuously clicked in the second public user-defined interface to fill the inter-table access function into the user-defined formula and store the inter-table access function into the database.
S103, calculating according to the self-defined formula to obtain a calculation result.
And S104, checking the calculation result and the input value in the designated cell according to the check symbol input by the user in the check symbol area.
After the self-defined formula is determined, calculation can be performed according to the self-defined formula, and a calculation result is obtained. Then, according to the check symbol which is input by the user, comparing the calculation result with the value which is input in the appointed cell, and if the comparison result accords with the check symbol, checking is successful without exception; if the comparison result does not accord with the check character, the check failure has abnormality. Of course, when checking, all the designated cells in the report can be checked.
Specifically, when the calculation result is calculated according to the custom formula, it may be first determined whether the custom formula includes a macro function and/or an inter-table access function. If the macro function and/or the inter-table access function exist, calculating an intermediate result corresponding to the macro function and/or the inter-table access function, replacing the macro function and/or the inter-table access function in the custom formula by the intermediate result, and then calculating the custom formula to obtain a calculation result.
Further, when calculating the intermediate result corresponding to the inter-table access function, each configuration parameter in the inter-table access function may be extracted first, where the configuration parameter includes the coordinates of the cell to be accessed, the date, the task period, the task number, the code of the present stage, the report type, the report number, the row number, the column number, and the like. And then determines whether the user has set a date or a task period. If the task periods are set, the task periods are directly used. If the task period is not set and the date is set, the task period corresponding to the date is acquired. And if not, acquiring the current period as a task period. And then judging whether the user sets a task number, a current level code, a report type and a report number. If so, the corresponding configuration parameters can be directly used; if the task number is not set, the current default task number is used; if the current level code and/or the report type are not set, the current level code and/or the report type of the unit node corresponding to the user are set; if the report number is not set, the current default report number is used. And finally, according to each used configuration parameter, determining cell data in the cells to be fetched in a database, and filling the cell data into a custom formula as an intermediate result corresponding to an inter-table access function.
In one embodiment, if the verification result in the report is abnormal, as shown in fig. 5, the abnormal result in the report may be displayed in a corresponding interface, that is, in a lower area in fig. 5. And then the user can perform corresponding operations, such as clicking, namely the position with the abnormality in the report can be positioned and displayed to the user, so that the user can find the position with the abnormality as soon as possible.
As shown in fig. 2, the embodiment of the present application further provides a report data verification device, including:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region;
generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region;
calculating according to the self-defined formula to obtain a calculation result;
and verifying the calculation result and the inputted value in the designated cell according to the check character input by the user in the check character area.
The embodiment of the application also provides a non-volatile computer storage medium for checking report data, which stores computer executable instructions, wherein the computer executable instructions are set as follows:
based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region;
generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region;
calculating according to the self-defined formula to obtain a calculation result;
and verifying the calculation result and the inputted value in the designated cell according to the check character input by the user in the check character area.
All embodiments in the application are described in a progressive manner, and identical and similar parts of all embodiments are mutually referred, so that each embodiment mainly describes differences from other embodiments. In particular, for the apparatus and medium embodiments, the description is relatively simple, as it is substantially similar to the method embodiments, with reference to the section of the method embodiments being relevant.
The devices and media provided in the embodiments of the present application are in one-to-one correspondence with the methods, so that the devices and media also have similar beneficial technical effects as the corresponding methods, and since the beneficial technical effects of the methods have been described in detail above, the beneficial technical effects of the devices and media are not described in detail herein.
It will be appreciated by those skilled in the art that embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.
Claims (6)
1. A report data verification method is characterized by comprising the following steps:
based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region;
generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region;
calculating according to the self-defined formula to obtain a calculation result;
according to the check symbol input by the user in the check symbol area, checking the calculation result and the input value in the appointed cell;
according to the numerical data input by the user in the numerical area, generating a custom formula corresponding to the designated cell comprises the following steps:
based on the appointed operation of the user in the first formula custom interface, a second formula custom interface is displayed for the user, and the second formula custom interface is related to the inter-table number taking function;
determining cell data in the cells to be fetched in a database according to the coordinates of the cells to be fetched, which are input by the user in the second formula custom interface;
generating a custom formula corresponding to the designated cell according to the cell data;
wherein the second formula custom interface comprises: a numerical value definition area, a numerical value display area and a numerical value description area;
the numerical definition area includes: the to-be-fetched cell part is used for determining the to-be-fetched cell coordinates input by the user;
the numerical display area is used for displaying the determined inter-table access function;
the numerical value description area is used for displaying corresponding description information;
calculating according to the self-defined formula to obtain a calculation result, wherein the calculation result comprises:
determining whether the custom formula contains the macro function and/or the inter-table access function;
if yes, calculating an intermediate result corresponding to the macro function and/or the inter-table access function;
replacing the macro function and/or the inter-table access function in the custom formula with the intermediate result, and calculating to obtain a calculation result;
calculating an intermediate result corresponding to the inter-table access function, including:
extracting each configuration parameter corresponding to the inter-table access function, wherein the configuration parameters comprise at least one of coordinates of cells to be accessed, date, task period, task number, code of the current level, report type, report number, row number and column number;
judging whether the user sets the date or the task period;
if the task period is set, directly using the task period; if the task period is not set, acquiring the task period corresponding to the date; if not, acquiring the current period as the task period;
judging whether the user sets the task number, the current level code, the report type and the report number;
if the setting is already set, the method is directly used; if the task number is not set, the current default task number is used; if the current level code and/or the report type are not set, using the current level code and/or the report type of the unit node corresponding to the user; if the report number is not set, the current default report number is used;
and determining cell data in the cells to be fetched in a database according to the used configuration parameters, and taking the cell data as an intermediate result corresponding to the inter-table access function.
2. The method of claim 1, wherein the numerical values include: a fixed value and/or an expression, the expression comprising at least one of a computational function, a macro function, an inter-table access function.
3. The method of claim 2, wherein the computing function comprises: at least one of SUM summation function, AVG averaging function, MAX maximum function, MIN minimum function, cell number function in REF report, PERCENT percentage function;
the macro function includes: at least one of KJQJ current period, DWNM unit inner code, CURDATE current date, USERNAME user name and BBLX report type.
4. The method according to claim 1, wherein the method further comprises:
determining that the verification result is abnormal;
and positioning the position of the abnormality in the report based on the corresponding operation of the user, and displaying the position to the user.
5. A report data verification apparatus, comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region;
generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region;
calculating according to the self-defined formula to obtain a calculation result;
according to the check symbol input by the user in the check symbol area, checking the calculation result and the input value in the appointed cell;
according to the numerical data input by the user in the numerical area, generating a custom formula corresponding to the designated cell comprises the following steps:
based on the appointed operation of the user in the first formula custom interface, a second formula custom interface is displayed for the user, and the second formula custom interface is related to the inter-table number taking function;
determining cell data in the cells to be fetched in a database according to the coordinates of the cells to be fetched, which are input by the user in the second formula custom interface;
generating a custom formula corresponding to the designated cell according to the cell data;
wherein the second formula custom interface comprises: a numerical value definition area, a numerical value display area and a numerical value description area;
the numerical definition area includes: the to-be-fetched cell part is used for determining the to-be-fetched cell coordinates input by the user;
the numerical display area is used for displaying the determined inter-table access function;
the numerical value description area is used for displaying corresponding description information;
calculating according to the self-defined formula to obtain a calculation result, wherein the calculation result comprises:
determining whether the custom formula contains the macro function and/or the inter-table access function;
if yes, calculating an intermediate result corresponding to the macro function and/or the inter-table access function;
replacing the macro function and/or the inter-table access function in the custom formula with the intermediate result, and calculating to obtain a calculation result;
calculating an intermediate result corresponding to the inter-table access function, including:
extracting each configuration parameter corresponding to the inter-table access function, wherein the configuration parameters comprise at least one of coordinates of cells to be accessed, date, task period, task number, code of the current level, report type, report number, row number and column number;
judging whether the user sets the date or the task period;
if the task period is set, directly using the task period; if the task period is not set, acquiring the task period corresponding to the date; if not, acquiring the current period as the task period;
judging whether the user sets the task number, the current level code, the report type and the report number;
if the setting is already set, the method is directly used; if the task number is not set, the current default task number is used; if the current level code and/or the report type are not set, using the current level code and/or the report type of the unit node corresponding to the user; if the report number is not set, the current default report number is used;
and determining cell data in the cells to be fetched in a database according to the used configuration parameters, and taking the cell data as an intermediate result corresponding to the inter-table access function.
6. A non-volatile computer storage medium storing computer executable instructions for report data verification, the computer executable instructions configured to:
based on a verification request of a user for a designated cell in a report, a first formula custom interface is displayed to the user, wherein the first formula custom interface comprises: a calibrator region, a value region;
generating a custom formula corresponding to the designated cell according to the numerical data input by the user in the numerical region;
calculating according to the self-defined formula to obtain a calculation result;
according to the check symbol input by the user in the check symbol area, checking the calculation result and the input value in the appointed cell;
according to the numerical data input by the user in the numerical area, generating a custom formula corresponding to the designated cell comprises the following steps:
based on the appointed operation of the user in the first formula custom interface, a second formula custom interface is displayed for the user, and the second formula custom interface is related to the inter-table number taking function;
determining cell data in the cells to be fetched in a database according to the coordinates of the cells to be fetched, which are input by the user in the second formula custom interface;
generating a custom formula corresponding to the designated cell according to the cell data;
wherein the second formula custom interface comprises: a numerical value definition area, a numerical value display area and a numerical value description area;
the numerical definition area includes: the to-be-fetched cell part is used for determining the to-be-fetched cell coordinates input by the user;
the numerical display area is used for displaying the determined inter-table access function;
the numerical value description area is used for displaying corresponding description information;
calculating according to the self-defined formula to obtain a calculation result, wherein the calculation result comprises:
determining whether the custom formula contains the macro function and/or the inter-table access function;
if yes, calculating an intermediate result corresponding to the macro function and/or the inter-table access function;
replacing the macro function and/or the inter-table access function in the custom formula with the intermediate result, and calculating to obtain a calculation result;
calculating an intermediate result corresponding to the inter-table access function, including:
extracting each configuration parameter corresponding to the inter-table access function, wherein the configuration parameters comprise at least one of coordinates of cells to be accessed, date, task period, task number, code of the current level, report type, report number, row number and column number;
judging whether the user sets the date or the task period;
if the task period is set, directly using the task period; if the task period is not set, acquiring the task period corresponding to the date; if not, acquiring the current period as the task period;
judging whether the user sets the task number, the current level code, the report type and the report number;
if the setting is already set, the method is directly used; if the task number is not set, the current default task number is used; if the current level code and/or the report type are not set, using the current level code and/or the report type of the unit node corresponding to the user; if the report number is not set, the current default report number is used;
and determining cell data in the cells to be fetched in a database according to the used configuration parameters, and taking the cell data as an intermediate result corresponding to the inter-table access function.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010603392.6A CN111966669B (en) | 2020-06-29 | 2020-06-29 | Report data verification method, device and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010603392.6A CN111966669B (en) | 2020-06-29 | 2020-06-29 | Report data verification method, device and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111966669A CN111966669A (en) | 2020-11-20 |
| CN111966669B true CN111966669B (en) | 2024-03-15 |
Family
ID=73361078
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010603392.6A Active CN111966669B (en) | 2020-06-29 | 2020-06-29 | Report data verification method, device and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111966669B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114281463B (en) * | 2021-12-29 | 2024-05-10 | 浪潮通用软件有限公司 | Form interface format configuration and interface display method, device and medium |
| CN115346601B (en) * | 2022-10-18 | 2023-01-03 | 昭衍（苏州）新药研究中心有限公司 | DNA/RNA experimental data analysis, verification and access system |
| CN115587577A (en) * | 2022-12-13 | 2023-01-10 | 西安葡萄城软件有限公司 | Method and device for drawing mini-graph based on formula in spreadsheet |
| CN115879429B (en) * | 2023-02-01 | 2023-06-27 | 天津联想协同科技有限公司 | Electronic form verification method and device, electronic equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106899411A (en) * | 2016-12-08 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of method of calibration and device based on identifying code |
| CN109710237A (en) * | 2019-01-10 | 2019-05-03 | 厦门商集网络科技有限责任公司 | A kind of online modification method of calibration and equipment based on customized two-dimentional report |
| CN111144082A (en) * | 2019-12-23 | 2020-05-12 | 中国建设银行股份有限公司 | Multi-table iterative calculation method and device, electronic equipment and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090172063A1 (en) * | 2007-12-26 | 2009-07-02 | Microsoft Corporation | Multi-Threaded Codeless User-Defined Functions |
-
2020
- 2020-06-29 CN CN202010603392.6A patent/CN111966669B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103714480A (en) * | 2013-12-30 | 2014-04-09 | 山东中创软件工程股份有限公司 | Self-defined financial statement generation system |
| CN106899411A (en) * | 2016-12-08 | 2017-06-27 | 阿里巴巴集团控股有限公司 | A kind of method of calibration and device based on identifying code |
| CN109710237A (en) * | 2019-01-10 | 2019-05-03 | 厦门商集网络科技有限责任公司 | A kind of online modification method of calibration and equipment based on customized two-dimentional report |
| CN111144082A (en) * | 2019-12-23 | 2020-05-12 | 中国建设银行股份有限公司 | Multi-table iterative calculation method and device, electronic equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 管理报表系统用户自定义函数解析器算法实现;陈新林;张双武;;武汉理工大学学报(信息与管理工程版)(第03期);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111966669A (en) | 2020-11-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111966669B (en) | Report data verification method, device and medium | |
| KR101999409B1 (en) | Formatting data by example | |
| CN108958959B (en) | Method and device for detecting hive data table | |
| CN110929965A (en) | Project risk assessment method and device | |
| CN115114146A (en) | Interface test method, device, equipment and storage medium | |
| CN111723004B (en) | Measurement method for agile software development, measurement data output method and device | |
| CN116719795A (en) | Data migration method, device, equipment, medium and product of heterogeneous database | |
| US20200320632A1 (en) | Method and system for time series data quality management | |
| CN116301856A (en) | Design method, device, equipment and medium of visual form designer | |
| CN115309730A (en) | Data auditing method and device, electronic equipment and storage medium | |
| CN115129590A (en) | Test case generation method and device, electronic equipment and storage medium | |
| CN114817209A (en) | Monitoring rule processing method and device, processor and electronic equipment | |
| CN112396398A (en) | Cooperative office document processing method and device | |
| CN114281427A (en) | Method and equipment for batch parameter configuration and verification | |
| CN103678636A (en) | System and method for improving reliability of component software system | |
| CN110109980A (en) | Regular inspection material generation method, device, computer equipment and storage medium | |
| CN113781016B (en) | Method, system, equipment and storage medium for updating account information | |
| CN117851408A (en) | User default value processing method, device and medium based on cache | |
| CN117371414A (en) | Method and device for generating data table | |
| CN117608725A (en) | Method, equipment and medium for generating description document of API (application program interface) | |
| CN115271902A (en) | Budget processing method, device, equipment and medium for account statement sheet | |
| CN117762667A (en) | System fault plan generation method and device, storage medium and electronic equipment | |
| CN117611115A (en) | Salary generation method, system, storage medium and processor | |
| CN117492817A (en) | Processing method and device of environment configuration information, storage medium and electronic equipment | |
| CN115713353A (en) | Method, equipment and medium for realizing product inventory based on ERP system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20240218 Address after: 250000 Langchao Science Park, No. 1036, Langchao Road, high tech Zone, Jinan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Country or region after: China Address before: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. Country or region before: China |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |