US5095429A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method for prioritizing data in financial information system
Assignee: Oracle International Corp
•
Filing: 1990-08-28
•
Granted: 1992-03-10
•
Expires: 2010-08-28
Abstract
Abstract A method is provided for modifying calculation of a predefined procedure in a spread of financial data in a financial information system operative on a digital computer wherein data is manually input into a cell as a value, the value is prioritized above other values dependent thereon by setting a lock flag to indicate that the data is to be secured against change by subsequent recalculation on the cell and thereafter the data of all other cells which is not locked is recalculated on the basis of the priority values stored in cells designated as locked. In each case, the steps of inputting, locking, recalculating and storing are repeated for each manually entered data value. The value is recalculated upon unlocking a cell, thereby deprioritizing the data.
Inventors
- 👤 C. Lee Harris
- 👤 Christian D. Ovard
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 03:30
CPC Classifications
G; G06; G06Q; G06Q40/00; G06Q40/02; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 16
Claim 1
Independent Claim
143 words
In an electronic spreadsheet for processing numeric information, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for recalculating the spreadsheet comprising: (a) entering in one cell a sum total; (b) setting a lock flag in selected ones of said cells, each said selected one becoming a locked cell; (c) counting the number of set lock flags; (d) calculating the sum of all values stored in the locked cells; (e) calculating a total to spread by subtracting said calculated sum from said sum total; and (f) displaying in cells which are not locked cells the total to spread divided by the sum of the total number of said cells less said number of set lock flags.
Claim 2
Dependent Claim
143 words
In an electronic spreadsheet for processing numeric information, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for recalculating the spreadsheet comprising: (a) entering in one cell a sum total; (b) setting a lock flag in selected ones of said cells, each said selected one becoming a locked cell; (c) counting the number of set lock flags; (d) calculating the sum of all values stored in the locked cells; (e) calculating a total to spread by subtracting said calculated sum from said sum total; and (f) displaying in cells which are not locked cells the total to spread divided by the sum of the total number of said cells less said number of set lock flags.
Claim 3
Dependent Claim
25 words
The method of claim 1, further comprising the step: (g) removing the lock flag from any of said locked cells; and (h) repeating steps (c)-(f).
Claim 4
Dependent Claim
31 words
The method of claim 1, wherein step (b) comprises: setting a lock flag by entering data in selected ones of said cells, each of said selected ones becoming a locked cell.
Claim 5
Dependent Claim
25 words
The method of claim 1, wherein after step (b) further comprises the step: (g) displaying an icon for each cell which is a locked cell.
Claim 6
Dependent Claim
22 words
The method of claim 1, wherein said step (a) comprises entering in one cell a sum total representing an annual dollar amount.
Claim 7
Dependent Claim
180 words
In a programmed computer, an improved electronic spreadsheet for processing numeric information, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, the improvement comprising: (a) input means for entering in one cell a sum total and for setting a lock flag in selected ones of said cells, each of said selected ones becoming a locked cell; (b) means, coupled to said input means, for counting the number of set lock flags; (c) first means, coupled to said counting means, for calculating the sum of all values stored in the locked cells; (d) second means, coupled to said first calculating means, for calculating a total to spread by subtracting said calculated sum from said sum total; and (e) means, coupled to said second calculating means, for displaying in cells which are not locked cells the total to spread divided by the sum of the total number of said cells less said number of set lock flags.
Claim 8
Dependent Claim
180 words
In a programmed computer, an improved electronic spreadsheet for processing numeric information, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, the improvement comprising: (a) input means for entering in one cell a sum total and for setting a lock flag in selected ones of said cells, each of said selected ones becoming a locked cell; (b) means, coupled to said input means, for counting the number of set lock flags; (c) first means, coupled to said counting means, for calculating the sum of all values stored in the locked cells; (d) second means, coupled to said first calculating means, for calculating a total to spread by subtracting said calculated sum from said sum total; and (e) means, coupled to said second calculating means, for displaying in cells which are not locked cells the total to spread divided by the sum of the total number of said cells less said number of set lock flags.
Claim 9
Dependent Claim
162 words
In an electronic spreadsheet for processing numeric information for a user, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for calculating monthly figures based on an annual figure, said method comprising: (a) entering into one cell said annual figure; (b) entering into selected ones of twelve cells values representing monthly figures, wherein each of said twelve cells corresponds to a month of the year, each of said selected ones being protected against recalculation; (c) counting the number of said selected ones; (d) calculating the sum of the monthly figures in said selected ones; (e) calculating a total to spread by subtracting said calculated sum from said annual figure; and (f) displaying in non-selected ones of said twelve cells the total to spread averaged over the number of said non-selected ones of said twelve cells.
Claim 10
Dependent Claim
162 words
In an electronic spreadsheet for processing numeric information for a user, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for calculating monthly figures based on an annual figure, said method comprising: (a) entering into one cell said annual figure; (b) entering into selected ones of twelve cells values representing monthly figures, wherein each of said twelve cells corresponds to a month of the year, each of said selected ones being protected against recalculation; (c) counting the number of said selected ones; (d) calculating the sum of the monthly figures in said selected ones; (e) calculating a total to spread by subtracting said calculated sum from said annual figure; and (f) displaying in non-selected ones of said twelve cells the total to spread averaged over the number of said non-selected ones of said twelve cells.
Claim 11
Dependent Claim
21 words
The method of claim 7, wherein after step (b) further comprises: displaying a padlock icon proximate each of said selected ones.
Claim 12
Dependent Claim
20 words
The method of claim 7, further comprising the step: (g) repeating steps (b)-(f) with different cells as the selected ones.
Claim 13
Dependent Claim
164 words
In an electronic spreadsheet for processing numeric information for a user, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for calculating quarterly figures based on an annual figure, said method comprising: (a) entering into one cell said annual figure; (b) entering into selected ones of four cells values representing quarterly figures, wherein each of said four cells corresponds to a quarter of the year, each of said selected ones being protected against recalculation; (c) determining the number of said non-selected ones of said cells; (d) calculating the sum of the quarterly figures in selected ones; (e) calculating a total to spread by subtracting said calculated sum from said annual figure; and (f) displaying in non-selected ones of said four cells the total to spread averaged over the number of said non-selected ones of said four cells.
Claim 14
Dependent Claim
164 words
In an electronic spreadsheet for processing numeric information for a user, said spreadsheet operative in a digital computer and including a plurality of cells for entering data and formulas, and further including means for recalculating said cells in response to said entered data and formulas, a method for calculating quarterly figures based on an annual figure, said method comprising: (a) entering into one cell said annual figure; (b) entering into selected ones of four cells values representing quarterly figures, wherein each of said four cells corresponds to a quarter of the year, each of said selected ones being protected against recalculation; (c) determining the number of said non-selected ones of said cells; (d) calculating the sum of the quarterly figures in selected ones; (e) calculating a total to spread by subtracting said calculated sum from said annual figure; and (f) displaying in non-selected ones of said four cells the total to spread averaged over the number of said non-selected ones of said four cells.
Claim 15
Dependent Claim
31 words
The method of claim 10, further comprising: (g) unlocking said one cell; and (h) displaying in said one cell an annual figure which is a sum total of said four cells.
Claim 16
Dependent Claim
19 words
The method of claim 11, further comprising: (i) repeating step (b) with new values; and (j) repeating step (h).
References Cited (Backward Citations)
US4845652A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1995-03-10 | 1995-09-09 | 1996-03-10 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1999-03-10 | 1999-09-09 | 2000-03-10 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2003-03-10 | 2003-09-09 | 2004-03-10 | $7700.00 | Window Closed / Lapsed |