Issue No.05 - September/October (2009 vol.26)
Martin Erwig , Oregon State University
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MS.2009.140
Spreadsheets are popular end-user programming tools. Many people use spreadsheet-computed values to make critical decisions, so spreadsheets must be correct. Proven software engineering principles can assist the construction and maintenance of dependable spreadsheets. However, how can we make this practical for end users? One way is to exploit spreadsheets' idiosyncratic structure to translate software engineering concepts such as type checking and debugging to an end-user programming domain. The simplified computational model and the spatial embedding of formulas, which provides rich contextual information, can simplify these concepts, leading to effective tools for end users.
spreadsheets, software engineering, type checking, debugging, spatial analysis
Martin Erwig, "Software Engineering for Spreadsheets", IEEE Software, vol.26, no. 5, pp. 25-30, September/October 2009, doi:10.1109/MS.2009.140