Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2000-03-14
2002-08-06
Feild, Joseph H. (Department: 2176)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000
Reexamination Certificate
active
06430584
ABSTRACT:
TECHNICAL FIELD
This invention relates to computerized spreadsheets.
BACKGROUND OF THE INVENTION
Computerized spreadsheets are widely used for organizing numerical and textual data in such environments as accounting, financial/investments, inventory, and the like. The spreadsheets consist of rows and columns of individual cells. The columns are organized by letter—Columns A, B, C, etc.—and the rows are organized by number—Rows
1
,
2
,
3
, etc. Each cell is identified by a combination of column letter and row number. Cell “B
3
,” for instance, is in column B and row
3
. Numerical and textual data are entered into the cells of the spreadsheet according to the organization imposed by the author. The cells can be formatted to present the numbers and text in a desired appearance.
Conventional spreadsheets also permit an author to define mathematical functions within individual cells. The functions are set apart from normal data by use of a leading descriptor entry, such as an “=” sign. It is common for the mathematical functions entered in one cell to use data contained in other cells. The function itself is not displayed in the cell; rather, the cell displays the results of the function.
To perform calculations on the data entered into the spreadsheet, the author has to explicitly define the function and enter it in one of the cells. One typical spreadsheet example is to sum all of the numbers in a column. The author selects a cell in the spreadsheet which will be used to show the summation, and in that cell, defines a summation function which adds the values of the particular cells in the column. To compute the summation of numbers residing in cells B
3
to B
12
and show that sum in cell B
13
, the author enters in cell B
13
one of the following equations:
=SUM(
B
3
:
B
12
)
=
B
3
+
B
4
+ . . . +
B
12
+
B
13
Notice that the function begins with the “=” descriptor to identify that the cell contains a function, and not text or numerical data.
For commonly used equations, spreadsheets typically have a predefined list of functions from which the author may choose. The list can be presented in a pull-down menu, or the like. The author simply chooses a particular cell and selects a function from the predefined list. The spreadsheet enters the selected function into the chosen cell, so that the author does not have to type in the function. In addition to predefined lists, one present-day spreadsheet marketed under the name Excel by Microsoft Corporation offers a “function wizard” which guides the author step-by-step through the parts of a function to ensure entry of the appropriate cell information and parameters. While the predefined lists and function wizards provide shortcuts to improve operation efficiency, they too result in entry of a function within a designated cell.
There are occasions, however, when an author only wants a quick, temporary calculation that is not intended to be part of the workbook. For instance, the author might wish to know the subtotal of a group of cells, or to analyze data within a set of cells to find a subset of those cells which produce a certain value. With conventional spreadsheets, the author is forced to enter the formula in a cell (either by entering the function, selecting one from a menu, or using a function wizard), view the result, and subsequently go back and delete the function from the cell to remove it from the workbook.
Accordingly, there is a need to improve computerized spreadsheets to handle intermediate calculations without having to enter formulas into the worksheet.
SUMMARY OF THE INVENTION
This invention concerns techniques for performing automatic calculations in a computerized spreadsheet without creating a function to perform the calculations. The computerized spreadsheet has multiple cells which are selectable by an indicator, such as a pointer or highlight bar. As the author selects one or more cells, an auto-calculator automatically calculates a predefined function using the one or more selected cells and then promptly displays the result. For example, suppose the function is to sum all the values in the selected cells. As the author selects cells, the auto-calculator quickly computes the sum of the selection and displays the result. As the author changes the selection (e.g., moving the pointer to include another cell), the calculation is continuously updated in real-time. In this manner, the author can view intermediate calculations without having to write or embed a formula within the spreadsheet.
The calculations can be made in one of two ways. One approach is to compute the function each time a new cell is selected by repeatedly using all of the selected cells. A second approach is to compute the function for the present selection and temporarily cache the result. Then, as a new cell is selected, compute the function using the new cell and the cached result to incrementally adjust the calculation.
Once the calculation is made, the result is immediately displayed. In the described implementation, the spreadsheet is implemented in a graphical user interface window having a toolbar adjacent to the rows and columns of cells and a moveable pointer. The result can be displayed in a pane of the tool bar or in a tip-window beside the pointer.
REFERENCES:
patent: 5317686 (1994-05-01), Salas et al.
patent: 5396621 (1995-03-01), MacGregor et al.
patent: 5495565 (1996-02-01), Millard et al.
patent: 5510980 (1996-04-01), Peters
patent: 5544285 (1996-08-01), Glaser et al.
patent: 5603021 (1997-02-01), Spencer et al.
patent: 5623282 (1997-04-01), Graham et al.
patent: 5685001 (1997-11-01), Capson et al.
patent: 5845300 (1998-12-01), Comer et al.
patent: 5874963 (1999-02-01), Johnson et al.
patent: 6055548 (2000-04-01), Comer et al.
Underdahl, Brian, “Using Quattro Pro 6 for Windows, Special Edition”, 1994, Que Corporation, ISBN 1-56529-761-x, pp. 177-182.
Comer Ross
Williams, Jr. David Russell
Feild Joseph H.
Lee & Hayes PLLC
LandOfFree
Computerized spreadsheet with auto-calculator does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Computerized spreadsheet with auto-calculator, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Computerized spreadsheet with auto-calculator will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2925581