Spreadsheet analysis and design

Subscribe (Full Service)


	Search: The ACM Digital Library The Guide

	Feedback

Spreadsheet analysis and design

Full text

Pdf (860 KB)

Source

Communications of the ACM archive
Volume 32 , Issue 1 (January 1989) table of contents

Pages: 84 - 93

Year of Publication: 1989

ISSN:0001-0782

Authors

Boaz Ronen	Tel Aviv Univ., Tel Aviv, Israel
Michael A Palley	Baruch College, CUNY, New York, NY
Henry C. Lucas, Jr.	New York Univ., New York

Publisher

ACM New York, NY, USA

Bibliometrics

Downloads (6 Weeks): 33, Downloads (12 Months): 123, Citation Count: 23

Additional Information:

abstract references cited by index terms review collaborative colleagues

Tools and Actions:	Request Permissions Review this Article Save this Article to a Binder Display Formats: BibTeX EndNote ACM Ref

DOI Bookmark:	Use this link to bookmark this Article: http://doi.acm.org/10.1145/63238.63244 What is a DOI?

ABSTRACT

Although spreadsheet programs and microcomputers have revolutionized information processing in organizations, a significant number of serious errors have been reported through the misuse of this technology. This article discusses several different contexts for the development of spreadsheet models and presents structured design techniques for these models.

REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

	1	Niv Ahituv , Seev Neumann, Principles of information systems for management (2nd ed.), William C. Brown Publishers, Dubuque, IA, 1986
	2	Gad Ariav , Michael J. Ginzberg, DSS design: a systemic view of decision support, Communications of the ACM, v.28 n.10, p.1045-1052, Oct. 1985 [doi>10.1145/4372.4374]
	3	Berry, T. How to structure spreadsheets. Bus. Softw. (Oct. 1986), 56-58.
	4	Bryan, M. Are your spreadsheets lying to you? Bus. Softw. (Oct. 1986), 59-64.
	5	Tom DeMarco, Structured Analysis and System Specification, Prentice Hall PTR, Upper Saddle River, NJ, 1979
	6	Chris P. Gane , Trish Sarson, Structured Systems Analysis: Tools and Techniques, Prentice Hall Professional Technical Reference, 1979
	7	Grupe, F. Tips for better worksheet documentation. Lotus (Aug. 1985), 68-70.
	8	Grushcow, J. Avoid these common spreadsheet errors. Lotus (July 1985), 59-62.
	9	Geoffrey T. Leblond , Thomas W. Carlton , Douglas Ford. Cobb, Using 1-2-3, Que Corp., Indianapolis, IN, 1985
	10	Henry C. Lucas, Jr., The analysis, design, and implementation of information systems (3rd ed.), McGraw-Hill, Inc., New York, NY, 1985
	11	McGrath, J. PC's can't add--but you can teach them to. Bus. Softw. (Sept. 1986), 58-59.

CITED BY 23

	Trevor J. Smedley , Philip T. Cox , Shannon L. Byrne, Expanding the utility of spreadsheets through the integration of visual programming and user interface objects, Proceedings of the workshop on Advanced visual interfaces, May 27-29, 1996, Gubbio, Italy
	Philip T. Cox , Trevor J. Smedley, Using visual programming to extend the power of spreadsheet, Proceedings of the workshop on Advanced visual interfaces, p.153-161, June 01-04, 1994, Bari, Italy
	Sarat Vemuri , Shankar Sengupta , J. Steve Davis, Data dependency diagrams for spreadsheet applications, Proceedings of the 30th annual Southeast regional conference, April 08-10, 1992, Raleigh, North Carolina
	Tomás Isakowitz , Shimon Schocken , Henry C. Lucas, Jr., Toward a logical/physical theory of spreadsheet modeling, ACM Transactions on Information Systems (TOIS), v.13 n.1, p.1-37, Jan. 1995
	James Reichwein , Gregg Rothermel , Margaret Burnett, Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging, ACM SIGPLAN Notices, v.35 n.1, p.25-38, Jan. 2000
	Charles M. Morrison , Joline Morrison , John Melrose , E. Vance Wilson, A graphical approach for reducing spreadsheet linking errors, Advanced topics in end user computing, Idea Group Publishing, Hershey, PA, 2003
	Tanya J. McGill, A comparison of end user and expert system quality assessments, Advanced topics in end user computing, Idea Group Publishing, Hershey, PA, 2003
	M. Adam Mahmood, Comprehensive bibliography, Advanced topics in end user computing, Idea Group Publishing, Hershey, PA, 2003
	Markus Clermont, Heuristics for the automatic identification of irregularities in spreadsheets, ACM SIGSOFT Software Engineering Notes, v.30 n.4, July 2005
	Dongxi Liu , Zhenjiang Hu , Masato Takeichi, An environment for maintaining computation dependency in XML documents, Proceedings of the 2005 ACM symposium on Document engineering, November 02-04, 2005, Bristol, United Kingdom
	Robin Abraham , Martin Erwig, Type inference for spreadsheets, Proceedings of the 8th ACM SIGPLAN symposium on Principles and practice of declarative programming, July 10-12, 2006, Venice, Italy
	Bala Iyer , G. Shankaranarayanan , Melanie L. Lenard, Model management decision environment: a web service prototype for spreadsheet models, Decision Support Systems, v.40 n.2, p.283-304, August 2005
	Margaret Burnett , Andrei Sheretov , Bing Ren , Gregg Rothermel, Testing Homogeneous Spreadsheet Grids with the "What You See Is What You Test" Methodology, IEEE Transactions on Software Engineering, v.28 n.6, p.576-594, June 2002
	Donald L. Amoroso , Paul H. Cheney, Testing a causal model of end-user application effectiveness, Journal of Management Information Systems, v.8 n.1, p.63-89, June 1991
	Robin Abraham , Martin Erwig, UCheck: A spreadsheet type checker for end users, Journal of Visual Languages and Computing, v.18 n.1, p.71-95, February, 2007
	James Reichwein , Gregg Rothermel , Margaret Burnett, Slicing spreadsheets: an integrated methodology for spreadsheet testing and debugging, Proceedings of the 2nd conference on Conference on Domain-Specific Languages, p.3-3, October 03-05, 1999, Austin, Texas
	Tanya J. McGill , Jane E. Klobas, The role of spreadsheet knowledge in user-developed application success, Decision Support Systems, v.39 n.3, p.355-369, May 2005
	Robin Abraham , Martin Erwig, Inferring templates from spreadsheets, Proceeding of the 28th international conference on Software engineering, May 20-28, 2006, Shanghai, China
	Martin Erwig , Robin Abraham , Steve Kollmansberger , Irene Cooperstein, Gencel: a program generator for correct spreadsheets, Journal of Functional Programming, v.16 n.3, p.293-325, May 2006
	Rommert J. Casimir, Real programmers don't use spreadsheets, ACM SIGPLAN Notices, v.27 n.6, p.10-16, June 1992
	T. McGill , J. Klobas, User developed application success: sources and effects of involvement, Behaviour & Information Technology, v.27 n.5, p.407-422, September 2008
	Stephen G. Powell , Kenneth R. Baker , Barry Lawson, A critical review of the literature on spreadsheet errors, Decision Support Systems, v.46 n.1, p.128-138, December, 2008
	Chris Chambers , Martin Erwig, Automatic detection of dimension errors in spreadsheets, Journal of Visual Languages and Computing, v.20 n.4, p.269-283, August, 2009

INDEX TERMS

Primary Classification:
H. Information Systems
H.4 INFORMATION SYSTEMS APPLICATIONS

General Terms:
Design, Documentation, Management

REVIEW

"Rudolph E. Hirsch : Reviewer"

Spreadsheets are no longer used solely for quick fixes by developers who are also the users. More ambitious applications, often designed by IS professionals for use by IS laypersons, are becoming common, but many of those laypersons are spread more...

Collaborative Colleagues:

Boaz Ronen: colleagues

Michael A Palley: colleagues

Henry C. Lucas, Jr.: colleagues

Adobe Acrobat

QuickTime

Windows Media Player

Real Player