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...
Uloženo v:
| Vydáno v: | International Conference on Software Engineering 2009 Ročník 2009; číslo 1 |
|---|---|
| Hlavní autor: | |
| Médium: | Journal Article |
| Jazyk: | angličtina |
| Vydáno: |
03.04.2009
|
| ISBN: | 9781605585659, 1605585653 |
| ISSN: | 0270-5257 |
| On-line přístup: | Získat plný text |
| Tagy: |
Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
|
| Shrnutí: | 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. |
|---|---|
| Bibliografie: | 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 |