|
Archive@NYU >
Stern School of Business >
IOMS: Information Systems Working Papers >
Please use this identifier to cite or link to this item:
http://hdl.handle.net/2451/14344
|
| Title: | TOWARD A LOGICAL/PHYSICAL THEORY OF SPEADSHEET MODELING |
| Authors: | Isakowitz, Tomas
Schocken, Shimon
Lucas, Henry C. , Jr. |
| Keywords: | Theory
Design
Languages
Model Management |
| Issue Date: | 23-Oct-1992 |
| Publisher: | Stern School of Business, New York University |
| Series/Report no.: | IS-92-28 |
| Abstract: | In spite of the increasing sophistication and power of commercial
spreadsheet packages, we still lack a formal theory of spreadsheets and
a methodology that aids their construction and maintenance. Using a new
functional relational language, this paper identifies four principal
components that characterize any spreadsheet model: Model, Data,
Editorial, and Binding. We present a factoring algorithm for identifying
and extracting these components from conventional spreadsheets
automatically, and a synthesis algorithm that assists users in the
construction of executable spreadsheets from reusable components. This
approach opens new possibilities for applying object oriented and model
management techniques to support the construction, sharing, and reuse,
of spreadsheet models in organizations. |
| URI: | http://hdl.handle.net/2451/14344 |
| Appears in Collections: | IOMS: Information Systems Working Papers
|
All items in Faculty Digital Archive are protected by copyright, with all rights reserved.
|
