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 | Size | Format | |
---|---|---|---|---|
IS-87-52.pdf | 3.71 MB | Adobe PDF | View/Open |
Items in FDA are protected by copyright, with all rights reserved, unless otherwise indicated.