US5033009A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System for generating worksheet files for electronic spreadsheets
Assignee: SPREADSHEET AUTOMATION Corp
•
Filing: 1989-03-03
•
Granted: 1991-07-16
•
Expires: 2009-03-03
Abstract
Abstract A method for automating the production of worksheet files of the type used by electronic spreadsheet programs. The spreadsheet program has an associated filed format specification that defines the format in which the spreadsheet program stores and receives data in a worksheet file. The spreadsheet program is capable of processing the worksheet files to produce an output spreadsheet. The method of the invention comprises receiving pattern data specifying positions for one or more variable data items to appear on the output spreadsheet, receiving variable data specifying the variable data items, and merging the pattern and variable data to produce merge data specifying the variable data items and their positions. The merged data is then output into the worksheet filed in said format, such that the spreadsheet program can then use the worksheet file to produce the output spreadsheet having the variable data items at the specified positions.
Inventors
- 👤 Steven J. Dubnoff
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 22:39
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18; G06F40/174
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
160 words
A method for use on a computer for producing a worksheet file for use by an electronic spreadsheet program, the spreadsheet program having an associated file format specification that defines a format in which the spreadsheet program stores and retrieves data, the spreadsheet program further including means for processing data in said format to produce an output spreadsheet, the method comprising: receiving from computer memory a pattern data file containing pattern data specifying positions for one or more variable data items to appear on the output spreadsheet; receiving from computer memory a variable data file containing variable data specifying the variable data items; merging the pattern and variable data to produce merged data specifying the variable data items and the positions for the variable data items; and outputting the merged data into the worksheet file in said format, whereby the spreadsheet program can use the worksheet file to produce the output spreadsheet having the variable data items at said positions.
Claim 2
Independent Claim
160 words
A method for use on a computer for producing a worksheet file for use by an electronic spreadsheet program, the spreadsheet program having an associated file format specification that defines a format in which the spreadsheet program stores and retrieves data, the spreadsheet program further including means for processing data in said format to produce an output spreadsheet, the method comprising: receiving from computer memory a pattern data file containing pattern data specifying positions for one or more variable data items to appear on the output spreadsheet; receiving from computer memory a variable data file containing variable data specifying the variable data items; merging the pattern and variable data to produce merged data specifying the variable data items and the positions for the variable data items; and outputting the merged data into the worksheet file in said format, whereby the spreadsheet program can use the worksheet file to produce the output spreadsheet having the variable data items at said positions.
Claim 3
Dependent Claim
25 words
The method of claim 1, wherein the received pattern data is in said format, whereby the pattern data can be created by the spreadsheet program.
Claim 4
Dependent Claim
32 words
The method of claim 1, wherein the merging step comprises aggregating a plurality of variable data items to produce an aggregated data item and producing merged data specifying the aggregated data item.
Claim 5
Dependent Claim
33 words
The method of claim 1, wherein the outputting step comprises outputting the merged data into a plurality of worksheet files such that each variable data item is contained in a different worksheet file.
Claim 6
Dependent Claim
44 words
The method of claim 1, wherein the pattern data includes fixed data specifying one or more fixed data items and a position at which each fixed data item is to appear on the output spreadsheet, and wherein the merged data includes said fixed data.
Claim 7
Dependent Claim
52 words
The method of claim 1, wherein the merging step comprises producing merged data specifying a formula, the formula comprising an instruction that will cause the spreadsheet program to determine an evaluated data item based upon one or more variable data items and to include the evaluated data item in the output spreadsheet.
Claim 8
Dependent Claim
43 words
The method of claim 6, wherein the formula is produced such that the number of variable data items that will be used by the spreadsheet program to determine the evaluated data item is a function of the number of variable data items received.
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) | 1994-07-15 | 1995-01-14 | 1995-07-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 1998-07-15 | 1999-01-14 | 1999-07-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2002-07-15 | 2003-01-14 | 2003-07-16 | $7700.00 | Window Closed / Lapsed |