Heuristics for the automatic identification of irregularities in spreadsheets
WEUSE I Proceedings of the first workshop on End-user software engineering
An empirical evaluation of a testing and debugging methodology for Excel
Proceedings of the 2006 ACM/IEEE international symposium on Empirical software engineering
The state of the art in end-user software engineering
ACM Computing Surveys (CSUR)
A web-centred approach to end-user software engineering
ACM Transactions on Software Engineering and Methodology (TOSEM) - Testing, debugging, and error handling, formal methods, lifecycle concerns, evolution and maintenance
Hi-index | 0.00 |
Although the results of spreadsheet programs are thebase for very important decisions and are subject to manychanges, they are only poorly documented. In this paperwe introduce an approach that extents previous work in thearea of spreadsheet visualization. It enables the maintainerto decompose large spreadsheets into self contained parts,that are similar to modules in conventional software. Ofcourse there are important differences, as these modules areonly recognized during analysis, and users are not forced tobuild modular spreadsheets. This is very important, as weaim not to change the spreadsheet users. It has turned out,that attempts to change the users are usually doomed to fail.This approach can be considered orthogonal to semanticclasses, that have been introduced in prior work.The generated abstraction is not build upon the formula-contentsof the spreadsheet, but on properties of the dataflow graph. Therefore, spreadsheets with irregular formulascan be solely analyzed with the new approach.On the other hand, large spreadsheets can be decomposedinto data modules at first, that are smaller and easierto understand. Each of the data modules can than beanalyszed with a formula based approach.