A visualization-based approach for improving spreadsheet quality
Spreadsheet programs, artefacts developed by end-user programmers, are used for a variety of important tasks and decisions. However, as the literature indicates, a significant proportion of spreadsheet programs contain faults. One of the contributing factors to the quality issue is the invisibility...
Gespeichert in:
| Veröffentlicht in: | International Conference on Software Engineering 2009 Jg. 2009; H. 1 |
|---|---|
| 1. Verfasser: | |
| Format: | Journal Article |
| Sprache: | Englisch |
| Veröffentlicht: |
03.04.2009
|
| ISBN: | 9781605585659, 1605585653 |
| ISSN: | 0270-5257 |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | Spreadsheet programs, artefacts developed by end-user programmers, are used for a variety of important tasks and decisions. However, as the literature indicates, a significant proportion of spreadsheet programs contain faults. One of the contributing factors to the quality issue is the invisibility of cell dependencies (which define the dataflow structure of a spreadsheet) up on which computations are performed. In an attempt to provide a guide in understanding spreadsheets, this paper presents an approach to visualize a spreadsheet in terms of logical areas using the MCL (Markov Clustering) algorithm. Instead of focusing their attention on the whole spreadsheet, spreadsheet users may narrow their focus to one logical area at a time. To evaluate our approach, a prototype tool has been developed and integrated into Microsoft Excel. |
|---|---|
| Bibliographie: | SourceType-Scholarly Journals-2 ObjectType-Feature-2 ObjectType-Conference Paper-1 content type line 23 SourceType-Conference Papers & Proceedings-1 ObjectType-Article-3 |
| ISBN: | 9781605585659 1605585653 |
| ISSN: | 0270-5257 |
| DOI: | 10.1145/1527033.1527038 |