Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Multi-table iterative computation method and device, electronic equipment and storage medium

An iterative calculation and multi-table technology, applied in calculation, program control device, program control design, etc., can solve problems such as inability to apply iterative cycles, uncontrollable accuracy of formula calculations, inability to import templates and display formula calculation results, etc. Achieve the effect of ensuring accuracy and preventing formula configuration errors

Active Publication Date: 2020-05-12
CHINA CONSTRUCTION BANK
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] At present, the calculation of the formula, especially the calculation of the reference relationship between the parameters in the formula, is generally implemented by using a template such as an Excel table file. For each worksheet (sheet) in the template, it can be understood as a cell in the table , generally use the poi method to fill in the formula of the cell into the sheet of the created excel file, and let excel perform the formula operation. However, when the data source and formula are configured in the template, the template has multiple sheets, The cells of each Sheet contain formulas, and these formulas may span Sheets. These cells containing formulas may refer to each other, and eventually form an iterative relationship. For the above configuration, the poi method cannot be applied to the above iterative cycle containing formulas , and because the maximum number of iterations and the maximum error cannot be set, the accuracy of the formula operation in the cell cannot be controlled
In addition, the above-mentioned templates are generally stored in a local computer or a computer connected to a local area network, and it is impossible to import the template online and display the calculation results of the formula. In this way, the template that may have undergone multiple adjustments to the data and formula cannot be flexibly updated online. Display update calculation results

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
  • Multi-table iterative computation method and device, electronic equipment and storage medium
  • Multi-table iterative computation method and device, electronic equipment and storage medium
  • Multi-table iterative computation method and device, electronic equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0037] For Example 1, the mutual iterative relationship forms a mutually iterative formula. The maximum number of iterations and the maximum error value of the formula iterative calculation of this formula can be flexibly modified through the initialization method according to actual needs. Each formula in the test step calculates the maximum number of iterations and the maximum error value to realize the control of the calculation accuracy of the formula. Only when the maximum number of iterations and the maximum error value meet the conditions can the finally calculated business such as example 1 be used! The calculated value of the formula of B8 is provided as the final calculation result through, for example, the online display of the web page, which ensures the accuracy of the formula calculation.

[0038] The embodiment of this application provides a multi-table iterative calculation method. Compared with the existing technology that cannot control the accuracy of formula...

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 multi-table iterative computation method and device, electronic equipment and a storage medium, and is applied to the technical field of data analysis and processing. The method comprises the following steps of: 1, initializing an application program interface, and calling in a function definition file; 2, obtaining a template with multiple tables and verifying each formula in the multiple tables; and 3, executing formula iterative computation after all the formulas pass the verification, wherein the formula iterative computation comprises computation for the maximum iteration times and the maximum error value of the formulas. On the basis of preventing formula configuration errors, the accuracy of formula calculation can be controlled.

Description

technical field [0001] The present application relates to the technical field of data analysis and processing. Specifically, the present application relates to a multi-table iterative calculation method, device, electronic equipment and storage medium. Background technique [0002] At present, the calculation of the formula, especially the calculation of the reference relationship between the parameters in the formula, is generally implemented by using a template such as an Excel table file. For each worksheet (sheet) in the template, it can be understood as a cell in the table , generally use the poi method to fill in the formula of the cell into the sheet of the created excel file, and let excel perform the formula operation. However, when the data source and formula are configured in the template, the template has multiple sheets, The cells of each Sheet contain formulas, and these formulas may span Sheets. These cells containing formulas may refer to each other, and even...

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): G06F40/18G06F40/186G06F16/903G06F9/455
CPCG06F16/90344G06F9/45529Y02D10/00
Inventor 庄佳和罗川匀李志顺
Owner CHINA CONSTRUCTION BANK
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com