US5550964A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and methods for intelligent analytical graphing
Assignee: Borland Software Corp
•
Filing: 1994-11-01
•
Granted: 1996-08-27
•
Expires: 2014-11-01
Abstract
Abstract An electronic spreadsheet system includes an intelligent analytical graphing module for creating complex analytical graphs from user-supplied information. Methods are described for automatically creating one or more desired analyses on a spread of user-supplied information, all without the user having to modify his or her information or supply (or even understand) the operations necessary for a given analysis. The system includes a preferred interface for receiving selections from the user indicating one or more analyses to be performed on the information, and for displaying analytical graphs for visualizing the result of a selected analysis.
Inventors
- 👤 Paul Davoust
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 15:15
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 25
Claim 1
Independent Claim
126 words
A method, performed by a computer system, for automatically interpreting data stored in an electronic spreadsheet, comprising the steps of: determining a set of information members to be analyzed in response to input from a user, the set of information members including at least some information members characterized by numeric values; displaying a number of analysis types for the user; determining a selected analysis type in response to input from the user; subjecting the set of information members to a set of operations that effects the selected analysis type so as to generate a temporary data set that includes numeric values based on at least some of the numeric values that characterize the set of information members; and generating a graph representing the temporary data set.
Claim 2
Independent Claim
126 words
A method, performed by a computer system, for automatically interpreting data stored in an electronic spreadsheet, comprising the steps of: determining a set of information members to be analyzed in response to input from a user, the set of information members including at least some information members characterized by numeric values; displaying a number of analysis types for the user; determining a selected analysis type in response to input from the user; subjecting the set of information members to a set of operations that effects the selected analysis type so as to generate a temporary data set that includes numeric values based on at least some of the numeric values that characterize the set of information members; and generating a graph representing the temporary data set.
Claim 3
Dependent Claim
18 words
The method of claim 1, and further comprising the step of displaying the graph on a display device.
Claim 4
Dependent Claim
14 words
The method of claim 1, and further comprising the step of printing the graph.
Claim 5
Dependent Claim
34 words
The method of claim 1, and further comprising the step, performed after said step of generating a graph, of discarding the temporary data set without storing the temporary data set in the electronic spreadsheet.
Claim 6
Dependent Claim
32 words
The method of claim 1, and further comprising the step, performed after said step of subjecting, of storing the temporary data set in the electronic spreadsheet in response to a user command.
Claim 7
Dependent Claim
49 words
The method of claim 1, and further comprising the steps, performed before said step of displaying a number of analysis types, of: analyzing at least one property of the information members in the set; and selecting analysis types for display on the basis of the at least one property.
Claim 8
Dependent Claim
18 words
The method of claim 1 wherein the information members are stored as information cells in a memory device.
Claim 9
Dependent Claim
18 words
The method of claim 7 wherein the selected range of cells are stored contiguously in the memory device.
Claim 10
Dependent Claim
15 words
The method of claim 1 wherein each of the information members has a data type.
Claim 11
Dependent Claim
30 words
The method of claim 9 wherein the data type includes a numeric format selected from one of the following data types: fixed, scientific, currency, percent, date, time, text, and user-defined.
Claim 12
Dependent Claim
71 words
The method of claim 9, and further including the steps, performed before said step of displaying a number of analysis types, of: examining the set of information members for determining a common data type; and determining which ones of available analysis types are appropriate for the determined data type; wherein said step of displaying a number of analysis types is limited to displaying only ones determined to be appropriate are displayed.
Claim 13
Dependent Claim
28 words
The method of claim 11 wherein said step of examining includes heuristically determining a common data type by examining each of the information members with an expert system.
Claim 14
Dependent Claim
19 words
The method of claim 11 wherein the displayed analysis types include aggregation, moving average, linear fit, and exponential fit.
Claim 15
Independent Claim
164 words
A method, performed by a computer system, for automatically interpreting data stored in an electronic spreadsheet, comprising the steps of: determining a set of information members to be analyzed in response to input from a user, the set of information members including at least some information members characterized by numeric values; analyzing at least one property of the information members in the set; on the basis of said analyzing step, determining a number of possible analysis types suitable for use with information members having the at least one property; displaying the number of analysis types for the user; determining a selected analysis type in response to input from the user; subjecting the set of information members to a set of operations that effects the selected analysis type so as to generate a temporary data set that includes numeric values based on at least some of the numeric values that characterize the set of information members; and generating a graph representing the temporary data set.
Claim 16
Independent Claim
164 words
A method, performed by a computer system, for automatically interpreting data stored in an electronic spreadsheet, comprising the steps of: determining a set of information members to be analyzed in response to input from a user, the set of information members including at least some information members characterized by numeric values; analyzing at least one property of the information members in the set; on the basis of said analyzing step, determining a number of possible analysis types suitable for use with information members having the at least one property; displaying the number of analysis types for the user; determining a selected analysis type in response to input from the user; subjecting the set of information members to a set of operations that effects the selected analysis type so as to generate a temporary data set that includes numeric values based on at least some of the numeric values that characterize the set of information members; and generating a graph representing the temporary data set.
Claim 17
Dependent Claim
34 words
The method of claim 14, and further comprising the step, performed after said step of generating a graph, of discarding the temporary data set without storing the temporary data set in the electronic spreadsheet.
Claim 18
Dependent Claim
32 words
The method of claim 14, and further comprising the step, performed after said step of subjecting, of storing the temporary data set in the electronic spreadsheet in response to a user command.
Claim 19
Dependent Claim
18 words
The method of claim 14 wherein the information members are stored as information cells in a memory device.
Claim 20
Dependent Claim
18 words
The method of claim 17 wherein the selected range of cells are stored contiguously in the memory device.
Claim 21
Dependent Claim
15 words
The method of claim 18 wherein each of the information members has a data type.
Claim 22
Dependent Claim
30 words
The method of claim 19 wherein the data type includes a numeric format selected from one of the following data types: fixed, scientific, currency, percent, date, time, text, and user-defined.
Claim 23
Dependent Claim
71 words
The method of claim 19, and further including the steps, performed before said step of displaying a number of analysis types, of: examining the set of information members for determining a common data type; and determining which ones of available analysis types are appropriate for the determined data type; wherein said step of displaying a number of analysis types is limited to displaying only ones determined to be appropriate are displayed.
Claim 24
Dependent Claim
28 words
The method of claim 21 wherein said step of examining includes heuristically determining a common data type by examining each of the information members with an expert system.
Claim 25
Dependent Claim
20 words
The method of claim 14 wherein the displayed list of analyses includes aggregation, moving average, linear fit, and exponential fit.
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) | 1999-08-27 | 2000-02-26 | 2000-08-27 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-08-27 | 2004-02-26 | 2004-08-27 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-08-27 | 2008-02-26 | 2008-08-27 | $7700.00 | Window Closed / Lapsed |