Sciweavers

WCRE
2003
IEEE

Analyzing Large Spreadsheet Programs

13 years 9 months ago
Analyzing Large Spreadsheet Programs
Although the results of spreadsheet programs are the base for very important decisions and are subject to many changes, they are only poorly documented. In this paper we introduce an approach that extents previous work in the area of spreadsheet visualization. It enables the maintainer to decompose large spreadsheets into self contained parts, that are similar to modules in conventional software. Of course there are important differences, as these modules are only recognized during analysis, and users are not forced to build modular spreadsheets. This is very important, as we aim 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 semantic classes, that have been introduced in prior work. The generated abstraction is not build upon the formulacontents of the spreadsheet, but on properties of the data flow graph. Therefore, spreadsheets with irregular formulas can be solely ...
Markus Clermont
Added 05 Jul 2010
Updated 05 Jul 2010
Type Conference
Year 2003
Where WCRE
Authors Markus Clermont
Comments (0)