Toward a Logical/Physical Theory of Speadsheet Modeling

54 Pages Posted: 23 Oct 2008

See all articles by Tomas Isakowitz

Tomas Isakowitz

affiliation not provided to SSRN

Shimon Schocken

affiliation not provided to SSRN

Date Written: October 1992

Abstract

In spite of the increasing sophistication and power of commercial spreadsheetpackages, we still lack a formal theory of spreadsheets and a methodology thataids their construction and maintenance. Using a new functional relationallanguage, this paper identifies four principal components that characterize anyspreadsheet model: Model, Data, Editorial, and Binding. We present a factoringalgorithm for identifying and extracting these components from conventionalspreadsheets automatically, and a synthesis algorithm that assists users in theconstruction of executable spreadsheets from reusable components. This approachopens new possibilities for applying object oriented and model managementtechniques to support the construction, sharing, and reuse, of spreadsheetmodels in organizations.

Keywords: Theory, Design, Languages, Model Management

Suggested Citation

Isakowitz, Tomas and Schocken, Shimon, Toward a Logical/Physical Theory of Speadsheet Modeling (October 1992). NYU Working Paper No. IS-92-28, Available at SSRN: https://ssrn.com/abstract=1288505

Tomas Isakowitz (Contact Author)

affiliation not provided to SSRN

No Address Available

Shimon Schocken

affiliation not provided to SSRN

No Address Available

Here is the Coronavirus
related research on SSRN

Paper statistics

Downloads
14
Abstract Views
412
PlumX Metrics