Unlock instant, AI-driven research and patent intelligence for your innovation.

Electronic data table calculation method and device

A technology of electronic data sheet and calculation method, which is applied in the direction of electrical digital data processing, calculation, complex mathematical operation, etc., can solve the problems of low calculation rate, low efficiency, waste of system computing resources, etc., to improve the calculation speed and increase the calculation speed. , the effect of saving system resources

Active Publication Date: 2007-10-17
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF1 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] However, in practical applications, it is found that the above-mentioned various processing processes have the following technical problems in the complex financial data processing process: all need to repeatedly call the same function in the entire spreadsheet, and the scattered repetition of the same function Calling is not conducive to the optimized execution of this function, resulting in low efficiency
Therefore, in the execution process of the prior art, the function A is independently and repeatedly executed M times, and each execution of the function A needs to independently query and match the corresponding data from other data tables, and then complete the calculation, which cannot Realize the optimized execution of function A, waste system computing resources, and the computing rate is low

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Electronic data table calculation method and device
  • Electronic data table calculation method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0062] The external secondary development module is written in Java language as the electronic data sheet, which is used to provide ACCT query function to query the data in the ERP (Enterprise Resource Planning, enterprise resource management) database. ACCT is defined as: public BigDecimal ACCT (String subject code). You can enter the formula "=ACCT("001")" in the cell of the spreadsheet to query the account code whose ID is 001 in the ERP system. For example, this code corresponds to the cash amount, that is, query the ERP system to obtain the corresponding cash amount data.

[0063] In the internal implementation of ACCT, the query to the database is completed by assembling the following SQL statement: select amount from subject balance table while subject code = "001". In the execution of an ACCT query function, the following series of operations need to be performed: connecting to the database, assembling SQL statements according to function parameters, executing SQL stat...

Embodiment 2

[0070] Assume that the cell formulas in the 100 cells of the spreadsheet in the first embodiment not only include the ACCT function, but also include rules for calculating the function or other parameters.

[0071] For the above case. The present invention can be calculated in the following two ways:

[0072] A. Set a complex function execution engine in the secondary development module to execute unit formulas including ACCT functions.

[0073] This solution is preferably applicable to the case where the unit formulas in the above 100 cells are all the same or similar. During the batch collection step, the entire unit formula is collected and submitted to the complex function execution engine. After the batch is completed, the execution result is returned Give the spreadsheet.

[0074] B. The function execution engine only for ACCT is still set in the secondary development module. After the execution is completed, the execution result is returned to the electronic data shee...

Embodiment 3

[0077] On the basis of the above-mentioned embodiments, for the collected functions and their parameters, multi-thread technology can also be used to parallelize the various types of collected functions. For computing scenarios where there are multiple CPUs in the computing environment or function execution requires remote data access, it can help make full use of computer resources and significantly improve computing efficiency.

[0078]The following is a specific example to illustrate the process of using the direct matching method to collect functions and complete the calculation:

[0079] The core idea of ​​the direct matching method is to collect functions and their parameters through string matching. For example, use Excel to complete a report for an ERP system: enter the formula =SUM(ACCT("001"), 100) in the Excel cell, the SUM function can be recognized by Excel, and the ACCT function is used to extract from the ERP system The extension function for extracting data ca...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method and apparatus for calculating in batch the function of spreadsheet. The method comprises the following steps of: scanning a cell formula in the spreadsheet, and collecting the function and parameter which accord with the predetermined condition; putting in the function and parameter in batch to at least a function execution engine; the function execution engine carrying out the optimized execution for the receiving batch function and parameter. The invention, at first, collects the fuction which is applied to be calculated in batch in the invention, from the spreadsheet to be treated, then collects all parameters of fuction in the spreadsheet at one time, afterwards carries out the optimized execution for the function to obtain the batch result(for example, the function calculation of function, the data collection of all functions as new parameter, is completed), so that the function is not executed independently again in the sequent calculation of cell, accordingly the system resource is saved greatly and the calculating speed is improved.

Description

technical field [0001] The invention relates to the field of computer data processing, in particular to a calculation method and device for an electronic data sheet. Background technique [0002] Spreadsheet: It is a calculation tool software that organizes data and information in the form of a table, such as Microsoft Excel, Lotus1-2-3, Borland Quattro Pro, LinuxGnumeric, WPS spreadsheet, Yongzhong Office, etc. [0003] A cell is the most basic unit of a spreadsheet, which can contain calculation formulas to calculate the value of this cell. The electronic data sheet can also be pre-set or provided by the secondary developer with some functional functions, which can be used in unit formulas for the convenience of users. [0004] For example, the SUM(number1, number2, ...) function is generally used for data aggregation; the AVERAGE(number1, number2, ...) function is generally used to return the average value (arithmetic mean) of the parameters. The parameters (number1, nu...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/24G06F17/15
Inventor 乔昕明
Owner KINGDEE SOFTWARE(CHINA) CO LTD