Please use this identifier to cite or link to this item:
http://hdl.handle.net/11375/17645
Title: | Structuring problems for analysis with electronic spreadsheets |
Authors: | Archer, Norman P. McMaster University, Faculty of Business |
Department: | None |
Publication Date: | Jan-1987 |
Series/Report no.: | Research and working paper series (McMaster University. Faculty of Business) no. 267 |
Abstract: | This paper discusses a method which uses directed graphs to reveal the underlying structure spreadsheet problems. Advantage is taken of the fact that there is a great deal of similarity among the two main classes of spreadsheet problems: those which are acyclic, and those involving cycles. For acyclic problems, a logical numbering can be assigned to cells, and the cell relationships may be shown in the form of a Cell Relationship Diagram (CRD . For cyclic problems, a pseudo CRD is used in order to break the cycles and derive pseudo-logical numberings for the cells. Cyclic spreadsheets are shown to contain fixed point problems, and three iterative numerical solution techniques (successive substitution, Newton-Raphson, and Gauss-Seidel) are described in terms of implementation and convergence properties, and demonstrated with several examples. |
Description: | 26 p. ; Includes bibliographical references (p. 25-26). ; "January, 1987."; This work was supported by a grant from the Natural Sciences and Engineering Research Council of Canada. |
URI: | http://hdl.handle.net/11375/17645 |
Appears in Collections: | DeGroote School of Business Working Paper Series |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
dsb_wp_267.pdf | 407.81 kB | Adobe PDF | View/Open |
Items in MacSphere are protected by copyright, with all rights reserved, unless otherwise indicated.