Testing Homogeneous Spreadsheet Grids with the "What You See Is What You Test" Methodology
IEEE Transactions on Software Engineering
PADL '02 Proceedings of the 4th International Symposium on Practical Aspects of Declarative Languages
Inferring templates from spreadsheets
Proceedings of the 28th international conference on Software engineering
A Type System Based on End-User Vocabulary
VLHCC '07 Proceedings of the IEEE Symposium on Visual Languages and Human-Centric Computing
A critical review of the literature on spreadsheet errors
Decision Support Systems
| Hi-index | 0.00 |
Past research has shown that errors are relatively commonin all types of spreadsheets. As spreadsheets are usedwidely by executives in analyzing financial, budgeting andforecasting problems to support their decision making, itis very important that spreadsheets are accurate. Errorsundetected in spreadsheets may have undesirableconsequences as they may adversely impact the firm'sbottom line as well as the firm 's competitiveness. In thispaper, we investigate the types of errors that occur for asimple domain-free spreadsheet model. We also show thatspreadsheet errors can be difficult to detect during "what"analysis (i.e., when design parameters are changed) whenthe spreadsheets are not properly designed. The resultsshow that most students do not take due care in designingtheir spreadsheets. The study appears to suggest that inteaching spreadsheets, emphasis must be placed on creatinga comprehensible design that enables easy detection oferrors and easy maintenance.