Method for realizing goal seeking of electronic form

A spreadsheet and univariate technology, applied in the field of univariate solving, can solve problems such as inability to guarantee convergence and convergence speed, and achieve the effects of good adaptability, strong practicability, and broadened solution performance

Active Publication Date: 2014-06-25
YOZOSOFT
View PDF2 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The conditions of problems in practical applications are ever-changing, and purely using one of the methods often cannot guarantee convergence and convergence speed

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
  • Method for realizing goal seeking of electronic form
  • Method for realizing goal seeking of electronic form
  • Method for realizing goal seeking of electronic form

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0034] The detailed description of the present invention directly or indirectly simulates the operation of the technical solution of the present invention mainly through programs, steps, logic blocks, processes or other symbolic descriptions. In the ensuing description, numerous specific details are set forth in order to provide a thorough understanding of the present invention. Rather, the invention may be practiced without these specific details. These descriptions and representations herein are used by those skilled in the art to effectively convey the substance of their work to others skilled in the art. In other words, for the purpose of avoiding obscuring the present invention, well-known methods, procedures and components have not been described in detail since they are already readily understood.

[0035] Reference herein to "one embodiment" or "an embodiment" refers to a particular feature, structure or characteristic that can be included in at least one implementati...

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 discloses a method for realizing goal seeking of an electronic form, which comprises the following steps of: obtaining initial conditions such as an independent variable, an induced variable, an initial value, a target value, the precision and iteration step number limitation and the like through a user interface of the electronic form; and carrying out goal seeking by adopting a continued fraction method as a core to be combined with methods such as the initial searching, a dichotomy method, an advancing and retreating method and the like. The method provided by the invention is applied to the field of the electronic form data analysis, has good calculation performance and precision and reaches the practical application level.

Description

technical field [0001] The invention belongs to the field of electronic form data analysis, and in particular relates to a single-variable solving method with the continued fraction method as the core. Background technique [0002] A data analysis function in spreadsheet programs, Goal Seek is a method of finding a specific value in a given cell by adjusting the value in another cell. During Goal Seek, the spreadsheet program keeps changing the value in a given cell until a formula that depends on that cell returns a satisfactory value. The existing univariate solution methods mainly include: dichotomy method, Newton method (tangent method), secant method and continued fraction method. [0003] When using the dichotomy method for univariate solution, the objective function is required to be continuous and have only one real root in the initial interval. Although the conditions are easy to meet, the convergence speed is slow. Although the Newton method has a fast convergenc...

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 Patents(China)
IPC IPC(8): G06F9/44G06F17/10
Inventor 俞志刚
Owner YOZOSOFT
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap