Faculty Digital Archive

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/14493

Title: SPREADSHEET ANALYSIS AND DESIGN
Authors: Ronen, Boaz
Palley, Michael A.
Lucas, Henry C. , Jr.
Issue Date: Jun-1987
Publisher: Stern School of Business, New York University
Series/Report no.: IS-87-52
Abstract: Spreadsheet programs and microcomputers have revolutionized information processing in organizations. Users have adopted spreadsheets to solve problems and circumvent the long delays encountered in dealing with the traditional information services department. A significant number of serious errors have been reported through the misuse of spreadsheet technology. This paper discusses several different contexts for the development of spreadsheet models and presents structured design techniques for these models. The recommended approach to spreadsheet analysis and design encourages the use of a block structure format for the worksheet and introduces Spreadsheet Flow Diagrams as a systems design tool. The objective of this design approach is to reduce the probability and severity of spreadsheet errors, improve auditability and promote greater longevity for spreadsheet models.
URI: http://hdl.handle.net/2451/14493
Appears in Collections:IOMS: Information Systems Working Papers

Files in This Item:

File Description SizeFormat
IS-87-52.pdf3.71 MBAdobe PDFView/Open

All items in Faculty Digital Archive are protected by copyright, with all rights reserved.

 

The contents of this archive are either in the public domain or subject to copyright. Please consult NYU's "Handbook for Use of Copyrighted Materials" (http://library.nyu.edu/copyright/copyright.html) for information on using material within the Faculty Digital Archive.
Valid XHTML 1.0 | CSS