US5893123A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method of integrating a spreadsheet and external program having output data calculated automatically in response to input data from the spreadsheet
Assignee: Intellectual Ventures Fund 83 LLC
•
Filing: 1995-06-22
•
Granted: 1999-04-06
•
Expires: 2015-06-22
Abstract
Abstract A system and method integrate a spreadsheet and an externally implemented program. The system includes a set of input cells in the spreadsheet, which contain input data for the external program; a set of transmission functions which reference the input cells; and a set of retrieval functions, which reference the transmission functions. A spreadsheet evaluation sequencer, which is part of the spreadsheet program, schedules execution of the transmission functions whenever input data changes, and schedules execution of the retrieval functions after the transmission functions have been executed, thereby effecting a seamless, two-way link between the spreadsheet and external program.
Inventors
- 👤 Paul W. Tuinenga
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 21:18
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 28
Claim 1
Independent Claim
139 words
A system for integrating a spreadsheet program and an external program comprising: an input cell in said spreadsheet, said input cell containing data used as input by said external program; a transmission function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said transmission function as part of normal spreadsheet operation if said input cell is changed, said transmission function transmitting the data from said input cell to said external program; and a retrieval function containing a reference to said transmission function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said transmission function, said retrieval function as part of normal spreadsheet operation retrieving output data from said external program, said output data calculated by said external program based upon said input data from said spreadsheet.
Claim 2
Independent Claim
139 words
A system for integrating a spreadsheet program and an external program comprising: an input cell in said spreadsheet, said input cell containing data used as input by said external program; a transmission function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said transmission function as part of normal spreadsheet operation if said input cell is changed, said transmission function transmitting the data from said input cell to said external program; and a retrieval function containing a reference to said transmission function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said transmission function, said retrieval function as part of normal spreadsheet operation retrieving output data from said external program, said output data calculated by said external program based upon said input data from said spreadsheet.
Claim 3
Dependent Claim
15 words
The system of claim 1, wherein said transmission function refers indirectly to said input cell.
Claim 4
Dependent Claim
15 words
The system of claim 1, wherein said retrieval function refers indirectly to said transmission function.
Claim 5
Dependent Claim
15 words
The system of claim 1, wherein said transmission function is implemented within said spreadsheet program.
Claim 6
Dependent Claim
21 words
The system of claim 1, wherein said transmission function is contained within a cell in a worksheet within said spreadsheet program.
Claim 7
Dependent Claim
22 words
The system of claim 1, wherein said transmission function is contained within a cell in a hidden worksheet within said spreadsheet program.
Claim 8
Dependent Claim
15 words
The system of claim 1, wherein said retrieval function is implemented within said spreadsheet program.
Claim 9
Dependent Claim
21 words
The system of claim 1, wherein said retrieval function is contained within a cell in a worksheet within said spreadsheet program.
Claim 10
Dependent Claim
23 words
The system of claim 1, wherein said transmission function is called as an Object Linking and Embedding Automation method of said external program.
Claim 11
Dependent Claim
23 words
The system of claim 1, wherein said retrieval function is called as an Object Linking and Embedding Automation method of said external program.
Claim 12
Dependent Claim
12 words
The system of claim 1, wherein said external program is input dependent.
Claim 13
Dependent Claim
15 words
The system of claim 1, wherein said external program is an electrical circuit simulator program.
Claim 14
Dependent Claim
21 words
The system of claim 1, wherein said transmission function also transmits additional information regarding said input cell to said external program.
Claim 15
Dependent Claim
20 words
The system of claim 1, wherein said external program is implemented, in part, as an embeddable document within said spreadsheet.
Claim 16
Independent Claim
129 words
A method for providing spreadsheet-style interface and control for an input dependent external program, comprising the steps of: providing a spreadsheet containing input data for use by said program; making a first function call from said spreadsheet program to said external program, said first function call made automatically by said spreadsheet as part of normal spreadsheet operation, said first function call transmitting said new input data to said external program; and making a second function call from said spreadsheet program to said external program, said second function call automatically occurring after said first function call as part of normal spreadsheet operation, said second function call retrieving output data from said external program, said output data calculated by said external program in response to said input data from said spreadsheet.
Claim 17
Independent Claim
129 words
A method for providing spreadsheet-style interface and control for an input dependent external program, comprising the steps of: providing a spreadsheet containing input data for use by said program; making a first function call from said spreadsheet program to said external program, said first function call made automatically by said spreadsheet as part of normal spreadsheet operation, said first function call transmitting said new input data to said external program; and making a second function call from said spreadsheet program to said external program, said second function call automatically occurring after said first function call as part of normal spreadsheet operation, said second function call retrieving output data from said external program, said output data calculated by said external program in response to said input data from said spreadsheet.
Claim 18
Dependent Claim
22 words
The method of claim 15, wherein said first function call is originated from a cell in a worksheet within said spreadsheet program.
Claim 19
Dependent Claim
22 words
The method of claim 15, wherein said second function call is originated from a cell in a worksheet within said spreadsheet program.
Claim 20
Dependent Claim
25 words
The method of claim 15, wherein said first function call is executed by calling an Object Linking and Embedding Automation method of said external program.
Claim 21
Dependent Claim
25 words
The method of claim 15, wherein said second function call is executed by calling an Object Linking and Embedding Automation method of said external program.
Claim 22
Dependent Claim
12 words
The method of claim 15, wherein said external program is input dependent.
Claim 23
Dependent Claim
20 words
The method of claim 15, wherein said external program is implemented, in part, as an embeddable document within said spreadsheet.
Claim 24
Independent Claim
141 words
A system for integrating a spreadsheet program and an external program, comprising: an input cell in said spreadsheet, said input cell containing data used as input by said external program; a notification function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said notification function as part of normal spreadsheet operation if said input cell is changed, said notification function notifying said external program that the data from said input cell has changed; a retrieval function containing a reference to said notification function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said notification function, said retrieval function retrieving output data from said external program as part of normal spreadsheet operation, said output data computed by said external program in response to said input data from said spreadsheet.
Claim 25
Independent Claim
141 words
A system for integrating a spreadsheet program and an external program, comprising: an input cell in said spreadsheet, said input cell containing data used as input by said external program; a notification function containing a reference to said input cell, such that said spreadsheet automatically schedules evaluation of said notification function as part of normal spreadsheet operation if said input cell is changed, said notification function notifying said external program that the data from said input cell has changed; a retrieval function containing a reference to said notification function, such that said spreadsheet automatically schedules evaluation of said retrieval function to occur after evaluation of said notification function, said retrieval function retrieving output data from said external program as part of normal spreadsheet operation, said output data computed by said external program in response to said input data from said spreadsheet.
Claim 26
Dependent Claim
23 words
The system of claim 22, wherein said notification function is called as an Object Linking and Embedding Automation method of said external program.
Claim 27
Dependent Claim
12 words
The system of claim 22, wherein said external program is input dependent.
Claim 28
Dependent Claim
21 words
The system of claim 22, wherein said notification function also transmits additional information regarding said input cell to said external program.
References Cited (Backward Citations)
US5079695A
Cited
US5339410A
Cited
US5418902A
Cited
US5317686A
Cited
US5381524A
Cited
US5381524B1
Cited
US5381524B2
Cited
WO1993024896A1
Cited
US5610833A
Cited
US5485569A
Cited
US5315703A
Cited
US5303146A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-04-05 | 2002-10-05 | 2003-04-06 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-04-05 | 2006-10-05 | 2007-04-06 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-04-05 | 2010-10-05 | 2011-04-06 | $7700.00 | Window Closed / Lapsed |