Computing Reviews
Today's Issue Hot Topics Search Browse Recommended My Account Log In
Review Help
Search
Toward a logical/physical theory of spreadsheet modeling
Isakowitz T., Schocken S., Henry C J. ACM Transactions on Information Systems13 (1):1-37,1995.Type:Article
Date Reviewed: Jun 1 1996

The spreadsheet is one of the most important decision support tools used by businesses. It has the reputation of being powerful, versatile, and user-friendly, so the practice of building a spreadsheet model has not changed. Lest we be complacent, the authors caution us that spreadsheet design errors are prevalent and difficult to detect, especially if one just looks at the spreadsheet’s physical appearance, which can be deceiving. What appears on the spreadsheet may not have anything to do with the logical structure it represents. This should be a scary thought for businesses and the customers they serve.

Since a theory of spreadsheet analysis and design has yet to emerge, the concern of the authors is to provide the first step to endowing the conventional spreadsheet program with the functionality of a formal spreadsheet model management system, thus coming up with a business-wide spreadsheet model management system. They hope that such a system would produce a well-designed, well-documented spreadsheet that can communicate with other models and data resources in the organization, so that one could move data from one platform to another, as in current database management systems, and have the ability to change assumptions and inspect their effect.

The authors try to show that there are three approaches that could be used: top-down, inside-out, and bottom-up. They prefer the bottom-up approach because they believe in using data sets from existing spreadsheets instead of building new models. They consider the interplay of the physical and logical views of spreadsheet models to contain the following elements: schema, data, editorial, and binding. They hope to build relational spreadsheets in which a change in one element will affect another. The user can then build spreadsheet models in his or her favorite spreadsheet program without having to learn a new modeling language.

I enjoyed the challenge of reading this paper. Although at times it has a tendency to be technical, and there are empty tables, the lay reader should be able to follow the logic of what the authors are trying to say. The paper raises issues that I am sure businesses have also considered regarding their use of the spreadsheet as a management tool. The compatibility of spreadsheets used by different people for the same purposes can only be achieved by copying an original, erasing the contents, and then using it. But once the original is changed, the changes are not reflected in the copies, so the possibilities for errors are great. Imagine the time that can be saved by making spreadsheets relational. I commend the authors for their efforts. I am sure that relational spreadsheets will be forthcoming as a result of their seminal work.

Reviewer:  Cecilia G. Manrique Review #: CR119094 (9606-0449)
Bookmark and Share
  Featured Reviewer  
 
Model Development (I.6.5 )
 
 
Decision Support (H.4.2 ... )
 
 
Spreadsheets (H.4.1 ... )
 
 
Spreadsheets (K.8.1 ... )
 
 
Application Packages (K.8.1 )
 
 
Model Validation And Analysis (I.6.4 )
 
  more  
Would you recommend this review?
yes
no
Other reviews under "Model Development": Date
Model-Based Diagnosis or Reasoning from First Principles
Peischl B., Wotawa F. IEEE Intelligent Systems & Their Applications 18(3): 32-37, 2003. Type: Article
Nov 6 2003
Simulation modeling handbook: a practical approach
Chung C., CRC Press, Inc., Boca Raton, FL, 2003.  608, Type: Book (9780849312410)
Nov 26 2003
Dynamics of deterministic and stochastic paired excitatory-inhibitory delayed feedback
Laing C., Longtin A. Neural Computation 15(12): 2779-2822, 2003. Type: Article
Jan 12 2004
more...

E-Mail This Printer-Friendly
Send Your Comments
Contact Us
Reproduction in whole or in part without permission is prohibited.   Copyright 1999-2024 ThinkLoud®
Terms of Use
| Privacy Policy