|Title||A disciplined approach to spreadsheet development|
|Authors||Monojit Ghosal & A. Bruce Caster|
|Series||Volume 40, number 4, October-December, pages 39-44|
A process for developing spreadsheet templates that employ the general approaches of systems analysis and structured computer programming is described.
The process is called the "disciplined approach" to spreadsheet development to distinguish it from the undisciplined ad hoc (just sitting down and writing) approach that has predominated until now. The disciplined approach emphasizes the usability, reliability, understandability, and maintainability of the resulting template.
The basic philosophy of this approach is that a process concerned with building in quality is inherently superior to a process that focuses on catching and eliminating errors. The discipline approach begins with the analysis of the problem structure. The next step is to analyze the control structure. Finally, the developer must decide on a display structure.
The small amount of time invested in learning and employing this approach is more than justified by the results.
|Full version||Not available|
Spreadsheets should be organized into distinct sections, including: