Authors
Ernst Goss, Thomas Dillon, & Jackie Kendrick
Abstract
Electronic spreadsheets for mainframes were developed in the late 1970s; in 1979, VisiCorp Co. introduced VisiCalc for the microcomputer. Lotus 1-2-3 from Lotus Development Corp., the 2nd generation of these tools, became the market leader in the 1980s.
A recent survey has revealed that spreadsheet packages are the most important type of software employed for strategic decision making. The Systems Development Life Cycle (SDLC) provides a basis for managerial control, with the steps defining the segments of the workflow and specifying the documents to be constructed in each phase.
While this approach will not guarantee the integrity of the spreadsheet applications, it will significantly reduce errors and provide the manager with a basis for control.
Sample
Seven steps can be followed in the SDLC process:
- Survey the situation.
- Analyze specific needs and requirements.
- Gather available information.
- Logically design the application on paper.
- Construct the spreadsheet template or model.
- Test the template or model with known output data.
- Implement the spreadsheet.
Publication
1989, The Woman CPA, Volume 51, number 3, July, pages 20-24
Full article
Bittersweet spreadsheets: Application development needs control
