Statistics method among plurality of tables, user-defined rule building method, device and system

Abstract

The invention discloses a user-defined rule building method capable of being used for performing statistics on a plurality of report forms. The method comprises the following steps of receiving a user-defined formula, aiming at the plurality of report forms, input by a user, wherein the user-defined formula comprises operators and a plurality of groups of Chinese keywords separated by the operators, and each group of Chinese keywords include Chinese keywords corresponding to data contents and Chinese keywords corresponding to data time; performing finding and matching on each group of keywords in the plurality of report forms so that the data corresponding to the group of keywords can be found and matched, wherein the Chinese keywords corresponding to the data contents in each group of keywords are used as the first stage of index, a plurality of data relevant to the data contents in the affiliated form in the group of Chinese keywords is determined, the Chinese keywords corresponding to the data time are used as the second stage of index, and data corresponding to the Chinese keywords corresponding to the data time is determined; and associating each matched datum to the corresponding group of Chinese keywords so as to give values to each group of keywords.

Description

technical field [0001] The invention relates to the field of statistical calculation of reports, in particular to a statistical method among multiple tables, a method for establishing self-defined rules, a device and a system. Background technique [0002] The report is a form for reporting the situation to the superior. Simply put, the report is to dynamically display data in forms such as tables and charts. Reports can be used to make preliminary statistics on events, and can display relevant information of events visually and intuitively. For example, in daily work, daily reports, weekly reports, and monthly reports can be used to report the work content to relevant departments, and for example, financial statements that every enterprise needs to establish, etc. Most companies use the EXCEL form for financial data recording and statistics. The EXCEL form is powerful and can perform calculations on each cell in the same form, such as summation, average calculation, etc. H...

AI Technical Summary

Problems solved by technology

Most companies use the EXCEL form for financial data recording and statistics. The EXCEL form is powerful and can perform calculations on each cell in the same form, such as summation, average calculation, etc. However, for financial data Statistical calculations generally require skilled personnel to perform calculations. For first-time users or users who are not proficient in computers, it is difficult to find the calculation formulas for each table.

In addition, the calculations between multiple EXCEL reports are more complicated, even users who understand computers may not be able to perform statistical calculations on the data between multiple reports proficiently

In an enterprise, there may be many people who need financial statement data, and they may be in different parts of the enterprise. It is impossible for them to be familiar with financial statements, let alone the calculation rules between multiple statements. If you want to obtain statistical data, you must Professional personnel are needed to make statistics for them. This method greatly reduces work efficiency and is not convenient for relative personnel to carry out statistics

Images