Patent US5339410A successfully refreshed from Google Patents.
US5339410A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method of bidirectional recalculation
Assignee: International Business Machines Corp
•
Filing: 1992-07-09
•
Granted: 1994-08-16
•
Expires: 2012-07-09
Abstract
Abstract A recalculation function operates in both directions on a spreadsheet. The function is activated when a user directly changes any cell value. The other cell values are automatically recalculated resulting in easier and smoother operation of the spreadsheet.
Inventors
- 👤 Naoki Kanai
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 09:48
CPC Classifications
G; G06; G06F; G06F8/00; G06F8/40; G06F8/41; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06Q; G06Q99/00
Claims Analysis
Total Claims: 7
Claim 1
Independent Claim
254 words
A spreadsheet system having a recalculation function in both a forward and reverse direction comprising: means for establishing a calculation model in said spreadsheet system having at least one relational node corresponding to an inputted relation and a plurality of cell nodes including a function value cell node, a variable value cell node, and a propagation constraint cell node connected to said relational node by a plurality of arcs; means for inputting by a user a first change instruction for said variable value cell node; means for marking said calculation model in response to said first change instruction based on a series of predetermined rules describing a recalculating order of said function value cell node, variable value cell node and propagation constraint cell node; a first means for automatically recalculating a value for said function value cell node based on said inputted relation at said relational node in said forward direction in response to said first change instruction based on the markings on said calculation model placed thereon by said marking means; means for inputting by a user a second change instruction for said function value cell node; means for marking said calculation model in response to said second change instruction for said function value cell node based on said predetermined rules; and a second means for automatically recalculating a new value for said propagation constraint cell node in said reverse direction using an inverse function of said inputted relation in response to said second change instruction and said markings on said calculation model.
Claim 2
Dependent Claim
254 words
A spreadsheet system having a recalculation function in both a forward and reverse direction comprising: means for establishing a calculation model in said spreadsheet system having at least one relational node corresponding to an inputted relation and a plurality of cell nodes including a function value cell node, a variable value cell node, and a propagation constraint cell node connected to said relational node by a plurality of arcs; means for inputting by a user a first change instruction for said variable value cell node; means for marking said calculation model in response to said first change instruction based on a series of predetermined rules describing a recalculating order of said function value cell node, variable value cell node and propagation constraint cell node; a first means for automatically recalculating a value for said function value cell node based on said inputted relation at said relational node in said forward direction in response to said first change instruction based on the markings on said calculation model placed thereon by said marking means; means for inputting by a user a second change instruction for said function value cell node; means for marking said calculation model in response to said second change instruction for said function value cell node based on said predetermined rules; and a second means for automatically recalculating a new value for said propagation constraint cell node in said reverse direction using an inverse function of said inputted relation in response to said second change instruction and said markings on said calculation model.
Claim 3
Dependent Claim
76 words
A spreadsheet system as recited in claim 1 wherein said second means for automatically recalculating a new value include preprocessing means for detecting a loop production resulting from forward and reverse recalculation of said function value cell node and said propagation constraint cell node by determining if said inputted relation is satisfied for said first change instruction and said second change instruction according to a series of predetermined rules and reporting the status to a user.
Claim 4
Dependent Claim
43 words
A spreadsheet system as recited in claim 1 wherein said second means for automatically recalculating a new value include preprocessing means for placing said markings on said calculation model for a plurality of paths that can be changed by forward and reverse recalculation.
Claim 5
Dependent Claim
33 words
A spreadsheet system as recited in claim 1 wherein said means for automatically recalculating a new value include means for determining an order for recalculation based on the markings on said calculation model.
Claim 6
Independent Claim
190 words
A method, implemented in a computer, of providing a recalculation function in both direction for a spreadsheet in a data processing system comprising: creating a calculation model on the basis of the relations of a plurality of variable value cells including a propagation constraint cell described by a relation formula in said computer; inputting a first change instruction by a user for at least one of said variable value cells; marking said calculation model in response to said change instruction based on a series of predetermined rules describing a recalculating order of said variable value cells and function value cell in said computer; performing said recalculation function based on the marking of said calculation model for said function value cell in a first direction in said computer; inputting a second change instruction by said user for said function value cell; marking said calculation model in response to said second change instruction for said function value cell based on said predetermined rules; and automatically recalculating in said computer a new value for said propagation constraint cell based on the marking on said calculation model and inverse function of said relation formula.
Claim 7
Independent Claim
190 words
A method, implemented in a computer, of providing a recalculation function in both direction for a spreadsheet in a data processing system comprising: creating a calculation model on the basis of the relations of a plurality of variable value cells including a propagation constraint cell described by a relation formula in said computer; inputting a first change instruction by a user for at least one of said variable value cells; marking said calculation model in response to said change instruction based on a series of predetermined rules describing a recalculating order of said variable value cells and function value cell in said computer; performing said recalculation function based on the marking of said calculation model for said function value cell in a first direction in said computer; inputting a second change instruction by said user for said function value cell; marking said calculation model in response to said second change instruction for said function value cell based on said predetermined rules; and automatically recalculating in said computer a new value for said propagation constraint cell based on the marking on said calculation model and inverse function of said relation formula.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1997-08-15 | 1998-02-14 | 1998-08-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2001-08-15 | 2002-02-14 | 2002-08-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2005-08-15 | 2006-02-14 | 2006-08-16 | $7700.00 | Window Closed / Lapsed |