CN113191128B - Report checking tool generation method and device and electronic equipment - Google Patents
Report checking tool generation method and device and electronic equipment Download PDFInfo
- Publication number
- CN113191128B CN113191128B CN202110562899.6A CN202110562899A CN113191128B CN 113191128 B CN113191128 B CN 113191128B CN 202110562899 A CN202110562899 A CN 202110562899A CN 113191128 B CN113191128 B CN 113191128B
- Authority
- CN
- China
- Prior art keywords
- column
- data
- row
- report
- preset function
- 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 51
- 230000000452 restraining effect Effects 0.000 claims abstract description 4
- 230000006870 function Effects 0.000 claims description 195
- 238000004364 calculation method Methods 0.000 claims description 14
- 238000000605 extraction Methods 0.000 claims description 7
- 238000012795 verification Methods 0.000 claims description 7
- 238000004891 communication Methods 0.000 claims description 2
- 238000004590 computer program Methods 0.000 claims description 2
- 238000005516 engineering process Methods 0.000 abstract description 4
- 125000004122 cyclic group Chemical group 0.000 description 9
- 238000012360 testing method Methods 0.000 description 6
- 230000018109 developmental process Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000003491 array Methods 0.000 description 2
- 230000012447 hatching Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- NAWXUBYGYWOOIX-SFHVURJKSA-N (2s)-2-[[4-[2-(2,4-diaminoquinazolin-6-yl)ethyl]benzoyl]amino]-4-methylidenepentanedioic acid Chemical compound C1=CC2=NC(N)=NC(N)=C2C=C1CCC1=CC=C(C(=O)N[C@@H](CC(=C)C(O)=O)C(O)=O)C=C1 NAWXUBYGYWOOIX-SFHVURJKSA-N 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000008570 general process Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000010979 ruby Substances 0.000 description 1
- 229910001750 ruby Inorganic materials 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24564—Applying rules; Deductive queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Databases & Information Systems (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a method and a device for generating a report checking tool and electronic equipment, and relates to the field of financial science and technology, wherein the method comprises the following steps: acquiring an operation rule of report data, wherein the operation rule is used for restraining the relation among the data in the rows or columns of the report; extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks; calling a preset write operation function, writing codes for calling a preset function into a VBA editing window of a table, and taking parameters as actual parameters of the preset function; judging whether a group of data positioned by a row label and a column label in actual parameters accords with an operation rule or not when a preset function is executed; writing in codes for displaying the checking result, and further obtaining report checking tool codes; the report checking tool automatically checks whether the data in the report accords with the operation rule when being executed. According to the scheme, the check tool codes are automatically generated according to the report operation rules, and the generated report check tool codes are wide in application range.
Description
Technical Field
The present invention relates to the field of financial science and technology, and in particular, to a method and an apparatus for generating a report checking tool, and an electronic device.
Background
In the version test process, the display of some report data is often required to be tested, and the report data is large in volume and needs to be tested for multiple times, so that a large amount of manpower is required to be consumed for completion. The general process flow of such tests is: after the report data comes out, the service personnel checks the accuracy of the data, completes the first test and submits the test problem. And after repairing the defects, performing a second round of test until all logic verification is completed.
In the test process, the data operation needs to be checked manually one by one, so that a great deal of time is consumed and errors exist.
Disclosure of Invention
The embodiment of the application aims to provide a method and a device for generating a report checking tool and electronic equipment, so that report checking efficiency and accuracy are improved.
In order to solve the above technical problems, an embodiment of the present disclosure provides a method for generating a report verification tool, where the method includes: acquiring an operation rule of report data, wherein the operation rule is used for restricting the relation among the data in the rows or columns of the report; extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks; calling a preset write operation function, writing codes for calling a preset function into a VBA editing window of a table, and taking the parameters as actual parameters of the preset function; judging whether a group of data positioned by a row label and a column label in actual parameters accords with the operation rule or not when the preset function is executed; writing in codes for displaying the checking result, and further obtaining report checking tool codes; the report checking tool automatically checks whether the data in the report accords with the operation rule when being executed.
The embodiment of the specification provides a report checking tool generating device, which comprises: the acquisition module is used for acquiring operation rules of the report data, wherein the operation rules are used for restraining the relation among the data in the rows or columns of the report; the extraction module is used for extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks; the first writing module is used for calling a preset writing operation function, writing codes for calling the preset function into a VBA editing window of a table, and taking the parameters as actual parameters of the preset function; judging whether a group of data positioned by a row label and a column label in actual parameters accords with the operation rule or not when the preset function is executed; the second writing module is used for writing codes for displaying the checking results so as to obtain report checking tool codes; the report checking tool automatically checks whether the data in the report accords with the operation rule when being executed.
According to the report checking tool generating method provided by the embodiment of the specification, the operation rule of report data is obtained, the parameters are extracted from the budget rule, codes for calling the preset function are written into the VBA editing window of one form, the extracted parameters are used as actual parameters of the preset function, when the preset function is executed, whether a group of data positioned by the row mark and the column mark in the actual parameters accords with the operation rule is judged, codes for displaying the checking result are written in, and further, the checking tool codes are obtained, the checking tool can assist in checking the report, so that the data among the reports do not need to be checked manually one by one, the checking efficiency is high, and the accuracy is also high; the report checking tool can also realize the efficient checking of all data, and can also realize the efficient checking of the logic correctness of the management data among different reports. The report form checking tool code is generated automatically according to the operation rules of the report form, and the checking tool code for a specific operation rule is not independently written for the specific operation rule, so that the application range of the generated report form checking tool code is wider.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments described in the present application, and that other drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 shows a schematic diagram of an Excel table and data ranges;
FIG. 2 illustrates a schematic view of a scenario in which a report reconciliation tool is performed;
FIG. 3 is a schematic diagram showing the contents of the report check table;
FIG. 4 shows a flowchart of a method of generating a report reconciliation tool in accordance with an embodiment of the disclosure;
fig. 5 shows a schematic block diagram of a report collation tool generation apparatus according to an embodiment of the present specification.
Detailed Description
In order to make the technical solutions in the present application better understood by those skilled in the art, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, but not all embodiments. All other embodiments, based on the embodiments herein, which would be apparent to one of ordinary skill in the art without undue burden are intended to be within the scope of the present application.
Fig. 1 shows a schematic diagram of an Excel table file (. Xls format), in which a plurality of pages, i.e. sheets, may be included in one table file, each column of the table is denoted by an letter (A, B … … Z), each row of the table is denoted by a number (1, 2, 3 … …), and the data in one table can be uniquely located by a row label and a column label. The row index number is sequentially added with 1, the column index letter is sequentially changed to the next letter in the alphabet, and the column Z is followed by the column AA, the column AB, the column AC … … BA, the column BB and the column BC … ….
Fig. 2 shows four tables to be checked, namely: "Whole channel+all customers. Xls", "Whole channel+no lender. Xls", "Whole channel+lender. Xls", and "Whole channel+institution. Xls". When the tables are checked, the tables can be placed under a folder, and a checking result table (xlsm format) is also placed under the file directory, wherein a checking tool code is arranged in the checking result table, and a control (for example, in a button form) is arranged in the checking result table and used for triggering a report checking tool to automatically execute so as to check the report to be checked, and the checking result is presented in the checking result table. The contents of the collation result table are shown in fig. 3. Clicking on the "check report" button control in fig. 3 triggers the report check tool code to execute. The report form verification tool generation method provided by the specification is to write codes in the VBA editing window of the verification result table.
In the embodiment of the present specification, a specific implementation manner of the embodiment of the present specification is described by taking a checking method of a bank "development table of a proxy payroll service" as an example. This embodiment may be implemented by an electronic device having computing capabilities.
For example, page Sheet1 of one table file is "a substitute payroll development situation table", and the data of the table has the following operation rules therebetween: (1) C=d+e, which is determined to be a transverse comparison according to the fact that the operation rule does not contain a line number or the line numbers are equal; (2) B2> B3+B4+ … … +B7, and it is determined that this is a longitudinal comparison according to the same column numbers in the operation rule. It is assumed that only the data of the table covered by the hatching in fig. 1 need to be checked, or only the table covered by the hatching has data.
For the operation rule (1) of the transverse comparison, the parameters are first extracted according to the rule. The first appearing letter C is used as a first column label, the subsequently appearing letter DE is used as a second column label, the minimum row label of the row filled with data in the query table is 2, the maximum row label is 8, the first appearing operator "=" is used as a first operation relation, and the subsequently appearing operator "+" is used as a fourth operation relation.
Writing code in the VBA editing window is then started. Before that, a packaged first preset function compare1 (table name, page name, first column label, second column label, first operation relation, fourth operation relation, row label) is preset.
Specifically, when writing codes, a first preset function compare1 (inFile (J), infeet (J), C, =, DE, +, k) is filled first, where infieet () is an array in which table names of the report to be checked are stored, and infieet () is also an array in which page names of the report to be checked are stored, and there may be a plurality of pages in one table, and table names and page names stored in corresponding sequence numbers of the two arrays are corresponding, for example, infieet (1), infieet (2), and infieet (3) are different pages in the same table, and table names stored in infieet (1), infieet (2), and infieet (3) are the same. The functions implemented by the codes of the first preset function include: find the table file with table name of inFile (J), and find the page with page name of inSheet (J), obtain Ck, dk, ek data, and compare Ck equal to Dk+Ek, return "pass" when equal, return "do not pass" when unequal.
And assembling codes for circularly calling the first preset function on the basis of the first preset function, so that the first preset function is called once when the data of any one of the 2 nd line to the 8 th line in the figure 1 are checked, and the check of each line in the range of the data to be checked is realized. Specifically, a minimum row index m and a maximum row index n of a data range to be checked can be obtained first; assembling codes for circularly calling a first preset function, wherein a circulating variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function compare1 (inFile (J), inshifet (J), C, =, DE, +, k), which when executed, determines whether the sum of the data of column C and the data of column DE of k rows is equal.
Code for displaying the collation results is then written: sysoutF (J) =sysoutf (J) & compact 1 (inFile (J), inshiet (J), C, DE, =, +, k); the "sysoutF (J) =sysoutf (J) &" code section is used to display the display result in the collation result table shown in fig. 3, that is, the table name, page name to be collated are displayed in correspondence with the collation result.
For the operation rule (2) of the longitudinal comparison, before that, a second preset function compare2 (table name, page name, third column label, third row label, start row label, end row label, second operation relation) is preset.
Specifically, when writing codes, a second preset function compare2 (inFile (J), infeet (J), B,2,3,7, >) is filled first, where infieet () is an array in which table names of the report to be checked are stored, and infieet () is also an array in which page names of the report to be checked are stored, and there may be a plurality of pages in one table, and table names and page names stored in corresponding sequence numbers of the two arrays are corresponding, for example, infieet (1), infieet (2), infieet (3) are different pages in the same table, and table names stored in infieet (1), infieet (2), infieet (3) are the same. The functions implemented by the codes of the second preset function include: find the table file with table name of inFile (J), find the page with page name of inshifet (J), obtain data of B2, and B3 to B7, calculate the sum of data of B3 to B7, and judge whether B2 is greater than the sum, when greater than, return "pass", return "do not pass" if not.
The second preset function compare2 is executed once according to the parameters, so as to verify the operation rule (2) in the table shown in fig. 1.
Based on the above embodiments, the embodiments of the present disclosure provide a method for generating a report verification tool, which may be used for any electronic device with a computing function. As shown in fig. 4, the method comprises the steps of:
S10: and acquiring an operation rule of the report data, wherein the operation rule is used for restraining the relation among the data in the rows or columns of the report.
A report, as used herein, refers to a table that displays data, including table formats and data within the table. Usually, data in the same report needs to be checked, and correlation exists between data in different reports, and the data needs to be checked.
Although the embodiment only provides the checking method of the data in the same report, since the above embodiment provides the operation of opening the report file, when the data between the report J and the report K needs to be checked, only the two reports need to be opened to obtain the data, so the checking method of the report provided by the embodiment can also be used for checking the data between different reports. These different reports may be in the same format, i.e., the content represented by the corresponding columns is consistent, or the content represented by the corresponding rows is consistent.
The operation rule between report data usually originates from business rules, for example, the loan amount of a general bank in a report, the loan amount of a branch of Jiangsu and a branch of Zhejiang are respectively in columns C, D and E, and according to the business rules, "the loan amount of the general bank should be greater than the sum of the loan amount of a branch of Jiangsu and the loan amount of a branch of Zhejiang", the operation rule "C > D+E" can be obtained.
In some embodiments, the calculation rule between report data may also be derived from a calculation formula, for example, the side length of the cube and the volume of the cube are respectively in F columns and G columns, and according to the calculation formula "the volume of the cube=side length×side length", the calculation rule "g=fζ3" may be obtained.
In some embodiments, the operation rule of the F column and the G column may also be g=sinf, g= lnF, and so on, which cannot be exhausted by the embodiments of the present disclosure.
The operation rule in the embodiment of the present disclosure may include arithmetic operations (addition, subtraction, multiplication, division), mathematical operations such as sine and cosine functions, log functions, and other and/or, unequal boolean operations, and relational operations such as greater than, less than, and equal to, which cannot be exhausted by the embodiment of the present disclosure.
The above operation rule may be a mathematical expression program or a text description program.
S20: parameters are extracted from the operation rule, and the parameters at least comprise row marks and/or column marks.
The preset function refers to a function which is packaged, has a defined function name and has a defined function internal code, and when the execution of the function internal code requires that the function external provides data, the preset function also has form parameters in brackets behind the function name, and when the function internal code is executed, the form parameters are processed. When the preset function is called, the parameters are required to be transferred, data provided outside when the preset function is called are filled in brackets of the preset function as actual parameters, and the positions of the actual parameters in the brackets correspond to the positions of the form parameters in the brackets.
When the parameters are extracted, the comparison direction of the operation rule can be firstly judged, for example, the comparison is transverse comparison and longitudinal comparison, wherein the transverse comparison is the comparison between different data of the same row, the longitudinal comparison is the comparison between different data of the same column, and then the parameters are extracted according to the comparison direction to serve as actual parameters of a preset function. It is of course also possible to extract the parameters directly from the above-mentioned features to which the conclusion corresponds, instead of deriving this conclusion from a transverse comparison or a longitudinal comparison.
The method for judging the comparison direction may be determined according to the expression rule, regulation or format of the operation rule, for example, the comparison direction shown in the table may be extracted against the operation rule in the following table 1 or table 2. For tables 1 and 2, the rules of operation are expressed as follows: "a to B" represents the sum of data of a to B, for example, "B6 to B41" represents the sum of data of b6+b7+ … … +b41; only the sum operation of the data among the columns uses a "+" sign, and the operation rules among different columns do not contain row marks; in the operation rule, the compared data is before, and other data is after; and, there is only one operational relationship between the other data than the compared data.
Judging the comparison direction according to whether the arithmetic rule contains a "+" sign or not based on the arithmetic rule, and if the arithmetic rule contains the "+", judging the comparison direction as transverse comparison; when "+" is absent, it is a longitudinal comparison. Or judging the comparison direction according to whether the operation rule contains the line marks of the digital representation, and if so, performing longitudinal comparison; when a numeric line label is absent, a lateral comparison is made. Or judging the comparison direction according to whether the column labels in the operation rule are the same or whether the letters in the operation rule are the same, and when the letters are the same, namely the column labels are the same, performing longitudinal comparison; when the letters are different, i.e. the columns are different, a lateral comparison is made.
The above three examples are only used for explaining the method of judging and comparing, and can be determined according to the expression rule, rule or format of the operation rule, and when the expression rule, rule or format is different, the method of judging and comparing direction is also different. Other methods of determining the direction of comparison will also occur to those skilled in the art based on the teachings of the three examples described above and are not intended to be exhaustive.
TABLE 1
TABLE 2
The method for extracting the parameters may be determined based on the comparison direction of the operation rule or the features corresponding to the comparison direction and the expression rule, or format of the operation rule, and for example, the parameters may be extracted for the operation rules in table 1 and table 2.
Specifically, the extraction rule may be: when the comparison direction is transverse, taking a first appearing letter as a first column label, taking a subsequently appearing letter as a second column label, taking a first appearing operator as a first operation relation, and taking a subsequently appearing operator as a fourth operation relation; when the comparison direction is vertical, the first appearing letter is used as the third column label (when there is only one letter in the operation rule, any letter appearing can be used as the third column label), the first appearing number is used as the first row label, the second appearing number is used as the starting row label, the third appearing number is used as the ending row label, the first appearing operator is used as the second operation relation, and the subsequent appearing or implicit operator is used as the sixth operation relation (rules "A to B" are expressed in Table 1).
The method for describing the extraction parameters in the above example may be determined according to the rule, rule or format of the operation rule, and when the rule, rule or format of the expression is different, the method for judging the extraction may be different. Other methods of extracting parameters will also occur to those skilled in the art in light of the teachings of the foregoing examples and are not exhaustive herein.
The comparison direction can be used not only for extracting parameters as a reference, but also for selecting a preset function. Often there is more than one preset function, and different preset functions differ in form parameters or functions implemented. When the coding language has the function of function reloading, the preset function is not required to be selected, and the actual parameters of the preset function can be automatically matched and preset to the proper preset function according to the code of calling the preset function.
S30: calling a preset write operation function, writing codes for calling a preset function into a VBA editing window of a table, and taking parameters as actual parameters of the preset function; when the preset function is executed, whether a group of data positioned by the row marks and the column marks in the actual parameters accords with the operation rule is judged.
An Excel has a VBA editing window for code writing, and the written codes are associated with table contents, so that the table processing efficiency can be improved. The VBA editing window can be called out by manually operating a mouse at the page name position at the left lower part, clicking the right button and clicking the 'view code'. The method provided by the embodiment of the specification enables the electronic device executing the method to automatically open the VBA editing window and write codes in the editing window.
The "one table" in this step may be an existing table (collation result table), or may be a table newly created during execution of the method provided in the present specification for storing collation results.
S40: writing in codes for displaying the checking result, and further obtaining report checking tool codes; the report checking tool automatically checks whether the data in the report accords with the operation rule when being executed.
The horizontal comparison mode needs to check row by row, so that the cyclic code needs to be supplemented, and the vertical comparison mode does not need to check row by row or column by column, so that the report checking tool generating method provided by the specification adopts different modes to assemble program codes according to different comparison directions when the codes are written.
When the comparison direction is a lateral comparison, the first preset function may be any one of the following four functions (hereinafter, only the name and form parameters of the function are shown, and the function is not used as a function header when the function is defined):
compare1 (first column label, second column label, row label); - (1)
compare1 (first column label, second column label, row label, first operational relationship); - (2)
compare1 (first column label, second column label, row label, first operational relationship, fourth operational relationship); (3)
compare1 (first column label, second column label, row label, first operational relationship, fourth operational relationship, third operational relationship); - (4)
The first column label and the second column label refer to column labels respectively positioned at two sides of a relational operator, wherein the relational operator can be represented by a symbol or by a word.
In some embodiments, it is only necessary to check whether the first column label and the second column label data satisfy a certain operational relationship, where the certain operational relationship (for example, equality) may be fixedly written in the implementation code of the first preset function, and the form parameter of the function may default to the first operational relationship, where the first operational relationship is the operational relationship between the first column label and the second column label, and the first preset function is as shown in the formula (1) above. When assembling a cyclic code for circularly calling a first preset function, the cyclic variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function, the first row mark, the second row mark and the line mark k are used as actual parameters of the first preset function, and the first preset function is represented by the formula (1); when the first preset function is executed, it is determined whether a predetermined operational relationship (e.g., equality) is satisfied between the data of the first column standard column of the k rows and the data of the second column standard column. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) &" is added before the first preset function compare1 function. The m is the minimum line standard of the report data, and the n is the maximum line standard of the report data, which can be obtained when extracting parameters.
In some embodiments, the data operation relationship between the first column label or the second column label is uncertain, for example, the data operation relationship may be greater than, less than or equal to the data operation relationship, where the form parameter of the first preset function must have the first operation relationship, and the first preset function is expressed as (2) (3) (4) above. For example, column C is greater than column D+E and column F is less than column D+E. When assembling a cyclic code for circularly calling a first preset function, the cyclic variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function, the first operation relation of the first row mark, the second row mark, the line mark k and the first operation relation is used as the actual parameter of the first comparison function, and the first preset function is as described in (2) (3) (4); when the first preset function is executed, whether the data of the first column standard column of the k rows and the data of the second column standard column meet a first operation relation is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) &" is added before the first preset function compare1 function. The m is the minimum line standard of the report data, and the n is the maximum line standard of the report data, which can be obtained when extracting parameters.
In some embodiments, the number of the second labels is not only one, but only the data between different second labels is calculated according to a fixed operation relation, at this time, the operation relation determined between the second labels can be fixedly written in the implementation code of the first preset function, and the form parameter of the first preset function can default a fourth operation relation, where the fourth operation relation is the operation relation between at least two second labels. For example, column C is greater than column D+E and column F is less than column D+E. The first preset function is as in equation (1) (2) above.
In other embodiments, the number of the second labels is not limited to one, and the operation relationship between the second labels is not limited, and may be a summation operation relationship, a product operation relationship, or a logic and operation relationship, where the form parameter of the first preset function must have a fourth operation relationship, and the first preset function is as shown in the above formula (3) (4). For example, column C equals column d+column E, and column F equals column d×e (×product). When assembling a cyclic code for circularly calling a first preset function, the cyclic variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function; taking the first column label, the second column label, the row label k, the first operation relation and the fourth operation relation as actual parameters of a first preset function; when the first preset function is executed, first, second column standard column data of k rows are calculated according to a fourth operation relation, and whether the calculation result and first column standard column data of k rows meet the first operation relation is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) &" is added before the first preset function compare1 function. The m is the minimum line standard of the report data, and the n is the maximum line standard of the report data, which can be obtained when extracting parameters.
In some embodiments, the number of the first labels is more than one, but the first labels only need to be checked according to a fixed operation relation, at this time, the operation relation determined between the first labels may be fixedly written in the implementation code of the first preset function, and the form parameter of the first preset function may default to a third operation relation, where the third operation relation is an operation relation between at least two first labels. For example, a column+b column=c column+d column. The first preset function is expressed as above (1) (2) (3).
In some embodiments, the number of the first labels is more than one, and the operation relationship between the first labels is not determined, which may be a summation operation relationship, a product operation relationship, or a logic and operation relationship, where the form parameter of the first preset function must have a third operation relationship. For example, column a x column B = column C + column D (xrepresents product). The first preset function is as in equation (4) above. When assembling a cyclic code for circularly calling a first preset function, the cyclic variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a first preset function; taking the first column label, the second column label, the row label k, the first operation relation, the fourth operation relation and the third operation relation as actual parameters of a first preset function, wherein the actual parameters are represented by the formula (8); when the first preset function is executed, first calculating second column standard column data of k rows according to a fourth operation relation, calculating first column standard column data of k rows according to a third operation relation, and then judging whether the two calculation results meet the first operation relation or not. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) &" is added before the first preset function compare1 function. The m is the minimum line standard of the report data, and the n is the maximum line standard of the report data, which can be obtained when extracting parameters.
In some embodiments, the number of the second column labels is one, but the second column labels have monocular operators, and the second column labels only need to be checked according to a fixed monocular operation relation, at this time, the operation relation of the second column labels can be fixedly written in the implementation code of the function, and the form parameter of the function can default a fourth operation relation, and the fourth operation relation is the operation relation between at least two second column labels. The function is as above equation (1) (2). For example, column c=cos E.
In some embodiments, the number of the second column labels is one, but the second column labels have monocular operators, and the monocular operation relation is not definite, and it is possible to perform a logical negation operation, and it is also possible to perform a cosine cos operation, where the form parameter of the function must have a fourth operation relation. The function is as in equation (3) (4) above. For example, E column=cos C column, F column=sin D column.
In some embodiments, the number of the first column labels is one, but the first column labels have monocular operators, and only the first column labels need to be checked according to a fixed monocular operation relation, at this time, the operation relation of the first column labels can be fixedly written in the implementation code of the function, and the form parameters of the function can default to the first operation relation, and the first operation relation is the operation relation between at least two first column labels. The functions are as described above in equations (1) (2) (3). For example, cos C column=d column+e column.
In some embodiments, the number of the first column labels is one, but the first column labels have monocular operators, and the monocular operation relation is not definite, and it is possible to perform logical negation operation, and it is also possible to perform cosine cos operation, where the form parameters of the function must have the first operation relation. The function is as in equation (4) above. For example, cos C column=d column+e column, sin J column=a×b.
In one embodiment, one of the functions (1) to (4) above may be selected according to the specific situation.
Alternatively, in one embodiment, the first preset function compare1 function in the above (1) to (4) is a homonym function (that is, the function names are the same, they are both compare1, only the form parameters are different), and they may be already packaged functions, and these homonym functions are also called function reloads in advance. When the compare1 function is called, one of the compare1 functions required in (1) to (4) is automatically matched according to the incoming actual parameters.
When the comparison direction is the longitudinal comparison, the second preset function may be any one of the following six functions (hereinafter, only the name and form parameters of the function are shown, and the function head is not used when the function is defined):
compare2 (third column label, third row label, start row label, end row label, second operational relationship); - (5)
Compare2 (third column index, third row index, start row index, end row index, second operational relationship, sixth operational relationship); - (6)
Compare2 (third column, first starting line, first ending line, second starting line, second ending line, second operational relationship); - (7)
Compare2 (third column, first starting line, first ending line, second starting line, second ending line, second operational relationship, sixth operational relationship); - (8)
Compare2 (third column, first starting line, first ending line, second starting line, second ending line, second operational relationship, fifth operational relationship); - (9)
Compare2 (third column, first starting line, first ending line, second starting line, second ending line, second operational relationship, sixth operational relationship, fifth operational relationship); - (10)
The first initial line mark and the first end line mark are also called as first line marks, the second initial line mark and the second end line mark are also called as second line marks, and the first line mark and the second line mark refer to line marks respectively positioned at two sides of a relation operator, wherein the relation operator can be represented by a symbol or by a word.
In some embodiments, only the relation between one piece of data in a certain column and the sum (or other determined data relation, such as a product) of a piece of data (i.e. a plurality of pieces of data with continuous labels in a column) needs to be checked, at this time, the operation relation between the pieces of data of the piece of data is determined, at this time, the determined operation relation can be fixedly written in the implementation code of the function, and the form parameter of the second preset function can default to a sixth operation relation, where the sixth operation relation is the operation relation between the data of the starting row label row and the ending row label row of the third column label column. For example, b2> b3+b4+ … … +b7. The second preset function is as in equation (5) above. When writing codes for calling the second preset function, taking the third column mark, the third row mark, the initial row mark i in the operation rule, the ending row mark j in the operation rule and the second operation relation as actual parameters of the second preset function; when the second preset function is executed, calculating the data of the i rows to the j rows of the third column standard column according to the determined operation relation (for example, calculating the sum of the data), and judging whether the calculation result and the data of the third column standard column and the third row standard column meet the second operation relation. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) & is added before the compare2 function.
In some embodiments, it is necessary to check the relationship between one data in a certain column and a piece of data (i.e. a plurality of data with continuous labels in a column), where the operational relationship between the piece of data is not determined, and may be a product relationship or a summation relationship, and the form parameter of the second preset function must have a sixth operational relationship. The function is as in equation (6) above. When writing codes for calling the second preset function, taking the third column index, the third row index, the initial row index i, the end row index j, the second operation relation and the sixth operation relation as actual parameters of the second preset function; and when the second preset function is executed, calculating the data from the i row to the j row of the third column standard row according to the sixth operation relation, and judging whether the calculation result and the data of the third column standard row and the third row standard row meet the second operation relation. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) & is added before the compare2 function.
In some embodiments, it is necessary to check the relationship between the sum of one piece of data (i.e. the plurality of data with continuous line labels in one column) and the sum of the other piece of data (i.e. the plurality of data with continuous line labels in one column), where the operational relationship between the data of two pieces of data is determined, where the determined operational relationship may be fixedly written in the implementation code of the second preset function, and the form parameter of the second preset function may default to a sixth operational relationship, where the sixth operational relationship is the operational relationship between the data from the start line label row to the end line label row of the third column label column, and the fifth operational relationship is the operational relationship between the data from the other start line label row to the other end line label row of the third column label column. For example, b1+b2> b3+b4+ … … +b7. The second preset function is as in equation (7) above. When writing codes for calling the second preset function, taking the third row mark column, the first initial row mark m, the first ending row mark n, the second initial row mark i, the second ending row mark j and the second operation relation as actual parameters of the second preset function; when the second preset function is executed, the sum of data from m rows to n rows of the third column standard is calculated, the sum of data from i rows to j rows of the third column standard is calculated, and whether the two calculation results meet the second operation relation is judged. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) & is added before the compare2 function.
In some embodiments, the relationship between one piece of data (i.e. a plurality of data with continuous labels in a column) and another piece of data (i.e. a plurality of data with continuous labels in a column) is checked, but the operational relationship between one piece of data is not determined, where the form parameter of the function must have a sixth operational relationship or a fifth operational relationship, as in the above formula (8) or (9). Or the operation relation between the two pieces of data is uncertain, and the form parameters of the function need to have a sixth operation relation and a fifth operation relation, and the above formula (10) is adopted. For the latter, when writing codes for calling the second preset function, taking the third column label column, the first initial row label m, the first ending row label n, the second initial row label i, the second ending row label j, the second operation relation, the sixth operation relation and the fifth operation relation as actual parameters of the second preset function; when the second preset function is executed, calculating data from m rows to n rows of the third column standard column according to the fifth operation relation, calculating data from i rows to j rows of the third column standard column according to the sixth operation relation, and judging whether the two calculation results meet the second operation relation. Finally, a code for displaying the collation result is written, for example, a code segment "sysoutF (J) =sysoutf (J) & is added before the compare2 function.
In one embodiment, one of the functions (5) to (10) above may be selected according to the specific situation.
Alternatively, in one embodiment, the second preset function compare2 functions in the above (5) to (10) are homonymic functions (i.e. the function names are the same, they are both compare2, only the form parameters are different), and they may be already packaged functions, and these homonymic functions are pre-written and called function reloads. When the compare2 function is called, the required one of the compare2 functions (5) to (10) is automatically matched according to the incoming actual parameters.
According to the report checking tool generating method provided by the embodiment of the specification, the operation rule of report data is obtained, the parameters are extracted from the budget rule, codes for calling the preset function are written into the VBA editing window of one form, the extracted parameters are used as actual parameters of the preset function, when the preset function is executed, whether a group of data positioned by the row mark and the column mark in the actual parameters accords with the operation rule is judged, codes for displaying the checking result are written in, and further, the checking tool codes are obtained, the checking tool can assist in checking the report, so that the data among the reports do not need to be checked manually one by one, the checking efficiency is high, and the accuracy is also high; the report checking tool can also realize the efficient checking of all data, and can also realize the efficient checking of the logic correctness of the management data among different reports. The report form checking tool code is generated automatically according to the operation rules of the report form, and the checking tool code for a specific operation rule is not independently written for the specific operation rule, so that the generated report form checking tool code has a wider application range.
The embodiment of the present disclosure provides a generating device of a report checking tool, which may be used to implement the method described in the corresponding embodiment of fig. 4. As shown in fig. 5, the apparatus includes an acquisition module 10, an extraction module 20, a first writing module 30, and a second writing module 40.
The obtaining module 10 is configured to obtain an operation rule of report data, where the operation rule is used to constrain a relationship between data in a row or a column of a report.
The extraction module 20 is configured to extract parameters from the operation rule, where the parameters include at least a row label and/or a column label.
The first writing module 30 is configured to call a preset writing function, write a code for calling the preset function into the VBA editing window of a table, and take the parameter as an actual parameter of the preset function; when the preset function is executed, whether a group of data positioned by the row marks and the column marks in the actual parameters accords with an operation rule is judged.
The second writing module 40 is used for writing a code for displaying the checking result, so as to obtain a report checking tool code; the report checking tool automatically checks whether the data in the report accords with the operation rule when being executed.
The embodiment of the specification provides an electronic device, which includes a memory and a processor, where the processor and the memory are communicatively connected to each other, the memory stores computer instructions, and the processor executes the computer instructions, so as to implement the steps of the method according to the corresponding embodiment of fig. 4.
Embodiments of the present invention provide a computer storage medium storing computer program instructions that, when executed, implement the steps of the method of the corresponding embodiment of fig. 4.
In the 90 s of the 20 th century, improvements to one technology could clearly be distinguished as improvements in hardware (e.g., improvements to circuit structures such as diodes, transistors, switches, etc.) or software (improvements to the process flow). However, with the development of technology, many improvements of the current method flows can be regarded as direct improvements of hardware circuit structures. Designers almost always obtain corresponding hardware circuit structures by programming improved method flows into hardware circuits. Therefore, an improvement of a method flow cannot be said to be realized by a hardware entity module. For example, a programmable logic device (Programmable Logic Device, PLD) (e.g., field programmable gate array (Field Programmable Gate Array, FPGA)) is an integrated circuit whose logic function is determined by the programming of the device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips 2. Moreover, nowadays, instead of manually manufacturing integrated circuit chips, such programming is mostly implemented with "logic compiler" software, which is similar to the software compiler used in program development and writing, and the original code before the compiling is also written in a specific programming language, which is called hardware description language (Hardware Description Language, HDL), but HDL is not only one, but a plurality of kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), lava, lola, myHDL, PALASM, RHDL (Ruby Hardware Description Language), etc., VHDL (Very-High-Speed Integrated Circuit Hardware Description Language) and Verilog2 are most commonly used at present. It will also be apparent to those skilled in the art that a hardware circuit implementing the logic method flow can be readily obtained by merely slightly programming the method flow into an integrated circuit using several of the hardware description languages described above.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are referred to each other, and each embodiment is mainly described as different from other embodiments.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function.
For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present application.
From the above description of embodiments, it will be apparent to those skilled in the art that the present application may be implemented in software plus a necessary general purpose hardware platform. Based on such understanding, the technical solutions of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product, which may be stored in a storage medium, such as a ROM/RAM, a magnetic disk, an optical disk, etc., including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform the methods of some parts of the embodiments of the present application.
The subject application is operational with numerous general purpose or special purpose computer system environments or configurations. For example: personal computers, server computers, hand-held or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments that include any of the above systems or devices, and the like.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
Although the present application has been described by way of embodiments, those of ordinary skill in the art will recognize that there are many variations and modifications of the present application without departing from the spirit of the present application, and it is intended that the appended claims encompass such variations and modifications without departing from the spirit of the present application.
Claims (9)
1. A method for generating a report reconciliation tool, the method comprising:
acquiring an operation rule of report data, wherein the operation rule is used for restricting the relation among the data in the rows or columns of the report;
extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks;
calling a preset write operation function, writing codes for calling a preset function into a VBA editing window of a table, and taking the parameters as actual parameters of the preset function; judging whether a group of data positioned by a row label and a column label in actual parameters accords with the operation rule or not when the preset function is executed;
writing in codes for displaying the checking result, and further obtaining report checking tool codes; automatically checking whether the data in the report accords with the operation rule when the report checking tool is executed;
wherein the method further comprises:
judging the comparison direction of the operation rule, wherein the comparison direction comprises the following steps: the transverse comparison is the comparison between different column data of the same row, and the longitudinal comparison is the comparison between different row data of the same column;
and selecting a preset function according to the comparison direction.
2. The report reconciliation tool generation method of claim 1 wherein the step of extracting parameters from the operational rules comprises:
extracting at least one first column mark and at least one second column mark, wherein the first column mark and the second column mark are respectively positioned at two sides of a relation operator;
or,
at least one first line mark and at least one second line mark are extracted, and the first line mark and the second line mark are respectively positioned at two sides of a relation operator.
3. The method of generating a report form collation tool according to claim 2, wherein in the case where at least one first column mark and at least one second column mark are extracted, before the step of obtaining the code of the report form collation tool, further comprising:
acquiring a minimum row mark m and a maximum row mark n of a data range to be checked;
assembling a circulating code for circularly calling the preset function, wherein a circulating variable is a line mark k; the circulation condition is from m to n, and the step length is 1; the loop body is a code for calling the preset function, and the line mark k is also used as a parameter of the preset function; when the preset function is executed, judging whether the data of the first column standard column and the data of the second column standard column of k rows meet the operation rule or not.
4. The method for generating report verification tool according to claim 2, wherein in the case of extracting at least one first column label and at least one second column label, the parameters further include a first operational relationship, the first operational relationship being an operational relationship between the first column label column and the second column label column data; correspondingly, judging whether the first row mark row and the second row mark row meet the first operation relation when the preset function is executed;
or,
under the condition of extracting at least one first column mark and at least one second column mark, the parameters also comprise a second operation relation, wherein the second operation relation is an operation relation between the first row mark row and the second row mark row data; accordingly, when the preset function is executed, whether the first row standard line data and the second row standard line data meet a second operation relation is judged.
5. The method for generating a report verification tool according to claim 3 or 4, wherein, in the case of extracting at least one first column label and at least one second column label, the parameters further include a third operational relationship and/or a fourth operational relationship, the third operational relationship being an operational relationship between at least two first column label data, the fourth operational relationship being an operational relationship between at least two second column label data;
Correspondingly, when the preset function is executed, at least two first row standard column data are calculated according to the third operation relation, and the calculation result is compared with the second row standard column data; and/or, when the preset function is executed, calculating at least two second row standard column data according to the fourth operation relation, and comparing a calculation result with the first row standard column data;
or,
under the condition that at least one first column mark and at least one second column mark are extracted, the parameters further comprise a fifth operation relation and/or a sixth operation relation, wherein the fifth operation relation is an operation relation between at least two first row mark row data, and the sixth operation relation is an operation relation between at least two second row mark row data;
correspondingly, when the preset function is executed, at least two first row standard row data are calculated according to the fifth operation relation, and the calculation result is compared with the second row standard row data; and/or, when the preset function is executed, calculating at least two second row standard row data according to the sixth operation relation, and comparing a calculation result with the first row standard row data.
6. The report checking tool generating method according to claim 1, wherein the parameters of the preset function further comprise table names and/or page names, and when the preset function is executed, a report corresponding to the table names and/or page names is opened and data located by row labels and column labels is acquired.
7. A report collation tool generation apparatus, comprising:
the acquisition module is used for acquiring operation rules of the report data, wherein the operation rules are used for restraining the relation among the data in the rows or columns of the report;
the extraction module is used for extracting parameters from the operation rule, wherein the parameters at least comprise row marks and/or column marks;
the first writing module is used for calling a preset writing operation function, writing codes for calling the preset function into a VBA editing window of a table, and taking the parameters as actual parameters of the preset function; judging whether a group of data positioned by a row label and a column label in actual parameters accords with the operation rule or not when the preset function is executed;
the second writing module is used for writing codes for displaying the checking results so as to obtain report checking tool codes; automatically checking whether the data in the report accords with the operation rule when the report checking tool is executed;
The report checking tool generating device is further used for: judging the comparison direction of the operation rule, wherein the comparison direction comprises the following steps: the transverse comparison is the comparison between different column data of the same row, and the longitudinal comparison is the comparison between different row data of the same column; and selecting a preset function according to the comparison direction.
8. An electronic device, comprising:
a memory and a processor in communication with each other, the memory having stored therein computer instructions which, upon execution, cause the processor to perform the steps of the method of any of claims 1 to 6.
9. A computer storage medium storing computer program instructions which, when executed, implement the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110562899.6A CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110562899.6A CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113191128A CN113191128A (en) | 2021-07-30 |
| CN113191128B true CN113191128B (en) | 2024-03-19 |
Family
ID=76984814
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110562899.6A Active CN113191128B (en) | 2021-05-24 | 2021-05-24 | Report checking tool generation method and device and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113191128B (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103049558A (en) * | 2012-12-31 | 2013-04-17 | 郑州中实赛尔科技有限公司 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
| CN111985201A (en) * | 2020-08-19 | 2020-11-24 | 支付宝(杭州)信息技术有限公司 | Data processing rule generation method and device and electronic equipment |
| CN112433730A (en) * | 2020-11-23 | 2021-03-02 | 北京字节跳动网络技术有限公司 | Code detection rule generation method and device and electronic equipment |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150235262A1 (en) * | 2014-02-14 | 2015-08-20 | PharmaCommunications Holdings Inc. | Method, system and computer program product for enhancing business growth, marketing and analysis |
-
2021
- 2021-05-24 CN CN202110562899.6A patent/CN113191128B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101794280A (en) * | 2010-03-11 | 2010-08-04 | 北京中科辅龙计算机技术股份有限公司 | Form automatic generation method and system based on form template set |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103049558A (en) * | 2012-12-31 | 2013-04-17 | 郑州中实赛尔科技有限公司 | Method and system for generating report forms in Factory Talk View SE (site edition) configuration environment |
| CN106815182A (en) * | 2015-11-27 | 2017-06-09 | 国家电网公司 | One kind is based on being directed to power network financial statement statistical system under excel |
| CN108197114A (en) * | 2018-01-19 | 2018-06-22 | 腾讯科技（深圳）有限公司 | Detection method, device, storage medium and the electronic device of list data |
| CN111985201A (en) * | 2020-08-19 | 2020-11-24 | 支付宝(杭州)信息技术有限公司 | Data processing rule generation method and device and electronic equipment |
| CN112433730A (en) * | 2020-11-23 | 2021-03-02 | 北京字节跳动网络技术有限公司 | Code detection rule generation method and device and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113191128A (en) | 2021-07-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109508352B (en) | Report data output method, device, equipment and storage medium | |
| CN109710237A (en) | A kind of online modification method of calibration and equipment based on customized two-dimentional report | |
| Han et al. | Deriving minimal conflict sets by CS-trees with mark set in diagnosis from first principles | |
| CN106874163A (en) | A kind of method and system for showing software error code information | |
| CN108108186A (en) | A kind of chip register characteristic encoding method based on EXCEL | |
| CN107577663A (en) | A kind of key-phrase extraction method and apparatus | |
| CN108984868B (en) | Method and device for integrating board card internet data | |
| CN110765402A (en) | Visual acquisition system and method based on network resources | |
| CN110362476A (en) | Verification method, device, computer equipment and the storage medium of data conversion tools | |
| CN112035480A (en) | Data table management method, device, equipment and storage medium | |
| CN110750440A (en) | Data testing method and terminal equipment | |
| CN113191128B (en) | Report checking tool generation method and device and electronic equipment | |
| Mauborgne | Abstract interpretation using typed decision graphs | |
| CN116360794A (en) | Database language analysis method, device, computer equipment and storage medium | |
| Hay-Jahans | An R companion to linear statistical models | |
| CN112445461B (en) | Business rule generation method and device, electronic equipment and readable storage medium | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| CN114492354A (en) | Streaming document generation method, computing device and computer readable medium | |
| CN114115831A (en) | Data processing method, device, equipment and storage medium | |
| CN110018957B (en) | Method and device for detecting resource loss check script | |
| CN109710476A (en) | A kind of system interface robustness testing method and apparatus | |
| CN115826928B (en) | Program generating method, system, electronic device and computer readable storage medium | |
| CN113094338B (en) | Data comparison method, system, device and medium | |
| Meera et al. | Multilingual machine translation with semantic and disambiguation | |
| CN1609816A (en) | Data testing system and method |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |