Toward a Logical/Physical Theory of Spreadsheet Modeling

50 Pages Posted: 15 Oct 2008

See all articles by Tomas Isakowitz

Tomas Isakowitz

affiliation not provided to SSRN

Shimon Schocken

affiliation not provided to SSRN

Henry C. Lucas Jr.

New York University (NYU)

Date Written: July 1993

Abstract

In spite of the increasing sophistication and power of commercial spreadsheetpackages, we still lack a formal theory or a methodology to support the constructionand maintenance of spreadsheet models. Using a dual logical/physicalperspective, we identify four principal components that characterize any spreadsheetmodel: schema, data, editorial, and binding. We present a factoringalgorithm for identifying and extracting these components from conventionalspreadsheets with minimal user intervention, and a synthesis algorithm that assistsusers in the construction of executable spreadsheets from reusable modelcomponents. This approach opens new possibilities for applying object-orientedand model management techniques to support the construction, sharing, andreuse, of spreadsheet models in organizations. Importantly, our approach tomodel management and the Windows-based prototype that we have developedare designed to coexist with, rather than replace, traditional spreadsheet programs.In other words, the users are not required to learn a new modelinglanguage; instead, their logical models and data sets are extracted from theirspreadsheets transparently, as a side-effect of using standard spreadsheet program.

Keywords: Model Management

Suggested Citation

Isakowitz, Tomas and Schocken, Shimon and Lucas Jr., Henry C., Toward a Logical/Physical Theory of Spreadsheet Modeling (July 1993). Information Systems Working Papers Series, Vol. , pp. -, 1993. Available at SSRN: https://ssrn.com/abstract=1284881

Tomas Isakowitz (Contact Author)

affiliation not provided to SSRN

No Address Available

Shimon Schocken

affiliation not provided to SSRN

No Address Available

Henry C. Lucas Jr.

New York University (NYU) ( email )

Bobst Library, E-resource Acquisitions
20 Cooper Square 3rd Floor
New York, NY 10003-711
United States

Register to save articles to
your library

Register

Paper statistics

Downloads
48
Abstract Views
455
PlumX Metrics