US5189608A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for storing and generating financial information employing user specified input and output formats
Assignee: CORPORATE CLASS SOFTWARE Inc A CORP OF
•
Filing: 1990-02-15
•
Granted: 1993-02-23
•
Expires: 2010-02-15
Abstract
Abstract An advanced financial reporting and analysis software package is described. The package collects, organizes, manages and consolidates financial data and provides user defined capabilities for creating financial and corporate reports. Financial data is organized into four business classifications or dimensions: Schedule, Entity, Period and Type. Data is stored in the system in such a way that all data associated with a particular Schedule, Entity, Period and Type is identified by that particular SEPT value. To accommodate automatic data entry, a mapping means or template is provided that specifies for each different input spreadsheet the location of the first data cell in the spreadsheet and the size of the spreadsheet. Data is read from the data store by various report and spreadsheet generating functions which convert data associated with particular SEPT values to desired output formats.
Inventors
- 👤 Richard J. Lyons
- 👤 Kevin F. Nolan
- 👤 Wah C. Chu
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-28 13:10
CPC Classifications
G; G06; G06Q; G06Q40/00; G06Q40/02; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06Q40/12
Claims Analysis
Total Claims: 11
Claim 1
Independent Claim
278 words
In a computer, a method of storing and generating financial information of the type used in financial schedules comprising the steps of: storing financial information in a first format in a storage means in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values; specifying by user input to said computer a plurality of second formats in which are received data values to be stored in said storage means, each of said second formats associating each of a plurality of financial data value with one of said sets of at least three identifying attributes, whereby a plurality of user-defined data input templates are defined; using said data input templates to convert data values received in each of the plurality of second formats into said first format and storing such data values in said storage means in said first format; specifying by user input to said computer a plurality of third formats in which data values stored in said storage means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with second set of at least three attributes, whereby a plurality of user-defined of data output templates are defined; and using one of said data output templates to convert data values stored in said storage means to said third format.
Claim 2
Dependent Claim
278 words
In a computer, a method of storing and generating financial information of the type used in financial schedules comprising the steps of: storing financial information in a first format in a storage means in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values; specifying by user input to said computer a plurality of second formats in which are received data values to be stored in said storage means, each of said second formats associating each of a plurality of financial data value with one of said sets of at least three identifying attributes, whereby a plurality of user-defined data input templates are defined; using said data input templates to convert data values received in each of the plurality of second formats into said first format and storing such data values in said storage means in said first format; specifying by user input to said computer a plurality of third formats in which data values stored in said storage means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with second set of at least three attributes, whereby a plurality of user-defined of data output templates are defined; and using one of said data output templates to convert data values stored in said storage means to said third format.
Claim 3
Dependent Claim
39 words
The method of claim 1 wherein the identifying attributes are a financial schedule in which the financial information appears, a business entity to which the financial information pertains, and a period of time to which the financial information pertains.
Claim 4
Dependent Claim
18 words
The method of claim 2 wherein the identifying attributes further include a fourth attribute defined by the user.
Claim 5
Dependent Claim
55 words
The method of claim 1 wherein said financial information is output by: specifying a particular type of schedule, specifying a combination of attributes such as entity, period and type; specifying a number of rows and columns in which to display output data, and specifying the locations of the attributes on the display of output data.
Claim 6
Dependent Claim
14 words
The method of claim 1 wherein input data may be stored in multiple schedules.
Claim 7
Dependent Claim
17 words
The method of claim 1 wherein integrity checks and currency conversions are performed at time of input.
Claim 8
Dependent Claim
260 words
Apparatus for the storage and generation of financial information of the type used in financial schedules comprising: means for storing financial information in a first format in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values; first means for specifying by user input to said apparatus a plurality of second formats in which are received data values to be stored in said storing means, each of said second formats associating each of a plurality of financial data values with one of said sets of at least three identifying attributes; means for using said first specifying means to convert data values received in each of the plurality of second formats into said first format and for storing such data values in said storing means in said first format; second means for specifying by user input to said apparatus a plurality of third formats in which data values stored in said storing means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with a second set of at least three attributes; and means for using said second specifying means to convert data values stored in said storing means to said third format.
Claim 9
Dependent Claim
260 words
Apparatus for the storage and generation of financial information of the type used in financial schedules comprising: means for storing financial information in a first format in which format each of a plurality of financial data values is associated with a set of at least three identifying attributes and some data values are associated with a set of attributes different from that associated with other data values; first means for specifying by user input to said apparatus a plurality of second formats in which are received data values to be stored in said storing means, each of said second formats associating each of a plurality of financial data values with one of said sets of at least three identifying attributes; means for using said first specifying means to convert data values received in each of the plurality of second formats into said first format and for storing such data values in said storing means in said first format; second means for specifying by user input to said apparatus a plurality of third formats in which data values stored in said storing means are to be provided for output, each of said third formats associating a plurality of financial data values stored in said first format and associated with a first set of at least three attributes with a plurality of financial data values stored in said first format and associated with a second set of at least three attributes; and means for using said second specifying means to convert data values stored in said storing means to said third format.
Claim 10
Dependent Claim
39 words
The apparatus of claim 7 wherein the identifying attributes are a financial schedule in which the financial information appears, a business entity to which the financial information pertains, and a period of time to which the financial information pertains.
Claim 11
Dependent Claim
18 words
The apparatus of claim 8 wherein the identifying attributes further include a fourth attribute defined by the user.
References Cited (Backward Citations)
US4321672A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1996-02-23 | 1996-08-24 | 1997-02-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2000-02-23 | 2000-08-24 | 2001-02-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2004-02-23 | 2004-08-24 | 2005-02-23 | $7700.00 | Window Closed / Lapsed |